[mythtv-users] Remove Commercial Script hacking - How do I zero out the commercial skip list?

[Michael T. Dean]

On 05/14/2007 12:31 AM, Vincent Loschiavo wrote:
> Since I (1) despise commercials and (2) currently have limited disk space on
> my backend/frontend box (in that order), I've been working on removing
> commercials from my recordings.  
>
> So far I've gotten both the myth.org wiki removecommercial shell script as
> well as the perl script from
> http://bentonroberts.com/personal/media-server/code/mythshelljob.  I've had
> to modify both based on the wiki discussion:
> http://www.mythtv.org/wiki/index.php/Talk:Script_-_RemoveCommercials.
>
> The removal process works great and replaces the old file with the
> commercial-less file.  The only problem is that I'd like to keep the
> "auto-skip commercial during playback" feature turned on incase I don't want
> to remove the commercials for whatever reason.  So what happens is the
> commercials are no longer in the file, but the database still has the
> skiplist for the recording in question.  
>
> # mythcommflag --getskiplist -f <filename>
> This returns some values like: 
> Commercial Skip List: 0-2426,11086-15788,27565-32511
>
> I'd like to zero out these values, but I'm mysql phobic.  :)  just kidding.
> I'm not sure where/how to begin locating the correct table/column/etc of the
> database to modify.  Any suggestions?  I'm sure the alternative method used
> at the end of the script below would be a great template though.
>   

mythcommflag --clearcutlist

May be SVN trunk only, though.  Check with mythcommflag --help.

Mike