June 01, 2023, 01:25:32 pm

The Gang Garrison 2 Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

NOTICE: Due to a rise in bot activity, new posters need to be approved before posting.

Join the community Discord server!

Pages: [1] 2

Author Topic: [Server plugin] Stat collection plugin  (Read 4407 times)

ajf

  • (Ex-?)Developer and forum/web admin
  • *****
  • Karma: 7
  • Offline Offline
  • Posts: 3493
  • she's never quite as dead as you think
[Server plugin] Stat collection plugin
« on: October 13, 2013, 08:50:43 am »

This is a plugin for server hosts. It's not server-sent, it runs on your server. It doesn't activate when you're playing on another server.

It sends a bunch of stats at the end of each round to my server:
  • GG2 version
  • Server name
  • Server IP and port
  • Map
  • Winning team
  • Game mode (+ number of control points and whether there's a setup gate if CP)
  • Timer and time limit (if applicable)
  • Respawn time (if applicable)
  • Red/blue caps (if CP)
  • Red/blue wins (if arena)

Plus this info about each player:
  • Name (not sent since version 1.1 after wareya objected - fair enough)
  • Team
  • Class
  • Whether they have queueJump enabled

And all thirteen stats about each player:
  • Kills
  • Deaths
  • Caps
  • Assists
  • Destruction
  • Stabs
  • Healing
  • Defenses
  • Invulns
  • Bonus
  • Dominations
  • Revenge
  • Points

And that's all. The data is sent silently and automatically, and if it fails to send, it will not crash your server. All the data is publicly available at http://stats.ajf.me/

This is not supposed to be some evil NSA spying program. All this info is available publicly anyway if you join a server. I'm just making a way to automatically collect it.

So, why send all this data? Well, we can build up a database of GG2 games with it. This is useful because we can see if certain game modes are biased one way or the other, or how respawn times affect things, or how many people use queueJump, etc. While the interface atm is very primitive, it's all backed by a proper SQLite database, so all sorts of interesting queries could be run.

Running a server and interested in joining this project to gather stats?

Download v1.2.1 now!
(it's a zip file, extract the files into your Plugins folder. onroundend.gml needs to be at Plugins\Stats\onroundend.gml to work.)
« Last Edit: February 01, 2014, 02:57:20 pm by ajf »
Logged
did you know that spinning stars work like this???

I've seen things you people wouldn't believe. execute_strings on fire off the shoulder of Overmars. I watched object-beams glitter in the dark near the room_goto_fix. All those moments will be lost in time, like tears...in...rain. Time to die.

Danikah

  • Guest
Re: [Server plugin] Stat collection plugin
« Reply #1 on: October 13, 2013, 09:42:21 am »

Logged

Phantom Brave

  • All Hail Classicwell
  • Moderator
  • *****
  • Karma: 70
  • Offline Offline
  • Posts: 12700
  • Another one --
Re: [Server plugin] Stat collection plugin
« Reply #2 on: October 13, 2013, 09:48:10 am »

Yes, there's an option in gg2.ini as of a few versions ago which enables cpma/QL style queued jumping.
Logged

http://steamcommunity.com/id/wareya/
ladies and gentlemen i would like to announce that the fact of the matter is up that the fact of the matter is a fact and it matters

Danikah

  • Guest
Re: [Server plugin] Stat collection plugin
« Reply #3 on: October 13, 2013, 09:54:25 am »

Yes, there's an option in gg2.ini as of a few versions ago which enables cpma/QL style queued jumping.
Pardon me, I still don't understand.
Logged

Phantom Brave

  • All Hail Classicwell
  • Moderator
  • *****
  • Karma: 70
  • Offline Offline
  • Posts: 12700
  • Another one --
Re: [Server plugin] Stat collection plugin
« Reply #4 on: October 13, 2013, 10:10:05 am »

It means that when you press your jump button, but can't jump, and hold it down until you can jump, you will hold the moment that you can first jump. So it's easier to do platforming on laggy servers.
Logged

http://steamcommunity.com/id/wareya/
ladies and gentlemen i would like to announce that the fact of the matter is up that the fact of the matter is a fact and it matters

notarctic

  • just arctic, what gives?
  • ******
  • Karma: 8
  • Offline Offline
  • Posts: 4904
  • 👎👀 bad aim ba̷̶ ԁ aIm 👎 thats❌ some bad 👎👎aim
    • arcticland
Re: [Server plugin] Stat collection plugin
« Reply #5 on: October 13, 2013, 12:39:52 pm »

So it's easier to do platforming on laggy servers.
ohhhhhhh, thats what its for, i thought its just some nice bunny hop like feature to play around with.
Logged
[1:37:51 PM] Derpduck: arctic u need to quote ppl that make shit posts in case they edit them
[4:20:15 PM] Rubeus Hashgrid: i cant discover anything fuck you imageshack

cabalier

  • Mega-Weeaboo Extraordinaire
  • **
  • Karma: 4
  • Offline Offline
  • Posts: 1968
  • water
Re: [Server plugin] Stat collection plugin
« Reply #6 on: October 13, 2013, 12:49:43 pm »

remember a couple months back I tried to get everyone to manually collect their stats in a spreadsheet
good times

ajf

  • (Ex-?)Developer and forum/web admin
  • *****
  • Karma: 7
  • Offline Offline
  • Posts: 3493
  • she's never quite as dead as you think
Re: [Server plugin] Stat collection plugin
« Reply #7 on: October 13, 2013, 12:52:22 pm »

Code: [Select]
sqlite> SELECT COUNT(*) FROM game WHERE gameMode = 'cp' AND winner = 1 AND controlPoints = 2 and setupGate=1;
1
sqlite> SELECT COUNT(*) FROM game WHERE gameMode = 'cp' AND winner = 0 AND controlPoints = 2 and setupGate=1;
9

yeah so a/d is pretty biased against BLUE (winner = 0 is RED, winner = 1 is BLUE)
Logged
did you know that spinning stars work like this???

I've seen things you people wouldn't believe. execute_strings on fire off the shoulder of Overmars. I watched object-beams glitter in the dark near the room_goto_fix. All those moments will be lost in time, like tears...in...rain. Time to die.

Nova

  • Seasoned Member
  • *****
  • Karma: 4
  • Offline Offline
  • Posts: 1740
  • Personal Text
Re: [Server plugin] Stat collection plugin
« Reply #8 on: October 13, 2013, 01:04:52 pm »

AJF-SA.
Logged

ajf

  • (Ex-?)Developer and forum/web admin
  • *****
  • Karma: 7
  • Offline Offline
  • Posts: 3493
  • she's never quite as dead as you think
Re: [Server plugin] Stat collection plugin
« Reply #9 on: October 13, 2013, 01:27:28 pm »

AJF-SA.
?

Anyhow, I've cleared the DB (doesn't matter, we'll collect plenty of new stats), but now there are timestamps. I also merged caps and wins.

Because of the caps/wins merger, I made Version 1.2 (download here), though there's no need to update to it as the server-side code will, for backwards-compatibility, accept winsRed and winsBlue as well as capsRed and capsBlue. Timestamps are server-side too.

Have fun y'all.
Logged
did you know that spinning stars work like this???

I've seen things you people wouldn't believe. execute_strings on fire off the shoulder of Overmars. I watched object-beams glitter in the dark near the room_goto_fix. All those moments will be lost in time, like tears...in...rain. Time to die.

notarctic

  • just arctic, what gives?
  • ******
  • Karma: 8
  • Offline Offline
  • Posts: 4904
  • 👎👀 bad aim ba̷̶ ԁ aIm 👎 thats❌ some bad 👎👎aim
    • arcticland
Re: [Server plugin] Stat collection plugin
« Reply #10 on: October 13, 2013, 01:58:59 pm »

ajf-sa
N-sa
Logged
[1:37:51 PM] Derpduck: arctic u need to quote ppl that make shit posts in case they edit them
[4:20:15 PM] Rubeus Hashgrid: i cant discover anything fuck you imageshack

ajf

  • (Ex-?)Developer and forum/web admin
  • *****
  • Karma: 7
  • Offline Offline
  • Posts: 3493
  • she's never quite as dead as you think
Re: [Server plugin] Stat collection plugin
« Reply #11 on: October 13, 2013, 04:24:07 pm »

ajf-sa
N-sa
oh I get it

it's not very comparable to the NSA tho
Logged
did you know that spinning stars work like this???

I've seen things you people wouldn't believe. execute_strings on fire off the shoulder of Overmars. I watched object-beams glitter in the dark near the room_goto_fix. All those moments will be lost in time, like tears...in...rain. Time to die.

ajf

  • (Ex-?)Developer and forum/web admin
  • *****
  • Karma: 7
  • Offline Offline
  • Posts: 3493
  • she's never quite as dead as you think
Re: [Server plugin] Stat collection plugin
« Reply #12 on: October 14, 2013, 07:13:22 am »

Code: [Select]
sqlite> SELECT COUNT(*) FROM game WHERE gameMode = 'cp' AND winner = 0 AND controlPoints = 2 and setupGate = 1;
15
sqlite> SELECT COUNT(*) FROM game WHERE gameMode = 'cp' AND winner = 1 AND controlPoints = 2 and setupGate = 1;
9

15:9 RED:BLU wins on A/D. Interesting. So RED wins 62.5% of the time on A/D. Not as bad as I thought actually.
Logged
did you know that spinning stars work like this???

I've seen things you people wouldn't believe. execute_strings on fire off the shoulder of Overmars. I watched object-beams glitter in the dark near the room_goto_fix. All those moments will be lost in time, like tears...in...rain. Time to die.

ajf

  • (Ex-?)Developer and forum/web admin
  • *****
  • Karma: 7
  • Offline Offline
  • Posts: 3493
  • she's never quite as dead as you think
Re: [Server plugin] Stat collection plugin
« Reply #13 on: October 14, 2013, 08:11:34 am »

I made an S&T thread:

Now that I have my stat database, is there anything you'd like me to check?

Most recent post there is by me, with a better A/D check. Turns out when there are actual players, A/D is pretty damn biased.
« Last Edit: October 14, 2013, 08:11:57 am by ajf »
Logged
did you know that spinning stars work like this???

I've seen things you people wouldn't believe. execute_strings on fire off the shoulder of Overmars. I watched object-beams glitter in the dark near the room_goto_fix. All those moments will be lost in time, like tears...in...rain. Time to die.

Nova

  • Seasoned Member
  • *****
  • Karma: 4
  • Offline Offline
  • Posts: 1740
  • Personal Text
Re: [Server plugin] Stat collection plugin
« Reply #14 on: October 14, 2013, 12:52:59 pm »

Make it sortable on the webpage. By Server-Name/Winner/Amount of players etc. etc.
Logged
Pages: [1] 2
 

Page created in 0.038 seconds with 37 queries.