
mtdean at thirdcontact
Apr 29, 2012, 2:38 PM
Post #5 of 5
(246 views)
Permalink
|
|
Re: Is there a way to pad individual recordings in a recording rule?
[In reply to]
|
|
On 04/29/2012 11:35 AM, David Engel wrote: > On Sun, Apr 29, 2012 at 08:16:15AM -0400, Michael T. Dean wrote: >> On 04/28/2012 11:37 PM, Paul Stillwell wrote: >>> I have a rule set to record college lacrosse on ESPNU any time it is on. The games are scheduled to be 2 hours long, but they often go over by a few minutes. They also schedule them such that they are usually back-to-back. What I would like to do is pad the second recording of the day since the first recording for the day will be caught in the second recording, but I can't find a way to do it. >>> >>> Any ideas? I don't want to go in and hack the database to do this. >>> >> Could use a "Power Recording Rule" using some relatively-advanced >> date functions to check for the last "episode" of the day. > I don't think the query needs to be that complex. The following > (untested) should work. Use "program AS nextprogram" for the join > part and the where part should then be: > > program.title = "Lacrosse" AND nextprogram.chanid = program.chanid AND > nextprogram.starttime = program.endtime AND nextprogram.title<> "Lacrosse" > > Change the<> to = for the nextprogram.title check to match the games > that have another one following. Nice--much prettier than the date functions. Mike _______________________________________________ mythtv-users mailing list mythtv-users [at] mythtv http://www.mythtv.org/mailman/listinfo/mythtv-users
|