From 0dd96314cb0fc3d40502d87f354c6fd61f35a3cd Mon Sep 17 00:00:00 2001
From: arun <arun@nubati.net>
Date: Thu, 8 Feb 2007 19:19:11 +0000
Subject: * rewrote checking for sickness, the player now sees a nice summary
 before getting to the table... * wedding is now announced * for solo and
 normal games, re and contra are assigned correctly * the score for re and
 contra is computed at the end * used one variable $CARDS instead of several
 global ones e.g. $CARDS["trump"] instead of $TRUMP

---
 db.php | 19 ++++++++++++++++++-
 1 file changed, 18 insertions(+), 1 deletion(-)

(limited to 'db.php')

diff --git a/db.php b/db.php
index 8843712..31098d4 100644
--- a/db.php
+++ b/db.php
@@ -417,7 +417,7 @@ function DB_get_all_userid_by_gameid($id)
   $names = array();
   
   $result = mysql_query("SELECT user_id FROM Hand WHERE game_id=".
-			DB_quote_smart($id));
+			DB_quote_smart($id)." ORDER BY position ");
   while($r = mysql_fetch_array($result,MYSQL_NUM))
     $names[] = $r[0];
 
@@ -584,4 +584,21 @@ function DB_get_ruleset($dullen,$schweinchen)
   return -1; /* something went wrong */
 }
 
+function DB_get_party_by_hash($hash)
+{
+  $result = mysql_query("SELECT party FROM Hand WHERE hash=".DB_quote_smart($hash));
+  $r      = mysql_fetch_array($result,MYSQL_NUM);
+  
+  if($r)
+    return $r[0];
+  else
+    return NULL;
+}
+function DB_set_party_by_hash($hash,$party)
+{
+  mysql_query("UPDATE Hand SET party=".DB_quote_smart($party)." WHERE hash=".DB_quote_smart($hash));
+  return;
+}
+
+
 ?>
\ No newline at end of file
-- 
cgit v1.2.3-18-g5258