#!/bin/sh

# initalize variables
db='mythconverg'

# substitute the username you want to you use to connect to mySQL
user='root'

# password variable is here, but I haven't used it
password=''

# run SQL
data0=`mysql $db -u $user -e "select count(*) from inuseprograms where recusage like 'player'" -sN`
data1=`mysql $db -u $user -e "select count(*) from inuseprograms where recusage like 'recorder'" -sN`
data2=`mysql $db -u $user -e "select count(*) from record \
        where inactive=0 and (type!=0 or type!=8) and \
        timediff(sysdate(),concat(startdate,' ',starttime))<'00:10:00' and \
        timediff(concat(startdate,' ',starttime),sysdate())<'00:10:00';\
        " -sN`

if [ $data0 -ge 1 -o $data1 -ge 1 -o $data2 -ge 1 ]; then
        echo -e "\033[31m\n         WARNING!!!\033[0m\n"
        if [ $data0 -ge 1 ]; then
                echo "MythTV is watching $data0 program(s)"
        fi
        if [ $data1 -ge 1 ]; then
                echo "MythTV is recording $data1 program(s)"
        fi
        if [ $data2 -ge 1 ]; then
                echo "MythTV has scheduled $data2 program(s) within 10 minutes"
        fi
        echo -e "\nDo you still wish to reboot? (y/n)"
        read ANSW
        case $ANSW in
         y) reboot ;;
         *) exit 0
        esac
else
        echo "Rebooting"
        reboot
fi

exit 0