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.