Cleaning up spawn points on the map

suranic

suranic

New Member
Hello OpendayZ,

I've got a question about vehicle spawns. I'm using bliss via dayz.st
Now when i look on the map, there are tons of spawn points, but most of them aren't spawned and they make the map look a bit messy.

I can ,of course, remove every spawn point and start all over. But with people having bases and owning vehicles, i will also remove those ( and i don't think they will be happy when i do that :D ).

So i want to delete the spawn points that do not have a vehicle spawned in game and/or do not have a owner.

Is this possible ?

Greetz
 
You can use the database access on dayz.st to do it very fast with SQL.

Example:
"remove all tents without gear in them"
DELETE FROM instance_deployable WHERE `deployable_id` =1 and inventory = '[[[],[]],[[],[]],[[],[]]]'

Read here:
http://dayz.st/w/MySQL
 
Hello Maciej,

Yes i've found it already. I've also added it on the wiki that you refer to :).

I used this SQL code for the ones that want to know it.

DELETE FROM `world_vehicle` WHERE `id` NOT IN ( SELECT DISTINCT `world_vehicle_id` FROM `instance_vehicle`)

This basically removes all the spawn points that haven't got a spawned vehicle yet ( and this way I don't have to be afraid I delete any vehicles that have got an owner :D.

Thank you anyway!
 
You must log in or register to reply here.
Back
Top