added exams

[banana.git] / admin / sessionoverview.php

diff --git a/admin/sessionoverview.php b/admin/sessionoverview.php
index 77b29b6a17882e6a833722eeccd4afdd65dbd2e3..ab6cd7ef590d6b6767f4bf7115179b203859ec8a 100644 (file)
--- a/admin/sessionoverview.php
+++ b/admin/sessionoverview.php
@@ -24,8 +24,12 @@
     $up_tstamp = trim($_GET['tstamp']);
     $up_editsub = trim($_GET['editsub']);
 
+    if( $up_editsub == "" ) { $up_manydone = 0; }
+    else{ $up_manydone = count(explode(",",$up_editsub)); }
+
     if( $db->query("SELECT COUNT(*) FROM workdone WHERE mnumber=$up_mnumber AND session=$up_sessionid AND tstamp=$up_tstamp")->fetch(PDO::FETCH_NUM)[0] == 0 ) {
-      $db->query("UPDATE workdone SET thisdone='$up_editsub', manydone=" . count(explode(",",$up_editsub)) . ",tstamp=$up_tstamp WHERE mnumber=$up_mnumber AND session=$up_sessionid");
+      $db->query("DELETE FROM workdone WHERE mnumber=$up_mnumber AND session=$up_sessionid");
+      $db->query("INSERT INTO workdone (session,mnumber,thisdone,manydone,tstamp) values ($up_sessionid,$up_mnumber,\"$up_editsub\",$up_manydone,$up_tstamp)");
       block("lightgreen", "modified submit");
     }
   }