Update start and end timestamp

[infodrom.org/service.infodrom.org] / src / InfoCon / stempel / update.wml

diff --git a/src/InfoCon/stempel/update.wml b/src/InfoCon/stempel/update.wml
index 46e2cd6..6084bd4 100644 (file)
--- a/src/InfoCon/stempel/update.wml
+++ b/src/InfoCon/stempel/update.wml
@@ -21,15 +21,18 @@
 
 
   if (isset($_POST['delete'])) {
-    $query = sprintf("DELETE FROM stempel WHERE oid = %s",
+    $query = sprintf("DELETE FROM stempel WHERE oid = %d",
                     $_POST['oid']);
 
     $sth = pg_exec ($dbh, $query);
     echo('<p><strong>Deleted.</strong></p>');
   } else {
-    $query = sprintf("UPDATE stempel SET time=%d, task='%s' WHERE oid = %s",
+    $query = sprintf("UPDATE stempel SET time=%d, start='%s', stop='%s', task='%s', status=%d WHERE oid = %d",
                     hour2min($_POST['time']),
+                    pg_escape_string($dbh, $_POST['start']),
+                    pg_escape_string($dbh, $_POST['stop']),
                     pg_escape_string($dbh, $_POST['task']),
+                    $_POST['status'],
                     $_POST['oid']);
 
     $sth = pg_exec ($dbh, $query);
@@ -38,7 +41,7 @@
 
 ?>
 
-<p>Return to <a href="index.php">Index</a></p>
+<p>Return to <a href="index.php">Index</a>, <a href="edit.php?id=<?=$_POST['oid']?>">edit page</a></p>
 
 </page>