Global vehicle wipe?

[darkfall211]

Is this possible? i need to wipe my entire map of vehichles then respawn them organically. Anyone have a method for this?

[cen]

DELETE FROM `object_data` WHERE `CharacterID` > 0 AND `Classname` NOT IN ('VaultStorage','LockboxStorage','VaultStorageLocked','LockboxStorageLocked','WoodShack_DZ','StorageShed_DZ','TentStorageDomed','TentStorageDomed2','TentStorage')  AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL;

That should work.

[ekroemer]

cen, as i read your code, it would delete owned vehicles, only (because CharacterID=0 for spawned vehicles) .

 

I guess, skipping the "`CharacterID` > 0 AND" wouldn't hurt.

[cen]

Ahh that's true. Just remove that part.

DELETE FROM `object_data` WHERE `Classname` NOT IN ('VaultStorage','LockboxStorage','VaultStorageLocked','LockboxStorageLocked','WoodShack_DZ','StorageShed_DZ','TentStorageDomed','TentStorageDomed2','TentStorage')  AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL;