issue: database insert method to keep array values

[minimedit.git] / widget / reply.php

diff --git a/widget/reply.php b/widget/reply.php
index 3a16e2c0df1d3d54d1c10a255e9ace49a8edb44c..abb364cc1354876b078a0c0a698fc91647b098df 100644 (file)
--- a/widget/reply.php
+++ b/widget/reply.php
@@ -1,5 +1,5 @@
 <?php
-global $User;
+global $User, $Db;
 require_once 'database.inc.php';
 
 print '<h3>Reacties</h3>'."\n";
@@ -16,10 +16,16 @@ if ($_POST) {
                if (!$query->rowCount()) {
                        throw new Exception('Fout bij opslaan');
                }
+               if (@list ($cat, $issue) = explode('/', $Page) and ctype_digit($issue)) {
+                       $Db->query(
+                               'UPDATE issues SET updated = now() WHERE page = ? AND id = ?',
+                               [$cat, $issue]
+                       );
+               }
                $_POST['reply'] = NULL;
        }
        catch (Exception $e) {
-               print '<p class=warn>Antwoord niet opgeslagen.</p>'."\n\n";
+               print "<p class=warn>Antwoord niet opgeslagen: {$e->getMessage()}.</p>\n\n";
        }
 }
 
@@ -37,14 +43,16 @@ while ($row = $query->fetch()) {
        print "</li>\n";
 }
 
-print '<li>';
-print '<form method="post" action="">';
-printf('<textarea id="%s" name="%1$s" cols=60 rows=3 placeholder="%s">%s</textarea>'."\n",
-       'reply',
-       "Bericht van {$User->login}",
-       ''
-);
-print '<input type="submit" value="Plaatsen" />'."\n";
-print "</form></li>\n";
+if ($User) {
+       print '<li>';
+       print '<form method="post" action="">';
+       printf('<textarea id="%s" name="%1$s" cols=60 rows=3 placeholder="%s">%s</textarea>'."\n",
+               'reply',
+               "Bericht van {$User->login}",
+               ''
+       );
+       print '<input type="submit" value="Plaatsen" />'."\n";
+       print "</form></li>\n";
+}
 
 print "</ul>\n\n";