<div dir="ltr"><div><div><div><div><div><div><div><div><div><div>The UK freeview channels did a retune/renumber yesterday 4th September, this can be a PITA as it can require a lot of manual messing around to get the channels resorted the way you way (and remove the 'garbage' channels from the visible lists).<br>
<br></div>The following script should allow you to quickly setup the channels in a usable format again.<br><br></div>BEFORE using the script note the following:-<br><br></div><div>BACKUP your DATABASE, BACKUP your DATABASE, BACKUP your DATABASE before doing anything else.<br>
</div><div><br></div>It's primarily for Crystal Palace transmitter, but can be modified for other UK transmitters.<br><br></div>It's NOT designed for satellite or mixed freeview/satellite setups.<br><br></div><div>
It is designed to be used after you've done a manual retune of your channels in mythtv-setup, my personal recommendation is to delete all the existing channels before doing the retune to 'clear out' potential conflicts.<br>
</div><div><br></div>It assumes that your Freeview Tuner device is configured so that your channel ids (chanid) will usually begin 1xxx (where xxx is the channel number, i.e. BBC One is 1001 and BBC One HD is 1101), if your device starts 2xxx or Yxxx for some reason (can sometimes happen if devices are added in different order) then you'll need to edit the script.<br>
<br></div>The channel order is just my personal preference and groups the channels the way I like, your preference may be different.<br><br></div>All errors and omissions are mine so USE AT YOUR OWN RISK....if it breaks your box or burns your house down I'm not responsible.....it's purely here to save people having to do some work going through the new channels.<br>
<br></div>MAKE SURE you change the USERNAME and PASSWORD in BOTH places in the script to match your setup (once at the top and again near the bottom)<br><br></div>This script is based on ones I think I found in the wiki years ago, all credit to anyone who wants it.<br>
<br></div><div>SCRIPT STARTS BELOW<br></div><div><div><div><div><div><br> *******************************************************<br><br>#!/bin/sh<br><br><br>echo '<br><br>update channel set visible=0;<br><br><br>' | mysql --database=mythconverg --user=mythtvusername --password=mythtvpassword<br>
<br><br>echo '<br><br>update channel set channum=1,visible=1,commmethod=-2 where chanid="1001";<br>update channel set name="BBC One" where chanid="1001";<br>update channel set callsign="BBC One" where chanid="1001";<br>
update channel set channum=2,visible=1,commmethod=-2 where name="BBC TWO";<br>update channel set channum=3,visible=1 where name="ITV";<br>update channel set channum=4,visible=1 where name="Channel 4";<br>
update channel set channum=5,visible=1 where name="Channel 5";<br>update channel set channum=6,visible=1,commmethod=-2 where name="BBC THREE";<br>update channel set channum=7,visible=1,commmethod=-2 where name="BBC FOUR";<br>
update channel set channum=8,visible=1 where name="ITV2";<br>update channel set channum=9,visible=1 where name="ITV3";<br>update channel set channum=10,visible=1 where name="ITV4";<br>update channel set channum=11,visible=1 where name="E4";<br>
update channel set channum=12,visible=1 where name="More 4";<br>update channel set channum=13,visible=1 where name="Film4";<br>update channel set channum=14,visible=1 where name="Film4+1";<br>
update channel set channum=15,visible=1 where name="Movie Mix";<br>update channel set channum=16,visible=1 where name="movies4men";<br>update channel set channum=17,visible=1 where name="5*";<br>
update channel set channum=18,visible=1 where name="5 USA";<br>update channel set channum=19,visible=1 where name="Pick";<br>update channel set channum=20,visible=1 where name="Yesterday";<br>
update channel set channum=21,visible=1 where name="Dave";<br>update channel set channum=22,visible=1 where name="Really";<br>update channel set channum=23,visible=1 where name="Challenge";<br>
update channel set channum=24,visible=1 where name="True Entertainment";<br>update channel set channum=25,visible=1 where name="Drama";<br>update channel set channum=26,visible=1 where name="ITVBe";<br>
update channel set channum=27,visible=1 where name="QUEST";<br>update channel set channum=28,visible=1 where name="CBS Reality";<br>update channel set channum=29,visible=1 where name="CBS Action";<br>
update channel set channum=30,visible=1 where name="truTV";<br>update channel set channum=31,visible=1 where name="ITV +1";<br>update channel set channum=32,visible=1 where name="ITV2 +1";<br>
update channel set channum=33,visible=1 where name="ITV3+1";<br>update channel set channum=34,visible=1 where name="ITV4+1";<br>update channel set channum=35,visible=1 where name="Channel 4+1";<br>
update channel set channum=36,visible=1 where name="E4+1";<br>update channel set channum=37,visible=1 where name="4seven";<br>update channel set channum=38,visible=1 where name="Channel 5+1";<br>
update channel set channum=39,visible=1 where name="Channel 5+24";<br>update channel set channum=40,visible=1 where name="Dave ja vu";<br>update channel set channum=41,visible=1 where name="QUEST+1" and chanid="1038";<br>
update channel set channum=42,visible=1 where name="truTV+1";<br>update channel set channum=45,visible=1 where name="4Music";<br>update channel set channum=46,visible=1 where name="VIVA";<br>
update channel set channum=47,visible=1 where name="Chart Show TV";<br><br>update channel set channum=50,visible=1,commmethod=-2 where name="BBC ONE HD";<br>update channel set channum=51,visible=1,commmethod=-2 where name="BBC TWO HD";<br>
update channel set channum=52,visible=1 where name="ITV HD";<br>update channel set channum=53,visible=1 where name="CHANNEL 4 HD";<br>update channel set channum=54,visible=0 where name="Channel 5 HD";<br>
update channel set channum=55,visible=1,commmethod=-2 where name="BBC THREE HD";<br>update channel set channum=56,visible=1,commmethod=-2 where name="BBC FOUR HD";<br>update channel set channum=57,visible=1 where name="Channel 4+1 HD";<br>
update channel set channum=58,visible=1 where name="4seven HD";<br><br>update channel set channum=60,visible=1 where name="BT Sport 1";<br>update channel set channum=61,visible=1 where name="BT Sport 2";<br>
<br>update channel set channum=70,visible=1,commmethod=-2 where name="CBBC" and chanid="1120";<br>update channel set channum=71,visible=1,commmethod=-2 where name="CBeebies" and chanid="1121";<br>
update channel set channum=72,visible=1 where name="CITV" and chanid="1122";<br>update channel set channum=73,visible=1 where name="POP";<br>update channel set channum=74,visible=1 where name="POP +1";<br>
update channel set channum=75,visible=1,commmethod=-2 where name="CBBC HD"and chanid="1123";<br>update channel set channum=76,visible=1,commmethod=-2 where name="CBeebies HD" and chanid="1124";<br>
<br>update channel set channum=80,visible=1,commmethod=-2 where name="BBC NEWS" and chanid="1130";<br>update channel set channum=81,visible=1,commmethod=-2 where name="BBC Parliament" and chanid="1131";<br>
update channel set channum=82,visible=1 where name="Sky News" and chanid="1132";<br>update channel set channum=84,visible=0 where name="CNN";<br>update channel set channum=85,visible=1 where name="RT" and chanid="1135";<br>
update channel set channum=86,visible=1 where name="Al Jazeera Eng" and chanid="1133";<br>update channel set channum=90,visible=0 where name="TV News";<br><br>update channel set channum=100,visible=1 where name="BBC NEWS HD";<br>
update channel set channum=101,visible=1 where name="Al Jazeera Eng HD";<br><br>update channel set channum=200,visible=1,commmethod=-2 where name="BBC Red Button";<br>update channel set channum=301,visible=1 where name="BBC RB 1";<br>
update channel set channum=302,visible=1 where name="302";<br>update channel set channum=700,visible=1,commmethod=-2 where name="BBC Radio 1";<br>update channel set channum=701,visible=1,commmethod=-2 where name="BBC R1X";<br>
update channel set channum=702,visible=1,commmethod=-2 where name="BBC Radio 2";<br>update channel set channum=703,visible=1,commmethod=-2 where name="BBC Radio 3";<br>update channel set channum=704,visible=1,commmethod=-2 where name="BBC Radio 4";<br>
update channel set channum=705,visible=1,commmethod=-2 where name="BBC R5L";<br>update channel set channum=706,visible=1,commmethod=-2 where name="BBC R5SX";<br>update channel set channum=707,visible=1,commmethod=-2 where name="BBC 6 Music";<br>
update channel set channum=708,visible=1,commmethod=-2 where name="BBC Radio 4 Ex";<br>update channel set channum=709,commmethod=-2 where name="BBC Asian Net.";<br>update channel set channum=710,visible=1,commmethod=-2 where name="BBC World Sv.";<br>
update channel set channum=711,visible=1 where name="BBC London";<br>update channel set channum=712,visible=1 where name="KISS FRESH";<br>update channel set channum=713,visible=1 where name="Kiss";<br>
update channel set channum=714,visible=1 where name="KISSTORY";<br>update channel set channum=715,visible=1 where name="Magic";<br>update channel set channum=716,visible=1 where name="heat";<br>
update channel set channum=717,visible=1 where name="Kerrang!";<br>update channel set channum=718,visible=1 where name="SMOOTH RADIO";<br>update channel set channum=723,visible=1 where name="talkSPORT";<br>
update channel set channum=724,visible=1 where name="Capital FM";<br>update channel set channum=725,visible=1 where name="Premier Radio";<br>update channel set channum=727,visible=1 where name="Absolute Radio";<br>
update channel set channum=728,visible=1 where name="Heart";<br><br>update channel set channum=9999773666474 where name="TBN UK";<br>update channel set channum=999947783884 where name="Al Jazeera Arabic";<br>
update channel set channum=61,visible=1 where name="BT Sport 2";<br>update channel set channum=9999999997754 where name="London Live";<br>update channel set channum=99999999916 where name="QVC";<br>
update channel set channum=99999999917 where name="G.O.L.D.";<br>update channel set channum=99999999922 where name="Ideal World";<br>update channel set channum=99999999923 where name="bid";<br>
update channel set channum=99999999926 where name="Home";<br>update channel set channum=99999999948 where name="Food Network";<br>update channel set channum=99999999949 where name="Jewellery Ch.";<br>
update channel set channum=99999758487 where name="Jewellery Maker";<br>update channel set channum=99999999950 where name="Marketplace";<br>update channel set channum=99999999955 where name="Motors TV";<br>
update channel set channum=9999999987 where name="Community";<br>update channel set channum=99998773662 where name="Community HD";<br>update channel set channum=99999747882 where name="Dating";<br>
update channel set channum=9999999302 where name="TVPlayer";<br>update channel set channum=9999999308 where name="Vintage TV";<br>update channel set channum=9999999309 where name="TOPUP Anytime3";<br>
update channel set channum=9999999306 where name="TOPUP Anytime5";<br>update channel set channum=9999999307 where name="TOPUP Anytime6";<br>update channel set channum=9999999228 where name="Christian";<br>
update channel set channum=9999999229 where name="Propeller TV";<br>update channel set channum=9999999229 where name="Connect 2";<br>update channel set channum=9999999230 where name="Connect 1";<br>
update channel set channum=9999999231 where name="Racing UK";<br>update channel set channum=9999999234 where name="CONNECT 4";<br>update channel set channum=9999999237 where name="Peace TV";<br>
update channel set channum=9999999238 where name="VuTV";<br>update channel set channum=9999999239 where name="Sonlife";<br>update channel set channum=9999999225 where name="VISION";<br>update channel set channum=9999999226 where name="CCTV";<br>
update channel set channum=9999999227 where name="Sports";<br>update channel set channum=9999999236 where name="SONY SAB";<br>update channel set channum=9999999108 where name="Sky Text";<br>update channel set channum=9999999109 where name="MOBILIZER";<br>
update channel set channum=9999991199,name="AlsoAdult" where chanid="1199";<br>update channel set channum=9999999170 where name="ADULT Section";<br>update channel set channum=9999999180 where name="xxXpanded TV";<br>
update channel set channum=9999999790 where name="Test";<br>update channel set channum=9999999191 where name="ADULT redhotTV";<br>update channel set channum=9999999192 where name="ADULT Filth";<br>
update channel set channum=9999999170 where name="ADULT Section";<br>update channel set channum=9999999171 where name="Television X";<br>update channel set channum=9999999172 where name="ADULT smileTV2";<br>
update channel set channum=9999999173 where name="ADULT smileTV3";<br>update channel set channum=9999999174 where name="ADULT Babestn";<br>update channel set channum=9999999177 where name="ADULT Babestn2";<br>
update channel set channum=9999999175 where name="ADULT PARTY";<br>update channel set channum=9999999176 where name="ADULT Blue";<br>update channel set channum=9999999181 where name="ADULT Playboy TV Chat";<br>
update channel set channum=9999999201 where name="Holidays TV";<br>update channel set channum=9999999202 where name="Rabbit";<br>update channel set channum=9999999203 where name="Gay Rabbit";<br>
update channel set channum=9999999204 where name="1-2-1 Dating";<br>update channel set channum=9999999207 where name="Kiss Me TV";<br>update channel set channum=9999999208 where name="Proud Dating";<br>
update channel set channum=99999999936 where name="Create & Craft";<br>update channel set channum=99999999937 where name="price-drop";<br>update channel set channum=99999999932 where name="Big Deal";<br>
update channel set channum=99999999939 where name="The Store";<br>update channel set channum=99999999942 where name="Travel Channel";<br>update channel set channum=99999999940 where name="Rocks & Co 1";<br>
update channel set channum=99999999943 where name="Gems TV";<br>update channel set channum=99999999948 where name="QVC Beauty";<br>update channel set channum=99999664554 where name="QVC EXTRA";<br>
' | mysql --database=mythconverg --user=mythusername --password=mythpassword<br> <br># -- Mark BBC channels as addfree and not requiring commercial flagging.<br># UPDATE channel SET commmethod=-2 WHERE name LIKE '%BBC%' OR name = 'CBeebies';<br>
<br># -- Set Default Channel to a valid entry<br># UPDATE settings SET data=(SELECT channum FROM channel WHERE channum > 100 ORDER BY channum ASC LIMIT # 1) WHERE value='DefaultTVChannel';<br><br># -- Set Smart Channel Changing (instant change on 3rd Digit)<br>
# UPDATE settings SET data = 1 WHERE value='SmartChannelChange';<br><br>***********************************************************************************************<br><br></div><div>SCRIPT ENDS ABOVE<br></div>
</div></div></div></div></div>