From: Mischa POSLAWSKY <perl@shiar.org>
Date: Thu, 11 Nov 2021 19:46:59 +0000 (+0100)
Subject: issue: hide unannounced messages from public activity
X-Git-Tag: v5.4~6
X-Git-Url: http://git.shiar.nl/minimedit.git/commitdiff_plain/218c239a4dc23c0dbe3878109c2f844d978ec626

issue: hide unannounced messages from public activity
---

diff --git a/widget/issue/activity.php b/widget/issue/activity.php
index 919ce77..1d1a37a 100644
--- a/widget/issue/activity.php
+++ b/widget/issue/activity.php
@@ -7,6 +7,7 @@ $cols = 'm.*, i.subject, i.updated, i.closed';
 $sql = "SELECT $cols FROM messages m JOIN issues i ON i.id = issue";
 $sql .= " WHERE message IS NOT NULL";
 $sql .= " AND i.page <> 'spam'";
+$sql .= " AND m.announced";
 $sql .= " ORDER BY m.created DESC LIMIT $limit";
 $query = $Db->query($sql);
 $rows = $query->fetchall();