P99 class distribution

[JaVeDK]

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

I am a shaman in game. My alt is a ranger.

Remember to vote on the poll too (don't see any shamans or rangers registered yet)

[harojaro91]

I think hes trying to get people to poll for the class that they play the most

[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)

[nilbog]

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.

Yeah, well I'm not gonna be doing that. Large queries on a running database are not good to do.. I was offering this as more of a 1 time deal since the server was down and I was gonna give you some quick answers.

Your census will be better for your goals.

[JaVeDK]

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

Yeah, well I'm not gonna be doing that. Large queries on a running database are not good to do.. I was offering this as more of a 1 time deal since the server was down and I was gonna give you some quick answers.

Your census will be better for your goals.

I see. Well if you could provide the numbers suggested this one time, then that might still prove a valuable reference in analysing the final result.
And thank you very much BTW ;P

[nilbog]

Np, you guys decide on some queries and let me know.

[You must be logged in to view images. Log in or Register.]

http://www.eqemulator.net/wiki/wikka...chemacharacter

SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '1'

etc. I don't have time to do this now, so if someone wants to prepare some good queries, that'd be great. comprehensive and as few total queries as possible please.