Player online stats

Legit · Post by **Legit** » Tue Oct 10, 2006 7:02 am

trust em ill prolly make it everytime... lol and how do u egt one of those under ur name anyways? im kinda new to this forum

Jonathan · Post by **Jonathan** » Tue Oct 10, 2006 9:17 am

Do you mean the things like "Outside Corner Grinder"? Those depend on your number of posts. Occasionally our admin, Tank Program, changes someone's to something special. I haven't been a victim of that yet.

Website · Post by **Z-Man** » Tue Oct 10, 2006 9:22 am

Wow, that was fast, Tank

Jonathan · Post by **Jonathan** » Tue Oct 10, 2006 9:24 am

Heh. I was wondering if that was going to happen.

Post by **Lucifer** » Tue Oct 10, 2006 9:31 am

He also sometimes changes people's signatures.

Meow.

Jonathan · Post by **Jonathan** » Tue Oct 10, 2006 9:34 am

Not to mention smiling flags.

Post by **Lucifer** » Tue Oct 10, 2006 10:04 am

Speaking of flags, where'd they go? ANd how long ago did they disappear?

Edit: nvm, went to profile and fixed it.

wrtlprnft · Post by **wrtlprnft** » Tue Oct 10, 2006 3:51 pm

The previous stats were made by hand using the mysql command line client, vim, awk, sort and uniq -c, which would make it a pain to recreate them.
So I made a script that does all this by itself. I'll have it run as cronjob once an hour, so now you can fight for your spots

http://wrtlprnft.ath.cx/playerstats2.htm

Post by **Tank Program** » Tue Oct 10, 2006 6:02 pm

Couldn't resist changing it Jonathan, especially after giving me such a perfect oppurtunity. There actually is a rank for addict though, and I think it's been in place ages. Just, you really have to be addicted to posting here and not have gotten a special rank...

(Which would be hard to avoid if you posted that much...)

Jonathan · Post by **Jonathan** » Tue Oct 10, 2006 6:12 pm

Probably. I guess trying it with a bot isn't a good idea. Not good for the forum, and I don't think it'd reach it before it is stopped at ≤5760 posts per day.

Post by **Tank Program** » Tue Oct 10, 2006 8:19 pm

There's only one person that's close to having it.

Post by **Lucifer** » Tue Oct 10, 2006 8:30 pm

It's not me, is it?

Jonathan · Post by **Jonathan** » Tue Oct 10, 2006 9:13 pm

Either 2500 or 5000?

ed · Post by ed » Tue Oct 10, 2006 9:39 pm

Can your data show other cool stuff.
Like which are the most popular servers? How long they're in use, etc.

wrtlprnft · Post by **wrtlprnft** » Tue Oct 10, 2006 9:51 pm

In theory it can, it just needs a script to do it…
If you want I can give you an account on the server, then you can fool around with it yourself. The database has a size of currently 410MB, so it's a bit much to send it over the network, and I wanna keep it in its raw form so one can do all sorts of statistics on it.
Here's the database structure. “current” has just one row containing the unix time (“stamp”, called “xtime” in the other tables) and id (“time”) of the newest data. “serverinfo” contains contains a row for each server and minute it was queried, together with its “time”. “players” contains a row for each player and minute he/she was online, with “sid” referring to the id of the server.

The naming is bad, and the server names and descriptions are stored every minute, which eats tons of space, but well, this way I get to keep all data