APB Stats Problems Options

Due to a loss of connection between the ranks bot and the database at a critical time all of the monthly and ongoing rank data was lost.

I have restored the data from an older backup but unfortunately this is a lot older than I would have liked.

Pro Tip

CODE

START TRANSACTION

-- DO SQL STUFF --

COMMIT

Using transactions will ensure that losing connection partway through an update will not result in a fucked up database because the DBMS will automatically roll back the transaction if it is not committed before the connection loss. If using SQL Server instead of MySQL use 'BEGIN TRANSACTION' instead of 'START TRANSACTION'.