----- Original Message ----
> From: Tom Metro <[email protected]>
> To: Michael Drons <[email protected]>
> Cc: L-mvpmc-users <[email protected]>
> Sent: Thu, December 24, 2009 1:27:54 AM
> Subject: Re: [Mvpmc-users] LiveTV fix for mythtv 0.22
>
> Michael Drons wrote:
> > Can you everyone send me details from the DB?
> >
> > SELECT * FROM `capturecard`
>
> +--------+-------------+-------------+-----------+-----------+--------------+----------------+----------+--------------+--------------+-----------------------+-------------+---------------+-----------------+---------------+---------------+----------------+----------------+---------------------+------------+----------------+------------+----------------+-----------------+------------------+----------+------------+--------+-----+----------+-------------+
> | cardid | videodevice | audiodevice | vbidevice | cardtype | defaultinput |
> audioratelimit | hostname | dvb_swfilter | dvb_sat_type |
> dvb_wait_for_seqstart
> | skipbtaudio | dvb_on_demand | dvb_diseqc_type | firewire_port |
> firewire_node
> | firewire_speed | firewire_model | firewire_connection | dbox2_port |
> dbox2_httpport | dbox2_host | signal_timeout | channel_timeout |
> dvb_tuning_delay | contrast | brightness | colour | hue | diseqcid |
> dvb_eitscan
> |
> +--------+-------------+-------------+-----------+-----------+--------------+----------------+----------+--------------+--------------+-----------------------+-------------+---------------+-----------------+---------------+---------------+----------------+----------------+---------------------+------------+----------------+------------+----------------+-----------------+------------------+----------+------------+--------+-----+----------+-------------+
> | 1 | /dev/video0 | /dev/dsp | /dev/vbi0 | MPEG | Tuner 1 |
>
> 0 | mythtv | 0 | 0 | 1 |
>
> 0 | 0 | NULL | 0 | 2 |
> 0 |
> NULL | 0 | 31338 | 80 | NULL |
>
> 1000 | 3000 | 0 | 0 | 0 | 0 |
> 0
> | NULL | 1 |
> | 2 | /dev/video1 | NULL | NULL | MPEG | Tuner 1 |
>
> NULL | mythtv | 0 | 0 | 1 |
>
> 0 | 0 | NULL | 0 | 2 |
> 0 |
> NULL | 0 | 31338 | 80 | NULL |
>
> 1000 | 3000 | 0 | 0 | 0 | 0 |
> 0
> | NULL | 1 |
> | 5 | /dev/video2 | /dev/dsp | /dev/vbi2 | V4L | Television |
>
> 0 | mythtv | 0 | 0 | 1
> |
> 0 | 0 | NULL | 0 | 2
> |
> 0 | NULL | 0 | 31338 | 80
> |
> NULL | 1000 | 3000 | 0 | 0 |
> 0
> | 0 | 0 | NULL | 1 |
> | 6 | 1014229B | NULL | NULL | HDHOMERUN | MPEG2TS |
>
> NULL | mythtv | 0 | 0 | 1 |
>
> 0 | 0 | NULL | 0 | 2 |
> 0 |
> NULL | 0 | 0 | 80 | NULL |
>
> 1000 | 3000 | 0 | 0 | 0 | 0 |
> 0
> | NULL | 1 |
> | 7 | 1014229B | NULL | NULL | HDHOMERUN | MPEG2TS |
>
> NULL | mythtv | 0 | 0 | 1 |
>
> 0 | 0 | NULL | 0 | 2 |
> 0 |
> NULL | 0 | 1 | 80 | NULL |
>
> 1000 | 3000 | 0 | 0 | 0 | 0 |
> 0
> | NULL | 1 |
> +--------+-------------+-------------+-----------+-----------+--------------+----------------+----------+--------------+--------------+-----------------------+-------------+---------------+-----------------+---------------+---------------+----------------+----------------+---------------------+------------+----------------+------------+----------------+-----------------+------------------+----------+------------+--------+-----+----------+-------------+
>
>
> > I would also be interested if the sql query produces rows from the
> > DB. Can you run this query for a recording that was made by
> > anything tuner that is not a PVR-500, PVR-150, PVR-350
> >
> > SELECT m.type AS type, m.mark AS mark, s.offset AS offset,
> > s.type AS stype FROM recordedmarkup AS m INNER JOIN recordedseek AS
> > s ON
> > (m.chanid = s.chanid AND m.starttime = s.starttime AND
> > FLOOR((8+m.mark) / 15) =
> > FLOOR((8+s.mark) / 15) ) WHERE m.chanid = ? AND m.starttime = ? AND
> > m.type IN
> > (4, 5) AND s.type = 9 ORDER BY mark;
>
> Empty set (0.00 sec)
>
> I'm pretty sure I have the chanid and starttime correct, as:
>
> > select title, subtitle from recorded where chanid = 1023 AND starttime =
> '2009-11-12T20:01:00';
> +--------------+---------------------------+
> | title | subtitle |
> +--------------+---------------------------+
> | FlashForward | Playing Cards With Coyote |
> +--------------+---------------------------+
>
> Comskip never seems to work with shows that were recorded on this analog
> tuner
> (cardid=5). I thought it was a result of the transcoding, but apparently not.
>
> -Tom
Tom,
Try this query. Change the starttime to a starttime of a recording on
your backend, you can look in the recorded table if you need a sample.
1) SELECT * FROM `recordedmarkup` where starttime='2009-12-01 12:00:00'
These are the markings of the commercials... 4 is the start and 5 is the end.
Send this to me please.
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'
REPLACE starttime and chanid from the recording details.
>From the first query (1) you should see a record similar to this. The actual
>numbers will be different
chanid starttime mark
3044 2009-12-01 12:00:00 19608 4 NULL
The
third column is the mark field (19608 in the example). 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)
Thanks, 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/
