From 981af305085c3f31cc80ec5c22c79ebc3a3aec95 Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Wed, 31 Oct 2007 10:45:28 +0100
Subject: BUGFIX: no check for a followup game if someone else already started
 one

several people could start a followup game (or one person hitting reload) and several games were started. Now the prog checks if there is already an active game.
---
 db.php | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'db.php')

diff --git a/db.php b/db.php
index 646f004..4afa9e1 100644
--- a/db.php
+++ b/db.php
@@ -939,5 +939,17 @@ function DB_set_reminder($user,$gameid)
   return 0;
 }
 
+function DB_is_session_active($session)
+{
+  $queryresult = mysql_query("SELECT COUNT(*) FROM Game ".
+			     "  WHERE session=$session ".
+			     "  AND status<>'gameover' ");
+
+  $r = mysql_fetch_array($queryresult,MYSQL_NUM);
+  if($r)
+    return $r[0];
+  else
+    return -1;
+}
 
 ?>
\ No newline at end of file
-- 
cgit v1.2.3-18-g5258