[How-To] Improved vehicle spawn functions

Awesome. It would be worth noting how that car became nulled. Maybe you can scan your log-queries.txt trying to find it. I highly doubt the pSpawnVehicles caused it, so it may have been an error in dayz code or it may have been hacked in (badly)
 
It happened again. Another Skoda popped up in the objects_data and it's nulled. Ill attached a screenshot of my objects_data. Also, the vehicles in objects_data are the only vehicles spawning on my map. I have no idea how to change that. I would like little birds and Mi17's and all the other types of vehicles I'm missing...null.jpg
 
Nice background!

I had that same exact thing happen to me. I believe I fixed it by loading an earlier copy of my schema and mysql files inside dayz_data.
 
Any chance of a tutorial on how to load the schema and mysql files into dayz_data? I've never done anything like that and I don't have the slightest clue on how to start...
 
Nah, no problem. It's just copying over the old files. Nothing fancy like having to execute them.

They are in MYSQL>dayz_data. Just copy the new fresh ones over the old ones, took care of the null issue for me.

Also make sure you've got the same couple of fixes that Doc has posted.
 
Here's hoping that did it. With me, it was all new vehicles spawning that were being created with null. Was terrible.
 
OK well i turned battle eye off, locked my server, and ran my script to see all vehicles on the map. None of the new vehicles are in except for BAF offroad. Only two heli's on the map too and they are UH1H's.
 
ok im trying to follow this to uipdate my spawn scripts and im getting this error:
error 1136 (21s01) at line 1: column doesn't match count at row 1

what am I doing wrong?
thanks
 
I was able to add this without error. I could look at it if Doc doesnt get back with you

thanks. its prob something I did in these pics. its was 2am and I was trying to finish this up while falling asleep at the computer.

I fixed it. Once I sleep I looked back at what I did. Made the changes and it works fine now!
 

Attachments

  • bandicam 2013-01-27 10-28-56-265.jpg
    bandicam 2013-01-27 10-28-56-265.jpg
    126.8 KB · Views: 6
  • bandicam 2013-01-27 10-29-26-561.jpg
    bandicam 2013-01-27 10-29-26-561.jpg
    120.4 KB · Views: 4
ok im trying to follow this to uipdate my spawn scripts and im getting this error:
error 1136 (21s01) at line 1: column doesn't match count at row 1

what am I doing wrong?
thanks


You haven't added the new columns to the tables (near bottom of the guide) :)
 
OK well i turned battle eye off, locked my server, and ran my script to see all vehicles on the map. None of the new vehicles are in except for BAF offroad. Only two heli's on the map too and they are UH1H's.

Make sure your script is running without error. Execute pSpawnVehicles and see what the mysql response is. There may be an error.

Assuming it is installed correctly, are you actually executing the function before you start the server? This is by changing pMain to pSpawnVehicles when you edit your @START_SERVER.bat
 
Make sure your script is running without error. Execute pSpawnVehicles and see what the mysql response is. There may be an error.

Assuming it is installed correctly, are you actually executing the function before you start the server? This is by changing pMain to pSpawnVehicles when you edit your @START_SERVER.bat

Yup. I made sure it ran fine and I made the change in the @START_SERVER.bat. I swear I did everything right, that's why im so stumped.
 
Make sure your script is running without error. Execute pSpawnVehicles and see what the mysql response is. There may be an error.

Assuming it is installed correctly, are you actually executing the function before you start the server? This is by changing pMain to pSpawnVehicles when you edit your @START_SERVER.bat

I have an HBF package plus server and i am missing several of the functions used with your vehicle spawn function like getvehcount etc i tried to create new functions with the code you provided on the first page but i am having an issue saving the fgetvehcount in particular, im sure the vehicle spawner wont work as it lists fgetvehcount in its code can you tell me what im doing wrong? 1418- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you "might" want to use the less safe log_bin_trust_function_creators variable
 
Hi Doc,

You going to update the vehicle spawn script for the newer release, can't seem to get it running on a fresh install of the latest server files.
 
I get the same error in Navicat that others are getting. I cut and pasted your text and followed the directions. The procedure won't save.
 
Back
Top