#!/bin/bash

inFILE="~/.mythchannels.conf"
. ~/.mythtv/mysql.txt

echo '
   update channel set channum=channum+11000 where channum < 100 ;
   update channel set visible=0,useonairguide=0 ;
' | mysql --database=${DBName} --user=${DBUserName} --password=${DBPassword}

n=0
cat "$inFILE" | while read line
do
   n=$((n+1))
   echo "SET NAMES utf8; update channel set visible=1,useonairguide=1,channum='$n' where callsign='$line' ;" | mysql --database=${DBName} --user=${DBUserName} --password=${DBPassword}
done