Canned searches include hidden channels

[Stuart Auchterlonie]

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.

[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, ')

[xris]

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

[xris]

(In [8433]) hopefully fix #615