[mythtv-users] RE:PPV script, etc.

[Eduardo]

I had this one too...

If you have two video inputs you run into trouble, I have my local cable
in one input and sattelite in the other.

It assumes the ppv channels are 1100-1200 (the leading one is the video
source). In reality for me, they were 2100-2200, it may be 3100, or 4100,
etc depending on the number of sources.

The script needs to be modified in two places:
One line in the delete section (line 176 in my copy):
  my $sqldel = $dbh->prepare( q{
    DELETE FROM program WHERE chanid > 1100 AND chanid < 1200
  });

changed to:
  my $sqldel = $dbh->prepare( q{
    DELETE FROM program WHERE chanid > 2100 AND chanid < 2200
  });
The second spot is on line 276
  $ProgPoint = substr($ProgPoint, 2);
  $ChannelNum = substr($ChannelNum, 3) + 1000;
  $ProgStart = $ProgDate * 86400 + $ProgStart;

Changed to:
  $ProgPoint = substr($ProgPoint, 2);
  $ChannelNum = substr($ChannelNum, 3) + 2000;
  $ProgStart = $ProgDate * 86400 + $ProgStart;
Again the 2000 could be 3000 or 4000 depending on the number of sources.

Happy watching
Ed.

Dennis Hand said:
>>I downloaded the ppv.pl script from Tarek's site, and it appears to work.
>>However, when it finishes, I still have no PPV listings in the channel
>> guide!
>>Has anyone ever experienced this?
>
> Are you getting any errors or messages of any kind when you run this? You
> shouldn't see anything if it runs right. I also think that the script
> might need to be set as executable, I think. By chance when you do the
> ppv.pl 2 and it says it has downloaded go into Mythweb and see if you have
> extra days imported. This script applies an extra 5 or 6 days to your
> normal 8 that xmltv imports. If it does then its working to some degree
> and wmunson might be right about the localhost, 127.0.0.1 setup. As for
> your channel changing, wmunson wrote a nice little channel change script
> that I use and it seems to change faster for me, if you use an older RCA
> or SONY receiver. Search for his posts from a few weeks ago.
>
> Dennis
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>