[mythtv-users] Help, Channel change script's first argument aint channel number

[Michael T. Dean]

On 01/06/2008 02:31 PM, Evuraan::ഏവൂരാന്‍ wrote:
> Michael T. Dean wrote:
>   
>> On 01/06/2008 12:38 AM, Evuraan::ഏവൂരാന്‍ wrote:
>>> On Jan 5, 2008 10:31 PM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>>>> The freqid /is/ the channel number--unless someone changes it to a
>>>> frequency (in kHz). In other words, if you want a channel number instead
>>>> of a frequency, change your freqid values to the channel number using
>>>> the channel editor in mythtv-setup or MythWeb.
>>> Well,  I modified my channel change script to do a mysql db lookup to
>>> find the channum against the given freqid:
>>>
>>> The full script is here, in case anyone else ever needs it:
>>>
>>> http://malayalam.homelinux.net/evuraan/change-channel.sh.txt
>>>
>>> Thanks for your time..!
>> Why not fix your DB to hold the right data? The frequencies are useless 
>> to Myth if you're using an external channel change script.
> I tried to, in mythtv-setup, ( no mythweb here) -  seems like I will 
> have to manually edit the 165+ channels? Unless I am missing something, 
> that looks a bit cumbersome.

Though I would never recommend editing the DB directly, if you're 
comfortable enough writing a script to connect to the DB to translate 
frequency to channel number, perhaps you might think of a way to set the 
frequency ID equal to the channel number using a single SQL statement...  ;)

Mike