f3cuk

Depends on BEC version. As of BEC 1.6 your setup wont work anymore. If your file doesnt work its safe to assume you are running on >= 1.6. You mention working restarts, since only #shutdown (which does not restart anything) is handled in this file i'm guessing restart are handled differently by your host.

Minor correction needed, remove the 'id' from the columns list (as such):
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('["ItemORP",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemTNK",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemLRK",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemAVE",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'); Thanks for posting these f3cuk!

What this does
 
Remove all server spawned - or force unlocked - vehicles that have no gear in them and haven't been updated in the last hour on restart.
 
Why you might want this
 
It makes room for fresh vehicles to spawn so there are actually new vehicles on the coast each restart. Plus it helps cleanup vehicles that are never found / used.
 
Why the no gear and update exclusion

You can take them out if you want. But its mainly to ensure people dont get fucked over. You don't want your precious gear to get deleted on restart and neither do you want your vehicle you were just driving before restart to dissapear on you, leaving you all alone in the wilderness :P.
 
---
 
First things first
 
BACKUP YOUR DATABASE BEFORE DOING ANY CHANGES TO THEM
 
1.) Okay you gonna wanna start by running this query to check if it selects the right objects for you.
SELECT    * FROM     `object_data` WHERE     `LastUpdated` < DATE_SUB(NOW(), INTERVAL 1 HOUR) AND     `CharacterID` = 0 AND (     `Inventory` = '[]'     OR     `Inventory` = '[[[],[]],[[],[]],[[],[]]]'  ) This query will not transform anything but just check to see if it finds any matches. Depending on your settings it should find quite a few vehicles, our server is pretty new. We got maxvehicles @ 350 and it finds about ~250 vehicles. After running this query you will have to go through the results and see if it didnt select any vehicles you don't want to get deleted.
 
2.) If all goes well and you are satisfied with the selected vehicles, it's safe to assume the query is working for you and we can go ahead by implementing it. (There's is probably al lot ways to do this, i chose to do it in my restart.bat file, just after backing up the database.)

My restart.bat
@echo off cd C:\path\to\zombieland echo Stopping server start /wait zombieland_stop.bat echo Backing up database start /wait zombieland_backup.bat echo Refresh vehicles start /wait refresh_vehicles.bat echo Starting BEC cd C:\path\to\bec start Bec.exe -f Config.cfg echo Starting server cd C:\path\to\zombieland start "arma2" /min /affinity 3 "arma2oaserver.exe" -port=2302 "-config=instance_11_Chernarus\config.cfg" "-cfg=instance_11_Chernarus\basic.cfg" "-profiles=instance_11_Chernarus" -name=instance_11_Chernarus "-mod=@DayZ_Epoch;@hive;" -maxMem=2047 ping 127.0.0.1 -n 5 >NUL Notice the "start /wait zombieland_refresh.bat", that's where the magic happens. The /wait ensures it waits to finish.
 
3.) Create a file called refresh_vehicles.sql and save it in your server folder. Add below code
 
Replace
{database_name} with the name of your database. USE {database_name}; DELETE FROM     `object_data` WHERE     `LastUpdated` < DATE_SUB(NOW(), INTERVAL 1 HOUR) AND     `CharacterID` = 0 AND (     `Inventory` = '[]'     OR     `Inventory` = '[[[],[]],[[],[]],[[],[]]]'  ) 4.) Create a file called refresh_vehicles.bat and add below code
 
Replace
{username} with you database username {password} with your database password {path_to_mysql_bin_folder} with the path to your mysql bin folder (e.g. C:\xampp\mysql\bin) {path_to_refresh_vehicles} with the path to your refresh_vehicles.sql (e.g. C:\servername\ @echo off cd {path_to_mysql_bin_folder} mysql.exe -u {username} -p{password} < {path_to_refresh_vehicles}refresh_vehicles.sql exit 5.) You are now done and set for restart!
 
--
 
6.) Optionally lower the MaxVehicleDamage in your init.sqf to ensure less broken vehicles.

Think it is this.
 
 
Yeah that sucks. I actually hacked around it to make both DZC and DZL work with just one installation.

