[mythtv] DirecTV PPV EPG solution

[Isaac Richards]

On Friday 15 November 2002 07:01 am, tarek Lubani wrote:
> Hey guys..
>
> Well, I have lost a bit of sleep over this, but now (mercifully), it is
> done..
>
>
> The script no longer generates an XML (though the code is in there and
> commented out).. instead, the script now puts the PPV movies directly into
> the database using some SQL stuffs.. It seemed inefficient, to say the
> least, to have this script outputting something and then waiting for
> another script to output something..
>
> In any case, this solution is *suboptimal*, as I've heard it described..
> This is a hack that runs on top of myth's usual programs. Also, I am a
> hack, and don't actually know how to program in perl or any other language.
> All of this contributes to the suboptimalness.. It will do the following;
>
> 1) Look up the PPV listings
> 2) format them as necessary
> 3) open a connection to mythconverg@127.0.0.1 with username/pass of
> (mythtv) 4) **DELETE** all listings with ChanID > 1100 and < 1200
> 5) Enter all the PPV information
>
> the location of the script is at:
>
> http://tarek.2y.net/mythtv/ppv.pl

I get a 404 when trying to grab the script.  

But anyway, this's probably the easiest way to do it, if you made it parse 
mysql.txt for the database settings..  As long as it dumps the data into the 
database properly, there's really no reason to go through the whole 
filldatabase script.

Isaac