[Maheegan]

Quote:

Originally Posted by Vince You're completely missing the point here. No, you don't need to run it from the gamemode because a) the query itself does not contain anything special and doesn't even have to be formatted and b) because having a timer that's just eating up CPU 99.9999% of the time is totally inefficient.

Would this work ?

Код:

CREATE
    EVENT `reset_column`
    ON SCHEDULE EVERY 1 WEEK STARTS '2016-02-15 00:00:00'
    DO BEGIN
   UPDATE playeraccounts SET pRunners = 0, pArrests = 0, pTickets = 0, pDConf = 0, pLConf = 0, pLGive = 0, pTOrders = 0, pHealed = 0, pContracts = 0, pNews = 0, pLive = 0, pDDep = 0, pMaDep = 0, pMoDep = 0, pWK = 0, pWD = 0, pMUsed = 0
    END */$$
DELIMITER ;