added game number to game display

[e-DoKo.git] / index.php

diff --git a/index.php b/index.php
index ef047be0f0983f169174417b78b240a810ca9d07..98420418669f997e73418c4c9d13d7cd8ad07202 100644 (file)
--- a/index.php
+++ b/index.php
@@ -140,7 +140,14 @@ else if(myisset("me"))
     $myname   = DB_get_name_by_hash($me);
     $mystatus = DB_get_status_by_hash($me);
     $mypos    = DB_get_pos_by_hash($me);
+
+    echo "<p class=\"gamenumber\"> Game $gameid </p>\n";
+    
+
     
+    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':
@@ -667,7 +674,7 @@ else if(myisset("me"))
          }
        
        $mycards = DB_get_hand($me);
-       mysort($mycards,$gametype);
+       $mycards = mysort($mycards,$gametype);
        echo "<div class=\"mycards\">\n";
        
        if($myturn && !myisset("card"))
@@ -762,11 +769,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))