Question about the recommended MySQL Events.

[Radiix]

Hey guys,

 

i got a question regarding about the recommended mysql events that are in the 1.0.2.4 server files.

Tbh im not the best at mysql, and my question is:

 

What i need to adjust on these events so the players have to maintain the objects they placed only once a month? The cleanup of those object has to be after 30 days then.

 

I've looked into the code and its kind of confusing for me lol.

 

Thanks for any help and any advice!

[zydrahydra]

DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 42 DAY)

first interval is when they last maintained or updated second is when they placed