Ticket #11139: removecommercials

#!/bin/sh
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/root/bin

VIDEODIR=$1
FILENAME=$2
CHANID=$3
STARTTIME=$4
#exec > /tmp/removeCommercials$CHANID$STARTTIME


echo "$CHANID $STARTTIME $FILENAME $VIDEODIR" 
# Sanity checking, to make sure everything is in order.
if [ -z "$VIDEODIR" -o -z "$FILENAME" ]; then
        echo "Usage: $0 <VideoDirectory> <FileName>" 
        exit 5
fi
if [ ! -f "$VIDEODIR/$FILENAME" ]; then
        echo "File does not exist: $VIDEODIR/$FILENAME"
        exit 6
fi
# The meat of the script. Flag commercials, copy the flagged commercials to
# the cutlist, and transcode the video to remove the commercials from the
# file.
mythcommflag -f $VIDEODIR/$FILENAME  
echo "fin1" 
ERROR=$?
if [ $ERROR -gt 126 ]; then
        echo "Commercial flagging failed for ${FILENAME} with error $ERROR"  
        exit $ERROR 
fi
echo "cutting" 
mythutil --gencutlist --chanid $CHANID --starttime $STARTTIME -f $VIDEODIR/$FILENAME 
ERROR=$?
echo "cut'ed end" 
if [ $ERROR -ne 0 ]; then
        echo "Copying cutlist failed for $FILENAME $CHANID $STARTTIME with error $ERROR" 
        exit $ERROR
fi
echo "transcodin" 
mythtranscode --verbose all --nodblog --loglevel debug --logpath /tmp -p def --honorcutlist --showprogress -i $VIDEODIR/$FILENAME -o $VIDEODIR/$FILENAME.tmp 
ERROR=$?
echo "transcodid end " 
if [ $ERROR -ne 0 ]; then
        echo "Transcoding failed for ${FILENAME} with error $ERROR" 
        exit $ERROR
fi
echo "cleaning up" 
mv $VIDEODIR/$FILENAME $VIDEODIR/$FILENAME.old
mv $VIDEODIR/$FILENAME.tmp $VIDEODIR/$FILENAME
rm $VIDEODIR/$FILENAME.old

mythcommflag -f $VIDEODIR/${FILENAME} --rebuild  
ERROR=$?
if [ $ERROR -ne 0 ]; then
        echo "Rebuilding seek list failed for ${FILENAME} with error $ERROR" 
        exit $ERROR
fi
mythutil --clearcutlist --chanid $CHANID --starttime $STARTTIME 
ERROR=$?
echo "cutlist cleared" 

if [ $ERROR -eq 0 ]; then
echo "cutlist cleared properly" 
        # Fix the database entry for the file
        cat << EOF | mysql mythconverg
UPDATE 
        recorded
SET
        cutlist = 0,
        filesize = $(ls -l $VIDEODIR/$FILENAME | awk '{print $5}') 
WHERE
        basename = '$FILENAME';

EOF


echo "cleared in db" 

cat << EOF | mysql mythconverg

DELETE FROM 
       recordedmarkup
WHERE 
       CONCAT( chanid, starttime ) IN (
               SELECT 
                       CONCAT( chanid, starttime )
               FROM 
                       recorded
               WHERE 
                       basename = '$FILENAME'
      );

EOF
        exit 0
else
        echo "Clearing cutlist failed for ${FILENAME} with error $ERROR"  
        rm -f $VIDEODIR/$FILENAME.tmp
        exit $ERROR
fi