From 15e85c12f9392246845f5c611f5faafe8660a9e2 Mon Sep 17 00:00:00 2001
From: arun <arun@nubati.net>
Date: Sat, 3 Feb 2007 04:57:04 +0000
Subject: added session to database

---
 index.php | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'index.php')

diff --git a/index.php b/index.php
index cbcc2f2..e58bae6 100644
--- a/index.php
+++ b/index.php
@@ -63,7 +63,17 @@ else if( myisset("PlayerA", "PlayerB","PlayerC","PlayerD" ))
   if(myisset("followup") )
     {
       $followup= $_REQUEST["followup"];
-      mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre','$followup' ,NULL)");
+      $session = DB_get_session_by_gameid($followup);
+      if($session)
+	mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre','$session' ,NULL)");
+      else
+	{
+	  /* get max session */
+	  $max = DB_get_max_session();
+	  $max++;
+	  mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre','$max' ,NULL)");
+	  mysql_query("UPDATE Game SET session='".$max."' WHERE id=".DB_quote_smart($followup));
+	}
     }
   else
     mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre', NULL ,NULL)");
-- 
cgit v1.2.3-18-g5258