started work on canceling games

diff --git a/index.php b/index.php
index 6353f34280feafae3a4a378312bcfc9ebf79a617..38879e91c023738ce0f129f6e75d0c9f2dc2fc6c 100644 (file)
--- 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);
     
     $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':
     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";
        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))
        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>\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))
        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))