Make public class distribution?

[Rabkorik]

Originally Posted by Ferok [You must be logged in to view images. Log in or Register.]

select class, count(distinct player) from players group by class

This is a very complex sql statement!

[karsten]

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

[Ferok]

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:

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.