[mythtv-users] Converting frames to time

Robert Johnston anaerin at gmail.com
Mon May 8 23:07:10 EDT 2006

On 5/8/06, Andrew Robinson <awrobinson-ml at nc.rr.com> wrote:
> 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.

Quick Pseudo-code

IF Picturebase="NTSC" THEN
   Time_In_Seconds = Frames/30
ELSE IF Picturebase="PAL" THEN
   Time_In_Seconds = Frames/25
   // Unknown
Robert "Anaerin" Johnston

More information about the mythtv-users mailing list