#!/bin/sh
echo 'select xmltvid from channel where sourceid=2;' | mysql --skip-column-names mythconverg -poxxzqsve | sort | uniq | grep -v '^$' | sed 's,^,channel ,' >~/.mythtv/DVB.xmltv
echo 'select xmltvid from channel where sourceid=3;' | mysql --skip-column-names mythconverg -poxxzqsve | sort | uniq | grep -v '^$' | sed 's,^,channel ,' >~/.mythtv/Satellite.xmltv