In start type CMD and run as admin. Then use this command to create a folder shortcut for DZC to recognize Epoch (1051)
mklink /J "C:\Program Files (x86)\Steam\steamapps\common\Arma 2 Operation Arrowhead\@DayZ_Epoch" "C:\Program Files (x86)\Steam\steamapps\common\Arma 2 Operation Arrowhead\@DayZ_Epoch1051" Obviously you wanna change the paths to suit yours.

I have nuanced ours a bit. Setting realistic prices and removing some vehicles that are not popular. For anyone interested:
 
Vehicles
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('["SUV_TK_CIV_EP1_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["datsun1_civil_1_open_DZE4",2]', 10, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["datsun1_civil_3_open_DZE4",2]', 10, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["hilux1_civil_1_open_DZE4",2]', 10, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["hilux1_civil_2_covered_DZE4",2]', 10, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["hilux1_civil_3_open_DZE4",2]', 10, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["UAZ_CDF_DZE4",2]', 10, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["UAZ_INS_DZE4",2]', 10, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["UAZ_RU_DZE4",2]', 10, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["UAZ_Unarmed_TK_EP1_DZE4",2]', 10, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["UAZ_Unarmed_UN_EP1_DZE4",2]', 10, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["VWGolf_DZE4",2]', 9, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["VolhaLimo_TK_CIV_EP1_DZE4",2]', 10, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["Offroad_DSHKM_Gue_DZE4",2]', 10, '[8,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_Green_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_Yellow_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_White_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_Silver_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_Red_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_Pink_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_Orange_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_Charcoal_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_Blue_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["SUV_Camo_DZE4",2]', 10, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'), ('["UAZ_Unarmed_TK_CIV_EP1_DZE4",2]', 10, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, [INSERT_TRADER_ID_HERE], 'trade_any_vehicle'); Vehicle upgrade items
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('["ItemORP",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemTNK",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemLRK",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemAVE",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items');

Title says it all.
 
ALWAYS BACK UP YOUR DATABASE BEFORE DOING CHANGES
 
1.) First run this query to add the category (double check if 143 is the hero trader for you)
INSERT INTO `trader_tids` (`sort`, `name`, `trader`) VALUES (NULL, 'Upgraded Vehicles', 143); Copy the id of the inserted row.
 
---
 
