Quote:
Originally Posted by karsten
[You must be logged in to view images. Log in or Register.]
so, it'd be easy to do? wouldn't it be skewed data though due to peoples' playtimes not being represented, just character levels? also, wouldn't the data be skewed towards level 1s? if good data were easy to get i'd say let's go for it
|
That's the rub.
You could certainly do something like the following:
select class, count(distinct player) from players where level > 5 group by class
Furthermore, you could (I assume) filter based on last login:
Code:
select p.class, count(distinct p.player)
from players p
left outer join accounts a on p.account_id == a.account_id
where p.level > 5 and now() < adddate(a.last_login, interval 7 day)
group by p.class
which would give you (minus some syntax and obviously the fact that I'm taking a shot in the dark at the schema) players over level 5 whose accounts have been active in the past week.
This is all based on data I would expect to be available. There's probably a better way of representing someone's "activity" level, but without knowing the schema it's pretty hard to speculate on.