moved db to admin area and dbscheme to seperate unique file.

[banana.git] / submit.php

diff --git a/submit.php b/submit.php
index aabc3fe3b856ba7e8928d25b5f36c39f232512fb..d64b8da9116ad04f19b76f000f653377f002e1c9 100644 (file)
--- a/submit.php
+++ b/submit.php
@@ -5,7 +5,7 @@
 
   if ( ! isset($SESSIONS_next) ) {
     block("red", "submission closed");
 
   if ( ! isset($SESSIONS_next) ) {
     block("red", "submission closed");

-    break;
+    exit;

   }
 
   if(isset($_POST['submit']) && $_POST['mnumber']!="") {
   }
 
   if(isset($_POST['submit']) && $_POST['mnumber']!="") {


@@ -17,15 +17,14 @@
     $sessionid = $SESSIONS[$SESSIONS_next]['id'];
 
     if($db->query("SELECT COUNT(*) FROM workdone WHERE mnumber = $mnumber AND session = $sessionid")->fetch(PDO::FETCH_NUM)[0] == 1) {
     $sessionid = $SESSIONS[$SESSIONS_next]['id'];
 
     if($db->query("SELECT COUNT(*) FROM workdone WHERE mnumber = $mnumber AND session = $sessionid")->fetch(PDO::FETCH_NUM)[0] == 1) {

-      print '<table bgcolor="red">';
-        print '<tr><th><b><font color="white">You already submitted results for this session</font></b></th><tr>';
+      $db->query("DELETE FROM workdone WHERE mnumber = $mnumber AND session = $sessionid");
+      print '<table bgcolor="lightgreen">';
+        print '<tr><th><b><font color="white">deleted old submission</font></b></th><tr>';

       print '</table>';
       print '</table>';

-      print "You can only submit your calculated examples once!";
-      break;

     }
 
     $excount = count($exchecked);
     }
 
     $excount = count($exchecked);

-    $donestring = implode(', ', $exchecked);
+    $donestring = implode(',', $exchecked);

 
     $db->query("INSERT INTO workdone (mnumber,session,manydone,thisdone) 
         VALUES (\"$mnumber\", \"$sessionid\", \"$excount\", \"$donestring\")");
 
     $db->query("INSERT INTO workdone (mnumber,session,manydone,thisdone) 
         VALUES (\"$mnumber\", \"$sessionid\", \"$excount\", \"$donestring\")");


@@ -33,7 +32,7 @@
     print '<table bgcolor="lightgreen">';
       print '<tr><th><b><font color="white">submitted</font></b></th><tr>';
     print '</table>';
     print '<table bgcolor="lightgreen">';
       print '<tr><th><b><font color="white">submitted</font></b></th><tr>';
     print '</table>';

-    break;
+    exit;

   }
 
 ?>
   }
 
 ?>


@@ -48,7 +47,7 @@
       <th align="left">Mat.nummer:</th> <th align="left"><input type="text" name="mnumber"></th>
     </tr>
     <tr>  
       <th align="left">Mat.nummer:</th> <th align="left"><input type="text" name="mnumber"></th>
     </tr>
     <tr>  

-      <th align="left">Password:</th> <th align="left"><input type="text" name="password"></th>
+      <th align="left">Password:</th> <th align="left"><input type="password" name="password"></th>

     </tr>
  
     <tr><th colspan=2></th></tr>
     </tr>
  
     <tr><th colspan=2></th></tr>