[mythtv-users] mythburn not using my cutlist properly
Robin Gilks
g8ecj at gilks.org
Fri Apr 7 04:41:02 UTC 2006
> 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
More information about the mythtv-users
mailing list