Author Topic: Frag stats updated  (Read 5776 times)

Offline console

  • Brobdingnagian Member
  • ***
  • Posts: 4518
  • "Man, this is the way to travel," said my attorney
    • View Profile
    • tastyspleen.net
  • Rated:
Frag stats updated
« on: June 03, 2006, 08:17:12 PM »
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 ?!!


:rockon:
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

myamagical

  • Guest
Re: Frag stats updated
« Reply #1 on: June 03, 2006, 08:48:43 PM »
Pretty nifty stuff! Thanks console!

=]
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

Offline us/3r

  • Newbie
  • *
  • Posts: 33
    • View Profile
  • Rated:
Re: Frag stats updated
« Reply #2 on: June 04, 2006, 03:14:52 PM »
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.
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus
"Everything has already been said.  Enjoy the music. "
[adult swim]

BigwigKEA

  • Guest
Re: Frag stats updated
« Reply #3 on: June 06, 2006, 12:37:38 PM »
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.
« Last Edit: June 06, 2006, 12:42:25 PM by Bigwig~ »
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

Offline Jay Dolan

  • Swanky Member
  • *****
  • Posts: 644
    • View Profile
    • Quetoo.org
  • Rated:
Re: Frag stats updated
« Reply #4 on: June 07, 2006, 05:29:31 AM »
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

  • Guest
Re: Frag stats updated
« Reply #5 on: June 07, 2006, 07:50:59 AM »
omg quetoo :please:
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

Offline console

  • Brobdingnagian Member
  • ***
  • Posts: 4518
  • "Man, this is the way to travel," said my attorney
    • View Profile
    • tastyspleen.net
  • Rated:
Re: Frag stats updated
« Reply #6 on: June 07, 2006, 08:34:05 AM »
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,

:mrgreen:
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

Offline [BTF]DeathStalker

  • Moderator
  • Swanky Member
  • *****
  • Posts: 968
  • The Beat is Strong
    • View Profile
    • Home of the Great Clan of [BTF]
  • Rated:
Re: Frag stats updated
« Reply #7 on: June 07, 2006, 05:01:09 PM »
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 ????
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

Offline Jay Dolan

  • Swanky Member
  • *****
  • Posts: 644
    • View Profile
    • Quetoo.org
  • Rated:
Re: Frag stats updated
« Reply #8 on: June 08, 2006, 05:29:29 AM »
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.

Offline [BTF]adam

  • Brobdingnagian Member
  • ***
  • Posts: 4047
    • View Profile
    • adam.tastyspleen.net
  • Rated:
Re: Frag stats updated
« Reply #9 on: June 08, 2006, 08:09:35 AM »
#tastyspleen-live on etg.
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

Offline console

  • Brobdingnagian Member
  • ***
  • Posts: 4518
  • "Man, this is the way to travel," said my attorney
    • View Profile
    • tastyspleen.net
  • Rated:
Re: Frag stats updated
« Reply #10 on: June 08, 2006, 08:38:44 AM »
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,

:mrgreen:
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

Offline Jay Dolan

  • Swanky Member
  • *****
  • Posts: 644
    • View Profile
    • Quetoo.org
  • Rated:
Re: Frag stats updated
« Reply #11 on: June 08, 2006, 09:01:24 AM »
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).

Offline console

  • Brobdingnagian Member
  • ***
  • Posts: 4518
  • "Man, this is the way to travel," said my attorney
    • View Profile
    • tastyspleen.net
  • Rated:
Re: Frag stats updated
« Reply #12 on: June 08, 2006, 09:42:15 AM »
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,

:afro:
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

Offline [BTF]DeathStalker

  • Moderator
  • Swanky Member
  • *****
  • Posts: 968
  • The Beat is Strong
    • View Profile
    • Home of the Great Clan of [BTF]
  • Rated:
Re: Frag stats updated
« Reply #13 on: June 08, 2006, 09:22:31 PM »
 :help: I KILLED WALLFLY, TWICE!!!
  • Insightful
    Informative
    Funny
    Nice Job / Good Work
    Rock On
    Flawless Logic
    Well-Reasoned Argument and/or Conclusion
    Demonstrates Exceptional Knowlege of the Game
    Appears Not to Comprehend Game Fundamentals
    Frag of the Week
    Frag Hall of Fame
    Jump of the Week
    Jump Hall of Fame
    Best Solution
    Wins The Internet
    Whoosh! You done missed the joke thar Cletus!
    Obvious Troll Is Obvious
    DO YOU EVEN LIFT?
    DEMO OR STFU
    Offtopic
    Flamebait
    Redundant
    Factually Challenged
    Preposterously Irrational Arguments
    Blindingly Obvious Logical Fallacies
    Absurd Misconstrual of Scientific Principles or Evidence
    Amazing Conspiracy Theory Bro
    Racist Ignoramus

Offline Jay Dolan

  • Swanky Member
  • *****
  • Posts: 644
    • View Profile
    • Quetoo.org
  • Rated:
Re: Frag stats updated
« Reply #14 on: June 09, 2006, 11:33:10 AM »
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  :-X  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.

 :headbang:

 

El Box de Shoutamente

Last 10 Shouts:

Costigan_Q2

November 11, 2024, 06:41:06 AM
"Stay cozy folks.

Everything is gonna be fine."

There'll be no excuses for having TDS after January 20th, there'll be no excuses AT ALL!!!
 

|iR|Focalor

November 06, 2024, 03:28:50 AM
 

RailWolf

November 05, 2024, 03:13:44 PM
Nice :)

Tom Servo

November 04, 2024, 05:05:24 PM
The Joe Rogan Experience episode 223 that dropped a couple hours ago with Musk, they're talking about Quake lol.

Costigan_Q2

November 04, 2024, 03:37:55 PM
Stay cozy folks.

Everything is gonna be fine.
 

|iR|Focalor

October 31, 2024, 08:56:37 PM

Costigan_Q2

October 17, 2024, 06:31:53 PM
Not activated your account yet?

Activate it now! join in the fun!

Tom Servo

October 11, 2024, 03:35:36 PM
HAHAHAHAHAHA
 

|iR|Focalor

October 10, 2024, 12:19:41 PM
I don't worship the devil. Jesus is Lord, friend. He died for your sins. He will forgive you if you just ask.
 

rikwad

October 09, 2024, 07:57:21 PM
Sorry, I couldn't resist my inner asshole.

Show 50 latest
Welcome, Guest. Please login or register.
November 22, 2024, 11:24:00 PM

Login with username, password and session length