Fwd: Re: [mythtv-users] tv_grab_dvb

[Mark]

With a big thanks to the author, Mark Bryars, the latest version of the dvb
grabber is now available - and it's capable of parsing 8 day info :-

http://www.darkskiez.co.uk/dvbepg.html

I've tested it a couple of times today and it seems to be working well:-

 -  full 8 day 'download' takes 3-5minutes.
 - for some reason ITV2 listings are only a couple of days and Channel 5 and
ITV1 do not extend the full week - hopefully this will be fixed when the
trial is complete.
 - Categorisation is there on roughly half the channels but unfortunately
episode information, if given, is included in the description.
- Mux A (Channel 5 etc) is still only showing now/next info.

The grabber output uses the channel's serviceid to build the xmltvid, so
you'll need to update your xmltvids in the channel table for it to work 'out
of the box' - I used the php script below (backup your channel info/database
first!).

Thanks again to Mark for his work on this - makes grabbing listings so much
easier...

Regards

Mark

<?php

$server = "localhost";
$database = "mythconverg";
$user = "mythtv";
$password = "mythtv";

$open = mysql_connect($server, $user, $password);
print "Connecting to server...\n".mysql_error();
if (!$open) {
        print "Couldn't connect to server.\n";
        exit;
}

$database_connect = mysql_select_db ($database, $open);
print "Connecting to database...\n".mysql_error();
if (!$database_connect) {
        print "Couldn't connect to database.\n";
        exit;
}

$query = "select * from dvb_channel";
$query = mysql_db_query($database, $query);
print mysql_error();
$rows = mysql_num_rows($query);

for ($i=0; $i<$rows; $i++) {
        $row = mysql_fetch_array($query);
        $update = "update channel set
xmltvid='".$row['serviceid'].".dvb.guide' where chanid
=".$row['chanid'];
        mysql_db_query($database, $update);
        print "Updated ".$row['chanid']."\n";
}

print "Finished. (".($rows)." channels updated)\n\n";
?>