Quote:
Originally Posted by dojo420
[You must be logged in to view images. Log in or Register.]
you could check for active characters for the last month by adding this to the "where"-clause:
AND (DATEDIFF(now(), character_.timelaston) < 30)
not sure about the exact timestamp type used for that field, but datediff should work with about any timestamp / time / date type.
...i think =/
|
Unfortunately there's a problem with that since its an int instead of a date
From the wiki:
Quote:
timelaston
A timestamp representing the date/time the character was last logged on. While this may be obvious to some, to be perfectly clear, this field actually tracks the timestamp at which the player last logged off. This only came up because trying to use this field as a way of listing online players through a web-tool does not work properly.
This numeric timestamp is easily understood by the internal system routines, but it is not intended to be human-readable, so unless you've got a program to translate the number for you, don't expect to be able to look at this number with the naked eye and immediately tell the date/time it represents.
|
I couldn't find any more documentation on it, and unless its something like MMDDYYYYHHmm its probably pretty hard to figure out.