X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/4e8cf4634404ed80dfa8dcb9fb56a577897b9da1..218c239a4dc23c0dbe3878109c2f844d978ec626:/widget/issue/activity.php 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();