Mike,
The commskip functions were never written for a DVB-T card type. There
were written for an IVTV card type. The entries in the DB are very different
based on the card type that did the recording. What needs to happen is the
code needs to understand the difference between the different cards. I can
take a look at it when I get some time, but it will be a while, as I just
upgraded my mythtv server to trunk and have a lot of things not working.
I beleive it just needs to follow something similair as the bookmark code. Can
you confirm that bookmarks work for the recording?
Mike
----- Original Message ----
From: Mike Holden <[email protected]>
To: [email protected]
Sent: Friday, January 16, 2009 2:17:14 PM
Subject: [Mvpmc-users] Mythtv Commercial skipping. UK DVB-T
I'm not getting any commercial flags returned by mvpmc when I know that
the program has several valid commercial breaks flagged, as can be seen in
normal skipping using a myth client instead of mvpmc. I can also see a
valid break list using:
$ mythcommflag --getskiplist -c 4029 -s 2009-01-15T07:38:00 -v database
2009-01-16 18:49:50.527 Using runtime prefix = /usr
2009-01-16 18:49:50.528 Empty LocalHostName.
2009-01-16 18:49:50.534 New DB connection, total: 1
2009-01-16 18:49:50.538 Closing DB connection named 'DBManager0'
2009-01-16 18:49:50.538 Clearing Settings Cache.
2009-01-16 18:49:50.538 Enabling Settings Cache.
2009-01-16 18:49:50.538 Clearing Settings Cache.
2009-01-16 18:49:50.540 MSqlQuery: SELECT
recorded.chanid,starttime,endtime,title,
subtitle,description,channel.channum,
channel.callsign,channel.name,channel.commmethod,
channel.outputfilters,seriesid,programid,filesize,
lastmodified,stars,previouslyshown,originalairdate,
hostname,recordid,transcoder,playgroup,
recorded.recpriority,progstart,progend,basename,recgroup, storagegroup
FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE
recorded.chanid = '4029' AND starttime = '2009-01-15T07:38:00' ;
2009-01-16 18:49:50.540 New DB connection, total: 2
2009-01-16 18:49:50.541 MSqlQuery: SELECT commflagged, cutlist,
autoexpire, editing, bookmark, watched, preserve FROM recorded LEFT JOIN
recordedprogram ON (recorded.chanid = recordedprogram.chanid AND
recorded.progstart = recordedprogram.starttime) WHERE recorded.chanid =
'4029' AND recorded.starttime = '2009-01-15T07:38:00' ;
2009-01-16 18:49:50.542 MSqlQuery: SELECT audioprop+0, videoprop+0,
subtitletypes+0 FROM recorded LEFT JOIN recordedprogram ON
(recorded.chanid = recordedprogram.chanid AND recorded.progstart =
recordedprogram.starttime) WHERE recorded.chanid = '4029' AND
recorded.starttime = '2009-01-15T07:38:00' ;
2009-01-16 18:49:50.542 MSqlQuery: SELECT mark, type FROM recordedmarkup
WHERE chanid = '4029' AND starttime = '2009-01-15T07:38:00' AND type = 4
ORDER BYmark;
2009-01-16 18:49:50.542 MSqlQuery: SELECT mark, type FROM recordedmarkup
WHERE chanid = '4029' AND starttime = '2009-01-15T07:38:00' AND type = 5
ORDER BYmark;
Commercial Skip List: 0-4865,21935-28011,58893-64960,80080-87678
There's an old thread at
http://www.nabble.com/Mythtv-commercial-skipping-tt20333293s24862.html#a20333293
which tries to discuss this issue, and it would appear it was resolved for
that user, but I have a current build and it doesn't work.
Could somebody who is familiar with the code in
cmyth_mysql_get_commbreak_list please explain the thinking behind the
mysql query used there, especially around the FLOOR and /15 stuff? I
presume it's trying tp map recordedmarkup records for type 4 and type 5
records (commstart and commend) with the nearest recordedseek records?
This is certainly not working for me, as mvpmc always reports zero
commflag records found for programs.
If I knew where the code was trying to head, maybe I could refine it into
something that always works?
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Mvpmc-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mvpmc-users
mvpmc wiki: http://mvpmc.wikispaces.com/
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Mvpmc-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mvpmc-users
mvpmc wiki: http://mvpmc.wikispaces.com/
