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 =/
__________________
Xenu / Shalaya
ɹỊɐ-ləq pəllɐɔ uʍoʇ ɐ ɟo əɔuỊɹd əɥʇ əɯɐɔəq I ʍoɥ noʎ lləʇ ll‚l
əɹəɥʇ ʇɥნỊɹ ʇỊs ʇsnỊ əʇnuỊɯ ɐ əʞɐʇ oʇ əʞỊl p‚I puɐ
uʍop əpỊsdn pəuɹnʇ ´pəddỊlɟ ʇoნ əɟỊl
ʎɯ ʍoɥ ʇnoqɐ llɐ ʎɹoʇs ɐ sỊ sỊɥʇ ʍoN
|