Spawning vehicles problem in 1.8.5 SQL

[CTBM 0]

edit: Issue has been resolved and explained in this thread.

 

As of 1.8 i have had some issues getting more vehicles to spawn statically so after some time and data entering

I've created a table of Vehicle Spawns based loosly on this map here: http://dayzdb.com/map/chernarus.

 

There are 69 vehicles in this table but you can add/remove as much as you want as long as you follow the object_spawns table.

 

Nearly all vehicles have no fuel and data has been based off object_spawns table. So you may want to also change this data to your liking.

 

To install just replace blank table with this one. Locations and vehicle info should save if your server is set up correctly.

 

Download just rename to .SQL

 

object_data.sql.txt

 

This can also be used for other maps too, you just need to modify the Worldspace column.

Edited May 21, 2015 by CTBM

[r4z0r49 4761]

I'm really unsure what this is doing ? If you wish to add vehicles just run pmain and vehicles will be added.

[CTBM 0]

Its just for people interested in additional repairable vehicles to the current set, I couldn't find any on Chernarus that aren't complete wrecks and beyond repair.

 

maybe my server has terrible luck :P

 

edit: I also ran the OOB function to no avail.

Edited May 21, 2015 by CTBM

[r4z0r49 4761]

the oob is out of bounds has nothing to do with spawning ?

 

Run pMain to respawn vehicles if you wish to change the damage values edit them in vehicle_spawns if your using the new spawn system.

 

Ps your only running the new spawn system if your admins have installed it.

[r4z0r49 4761]

Its just for people interested in additional repairable vehicles to the current set, I couldn't find any on Chernarus that aren't complete wrecks and beyond repair.

 

maybe my server has terrible luck :P

 

edit: I also ran the OOB function to no avail.

 

Wait you said you cant repair them that means there all bloody damaged run the pcleanup to remove and pmain to respawn them again. You should enable timers and run pmain every 3 hours it should do everything for you.

[CTBM 0]

Ok just to explain a few things

 

Server is running on localhost using mySQL server.

 

ive installed server, installed all SQL data in 1.8.5 folder and also added The vehicle spawner code.

 

run ALL functions including pMain.

 

changed all Vehicle data including spawn chance, hitpoints/ damage. still no repairable vehicles.

 

my method is the Only way it works on my server no other table makes any changes to server,

 

i appreciate you trying to help but my method is the only one that works for me.

Edited May 21, 2015 by CTBM

[r4z0r49 4761]

Ok that way is very wrong. So we need to find out why its not working.

 

Stop server

Rename your object_data.
Add new Object_date epmty

run pmain

 

Whats happening when you run pmain?

[CTBM 0]

Ok i found the problem.

 

during installation pCleanup was not being added to the stored procedures. so manually added pCleanup because only pCleanupBase & pCleanupOOB were only visible in hive.

 

so then i run pMain(1337);

 

Now object_data is full. :)

Edited May 21, 2015 by CTBM

[r4z0r49 4761]

K cool ill look over the sql tomorrow see if we missed Somthing.

[alanbr00 0]

I think i'm having the same issue.

 

I have a dayz vanilla server 1.8.6.1 and i can't increase my vehicle servers. i have set on vehicle_spawns but, my object_data stops around 55.

[pjohnson7 7]

I think i'm having the same issue.

 

I have a dayz vanilla server 1.8.6.1 and i can't increase my vehicle servers. i have set on vehicle_spawns but, my object_data stops around 55.

Take a peek at the table VEHICLE_GROUPS also..it appears to be like a global max vehicle count by vehicle ID...

 

on a side note,  I also had to delete out the info in VEHICLE_SPAWNS_GROUPS in order to get all the vehicles spawned that I wanted.

Though I did this because I added/rearranged/etc the Vehicle ID's to my liking and didn't even understand what this table was actually doing other than stopping some of my vehicles counts from spawning.

[r4z0r49 4761]

Take a peek at the table VEHICLE_GROUPS also..it appears to be like a global max vehicle count by vehicle ID...

 

on a side note,  I also had to delete out the info in VEHICLE_SPAWNS_GROUPS in order to get all the vehicles spawned that I wanted.

Though I did this because I added/rearranged/etc the Vehicle ID's to my liking and didn't even understand what this table was actually doing other than stopping some of my vehicles counts from spawning.

 

It only spawns a maximum amount of vehicles based on group.

[alanbr00 0]

I was able to spawn more vehicles, but now i can't find them in game, i go to them thru DB and they are not there.

 

