[How-to] Spawn and test all non-banned vehicles

Doc

Valued Member!
This little SQL script will add every non-banned vehicle in DayZ into your object_data table so they will spawn at a location just north of Novy Sobor. I do not recommend using this on a live server as it is generally for testing purposes for admins to see what vehicles they want to add to their server. Some vehicles may appear many times, but that is just because there are occasionally different versions of the same model that exist.

To use this, just execute the attached SQL script (open text file and copy/paste) by exucuting a query on your object_data table. Afterwards, teleport yourself (by changing your characters worldspace whilst aborted) to [30,[7440.19,8000.24,0.001]]

If you find a vehicle you like, you can usually tell by it's shape/location/name what classname it is. If you are really stuck then put an item in it's gear inventory and find it from the database like that.

Enjoy :)


 

Attachments

  • all_vehicles_sql.txt
    11.4 KB · Views: 487
Hiya

Once your server is up and running, simply open the Object_data table in navicat and go to File -> Query table. Paste the contents of the file into the area, replacing what was in it, then press Execute or Run or whatever it is. Once that's done, you can restart your server, teleport yourself to the location stated and enjoy testing the vehicles.
 
Doc, I get this error message when trying import. I am using your "pSpawnVehicles" function:

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `object_data` VALUES (19336, '1123123753', '1', 'datsun1_civil_1_ope' at line 1

-Yorto
 
Based upon your directions to :

Query the Table, and run the Injection.

I then get the error message:
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `object_data` VALUES (19336, '1123123753', '1', 'datsun1_civil_1_ope' at line 1

Much appreciated.

-Yorto
 
Ah, you have an additional column called 'Landmark'.

Open the file in notepad, word or similar, press ctrl + r (find and replace feature)

Find: );
Replace: ', '1');

Try with the changes and let me know if it works :)
 
New error now...

[SQL] INSERT INTO `object_data` VALUES (19336, '1123123753', '1', 'datsun1_civil_1_open', '0', 0, '[148,[7438.45,8037.38,0.049]]', '[[[],[]],[[],[]],[[],[]]]', '[]', '1', '2012-12-13 02:20:48'', '1');
INSERT INTO `object_data` VALUES (19337, '223753234', '1', 'datsun1_civil_2_covered', '0', 0, '[151,[7430.81,8042.28,0.05]]', '[[[],[]],[[],[]],[[],[]]]', '[]', '1', '2012-12-13 02:20:48'', '1');
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1');
INSERT INTO `object_data` VALUES (19337, '223753234', '1', 'datsun1_civil_' at line 1

Not sure as to why.

Here is the actual line of that Insertion code:

INSERT INTO `object_data` VALUES (19336, '1123123753', '1', 'datsun1_civil_1_open', '0', 0, '[148,[7438.45,8037.38,0.049]]', '[[[],[]],[[],[]],[[],[]]]', '[]', '1', '2012-12-13 02:20:48'', '1');
INSERT INTO `object_data` VALUES (19337, '223753234', '1', 'datsun1_civil_2_covered', '0', 0, '[151,[7430.81,8042.28,0.05]]', '[[[],[]],[[],[]],[[],[]]]', '[]', '1', '2012-12-13 02:20:48'', '1');


Something wrong?
Thanks!
-Yorto
 
Hi Doc,

Thanks for the response, I have tried that, but when I restart my server I am where the vehicles should be, but there are no vehicles sat there and then when I check the "object_data" table with navicat all of the vehicles other than the original vehicles that were on the server have disappeared.
 
Few things may be causing this:

1) Did the vehicles add into the table in the first place?
2) Are you running any cheat protection
3) Did the vehicles definitely add into the table in the first place?
 
Hi Doc,

The vehicles definitely added into the database ok as I used the location of one of the vehicles as the spawn location of my character.

I am running it straight as it downloads via github, so Battleeye is running, I'll try disabling it and see if that helps and post back if I have success!
 
There is no need to disable battleye for this. The only thing I can consider is perhaps some cheat protection removing them afterwards, but if its straight from github then that should not be an issue. Also are you restarting the server after you added them which you need to do? Message me your skype details and I can try help you further via there so I can see your navicat.
 
It didn't work! I don't have skype unfortunately!

I am restarting the server after adding them and apart from Battleye, there is no cheat protection running. I am running the game through Steam, could this be causing issues?
 
Jim....have you rebuilt the software end of your server?

Sometimes starting over is the best course of action.

Just a suggestion.

-Yorto
 
sorry but
another tutorial by Doc not-effective
when I restart the server my old database returns
 
Code:
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `object_data` VALUES (19336, '1123123753', '1', 'datsun1_civil_1_open', '0', 0, '[148,[7438.45,8037.38,0.049]]', '[[[],[]],[[],[]],[[],[]]]', '[]', '1', '2012-12-13 02:20:48');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
 
The cars didn't work, i've insert the cars into my database and there is anythink in but they don't spawn.

By the way here is the fixxed sql for the one who are getting column error.
Click here!
 
and how can i despawn objects?, or modify directions?, becouse i know how to spawn, but when i try to fix some positions, stuff are just still there...
 
Back
Top