timezone alter time

[everlifefree]

I was wondering if you could help me make it so that my users last login and online since will so the proper time relating to there timezone instead of just the time on the server. When my user sign up the enter a variable into the database of like "US mountain time would be -7" and the variable "-7" in stored in the database table users under the timezone section thing... Please help!

 

heres the current php used:

 

/* Figure out if the user is online or not */

if (_fnc("user", $_GET["id"], "last_load") > (date("U") - 180)) {

$tpl -> Zone("onlinecheck", "online");

$tpl -> AssignArray(array(

"onlinesince" => date($CONF["LOCALE_SHORT_TIME"], _fnc("user", $_GET["id"], "last_login")),

"online.object" => $GLOBALS["OBJ"]["online"]

));

 

} elseif (_fnc("user", $_GET["id"], "last_login") != 0) {

$tpl -> Zone("onlinecheck", "offline");

$tpl -> AssignArray(array(

"lastlogin" => date($CONF["LOCALE_SHORT_DATE_TIME"], _fnc("user", $_GET["id"], "last_login")),

"online.object" => NULL

));

 

} else {

$tpl -> Zone("onlinecheck", "nologin");

$tpl -> AssignArray(array(

"lastlogin" => NULL,

"online.object" => NULL

));

}

 

 

[revraz]

This is what I do

 

$offset = (60 * 60) * $_SESSION['offset'];

<?php echo  date('m/d/Y-H:i',$row->ndate + $offset);?>

 

Where $_SESSION['offset'] is like -3 or whatever the offset value is for them.

[everlifefree]

but how to I get the offset to automaticly change to the correct +/- whatever that is listed in the database table "users" under the timezone area 

[revraz]

$_SESSION['offset'] is set when they login and the DB is queried.

[everlifefree]

HUH?? sorry I'm sort of new to this whole php scriptting I have only figured out the very very basics of how it all works. So is the offset set in like the database for each user or what

[revraz]

For me it is, and according to this post, it seems it is for you too.

 

but how to I get the offset to automaticly change to the correct +/- whatever that is listed in the database table "users" under the timezone area 

[everlifefree]

well right now it is set in my database under timezone does it need a further code to acquire it or do I need to just simple change the timezone to offset?? Still very confused could you please in detail explain how this works...

[everlifefree]

Could anyone give me more details here??