[mythtv-users] Fall cable reruns and mythTV

Kevin Kuphal kkuphal at gmail.com
Wed Sep 3 16:54:39 UTC 2008


On Wed, Sep 3, 2008 at 11:33 AM, David Linville
<dlinvill at networksdown.com>wrote:

> On Tue, Sep 2, 2008 at 8:07 PM, <mons37318 at mypacks.net> wrote:
>
>>
>> Do we have a way to tell myth to list (but not record, as in the new pilot
>> search) pilot episodes of old series that we a. didn't watch at the time
>> they were new or b. never were aware of to begin with?
>>
>> the *new* pilot search is as follows
>>
>> program.previouslyshown = 0
>> AND program.first > 0
>> AND program.programid LIKE 'EP%0001'
>> AND DAYOFYEAR(program.originalairdate) =
>>    DAYOFYEAR(program.starttime)
>>
>> i'm guessing that the program.previously shown (at least, and possibly
>> something else - my SQL isn't that great) will disinclude Old pilots. at
>> least if it = 0
>>
>
>
> I just tried
>
> program.first > 0
> AND program.programid LIKE 'EP%0001'
> AND DAYOFYEAR(program.originalairdate) <   DAYOFYEAR(program.starttime)
>
> which seems to do exactly what you want but I get 5-6 'old pilots' per day
> so for me  it really would only work as a search and not a record rule.
>

The guide information may not contain the program.programid in the format
you specified.  Try removing that line

Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080903/6a6e7219/attachment.htm 


More information about the mythtv-users mailing list