P99 class distribution

[Dumesh Uhl'Belk]

so... quick math in my head

Total characters level 40+ : 843

Total tanks 40+ : 110
Total healers 40+ : 279
Total CC 40+ : 108
Total DPS 40+ : 346

Over all, it looks like the server might be a tiny bit light on tanks and CC, but not as drastic as I was expecting.

I wonder what the numbers would look like if it was limited to > 10 hours played in the last 30 days, and if multiple characters on one account, only the one with the highest number of hours. I know this is more than Nilbog can provide atm, but I am just suggesting ways to improve the usefullness of the data we have.

[MogManX44]

112 30-39 druids...thats a bummer maybe i should reroll...

[Bones]

wow.. more lvl 50 clerics than any other class? that's surprising for some reason.

[Xumosa]

so many druids lol...you would think it would be easy to find a port..

[Mordachai]

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

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

From the wiki:


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

it sounds like it is a timestamp in the vein of "# of seconds since January 1, 1970" or something similar, in which case you could convert getdate() into seconds and then subtract that value and then calculate how long?

[Minch/FureeZeb]

tried to save some people some time

[codcereal]

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

tried to save some people some time

You succeeded, thank you!

[Ihealyou]

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

it sounds like it is a timestamp in the vein of "# of seconds since January 1, 1970" or something similar, in which case you could convert getdate() into seconds and then subtract that value and then calculate how long?

I'm bored at work, so I looked it up, and you're right.

Add this to the where clause to get accounts active in the last 30 days

DateDiff(day, DateAdd(second, timelaston, '1/1/1970'), GetDate()) <= 30

[Tallenn]

Definitely short of Pal and SK. Lots of Wars, but I think XP groups generally prefer Knight for tank, and really, how many Wars are going to be needed for raids?

Actually, if you look at it, very few rangers and not many bards, either. Am I the only one that thinks the 40% penalty may be having a significant effect on how many people are willing to play hybrids?

[Mordachai]

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

Definitely short of Pal and SK. Lots of Wars, but I think XP groups generally prefer Knight for tank, and really, how many Wars are going to be needed for raids?

Actually, if you look at it, very few rangers and not many bards, either. Am I the only one that thinks the 40% penalty may be having a significant effect on how many people are willing to play hybrids?

I hope so, it weeds out a lot of people just playing x class to twink it for fun, and leaves most of the rangers/bards people who actually like the class! [You must be logged in to view images. Log in or Register.]