Thread: Website is slow
View Single Post
SnowHP
Member
Join Date: Sep 2016
Location: Porto, Portugal
Old 07-11-2018 , 20:26   Re: Website is slow
Reply With Quote #8

Quote:
Originally Posted by Doulos View Post
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.
Will this fix the lag?
__________________
SnowHP is offline