Deleting Channels From MythTV
Wednesday, January 28th, 2009MythTV is a DIY digital video recorder. Building a box to do this isn’t much beyond putting together a PC and installing Linux, but its not something I’d expect a non-geek to dive into. Geek or not – everyone should have some form of digital video recorder, it completely changes how you watch TV.
Of course, since my MythBox is using a capture card to grab video from my sattellite receiver it has no idea what channel has which show. When I started with MythTV, there was a free service offered by Zap2It.com that offered up listing information in an easy to consume format. The listings provide MythTV with guide information so it knows what is on, and when. Today there is SchedulesDirect which is well run and inexpensive at $20 USD a year.
Over time, channels change and this is reflected by changes in the listing data. MythTV detects these changes, and will add new channels automatically – it won’t remove channels that we listing information is no longer being delivered for. I’m on an older version (0.20) but suspect there is a design decision here.
Using the UI to remove channels is pretty clunky. The MythTV site has instructions on accomplishing this via the command line, and while I’m comfortable with the command line – it is a multi-step process which I dreaded doing. So over a few months, more and more bogus channels that I didn’t actually have would get added. For example – a new pay per view (PPV) channel would appear, new guide data would become available and I’d start seeing it as an available channel… grr
Of course, you still need to connect to SchedulesDirect and remove the unwanted channels from your subscription otherwise MythTV will just keep adding the ‘new’ channels back. Tonight I wrote up a quick Perl script to automate the multi-step process – this makes removing unwanted channels quick and easy.
Usage: remove_channel.pl <channel number>
#!/usr/bin/perl
use Mysql;
# MYSQL CONFIG VARIABLES
$host = "localhost";
$database = "mythconverg";
$user = "root";
$pw = "";
# PERL MYSQL CONNECT()
$connect = Mysql->connect($host, $database, $user, $pw);
# SELECT DB
$connect->selectdb($database);
# DEFINE some MySQL queries
$findchan = "SELECT chanid FROM channel where channum = ".$ARGV[0];
$delchannel = "DELETE FROM channel where chanid = ";
$delprogram = "DELETE FROM program where chanid = ";
# EXECUTE THE QUERY
$execute = $connect->query($findchan);
while (@results = $execute->fetchrow()) {
print "chanid ".$results[0]."\n";
$connect->query($delchannel.$results[0]);
$connect->query($delprogram.$results[0]);
}
