diff options
| -rw-r--r-- | db.php | 27 | ||||
| -rw-r--r-- | functions.php | 14 | ||||
| -rw-r--r-- | index.php | 18 |
3 files changed, 57 insertions, 2 deletions
@@ -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 @@ -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> |