[mythtv] Weekslot recording, and an sql-join for mythbackend

[Eric Andresen]

On Mon, 2003-03-31 at 08:08, Thor Johnson wrote:
> Two more patches:
> The first makes an explicit "this timeslot every week" recording
> type.  This corrects the probme TNN has with some shows that are
> weekly programs that also show up in the same timeslot on a 
> different day.
> 
> Recordtype 5 is weekslot record, and it will only fire if the
> channel, title, timeslot and dayofweek match. (BTW Kudos to
> whoever did that SQL query!!).
> 
> The tiny patch is to use a Join instead of subquerying the
> database for the queryrecordings query.  Just a bit faster.
> 
> -Thor Johnson

+"     ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime) "
+"       AND "
+"       ((record.type = %4) " // weekslotrecord

Shouldn't this check the time as well as the day of week?

-- 
--Eric Andresen
  ndiin at asu.edu