[mythtv-users] Removecommercials script and commercial flagging problem
mythtv at corwyn.net
mythtv at corwyn.net
Mon Aug 11 20:56:42 UTC 2008
I think this exact problem is described in the wiki page.
http://www.mythtv.org/wiki/index.php/Script_-_RemoveCommercials
If you use this script and have commercial auto-skip set then during
playback you will notice that MythTV skips over parts of your
program. This is because the information about where commercials are
located is still available. Adding this query after the UPDATE and
before the EOF will remove the commercial points and allow things to
run smoothly.
DELETE FROM
`recordedmarkup`
WHERE
CONCAT( chanid, starttime ) IN (
SELECT
CONCAT( chanid, starttime )
FROM
recorded
WHERE
basename = '$FILENAME'
);
At 02:42 PM 8/11/2008, Bobby Gill wrote:
>I have this script running:
><http://www.mythtv.org/wiki/index.php/Talk:Script_-_RemoveCommercials#enhanced_script_uses_channelID_and_starttime_throughout>http://www.mythtv.org/wiki/index.php/Talk:Script_-_RemoveCommercials#enhanced_script_uses_channelID_and_starttime_throughout
>
>with this user job:
>
>removecommercials "%DIR%" "%FILE%" "%CHANID%" "%STARTTIME%"
>
>and it works fine, but I'm having a problem where the recording,
>let's say a 30 minute episode, gets stripped down to ~21 minutes
>with commercials cut (as is the goal, fine so far), but what happens
>is there's still commercials flagged apparently and the episode will
>skip in a few places where it has flagged commercials, but of course
>there are none. Like the first commercial break might be at 9
>minutes into the show, but it's cut so it goes black for a second
>and returns to the second act, and it will skip a few minutes there,
>where it has flagged a commercial. I can't figure this out.
>
>Bob
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
More information about the mythtv-users
mailing list