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… 😎
btw: the binary for kernel module file also available at http://namran.net/repository/xlinux
I wish it were so easy… no matter what I do, I get an immediate reboot when launching a custom kernel. No idea why.