title = "Issue #$id";
$row = $Db->query(
'SELECT * FROM issues WHERE id = ?', [$id]
)->fetch();
if (!$row) throw new Exception('Issuenummer niet gevonden');
$Article->title .= ': '.htmlspecialchars($row->subject);
print "{$Article->title}
\n";
print $row->body;
if ($row->closed) {
printf('%s %s
'."\n",
'Opgelost', showdate(preg_split('/\D/', $row->closed))
);
}
$Args = "/$id"; # minimal reference
print placeholder_include('reply');
return;
}
if ($_POST) {
$html = nl2br(htmlspecialchars($_POST['body']));
$html = empty($html) ? NULL : "$html
";
$query = $Db->insert('issues', [
'page' => $Page,
'subject' => $_POST['subject'],
'body' => $html,
'author' => $User->login,
]);
if (!$query->rowCount()) {
throw new Exception('Issue niet opgeslagen.');
}
$_POST = [];
}
$query = $Db->query('SELECT * FROM issues ORDER BY updated DESC');
ob_start();
print '';
while ($row = $query->fetch()) {
printf('- %s %s',
"/$Page/{$row->id}/{$row->link}",
sprintf($row->closed ? '
%s' : '%s',
htmlspecialchars($row->subject)),
showdate(array_slice(preg_split('/\D/', $row->updated), 0, 3))
);
print " \n";
}
print "
\n";
$Place['issuelist'] = ob_get_clean();