[mythtv-users] how do I look at the cutlist in the db

ray cielencki mythtv at rayslinky.com
Fri Sep 19 13:43:34 EDT 2003


oh yeah, and it might be helpful to know the highest mark in the 
db... following previous examples:
select * from recordedmarkup where starttime=20030908230000 order by 
mark desc limit 1;

/rr

>for the all the cutlists in the db:
>select title,subtitle,cutlist from recorded;
>
>or if you know the starttime, you could just:
>select cutlist from recorded where starttime=20030908230000;
>
>for the commercial prediction flags (pre-editing - ie: if you have 
>commercial flagging enabled, but not set to autoskip), search:
>select * from recordedmarkup where (type=4 or type=5) and 
>starttime=20030908230000;
>
>this will give you 'mark's where commercials are predicted to begin 
>(4) and end (5).
>
>enjoy,
>rr


More information about the mythtv-users mailing list