X-Git-Url: http://git.shiar.nl/minimedit.git/blobdiff_plain/6b1d603f5f5265dcfaf005b9c45cc6aaac2f0bc6..af5d5f4037aabc493afa60a5394ab3f8f6134917:/issue/index.php diff --git a/issue/index.php b/issue/index.php index b34da6d..8b42d11 100644 --- a/issue/index.php +++ b/issue/index.php @@ -1,19 +1,25 @@ path, '/')); if ($id and ctype_digit($id)) { - $Article->title = "Issue #$id"; - + $Page->title = "Issue #$id"; + $Page->link = $Page->handler . ($Page->path = "/$id"); # minimal reference $Issue = $Db->query( - 'SELECT * FROM issues WHERE page = ? AND id = ?', [$Page, $id] + 'SELECT * FROM issues WHERE page = ? AND id = ?', [$Page->handler, $id] )->fetch(); if (!$Issue) throw new Exception('Issuenummer niet gevonden'); - $Article->title .= ': '.htmlspecialchars($Issue->subject); - print "

{$Article->title}

\n"; - print "
\n"; + $replies = $Page->widget('reply'); # handle updates + + $Page->title .= ': '.htmlspecialchars($Issue->subject); + $Page->teaser = $Issue->body; + if ($Page->api) return; + $Page->body = $replies; # find image + + print "

{$Page->title}

\n"; + print '
\n\n"; print '
'; print $Issue->body; - $Args = "/$id"; # minimal reference - print placeholder_include('reply'); + print $replies; print "
\n"; return; } @@ -40,7 +45,7 @@ if ($id and ctype_digit($id)) { if ($_POST) { require_once 'upload.inc.php'; $query = $Db->set('issues', [ - 'page' => $Page, + 'page' => $Page->handler, 'subject' => $_POST['subject'], 'body' => messagehtml($_POST['body']), 'author' => $User->login, @@ -50,15 +55,17 @@ if ($_POST) { } $_POST = []; } +if ($Page->api) return; -$cols = "*, (SELECT count(*) FROM comments WHERE" - . " page=i.page||'/'||i.id AND message IS NOT NULL) AS replycount"; +$subsql = "SELECT count(*) FROM comments WHERE page=i.page||'/'||i.id"; +$cols = "*, ($subsql AND message IS NOT NULL) AS replycount"; +$cols .= ", ($subsql AND message ~ 'query($sql, [$Page]); +$query = $Db->query($sql, [$Page->handler]); if ($id == 'feed') { require 'issue/feed.inc.php'; @@ -67,18 +74,29 @@ if ($id == 'feed') { ob_start(); print '\n"; -$Place['issuelist'] = ob_get_clean(); +$Page->place['issuelist'] = ob_get_clean();