X-Git-Url: http://git.shiar.nl/minimedit.git/blobdiff_plain/aee71926fef0a65076c0c40b4c3280506dec5aba..58c5ec6b45dcc52107f5e7c8bbca2933c7f2e98d:/widget/issue/activity.php?ds=inline diff --git a/widget/issue/activity.php b/widget/issue/activity.php index 7829f93..919ce77 100644 --- a/widget/issue/activity.php +++ b/widget/issue/activity.php @@ -3,25 +3,56 @@ global $Db; require_once 'database.inc.php'; $limit = $Page->place['n'] ?? 50; -$cols = 'm.*, i.subject, i.closed'; +$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(); -print '\n"; +print "\n";