[mythtvnz] Use different tuner for adjacent recordings

[Tony Sauri]

On Tue, 20 Apr 2010 21:35, Aaron Whitehouse wrote:
>
> To save me manually going through and changing each Recording Rule, can
> anybody think of an SQL statement that would replace all "Begin this
> recording on time" and "End this recording on time" with 2 minutes and 5
> minutes respectively?
>
 UPDATE record set startoffset = 5 , endoffset = 5 where recordid != 0;

	should do all you want.

I would recommend the installation of phpmyadmin on your backend to allow you 
to interactively inspect and modify your database if you don't know SQL very 
well.

Tony

> Thanks in advance!
>
> Aaron
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/