This is the RPT if help.

Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/Offroad_SPG9_Gue/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/HMMWV_Ambulance/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/HMMWV_Avenger/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/USMC_Soldier/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/MTVR/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/M119/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/DSHkM_Mini_TriPod/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/SearchLight/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/Igla_AA_pod_East/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/Metis/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/2b14_82mm/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/M252/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/M2HD_mini_TriPod/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/MK19_TriPod/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/A10/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/C130J/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/T34/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/M1A1/
Unrecognized CfgVehicles simulation  in bin\config.bin/CfgVehicles/MLRS/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/StreetLamp/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/StreetLamp_BaseWeakYellow/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/StreetLamp_BaseMediumOrange/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/StreetLamp_BaseMediumPale/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/StreetLamp_BaseStrongPale/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/StreetLamp_EP1/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_Lamp_Cable_EP1/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_Lamp_Street1_decor_EP1/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_Lamp_Small_EP1/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_Lamp_Street1_EP1/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_Lamp_Street2_EP1/
Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_Lampa_Ind_EP1/
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:01 Server error: Player without identity Cap_Nemesis (id 320489710)
14:23:05 Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_lampa_sidl/
14:23:06 Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_PowLines_WoodL/
14:23:07 Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_lampa_ind/
14:23:07 Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_PowLines_ConcL/
14:23:10 Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_lampa_ind_zebr/
14:23:10 Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_lampa_sidl_2/
14:23:13 Unrecognized CfgNonAIVehicles simulation thing in bin\config.bin/CfgNonAIVehicles/Land_lampa_sidl_3/
14:23:22 Warning: looped for animation: ca\anims\characters\data\anim\sdr\mov\erc\wlk\non\non\amovpercmwlksnonwnondf.rtm differs (looped now 0)! MoveName: amovpercmstpsnonwnondnon_amovpercmstpsraswpstdnon
14:23:23 "PRELOAD_ Functions\init [[<No group>:0 (FunctionsManager)],any]"
14:23:23 "MPframework inited"
14:23:23 "dayz_preloadFinished reset"
14:23:25 "Res3tting B!S effects..."
14:23:26 "z\addons\dayz_code\system\REsec.sqf:Monitoring Remote Exe..."
14:23:26 "HIVE: Starting"
14:23:26 ["TIME SYNC: Local Time set to:",[2012,8,2,8,23],"Fullmoon:",true,"Date given by HiveExt.dll:",[2015,6,7,8,23]]
14:23:26 "DEBUG FPS  : 32.9218"
14:23:26 "HIVE: Request sent"
14:23:26 "HIVE: Commence Object Streaming..."
14:23:26 "HIVE: Streamed 0 objects"
14:23:26 "STARTING LOGIN: ["76561198006395951",B 1-1-A:1 (Cap_Nemesis) REMOTE]"
14:23:26 "LOGIN ATTEMPT: "76561198006395951" Cap_Nemesis"
14:23:26 "LOGIN LOADED: B 1-1-A:1 (Cap_Nemesis) REMOTE Type: Survivor1_DZ"
14:23:26 "1, [[],[["HandRoadFlare",9],"ItemBandage","ItemBandage"],""], ["",[[],[]],[[],[]]], [15,20,20], false, DayZMod V1.8.6.1, Survivor2_DZ, true, false"
14:23:26 "CLEANUP: INITIALIZING CLEANUP SCRIPT"
14:23:26 "CRASHSPAWNER: Starting spawn logic for Crash Spawner"
14:23:26 "z\addons\dayz_server\compile\server_playerSetup.sqf DEBUG ["1",B 1-1-B:1 (Cap_Nemesis) REMOTE,"76561198006395951",9]"
14:23:26 ["Character data: blood_type,rh_factor,testdone=","A",true,false]
14:23:26 "LOGIN PUBLISHING: UID#76561198006395951 CID#1 PID#3(Cap_Nemesis) as Survivor2_DZ should spawn at Elektrozavodsk [104:131]"
14:23:27 ["z\addons\dayz_server\system\scheduler\sched_sync.sqf","TIME SYNC: Local Time set to:",[2012,8,2,8,23],"Fullmoon:",true,"Date given by HiveExt.dll:",[2015,6,7,8,23]]
14:23:28 "z\addons\dayz_server\compile\fn_bases.sqf found a nice spot at Wilderness [100:30] (9)"
14:23:28 "CRASHSPAWNER: Spawning 'Mi-8 Wreck' with loot table 'HeliCrashEAST' at [9032.42,10735.5,0]"
14:23:31 "Infected Camps: Loot spawned at 'Camp2_Small' with total loot '16'"
14:23:32 "Infected Camps: Wrecks spawned at 'Camp2_Small' with total Bodys '9'"
14:23:33 UH1Wreck_DZ: MainTurret - unknown animation source MainTurret
14:23:33 UH1Wreck_DZ: MainGun - unknown animation source mainGun
14:23:33 UH1Wreck_DZ: Gatling - unknown animation source Gatling
14:23:34 "CRASHSPAWNER: Spawning 'Crashed UH-1Y' with loot table 'HeliCrashWEST' at [4054.96,12314.9,0.0694733]"
14:23:35 "z\addons\dayz_server\compile\fn_bases.sqf found a nice spot at Guglovo [83:81] (9)"
14:23:35 "Infected Camps: Loot spawned at 'Camp3_Small' with total loot '15'"
14:23:36 "CRASHSPAWNER: Spawning 'Crashed UH-1Y' with loot table 'HeliCrashWEST' at [3955.77,7834.42,0.00115967]"
14:23:36 "Infected Camps: Wrecks spawned at 'Camp3_Small' with total Bodys '6'"
14:23:36 "z\addons\dayz_server\compile\fn_bases.sqf found a nice spot at Dubrovka [108:48] (9)"
14:23:38 "Infected Camps: Loot spawned at 'Camp2_Small' with total loot '13'"
14:23:38 "Infected Camps: Wrecks spawned at 'Camp2_Small' with total Bodys '6'"
14:23:38 "z\addons\dayz_server\compile\fn_bases.sqf: found 3 camps spots in 12 sec."
14:23:39 "DEBUG: Spawning a "Misc_cargo_cont_net1" at [6427.32,7669.42,0] with loot type "Hospital" With total loot drops = 6"
14:23:40 "DEBUG: Spawning a "Misc_cargo_cont_net1" at [7246.64,5164.97,0] with loot type "CarePackages" With total loot drops = 3"
14:23:47 Warning: looped for animation: ca\anims\characters\data\anim\sdr\mov\erc\wlk\non\non\amovpercmwlksnonwnondf.rtm differs (looped now 1)! MoveName: amovpercmrunsnonwbindf_rfl
14:24:00 Server: Object 3:53 not found (message 94)
14:24:00 Server: Object 3:55 not found (message 91)
14:24:00 Server: Object 3:54 not found (message 99)
14:24:00 Server: Object 3:56 not found (message 98)
14:24:00 Server: Object 3:57 not found (message 91)
14:24:00 Server: Object 3:58 not found (message 98)
14:24:00 Server: Object 3:59 not found (message 91)
14:24:00 Server: Object 3:60 not found (message 70)
14:24:00 Server: Object 3:61 not found (message 94)
14:24:00 Server: Object 3:62 not found (message 99)
14:24:00 Server: Object 3:63 not found (message 91)
14:24:00 Server: Object 3:64 not found (message 99)
14:24:00 Server: Object 3:65 not found (message 91)
14:24:00 Server: Object 3:66 not found (message 70)
14:24:00 Server: Object 3:67 not found (message 70)
14:24:00 Server: Object 3:68 not found (message 70)
14:24:00 Server: Object 3:69 not found (message 70)
14:24:00 Server: Object 3:70 not found (message 94)
14:24:00 Server: Object 3:71 not found (message 70)
14:24:00 Server: Object 3:72 not found (message 70)
14:24:00 Server: Object 3:73 not found (message 70)
14:24:00 Server: Object 3:74 not found (message 70)
14:24:00 Server: Object 3:75 not found (message 70)
14:24:00 Server: Object 3:76 not found (message 70)
14:24:00 Server: Object 3:77 not found (message 94)
14:24:00 Server: Object 3:78 not found (message 94)
14:24:00 Server: Object 3:79 not found (message 70)
14:24:00 Server: Object 3:80 not found (message 94)
14:24:00 Server: Object 3:81 not found (message 94)
14:24:00 Server: Object 3:82 not found (message 70)
14:24:00 Server: Object 3:83 not found (message 70)
14:24:00 Server: Object 3:84 not found (message 70)
14:24:00 Server: Object 3:85 not found (message 70)
14:24:03 ["sched_lootpiles_5mn: reset lootpiles check, total visited:",95,"listed:",0]
14:24:12 "get: STRING (76561198006395951), sent: STRING (76561198006395951)"
14:24:12 "Player UID#76561198006395951 CID#1 PID#1(Cap_Nemesis) as Survivor2_DZ, logged off at Elektrozavodsk [104:131]"
14:24:12 Client: Remote object 3:9 not found
14:24:12 Warning: Cleanup player - person 3:8 not found

[pjohnson7 7]

I was able to spawn more vehicles, but now i can't find them in game, i go to them thru DB and they are not there.

 

This is the RPT if help.

 

in your OBJECT_DATA table,  do the vehicles have the same INSTANCE number as your server? 

[alanbr00 0]

Yeah that was the problem. FIXED!

 

Thanks to all for the help.

 

And about max local zombies? you know where do i edit?

[jbraddock 1]

It only spawns a maximum amount of vehicles based on group.

 

Where do you find this setting to alter it?