First of all have to determine the sourceid from.. the MySQL.. and make it look like this one..
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3905
Server version: 5.0.45 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mythconverg;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select sourceid,name,xmltvid from channel;
+----------+------+-----------------------+
| sourceid | name | xmltvid |
+----------+------+-----------------------+
| 2 | TV1 | M038-101.astro.com.my |
| 2 | TV3 | M046-103.astro.com.my |
| 2 | NTV7 | M036-107.astro.com.my |
| 2 | 8TV | M057-708.astro.com.my |
| 2 | | |
| 2 | TV9 | |
+----------+------+-----------------------+
6 rows in set (0.00 sec)
and this the bash file that i use to run it daily..
#!/bin/sh
#DATE=`date '+%d/%B/%y'
DATE=`date '+%Y%m%d'`
TOMORROW=`date -d1day '+%Y%m%d'`
cd /home/mythtv/mythguide/update
# TV1
wget http://mythastro.hostrator.com/M038-101.astro.com.my_$DATE.xml --output-document M038-101.astro.com.my_$DATE.xml
sed s/-0800/+0800/g M038-101.astro.com.my_$DATE.xml > M038-101.astro.com.my1_$DATE.xml
mythfilldatabase --update --refresh-all --file 2 M038-101.astro.com.my1_$DATE.xml
wget http://mythastro.hostrator.com/M038-101.astro.com.my_$TOMORROW.xml --output-document M038-101.astro.com.my_$TOMORROW.xml
sed s/-0800/+0800/g M038-101.astro.com.my_$TOMORROW.xml > M038-101.astro.com.my1_$TOMORROW.xml
mythfilldatabase --update --refresh-all --file 2 M038-101.astro.com.my1_$TOMORROW.xml
# TV3
wget http://mythastro.hostrator.com/M046-103.astro.com.my_$DATE.xml --output-document M046-103.astro.com.my_$DATE.xml
sed s/-0800/+0800/g M046-103.astro.com.my_$DATE.xml > M046-103.astro.com.my1_$DATE.xml
mythfilldatabase --update --refresh-all --file 2 M046-103.astro.com.my1_$DATE.xml
wget http://mythastro.hostrator.com/M046-103.astro.com.my_$TOMORROW.xml --output-document M046-103.astro.com.my_$TOMORROW.xml
sed s/-0800/+0800/g M046-103.astro.com.my_$TOMORROW.xml > M046-103.astro.com.my1_$TOMORROW.xml
mythfilldatabase --update --refresh-all --file 2 M046-103.astro.com.my1_$TOMORROW.xml
# NTV7
wget http://mythastro.hostrator.com/M036-107.astro.com.my_$DATE.xml --output-document M036-107.astro.com.my_$DATE.xml
sed s/-0800/+0800/g M036-107.astro.com.my_$DATE.xml > M036-107.astro.com.my1_$DATE.xml
mythfilldatabase --update --refresh-all --file 2 M036-107.astro.com.my1_$DATE.xml
wget http://mythastro.hostrator.com/M036-107.astro.com.my_$TOMORROW.xml --output-document M036-107.astro.com.my_$TOMORROW.xml
sed s/-0800/+0800/g M036-107.astro.com.my_$TOMORROW.xml > M036-107.astro.com.my1_$TOMORROW.xml
mythfilldatabase --update --refresh-all --file 2 M036-107.astro.com.my1_$TOMORROW.xml
# 8TV
wget http://mythastro.hostrator.com/M057-708.astro.com.my_$DATE.xml --output-document M057-708.astro.com.my_$DATE.xml
sed s/-0800/+0800/g M057-708.astro.com.my_$DATE.xml > M036-107.astro.com.my1_$TOMORROW.xml
mythfilldatabase --update --refresh-all --file 2 M057-708.astro.com.my1_$DATE.xml
wget http://mythastro.hostrator.com/M057-708.astro.com.my_$TOMORROW.xml --output-document M057-708.astro.com.my_$TOMORROW.xml
sed s/-0800/+0800/g M057-708.astro.com.my_$TOMORROW.xml > M057-708.astro.com.my1_$TOMORROW.xml
mythfilldatabase --update --refresh-all --file 2 M057-708.astro.com.my1_$TOMORROW.xml
-bash-3.2$ crontab -l
* 5 * * * /home/mythtv/bin/mythguide-update2.sh > /dev/null
it might be buggy at the moment..
but at least..I got something like this..
heheh..mouse over the program will tell the program description..
nice..
thanks to the XML uploader..
p/s: all this stuff only viable after a great journey earlier… 8-)
Leave a Comment