Bans SQL

[Snow-Man]

i have made bans system with sql but i have worried how to unban player while the time is end

 

[Simple0x47]

Make a timer which checks if the time expired.

[pa3ck]

Don't... create... a timer... Save the timestamp in SQL and when they join check if the timestamp expired. Look at the other topic created by Best Killer, I just told him how to do it.

 

If it's expired update the player data in SQL if not kick the player.

Edited December 21, 2016 by pa3ck

[Arran]

Why not just use the already existing script that I made: https://wiki.multitheftauto.com/wiki/Resource:Sqlbans

Or at the very least, look at how I did it in sqlbans, though I must admit the way I did it isn't as efficient as can be. My resource decrements the time remaining on a regular basis which works well and there's no need to change this but if you wanted to be super efficient you would store the time stamp of when you want them unbanning and then check on a regular basis to see if the time stamp they're due to be unbanned on is lower than the current time stamp.