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/
