[mythtv-users] Delay start time on just one channel?

[Brad DerManouelian]

On Feb 7, 2008, at 1:11 PM, Brad DerManouelian wrote:

> On Feb 7, 2008, at 1:02 PM, R. G. Newbury wrote:
>
>> This would do the trick: substitute for the proper chanid.
>>
>> mysql> update record set endtime = (endtime + 02) where chanid =  
>> 1037;
>>
>>
>> But don't run it more than once unless you don't care if you record 4
>> minutes or 6 or whatever.
>> If you don't care about that, and normally do not set your recording
>> schedule more than say 2 days in advance, then you could do this in a
>> cron script...
>
> To avoid that you could just update where endtime ends with 00 or 30.
> This is assuming your channel only starts programs on the hour or half
> hour. Then you can run it as often as you like.

Sorry I should have just posted it in case anyone in the future wants  
to do this:

mysql> update record set endtime = (endtime + 02) where chanid = 1037  
AND ( endtime LIKE '%30:00' or endtime LIKE '%00:00'  );

You'd also have to modify the starttime if you really want everything  
to strart and end 2 minutes later.
Again, don't blame me if your database blows up and your house catches  
on fire destroying the whole neighborhood. Use at your own risk and  
all that. ;)