Posts: 199
Threads: 53
Joined: May 2015
Reputation:
0
Hello SA-MP ...
Today I was hacked the server and were banned all player slots ... g.m. is MYSQL (Banned) is in the ' users ' How do I remove all of a sudden I mean something like bans for mysql DELETE ALL or something. .. Please help me. ..
SORRY FOR MY BAD ENGLISH.
Posts: 1,004
Threads: 18
Joined: Oct 2014
Reputation:
0
Login with phpmyadmin to your MySQL database and edit the raws manually.It seems to be a MySQL injection. Make sure you don't share your server's databse information with strangers, or even friends.
Posts: 1,004
Threads: 18
Joined: Oct 2014
Reputation:
0
Go to users table and edit its raws. If you have a backup of the database created recently, just import it to the database.
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
You better have a backup of your database otherwise you are so screwed. Assuming you have (or rather, had) more than one registered user, of course.
Posts: 199
Threads: 53
Joined: May 2015
Reputation:
0
Yes I had a pc but are all players with Banned = 1 .... and I want to give them how do I unban as are many and can't stand to give every-part. ..
Posts: 1,004
Threads: 18
Joined: Oct 2014
Reputation:
0
Well, I never checked if you can edit more raws at once in phpmyadmin. Anyway, just edit the Banned cell of your account and change the value to 0, then you can either script a command to unban the rest of the accounts at once, or to edit them manually.