Container

This Video Tutorial covers:
Add custom Traders anywhere on map
Find positions on map (also covering safezones/sensors a little bit)
Add your own custom Menus to traders
Add all Overwatch weapons, ammo and vehicles to your menus
Use notepad++ to convert Loot CFG (or literary ANY) file into SQL query that you can to insert items faster into database.
 
Notepad++ tricks:
I will show you some cool tricks how to clean out junk data from files, filter out only stuff you need and convert it into a different code that can be used elsewhere.
In this video I will be using Macros, TextFX and Find&Replace options to show you awesome stuff you can do with notepad++ to affect thousands of lines automatically!
You will need TextFX plugin.
 
SQL:
I am using Heidi SQL to edit my databases. Any other tool is very well capable of doing the same job well. I just love filtering on heidi. It's also free.
This is by no means targeted towards advanced users, beginners only. If you are advanced user and dislike the method, please share your method instead for all of us to learn from.
I am not sharing actual SQL code because database names differs for different hosts, also I think notepad++ tricks are awesome thing to know, might be handy in future.
In fact If database structure ever changes, you can reuse tricks learned here instead to update it quickly.
 
Overwatch vehicles used in video:



Alternative list of all Overwatch weapons/ammo/vehicles (Test out your new Notepad++ skill and convert it into SQL!)
PROTIP: if using alternative list - to filter out ammo from weapons Write Ammo Type: in search, leave search window open. Then create macro:
[Home] > [F3] > [shift]+[END] > [DEL] > [Down] > [Home]
This will delete last part on all rows that says ammo and leave weapons only. Apply similar method to delete weapons instead.
 
Credits and [How to] Install server: infiSTAR for awesome AH/Admin tool
 

 
00:00 - 20:00 Adding traders 20:00 - 35:05 Notepad++ filtering out the junk 35:05 - 36:40 Notepad++ TextFX deleting duplicate rows 36:40 - 41:55 Notepad++ Seperating ammo from weapons using macros 41:55 - 57:42 Converting classnames into SQL query (adding stuff to traders in database) 57:42 - Final in-game test

For those of you using DZMS or EMS
 



 
For those using WAI missions:
 



 
Config traders:
server_traders.sqf
//UPDATE ARRAY ON TOP! serverTraders = ["Winter_SOF_DA1b", //Overpoch menu_Winter_SOF_DA1b = [ [["Pistols",900],["RH",901],["FHQ",902],["Vil",903],["Misc",904],["Ammo",905],["Vehicles",906]], [], "neutral" ]; Dayz_Epoch_11.Chernarus\mission.sqf (dayz_server.pbo): (animated badass looking traders)
_unit_670 = objNull; if (true) then { _this = createAgent ["Winter_SOF_DA1b", [6296.33,7803.79,0], [], 0, "CAN_COLLIDE"]; _unit_670 = _this; _this setDir 310; _this setVehicleInit "this allowDammage false; this disableAI 'FSM'; this disableAI 'MOVE'; this disableAI 'AUTOTARGET'; this disableAI 'TARGET'; this setBehaviour 'CARELESS'; this forceSpeed 0;"; _this setUnitAbility 0.60000002; _this allowDammage false; _this disableAI 'FSM'; /*_this disableAI 'MOVE';*/ _this disableAI 'AUTOTARGET'; _this disableAI 'TARGET'; _this setBehaviour 'CARELESS'; _this forceSpeed 0;/*_this enableSimulation false;*/}; _unit_671 = objNull; if (true) then { _this = createAgent ["Winter_SOF_DA1b", [11449.9,11349.8,0], [], 0, "CAN_COLLIDE"]; _unit_671 = _this; _this setDir 120; _this setVehicleInit "this allowDammage false; this disableAI 'FSM'; this disableAI 'MOVE'; this disableAI 'AUTOTARGET'; this disableAI 'TARGET'; this setBehaviour 'CARELESS'; this forceSpeed 0;"; _this setUnitAbility 0.60000002; _this allowDammage false; _this disableAI 'FSM'; /*_this disableAI 'MOVE';*/ _this disableAI 'AUTOTARGET'; _this disableAI 'TARGET'; _this setBehaviour 'CARELESS'; _this forceSpeed 0;/*_this enableSimulation false;*/}; _unit_672 = objNull; if (true) then { _this = createAgent ["Winter_SOF_DA1b", [4030.66,11678.5,0], [], 0, "CAN_COLLIDE"]; _unit_672 = _this; _this setDir 140; _this setVehicleInit "this allowDammage false; this disableAI 'FSM'; this disableAI 'MOVE'; this disableAI 'AUTOTARGET'; this disableAI 'TARGET'; this setBehaviour 'CARELESS'; this forceSpeed 0;"; _this setUnitAbility 0.60000002; _this allowDammage false; _this disableAI 'FSM'; /*_this disableAI 'MOVE';*/ _this disableAI 'AUTOTARGET'; _this disableAI 'TARGET'; _this setBehaviour 'CARELESS'; _this forceSpeed 0;/*_this enableSimulation false;*/}; Overpoch.hpp:
http://pastebin.com/nfp5sbAL
 
