due to more and more cheaters appearing on my servers i created a little script. It can show the stats or delete all records of a choosen player login. I was to lazy to search for a player Id, than search records by player id, than delete this records. I know it still need the cheaters login but is shouldn't be to difficult to get that.
I dont know if somebody will use it but i think it's worth to share. At least may somebody will have some suggestions or modifications to make it better.
It's the first script i ever made, and i wanna give back a little part of what i got here.
Update version 2.2:
- - Fixed errors in markup and css, now page is W3 valid
- no change in config and function
- - updated repairrecs part to new version
- this version now only supports xaseco since version 1.06
the repairrecs script will fill up the empty spaces with the next following record.
prunerecs could be used for deleting older records. during my tests i needed to do so, to be able to run repairrecs without error. this was cause of some date-issue in my databases. dont know exactly why, but prunerecs solved it.
after prune/delete records the repairrecs should be executed.
cause of the repair/prune function it was necessary to make a difference between the 3 controlers.
for (X)Aseco all functions should be well, for Mistral i disabled repair/prune recs. cause the rs_times table is not inside. but it's still possible to delete cheater recs and optimize database.
- I tested the deleting and repairrecs with all 3 types of database.
prunerecs i only could test with my xaseco servers cause i dont have older data for the others. all the functions looks good to me. at least my databases are in a better shape now. i tested the whole function with 7 different xaseco db. biggest one is more than 35k players inside, oldest one should be about one year.
anyway it would be nice if somebody is able to test it with the different systems.
i recommend making a backup before testing, but i think all is fine.
- - Open the page at your webspace. normally the same server where (x)aseco is running.
it could be your local machine also.
- - Type in the players login
- - Choose the server you wanna check
- - Click "View" to check this logins stats
- - Or click "Delete" to delete all records from the coosen login and server/database
Login nouseforname with Player ID 1 from GER won 138 times, owns 148 records and played 146.4 hours at this server.
There will be a list of all records like:
RecordID 4 ChallengeID 6 Player ID 1 Time 24200 msec.
RecordID 52 ChallengeID 198 Player ID 1 Time 29790 msec.
The record list is not really important but i wanted to display it just to make sure it's the right login before choose delete.
Possible to optimize the respective database by one click at the servername. this would be necessary cause of "Overhead" after deleting data.
the idea is to make it easy for everybody. deleting records etc.. even without knowing phpmyadmin.
- index.php - main script
dbopt.php - optimize database script
config.php - configuration
prune.php - prunerecs script
- Just copy the files to a directory on your webspace.
Edit the config.php to match your mysql data.
Fill in the database host, login and password as well as the database names and belonging server names.
check the comments for the other parameters
Feel free to post your suggestions and modifications here. also i would appreciate your oppinion about this little thing.
Thanks to all the sriptwriters and programmers here for sharing your work.