[mythtv] [mythtv-commits] mythtv commit: r11390 by danielk
danielk at cuymedia.net
Tue Oct 3 12:34:30 UTC 2006
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.
> 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.
More information about the mythtv-dev