X-Git-Url: http://git.shiar.nl/minimedit.git/blobdiff_plain/5adffaba1226d6a75a1937e1ef836f34c991f7fd..ed1cd294e32647b117688b25a465889e4664fe03:/widget/reply.php diff --git a/widget/reply.php b/widget/reply.php index 4c7a304..b740c2a 100644 --- a/widget/reply.php +++ b/widget/reply.php @@ -1,57 +1,109 @@ Reacties'."\n"; +require_once 'upload.inc.php'; if ($_POST) { try { - $html = nl2br(htmlspecialchars($_POST['reply'])); - $html = "

$html

"; - $query = $Db->set('comments', [ - 'page' => $Page, - 'message' => $html, - 'author' => $User->login, - ]); - if (!$query->rowCount()) { - throw new Exception('Fout bij opslaan'); - } - - if (isset($Issue)) { - $row = ['updated' => ['now()']]; - $Db->set('issues', $row, ['id = ?', $Issue->id]); - } + $newcomment = createcomment($_POST, $Issue); + $target = "/{$Page->link}/$newcomment#$newcomment"; + abort($target, ($Page->api ? 200 : 303) . ' reply success'); $_POST['reply'] = NULL; } catch (Exception $e) { + if ($Page->api) { + abort(ucfirst($e->getMessage()), '500 reply error'); + } print "

Antwoord niet opgeslagen: {$e->getMessage()}.

\n\n"; } } -$query = $Db->query('SELECT * FROM comments WHERE page = ? ORDER BY created', [$Page]); +$cols = '*, (SELECT json_agg(journal.*) FROM journal WHERE comment_id = comments.id) AS journal'; +$query = $Db->query("SELECT $cols FROM comments WHERE page = ? ORDER BY created", [$Page->link]); + +if ($row = $query->fetch()) { + print $row->message; + $Page->teaser = $row->raw; +} print '\n\n";