X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/2e1116b155ec54beb89153f37a5f0de90212815c..a257ef8b6e9d435938803471bd655be9d9734370:/issue/index.php diff --git a/issue/index.php b/issue/index.php index fb6a84e..35a1116 100644 --- a/issue/index.php +++ b/issue/index.php @@ -1,64 +1,82 @@ 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"; - $author = $Issue->author ? new User('profile/'.$Issue->author, FALSE) : NULL; - printf('

%s%s %s

'."\n", - 'Geplaatst', - $author ? " door {$author->name}" : '', - showdate(preg_split('/\D/', $Issue->created)) - ); + $replies = $Page->widget('reply'); # handle updates + + $Page->title .= ': '.htmlspecialchars($Issue->subject); + $Page->body = $replies; # find image + if ($Page->api) return; + + print "

{$Page->title}

\n"; + print '\n\n"; + + print '
'; + print $replies; + print "
\n"; return; } -if ($_POST) { - $html = nl2br(htmlspecialchars($_POST['body'])); - $html = empty($html) ? NULL : "

$html

"; +if ($Page->api) return; +if ($_POST and isset($_POST['subject'])) { + require_once 'upload.inc.php'; + if (strlen($_POST['subject']) < 2) { + throw new Exception('Een minimaal onderwerp is verplicht om een issue aan te maken.'); + } $query = $Db->set('issues', [ - 'page' => $Page, + 'page' => $Page->handler, 'subject' => $_POST['subject'], - 'body' => $html, + 'link' => preg_replace('/\b(?:de|het|een)\s+|\W+/', '-', strtolower($_POST['subject'])), 'author' => $User->login, ]); if (!$query->rowCount()) { throw new Exception('Issue niet opgeslagen.'); } + $row = $query->fetch(); + if (!$row->id) { + throw new Exception('Issue niet goed opgeslagen.'); + } + try { + createcomment($_POST, $row); + } + catch (Exception $e) { + throw new Exception("Issueinhoud niet opgeslagen: {$e->getMessage()}."); + } $_POST = []; } -$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) - 1 AS replycount"; +$cols .= ", ($subsql AND message ~ 'query($sql, [$Page]); +$sql .= ' ORDER BY updated DESC'; +$query = $Db->query($sql, [$Page->handler]); if ($id == 'feed') { require 'issue/feed.inc.php'; @@ -67,17 +85,29 @@ if ($id == 'feed') { ob_start(); print '\n"; -$Place['issuelist'] = ob_get_clean(); +$Page->place['issuelist'] = ob_get_clean();