koldchillah
12-08-03, 01:08 PM
It would be awesome to have our own stats system that we could check out on the new SG game server page.
I've been hunting around for some info on how its done, and it really doesn't sound all that complicated.. The main thing would be the database. I guess where and how to host such a database would be the first question. Second, who would be willing to create it (I'm no programmer by any means)?
The following info has been cut & pasted, then paraphrased from various BF sites..:
The entire stats system would need to be done with PHP. Once every hour or so, the database server would run a script which would then connect to the game server and retrieve all the player info. Every hour or so, the data would then be compiled into a table, which would then be queried when we check the stats.
From what I can gather, how to get a servers stats you have to query the server on UDP port 23000 with a \status\ and it will return something like this..
\language\English\location\1033\gamever\v1.1\gamename\bfield1942\version\v1.1\status\3\dedicated\1\p assword\0\gamemode\openplaying\maxplayers\32\numplayers\31\gametype\conquest\mapname\Battle of the Bulge\hostport\14567\hostname\EAUK 15 - BF1942\CPU\980\Vehicle Friendly Fire On Splash\0%\Soldier Friendly Fire On Splash\0%\Kickback On Splash\0\Kickback\0\Name Tag Distance Scope\300\Name Tag Distance\100\Auto Balance Teams\off\Free Camera\off\Bandwidth Choke Limit\0\Axis Team Ratio\1\Allied Team Ratio\1\External View\on\Allow Nose Cam\yes\Ticket Ratio\100%\Game Start Delay\20s\Vehicle Friendly Fire\0%\Soldier Friendly Fire\0%\Spawn Delay\3s\Spawn Wave Time\15s\Number Of Rounds\3\Dedicated\yes\password\0\Time Limit\60\Version\v1.1\queryid\2337.1
Followed by detailed stats on all the players taking part.
It took this person an hour or so to write a php script to do this, claiming its not difficult. Sticking it in a mysql dbase? another hour at most.
What do you fellas think? Would it be realistic to say we could take this to the next level and give it a shot? Any of you guys know PHP & MySQL?
Unfortunately I know very little about programming, but maybe one of you guys might be able to help put this into action.. Even make it so that it only collects data for users that match those of us who play regularly or something.. that way the database doesn't get too large.
Just thought it would be a cool idea.. Maybe I'm shooting off a little far into space here, I don't know.. What do you guys think?
I've been hunting around for some info on how its done, and it really doesn't sound all that complicated.. The main thing would be the database. I guess where and how to host such a database would be the first question. Second, who would be willing to create it (I'm no programmer by any means)?
The following info has been cut & pasted, then paraphrased from various BF sites..:
The entire stats system would need to be done with PHP. Once every hour or so, the database server would run a script which would then connect to the game server and retrieve all the player info. Every hour or so, the data would then be compiled into a table, which would then be queried when we check the stats.
From what I can gather, how to get a servers stats you have to query the server on UDP port 23000 with a \status\ and it will return something like this..
\language\English\location\1033\gamever\v1.1\gamename\bfield1942\version\v1.1\status\3\dedicated\1\p assword\0\gamemode\openplaying\maxplayers\32\numplayers\31\gametype\conquest\mapname\Battle of the Bulge\hostport\14567\hostname\EAUK 15 - BF1942\CPU\980\Vehicle Friendly Fire On Splash\0%\Soldier Friendly Fire On Splash\0%\Kickback On Splash\0\Kickback\0\Name Tag Distance Scope\300\Name Tag Distance\100\Auto Balance Teams\off\Free Camera\off\Bandwidth Choke Limit\0\Axis Team Ratio\1\Allied Team Ratio\1\External View\on\Allow Nose Cam\yes\Ticket Ratio\100%\Game Start Delay\20s\Vehicle Friendly Fire\0%\Soldier Friendly Fire\0%\Spawn Delay\3s\Spawn Wave Time\15s\Number Of Rounds\3\Dedicated\yes\password\0\Time Limit\60\Version\v1.1\queryid\2337.1
Followed by detailed stats on all the players taking part.
It took this person an hour or so to write a php script to do this, claiming its not difficult. Sticking it in a mysql dbase? another hour at most.
What do you fellas think? Would it be realistic to say we could take this to the next level and give it a shot? Any of you guys know PHP & MySQL?
Unfortunately I know very little about programming, but maybe one of you guys might be able to help put this into action.. Even make it so that it only collects data for users that match those of us who play regularly or something.. that way the database doesn't get too large.
Just thought it would be a cool idea.. Maybe I'm shooting off a little far into space here, I don't know.. What do you guys think?