Celle 1.7.5.1 Vehicles problem!

DjTranceFire

New Member
Its impossible to use the mission file for Celle 1.7.5.1!
Graz added vehicles directly into the Mission file and everyone who enters them just explodes.
The mission.sqm has more then 26.000 lines with more then 2600 Items so its impossible to find and delete all vehicles that are added by the mission and not by the database.
I think we need a new mission.sqm without vehicles and a list of all vehicles from the mission to add them to the database by hand.
 
Which vehicles?

Are you using the latest server files? The 'kill hacker' code isn't present in the server files that have been released.

The objects that have been added is something like 4,000. Doing it by hand is a monumental task for admins. An sqm file is more convenient
 
hmm i was wonderring why my reality server only spawned the old vehicles from the previous celle release..
but its mission sided now? how will those vehicles save their locations and contents if they dont exist in the database?
 
Thats impossible and thats the problem i think.
A clean mission and a seperate database vehicle table would be the best.
@Graz:
All the objects are not the problem.
There are fine in the mission.
Just the vehicles should ALL be inside the dabase
I dont think there are 4000 vehicles?!
 
if players lose their vehicles after a restart they will definately not like this update :)
also admins will not have any controll over verhicles not in the database.
 
if you could just dump the classname + worldspace grid for all driveable/fyable vehicles, i can look into making it a usable schema update for reality :)

those really dont belong in the missionfile (atleast not in dayz, for wasteland it would be fine)
 
If you need help (if there are to many vehicles) i would help you! ;)
But on all this Items its impossible for me to find and extract all vehicles.. :D
 
We have these in our DB, additional to those of 1.7.4:

Code:
MH6J_DZ
GazelleUN
BAF_Merlin_DZC
AW159_Lynx_DZC
 
HMMWV_DZ
HMMWV_M2_DZ
HMMWV_TOW_DZ
LandRover_MG_TK_INS_EP1_DZ
LandRover_SPG9_TK_EP1_DZ
LandRover_Special_CZ_EP1_DZ
Offroad_DSHKM_TK_DZ
tractorOld
Pickup_PK_TK_DZ
UAZ_MG_INS_DZ
 
merlin are unbanned really? ( sry if it happens in earlier dayz versions, my really good last stand was hmm 1.2.x.x ) and the AW159 is the AZ-11 Wildcat version or witch one exactly? Is there maybe a sql file with vehicle spawns? The one from reality is really shit and i think its the version from chernarus because at 1 location the vehicle was in the river :D
 
oh wow those are unbanned? since graz never came with a list im just running the default dayz vehicles from 1.7.4 :)
 
I now testest those vehicles.
Result: 12 of them do work. I did not get the vehicles that are already included in the hive to work.
Now if you want them playable on you server, you have to do the following:

Step1: Insert them into your hive vehicle table.
Based on Reality, we have first to insert them to the global vehicle table!
Code:
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2000, 'GazelleUN', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,elektronika,mala vrtule,velka vrtule', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2001, 'BAF_Merlin_DZC', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,elektronika,mala vrtule,velka vrtule', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2002, 'AW159_Lynx_DZC', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,elektronika,mala vrtule,velka vrtule', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2003, 'HMMWV_M2_DZ', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,karoserie,palivo,wheel_1_1_steering,wheel_2_1_steering,wheel_1_2_steering,wheel_2_2_steering,sklo predni P,sklo predni L', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2004, 'HMMWV_TOW_DZ', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,karoserie,palivo,wheel_1_1_steering,wheel_2_1_steering,wheel_1_2_steering,wheel_2_2_steering,sklo predni P,sklo predni L', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2005, 'LandRover_MG_TK_INS_EP1_DZ', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,karoserie,palivo,wheel_1_1_steering,wheel_2_1_steering,wheel_1_2_steering,wheel_2_2_steering,sklo predni P,sklo predni L', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2006, 'LandRover_SPG9_TK_EP1_DZ', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,karoserie,palivo,wheel_1_1_steering,wheel_2_1_steering,wheel_1_2_steering,wheel_2_2_steering,sklo predni P,sklo predni L', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2007, 'LandRover_Special_CZ_EP1_DZ', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,karoserie,palivo,wheel_1_1_steering,wheel_2_1_steering,wheel_1_2_steering,wheel_2_2_steering,sklo predni P,sklo predni L', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2008, 'Offroad_DSHKM_TK_DZ', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,karoserie,palivo,wheel_1_1_steering,wheel_2_1_steering,wheel_1_2_steering,wheel_2_2_steering,sklo predni P,sklo predni L', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2009, 'tractorOld', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,karoserie,palivo,wheel_1_1_steering,wheel_2_1_steering,wheel_1_2_steering,wheel_2_2_steering,sklo predni P,sklo predni L', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2010, 'Pickup_PK_TK_DZ', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,karoserie,palivo,wheel_1_1_steering,wheel_2_1_steering,wheel_1_2_steering,wheel_2_2_steering,sklo predni P,sklo predni L', '[]');
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES (2011, 'UAZ_MG_INS_DZ', 0.100, 0.700, 0.200, 0.800, 0, 0, 'motor,karoserie,palivo,wheel_1_1_steering,wheel_2_1_steering,wheel_1_2_steering,wheel_2_2_steering,sklo predni P,sklo predni L', '[]');

Attention: I used IDs above 2000 because it makes it more easy to remove when they are officialy implemented in the hive!


Step2: Insert them in the world vehicle table of your hive.
This is done so the hive knows that these vehicles belong to celle.

However, I for testing purposes I did not use the positions from the mission, I let them spawn somewhere that I can see them side by side.

YOU HAVE TO ALTER THE POSITIONS ACCORDING TO THE MISSION FILE - else they will spawn at south airfield in about 5m distance to each other.
Code:
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10034, 2000, 9, '[260,[8267.33,1312.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10035, 2001, 9, '[260,[8263.33,1316.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10036, 2002, 9, '[260,[8257.33,1320.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10037, 2003, 9, '[260,[8254.33,1325.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10038, 2004, 9, '[260,[8250.33,1333.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10039, 2005, 9, '[260,[8245.33,1300.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10040, 2006, 9, '[260,[8240.33,1290.0,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10041, 2007, 9, '[260,[8235.33,1280.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10042, 2008, 9, '[260,[8230.33,1272.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10043, 2009, 9, '[260,[8225.33,1264.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10044, 2010, 9, '[260,[8220.33,1256.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10045, 2011, 9, '[260,[8215.33,1248.9,0.001]]', NULL, 0.700, '0.00');
 
/* these vehicles do already exist in the hive!*/
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10046, 92, 9, '[260,[8210.33,1210.9,0.001]]', NULL, 0.700, '0.00');
INSERT INTO `world_vehicle` (`id`, `vehicle_id`, `world_id`, `worldspace`, `description`, `chance`, `last_modified`) VALUES (10047, 93, 9, '[260,[8205.33,1310.9,0.001]]', NULL, 0.700, '0.00');


Step3: Spawn vehicles.
If you want to test all vehicle positions, try this modified vehicle spawn script I attached. This will spawn all vehicles ignoreing theyre maxLimit to test the vehicles positions (and without having to execute the script 1000 times ^^)


I hope this helps, however: EDIT THE SPAWN POSITIONS. The ones I postet here will not make you happy :p
 

Attachments

  • db_spawn_vehicles-ALL.zip
    2.5 KB · Views: 13
Back
Top