#!/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'


# 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=''
mfdb='mythfilldatabase --quiet'

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

if [ $data -ge 1 ]; then
        echo "$script MythTV is currently recording a scheduled program.  Please run mythfilldatabase at another time."
else
        echo "$script MythTV will now run $mfdb"
        $mfdb
fi

exit 0

#!/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'


# 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=''
mfdb='mythfilldatabase --quiet'

# run SQL
data1=`mysql $db -u $user -e "select count(*) from recorded where timediff(now(),endtime)<'00:00:00' and recgroup!='LiveTV';" -sN`
data2=`mysql $db -u $user -e "select count(*) from record where inactive=0 and (type!=0 or type!=8) and timediff(now(),concat(startdate,' ',starttime))<'00:30:00';" -sN`

if [ $data1 -ge 1 -o $data2 -ge 1 ]; then
        echo "$script MythTV is/will be recording a scheduled program.  Please run mythfilldatabase at another time."
else
        echo "$script MythTV will now run $mfdb"
        $mfdb
fi

exit 0

#!/bin/sh

# initalize variables
db='mythconverg'
data0=0
data1=0
data2=0

# 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(now(),concat(startdate,' '$

if [ $data0 -ge 1 -o $data1 -ge 1 -o $data2 -ge 1 ]; then
        echo -e "\033[31m         WARNING!!!"
        echo -e "\033[0mMythTV is watching $data0 program(s)"
        echo "MythTV is recording $data1 program(s)"
        echo "MythTV is scheduled $data2 program(s) within 10 minutes";
        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

#!/bin/sh

# initalize variables
db='mythconverg'
user='root'
password=''

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