[mythtvnz] TV Capture Card Frequency ID's.

[Barry Clearwater]

You could try this snippet of sql (untested)

INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`,
`callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`,
`recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`,
`commfree`, `visible`, `outputfilters`, `useonairguide`, `mplexid`,
`serviceid`, `atscsrcid`, `tmoffset`, `atsc_major_chan`,
`atsc_minor_chan`) VALUES 
(2003, '4', '175250', 2, 'TV2', 'TV2',
'/home/mythtv/.mythtv/channels/2.jpg', 0, '', 'tv2.sky.co.nz', 0, 32768,
32768, 32768, 32768, 'Default', 0, 1, '', 1, NULL, NULL, NULL, 0, 0, 0),
(2008, '9', '210250', 2, 'TV3', 'TV3',
'/home/mythtv/.mythtv/channels/3.jpg', 0, '', 'tv3.sky.co.nz', 0, 32768,
32768, 32768, 32768, 'Default', 0, 1, '', 1, NULL, NULL, NULL, 0, 0, 0),
(2010, '11', '224250', 2, 'C4', 'C4',
'/home/mythtv/.mythtv/channels/c4.jpg', 0, '', 'c4.sky.co.nz', 0, 32768,
32768, 32768, 32768, 'Default', 0, 1, '', 1, NULL, NULL, NULL, 0, 0, 0),
(2050, '60', '783250', 2, 'Prime', 'Prime',
'/home/mythtv/.mythtv/channels/prime.jpg', 0, '', 'prime.sky.co.nz', 0,
32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, NULL, NULL, NULL, 0,
0, 0),
(27177, '2', '2', 2, 'TVONE', 'One',
'/home/mythtv/.mythtv/channels/1.jpg', 0, '', 'tv1.sky.co.nz', 0, 32768,
32768, 32768, 32768, 'Default', 0, 1, '', 1, NULL, NULL, NULL, 0, 0, 0);


On Mon, 2007-08-20 at 22:56 +1200, Andrew Bruce wrote:
> Could someone please provide me with a list of the frequency ID's of the
> TV signals in the Dunedin City area (right in the city).
> 
> Just need the ones for 1, 2, 3, C4 and Prime.
> 
> I had them written down on a piece of paper that now seems to be long
> gone :(
> 
> Thanks,
> 
> Andrew
> 
Regards
Barry Clearwater

18 Shaw Street
Mosgiel
mailto:barryc@bcsystems.co.nz 
ph 03 4893915
mob 027 2219338