I made a little java program to extract the playerstats and save them to a database and also a webpage to view the stats.
What you need to run this:
Create a new database with any name you would like (you will have to enter this name into the config files later).
Import the kf2stats.sql which you can find in the uploaded ServerExtWebMod.rar.
PHP:
Open the Webpage/secret.php and enter:
To show the webpage use .../kf2stats.php?page=0&count=25
Java Program:
Open the USAConverter.ini and enter:
DON'T CHANGE LastUpdate. It saves the time when the database was updated so it only updates active users next time.
The initial run when i tested it took around 8 minutes for over 3000 users with 9000 stats and 4000 traits. (run locally where the database is hosted)
Drastical performance update: initial run took only 22 seconds for 2000 users with 10000 stats and 6000 traits. (run locally where the database is hosted)
V3:
V2:
V1: Released.
IF YOU ALREADY SETUP AN OLDER VERSION DON'T OVERWRITE THE "secret.php" AND THE "USAConverter.ini" OR YOU HAVE TO ENTER YOUR USER, PASSWORD,... AGAIN.
Download: here
Github Repo: https://github.com/j1gs4w/USAConverter
Known Issues: Players information like Playername are never updated once they are in the database.
Credits:
OldSchool - for sharing the stat files from his server.
Sheep - for sharing the stat files from his server.
Marco - for the Server Extension Mod.
What you need to run this:
- Server Extension Mod from marco running on your server
- computer where you can execute the java program
- mysql-database (5.5 or higher)
- a webspace or something like this with php
Create a new database with any name you would like (you will have to enter this name into the config files later).
Import the kf2stats.sql which you can find in the uploaded ServerExtWebMod.rar.
PHP:
Open the Webpage/secret.php and enter:
- hostname at $mysql_host
- port which will be used to connect to the MySQL server at $mysql_port (3306 is the standard port)
- username to access the MySQL server at $mysql_user
- password to access the MySQL server at $mysql_pass
- database name which you created at the beginning at $mysql_db
To show the webpage use .../kf2stats.php?page=0&count=25
Java Program:
Open the USAConverter.ini and enter:
- directory where your .usa file are at Directory (always use \\ for the folders instead of a single \)
- hostname where your MySQL server runs at Hostname
- port which will be used to connect to the MySQL server at Port (3306 is the standard port)
- username to access the MySQL server at Username
- password to access the MySQL server at Password
- database name which you created at the beginning at Database
- how frequently it should update the database at UpdateTimer in seconds (default here is every hour).
DON'T CHANGE LastUpdate. It saves the time when the database was updated so it only updates active users next time.
The initial run when i tested it took around 8 minutes for over 3000 users with 9000 stats and 4000 traits. (run locally where the database is hosted)
Drastical performance update: initial run took only 22 seconds for 2000 users with 10000 stats and 6000 traits. (run locally where the database is hosted)
Spoiler!
Spoiler!
V3:
Spoiler!
Updated to the newest Server Extension Mod Version (0.965)
Redesigned the Webpage.
Redesigned the Webpage.
V2:
Spoiler!
Added Firebug and Demolition.
Added tooltips to the traits.
Changed some default maximum levels to be in sync with the Server Extension Mod.
Added tooltips to the traits.
Changed some default maximum levels to be in sync with the Server Extension Mod.
V1: Released.
IF YOU ALREADY SETUP AN OLDER VERSION DON'T OVERWRITE THE "secret.php" AND THE "USAConverter.ini" OR YOU HAVE TO ENTER YOUR USER, PASSWORD,... AGAIN.
Download: here
Github Repo: https://github.com/j1gs4w/USAConverter
Known Issues: Players information like Playername are never updated once they are in the database.
Credits:
OldSchool - for sharing the stat files from his server.
Sheep - for sharing the stat files from his server.
Marco - for the Server Extension Mod.
Last edited: