Frag stats updated

[console]

Howdy folks,

I'm setting up scripts to generate the frag stats on a month-by-month basis... I plan to automate it so they're up-to-date each night.

Here are the current frag totals for June 2006:

http://tastyspleen.net/quake/stats/frags/

Hard to believe we've had 195,817 frags already this month - it's only June 3rd ?!!

[myamagical]

Pretty nifty stuff! Thanks console!

=]

[us/3r]

wow...I have more frags than deaths...that's a first

And apparently e|Ghandi is the person who killed me the most.....you bastage.
For a pacifist he has some pretty mean aim.

[BigwigKEA]

I always thought this way of putting stats was the best ( http://games.velocity.net/stats/ ) . Would it be hard to implement something like that?

Personnaly I don't really like the .txt used right now. Maybe a nicer and easier way to navigate would be good.

[Jay Dolan]

I was hoping he'd be interested in setting up something like http://jdolan.dyndns.org/stats/stats.php?  It's generated in realtime from a MySQL database.  My Quake2 server dumps frags and chat messages to MySQL as they occur.. so you're able to drop out of the game and check your stats that instant.  I plan to add a lot more to the stats pages eventually, including per-player or per-map stats (bloodiest map, your personal nemesis, your favorite weapon..), random chat quotes, etc.  Frag insertions to the database are rather inexpensive in terms of CPU.  More info about the mod and stats package is here:

http://jdolan.dyndns.org/trac/wiki/Stats
http://jdolan.dyndns.org/jaydolan/files/qmass-README

I'm quite sure that the MySQL related portions of the QMass mod could be borrowed into another mod rather easily, or Vanilla could run the QMass mod if Console wanted to.

[adrenal1ne]

omg quetoo

[console]

I was hoping he'd be interested in setting up something like http://jdolan.dyndns.org/stats/stats.php?  It's generated in realtime from a MySQL database.  My Quake2 server dumps frags and chat messages to MySQL as they occur.. so you're able to drop out of the game and check your stats that instant.  I plan to add a lot more to the stats pages eventually, including per-player or per-map stats (bloodiest map, your personal nemesis, your favorite weapon..), random chat quotes, etc.  Frag insertions to the database are rather inexpensive in terms of CPU.

Cool.  I'd started work on something like this last year, using PostgreSQL.  One of the challenges I faced was that some of our servers run on systems I don't have easy access to (the euro servers) or on Windows boxes (some of Gator's servers).  Also, the main tastyspleen.net CPU is overtaxed as it is, so I want the database engine running on another workhorse server I have.  One possible solution I considered, was to parse the wallfly logs in realtime, since no matter how remote the q2 server, all the wallfly logs end up on the same box.

However, what stopped me from using the wallfly logs, is wallfly gets dropped from the game occasionally, for a brief moment, and has to reconnect.  So it's possible for its logs to miss a few frags here and there.

I suppose I could split the difference, and use a different more reliable mechanism for the servers I do have direct access to, and make do with wallfly for the rest. 

So anyway, I've been thinking about the issues... real-time stats are definitely where I've wanted to end up.  On the FFA servers, I might want to make a gong go off in the middle of a game when someone beats the highstreak for this month, etc., or sets a new FPH record for a map...  Or update the server's MOTD to show that info, at least for the subset of servers where I have programmatic access to the MOTD file.

Ultimately I need a solution that works for remote servers, whether they're hosted on windoze or unix.

So that's my current situ. 

I'll definitely check out your system tho...

Thanks,

[[BTF]DeathStalker]

Just a thought, but Csports.net "used to" keep up with stats and ranks pretty good. It sucks now, but it still somewhat ranks you.
What about using something like what they use ????

[Jay Dolan]

How does Wallfly work?  Is he some false client you've written?  I didn't realize he was an actual program or bot.  I thought maybe you'd just hacked up the server status function to make it look like someone was playing   Having one thing that already sits on your servers would make this significantly easier than finding the source for, and patching, all the mods you run.

[[BTF]adam]

#tastyspleen-live on etg.

[console]

How does Wallfly work?  Is he some false client you've written?  I didn't realize he was an actual program or bot.  I thought maybe you'd just hacked up the server status function to make it look like someone was playing   Having one thing that already sits on your servers would make this significantly easier than finding the source for, and patching, all the mods you run.

Actually, it's easier than all of the above.  All of our admin scripts were written back when we only had rcon on xquake.  There was no way to patch the server or the mod.  Thus, the entire system operates over rcon, with wallfly being a hacked text-only client that connects in order to provide the system with a feed of the live player chat and obituaries.

So on the plus side, when someone puts up new servers, all I need is rcon and I can include the servers in the admin pool.  (The euro servers are the most recent example of servers for which I only have rcon.)

On the downside, the system has to make do with the capabilities provided by quake2's rcon (and q2admin, if available.)

But all in all, it works reasonably well.

Regards,

[Jay Dolan]

So extending Wallfly with a database backend wouldn't be terribly difficult, and you'd be able to simultaneously log all game activity to one database with one ODBC connection.  If you're able to procure the hardware resources, I'd be willing to help out with the programming if you like (both to Wallfly, and the stats page scripting).

[console]

Hmmm... thanks!

Well, the trouble with wallfly is it gets disconnected sometimes.  (Albeit, briefly.)

But since most of the servers I have ssh access to, my current plan is to:

  ssh 'tail -f' ... on every server log I have access to, and
  'tail -f' the local wallfly logs for servers I don't have ssh access to.

So I get 20-odd streams... I'll have a ruby script parsing the streams and updating a PostgreSQL database.

Somethin' like that.


Regards,

[[BTF]DeathStalker]

  I KILLED WALLFLY, TWICE!!!

[Jay Dolan]

But since most of the servers I have ssh access to, my current plan is to:

  ssh 'tail -f' ... on every server log I have access to, and
  'tail -f' the local wallfly logs for servers I don't have ssh access to.

So I get 20-odd streams... I'll have a ruby script parsing the streams and updating a PostgreSQL database.

Without any disrespect intended at all.. that sounds like a horrible and inefficient hack    If Wallfly drops, so will ssh (perhaps less often, but still..).  You're introducing yet another open connection on each box, plus the cpu resources required to encrypt data that you really needn't encrypt, plus the overhead of a parsing script that has to select() or poll() ~20 streams.  Ssh also automatically times out after some interval, which you would need to have disabled or increased on each server, unless you want to try to monitor each ssh session as well..  I dunno, man.  Seems clear to me that adding a few lines of ODBC to Wallfly is half as hard and complex.  But you know what you're doing, and I'll leave it at that.  Again, no disrespect intended at all.  I'm a database programmer by profession, just offering my $.02.