Help Spawn Vehicles on 1.8.1

[Dumgard 2]

I've recently set up a dedicated box for my DayZ servers.

With the latest database changes that 1.8.1 has brought, it has made it difficult for me to figure out how to easily add in a bunch of extra vehicles to the server. I used to have a TON of vehicle spawn points in my old database, which would spawn a good portion of vehicles given their Spawn Chance.

Currently, my map has zero vehicles showing on it. I'd like to do one (or both if possible!) of the following:

1. Implement a random spawn system similar to what Epoch uses so that vehicles are spawned evenly across the map, and a new vehicle is spawned upon the destruction of a current vehicle.

2. Easily add in about 100 static vehicle spawnpoints. Since I am now on a dedicated server and no longer using DayZ.ST, I am uncertain what utilities are able to provide right click spawn point addition with the new 1.8.1 database.

[Dumgard 2]

I'm wondering if I can just restructure the old database's world_vehicle table, but the thing that concerns me is that the new database format having an ObjectUID column. I am not sure what I need to do with that.

[kichilron 8550]

If you're running a private server, it would be best to use this build, as it's been updated to work with 1.8.1 already:

 

https://github.com/Pwnoz0r/DayZ-Private-Server

 

From there you can add more spawnpoints or edit the already existing vehicles.

[Dumgard 2]

If you're running a private server, it would be best to use this build, as it's been updated to work with 1.8.1 already:

 

https://github.com/Pwnoz0r/DayZ-Private-Server

 

From there you can add more spawnpoints or edit the already existing vehicles.

I am using that build with a couple modifications (mainly custom batch files to auto restart every 3 hours) and also running it from a true dedicated MySQL server instead of the default one.

 

Everything is fine, except from what I can tell there is no way to add in additional spawnpoints easily.  I also cannot find what to run/execute in order to initiate the vehicle spawns.  My object_spawns table is populated, but the map does not have a single vehicle on it.

[Dumgard 2]

Still searching for a solution.  Would gladly compensate someone monetarily for their time.

[Dumgard 2]

I have added spawnpoints into the database, and called pMain.   Even after editing pMain to allow for 250 vehicles max, it won't spawn more than 72 objects into object_data.  I currently have 1016 possible spawn entries.

 

ETA: Thank you for the fast help!  Fixed the Object limit with the object_classes table

Edited June 9, 2014 by Dumgard

[bbsnipes 3]

I have added spawnpoints into the database, and called pMain.   Even after editing pMain to allow for 250 vehicles max, it won't spawn more than 72 objects into object_data.  I currently have 1016 possible spawn entries.

 

ETA: Thank you for the fast help!  Fixed the Object limit with the object_classes table

 

I ran it twice and it spawned in about 73 vehicles, but everytime I run the procedure again it says Error Code: 1366. Incorrect decimal value: '' for column '' at row -1.

I even tried editing the pMain like you mentioned in your post and also increased the maximums above the limit. However it won't spawn anymore.

 

Also, how did you quickly generate all those spawn points?

[Dumgard 2]

I ran it twice and it spawned in about 73 vehicles, but everytime I run the procedure again it says Error Code: 1366. Incorrect decimal value: '' for column '' at row -1.

I even tried editing the pMain like you mentioned in your post and also increased the maximums above the limit. However it won't spawn anymore.

 

Also, how did you quickly generate all those spawn points?

 

 

I exported the old world_vehicle into xls, renamed the columns, and imported them to the new server

Edited June 11, 2014 by Dumgard