[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