[mythtv-users] New frequency for NY NBC OTA channel 4

[stinga]

On 03/04/18 01:26, Tom Dexter wrote:
> I just found out the hard way that apparently NY NBC channel 4
> apparently changed frequency on April 1.
>
> I'd love to be able to just find out what the new frequency is and to
> possible change it in the database. I HATE scanning for channels
> frankly. For one thing I have a bunch of disabled Philadelphia
> channels that I need to keep, but which can't be picked up without
> turning my antenna, and among other things I do NOT want it to delete
> any of those.
I don't do a scan, I just find out when things don't record and fix the 
DB, here are my rough rules, if you don't know what you are doing then 
don't use :-)
(I am in the UK)


#Useful urls
https://en.kingofsat.net/freqs.php?&pos=28.2E&standard=All&ordre=freq&filtre=no&aff=list
https://www.lyngsat.com/Astra-2E-2F-2G.html

#List chan details
select c.xmltvid, c.callsign, c.chanid, c.channum, c.sourceid 
'c.sourceid', dm.sourceid 'dm.sourceid', c.mplexid 'c.mplexid', 
dm.mplexid 'dm.mplexid', c.serviceid, dm.transportid, dm.frequency, 
dm.inversion, dm.symbolrate, dm.fec, dm.polarity, dm.modulation, 
dm.networkid from channel c, dtv_multiplex dm where c.mplexid = 
dm.mplexid and name like '%???%';

#if nothing returned then the multiplex is probably missing - this is 
probably better
select c.xmltvid, c.callsign, c.chanid, c.channum, c.sourceid 
'c.sourceid', dm.sourceid 'dm.sourceid', c.mplexid 'c.mplexid', 
dm.mplexid 'dm.mplexid', c.serviceid, dm.transportid, dm.frequency, 
dm.inversion, dm.symbolrate, dm.fec, dm.polarity, dm.modulation, 
dm.networkid from channel c left join dtv_multiplex dm on c.mplexid = 
dm.mplexid where name like '%???%';

#May need to add a new row into dtv_multiplex - see useful urls
select 
mplexid,sourceid,transportid,networkid,frequency,inversion,symbolrate,fec,polarity,modulation,sistandard 
from dtv_multiplex where frequency=???;
select 
mplexid,sourceid,transportid,networkid,frequency,inversion,symbolrate,fec,polarity,modulation,sistandard 
from dtv_multiplex order by frequency;

#To insert a new frequency - needs to be done twice, for 3 and 5 
sourceid's - I have HD and SD source ids
insert into dtv_multiplex 
(sourceid,transportid,networkid,frequency,symbolrate,polarity)values(5,???,2,???,???,'?');


#Then usually you need to alter the channel tables
select xmltvid, name, c.callsign, c.chanid, c.channum, c.sourceid, 
c.mplexid, c.serviceid from channel c where name like '%??%';
update channel set mplexid=??? where chanid=???;
update channel set serviceid=??? where chanid in (???,???);

#duplicate a channel row
CREATE table x SELECT * FROM channel where chanid=???'
#Find an empty chanid
select chanid from channel order by chanid limit 5;
update x set chanid=???, chanid=???;
INSERT INTO channel select * from x;
drop table x;

-- 
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email: stinga+mythtv at wolf-rock.com  o
You need only two tools.        o /////
A hammer and duct tape. If it    /@   `\  /) ~
doesn't move and it should use  >  (O)  X<  ~  Fish!!
the hammer. If it moves and      `\___/'  \) ~
shouldn't, use the tape.           \\\
---------------------------------------------------