#!/bin/bash

CHANNELFILE=/home/gladmin/tvchan2.txt
BOUQUET=`cat $CHANNELFILE | sed '1d' `
# echo "$BOUQUET"
OLDIFS=$IFS
IFS=$'\n'
MYTHDATABASE=`mysql -umythtv -pmythtv -e"use mythconverg; select * from channel;"`
echo "$MYTHDATABASE" >> /home/gladmin/newchannellist.txt

for CHANNEL in $BOUQUET; do
# Do the cleanup first
CHANID=`echo "$CHANNEL" | awk -F, '{print $1}'`
CHANNUM=`echo "$CHANNEL" | awk -F, '{print $2}'`
VISIBLE=`echo "$CHANNEL" | awk -F, '{print $6}'`
# echo "$VISIBLE"
if [ $VISIBLE -eq 0 -o $VISIBLE -eq 1 ]; then
echo "chanid $CHANID channum $CHANNUM visible $VISIBLE"
# exit 99
mysql -umythtv -pmythtv -e"UPDATE mythconverg.channel set channum="$CHANNUM" where chanid="$CHANID";"
mysql -umythtv -pmythtv -e"UPDATE mythconverg.channel set visible="$VISIBLE" where chanid="$CHANID";"
 
else
echo problem
exit
fi
done
IFS=%OLDIFS