Common Database Queries

[Admin 0]

Select your database (for example dayz2username for Chernarus) and run these from phpMyAdmin or MySQL Workbench or Navicat

 

Fix every vehicle at once

UPDATE instance_vehicle SET damage=0, parts = '[]'

 

Refuel all the vehicles at once

UPDATE instance_vehicle SET fuel=1

 

Make vehicles spawn with full health

UPDATE vehicle SET damage_min=0, damage_max=0

 

Make vehicles currently on the server full health

UPDATE instance_vehicle SET fuel=1, damage=0, parts = '[]'

 

Delete all vehicles that have gone unused for more than 7 days

DELETE FROM instance_vehicle WHERE DATE(`last_updated`) 

 
Delete all vehicle spawn points that haven't spawned in-game
[code]DELETE FROM `world_vehicle` WHERE `id` NOT IN ( SELECT DISTINCT `world_vehicle_id` FROM `instance_vehicle`)