[mythtv-users] Auto-transcode to x264 and update MythTV database along the way

[Kris B.]

On Thu, Dec 8, 2011, at 10:54 PM, Kris B. wrote:

> >
> This is not my script, but from the mythtv channel for the roku, it will
> not put it in a .mkv, but does in an mp4, and also does not move it in a
> different directory.. however it will update myth to point at the
> correct file, the commercial skip DOES work, and does delete the
> original file.  I think the only tweak I did is that to rerun for the
> seektable to work in myth.  Just make sure that when you set to run this
> user job that commercial flagging is also selected (done automatically
> for any of my programs)... I also had posted on here my mods that
> actually hard cut the commercials.:
> 
> [krisbee2010 at localhost ~]$ cat /usr/local/bin/mythrokuencode.sh 
> #!/bin/bash
> 
> #convert mpeg file to mp4 using handbrakecli
> MYTHDIR=$1
> MPGFILE=$2
> 
> # Should try and get these from settings.php, but for now...
> DATABASEUSER=mythtv
> DATABASEPASSWORD=mythtv
> 
> LOGFILE="/var/log/mythtv/rokuencode.log"
>  
> newbname=`echo $MPGFILE | sed 's/\(.*\)\..*/\1/'`
> newname="$MYTHDIR/$newbname.mp4"
> 
> echo "Roku Encode $MPGFILE to $newname, details in $LOGFILE" >> $LOGFILE
> 
> date=`date`
> echo "$newbname:$date Encoding" >> $LOGFILE
> #/usr/bin/HandBrakeCLI -i $1/$2 -o $newname -e x264 -b 1500 -E faac -B
> 256 -R 48 -w 720
> #/usr/bin/HandBrakeCLI -i $MYTHDIR/$MPGFILE -o $newname -e x264 -r 29.97
> -b 1500 -E faac -B 256 -R 48 --decomb >> $LOGFILE 2>&1
> #/usr/bin/HandBrakeCLI --preset='iPhone & iPod Touch' -i
> $MYTHDIR/$MPGFILE -o $newname >> $LOGFILE 2>&1
> /usr/bin/HandBrakeCLI --preset='iPhone & iPod Touch' -i
> $MYTHDIR/$MPGFILE -o $newname 
> 
> date=`date`
> echo "$newbname:$date Previews" >> $LOGFILE
> #Mythtv seems to have problems with keyframes in mp4s, so make previews
> with ffmpeg
>    ffmpeg -loglevel quiet -ss 34 -vframes 1 -i $newname -y -f image2 
>    $MYTHDIR/$newbname.mp4.png >> $LOGFILE 2>&1
>    ffmpeg -loglevel quiet -ss 34 -vframes 1 -i $newname -y -f image2 -s
>    100x75 $MYTHDIR/$newbname.mp4.64.100x75.png >> $LOGFILE 2>&1
>    ffmpeg -loglevel quiet -ss 34 -vframes 1 -i $newname -y -f image2 -s
>    320x240 $MYTHDIR/$newbname.mp4.64.320x240.png >> $LOGFILE 2>&1
> #ffmpeg -loglevel quiet -ss 34 -vframes 1 -i $newname -y -f image2 -s
> 100x75 $MYTHDIR/$newbname.jpg >> $LOGFILE 2>&1
> 
> date=`date`
> echo "$newbname:$date Database/remove" >> $LOGFILE
> # remove the orignal mpg and update the db to point to the mp4
> NEWFILESIZE=`du -b "$newname" | cut -f1`
> echo "UPDATE recorded SET
> basename='$newbname.mp4',filesize='$NEWFILESIZE',transcoded='1' WHERE
> basename='$2';" > /tmp/update-database.sql
> mysql --user=$DATABASEUSER --password=$DATABASEPASSWORD mythconverg <
> /tmp/update-database.sql
> rm $MYTHDIR/$MPGFILE
> 
> echo "Updating Seektable so you can fast forward in Myth" >> $LOGFILE
> mythcommflag --rebuild --file $newname
> 
> date=`date`
> echo "$newbname:$date Complete" >> $LOGFILE
> echo "" >> $LOGFILE
> 


That didn't paste so well, so I will send you the script as an
attachment off list as well if you email me.

-- 
  Kris B.
  krisbee at krisbee.com