[mythtv-users] Fall cable reruns and mythTV

[mons37318 at mypacks.net]

-----Original Message-----
>From: finlay <finlay at moeraki.com>
>Sent: Sep 3, 2008 12:50 PM
>To: Discussion about mythtv <mythtv-users at mythtv.org>
>Subject: Re: [mythtv-users] Fall cable reruns and mythTV
>
>David Linville wrote:
>> On Tue, Sep 2, 2008 at 8:07 PM, <mons37318 at mypacks.net 
>> <mailto: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.
>If you set the "Recording options" to "Record new episodes only" that 
>should only record pilots of new series.

Ta-Dah!
I checked it with the pilot of Hannah Montana which appeared (and I am SO not watching.)

In order to not have to actually watch all this crap ;-) you have to go into one of the upcoming airings and make the schedule inactive.

of course the fun part is when you find one you want - do you record anyway or do you use override settings? 
I tried both, cause apparently the machine doing some major file moving action I forgot about and one (apparently) didn't work and then i tried the other. when the upcoming page finally came up, it was all yellow and apparemtly recording every show on the air (I may be overstating, but it immediately started recording as many show as it had tuners for and the first screenful of upcoming conflicts all started at 2pm today)

or maybe it cause I tried removing the EP001  line?

I'm not sure (as that was the only line I actually understood). but for a while there I feared I'd overwhelmed (and broken) the database (cause I'm fairly sure that at some time in the past, I or the machine has managed to break the database)

so I'll do the further experimentation quite gently. at least the moving of files has finished

Oh, and
Thank you! 

--
Pam from Boston
Happily ever after means the show is really over.
Shonda Rhimes - Entertainment Weekly, May 9, 2008 issue
Scott Bakula News www.bakulanews.com