#!/bin/sh

# initalize variables
db='mythconverg'
user='root'
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
                                inner join recordmatch on record.recordid=recordmatch.recordid
                                where timediff(recordmatch.starttime,sysdate())<'00:10:00' and
                                recordmatch.starttime > sysdate() and
                                inactive=0 and (type!=0 or type!=8);" -sN`

# Spit out warnings, if any and execute base on sql results
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

data2=`mysql $db -u $user -e "select count(*) from record,recordmatch where \
        record.recordid=recordmatch.recordid and \
        record.chanid=recordmatch.chanid and \
        inactive=0 and (type!=0 or type!=8) and \
        timediff(recordmatch.starttime,now()) < '00:30:00' and \
        recordmatch.starttime > now();" -sN`

data1=`mysql $db -u $user -e "select count(*) from record \
        left join recordmatch on \
        record.recordid=recordmatch.recordid and \
        record.chanid=recordmatch.chanid where \
        isNULL(recordmatch.recordid);" -sN`

#!/bin/sh
# --------------------------------------------------------------------
# Very simple script to execute mythfilldatabase only if there are no
# scheduled recordings currently being recorded.

# Written by:   Neil Loknath
# Date:         May 22 2007
#---------------------------------------------------------------------

# initalize variables
script='MFDB:'
db='mythconverg'
date=`date`
msgp="$date $script"

# 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=''

#command to execute mythfilldatabase
mfdb='mythfilldatabase --quiet'


# run SQL
rec=`mysql $db -u $user -e "select count(*) from recorded where \
        timediff(now(),endtime)<'00:00:00' and \
        recgroup!='LiveTV';" -sN`

sched=`mysql $db -u $user -e "select count(*) from record,recordmatch where \
        record.recordid=recordmatch.recordid and \
        record.chanid=recordmatch.chanid and \
        inactive=0 and (type!=0 or type!=8) and \
        timediff(recordmatch.starttime,now()) < '00:30:00' and \
        recordmatch.starttime > now();" -sN`

RM=`mysql $db -u $user -e "select count(*) from recordmatch;" -sN`

#lastrun=`mysql $db -u $user -e "select lastrun from housekeeping where \
#               tag='MythFillDB';" -sN`



if [ $rec -ge 1 ]; then
        echo "$msgp MythTV is recording a scheduled program.  \
        Please run mythfilldatabase at another time."


elif [ $sched -ge 1 ]; then
        echo "$msgp MythTV is scheduled to record a program shortly. \
        Please run mythfilldatabase at another time."


elif [ $RM -eq 0 ]; then
        echo "$msgp Recordmatch table is empty. Quitting"


else
        echo "$msgp MythTV will now run $mfdb"
        $mfdb
        exit 0

fi

# update housekeeping table with now() minus one day so mfdb will run again
updhousek=`mysql $db -u $user -e "update housekeeping \
                set lastrun=date_sub(now(),INTERVAL 1 DAY) \
                 where tag='MythFillDB';" -sN`




exit 12