OverloadUT
Stats Monkey
I have spent the last several days working on a project I am calling "Pitboss WebStats" and I finally have a proof of concept I can show off.
Click here to see
What you're seeing is the current state of the Pitboss game I'm playing in, accurate to the last 30 seconds. If someone logs in, logs out, converts to an AI, finishes their turn, etc. it's all logged and viewable on that page. There are also two RSS feeds available on that page. If you're running Firefox, you should see the familiar RSS logo in the address bar. Go ahead and add those feeds to your Bookmarks to see how they work. One is a display of who has and hasn't finished the current turn (thanks to The Obb for the idea) and the second feed is simply a feed of the game log.
The core part of this is accomplished by a pair of scripts:
The first half is an application (the "Uploader") that runs on my Pitboss server machine. It monitors the Pitboss admin window and whenever it sees a change, it uploads the data to my webserver.
The second half is a set of php scripts connected to a MySQL database that can receive the data from the Uploader and store it in the database.
And then of course there are the php scripts that display the pages (the RSS feeds and the page linked above.)
I have several plans for making this better:
One big thing I am contemplating is allowing anybody to use my webserver to display their pitboss game stats. The whole thing is already designed to be able to handle multiple games at once; that works right now in fact. I would probably register a domain like civpitboss.com (any better ideas?) to make it easy for pitboss hosts to have a place that shows their game stats. I would do this if there is a big interest in this program, but not a big interest in setting it up on your own server.
My question to you, the pitboss server hosts: are you interested in this kind of thing? Do you have a php/mysql webserver that you would install the php script on, or would you rather have a public site that you could use to display your Pitboss WebStats?
Click here to see
What you're seeing is the current state of the Pitboss game I'm playing in, accurate to the last 30 seconds. If someone logs in, logs out, converts to an AI, finishes their turn, etc. it's all logged and viewable on that page. There are also two RSS feeds available on that page. If you're running Firefox, you should see the familiar RSS logo in the address bar. Go ahead and add those feeds to your Bookmarks to see how they work. One is a display of who has and hasn't finished the current turn (thanks to The Obb for the idea) and the second feed is simply a feed of the game log.
The core part of this is accomplished by a pair of scripts:
The first half is an application (the "Uploader") that runs on my Pitboss server machine. It monitors the Pitboss admin window and whenever it sees a change, it uploads the data to my webserver.
The second half is a set of php scripts connected to a MySQL database that can receive the data from the Uploader and store it in the database.
And then of course there are the php scripts that display the pages (the RSS feeds and the page linked above.)
I have several plans for making this better:
- Of course a better layout and looks nice.
- Individual player stats. You should be able to tell when the last time each player logged in, how many turns a player has missed, etc.
- Score Graphs?
- Maybe the ability to auto-kick someone out of the game if they miss too many turns in a row. I currently do this manually in our game.
- I'm open to ideas!
One big thing I am contemplating is allowing anybody to use my webserver to display their pitboss game stats. The whole thing is already designed to be able to handle multiple games at once; that works right now in fact. I would probably register a domain like civpitboss.com (any better ideas?) to make it easy for pitboss hosts to have a place that shows their game stats. I would do this if there is a big interest in this program, but not a big interest in setting it up on your own server.
My question to you, the pitboss server hosts: are you interested in this kind of thing? Do you have a php/mysql webserver that you would install the php script on, or would you rather have a public site that you could use to display your Pitboss WebStats?