Posts: 35
Threads: 0
Joined: May 2017
Reputation:
0
Does an entry appear in your database when you ban them?
What does MySQL logs tell you?
Posts: 1,506
Threads: 13
Joined: Jun 2015
The whole system is scripted very awfully. You should better recreate it with the following stuff taken in consideration:
- Use `ID` as NOT NULL AUTO INCREMENT column
- Add a column for player name and another for storing player's IP.
- This one will be used to store ban time, use gettime() and store the data into this.
- Now the final one, from whom the player was banned by. This must be VARCHAR (24).
Now when the player connects.
- Call OnBanCheck query
- If player is banned, compare the time by using gettime(), if the current time is more than the stored, the player's ban has expired and you can do what ever you like. If the stored time is not higher then you can kick them for being banned from IG.
- If player is not banned, query the player account stuff and you're good to go.