+ else
+ {
+ if(strlen($password)!=32)
+ $password = md5($password);
+
+ $ok=1;
+ $uid = DB_get_userid_by_email_and_password($email,$password);
+ if(!$uid)
+ $ok=0;
+
+ if($ok)
+ {
+ $time = DB_get_user_timestamp($uid);
+ $unixtime =strtotime($time);
+
+ $offset = DB_get_user_timezone($uid);
+ $zone = return_timezone($offset);
+ date_default_timezone_set($zone);
+
+ echo "last login: ".date("r",$unixtime)."<br />";
+
+ DB_update_user_timestamp($uid);
+
+ echo "<p>these are the games you are playing in:<br />\n";
+ $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>";
+ 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>".
+ " (clicking here is final and can't be restored)";
+ echo "<br />";
+ }
+ echo "</p>\n";
+
+
+ echo "<p>and these are your games that are already done:<br />Game: \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=\"".$host."?me=".$r[0]."\">#".$r[1]." </a>, ";
+ echo "</p>\n";
+
+ $names = DB_get_all_names();
+ echo "<p>registered players:<br />\n";
+ foreach ($names as $name)
+ echo "$name, \n";
+ echo "</p>\n";
+
+ echo "<p>Want to start a new game? Visit <a href=\"".$host."?new\">this page.</a></p>";
+ }
+ else
+ {
+ echo "sorry email and password don't match <br />";
+ }
+ };