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

[Brad DerManouelian]

On May 13, 2007, at 9:31 PM, Vincent Loschiavo wrote:

> Hello All,
>
> 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.
>
> Any suggestions on how I can figure this out?  This would also  
> improve the
> WAF significantly!

I don't know for a fact, but a quick look at my database shows this:

mysql> select * from recordedmarkup order by chanid,starttime;
+--------+---------------------+--------+--------+------+
| chanid | starttime           | mark   | offset | type |
+--------+---------------------+--------+--------+------+
|   1002 | 2007-01-28 20:00:00 |  36902 | NULL   |    4 |
|   1002 | 2007-01-28 20:00:00 |  21332 | NULL   |    4 |
|   1002 | 2007-01-28 20:00:00 |  28161 | NULL   |    5 |
|   1002 | 2007-01-28 20:00:00 |      0 | NULL   |    4 |
|   1002 | 2007-01-28 20:00:00 |   5507 | NULL   |    5 |
|   1002 | 2007-01-28 20:00:00 |  41803 | NULL   |    5 |

So it looks like you'll need to parse the channel id and starttime  
from the filename and then:

mysql> DELETE FROM recordedmarkup WHERE `chanid`='<yourchannelid>'  
AND `starttime`='<yourstarttime>';