From 44adf43ccb058fb76e7bdbb18917ca86a7f7ec29 Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Sun, 17 Jun 2007 18:55:34 +0200
Subject: NEW FEATURE: reuse random numbers from old games

random numbers generated for old games are reused in case none
of the players were in that old game. Will be interesting how different
people play with the same hand ;)
---
 db.php | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'db.php')

diff --git a/db.php b/db.php
index 935c848..a444360 100644
--- a/db.php
+++ b/db.php
@@ -764,4 +764,19 @@ function DB_get_PREF($myid)
     return;
 }
 
+function DB_get_unused_randomnumbers($userstr)
+{
+  $queryresult = mysql_query("SELECT randomnumbers,Game.id FROM Game ".
+			     "  LEFT JOIN Hand ON Hand.game_id=Game.id ".
+			     "                 AND  user_id not in (".$userstr.")".
+			     "  GROUP BY  Game.id ".
+			     "  HAVING num=4");
+  
+  $r = mysql_fetch_array($queryresult,MYSQL_NUM);
+  if($r)
+    return $r[0];
+  else
+    return "";
+}
+
 ?>
\ No newline at end of file
-- 
cgit v1.2.3-18-g5258