Opened 14 years ago

Closed 14 years ago

#615 closed defect (fixed)

Canned searches include hidden channels

Reported by: Stuart Auchterlonie Owned by: xris
Priority: minor Milestone: 0.19
Component: mythweb Version: head
Severity: low Keywords: mythweb canned search
Cc: Ticket locked: no

Description

Using the canned searches in mythweb to look for upcoming movies, programs being shown on channels that are marked as hidden are shown.

These should be hidden since the channels are not of interest.

Change History (3)

comment:1 Changed 14 years ago by Mark Edwards

I think this can be fixed using this? Should also speed up mythweb slighty if you have a lot of invisible channels.

Index: includes/channels.php =================================================================== --- includes/channels.php (revision 7639) +++ includes/channels.php (working copy) @@ -23,9 +23,9 @@

global $Channels; $Channels = array(); if ($_SESSIONguide_favonly?)

  • $sql = "SELECT channel.* FROM channel, favorites WHERE channel.chanid = favorites.chanid";

+ $sql = "SELECT channel.* FROM channel, favorites WHERE channel.chanid = favorites.chanid and visible=1";

else

  • $sql = "SELECT * FROM channel";

+ $sql = "SELECT * FROM channel where visible=1";

Group and sort

$sql .= ' GROUP BY channum, callsign ORDER BY '

.(prefer_channum ? : 'callsign, ')

comment:2 Changed 14 years ago by xris

next time, use the {{{ }}} formatting, or better yet, attach the diff to the ticket as a file. Committing the fix shortly.

comment:3 Changed 14 years ago by xris

Resolution: fixed
Status: newclosed

(In [8433]) hopefully fix #615

Note: See TracTickets for help on using tickets.