Removing unspawned spawn points?

[suranic]

Hello Guys,

I've already asked this in the housekeeping section. But maybe it's more related to this section.
Feel free to delete one of them!

My question is about the spawn points of vehicles. I'm using dayz.st and bliss.
Now when I open my dayz map there are tons of spawn points, where no vehicles have spawned.
That makes my map look a bit messy.

I can, of course, remove every spawn point ( this also removes spawned vehicles). but my players will not be happy when I do that

Is there a way that I can only delete the spawn points that haven't spawned a vehicle yet and/or do not have a owner

Cheers

 

[suranic]

Already got it : 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.