P99 class distribution

[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 MogManX44 [You must be logged in to view images. Log in or Register.]

that still wouldnt really be an accurate depiction of class distribution, you arent taking into account the people who joined later and are still leveling their main up.

There really isn't any way to get any accurate numbers with this sort of database query. For instance the database doesn't hold information on which characters are main, twinks or retired.

This is why this poll might give a clearer picture of the current status. I doubt people can be asked to do this poll every month to keep the numbers accurate though, and that's why Nilbog's solution might be better in the long run even considering it's limitations.

[Tallenn]

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

that still wouldnt really be an accurate depiction of class distribution, you arent taking into account the people who joined later and are still leveling their main up.

Not completely accurate, but I think more accurate than including everything (such as all of each class level 10 and up), and I was trying to be as reasonable as possible, rather than asking Nilbog to run 10 different queries for each class.

If it were to be just one query only for each class, I'd say probably 40 and above would give us the best idea, but 4 different queries (the ones I mention above) I think would give us an at least somewhat accurate picture. Of course a separate query for every level would be even more accurate, but that's asking a lot.

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

[JaVeDK]

Seeing as I know almost nothing about programming or SQL databases or whatever that is I won't be even trying, but I do hope someone's willing to help Nilbog out with this.

Interestingly enough I found the command timelaston in the link. If I read it correctly, this might be used to filter characters that have not been active for a while, which could be very helpful towards getting a more meaningful result.

[Xumosa]

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

Seeing as I know almost nothing about programming or SQL databases or whatever that is I won't be even trying, but I do hope someone's willing to help Nilbog out with this.

Interestingly enough I found the command timelaston in the link. If I read it correctly, this might be used to filter characters that have not been active for a while, which could be very helpful towards getting a more meaningful result.

i think the timelaston is just if you want to do a search on 1 single player it tells you last time they are on

not everyone that has logged in after this time

[jilena]

I am sql retarded but something like

SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN '35' AND '50' AND
character_.class = '??' AND
(no clue how this field works exactly but last part should be currenttime minus lasttimeon < 30 days);

Something like that so you basically have characters of that class between 35 and 50 who have logged on in the last 30 days. (I would honestly do 7 days but with the downtime obv that might get a lil weird)

Cuz I'm sure there are tons of 35-50 chars that no one plays. Just showing a list of those that exist really wouldn't give as good a picture as those that actually get logged on.

It would be even better if you had some means of calculating how much /played has occurred in X time period. Since obv a lot of people log on their 50s to farm something or res someone or give someone money or something similar when they actually don't play them much.

lol

[Xumosa]

hmm well hope im doing this right but here it goes...

SELECT COUNT(*) FROM
character_
WHERE
character_.level BETWEEN '35' AND '50' AND
character_.class = '8'

maybe? not sure how to incorporate the timelaston if it does work that way then like jilena stated id implement last 30days :x

[Tallenn]

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'