2.) Then run this query to add the vehicles:
IMPORTANT: Replace [iNSERT TRADER ID HERE] with the id of the inserted row. Change prizes to suit your needs INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["SUV_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Green_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Yellow_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_White_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Silver_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Red_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Pink_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Orange_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Charcoal_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Blue_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Camo_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Offroad_DSHKM_Gue_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["VolhaLimo_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Volha_1_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Volha_2_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["VWGolf_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Skoda_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SkodaBlue_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SkodaRed_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SkodaGreen_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["car_hatchback_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["car_sedan_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["datsun1_civil_1_open_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["datsun1_civil_3_open_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Lada1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Lada2_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["LadaLM_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Lada1_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Lada2_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["hilux1_civil_1_open_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["hilux1_civil_2_covered_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["hilux1_civil_3_open_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_CDF_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_INS_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_RU_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_Unarmed_TK_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_Unarmed_UN_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_Unarmed_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'); 3.) Find server_traders.sqf in your mission PBO and add
IMPORTANT: Replace [iNSERT TRADER ID HERE] with the id of the inserted row Note: Place it somewhere else in the array if you want to change the sort position ["Upgraded Vehicles",[INSERT TRADER ID HERE]], After
["Military Armed",562] 4.) Additionaly you can also add the documents to the trader, use this
IMPORTANT: Replace [iNSERT TRADER ID HERE] with the id of the inserted row. change prizes to suit your needs INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('["ItemORP",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemTNK",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemLRK",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemAVE",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'); --
 
Edit: Almost perfect. Anyone know a fix how to add the vehicles names and not only show the classnames?

Edit: I'm an idiot, forgot to add the vehicles using 2. Working fine now.

 

Title says it all.
 
ALWAYS BACK UP YOUR DATABASE BEFORE DOING CHANGES
 
1.) First run this query to add the category (double check if 143 is the hero trader for you)
INSERT INTO `trader_tids` (`sort`, `name`, `trader`) VALUES (NULL, 'Upgraded Vehicles', 143); Copy the id of the inserted row.
 
---
 
2.) Then run this query to add the vehicles:
IMPORTANT: Replace [iNSERT TRADER ID HERE] with the id of the inserted row. Change prizes to suit your needs INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["SUV_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Green_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Yellow_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_White_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Silver_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Red_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Pink_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Orange_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Charcoal_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Blue_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SUV_Camo_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Offroad_DSHKM_Gue_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["VolhaLimo_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Volha_1_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Volha_2_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["VWGolf_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Skoda_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SkodaBlue_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SkodaRed_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["SkodaGreen_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["car_hatchback_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["car_sedan_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["datsun1_civil_1_open_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["datsun1_civil_3_open_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Lada1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Lada2_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["LadaLM_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Lada1_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["Lada2_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["hilux1_civil_1_open_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["hilux1_civil_2_covered_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["hilux1_civil_3_open_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_CDF_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_INS_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_RU_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_Unarmed_TK_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_Unarmed_UN_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'), ('["UAZ_Unarmed_TK_CIV_EP1_DZE4",2]', 250, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, [INSERT TRADER ID HERE], 'trade_any_vehicle'); 3.) Find server_traders.sqf in your mission PBO and add
IMPORTANT: Replace [iNSERT TRADER ID HERE] with the id of the inserted row Note: Place it somewhere else in the array if you want to change the sort position ["Upgraded Vehicles",[INSERT TRADER ID HERE]], After
["Military Armed",562] 4.) Additionaly you can also add the documents to the trader, use this
IMPORTANT: Replace [iNSERT TRADER ID HERE] with the id of the inserted row. change prizes to suit your needs INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('["ItemORP",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemTNK",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemLRK",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'), ('["ItemAVE",1]', 250, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, [INSERT TRADER ID HERE], 'trade_items'); --
 
Edit: Almost perfect. Anyone know a fix how to add the vehicles names and not only show the classnames?

Edit: I'm an idiot, forgot to add the vehicles using 2. Working fine now.

 

Hi guys, its pain to find these class names on internets, so I pretty much had to write them down myself from infistar's menu
This list is for those who are adding custom vehicles to traders or dynamic spawns
Hopefully somebody finds this useful:
 
Vehicles:



Air:

Meh couldn't disagree more.
 
Is it BI's fault that a great many server owners and hosters are simply incompetent? Sure you can't expect them to fix any server that broke during update? Server owners should have known this was a major update and they should have anticipated better by staging a test environment (everyone can create a local test server on their own PC) for the latest patch (it has been out a while). If you fail to do so and postpone updating to the last day and then try to it with little or no knowledge on how to actually fix problems/errors might they occur, then - in my opinion - there is no one else to blame but yourself.
 
Obviously the community is here to help, but if you do not know how to fix stuff yourself, the least you can do is be patient when you ask others to fix it for you. In the meanwhile search the forums and actually try reading the numerous threads about the update. Cause 9 out of 10 questions asked have already been answered.

Meh couldn't disagree more.
 
Is it BI's fault that a great many server owners and hosters are simply incompetent? Sure you can't expect them to fix any server that broke during update? Server owners should have known this was a major update and they should have anticipated better by staging a test environment (everyone can create a local test server on their own PC) for the latest patch (it has been out a while). If you fail to do so and postpone updating to the last day and then try to it with little or no knowledge on how to actually fix problems/errors might they occur, then - in my opinion - there is no one else to blame but yourself.
 
Obviously the community is here to help, but if you do not know how to fix stuff yourself, the least you can do is be patient when you ask others to fix it for you. In the meanwhile search the forums and actually try reading the numerous threads about the update. Cause 9 out of 10 questions asked have already been answered.

Meh couldn't disagree more.
 
Is it BI's fault that a great many server owners and hosters are simply incompetent? Sure you can't expect them to fix any server that broke during update? Server owners should have known this was a major update and they should have anticipated better by staging a test environment (everyone can create a local test server on their own PC) for the latest patch (it has been out a while). If you fail to do so and postpone updating to the last day and then try to it with little or no knowledge on how to actually fix problems/errors might they occur, then - in my opinion - there is no one else to blame but yourself.
 
Obviously the community is here to help, but if you do not know how to fix stuff yourself, the least you can do is be patient when you ask others to fix it for you. In the meanwhile search the forums and actually try reading the numerous threads about the update. Cause 9 out of 10 questions asked have already been answered.

DayZ Launcher
The DayZ Launcher is no longer black listed so with Macas permission I have setup the official thread for people to use to report any problems on and give feedback on. It will also be updated when the launcher gets updated with the changes.
 
Download: http://dayzlauncher.com/
Support and Requests: Post on this thread or check http://epochservers.com/viewforum.php?f=38
VIrusTotal Report: https://www.virustotal.com/en/url/94b951a3c4f1719e523ece89ffd36949ad53c88658489cff44d8758f0071f9bb/analysis/1406059671/ & https://www.virustotal.com/en/file/65345df4b97352606553830a357f0405d89c5d1ed87a81ee51eb19044b58ed43/analysis/1406059676/
HowTo DayZ Launcher

 
Change Log
 
Version 0.0.0.6
New - Auto Updater (http://puu.sh/axPS1/71fb81c5c4.png & http://puu.sh/axQ2T/2f3c45dd4b.png)
New - Mod Page Layour
New - Ping/Location Filters
New - Link your server on your website using dzl://IP:QueryPort to have people join your server from your website. E.G dzl://1.2.3.4:27016 when ran will load DZL and start you joining ingame
New - Checks for more than one instance of Arma, offers to close it.
Fixed - Launch(Quick) no longer loads the IP:PORT from the advanced page so it loads only the mods selected to and opens the game
Fixed - Server name/mod updated on refresh so you do not need to wait 5 minutes for it to update.
 
Version 0.0.0.5


 
Version0.0.0.4


 
If you have any other problems or questions then please post below and they will be passed on to the developer.

Check out this proposed fix by dayzebay:

Okay can confirm the metal floor issue still persist in the latest version.

Before restart



 
After restart

==================================Step by Step guide================================
I have alot of custom scripts and files in my server, so i decided to look into the custom scripts from RimBlock and search what he has changed so i can make a step by step guide for guys who have the same problem like me. But ok lets start now.
 
Required:
-Time about an hour
-Custom compiles.sqf
-A general knowledge about scripting and formating
-Brain.exe
 
At first here is a file list compare it with your custom folder if some files are missing get them from the DayZ_Code.pbo.


If you checked theese list and maked sure that you have every file, you can start with the compiles.sqf
Remeber, i use my own file path´s, if you have another folder who is not named "Custom" you need to change the path´s to fit your folders.
I also call the custom compiles.sqf twice, so first the original one then the custom one, so my compiles.sqf looks like this:



So, now we came to the changes in every file:
fn_damageActions.sqf


 Fn_sefactions.sqf


 player_packtent.sqf


player_unlockvault.sqf


remove.sqf


player_updateGui.sqf


tent_pitch.sqf


vault_pitch.sqf


player_build.sqf


player_buildingDowngrade.sqf


player_tagfriendly.sqf


player_upgrade.sqf


Server_monitor.sqf


Now go to your init.sqf
and find:
_serverMonitor = [] execVM "\z\addons\dayz_code\system\server_monitor.sqf"; and replace it with your custom path pointing to your custom folder in my case it looks like this:
 
_serverMonitor = [] execVM "custom\server_monitor.sqf"; For me everything is working, i dont test the script before, i doed exact the same like above and its working for me with vanilla epoch and with my normal MPmission where i have about 22 custom files from the dayz_code.pbo.
#Edit: fixxed some synatx errors in my instruction

If you got no errors then it would appear you set up the adminlist.sqf wrong. Please make sure it is right, you might want to show it here so we could check. Check your player_data table in the database to make sure you got the right PlayerID.

Btw it's "doesn't" :P