#!/bin/bash
# Copyright 2006, Kees Cook <kees@outflux.net>
# License: GNU GPL v2
MYTHUSER=mythtv
MYTHHOST=cube

set -e

EDL=`mktemp -t edl-XXXXXX`

MEDIA="$1"
shift
if [ ! -f "$MEDIA" ]; then
    echo "Play what mythtv recording?" >&2
    exit 1
fi

ID=`echo "$MEDIA" | perl -ne 'print "$1 $2" if /(\d+)_(\d+)[^\d]+$/'`;
CHAN=`echo "$ID" | awk '{print $1}'`
CHAN=$(( CHAN + 0 ))
START=`echo "$ID" | awk '{print $2}'`
START=$(( START + 0 ))

ssh "$MYTHUSER"@"$MYTHHOST" "echo 'SELECT mark/29.97 FROM recordedmarkup WHERE chanid = $CHAN AND starttime = $START AND (type = 4 OR type = 5) ORDER BY mark;' | mysql -B --skip-column-names --password=\`grep ^DBPassword= /etc/mythtv/mysql.txt | awk -F= '{print \$2}'\` mythconverg | xargs -l2" 2>/dev/null | awk '{print $0 " 0" }' > "$EDL"

mplayer -fs -vobsub /dev/null -vf filmdint -edl "$EDL" "$MEDIA"

rm -f "$EDL"