Website: CheatRecordsDelete from DB V2.2 [php/mysql]

This is the place where you can find everything related to the dedicated server, control scripts and community tools.

Moderators: Pit Crew, TM-Patrol

nouseforname
swift roadking
swift roadking
Posts: 840
Joined: 20 Apr 2008 08:58
Owned TM-games: TMUF,TMNF, TMN
Manialink(s): therookies
Location: Germany
Contact:

Website: CheatRecordsDelete from DB V2.2 [php/mysql]

Post by nouseforname » 28 Dec 2008 19:55

Hi all,

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
Version 2.1:
  • - updated repairrecs part to new version
    - this version now only supports xaseco since version 1.06

    Download here!
-----------------------------------------------------------------


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.
[/list]

Test:
  • 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.

Function:
  • - 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
It will show you the information of this login like:
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.

Files:
  • index.php - main script
    dbopt.php - optimize database script
    config.php - configuration
    prune.php - prunerecs script

Installation:
  • 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
[/list]


Remark:
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.


cheers
Nouseforname
Last edited by nouseforname on 18 Nov 2009 15:35, edited 16 times in total.
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

nocturne
solid chaser
solid chaser
Posts: 1390
Joined: 08 Jun 2007 18:48
Owned TM-games: all
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by nocturne » 28 Dec 2008 22:11

Kind of nifty... a little complicated, though. I just stole the delete db function out of fish's old NoCheat plugin and made it an admin command in aseco.

Anyways, here's a few cheater's logins...

dvknight
marekfcst
mpoulis4ever
sdssdsdsdsd
sauce_svk
karapiperis2

Not really any point as they can just change logins, but I have their ip's in the logs somewhere... just gotta dig them up.

User avatar
oliverde8
solid chaser
solid chaser
Posts: 1135
Joined: 07 Oct 2006 07:03
Owned TM-games: TMU
Manialink(s): oliverde8
Location: Turkey
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by oliverde8 » 29 Dec 2008 07:41

nocturne wrote:Kind of nifty... a little complicated, though. I just stole the delete db function out of fish's old NoCheat plugin and made it an admin command in aseco.
can you pass as thta plugin if fish doesen't mind :grmblz:

the web site is nice olso but when you can do it ingame :)
ImageImage
Manialink : oliverde8color>
Servers : STATS <> United | VeryShort | Made In Turkey

nouseforname
swift roadking
swift roadking
Posts: 840
Joined: 20 Apr 2008 08:58
Owned TM-games: TMUF,TMNF, TMN
Manialink(s): therookies
Location: Germany
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by nouseforname » 29 Dec 2008 10:31

ingame is nice too. thats right. but handle 7 different servers with checking for the same login is faster on that page :)
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

User avatar
f*ckfish
Pit Crew
Pit Crew
Posts: 1302
Joined: 15 Jun 2007 07:59
Owned TM-games: TMNF, TMUF
Location: Dresden, Germany
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by f*ckfish » 29 Dec 2008 17:31

Nice work nouse =)
And nocturne too ;-)
inactive, sorry

User avatar
chiusam
wheelbarrow operator
wheelbarrow operator
Posts: 18
Joined: 27 Aug 2008 05:05
Owned TM-games: TMUF
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by chiusam » 29 Dec 2008 17:35

Good work!
I have already removed the records of the liar!! :gobananas:
Thank you :3
Image
ΞМЯΞ Nadeo 0-50K
ΞМЯΞ TMX 20K-70K

User avatar
lille79
Pit Crew
Pit Crew
Posts: 881
Joined: 09 Dec 2007 15:04
Owned TM-games: TMN, TMNF, TMUF
Location: Norway
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by lille79 » 29 Dec 2008 20:58

Nice tool!! Thanks.

Can I release this with the usbTMFserver? It would be a great addition for most server hosts :)
/lille79
Old man of the Norwegian Trackmania team Super Sheep Racing
To visit my homepage/blog, and download the usbTMFserver, this is the place to go.

Xymph
Pit Crew
Pit Crew
Posts: 5719
Joined: 19 Aug 2007 12:58
Owned TM-games: TMN, TMU, TMF, TM²
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by Xymph » 29 Dec 2008 21:17

Just deleting a player's entries from the 'records' table results in inconsistent records/times that will be unfair to some other players in the database. You also need to delete all that player's entries from the 'rs_times' table. And you need to fill in gaps in the 'records' table with their corresponding entries (by other players) from the 'rs_times' table, which is what my Repair Records script does.
Developer of XASECO for TMF/TMN ESWC & XASECO2 for TM²: see XAseco.org
Find your way around the Mania community from the TMN ESWC hub, TMF hub, TM² hub, and SM hub

