* 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

1 files changed, 18 insertions, 1 deletions

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