[mythtv-users] Removing the skiplist

[Daniel Olson]

I've wondered about this myself.

Both can be removed via mysql calls.
Removing the cutlist:
update recorded set cutlist = "" where title = "Show" and subtitle = "Episode";

The other commercial info appears to be located in the recordedmarkup
table (http://www.mythtv.org/wiki/index.php/Recordedmarkup_table)
  MARK_UPDATED_CUT = -3,
   MARK_EDIT_MODE = -2,
   MARK_CUT_END = 0,
   MARK_CUT_START = 1,
   MARK_BOOKMARK = 2,
   MARK_COMM_START = 4,
   MARK_COMM_END = 5,

My guess (and that's all it is) is that a query like:
delete from recordedmarkup where chanid = 1010 and starttitme =
"2006-08-23 10:00:00" and type > 3 and type < 6;
would remove all the commercial flag marks for a given episode.

I should note that the recordedmarkup table contains indices to
keyframes and when these are pointing to incorrect locations, playback
is erroneous.

One of these days I will look into how to rebuild the keyframes info
in the recordedmarkup table.  But for now I move my transcoded shows
to the video directory and watch them using mplayer.


On 8/25/06, Zach White <zwhite-mythtv at darkstar.frop.org> wrote:
> My question in short: how do I remove the skiplist from a recording without
> using the frontend?
>
> For more details on my situation, keep reading.
>
> I'm running svn revision 10665, and using my script to automatically
> commflag and transcode recordings to remove commercials from the file. This
> is so when I play videos using MythWeb to stream them I don't have to
> FF through the commercials. The script I'm using can be found in the wiki:
>
> http://mythtv.org/wiki/index.php/Script_-_RemoveCommercials
>
> The problem comes in when I play videos through the frontend. It seems that
> if you run mythtranscode outside of mythtv it doesn't remove the skiplist
> or the cutlist after transcoding. I can use mythcommflag --removecutlist
> to remove the cutlist from the recording, but there's not a similar option
> to remove the skiplist.
>
> -Zach
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>