git.shiar.nl
/
minimedit.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
8d719b9
)
issue/activity: ignore messages moved to spam page
author
Mischa POSLAWSKY
<perl@shiar.org>
Sun, 23 May 2021 12:50:29 +0000
(14:50 +0200)
committer
Mischa POSLAWSKY
<perl@shiar.org>
Wed, 22 Sep 2021 15:00:21 +0000
(17:00 +0200)
widget/issue/activity.php
patch
|
blob
|
history
diff --git
a/widget/issue/activity.php
b/widget/issue/activity.php
index 9ce6d530ab403163a66939582e7bfd43941808db..919ce7773e8b696ab4b5c48aaacb888a623ecf86 100644
(file)
--- a/
widget/issue/activity.php
+++ b/
widget/issue/activity.php
@@
-6,6
+6,7
@@
$limit = $Page->place['n'] ?? 50;
$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 .= " ORDER BY m.created DESC LIMIT $limit";
$query = $Db->query($sql);
$rows = $query->fetchall();