P99 class distribution - Page 4

Ihealyou · #1 04-16-2010, 01:37 PM

Quote:

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

No idea about the timelaston, so I just made those 56 queries (4 per class). I'm not sure about the print statement either. I've never used it, just found it on Internet. If messed up, let me know, I'll fix it.

Code:

PRINT "Warriors Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '1'

PRINT "Warriors Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '1'

PRINT "Warriors Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '1'

PRINT "Warriors Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '1'

PRINT "Clerics Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '2'

PRINT "Clerics Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '2'

PRINT "Clerics Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '2'

PRINT "Clerics Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '2'

PRINT "Paladins Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '3'

PRINT "Paladins Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '3'

PRINT "Paladins Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '3'

PRINT "Paladins Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '3'

PRINT "Rangers Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '4'

PRINT "Rangers Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '4'

PRINT "Rangers Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '4'

PRINT "Rangers Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '4'

PRINT "Shadow Knights Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '5'

PRINT "Shadow Knights Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '5'

PRINT "Shadow Knights Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '5'

PRINT "Shadow Knights Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '5'

PRINT "Druids Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '6'

PRINT "Druids Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '6'

PRINT "Druids Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '6'

PRINT "Druids Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '6'

PRINT "Monks Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '7'

PRINT "Monks Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '7'

PRINT "Monks Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '7'

PRINT "Monks Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '7'

PRINT "Bards Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '8'

PRINT "Bards Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '8'

PRINT "Bards Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '8'

PRINT "Bards Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '8'

PRINT "Rogues Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '9'

PRINT "Rogues Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '9'

PRINT "Rogues Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '9'

PRINT "Rogues Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '9'

PRINT "Shaman Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '10'

PRINT "Shaman Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '10'

PRINT "Shaman Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '10'

PRINT "Shaman Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '10'

PRINT "Necromancers Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '11'

PRINT "Necromancers Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '11'

PRINT "Necromancers Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '11'

PRINT "Necromancers Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '11'

PRINT "Wizards Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '12'

PRINT "Wizards Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '12'

PRINT "Wizards Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '12'

PRINT "Wizards Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '12'

PRINT "Magicians Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '13'

PRINT "Magicians Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '13'

PRINT "Magicians Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '13'

PRINT "Magicians Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '13'

PRINT "Enchanters Level 50: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level ='50' AND
character_.class =  '14'

PRINT "Enchanters Level 46 to 49: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '46' AND '49' AND
character_.class =  '14'

PRINT "Enchanters Level 40 to 45: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '40' AND '45' AND
character_.class =  '14'

PRINT "Enchanters Level 30 to 39: "
SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN  '30' AND '39' AND
character_.class =  '14'

There's an easier way to do this that doesn't require a million queries

Code:

select Character_.class, count(Character_.id) as 'Amount', 
(count(Character_.id) / (select count(Character_.id) from Character_ where Character_.level between @LowerLevel and @UpperLevel)) as '% of Total'
from Character_
where Character_.level between @LowerLevel and @UpperLevel
group by Character_.class
order by Character_.class

just replace @LowerLevel and @UpperLevel and you're good to go. Also, if anyone knows how to parse timelaston you can use it to get current players. I looked around some, but didn't find anything about it.

**nilbog** · #2 04-16-2010, 02:02 PM

Thanks, ihealyou. That saves me some effort!

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

Wenai · #3 04-16-2010, 02:07 PM

http://www.eqemulator.net/wiki/wikka...akka=ClassList

This will cover the next question. [You must be logged in to view images. Log in or Register.]

Spud · #4 04-16-2010, 06:54 PM

Quote:

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

Thanks, ihealyou. That saves me some effort!

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

wow so im just 1 of 57 huh?

112 druids between 30 and 39! wow

I really thought there would be more pal/sks alts 30 and up.

jilena · #5 04-15-2010, 08:17 PM

I think the queries are p worthless though without checking to see who has been on recently lol.

Minch/FureeZeb · #6 04-15-2010, 08:32 PM

not worthless, just not completely accurate

Malrubius · #7 04-15-2010, 08:57 PM

Would be great to see some race stats too (preferably in the same query as the class stuff). But whatever is easy. Easy is way underrated for some things.

JaVeDK · #8 04-15-2010, 09:10 PM

While certainly interesting I don't think knowing the race distribution makes much of a difference, and if doing these queries are a bother, I'd rather we keep it as simple as possible. New players might factor in class distribution when deciding what class to play choosing one less played to the advantage of both the player and server. I don't see the same benefits being gained from race distribution data, as I assume few truly cares if there's a shortage of trolls as long as there's plenty of shamans, SK's and warriors around.

loganhxh · #9 04-15-2010, 09:26 PM

well i mostly agree with you there, as i haven't made my char yet. still flip flopping back and forth between mage or necro, or maybe ench =/ or wiz...
i just know i want to save my melee char for when i am able to twink him some for easier grinding.

but i do know i took a little enjoyment out of being one of the very few female troll warriors back in the day so if i knew there was next to zero of a certain race i would be swayed that way myself.

Taluvill · #10 04-15-2010, 09:55 PM

Thats awesome. I would love to see you use those 56 queries he put up.

Although more druids than you can shake a stick at is pretty accurate, although tbqh most of them are farmers.
Their real mains are in the pre-30's. I would imagine if you sliced the druid number in half, thats the number that are mains and the other half are farmer chars for iksars or for another alt they have.

Edit: in reality, there aren't that many druid mains i don't think, although we do start to become uber come kunark lol

View Poll Results: What class is your main (the character you play the most)
Bard	31	7.01%
Cleric	39	8.82%
Druid	45	10.18%
Enchanter	34	7.69%
Magician	37	8.37%
Monk	28	6.33%
Necromancer	33	7.47%
Paladin	26	5.88%
Ranger	16	3.62%
Rogue	23	5.20%
Shadow Knight	27	6.11%
Shaman	50	11.31%
Warrior	29	6.56%
Wizard	24	5.43%
Voters: 442. You may not vote on this poll