timestamp timezone/offset

Just a query from playing with the PS2 Api.

The timestamp columns. Specifically.

ts, last_login

Are these values influenced by a client setting? I'm seeing some outfit members login 19 to 35 minutes in the future so can only assume the client is reporting their local time.

In addition. ts represents "last updated".

Can anyone clarify what causes an update. Is that automatic every 5 minutes in the game.

Is that on login/logout.

I know outfit resolving "online_status" is in the works - but I was hoping "last_update" might be something like a heartbeat that could be checked in the interim.

 

I belive all times and timestamps in the API are in UTC.

 

character records are currently updated when a user logs out of game.  the timestamps are generally in unix timestamp format.  

 

In EQ2, I think the record is updated on zone-out.