X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/845c98a6fa7ce005d3830548c042d77b68f7dc31..6b1d603f5f5265dcfaf005b9c45cc6aaac2f0bc6:/issue/index.php?ds=sidebyside diff --git a/issue/index.php b/issue/index.php index 6e13b13..b34da6d 100644 --- a/issue/index.php +++ b/issue/index.php @@ -3,7 +3,7 @@ global $User, $Db; require_once 'database.inc.php'; @list ($id, $title) = explode('/', ltrim($Args, '/')); -if ($id) { +if ($id and ctype_digit($id)) { $Article->title = "Issue #$id"; $Issue = $Db->query( @@ -13,36 +13,36 @@ if ($id) { $Article->title .= ': '.htmlspecialchars($Issue->subject); print "
%s%s %s
'."\n", - 'Geplaatst', - $author ? " door {$author->name}" : '', - showdate(preg_split('/\D/', $Issue->created)) - ); + print "%s aan %s
'."\n", - 'Toegewezen', htmlspecialchars($Issue->assign) - ); + print '%s%s %s
'."\n", - 'Opgelost', '', - showdate(preg_split('/\D/', $Issue->closed)) - ); + print '$html
"; + require_once 'upload.inc.php'; $query = $Db->set('issues', [ 'page' => $Page, 'subject' => $_POST['subject'], - 'body' => $html, + 'body' => messagehtml($_POST['body']), 'author' => $User->login, ]); if (!$query->rowCount()) { @@ -51,21 +51,32 @@ if ($_POST) { $_POST = []; } -$sql = 'SELECT * FROM issues WHERE page = ?'; +$cols = "*, (SELECT count(*) FROM comments WHERE" + . " page=i.page||'/'||i.id AND message IS NOT NULL) AS replycount"; +$sql = "SELECT $cols FROM issues i WHERE page = ?"; if (isset($_GET['open'])) { $sql .= ' AND closed IS NULL'; } $sql .= ' ORDER BY closed IS NOT NULL, updated DESC'; $query = $Db->query($sql, [$Page]); +if ($id == 'feed') { + require 'issue/feed.inc.php'; +} + ob_start(); print '