when starting a new game, games can't be selected twice anymore and are randomly...

[e-DoKo.git] / db.php

diff --git a/db.php b/db.php
index 88be2a3fd38fb47ad79a965232c8bd8e4dad5d50..38b788cd70d6c41bce8aa6d013b55be06e555ca9 100644 (file)
--- a/db.php
+++ b/db.php
@@ -236,6 +236,18 @@ function DB_get_hand_status_by_userid_and_gameid($uid,$gid)
     return 0;
 }
 
+function DB_get_sickness_by_userid_and_gameid($uid,$gid)
+{
+  $result = mysql_query("SELECT sickness FROM Hand WHERE user_id=".DB_quote_smart($uid).
+                       " AND game_id=".DB_quote_smart($gid));
+  $r      = mysql_fetch_array($result,MYSQL_NUM);
+  
+  if($r)
+    return $r[0];
+  else
+    return 0;
+}
+
 function DB_get_gameid_by_hash($hash)
 {
   $result = mysql_query("SELECT game_id FROM Hand WHERE hash=".DB_quote_smart($hash));
@@ -249,7 +261,7 @@ function DB_get_gameid_by_hash($hash)
 
 function DB_cancel_game($hash)
 {
-  $gameid = DB_get_gameid_by_hash($me);
+  $gameid = DB_get_gameid_by_hash($hash);
 
   if(!$gameid)
     return;
@@ -500,4 +512,27 @@ function DB_set_startplayer_by_gameid($id,$p)
   return;
 }
 
+function DB_get_session_by_gameid($id)
+{
+  $result = mysql_query("SELECT session FROM Game WHERE id=".DB_quote_smart($id));
+  $r      = mysql_fetch_array($result,MYSQL_NUM);
+  
+  if($r)
+    return $r[0];
+  else
+    return NULL;
+}
+
+function DB_get_max_session()
+{
+  $result = mysql_query("SELECT MAX(session) FROM Game");
+  $r      = mysql_fetch_array($result,MYSQL_NUM);
+  
+  if($r)
+    return $r[0];
+  else
+    return 0;
+}
+
+
 ?>
\ No newline at end of file