From cf8933299adf0605ccbf40aff3a1a0f920336dc1 Mon Sep 17 00:00:00 2001 From: Joey Schulze Date: Wed, 21 Aug 2019 09:44:35 +0200 Subject: [PATCH] Update start and end timestamp --- src/InfoCon/stempel/update.wml | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/src/InfoCon/stempel/update.wml b/src/InfoCon/stempel/update.wml index d26e267..6084bd4 100644 --- a/src/InfoCon/stempel/update.wml +++ b/src/InfoCon/stempel/update.wml @@ -27,8 +27,10 @@ $sth = pg_exec ($dbh, $query); echo('

Deleted.

'); } else { - $query = sprintf("UPDATE stempel SET time=%d, task='%s', status=%d WHERE oid = %d", + $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']); -- 2.20.1