Alucard88 Posted September 30, 2013 Report Share Posted September 30, 2013 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 More sharing options...
hambeast Posted September 30, 2013 Report Share Posted September 30, 2013 I like this. I would suggest adding the guns / ammo to the bandit vendor as well 627 and 577. Link to comment Share on other sites More sharing options...
Alucard88 Posted September 30, 2013 Author Report Share Posted September 30, 2013 Copy in new text, open with notepad++ and use option " Replace all " ;) Link to comment Share on other sites More sharing options...
theballin7 Posted September 30, 2013 Report Share Posted September 30, 2013 when i did this it works but some of the vehicles dont have the image next to its name is that a glitch or what. i can buy / sell the vehicle find its just not showing the image or popping up in green text in the trader menu Link to comment Share on other sites More sharing options...
Shizweak Posted October 1, 2013 Report Share Posted October 1, 2013 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 More sharing options...
Bags2247 Posted October 1, 2013 Report Share Posted October 1, 2013 Hey Alucard, would there need to be any BE update/kick/ban issues fixed Link to comment Share on other sites More sharing options...
Alucard88 Posted October 1, 2013 Author Report Share Posted October 1, 2013 For moment i have empty files of BE Link to comment Share on other sites More sharing options...
theballin7 Posted October 1, 2013 Report Share Posted October 1, 2013 this is my problem it dont show the images of the gun also happening to the vehicles too when i used those sql statements above anyway to make it show the image? i can buy and sell them fine with no problem Link to comment Share on other sites More sharing options...
Alucard88 Posted October 1, 2013 Author Report Share Posted October 1, 2013 Yes i have this, use Private Hive Tool and add items with Link to comment Share on other sites More sharing options...
Axe Cop Posted October 23, 2013 Report Share Posted October 23, 2013 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'); Torndeco 1 Link to comment Share on other sites More sharing options...
Emmer Posted October 24, 2013 Report Share Posted October 24, 2013 nice info thanks! Link to comment Share on other sites More sharing options...
AxoMuT Posted December 10, 2013 Report Share Posted December 10, 2013 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 More sharing options...
Axe Cop Posted December 10, 2013 Report Share Posted December 10, 2013 and how they fit in? What, I don't understand you, sorry.. And be aware some of the weapons from my list have already been added with Epoch 1.0.3 like the MG36, KSVK, m8_SAW and RPK_74... Link to comment Share on other sites More sharing options...
Renegade2k6 Posted December 10, 2013 Report Share Posted December 10, 2013 You could just use the command INSERT IGNORE INTO that way you wont get any errors if they are already in the database. Link to comment Share on other sites More sharing options...
EXHIBIT Posted January 26, 2014 Report Share Posted January 26, 2014 so will this all be added to the bandit and hero traders ? thanks Link to comment Share on other sites More sharing options...
EXHIBIT Posted January 26, 2014 Report Share Posted January 26, 2014 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 More sharing options...
ISHOOTMONDAYS Posted March 7, 2014 Report Share Posted March 7, 2014 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? Link to comment Share on other sites More sharing options...
Shizweak Posted March 7, 2014 Report Share Posted March 7, 2014 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 More sharing options...
ISHOOTMONDAYS Posted March 7, 2014 Report Share Posted March 7, 2014 Most likely because the `tid` is wrong! Link to comment Share on other sites More sharing options...
ISHOOTMONDAYS Posted March 7, 2014 Report Share Posted March 7, 2014 Based on whats in the server_trade.sqf inside the mission pbo, can you add categories/ids? Link to comment Share on other sites More sharing options...
Shizweak Posted March 7, 2014 Report Share Posted March 7, 2014 Based on whats in the server_trade.sqf inside the mission pbo, can you add categories/ids? I don't see why not Link to comment Share on other sites More sharing options...
m1 tanker Posted March 7, 2014 Report Share Posted March 7, 2014 My server is hosted on Verthosting and I don't have a trader_items in my DB. Any suggestions for that, because I have no icons on the items I added. Link to comment Share on other sites More sharing options...
Deepsniper Posted March 7, 2014 Report Share Posted March 7, 2014 Based on whats in the server_trade.sqf inside the mission pbo, can you add categories/ids? Link to comment Share on other sites More sharing options...
ISHOOTMONDAYS Posted March 7, 2014 Report Share Posted March 7, 2014 You can add anything you want. I've created a completely new trader city for my long term members with extra items like the APCs and hinds in there. Link to comment Share on other sites More sharing options...
fr1nk Posted March 7, 2014 Report Share Posted March 7, 2014 Try this: Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now