----- Original Message ----
> From: Tom Metro <[email protected]>
> To: Michael Drons <[email protected]>
> Cc: L-mvpmc-users <[email protected]>
> Sent: Sun, December 27, 2009 6:52:38 PM
> Subject: Re: [Mvpmc-users] LiveTV fix for mythtv 0.22
>
> Michael Drons wrote:
> >> Empty set (0.00 sec)
> >
> > Try this query.
> >
> > 1) SELECT * FROM `recordedmarkup` where starttime='2009-12-01 12:00:00'
>
> OK, but wouldn't this be a more specific query to try?
>
> SELECT * FROM recordedmarkup where chanid = 1023 AND
> starttime='2009-11-12T20:01:00' AND type IN (4,
> 5);+--------+---------------------+-------+--------+------+
> | chanid | starttime | mark | offset | type |
> +--------+---------------------+-------+--------+------+
> | 1023 | 2009-11-12 20:01:00 | 12380 | NULL | 4 |
> | 1023 | 2009-11-12 20:01:00 | 51447 | NULL | 4 |
> | 1023 | 2009-11-12 20:01:00 | 64755 | NULL | 4 |
> | 1023 | 2009-11-12 20:01:00 | 83205 | NULL | 4 |
> | 1023 | 2009-11-12 20:01:00 | 17540 | NULL | 5 |
> | 1023 | 2009-11-12 20:01:00 | 57748 | NULL | 5 |
> | 1023 | 2009-11-12 20:01:00 | 72905 | NULL | 5 |
> | 1023 | 2009-11-12 20:01:00 | 90088 | NULL | 5 |
> +--------+---------------------+-------+--------+------+
> 8 rows in set (0.00 sec)
>
>
> > These are the markings of the commercials... 4 is the start and 5 is
> > the end.
>
> Looks like there are matches for that part of the original query.
>
>
> > Next we need the offsets. These are difficult to get. They reside in
> > the recordedseek table, but there are 1000s of records in the table.
> > The easy query would be:
> > SELECT * from recordedseek where chanid='XXX' and starttime='xxxxx'
>
> Lots of rows for that...
>
> mysql> SELECT * from recordedseek where chanid='1023' and
> starttime='2009-11-12T20:01:00';
> +--------+---------------------+------+-----------+------+
> | chanid | starttime | mark | offset | type |
> +--------+---------------------+------+-----------+------+
> | 1023 | 2009-11-12 20:01:00 | 0 | 1064 | 7 |
> | 1023 | 2009-11-12 20:01:00 | 1 | 136260 | 7 |
> | 1023 | 2009-11-12 20:01:00 | 2 | 252444 | 7 |
> [...]
> | 1023 | 2009-11-12 20:01:00 | 3562 | 311293553 | 7 |
> | 1023 | 2009-11-12 20:01:00 | 3563 | 311377716 | 7 |
> | 1023 | 2009-11-12 20:01:00 | 3564 | 311449964 | 7 |
> +--------+---------------------+------+-----------+------+
> 3511 rows in set (0.00 sec)
>
> They all have type=7, which explains why there were no matches in the
> original
> query, due to the "AND s.type = 9" clause.
>
>
> > The third column is the mark field. Subtract
> > 100 from your number, add 100 to the number and run this query:
> >
> > SELECT * from recorededseek where chanid='XXX' and starttime='xxxx' and
> > mark
> < (19608+100) and mark > (19608-100)
>
> You mean grab a mark value from the recordedmarkup table and query
> recordedseek
> for a +/-100 range around that value as a means of limiting the result set?
> Sure, but I think the prior result answered the question.
>
> -Tom
Tom,
Its because of the card is type 7. The actual query in mvpmc does not use a
type 9 clause in the SQL. I think the issue is the byte offsets are different
with these cards verse the type 9 cards.
I believe commskip does not work on the HDHOMERUNS, correct???
Mike
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Mvpmc-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mvpmc-users
mvpmc wiki: http://mvpmc.wikispaces.com/
