added local time output

3 files changed, 57 insertions, 2 deletions

diff --git a/db.php b/db.php
index 10c5de2..9f00205 100644
--- a/db.php
+++ b/db.php
@@ -349,4 +349,31 @@ function DB_get_all_names()
 
   return $names;
 }
+
+function DB_update_user_timestamp($userid)
+{
+  mysql_query("UPDATE User SET last_login = CURRENT_TIMESTAMP WHERE id=".DB_quote_smart($userid));
+  return;
+}
+
+function DB_get_user_timestamp($userid)
+{
+  $result = mysql_query("SELECT last_login FROM User WHERE id=".DB_quote_smart($userid));
+  $r      = mysql_fetch_array($result,MYSQL_NUM);
+  
+  if($r)
+    return $r[0];
+  else
+    return NULL;
+}
+function DB_get_user_timezone($userid)
+{
+  $result = mysql_query("SELECT timezone FROM User WHERE id=".DB_quote_smart($userid));
+  $r      = mysql_fetch_array($result,MYSQL_NUM);
+  
+  if($r)
+    return $r[0];
+  else
+    return 0;
+}
 ?>
\ No newline at end of file
diff --git a/functions.php b/functions.php
index 49e0a1d..ce48513 100644
--- a/functions.php
+++ b/functions.php
@@ -431,4 +431,18 @@ function display_cards($me,$myturn)
   return;
 }
 
+function return_timezone($offset)
+{
+  switch($offset)
+    {
+    case '1':
+      $zone = "Europe/Berlin";
+      break;
+    default:
+      $zone = "Europe/London";
+    }
+  
+  return $zone;
+}
+
 ?>
\ No newline at end of file
diff --git a/index.php b/index.php
index 7db4399..8385576 100644
--- a/index.php
+++ b/index.php
@@ -171,6 +171,7 @@ else if(isset($_REQUEST["me"]))
 	 exit();
       }
     
+    DB_update_user_timestamp($myid);
     $myname   = DB_get_name_by_hash($me);
     $mystatus = DB_get_status_by_hash($me);
 
@@ -541,7 +542,18 @@ else if(isset($_REQUEST["me"]))
 
     if($ok)
       {
-	echo "ok. your logged in, now what? :)<br />";
+	$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 "ok. your logged in, now what? :) <br />last login: ";
+	echo date("r",$unixtime)."<br />";
+
+	DB_update_user_timestamp($uid);
+
 	$names = DB_get_all_names();
 	echo "<p>registered players:<br />\n";
 	foreach ($names as $name)
@@ -576,7 +588,9 @@ else if(isset($_REQUEST["register"]) )
                <td><input type="password" id="Rpassword" name="Rpassword" size="20" maxsize="30" /></td>
               </tr><tr>
 	       <td><label for="Rtimezone">Timezone:</label></td>
-               <td><input type="text" id="Rtimezone" name="Rtimezone" size="4" maxsize="4" value="+1"/></td>
+               <td>
+                  <input type="text" id="Rtimezone" name="Rtimezone" size="4" maxsize="4" value="+1" />
+	       </td>
               </tr><tr>
                <td colspan="2"> <input type="submit" value="register" /></td>
              </table>