P99 class distribution

[JaVeDK]

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

Level.

Ok. I guess if you feel you have, for the time being, made a commitment to play that character to level 50, and that this character is currently your top priority and most played. Does that make sense?

[nilbog]

What I mean is.. if you want to know how many particular people are playing a class above say.. level 10? They have put some time into it and they might play it again.

So, warriors might look like

SELECT
character_.class,
character_.level
FROM
character_
WHERE
character_.class =  '1' AND
character_.level >=  '10'

And the result would be ____ this many.

Trying to save you guys a lot of effort. [You must be logged in to view images. Log in or Register.]

[JaVeDK]

I'm afraid you lost me somewhat with that code stuff. Are you hinting that you will actually be able to pull the exact numbers from the database given certain search parameters?

That would be awesome and a quick way to know for sure, though the true current class distrubution might be somewhat polluted by twinks and retired characters

[nilbog]

Yes. That is why I wanted an easy argument to use with it. Like level. :P

[JaVeDK]

Well in that case your guess/opinion is as good as mine.

Level 10 might work I suppose. Anyone else got some thoughts on this?

[nilbog]

433, btw. On the warriors > 10

I can't/won't be able to do queries everyday, but if it will help new players choose what to be, then find the conditionals that you need.

[Tallenn]

I would say 4 different queries would be all we need to get an idea of what the high end game looks like:
50 (just 50)
46-49
40-45
30-39

That should tell us how many are at top levels, as well as how many will be there shortly. Any levels lower would have too many of chars that people just don't play enough to make a difference.

So, something like:

At level 50, there are:
22 bards
23 clerics
56 druids
etc

At levels 46-49 there are:
28 bards
50 clerics
97 druids
etc

(numbers there are completely made up out of thin air)

[JaVeDK]

Tallenn: That sounds reasonable to me.

Nilbog: If you'd be up for running those 56 queries once or twice a month, and perhaps put them in a sticky, I'm sure many would find that very informative and helpful.

[MogManX44]

that still wouldnt really be an accurate depiction of class distribution, you arent taking into account the people who joined later and are still leveling their main up.

[Xumosa]

look at all those bards/druids! wtb clerics :x

it dosnt have to be completely accurate just a general idea is what it would give/help alot!