Game Server Stats & Status Downloads

How are you doing the stats I haven't seen anythign useful in either log files to make stats on? Are you just polling the server like every 30 seconds and getting the updated kills that way? Curious as I want to make a stats program for my server.

TIA

LoRdNaTaS · October 8, 2004

correct I am getting info from the specified server and updated based on kills, deaths, teams, and maps

Alegis · October 8, 2004

Be sure to add the server stats to lucasfiles when you got php done

LoRdNaTaS · October 8, 2004

I had planned on it.. I should have it done this weekend. I am still testing on it right now..

LoRdNaTaS · October 10, 2004

Due to a little test on my server the php version of the stats will not be released this week. Due to the lack of intrest in the server over the weekend I could not get enough people on at one time to get the system stable. I should be working on it the rest of this week and next weekend so hopefully by the following week I should have a release.

Sorry guys.

If you are curious on what test I ran this weekend please see this post:

http://www.lucasforums.com/showthread.php?s=&threadid=137716

LoRdNaTaS · October 12, 2004

Ok thanks to not having the tps set above the default limit.

I actually had people on the server for the past 3 hours.

So I actually go some testing done on the SWBF Server Stats PHP Version.

It looks like all the bugs are out of the system but I want to run it one more day to make sure. This will also give me time to clean up my code and add some comments. I should be able to release it on Thursday.

If you want to check out the progress then go here

http://www.apocalypce.net/swbf_stats/index2.php

vwjoker · October 12, 2004

Great going there LoRdNaTaS.

I'm kinda looking forward to that once you release it.... um just outta interest, is the back end to that using mySQL?

LoRdNaTaS · October 12, 2004

currently yes..

I play on modify it to work with just about any db..

But I just wanted to get a working copy of the php stats out asap. The next port will work with postgres..

I will probabaly not add much WinBlows support to it unless there is a call for it. Seeing most of the admin here want a Linux port of the server I figure I am some what safe setting up for just that.

vwjoker · October 12, 2004

Yeah, prolly the best (and safest) route.

Shame, I'll have to dust off the old linux machine and fire her up.... I'm running the dedicated server on one of my own desktop machines, plus abyss web server, and a cut down winblows php.... I tried installing mysql and it wasnt best happy!!! LOL!... But I noticed that each time I ran the php (or left it on 60 seconds refresh) while i was playing it'd get a brief network flash up).... poxy windows.

But hey ho, its manageable... and only an iccle server... but at least its one I can guarantee is up muhhaah the control!!

But thanks again for all the hard work

LoRdNaTaS · October 12, 2004

No prob..

If I get time I will make a dedicated Winblows version but it is not that high on my proirty list.. Sorry to all you Winblow users.

Darth_Larsen · October 16, 2004

Does the stat page keep a rolling score (all games played).

or does it just display the current game?

I want to use this in a closed lan party.. and SQL is to pricy to put on a closed server. Any plans on adding a file based database?

We will prolly be running it on a 2003 web server. (what the school has). Will that be a problem.

LoRdNaTaS · October 17, 2004

The stats keep a total for all games not just the currently active one. The DB is MySQL of which is free. It will run on both windows and Linux.

I have to double check on the php stats system to make sure it will function on a Winblows box. Due to I do not run any winblows web servers. But if for some reason it does not I will just modify the Winblows php status script to work with the stats system.

I nomally do not due much development for winblows but I have had to make some sacrifices due to the lack of linux server files.

If they release a true log system that will be able to be parsed easily I could make a flat file system but as the server currently stats I do not have any plans of making a flat file stats system.

Darth_Larsen · October 18, 2004

MySql is free???

Where do i get it for free.. i seem to only find where to buy it.

SteVader · October 18, 2004

http://www.mysql.com/products/mysql/

LoRdNaTaS · October 18, 2004

Yes MySQL is free use the link that stevader posted pick your os and download and install....

And just if you are wondering php is also free.

http://www.php.net

You can also get apache for winBlows to if you want a real web server.

http://www.apache.org

Sorry I really hate winblows.

LoRdNaTaS · October 18, 2004

I have relased the php stats.

http://www.apocalypce.net/modules.php?name=Downloads&d_op=viewdownload&cid=9

LoRdNaTaS · October 18, 2004

No prob.. Thats the great thing about OPEN SOURCE....

As long as the copyright is in tacked I am happy.

LoRdNaTaS · October 18, 2004

I got a message asking how to setup the cron on WinBlows.

Ok so here is what you will have to do if you want to try the php stats on Winblows.

Create a .bat or .cmd file depending on your OS.. Most of you will be able to use .cmd file without any issue... If you are using 2000 or 2003.

Here is example 1 of the cmd file.

If you can run php scripts from the command line anywhere on your server this will work for you.

getstats.cmd

-------------------------------------------------------------

php -q /path/to/file/getstats.php

exit

If you can not run php scripts from the command without the php files being located in the PHP directory then use this file.

Make sure that you copy the getstats.php file to your php directory.

getstats.cmd

--------------------------------------------------------------

cd \

cd php

php -q getstats.php

exit

Now that you have your getstats.cmd file you can create your scheduled task.

click start->programs->accessories->system tools->scheduled tasks

click on add task

click next then click on browse.

Browse to where you saved your getstats.cmd file

Select Daily

Set the start time and date (Use the default)

If your user has admin rights of which it should then just use your user info in the next window or fill in the admin info.

Select "Open Advanced options"

Select the schedule tab -> advanced button

Check the repeat tack box

Set Every to what ever you want.. I currently have the cron to run every minute. I would not go less then that though.

In the duration hours box set it to 24.

This will allow the task to run every minute for 24 hours straight.

Then just hit ok on both winblows and then you are set.

Now again I have not tested this script on any WinBlows boxes.. So if you have issues let me know.

LoRdNaTaS · October 19, 2004

There is a small patch for the SWBF PHP Stats. And also instructions on how if you would like to set it up for WinBlows.

All info can be found here: http://www.apocalypce.net...

And just an FYI for everyone all updates and patches will be available for download off of apocalypce..

I will keep everyone posted on an patches or upgrades that become available.

(NJOC)MasterJedi[L] · October 19, 2004

sorry i have a a question.

until there is another way i am using the script on my site. but what i need to know(since i dont know php) is how to create a link on the webpage back to my home page. thanks.

LoRdNaTaS · October 19, 2004

If you go to the includes folder and open functions.php. Find the function that says Footing.

You will see a line like this:

print"<td align='center'>$back Ver $ver<bR> &copy <a href='http://www.apocalypce.net' target='blank'>-=DOA=- / -=SLOA=- $year</a><br></td>\n";

before the closing </td> put this in:

you can modify that link to what ever fits for you.

This will put the link at the bottom of the page on both the main listing and also the details.

(NJOC)MasterJedi[L] · October 19, 2004

thank you

LoRdNaTaS · October 19, 2004

No prob

(NJOC)MasterJedi[L] · October 19, 2004

ok i tried to install the server stats.php

and have trouble with sql

this is what i get

Error

SQL-query :

--

------------------------------------------------------- --

--

--

DROP TABLE IF EXISTS servers

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '---------------------------------------------------------

--

can you please help?? sorry.

Game Server Stats & Status Downloads

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Archived