From 0265cdc1c982ca2bd33ceee7d9d956eda91e9d37 Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Tue, 16 Nov 2010 11:13:52 -0800 Subject: Ticket 2895: exclude silenced users from popular notice lists --- lib/popularity.php | 1 + 1 file changed, 1 insertion(+) diff --git a/lib/popularity.php b/lib/popularity.php index c5b795b8d..b6987138b 100644 --- a/lib/popularity.php +++ b/lib/popularity.php @@ -76,6 +76,7 @@ class Popularity 'notice.rendered,notice.url,notice.created,notice.modified,' . 'notice.reply_to,notice.is_local,notice.source,notice.conversation, ' . 'notice.lat,notice.lon,location_id,location_ns,notice.repeat_of'; + $qry .= ' HAVING \'silenced\' NOT IN (SELECT role FROM profile_role WHERE profile_id=notice.profile_id)'; $qry .= ' ORDER BY weight DESC'; $offset = $this->offset; -- cgit v1.2.3