From cfb7c888c30e08e04c83dd818dea1dbd4274d303 Mon Sep 17 00:00:00 2001
From: arun <arun@nubati.net>
Date: Fri, 26 Jan 2007 11:59:05 +0000
Subject: started work on canceling games

---
 index.php | 15 +++++++++++++--
 1 file changed, 13 insertions(+), 2 deletions(-)

diff --git a/index.php b/index.php
index 6353f34..38879e9 100644
--- a/index.php
+++ b/index.php
@@ -141,6 +141,9 @@ else if(myisset("me"))
     $mystatus = DB_get_status_by_hash($me);
     $mypos    = DB_get_pos_by_hash($me);
     
+    if(myisset("cancle"))
+      echo "<p style=\"background-color:red\";>canceling a game is not implemented at the moment, but will be soon...<br /><br /></p>";
+
     switch($mystatus)
       {
       case 'start':
@@ -762,11 +765,19 @@ else if(myisset("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'" );
+	$result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.mod_date from Hand".
+			      " LEFT JOIN Game On Hand.game_id=Game.id".
+			      " WHERE Hand.user_id='$uid' AND Game.status<>'gameover'" );
 	while( $r = mysql_fetch_array($result,MYSQL_NUM))
-	  echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a><br />";
+	  {
+	    echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a>";
+	    if(time()-strtotime($r[2]) > 60*60*24*30)
+	       echo " The game has been running for over a month. Do you want to cancel it? <a href=\"$host?cancle=1&me=".$r[0]."\">yes</a>";
+	    echo "<br />";
+	  }
 	echo "</p>\n";
 
+
 	echo "<p>and these are your games that are already done:<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))
-- 
cgit v1.2.3-18-g5258