Quote:
Originally Posted by SnowHP
Its possible to remove very old bans that have expired easly?
|
If you have access to the database directly via phpmyadmin, or some other mySQL tool, use this...
DELETE FROM sb_bans WHERE created < the unix timestamp of the date you want to start deleting bans
example: To delete all bans, using a SQL query, that were created before Saturday, February 4, 2017 1:59:09 AM use:
DELETE FROM sb_bans WHERE created < 148617354
There are many online unix timestamp conversion tools.
Note: This will only delete the data from the sb_bans table, there may be other data for that player in other tables.