Call of Duty

UltraStats Beta v0.2.144 made by (deltaray) shooter-szene.de

Changelog:

- Fixed a serious security issue in player_details.php page.
- Fixed leaking DB handle in GetSingleDBEntryOnly
- Fixed a bug of players which were not displayed on the detail page. Only happened if there GUID was empty.
- Fixed bug in INSERT statement of server admin


how to update (english):

1. Copy all files over your existing one except for install.php and config.php! Do NOT copy these 2 files.
2. Login into the Admin Center and perform the database upgrade.
3. You are done.


Support Forum (english/german):
http://www.shooter-szene.de/index.php?name=PNphpBB2&file=index&c=28


Demo webpages:
http://cod2demo.ultrastats.org/
http://cod4demo.ultrastats.org/

    Step 1 - Check prerequisites

    Before you start installing UltraStats, you should should make sure that you have the following:

        * Apache Webserver 1.3 or 2.0 or higher (Ask your Webserver ISP if you are not sure)
        * PHP 4.x or PHP 5.x or higher is installed, UltraStats has been tested with both successfully.
        * MySQL Database (4.x or 5.x or higher)! Optional, I recommend that you have PhpMyAdmin installed. You may will need it for testing and debugging. However the installation can be done WITHOUT PhpMyAdmin!
        * About 20MB of free Webspace and at least 10MB of database space. You will need more database space if your logfile grows. However UltraStats has a high optimized database layout.

    Step 2 - Run the Installation Script

    I made it as easy as I could, you simple need to unpack the UltraStats archive and upload it onto your Webserver. After you have done this, kindly open http://www.yourwebhost.com/ultrastats/install.php and follow the installation instructions. A few files and directories need write access, the installer will tell you which files.
    Step 3 - Add your first Server

    If everything goes right, you should have your UltraStats Installation running in 5-10 minutes. You can now proceed to the Admin Center, login and add your first Server. Important is that you configure the correct Gamelog location. This is a relative path on the Webserver.

    I recommend to use something like this:
    ../gamelogs/games-server1.log

    If you add the server, the script will try to create an empty file ( if not already there ). If this fails, you will receive an error and the server will not be added (until the path is correct and the file writeable and readable).

    You can also configure a Remote FTP Path which can be used to automatically download the Gamelog from the Webserver.
    Use a remote ftp path like this:
    ftp://username@127.0.0.1/.callofduty2/main/Server1_mp.log
    *Experimental Support for SCP has also been added! Kindly use scp;// instead of ftp:// in the FTP Path parameter. But be warned, you will need the SSH2 Extension for PHP5 installed which itself is still beta and not easy to install! For more see the package website of ssh2 for php: http://pecl.php.net/package/ssh2
    Step 4 - Download the Logfile

    This step assumes that you have configured a valid FTP Remote path. In order to download the logfile click on the icon. If the password is not within the ftp remote path, you will be prompted for it automatically. Then the Gamelogfile is downloaded, assuming the path is correct. The download script only downloads new stuff from the logfile, this means it appends the log. This saves a lot of bandwidth and time if you are going to configure updates by hour.
    Step 5 - Run the Parser

    Now comes the parser part, also very easy - you just need to click the icon, and the parser will start. The script is designed to run max. 60 seconds. An internal timer will abort processing after 50 seconds, and auto reloads itself and resumes from the last position. The parser process will take a lot of performance from your Webserver, specially the MySQL server. This is due the many Insert statements. In the final version, I might be able to use bulk insert to speed the process up.
    Step 6 - Run Total/Final Calculations

    A very important step! For optimal performance, I have added some helper tables to store top aliases. You will see this in the page generation time. Even with large databases, the page generation will be very fast compared to other stats applications. The step is so important because without, you will not see any aliases on the main page!
    Finished

    Yes you are done :) Well not really, I think you need to experience all the features UltraStats brings to you. Server Admin, Player Editor and User Admin are currently working More administrative facilities will come in the final, I have planned to add a Map Admin and such stuff.