Jump to content

Share your Add item on trader


Alucard88

Recommended Posts

For me: ( paste this in your console of your sql server )

 

//Weapons

 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["M110_NVG_EP1",1]', 15, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_H_LNG_Sniper",1]', 15, '[1,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_H_CQC_CCO",1]', 15, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_H_CQC_CCO_SD",1]', 15, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_H_STD_EGLM_Spect",1]', 15, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_L_CQC",1]', 15, '[6,"ItemGoldBar",1]', '[2,"ItemGoldBar",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_L_CQC_CCO_SD",1]', 15, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_L_CQC_EGLM_Holo",1]', 15, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_L_CQC_Holo",1]', 15, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_L_STD_EGLM_RCO",1]', 15, '[5,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_L_STD_HOLO",1]', 15, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["SCAR_L_STD_Mk4CQT",1]', 15, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Saiga12K",1]', 15, '[8,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RPK_74",1]', 15, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["AA12_PMC",1]', 15, '[5,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["BAF_L86A2_ACOG",1]', 15, '[5,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["bizon_silenced",1]', 15, '[5,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 477, 'trade_weapons');

 

 

// Ammo

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["20Rnd_762x51_B_SCAR",1]', 50, '[1,"ItemSilverBar10oz",1]', '[4,"ItemSilverBar",1]', 478, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["100Rnd_556x45_BetaCMag",1]', 50, '[6,"ItemGoldBar",1]', '[2,"ItemGoldBar",1]', 478, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["20Rnd_762x51_B_SCAR",1]', 50, '[1,"ItemSilverBar10oz",1]', '[4,"ItemSilverBar",1]', 478, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["20Rnd_762x51_SB_SCAR",1]', 50, '[2,"ItemSilverBar10oz",1]', '[1,"ItemSilverBar10oz",1]', 478, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["8Rnd_B_Saiga12_74Slug",1]', 50, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 478, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["8Rnd_B_Saiga12_Pellets",1]', 50, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 478, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["75Rnd_545x39_RPK",1]', 50, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 478, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["EGLMMuzzle",1]', 50, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 478, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FlareWhite_M203",1]', 50, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 478, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["1Rnd_Smoke_M203",1]', 50, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 478, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["20Rnd_B_AA12_74Slug",1]', 50, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 478, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["20Rnd_B_AA12_Pellets",1]', 50, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 478, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["64Rnd_9x19_SD_Bizon",1]', 50, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 478, 'trade_items');

 

//Vehicule

 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["VIL_asistvan_DZE",1]', 5, '[6,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 479, 'trade_any_vehicle'),('["VIL_asistvan_DZE",1]', 10, '[8,"ItemGoldBar10oz",1]', '[4,"ItemGoldBar10oz",1]', 534, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["VIL_asistvan",1]', 5, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 479, 'trade_any_vehicle'),('["VIL_asistvan_DZE",1]', 10, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 534, 'trade_any_vehicle');

 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["BTR40_TK_INS_EP1",1]', 10, '[4,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 491, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["BTR40_TK_INS_EP1",1]', 10, '[4,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 598, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["BTR40_TK_INS_EP1",1]', 10, '[4,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 599, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["BTR40_TK_INS_EP1",1]', 10, '[4,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 658, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["BTR40_TK_GUE_EP1",1]', 10, '[4,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 491, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["BTR40_TK_GUE_EP1",1]', 10, '[4,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 598, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["BTR40_TK_GUE_EP1",1]', 10, '[4,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 599, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["BTR40_TK_GUE_EP1",1]', 10, '[4,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 658, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["V3S_Repair_TK_GUE_EP1",1]', 10, '[8,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 491, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["V3S_Repair_TK_GUE_EP1",1]', 10, '[8,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 598, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["V3S_Repair_TK_GUE_EP1",1]', 10, '[8,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 599, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["V3S_Repair_TK_GUE_EP1",1]', 10, '[8,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 658, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["V3S_Salvage_TK_GUE_EP1",1]', 10, '[6,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 491, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["V3S_Salvage_TK_GUE_EP1",1]', 10, '[6,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 598, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["V3S_Salvage_TK_GUE_EP1",1]', 10, '[6,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 599, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["V3S_Salvage_TK_GUE_EP1",1]', 10, '[6,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 658, 'trade_any_vehicle');

//Items

 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 680, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 680, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 680, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 680, 'trade_items');


 

Link to comment
Share on other sites

Thanks Alucard, i'm going to cherry pick some of those weapons to add on my server - no reason not too, more variety the better.

 

I've done a couple things, increased the cost of the GPK/SOV humvees, as they are way too cheap:

UPDATE traders_data
SET buy='[2,"ItemBriefcase100oz",1]', sell='[1,"ItemBriefcase100oz",1]'
WHERE item IN ('["HMMWV_M998A2_SOV_DES_EP1",2]', '["HMMWV_M1151_M2_CZ_DES_EP1",2]')
AND tid IN(569, 562);

And also added the RPG7 (plus all the available round types), and the throw away RPG18:

INSERT INTO traders_data (item, qty, buy, sell, tid, afile) VALUES
	('["RPG7V",1]', 10, '[5,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar10oz",1]', 526, 'trade_weapons'),
	('["RPG18",1]', 10, '[5,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar10oz",1]', 526, 'trade_weapons'),
	('["PG7V",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 527, 'trade_items'),
	('["PG7VL",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 527, 'trade_items'),
	('["PG7VR",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 527, 'trade_items'),
	('["OG7",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 527, 'trade_items');
Link to comment
Share on other sites

  • 3 weeks later...

Ok I want to share my additions if anyone cares here it goes :D

You need to add all new items to the "trader_items" table first, then you will see the icon and everything, too.

-- vehicles
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('VIL_asistvan_DZE', '2', 'Vans - Tow  - Vilas', 'trade_any_vehicle');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('BAF_Merlin_HC3_D', '2', 'Helicopter Unarmed', 'trade_any_vehicle');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('Ka137_PMC', '2', 'Helicopter Unarmed', 'trade_any_vehicle');

-- weapons
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('AK_107_Kobra', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('AKS_74_UN_Kobra', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('30Rnd_545x39_AKSD', '1', 'Ammo - Rifle', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('BAF_L85A2_UGL_Holo', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('BAF_L86A2_ACOG', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_CQC', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_CQC_CCO_SD', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_CQC_Holo', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_STD_HOLO', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_STD_Mk4CQT', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_H_CQC_CCO', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_H_CQC_CCO_SD', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_H_LNG_Sniper', '3', 'Rifle Sniper', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('20Rnd_762x51_B_SCAR', '1', 'Ammo Rifle', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('m107', '3', 'Rifle Sniper', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('10Rnd_127x99_M107', '1', 'Ammo Rifle Sniper', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('ksvk', '3', 'Rifle Sniper', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('5Rnd_127x108_KSVK', '1', 'Ammo Rifle Sniper', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('MG36', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('100Rnd_556x45_BetaCMag', '1', 'Ammo - Light Machine Gun', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('m8_SAW', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('RPK_74', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('75Rnd_545x39_RPK', '1', 'Ammo - Light Machine Gun', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('BAF_L110A1_Aim', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('200Rnd_556x45_L110A1', '1', 'Ammo - Light Machine Gun', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('AA12_PMC', '3', 'Shotgun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('20Rnd_B_AA12_Pellets', '1', 'Ammo Shotgun', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('20Rnd_B_AA12_74Slug', '1', 'Ammo Shotgun', 'trade_items');

-- vehicles
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"VIL_asistvan_DZE\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '565', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"VIL_asistvan_DZE\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '591', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"VIL_asistvan_DZE\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '568', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"VIL_asistvan_DZE\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '661', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"BAF_Merlin_HC3_D\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '519', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"Ka137_PMC\",2]', '10', '[5,\"ItemGoldBar\",1]', '[3,\"ItemGoldBar\",1]', '0', '519', 'trade_any_vehicle');

-- weapons
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"BAF_L85A2_UGL_Holo\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"BAF_L86A2_ACOG\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"AK_107_Kobra\",3]', '10', '[6,\"ItemGoldBar\",1]', '[3,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"AKS_74_UN_Kobra\",3]', '10', '[6,\"ItemGoldBar\",1]', '[3,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"30Rnd_545x39_AKSD\",1]', '10', '[4,\"ItemSilverBar\",1]', '[2,\"ItemSilverBar\",1]', '0', '527', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_CQC\",3]', '10', '[6,\"ItemGoldBar\",1]', '[3,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_CQC_CCO_SD\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_CQC_Holo\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_STD_HOLO\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_STD_Mk4CQT\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_H_CQC_CCO\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_H_CQC_CCO_SD\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_762x51_B_SCAR\",1]', '10', '[1,\"ItemSilverBar10oz\",1]', '[5,\"ItemSilverBar\",1]', '0', '527', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"AA12_PMC\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_B_AA12_Pellets\",1]', '10', '[1,\"ItemSilverBar10oz\",1]', '[5,\"ItemSilverBar\",1]', '0', '527', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_B_AA12_74Slug\",1]', '10', '[1,\"ItemSilverBar10oz\",1]', '[5,\"ItemSilverBar\",1]', '0', '527', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_H_LNG_Sniper\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '477', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_H_LNG_Sniper\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '627', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_762x51_B_SCAR\",1]', '10', '[2,\"ItemSilverBar10oz\",1]', '[1,\"ItemSilverBar10oz\",1]', '0', '478', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_762x51_B_SCAR\",1]', '10', '[2,\"ItemSilverBar10oz\",1]', '[1,\"ItemSilverBar10oz\",1]', '0', '577', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"m107\",3]', '10', '[4,\"ItemGoldBar10oz\",1]', '[2,\"ItemGoldBar10oz\",1]', '0', '477', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"10Rnd_127x99_M107\",1]', '10', '[2,\"ItemGoldBar\",1]', '[1,\"ItemGoldBar\",1]', '0', '478', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"ksvk\",3]', '10', '[4,\"ItemGoldBar10oz\",1]', '[2,\"ItemGoldBar10oz\",1]', '0', '627', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"5Rnd_127x108_KSVK\",1]', '10', '[2,\"ItemGoldBar\",1]', '[1,\"ItemGoldBar\",1]', '0', '577', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"MG36\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '477', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"100Rnd_556x45_BetaCMag\",1]', '10', '[2,\"ItemSilverBar10oz\",1]', '[1,\"ItemSilverBar10oz\",1]', '0', '478', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"m8_SAW\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '477', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"RPK_74\",3]', '10', '[5,\"ItemGoldBar\",1]', '[2,\"ItemGoldBar\",1]', '0', '627', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"75Rnd_545x39_RPK\",1]', '10', '[1,\"ItemSilverBar10oz\",1]', '[5,\"ItemSilverBar\",1]', '0', '577', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"BAF_L110A1_Aim\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '627', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"200Rnd_556x45_L110A1\",1]', '10', '[2,\"ItemGoldBar\",1]', '[1,\"ItemGoldBar\",1]', '0', '577', 'trade_items');

Link to comment
Share on other sites

  • 1 month later...

 

Ok I want to share my additions if anyone cares here it goes :D

You need to add all new items to the "trader_items" table first, then you will see the icon and everything, too.

-- vehicles
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('VIL_asistvan_DZE', '2', 'Vans - Tow  - Vilas', 'trade_any_vehicle');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('BAF_Merlin_HC3_D', '2', 'Helicopter Unarmed', 'trade_any_vehicle');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('Ka137_PMC', '2', 'Helicopter Unarmed', 'trade_any_vehicle');

-- weapons
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('AK_107_Kobra', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('AKS_74_UN_Kobra', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('30Rnd_545x39_AKSD', '1', 'Ammo - Rifle', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('BAF_L85A2_UGL_Holo', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('BAF_L86A2_ACOG', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_CQC', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_CQC_CCO_SD', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_CQC_Holo', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_STD_HOLO', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_L_STD_Mk4CQT', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_H_CQC_CCO', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_H_CQC_CCO_SD', '3', 'Rifle', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('SCAR_H_LNG_Sniper', '3', 'Rifle Sniper', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('20Rnd_762x51_B_SCAR', '1', 'Ammo Rifle', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('m107', '3', 'Rifle Sniper', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('10Rnd_127x99_M107', '1', 'Ammo Rifle Sniper', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('ksvk', '3', 'Rifle Sniper', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('5Rnd_127x108_KSVK', '1', 'Ammo Rifle Sniper', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('MG36', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('100Rnd_556x45_BetaCMag', '1', 'Ammo - Light Machine Gun', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('m8_SAW', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('RPK_74', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('75Rnd_545x39_RPK', '1', 'Ammo - Light Machine Gun', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('BAF_L110A1_Aim', '3', 'Machine Gun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('200Rnd_556x45_L110A1', '1', 'Ammo - Light Machine Gun', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('AA12_PMC', '3', 'Shotgun', 'trade_weapons');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('20Rnd_B_AA12_Pellets', '1', 'Ammo Shotgun', 'trade_items');
INSERT INTO `trader_items` (`classname`, `type`, `group`, `afile`) VALUES ('20Rnd_B_AA12_74Slug', '1', 'Ammo Shotgun', 'trade_items');

-- vehicles
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"VIL_asistvan_DZE\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '565', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"VIL_asistvan_DZE\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '591', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"VIL_asistvan_DZE\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '568', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"VIL_asistvan_DZE\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '661', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"BAF_Merlin_HC3_D\",2]', '10', '[2,\"ItemBriefcase100oz\",1]', '[1,\"ItemBriefcase100oz\",1]', '0', '519', 'trade_any_vehicle');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"Ka137_PMC\",2]', '10', '[5,\"ItemGoldBar\",1]', '[3,\"ItemGoldBar\",1]', '0', '519', 'trade_any_vehicle');

-- weapons
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"BAF_L85A2_UGL_Holo\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"BAF_L86A2_ACOG\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"AK_107_Kobra\",3]', '10', '[6,\"ItemGoldBar\",1]', '[3,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"AKS_74_UN_Kobra\",3]', '10', '[6,\"ItemGoldBar\",1]', '[3,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"30Rnd_545x39_AKSD\",1]', '10', '[4,\"ItemSilverBar\",1]', '[2,\"ItemSilverBar\",1]', '0', '527', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_CQC\",3]', '10', '[6,\"ItemGoldBar\",1]', '[3,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_CQC_CCO_SD\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_CQC_Holo\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_STD_HOLO\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_L_STD_Mk4CQT\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_H_CQC_CCO\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_H_CQC_CCO_SD\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_762x51_B_SCAR\",1]', '10', '[1,\"ItemSilverBar10oz\",1]', '[5,\"ItemSilverBar\",1]', '0', '527', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"AA12_PMC\",3]', '10', '[1,\"ItemGoldBar10oz\",1]', '[5,\"ItemGoldBar\",1]', '0', '526', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_B_AA12_Pellets\",1]', '10', '[1,\"ItemSilverBar10oz\",1]', '[5,\"ItemSilverBar\",1]', '0', '527', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_B_AA12_74Slug\",1]', '10', '[1,\"ItemSilverBar10oz\",1]', '[5,\"ItemSilverBar\",1]', '0', '527', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_H_LNG_Sniper\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '477', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"SCAR_H_LNG_Sniper\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '627', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_762x51_B_SCAR\",1]', '10', '[2,\"ItemSilverBar10oz\",1]', '[1,\"ItemSilverBar10oz\",1]', '0', '478', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"20Rnd_762x51_B_SCAR\",1]', '10', '[2,\"ItemSilverBar10oz\",1]', '[1,\"ItemSilverBar10oz\",1]', '0', '577', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"m107\",3]', '10', '[4,\"ItemGoldBar10oz\",1]', '[2,\"ItemGoldBar10oz\",1]', '0', '477', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"10Rnd_127x99_M107\",1]', '10', '[2,\"ItemGoldBar\",1]', '[1,\"ItemGoldBar\",1]', '0', '478', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"ksvk\",3]', '10', '[4,\"ItemGoldBar10oz\",1]', '[2,\"ItemGoldBar10oz\",1]', '0', '627', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"5Rnd_127x108_KSVK\",1]', '10', '[2,\"ItemGoldBar\",1]', '[1,\"ItemGoldBar\",1]', '0', '577', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"MG36\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '477', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"100Rnd_556x45_BetaCMag\",1]', '10', '[2,\"ItemSilverBar10oz\",1]', '[1,\"ItemSilverBar10oz\",1]', '0', '478', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"m8_SAW\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '477', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"RPK_74\",3]', '10', '[5,\"ItemGoldBar\",1]', '[2,\"ItemGoldBar\",1]', '0', '627', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"75Rnd_545x39_RPK\",1]', '10', '[1,\"ItemSilverBar10oz\",1]', '[5,\"ItemSilverBar\",1]', '0', '577', 'trade_items');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"BAF_L110A1_Aim\",3]', '10', '[2,\"ItemGoldBar10oz\",1]', '[1,\"ItemGoldBar10oz\",1]', '0', '627', 'trade_weapons');
INSERT INTO `traders_data` (`item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES ('[\"200Rnd_556x45_L110A1\",1]', '10', '[2,\"ItemGoldBar\",1]', '[1,\"ItemGoldBar\",1]', '0', '577', 'trade_items');

 

 

and how they fit in?

Link to comment
Share on other sites

  • 1 month later...

 

Thanks Alucard, i'm going to cherry pick some of those weapons to add on my server - no reason not too, more variety the better.

 

I've done a couple things, increased the cost of the GPK/SOV humvees, as they are way too cheap:

UPDATE traders_data
SET buy='[2,"ItemBriefcase100oz",1]', sell='[1,"ItemBriefcase100oz",1]'
WHERE item IN ('["HMMWV_M998A2_SOV_DES_EP1",2]', '["HMMWV_M1151_M2_CZ_DES_EP1",2]')
AND tid IN(569, 562);

And also added the RPG7 (plus all the available round types), and the throw away RPG18:

INSERT INTO traders_data (item, qty, buy, sell, tid, afile) VALUES
	('["RPG7V",1]', 10, '[5,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar10oz",1]', 526, 'trade_weapons'),
	('["RPG18",1]', 10, '[5,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar10oz",1]', 526, 'trade_weapons'),
	('["PG7V",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 527, 'trade_items'),
	('["PG7VL",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 527, 'trade_items'),
	('["PG7VR",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 527, 'trade_items'),
	('["OG7",1]', 50, '[1,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 527, 'trade_items');

Looks good, thanks its going o help allot :D

Link to comment
Share on other sites

  • 1 month later...

Looks good, thanks its going o help allot :D

 

You're welcome

 

 

The items I am adding have no problems being bought/sold/images, they just appear in the wrong list... I've put in the information correctly (including case sensitive spelling). Any input?

 

Most likely because the `tid` is wrong!

 

Here are my latest additions for 1.0.4.2.

 

 

Adds M110 rifle to hero/bandit traders (along with its ammunition), adds M16A4 and Mk16 variants to standard traders (stary, bash, klen), and lastly adds the Mk17 and Mk16 SD variants to black market traders:

INSERT INTO dayz.traders_data (item, qty, buy, sell, `order`, tid, afile) VALUES 

-- bandit trader weapons/ammo --
('["M110_NVG_EP1",3]', 999, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 627, 'trade_weapons'),
('["20rnd_762x51_B_SCAR",1]', 999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'),

-- hero trader weapons/ammo --
('["M110_NVG_EP1",3]', 999, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 477, 'trade_weapons'),
('["20rnd_762x51_B_SCAR",1]', 999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 478, 'trade_items'),

-- standard trader weapons --
('["M16A4",3]', 999, '[8,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', 0, 485, 'trade_weapons'),
('["SCAR_L_CQC",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 485, 'trade_weapons'),
('["SCAR_L_CQC_Holo",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 485, 'trade_weapons'),
('["SCAR_L_STD_Mk4CQT",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 485, 'trade_weapons'),
('["SCAR_L_STD_HOLO",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 485, 'trade_weapons'),

('["M16A4",3]', 999, '[8,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', 0, 602, 'trade_weapons'),
('["SCAR_L_CQC",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 602, 'trade_weapons'),
('["SCAR_L_CQC_Holo",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 602, 'trade_weapons'),
('["SCAR_L_STD_Mk4CQT",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 602, 'trade_weapons'),
('["SCAR_L_STD_HOLO",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 602, 'trade_weapons'),

('["M16A4",3]', 999, '[8,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', 0, 615, 'trade_weapons'),
('["SCAR_L_CQC",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 615, 'trade_weapons'),
('["SCAR_L_CQC_Holo",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 615, 'trade_weapons'),
('["SCAR_L_STD_Mk4CQT",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 615, 'trade_weapons'),
('["SCAR_L_STD_HOLO",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 615, 'trade_weapons'),

('["M16A4",3]', 999, '[8,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', 0, 637, 'trade_weapons'),
('["SCAR_L_CQC",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 637, 'trade_weapons'),
('["SCAR_L_CQC_Holo",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 637, 'trade_weapons'),
('["SCAR_L_STD_Mk4CQT",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 637, 'trade_weapons'),
('["SCAR_L_STD_HOLO",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 637, 'trade_weapons'),

-- black market trader weapons --
('["SCAR_H_LNG_Sniper",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 526, 'trade_weapons'),
('["SCAR_H_CQC_CCO",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 526, 'trade_weapons'),
('["SCAR_H_CQC_CCO_SD",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 526, 'trade_weapons'),
('["SCAR_L_CQC_CCO_SD",3]', 999, '[1,"ItemGoldBar10oz",1]', '[5,"ItemGoldBar",1]', 0, 526, 'trade_weapons'),

-- black market trader ammo --
('["20rnd_762x51_B_SCAR",1]', 999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 527, 'trade_items');

Adding pook/bell helicopters to traders, civi ones go to air trader for 80oz buy, 40oz sell and transport (armed) go to bandit/hero camps for 100oz buy, 50oz sell:

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES

-- air trader --
('["pook_H13_medevac",2]',1002,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_medevac_CDF",2]',1004,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_medevac_TAK",2]',1001,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_medevac_INS",2]',1005,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_medevac_UNO",2]',1001,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_medevac_PMC",2]',999,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_medevac_GUE",2]',1001,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_medevac_CIV",2]',1002,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_medevac_CIV_RU",2]',1001,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ",2]',998,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ_white",2]',1001,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ_slate",2]',1002,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ_black",2]',1004,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ_yellow",2]',1002,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ_ru",2]',1003,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ_ru_white",2]',1004,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ_ru_slate",2]',1001,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ_ru_black",2]',1002,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),
('["pook_H13_civ_ru_yellow",2]',1002,'[8,"ItemGoldBar10oz",1]','[4,"ItemGoldBar10oz",1]',0,519,'trade_any_vehicle'),

-- hero trader --
('["pook_H13_transport",2]',999,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,493,'trade_any_vehicle'),
('["pook_H13_transport_CDF",2]',999,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,493,'trade_any_vehicle'),
('["pook_H13_transport_UNO",2]',999,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,493,'trade_any_vehicle'),
('["pook_H13_transport_PMC",2]',999,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,493,'trade_any_vehicle'),
('["pook_H13_transport_GUE",2]',999,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,493,'trade_any_vehicle'),
('["pook_H13_transport_TAK",2]',1000,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,493,'trade_any_vehicle'),
('["pook_H13_transport_INS",2]',999,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,493,'trade_any_vehicle'),

-- bandit trader --
('["pook_H13_transport",2]',1001,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,512,'trade_any_vehicle'),
('["pook_H13_transport_CDF",2]',999,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,512,'trade_any_vehicle'),
('["pook_H13_transport_UNO",2]',1000,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,512,'trade_any_vehicle'),
('["pook_H13_transport_PMC",2]',998,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,512,'trade_any_vehicle'),
('["pook_H13_transport_GUE",2]',999,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,512,'trade_any_vehicle'),
('["pook_H13_transport_TAK",2]',996,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,512,'trade_any_vehicle'),
('["pook_H13_transport_INS",2]',1000,'[1,"ItemBriefcase100oz",1]','[5,"ItemGoldBar10oz",1]',0,512,'trade_any_vehicle');

Amphibious pook/bell not included as it's been noted as causing FPS issues, also the transport helicopter spawns in loaded with grenades/and ammunition for the mounted M60, to remove the ammo you must add the following to the relevant areas in the server code (vehicle spawn on restart, buying from traders, dynamic vehicle spawn):

if(_object isKindOf "pook_H13_transport") then {
    _object removeMagazinesTurret ["pook_12Rnd_Grenade_Camel", [-1]];
    _object removeMagazinesTurret ["pook_250Rnd_762x51", [0]];
    _object removeMagazinesTurret ["100Rnd_762x51_M240", [0]];
    _object removeMagazinesTurret ["1200Rnd_762x51_M240", [0]];
    _object removeMagazinesTurret ["pook_12Rnd_Grenade_Camel", [0]];
};
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
  • Discord

×
×
  • Create New...