{"id":114,"date":"2006-08-02T20:47:24","date_gmt":"2006-08-03T04:47:24","guid":{"rendered":"http:\/\/outflux.net\/blog\/archives\/2006\/08\/02\/mythtv-cutlist-to-mplayer-edl-file\/"},"modified":"2006-08-02T21:08:20","modified_gmt":"2006-08-03T05:08:20","slug":"mythtv-cutlist-to-mplayer-edl-file","status":"publish","type":"post","link":"https:\/\/outflux.net\/blog\/archives\/2006\/08\/02\/mythtv-cutlist-to-mplayer-edl-file\/","title":{"rendered":"mythtv cutlist to mplayer EDL file"},"content":{"rendered":"

I was too lazy to walk over to my TV, so I decided to watch my MythTV<\/a> recordings on my desktop without having installed a MythTV frontend. Via the magic of MythTVfs<\/a>, I started watching a recent Stargate episode<\/a>.<\/p>\n

Before the opening credits had finished, I knew I was already going to miss MythTV’s commercial flagging. So started the investigation into where in the world MythTV stores that information. I was imagining adding “.edl” files to MythTVfs automatically, etc.<\/p>\n

In MythTV 0.19, using “mythcommflag”, you can get the “Cut” list, but not the “Commercial Skip” list. (Think of the latter as a “Cut Hint” list.) The command for this is:<\/p>\n

mythcommflag –getcutlist -c 1059 -s 20060728210000<\/p><\/blockquote>\n

In MythTV 0.20, you’ll be able to use “–getskiplist”. Since I’m still using 0.19, I had to go directly to the “mythconverg” database to get the details. The marks are stored in the “recordedmarkup” table. The mark types<\/a> I care about are: 4: Commercial Start, 5: Commercial End. This SQL query gets me somewhere:<\/p>\n

SELECT mark, type FROM recordedmarkup WHERE chanid = “1059” AND starttime = “20060728210000” AND (type = 4 OR type = 5) ORDER BY mark;<\/p><\/blockquote>\n

However, mplayer’s EDL<\/a> file format expects time, not frame number. MythTV stores frame number. Luck for us, it’s all NTSC MPEG2, so we’re at 29.97 frame per second, and I can modify the SQL:<\/p>\n

SELECT mark\/29.97<\/strong>, type FROM recordedmarkup WHERE chanid = “1059” AND starttime = “20060728210000” AND (type = 4 OR type = 5) ORDER BY mark;<\/p><\/blockquote>\n

Now I just have to get the pairs on a single line with a trailing “0” for mplayer to know to skip that time frame:<\/p>\n

echo ‘SELECT mark\/29.97 FROM recordedmarkup WHERE chanid = “1059” AND starttime = “20060728210000” AND (type = 4 OR type = 5) ORDER BY mark;’ | mysql -B –skip-column-names | xargs -l2 | awk ‘{print $0 ” 0″ }’<\/p><\/blockquote>\n

Combined with some logic to extract the channel and starttime for a given recording, I’ve now got a really crazy wrapper script<\/a> that’ll let me mplayer a recording after generating an EDL cutlist.<\/p>\n

(With thanks to Ken’s excellent collection<\/a> of “merge pairs of lines into single lines” short cuts.)<\/p>\n

© 2006, Kees Cook<\/a>. This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 License<\/a>.
\"CC<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"

I was too lazy to walk over to my TV, so I decided to watch my MythTV recordings on my desktop without having installed a MythTV frontend. Via the magic of MythTVfs, I started watching a recent Stargate episode. Before the opening credits had finished, I knew I was already going to miss MythTV’s commercial […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/outflux.net\/blog\/wp-json\/wp\/v2\/posts\/114"}],"collection":[{"href":"https:\/\/outflux.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/outflux.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/outflux.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/outflux.net\/blog\/wp-json\/wp\/v2\/comments?post=114"}],"version-history":[{"count":0,"href":"https:\/\/outflux.net\/blog\/wp-json\/wp\/v2\/posts\/114\/revisions"}],"wp:attachment":[{"href":"https:\/\/outflux.net\/blog\/wp-json\/wp\/v2\/media?parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/outflux.net\/blog\/wp-json\/wp\/v2\/categories?post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/outflux.net\/blog\/wp-json\/wp\/v2\/tags?post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}