X-Git-Url: http://git.shiar.nl/minimedit.git/blobdiff_plain/b130f5a583949b90a36df32be8ce337959759578..0ec5d194ee1838759b2a79c574ebfdca30bc7404:/widget/issue/activity.php diff --git a/widget/issue/activity.php b/widget/issue/activity.php index a153f87..919ce77 100644 --- 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 = [ - "{(?=

\n).+}s" => ' (Meer op de site)', - '{(.*)(

]+>

)\s*}s' => "$2\n$1", + '{(.*)(

]+>

)\s*}s' => "$2$1", + "{(

\n).{20,}}s" => ' (Meer op de site)$1', '{(?<=