From 0265cdc1c982ca2bd33ceee7d9d956eda91e9d37 Mon Sep 17 00:00:00 2001
From: Brion Vibber <brion@pobox.com>
Date: Tue, 16 Nov 2010 11:13:52 -0800
Subject: [PATCH] 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 c5b795b8d2..b6987138b5 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;
--
2.39.5