cat /usr/bin/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"
mythcommflag --gencutlist -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 --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
mythcommflag --clearcutlist -f $VIDEODIR/$FILENAME


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