Thread: Website is slow
View Single Post
AlliedModders Donor
Join Date: Aug 2007
Old 07-11-2018 , 15:38   Re: Website is slow
Reply With Quote #7

Originally Posted by SnowHP View Post
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.

Last edited by Doulos; 07-11-2018 at 15:40.
Doulos is offline