[mythtv-users] Documentation for commercial flagging?

[Chris Pinkham]

* On Sat Mar 18, 2006 at 04:34:38PM -0500, Andrew Robinson wrote:
> >Otherwise you'll have to wait till 0.20 or write a script to hit the
> >database and run the SQL code yourself to get the information out of the
> >recordedmarkup table.

> I'd be happy to try a SQL script. Where in the database should I look?

select mark, type
	from recordedmarkup
	where chanid = CHANID
		and starttime = STARTTIME
		and type in (4,5)
	order by mark;

Type 4 is commercial break start, type 5 is commercial break end.
Substitute in your chanid and starttime and you should get what you're
looking for.

--
Chris