[mythtv-users] mythburn not using my cutlist properly

[Robin Gilks]

> I've got mythburn working for the most part, but it totally messes up
> when I've marked up a show with a valid cutlist. Stepping through the
> scripts, it looks like it's trying to pull the cutlist from
> recorded.cutlist, but for the show in question there's only a single
> value in there ("1"). I'm using the SVN version of mythtv (rev 9572). Is
> this the result of a change in the database, or am I misunderstanding
> how this should work?
>
> Daniel

My understanding is that cutlists have moved from the recorded to
recordedmarkup table and are stored in a similar way to bookmarks.

This diff extracts them OK but in the wrong format (one point per line
instead of start/end per line) so it still doesn't work for me yet.
Hopefully it will put someone on the right lines...

Sorry if the mailer mashes the diff up a bit:-(

Index: getmyth.sh
===================================================================
RCS file: /cvsroot/mythburn/mythburn/scripts/getmyth.sh,v
retrieving revision 1.8
diff -u -r1.8 getmyth.sh
--- getmyth.sh  8 Feb 2006 20:39:23 -0000       1.8
+++ getmyth.sh  7 Apr 2006 04:34:33 -0000
@@ -70,6 +70,7 @@
 # extract the details from MYSQL database for this NUV title
 #old statement sqlstatement=" from recorded left join program on
program.chanid=recorded.chanid and program.starttime=recorded.starttime
and program.endtime=recorded.endtime where recorded.chanid=$mchannel and
recorded.starttime=$mstarttime and recorded.endtime=$mendtime;"
 sqlstatement=" from recorded where recorded.chanid=$mchannel and
recorded.starttime=$mstarttime;"
+sqlstatement2=" from recordedmarkup where type IN (0,1) and
recordedmarkup.chanid=$mchannel and recordedmarkup.starttime=$mstarttime;"
 #and recorded.endtime=$mendtime;"

 echo $mnicestarttime >  ${tempdir}/date.txt
@@ -80,7 +81,8 @@
 checkreturnvalue
 mysql -h "$mysqlhost" -u "$mysqluser" $pwd "$mysqldatabase" -s -B --exec
"select IFNULL(recorded.description,'') $sqlstatement" >
${tempdir}/description1.txt
 checkreturnvalue
-mysql -h "$mysqlhost" -u "$mysqluser" $pwd "$mysqldatabase" -s -B --exec
"select IFNULL(recorded.cutlist,'') $sqlstatement" >
${tempdir}/cutlist.txt
+mysql -h "$mysqlhost" -u "$mysqluser" $pwd "$mysqldatabase" -s -B --exec
"select IFNULL(recordedmarkup.mark,'') $sqlstatement2" >
${tempdir}/cutlist.txt
+#mysql -h "$mysqlhost" -u "$mysqluser" $pwd "$mysqldatabase" -s -B --exec
"select IFNULL(recorded.cutlist,'') $sqlstatement" >
${tempdir}/cutlist.txt
 checkreturnvalue
 mysql -h "$mysqlhost" -u "$mysqluser" $pwd "$mysqldatabase" -s -B --exec
"select IFNULL(recorded.category,'') $sqlstatement" >
${tempdir}/category.txt
 checkreturnvalue


-- 
Robin Gilks