[mythtv-users] newbie UK user

Stephen Davies steve at daviesfam.org
Tue Jul 15 11:26:16 EDT 2003


Can I offer this little sql script for UK NTL users.  I have Family
pack.  I ran mythfilldatabase without "-manual" and then used this
script to fill in the channel numbers:

You'll have to edit the file and change the sourceid to the
appropriate one in your database for NTL.

Hope it's helpful,
Steve

-------------- next part --------------
update channel set channum='101', freqid='101',  callsign='BBC1' where sourceid=18 and xmltvid='east.bbc1.bbc.co.uk';
update channel set channum='102', freqid='102',  callsign='BBC2' where sourceid=18 and xmltvid='east.bbc2.bbc.co.uk';
update channel set channum='103', freqid='103',  callsign='ITV1' where sourceid=18 and xmltvid='anglia.tv.co.uk';
update channel set channum='104', freqid='104',  callsign='CH4' where sourceid=18 and xmltvid='channel4.com';
update channel set channum='105', freqid='105',  callsign='five' where sourceid=18 and xmltvid='channel5.co.uk';
update channel set channum='598', freqid='598',  callsign='CBBC' where sourceid=18 and xmltvid='cbbc.bbc.co.uk';
update channel set channum='599', freqid='599',  callsign='CBEEBIES' where sourceid=18 and xmltvid='cbeebies.bbc.co.uk';
update channel set channum='117', freqid='117',  callsign='ITV2' where sourceid=18 and xmltvid='itv2.itv.co.uk';
update channel set channum='140', freqid='140',  callsign='SKY1' where sourceid=18 and xmltvid='sky-one.sky.com';
update channel set channum='633', freqid='633',  callsign='TVTRVL2' where sourceid=18 and xmltvid='2.tvtravelshop.co.uk';
update channel set channum='113', freqid='113',  callsign='BLOOM' where sourceid=18 and xmltvid='bloomberg.com';
update channel set channum='126', freqid='126',  callsign='BBC3' where sourceid=18 and xmltvid='bbc3.bbc.co.uk';
update channel set channum='123', freqid='123',  callsign='ITN' where sourceid=18 and xmltvid='itn.co.uk';
update channel set channum='127', freqid='127',  callsign='BBC4' where sourceid=18 and xmltvid='knowledge.bbc.co.uk';
update channel set channum='128', freqid='128',  callsign='PRLMNT' where sourceid=18 and xmltvid='parliament.bbc.co.uk';
update channel set channum='856', freqid='856',  callsign='ScrnShop' where sourceid=18 and xmltvid='screenshop.co.uk';
update channel set channum='854', freqid='854',  callsign='SimpleShop' where sourceid=18 and xmltvid='simplyshoppingtv.co.uk';
update channel set channum='121', freqid='121',  callsign='SKYNEWS' where sourceid=18 and xmltvid='sky-news.sky.com';
update channel set channum='124', freqid='124',  callsign='CNBC' where sourceid=18 and xmltvid='europe.cnbc.com';
update channel set channum='125', freqid='125',  callsign='NEWS24' where sourceid=18 and xmltvid='news-24.bbc.co.uk';
update channel set channum='647', freqid='647',  callsign='BIDUP' where sourceid=18 and xmltvid='bid-up.tv';
update channel set channum='114', freqid='114',  callsign='QVC' where sourceid=18 and xmltvid='qvc1.qvcuk.com';
update channel set channum='112', freqid='112',  callsign='Eurosport' where sourceid=18 and xmltvid='british.eurosport.com';
update channel set channum='830', freqid='830',  callsign='UKGOLD2' where sourceid=18 and xmltvid='uk-gold-2.flextech.telewest.co.uk';
update channel set channum='300', freqid='300',  callsign='UKGOLD' where sourceid=18 and xmltvid='uk-gold.flextech.telewest.co.uk';
update channel set channum='407', freqid='407',  callsign='UKSTYLE' where sourceid=18 and xmltvid='uk-style.flextech.telewest.co.uk';
update channel set channum='827', freqid='827',  callsign='NICKReplay' where sourceid=18 and xmltvid='replay.nickelodeon.co.uk';
update channel set channum='400', freqid='400',  callsign='ParaComedy' where sourceid=18 and xmltvid='paramountcomedy.com';
update channel set channum='305', freqid='305',  callsign='UKDRAMA' where sourceid=18 and xmltvid='uk-drama.flextech.telewest.co.uk';
update channel set channum='307', freqid='307',  callsign='Chalnge' where sourceid=18 and xmltvid='challengetv.co.uk';
update channel set channum='190', freqid='190',  callsign='Hallmark' where sourceid=18 and xmltvid='hallmarkchannelint.com';
update channel set channum='808', freqid='808',  callsign='UKFOOD' where sourceid=18 and xmltvid='uk-food.flextech.telewest.co.uk';
update channel set channum='401', freqid='401',  callsign='Living' where sourceid=18 and xmltvid='living.flextech.telewest.co.uk';
update channel set channum='506', freqid='506',  callsign='Horizons' where sourceid=18 and xmltvid='uk-horizons.flextech.telewest.co.uk';
update channel set channum='801', freqid='801',  callsign='A1' where sourceid=18 and xmltvid='adventure-one.nationalgeographic.co.uk';
update channel set channum='503', freqid='503',  callsign='AnimalPlnt' where sourceid=18 and xmltvid='animalplanet.discoveryeurope.com';
update channel set channum='802', freqid='802',  callsign='BIOG' where sourceid=18 and xmltvid='biography-channel.biography.com';
update channel set channum='508', freqid='508',  callsign='DiscCiv' where sourceid=18 and xmltvid='civilisations.discoveryeurope.com';
update channel set channum='500', freqid='500',  callsign='Disc' where sourceid=18 and xmltvid='discoveryeurope.com';
update channel set channum='804', freqid='804',  callsign='DiscHealth' where sourceid=18 and xmltvid='health.discovery.com';
update channel set channum='505', freqid='505',  callsign='NtnlGeog' where sourceid=18 and xmltvid='nationalgeographic.co.uk';
update channel set channum='501', freqid='501',  callsign='Disc+1' where sourceid=18 and xmltvid='plus-1.discoveryeurope.com';
update channel set channum='807', freqid='807',  callsign='History+1' where sourceid=18 and xmltvid='plus-1.thehistorychannel.co.uk';
update channel set channum='510', freqid='510',  callsign='DiscSciTrek' where sourceid=18 and xmltvid='sci-trek.discoveryeurope.com';
update channel set channum='504', freqid='504',  callsign='History' where sourceid=18 and xmltvid='thehistorychannel.co.uk';
update channel set channum='509', freqid='509',  callsign='DiscTravel' where sourceid=18 and xmltvid='travel.discoveryeurope.com';
update channel set channum='805', freqid='805',  callsign='DiscWings' where sourceid=18 and xmltvid='wings.discoveryeurope.com';
update channel set channum='304', freqid='304',  callsign='DiscHome' where sourceid=18 and xmltvid='home.discoveryeurope.com';
update channel set channum='609', freqid='609',  callsign='MTVBase' where sourceid=18 and xmltvid='base.mtv.co.uk';
update channel set channum='611', freqid='611',  callsign='VH1Classic' where sourceid=18 and xmltvid='classic.vh1online.co.uk';
update channel set channum='820', freqid='820',  callsign='MTVDance' where sourceid=18 and xmltvid='dance.mtv.co.uk';
update channel set channum='610', freqid='610',  callsign='MTVHits' where sourceid=18 and xmltvid='hits.mtv.co.uk';
update channel set channum='815', freqid='815',  callsign='KissTV' where sourceid=18 and xmltvid='kiss-tv.kiss100.com';
update channel set channum='604', freqid='604',  callsign='MTV' where sourceid=18 and xmltvid='mtv.co.uk';
update channel set channum='606', freqid='606',  callsign='TheBox' where sourceid=18 and xmltvid='thebox.co.uk';
update channel set channum='605', freqid='605',  callsign='VH1' where sourceid=18 and xmltvid='vh1online.co.uk';


More information about the mythtv-users mailing list