Quote:
Originally Posted by Ihealyou
[You must be logged in to view images. Log in or Register.]
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. |
It would be cool to see this run again at the close of the vanilla EQ era and then again 6 months into Kunark.