Instructions:
Create new overpoch.hpp file near rest of configs and update your cfgServerTrader.hpp file like so (just add that single line):
#include "Category\NeutralWholesale.hpp" #include "Category\Overpoch.hpp" }; note: I feel obligated to remind you to use your own folder structure in these lines. In my example I have all my trader .hpp files inside "Category" folder that is found in root of mission file.

DZMS is a logic and useability rewrite of the DayZChernarus Mission System.
DZMS should be considered as an "updated" DayZChernarus Mission System.

Why Use DZMS instead of DayZChernarus MS?
DZMS has a simple Configuration File, no more digging through code No more junk code! (Anyone who has read add_unit_server will understand) Simple Install! DZMS Requires a single line edit. No more server_cleanup confusion! No more messy mission code! DZMS uses functions for most code. DZMS is rewrote with all maps in mind, not just Chernarus. Hence the Generic Rename. DZMS is completely server sided! No marker files needed in the Mission PBO! No more "Novy Sobor Bug"! Plus, many features have been added!
Option to save vehicles to the database! If Vehicle Saving is off, Users are warned when entering vehicles! Randomized Crate Loot! No more static crate loot! Adjustable Body Despawn Time! Optional: AI Ran Over have no gear! More!  
The Current Version is v1.2

Download Instructions: https://github.com/SMVampire/DZMS-DayZMissionSystem
Project Tracking: https://github.com/SMVampire/DZMS-DayZMissionSystem/projects
 
(Note: I have given The Fuchs permission to use DZMS as the base for EMS.)

