Prepare for upcoming conversion (errors) and possible debugging.
Restructure earlier posts:
ALTER TABLE comments ADD raw text;
UPDATE comments SET raw = regexp_replace(regexp_replace(raw,
'<br />|<\/?p>', '', 'g'),
E'\n?<img src="/thumb/640x(/.*)" />', E'\n\\1', 'g');
CREATE TABLE comments (
page text,
CREATE TABLE comments (
page text,
message text,
created timestamptz DEFAULT now(),
author text,
message text,
created timestamptz DEFAULT now(),
author text,
if ($_POST) {
require_once 'upload.inc.php';
try {
if ($_POST) {
require_once 'upload.inc.php';
try {
- $html = messagehtml($_POST['reply']);
+ $reply = [];
+ if (isset($_POST['reply']) and $body = $_POST['reply']) {
+ $reply['raw'] = $body;
+ $reply['message'] = messagehtml($body);
+ }
if ($_FILES and !empty($_FILES['image'])) {
$target = 'data/upload';
if (!file_exists($target)) {
if ($_FILES and !empty($_FILES['image'])) {
$target = 'data/upload';
if (!file_exists($target)) {
}
$target .= '/' . $User->login;
if ($result = userupload($_FILES['image'], $target)) {
}
$target .= '/' . $User->login;
if ($result = userupload($_FILES['image'], $target)) {
+ $reply['raw'] .= "/$result";
if (preg_match('(^image/)', $_FILES['image']['type'])) {
if (preg_match('(^image/)', $_FILES['image']['type'])) {
- $html .= sprintf('<p><img src="/thumb/640x/%s" /></p>', $result);
+ $reply['message'] .= sprintf('<p><img src="/thumb/640x/%s" /></p>', $result);
- $html .= sprintf('<p>Bijgevoegd bestand: <a href="/%s" />%s</a></p>',
+ $reply['message'] .= sprintf('<p>Bijgevoegd bestand: <a href="/%s" />%s</a></p>',
$result, basename($result)
);
}
}
}
$result, basename($result)
);
}
}
}
- $query = $Db->set('comments', [
+ $query = $Db->set('comments', $reply + [
'author' => $User->login,
]);
if (!$query->rowCount()) {
'author' => $User->login,
]);
if (!$query->rowCount()) {