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
------------------------------------------------------------------------------
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/
