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… 😎
Hey! Thanks for this! Great walkthrough.
I just downloaded and played with this myself
for the first time, and i enjoy getting directions
for stuff to look at.
Another alternative to the two part USB files:
in the readthisfirst file, there is a list of mirrors
to the ISO worldwide.
Also: i did the wget app download (you might
want to “blank out” the first failed attempt)
Question: where is the “app store” for
Android stuff? is it an app? is it like Cydia
for jailbroke iphones?
I want to walk around in the softs a bit.
thanks!
Foob
Uncle Foobar : ok.. had ‘blank out’ the first failed attempt on the app installation due to typo error of the app url..
App store for Google Android is available at http://www.android.com/market/
however.. it may not available at your mobile due to some TELCO / countries restriction..
please check the local Android user community..
or just go to http://developer.android.com/community/
😎
App Store is not open-sourced, hence not in these kind of builds. You need to have some agreement with google to distribute it on your “phones”.
You can browse what’s available in the market through the following hack http://www.cyrket.com from the same guy who brought you cydia on the iphone.
Having said that … those who have rooted android phones … can probably download an app from the market and “share” it with you …