nouseforname
swift roadking
swift roadking
Posts: 840
Joined: 20 Apr 2008 08:58
Owned TM-games: TMUF,TMNF, TMN
Manialink(s): therookies
Location: Germany
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by nouseforname » 29 Dec 2008 21:30

Xymph wrote:Just deleting a player's entries from the 'records' table results in inconsistent records/times that will be unfair to some other players in the database. You also need to delete all that player's entries from the 'rs_times' table. And you need to fill in gaps in the 'records' table with their corresponding entries (by other players) from the 'rs_times' table, which is what my Repair Records script does.
thanks xymph for your comment.
that means if i add the "rs_times" table to the delete-script, AND
add your repairrecs script after deleting the cheater recs out of both tables, it would be the best way?!

that shouldn't be a big problem. i could do that i think.

but how about that optimize function? not enough?
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

User avatar
jimos94
happy cruiser
happy cruiser
Posts: 122
Joined: 06 Jan 2007 22:52
Owned TM-games: TMUF
Manialink(s): fun
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by jimos94 » 29 Dec 2008 21:34

Good job Nouse! Pretty useful script to those that have many servers running as you said :). I will use it as soon as i get home.
PS: another cheater's login: wtfk
http://www.tm-planet.net/ Server hosting, Interviews, Events and more :)

Xymph
Pit Crew
Pit Crew
Posts: 5719
Joined: 19 Aug 2007 12:58
Owned TM-games: TMN, TMU, TMF, TM²
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by Xymph » 30 Dec 2008 14:19

nouseforname wrote:
Xymph wrote:Just deleting a player's entries from the 'records' table results in inconsistent records/times that will be unfair to some other players in the database. You also need to delete all that player's entries from the 'rs_times' table. And you need to fill in gaps in the 'records' table with their corresponding entries (by other players) from the 'rs_times' table, which is what my Repair Records script does.
that means if i add the "rs_times" table to the delete-script, AND
add your repairrecs script after deleting the cheater recs out of both tables, it would be the best way?!
Right.
nouseforname wrote:that shouldn't be a big problem. i could do that i think.
but how about that optimize function? not enough?
That only optimizes a table internally, it doesn't affect the actual data in the table. The Repair Recs script copies entries from 'rs_times' into 'records' such that 'records' once again contains a complete set of $maxrecs records for each challenge (as gaps in those sets resulted from deleting the cheated records).
Developer of XASECO for TMF/TMN ESWC & XASECO2 for TM²: see XAseco.org
Find your way around the Mania community from the TMN ESWC hub, TMF hub, TM² hub, and SM hub

s0xen
happy cruiser
happy cruiser
Posts: 115
Joined: 11 Nov 2007 20:31
Owned TM-games: TMN

Re: Website: delete cheater records from database [php/mysql]

Post by s0xen » 30 Dec 2008 20:57

Very very nice made.

nouseforname
swift roadking
swift roadking
Posts: 840
Joined: 20 Apr 2008 08:58
Owned TM-games: TMUF,TMNF, TMN
Manialink(s): therookies
Location: Germany
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by nouseforname » 30 Dec 2008 21:13

i am currently working on the next version. so better you wait for it cause of the improved function.
just got some problems to solve first, regarding the 3 different db tables in Mistral, Aseco and Xaseco.

think i am able to release it tonight or tomorrow before noon.

@ lille
it would be my pleasure if you would import it to your USB server
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

User avatar
lille79
Pit Crew
Pit Crew
Posts: 881
Joined: 09 Dec 2007 15:04
Owned TM-games: TMN, TMNF, TMUF
Location: Norway
Contact:

Re: Website: delete cheater records from database [php/mysql]

Post by lille79 » 30 Dec 2008 21:50

Thanks. I'll just wait till you've made a new release and it's tested a bit before adding it. :)
/lille79
Old man of the Norwegian Trackmania team Super Sheep Racing
To visit my homepage/blog, and download the usbTMFserver, this is the place to go.

nouseforname
swift roadking
swift roadking
Posts: 840
Joined: 20 Apr 2008 08:58
Owned TM-games: TMUF,TMNF, TMN
Manialink(s): therookies
Location: Germany
Contact:

Re: Website: CheatRecordsDelete from DB V1.1 [php/mysql]

Post by nouseforname » 31 Dec 2008 02:13

Version 1.1 is out.

Hope you'll like it. pls check first post.
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

Post Reply