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 .= " ORDER BY m.created DESC LIMIT $limit"; $query = $Db->query($sql); print '
'; $group = NULL; while ($row = $query->fetch()) { print '
'; if ($group !== $row->issue) { $group = $row->issue; printf('%s', $row->page, $row->subject); if ($row->closed) { print ' (opgelost)'; } } print ''; if ($row->author and $rowuser = new User("profile/{$row->author}")) { printf('%s ', $rowuser->html); } printf('%s', showdate(preg_split('/\D/', $row->created)) ); print ""; print '
'; print '
'; print $row->message; print "
\n"; } print "
\n";