From e68d4598c0d0a5e1f138b9c891f5c1c9ae0e8541 Mon Sep 17 00:00:00 2001
From: arun <arun@nubati.net>
Date: Thu, 7 Jun 2007 18:09:08 +0000
Subject: * FIX: added extra check for calling 120, etc.  so that people can't
 cheat * NEW: display sessions * NEW: display who's turn it is on the userpage
 (change in DB) * NEW: different ways when to say 90, 60, etc.  (change in DB)
 * MISC: some clean up, e.g. display of final score

---
 db.php | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

(limited to 'db.php')

diff --git a/db.php b/db.php
index 64a80b9..935c848 100644
--- a/db.php
+++ b/db.php
@@ -629,6 +629,24 @@ function DB_set_startplayer_by_gameid($id,$p)
   return;
 }
 
+function DB_get_player_by_gameid($id)
+{
+  $result = mysql_query("SELECT player FROM Game WHERE id=".DB_quote_smart($id));
+  $r      = mysql_fetch_array($result,MYSQL_NUM);
+  
+  if($r)
+    return $r[0];
+  else
+    return 0;
+}
+function DB_set_player_by_gameid($id,$p)
+{
+  mysql_query("UPDATE Game SET player='".DB_quote_smart($p)."' WHERE id=".DB_quote_smart($id));
+  return;
+}
+
+
+
 function DB_get_ruleset_by_gameid($id)
 {
   $result = mysql_query("SELECT ruleset FROM Game WHERE id=".DB_quote_smart($id));
@@ -662,6 +680,20 @@ function DB_get_max_session()
     return 0;
 }
 
+function DB_get_hashes_by_session($session,$user)
+{
+  $r = array();
+
+  $result = mysql_query("SELECT Hand.hash FROM Hand".
+			" LEFT JOIN Game ON Game.id=Hand.game_id ".
+			" WHERE Game.session=".DB_quote_smart($session).
+			" AND Hand.user_id=".DB_quote_smart($user));
+  while($t = mysql_fetch_array($result,MYSQL_NUM))
+    $r[] = $t[0];
+
+  return $r;
+}
+
 function DB_get_ruleset($dullen,$schweinchen)
 {
   $r = array();
-- 
cgit v1.2.3-18-g5258