[mythtv-users] Converting frames to time

Andrew Robinson awrobinson-ml at nc.rr.com
Mon May 8 23:03:07 EDT 2006


My goal here is to create a chapter list for dvdauthor from the frame 
markers from Myth's commercial flagging. Chris Pinkham was kind enough 
to provide me with this query for getting frame markers:

select mark, type
    from recordedmarkup
    where chanid = CHANID
         and starttime = STARTTIME
         and type in (4,5)
    order by mark;

This returns the frame numbers. Is there a straightforward way to 
convert the frame numbers to elapsed time? I've been poking around the 
mythconverg database, but I haven't found anything yet.

Thanks!

Andrew Robinson



More information about the mythtv-users mailing list