issue/activity: ignore messages moved to spam page

[minimedit.git] / widget / issue / activity.php

diff --git a/widget/issue/activity.php b/widget/issue/activity.php
index a153f872c0763d6a7670c28ec1cdfb87bd3d0039..919ce7773e8b696ab4b5c48aaacb888a623ecf86 100644 (file)
--- a/widget/issue/activity.php
+++ b/widget/issue/activity.php
@@ -6,13 +6,14 @@ $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();
 
 $msgformat = [
-       "{(?=</p>\n).+}s" => ' <small class="footer">(Meer op de site)</small>',
-       '{(.*)(<p><img [^>]+></p>)\s*}s' => "$2\n$1",
+       '{(.*)(<p><img [^>]+></p>)\s*}s' => "$2$1",
+       "{(</p>\n).{20,}}s" => ' <small class="footer">(Meer op de site)</small>$1',
        '{(?<=<img src=")(?:/thumb/[^/]+)?(?=/)}' => '/thumb/300x',
 ];