how to remove all cars who stand 7 days without movement?

[nikas455]

how to remove all cars who stand 7 days without movement?

[cen]

Run this SQL query

SELECT * FROM `object_data`
WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
AND `Classname`
NOT REGEXP 'land|storage|shed|bench|wall|floor|fence|pump|wood|hrescue|stick|pole|generator|panel|house|rack|bag|stand|barrel|canvas|wire|hedgehog|net|trap|ramp|fort|sand|scaffold';

If it returns results that look good, change the SELECT * FROM to DELETE FROM

[nikas455]

Run this SQL query

SELECT * FROM `object_data`
WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
AND `Classname`
NOT REGEXP 'land|storage|shed|bench|wall|floor|fence|pump|wood|hrescue|stick|pole|generator|panel|house|rack|bag|stand|barrel|canvas|wire|hedgehog|net|trap|ramp|fort|sand|scaffold';

If it returns results that look good, change the SELECT * FROM to DELETE FROM

and how to clean the machine? inscription what

[cen]

clean the machine?

[nikas455]

clean the machine?

yes

[cring0]

o_O  Oh, I think he's asking how to write in the variables or object names to clean up vehicles instead of land|storage|shed|bench|wall|floor|fence|pump|wood|hrescue|stick|pole|generator|panel|house|rack|bag|stand|barrel|canvas|wire|hedgehog|net|trap|ramp|fort|sand|scaffold.

 

Or does that exempt those objects and remove everything else?

[RimBlock]

What Cen proposes is probably the most reasonible way to go about it but just be aware that if someone goes in the vehicles 'gear' or enters and exits the vehicle then IIRC it gets saved to the DB as an update (i.e. it does not have to move to be updated).

[cen]

What Cen proposes is probably the most reasonible way to go about it but just be aware that if someone goes in the vehicles 'gear' or enters and exits the vehicle then IIRC it gets saved to the DB as an update (i.e. it does not have to move to be updated).

 

Correct, any action taken on the vehicle will update the LastUpdated date. Moving it, adding/removing gear, salvaging/repairing, force saving.