Adding Epoch Trader Tabs

[jacobpslagle]

Okay so I am currently adding tabs to some of my traders for the most part it all makes sense, but I have ran into one problem, but first here is what i have done:

 

• First I went into C:\ArmaServers\A2EpochServer\MPMissions\DayZ_Epoch_24.Napf\server_traders.sqf
• I have added two tabs to the hero vender ["Sniper Rifles"] and ["Sniper Rifle Ammunition"] Here is the code:

// Hero Vendor
menu_Tanny_PMC = [
    [["Ammunition",478],["Clothes",476],["Helicopter Armed",493],["Military Armed",562],["Trucks Armed",479],["Weapons",477],["Sniper Rifles",800],["Sniper Rifle Ammunition",801]],
    [],
    "hero"

• I have add two TID' 800 & 801
• Next I went into my database and added two TID's to trader_tids
• I assigned them to trader 143 which is the hero vender. All good so far.
• Next i added some items to those tabs.
• The tabs show up just fine, but nothing in them appears.
• Did i forget a step? Can anyone help me

[ElDubya]

Show us the database entries you made for these items. 

 

By the way, switch to config traders. MUCH less stuffing around :)

[jacobpslagle]

Database Entries:

 

TID 800

 

• In the database in table server_traders i found the Trader ID for the hero vender.

• After that i added my new TID for the first tab. Here is that SQL

INSERT INTO `dayz_epoch`.`trader_tids` (`id`, `name`, `trader`) VALUES ('800', 'Sniper Rifles', '143')

• Then I added a Sniper to that Tab here is the SQL

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'M107', '5', '[4,"ItemGoldBar",1]', '[2,"ItemGoldBar",1]', '0', '800', 'trade_weapons')

• Then i added an Sniper Rifle Ammunition Tab

INSERT INTO `dayz_epoch`.`trader_tids` (`id`, `name`, `trader`) VALUES ('801', 'Sniper Rifle Ammunition', '143')

• And last but not least I added some ammo for the M107

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, '10Rnd_127x99_m107', '20', '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', '0', '801', 'trade_items')

• Like I said my tabs show up just fine, but when I click on them nothing loads in. Those are the my SQL inserts that I did.

[DaveA]

I use this format to insert items

 

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["1Rnd_HE_M203",1]',10,'[4,"ItemGoldBar",1]','[2,"ItemGoldBar",1]',0,60,'trade_items') not sure if the id and null values possibly throwing it off?

[jacobpslagle]

I can add items just fine to other tabs I am just trying to create new tabs. The new tabs shows TID 800 is sniper rifles and TID 801 is Sniper Rifle Ammunition. When I add items tho to the tabs via trader_data nothing shows up when i click on the tabs.

[DaveA]

What shows up in your database when you search by tids 800 and 801?

[Tech_Support]

here try this query it should work :)

 

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES
(NULL, '["M107",3]', 5, '[4,"ItemGoldBar",1]', '[2,"ItemGoldBar",1]', 0, 800, 'trade_weapons'),
(NULL, '["10Rnd_127x99_m107",1]', 20, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 0, 801, 'trade_items');

[jacobpslagle]

I search in TID's for 800 and 8001 and I get for 800 Sniper Rifles and for 801 Sniper Rifle Ammunition. Juts like i entered.

 

Tech_support I entered your query and everything went in fine, but when i logged into the game nothing displayed into the tabs i added.