Channel 4 HD

Moderator: justinh

Post Reply
maff
Junior
Posts: 20
Joined: Wed Dec 07, 2016 9:50 pm
Great Britain

Channel 4 HD

Post by maff » Tue Sep 04, 2018 9:32 am

With channel 4 having a little strop at FreeSat HD vanished, however occasionally myth recorded in HD, seems the channel is still there but there is only now and next for the program guide, given the guide is the same as one of the other channel 4 channels I did a little sql and bobs your uncle... 4 HD is back.

1)Do this to get a list of channel 4's

select chanid,channum,name,mplexid,serviceid,recpriority from channel where name regexp "Channel 4";

+--------+---------+--------------+---------+-----------+-------------+
| chanid | channum | name | mplexid | serviceid | recpriority |
+--------+---------+--------------+---------+-----------+-------------+
| 13060 | 12060 | Channel 4+1 | 16 | 12060 | 0 |
| 13065 | 12065 | Channel 4+1 | 16 | 12065 | 0 |
| 10211 | 9211 | Channel 4 | 18 | 9211 | 0 |
| 10212 | 9212 | Channel 4 | 18 | 9212 | 0 |
| 10213 | 9213 | Channel 4 | 18 | 9213 | 0 |
| 10216 | 9214 | Channel 4 | 18 | 9214 | 0 |
| 9311 | 8311 | Channel 4+1 | 19 | 8311 | 0 |
| 9312 | 8312 | Channel 4+1 | 19 | 8312 | 0 |
| 9314 | 8314 | Channel 4+1 | 19 | 8314 | 0 |
| 9316 | 8316 | Channel 4+1 | 19 | 8316 | 0 |
| 9320 | 8320 | Channel 4 | 19 | 8320 | 0 |
| 22200 | 21200 | Channel 4 HD | 34 | 21200 | 5 |
| 7700 | 6700 | Channel 44 | 46 | 6700 | 0 |
+--------+---------+--------------+---------+-----------+-------------+

2)find the chanid of one of the channel 4's that is not the HD one, i chose 10216, also find the line for channel 4 HD.

3)run this

update channel set callsign = "Maff 4 HD", name = "Maff 4 HD", mplexid = 34, serviceid = 21200, recpriority = 5 where chanid = 10216;

where mplexid and servic are the ones from your channel 4 hd line above, recpriority is optional but i bump my HD channels and chanid is the id of the SD channel 4 you are going to replace. You can change the callsign and name above to make it obvious it's your channel.

4)run this

update program set hdtv = 1 where chanid = 10216;

to swap all the guide data to hd.

and job done, now you have a weeks work of channel 4 HD.

Moving forward there's some more work to do to keep the guide data up to date, but it got me the Italian F1 GP in HD and hopefully someone will find it useful. I'll update once I can see what happens, but i rekkon you can just set the details for 10216 back to what they were and wait for the guide to update.

As ever you can balls up your mythtv by fiddeling with the database, so don't blame me if you record 3 hours of TV-X instead of The Great British Bake Off!

Post Reply