BUGFIX: store canceled games, don't delete them

[e-DoKo.git] / include / db.php

diff --git a/include/db.php b/include/db.php
index 28100a7b8d80b7fbec0493548db5c5738437e1c8..ef902adaf21e73a0bc23f301f14c0a1aaddcb45b 100644 (file)
--- a/include/db.php
+++ b/include/db.php
@@ -61,8 +61,18 @@ function DB_query($query)
   /* debug/optimize the database
   $logfile=fopen('/tmp/DBlog.log','a+');
   fwrite($logfile,"EXPLAIN $query ;\n");
+
+  $time = microtime();
+  $return = mysql_query($query);
+  $time = $time - microtime();
+
+  fwrite($logfile,"time of above query: $time\n");
+
   fclose($logfile);
+
+  return $return;
   */
+
   return mysql_query($query);
 }
 
@@ -961,7 +971,7 @@ function DB_is_session_active($session)
 {
   $r = DB_query_array("SELECT COUNT(*) FROM Game ".
                      "  WHERE session=$session ".
-                     "  AND status<>'gameover' ");
+                     "  AND status IN ('pre','play') ");
   if($r)
     return $r[0];
   else