Make public class distribution? - Page 2

Ferok · #1 03-30-2010, 04:20 PM

No count?

Cilraaz · #2 03-30-2010, 04:29 PM

Yeah, I missed the count and the group by. Trying to get a quick post in during work and guess I went too quick.

Ferok · #3 03-30-2010, 04:35 PM

Quote:

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

Yeah, I missed the count and the group by. Trying to get a quick post in during work and guess I went too quick.

Still fails because you have terms in your select that aren't in your group by, but I know what you mean. This is probably what you meant:

SELECT class, count(distinct id) FROM character_ WHERE timelaston > (UNIX_TIMESTAMP() - 604800) AND level = '50' GROUP BY class;

Fortunately I'm doing SQL migrations this week so looking up syntax looks an awful lot like work!

Cilraaz · #4 03-30-2010, 04:41 PM

http://www.thetimekillers.com/eqemu/test.php

Works fine for me with a limited database to work with. I'll create multiple characters just to fuddle with when I get home tonight.

Took another look at it. Yeah, I don't need the timelaston or level in the select. Drop those and it's a more efficient statement.

Ferok · #5 03-30-2010, 04:47 PM

Quote:

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

http://www.thetimekillers.com/eqemu/test.php

Works fine for me with a limited database to work with. I'll create multiple characters just to fuddle with when I get home tonight.

Guess it just ignores them, since it doesn't make sense to return them.

I'm a little more familiar with MS-SQL, which I'm pretty sure would throw an error there.

Either way, I'm betting that data like this would be done as a nightly / hourly load to the message board db, rather than an on demand directly from the game db. It's not really very important that it's up-to-the-second information. This kind of aggregation isn't overly costly, but more costly than I'm sure it needs to be.

Yiblaan · #6 03-31-2010, 12:10 PM

Thank Prexus I am not a math major

Rabkorik · #7 03-31-2010, 12:47 PM

Quote:

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

Thank Prexus I am not a math major

Math...?

FatMagic · #8 03-31-2010, 12:19 PM

I'd like to see if you guys can get this worked out... it would be cool to see the class distribution on the server.

Cilraaz · #9 03-31-2010, 12:21 PM

Quote:

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

I'd like to see if you guys can get this worked out... it would be cool to see the class distribution on the server.

It would actually be pretty simple to do. It's more a matter of whether the admins want to publicize that information.

BornOfAshes · #10 03-31-2010, 12:37 PM

assuming that the database is MS SQL... I don't think it is though.

but yeah, you should be able to generate a logdump of the active players and then sort them like Ferok suggested above.

I for one would enjoy seeing the results of the queries, it's kind of neat to see trends