I am sql retarded but something like
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN '35' AND '50' AND
character_.class = '??' AND
(no clue how this field works exactly but last part should be currenttime minus lasttimeon < 30 days);
Something like that so you basically have characters of that class between 35 and 50 who have logged on in the last 30 days. (I would honestly do 7 days but with the downtime obv that might get a lil weird)
Cuz I'm sure there are tons of 35-50 chars that no one plays. Just showing a list of those that exist really wouldn't give as good a picture as those that actually get logged on.
It would be even better if you had some means of calculating how much /played has occurred in X time period. Since obv a lot of people log on their 50s to farm something or res someone or give someone money or something similar when they actually don't play them much.
lol
|