P99 class distribution

[teews08]

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

As I expected with most Emu servers, more druids than anything.
Still need moar wizards!

Out of curiosity, I'm interested in trying a wizard, but really am scared about going oom after 2 spell casts. Seems like I'd pretty much be medding 24/7 with the exception of casting a spell every 5 mins...(maybe not that long, but be honest with me.) My question is, is it really like this? from 1-50?

p.s. I know there are multiple DD spells that wizards can cast, but lets say the best dmg per mana spell.

[Bones]

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

Out of curiosity, I'm interested in trying a wizard, but really am scared about going oom after 2 spell casts. Seems like I'd pretty much be medding 24/7 with the exception of casting a spell every 5 mins...(maybe not that long, but be honest with me.) My question is, is it really like this? from 1-50?

p.s. I know there are multiple DD spells that wizards can cast, but lets say the best dmg per mana spell.

Honestly not sure, I haven't played one.
But any class will have that issue in the lower levels.
Fortunately you could probably cast only once or twice a fight and still equal or exceed any melee dps (in the lower levels anyways)
Once you get higher like at lvl 50 I think your mana pool will be large enough to cast quite a few nukes.

[Ihealyou]

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.

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

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.

[guineapig]

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

Oooh, I like!

[nilbog]

Thanks, ihealyou. That saves me some effort!

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

[Wenai]

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.]

[guineapig]

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

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.]

Nice preemptive strike, and thanks Nilbog!

[guineapig]

25 rangers between 30 and 50!!!.... so tempting to level one up. Yet I can't bring myself to pick that over bard or cleric for the guild.

[dojo420]

you could check for active characters for the last month by adding this to the "where"-clause:

AND (DATEDIFF(now(), character_.timelaston) < 30)

not sure about the exact timestamp type used for that field, but datediff should work with about any timestamp / time / date type.

...i think =/

[Ihealyou]

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

you could check for active characters for the last month by adding this to the "where"-clause:

AND (DATEDIFF(now(), character_.timelaston) < 30)

not sure about the exact timestamp type used for that field, but datediff should work with about any timestamp / time / date type.

...i think =/

Unfortunately there's a problem with that since its an int instead of a date

From the wiki:

timelaston
A timestamp representing the date/time the character was last logged on. While this may be obvious to some, to be perfectly clear, this field actually tracks the timestamp at which the player last logged off. This only came up because trying to use this field as a way of listing online players through a web-tool does not work properly.
This numeric timestamp is easily understood by the internal system routines, but it is not intended to be human-readable, so unless you've got a program to translate the number for you, don't expect to be able to look at this number with the naked eye and immediately tell the date/time it represents.

I couldn't find any more documentation on it, and unless its something like MMDDYYYYHHmm its probably pretty hard to figure out.