From e70edfecc1252420ceb06f55a97e1f14f76a767a Mon Sep 17 00:00:00 2001
From: arun <arun@nubati.net>
Date: Fri, 8 Dec 2006 21:22:37 +0000
Subject: [PATCH] bugfix? game entry wasn't added to DB, hope it is fixed now

---
 functions.php |  2 +-
 index.php     | 23 ++++++++++++++++++++---
 2 files changed, 21 insertions(+), 4 deletions(-)

diff --git a/functions.php b/functions.php
index c955d5c..1c7b29b 100644
--- a/functions.php
+++ b/functions.php
@@ -6,7 +6,7 @@
 
 $host  = "http://doko.nubati.net/database/index.php";
 $wiki  = "http://wiki.nubati.net/index.php?title=EmailDoko";
-$debug = 0;
+$debug = 1;
 
 $last=-2;
 
diff --git a/index.php b/index.php
index 8385576..4a38ed8 100644
--- a/index.php
+++ b/index.php
@@ -98,8 +98,13 @@ else if( isset($_REQUEST["PlayerA"]) &&
     
     /* create game */
     $followup = NULL;
-    if(isset($_REQUEST["followup"])) $followup= $_REQUEST["followup"];
-    mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', NULL, NULL,'pre',$followup ,NULL)");
+    if(isset($_REQUEST["followup"])) 
+      {
+	$followup= $_REQUEST["followup"];
+	mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', NULL, NULL,'pre','$followup' ,NULL)");
+      }
+    else
+      mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', NULL, NULL,'pre', NULL ,NULL)");
     $game_id = mysql_insert_id();
     
     
@@ -289,7 +294,13 @@ else if(isset($_REQUEST["me"]))
       case 'gameover': /* gameover and play, so that the tricks are visible for both */
 	display_news();
 	display_status();
-		
+
+	$gamestatus =DB_get_game_status_by_gameid($gameid);
+	if($gamestatus == 'pre')
+	  {
+	    echo "you need to wait for the others... <br />";
+	    break;
+	  }
 	/* get trick ids */
 	$result = mysql_query("SELECT Hand_Card.card_id as card,".
 			      "       User.fullname as name,".
@@ -554,6 +565,12 @@ else if(isset($_REQUEST["me"]))
 
 	DB_update_user_timestamp($uid);
 
+	echo "<p>these are the games you are playing in:<br />\n";
+	$result = mysql_query("SELECT hash,game_id from Hand WHERE user_id='$uid' AND status<>'gameover'" );
+	while( $r = mysql_fetch_array($result,MYSQL_NUM))
+	  echo "<a href=\"http://doko.nubati.net/database/index.php?me=".$r[0]."\">game #".$r[1]." </a><br />";
+	echo "</p>\n";
+
 	$names = DB_get_all_names();
 	echo "<p>registered players:<br />\n";
 	foreach ($names as $name)
-- 
2.25.1