[mythtv] [mythtv-commits] mythtv commit: r11390 by danielk

[Daniel Kristjansson]

On Mon, 2006-10-02 at 22:30 -0400, Michael T. Dean wrote:
> On 10/02/06 19:28, mythtv at cvs.mythtv.org wrote:
> >Refs #2087. Finetunes Cable HRC table.

> (since I was saying why it can't be done nicely), I figured out a pretty 
> nice way of doing it (at least the WHERE part of it--others might have a 
> better idea for the list of 40 SQL statements it requires).  Seems the 
> 2nd left join never crossed my mind until now.
Cool

> I included an "AND freqid < 10000" (which we use to tell if it's a 
> channel number or a frequency) in the SELECT since the finetune is not 
> used if the user specifies a frequency.  For IRC, the "initial" 
> decrement is done on all non-zero finetune values in that same range, so 
> if the user had any channels with freqid > 125, they will be 
> incremented.  But, since the frequency table does not currently have any 
> channels over 126, it would be impossible for the user to specify these 
> channels by channel number--they must use frequency--so finetune will be 
> ignored.  However, if they had a value in there (whatever it meant to 
> them), it will be modified.

Sounds reasonable. If you put this in the form of patch[es], I'll
apply it quickly. It doesn't matter if it is one or two patches.

-- Daniel