#!/bin/sh
#
# ScanTV channels to MythTV DB channels converter script
#
# Date: Sept 26, 2005
# Copyright: Garth Dahlstrom <ironstorm@users.sf.net> (C) 2005
# License: GPL V2.0+ < http://www.gnu.org/licenses/gpl.txt >
#

# Video Source Device for MythTV
VID_SOURCE=1

# Offset to add to all chanids
CHANID_START=999


echo Starting ScanTV - This can take 2-3 minutes...
# ScanTV temp data file
SCANDATA=scantvdata.txt

# echo's in 1<newline> 0<newline> into scantv which means NTSC and us-bcast are chosen
echo -e "1\n0" | scantv 2>&1 | grep "MHz" | grep -v "no station" | grep -n -v "no station" > $SCANDATA

echo MythTV MySQL channel output...
echo ----- cut -----
echo
echo use mythconverg
echo
for LOOP_COUNT in `seq $(cat $SCANDATA|wc -l)`
do
  CHAN_ID=`expr $CHANID_START + $LOOP_COUNT`
  CHAN_DATA=`cat $SCANDATA|grep "$LOOP_COUNT:"|head -1`
  CHAN_NUM=`echo $CHAN_DATA|cut -d":" -f2|cut -d" " -f1`
  FREQ_ID=$CHAN_NUM
  # `echo $CHAN_DATA|cut -d":" -f2|cut -d"(" -f2|cut -d")" -f1|sed "s/ //g"`
  CALLSIGN=`echo $CHAN_DATA|cut -d":" -f3|sed "s/ //"`
  CHAN_NAME="$CHAN_NUM - $CALLSIGN"
  # INSERT INTO `channel` (chanid, channum, freqid, sourceid, callsign, name) VALUES ($CHAN_ID,'$CHAN_NUM','501.25MHz',1,'TVO','19 - TVO')
  echo "INSERT INTO \`channel\` (chanid, channum, freqid, sourceid, callsign, name) VALUES ($CHAN_ID,'$CHAN_NUM','$FREQ_ID',$VID_SOURCE,'$CALLSIGN','$CHAN_NAME');"
done
echo
echo exit
echo
echo ----- eof -----
echo
echo next you have to do:
echo
echo su -
echo mysql
echo
echo then past the lines above into mysql
echo