X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/1e6e0732eb889ea7f8ca17ba467bf2a9a2ff5cbd..f73f2c6c223577ad3cc6e14c0e6ff1567c910eae:/widget/issue/activity.php diff --git a/widget/issue/activity.php b/widget/issue/activity.php index cd99e48..bb694c7 100644 --- a/widget/issue/activity.php +++ b/widget/issue/activity.php @@ -7,28 +7,31 @@ $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"; -$sql = "SELECT * FROM ($sql) x ORDER BY updated DESC, created, id"; # grouped issues $query = $Db->query($sql); print '
'; $group = NULL; while ($row = $query->fetch()) { - $rowuser = new User("profile/{$row->author}"); + print '
'; if ($group !== $row->issue) { $group = $row->issue; - print '
'; printf('%s', $row->page, $row->subject); if ($row->closed) { print ' (opgelost)'; } - print '
'; } - print '
'; - printf('%s %s', - $rowuser->html, showdate(preg_split('/\D/', $row->created)) + print ''; + if ($row->author and $rowuser = new User("profile/{$row->author}")) { + printf('%s ', $rowuser->html); + } + printf('%s', + showdate(preg_split('/\D/', $row->created)) ); - printf("\n\t
%s
", $row->message); + print "
"; + print ''; + print '
'; + print $row->message; print "
\n"; }