Malaysia TV Program Guide grabber for Mythtv

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..

program-listing
heheh..mouse over the program will tell the program description..

program-listing-mouse-over

click on it to record..
mythtv-record-lah

nice..

thanks to the XML uploader..

p/s: all this stuff only viable after a great journey earlier… 😎

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Like

Related Post

2 Responses

  1. jebat says:

    bro macam mana nak setting utk ipv4 untuk connect ke unifi.

    Reply
  2. wahid110 says:

    Hi,
    well, I ‘m a newbie to ipv6(and many other things).
    I’m a unifi subscriber VIP5.
    I’d like to set up a home network comprising a laptop and a pc, to be able to ping each other and outside world using IPv6.
    At the first step, I want to be able to ping ipv6.google.com
    currenly I’m running ubuntu on my laptop.
    I followed your instruction to register with he.net and got the same script. however I don’t know what you mean by copy& pasting it into “your router box”? can you help me? Thanx

    Reply

Anything to add?

X