hey guys, first of all i just want to say i didn't make this if anyone thinks i did because im a noob at scripting and all.
but after reading about 10 posts i fixed the towing and lifting so people won't get kicked. and im not 100% sure if this counts as a release because i didn't make this. please tell me if i don't have the right to post this.
i don't know how to do it with anit-hacks like infistar only the battleye filters.
so first download this
(link removed) and extract it then add the R3F_ARTY_AND_LOG to  the directory of your mission.pbo and add this to the end of your init.sqf sorry guys i had to remove the link above. please download using the link below.
download this version http://www72.zippyshare.com/v/47077164/file.html it is the same as the first download but the list of vehicles are fixed. so you can't lift helicopters with another vehicle or lift planes with helicopters or tow helicopters with a car. you can still tow a plane so you can unstuck those stuck planes :D
//Tow and lift execVM "R3F_ARTY_AND_LOG\init.sqf"; then edit your attachto.txt in your dayz.epoch.chernarus/battleye
so it look like this
//new 1 "" !="VaultStorageLocked" !="LockboxStorageLocked" !="Hedgehog_DZ" !="Sandbag1_DZ" !="Fort_RazorWire" !="WoodGate_DZ" !="Land_HBarrier1_DZ" 1 "Ikarus" 1 "UH1H_DZE" 1 "Mi17_Civilian_DZ" 1 "Mi17_DZE" 1 "KamazRefuel_DZ" 1 "UralRefuel_TK_EP1_DZ" 1 "MtvrRefuel_DES_EP1_DZ" 1 "Ural_UN_EP1" 1 "Ural_TK_CIV_EP1" 1 "Ural_CDF" 1 "Kamaz" 1 "CSJ_GyroP" 1 "MH6J_DZ" 1 "AH6X_DZ" 1 "MTVR_DES_EP1" 1 "V3S_Civ" 5 "Parachute" 5 "VaultStorage" !"VaultStorageLocked" 5 "LockboxStorage" !"LockboxStorageLocked" then in your setpos.txt in the first line add all the vehicles that you are towing and lifting so its like
!"vehiclename" !"vehiclename" and so on.
this is what it my setpos look like
//new 5 "" !"FunctionsManager" !"Shot" !"z_doctor" !"z_hunter" !"z_new_villager1" !"z_new_villager2" !"z_new_villager3" !"z_new_villager4" !"z_new_worker1" !"z_new_worker2" !"z_new_worker3" !"z_new_worker4" !"z_policeman" !"z_priest" !"z_soldier_heavy" !"z_soldier_pilot" !"z_soldier" !"z_suit1" !"z_suit2" !"z_teacher" !"z_villager1" !"z_villager2" !"z_villager3" !"z_worker1" !"z_worker2" !"z_worker3" !"zZombie_Base" !"AN2_DZ" !"ATV_CZ_EP1" !"ATV_US_EP1" !"ArmoredSUV_PMC_DZ" !"C130J_US_EP1" !"CH_47F_EP1_DZ" !"CSJ_GyroC" !"CSJ_GyroCover" !"CSJ_GyroP" !"Fishing_Boat" !"GAZ_Vodnik" !"GAZ_Vodnik_MedEvac" !"GLT_M300_LT" !"GLT_M300_ST" !"GNT_C185" !"GNT_C185C" !"GNT_C185R" !"GNT_C185U" !"HMMWV_Ambulance" !"HMMWV_Ambulance_CZ_DES_EP1" !"HMMWV_DES_EP1" !"HMMWV_DZ" !"HMMWV_M1035_DES_EP1" !"HMMWV_M1151_M2_CZ_DES_EP1" !"HMMWV_M998A2_SOV_DES_EP1" !"Ikarus" !"Ikarus_TK_CIV_EP1" !"JetSkiYanahui_Case_Blue" !"JetSkiYanahui_Case_Green" !"JetSkiYanahui_Case_Red" !"JetSkiYanahui_Case_Yellow" !"KamazRefuel_DZ" !"Lada1" !"Lada1_TK_CIV_EP1" !"Lada2" !"Lada2_TK_CIV_EP1" !"LadaLM" !"LandRover_CZ_EP1" !"LandRover_MG_TK_EP1" !"LandRover_Special_CZ_EP1" !"LandRover_TK_CIV_EP1" !"MH6J_DZ" !"MMT_Civ" !"MTVR_DES_EP1" !"MV22_DZ" !"Mi17_Civilian_DZ" !"Mi17_DZ" !"MtvrRefuel_DES_EP1_DZ" !"Offroad_DSHKM_Gue" !"Old_bike_TK_INS_EP1" !"Old_moto_TK_Civ_EP1" !"PBX" !"Pickup_PK_GUE" !"Pickup_PK_INS" !"Pickup_PK_TK_GUE_EP1" !"RHIB" !"S1203_TK_CIV_EP1" !"S1203_ambulance_EP1" !"SUV_Blue" !"SUV_Camo" !"SUV_Charcoal" !"SUV_Green" !"SUV_Orange" !"SUV_Pink" !"SUV_Red" !"SUV_Silver" !"SUV_TK_CIV_EP1" !"SUV_White" !"SUV_Yellow" !"Skoda" !"SkodaBlue" !"SkodaGreen" !"SkodaRed" !"Smallboat_1" !"Smallboat_2" !"TT650_Civ" !"TT650_TK_CIV_EP1" !"UAZ_CDF" !"UAZ_INS" !"UAZ_MG_TK_EP1" !"UAZ_Unarmed_TK_CIV_EP1" !"UAZ_Unarmed_TK_EP1" !"UAZ_Unarmed_UN_EP1" !"UH1H_DZ" !"UH1Y_DZ" !"UH60M_EP1_DZ" !"UralRefuel_TK_EP1_DZ" !"Ural_CDF" !"Ural_TK_CIV_EP1" !"Ural_UN_EP1" !"V3S_Open_TK_CIV_EP1" !"V3S_Open_TK_EP1" !"V3S_Refuel_TK_GUE_EP1_DZ" !"VIL_Star_S2000" !"VIL_Star_S2000o" !"VIL_alfa_civil" !"VIL_alfa_civil1" !"VIL_alfa_civil2" !"VIL_asistvan_DZE" !"VIL_berlingo" !"VIL_bmw7_civil" !"VIL_bmw7_civil1" !"VIL_bmw7_civil2" !"VIL_bmw7_civilvip" !"VIL_citrone_civil" !"VIL_citrone_civil1" !"VIL_citrone_civil2" !"VIL_citrone_civil3" !"VIL_ducato_bus" !"VIL_ducato_cargo" !"VIL_ducato_cargo2" !"VIL_fobia_civil" !"VIL_fobia_civil1" !"VIL_fobia_civil2" !"VIL_fobia_civil3" !"VIL_fobia_civil4" !"VIL_fobia_civil5" !"VIL_hilux1_civi2" !"VIL_hilux1_civi3" !"VIL_hilux1_civil" !"VIL_hilux1_police" !"VIL_karoca_civil" !"VIL_karoca_civil_red" !"VIL_kia_ceed" !"VIL_kia_ceed2" !"VIL_kia_ceed3" !"VIL_kia_ceed4" !"VIL_kia_ceeddwa" !"VIL_kia_ceeddwa2" !"VIL_kia_ceeddwa3" !"VIL_kia_ceeddwa4" !"VIL_kia_ceeddwa6" !"VIL_lublin_freez" !"VIL_mondeo_civil" !"VIL_mondeo_civil3" !"VIL_mondeo_civil4" !"VIL_mondeo_civil5" !"VIL_octavia_civil" !"VIL_octavia_civil2" !"VIL_octavia_civil3" !"VIL_octavia_civil4" !"VIL_panda_civil" !"VIL_panda_civil1" !"VIL_passat_civil" !"VIL_passat_civil1" !"VIL_passat_civil2" !"VIL_passat_civil3" !"VIL_passat_civil4" !"VIL_passat_civil5" !"VIL_smart_civil" !"VIL_smart_civil1" !"VIL_smart_civil2" !"VIL_smart_civil4" !"VIL_smart_civil5" !"VIL_sprinter_cargo" !"VIL_transit_truck" !"VIL_vivaro_amb" !"VIL_vivaro_civ" !"VIL_volvofl" !"VIL_vwt4_banksec" !"VIL_vwt4_civ" !"VWGolf" !"VolhaLimo_TK_CIV_EP1" !"Volha_2_TK_CIV_EP1" !"Zodiac" !"car_hatchback" !"car_sedan" !"datsun1_civil_1_open" !"datsun1_civil_2_covered" !"datsun1_civil_3_open" !"hilux1_civil_2_covered" !"hilux1_civil_3_open_EP1" !"policecar" !"tractor" !"ATV_Base_EP1" !"HMMWV_Base" !"Ikarus_TK_CIV_EP1" !"Lada_base" !"LandRover_Base" !"Offroad_DSHKM_base" !"Pickup_PK_base" !"S1203_TK_CIV_EP1" !"SUV_Base_EP1" !"SkodaBase" 1 "" if you want to edit what you want to do and lift
go to your mission file then R3F_ARTY_AND_LOG\R3F_LOG\addons_config\arma2_CO_object.sqf
and in there, there are 4 list of vehicle names and if you read the comments that are like // and /* you will know what to add in there.
 
DISABLE TOWING FOR LOCKED VEHICLES : 
i hope MrTesla doesnt mind if i link it.
 
you will probably want to configure your lift and towing list of vehicles.
and please tell me if i did something wrong, and sorry about my English. its not my mother language.