Vilayer adding items into traders

[THEGeekGaming]

Basically I am helping a friend with scripting on his server and that and I am struggling to edit and add extra weapons into the database could someone help me and give me some advice.

[Kivuli]

Well, what issues are you encountering? Are they just not showing up? Not receiving the item when they buy? Syntax errors? Whatcha got going on?

[Razorman]

Its very simple & their are numerous guides here & tools to do it....

[THEGeekGaming]

Well I used HeidiMySQL and Navicat but it said it was in the database but they were not actually appearing the traders I was adding chainsaws and ComboLocks.

[Anthraxx]

Just open HeidiSQL and run this query: 

 

For the codelocks.

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemComboLock",1]', 150, '[5,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 530, 'trade_items'); 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemComboLock",1]', 150, '[5,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 662, 'trade_items'); 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemComboLock",1]', 150, '[5,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 508, 'trade_items'); 

 

[fr1nk]

Make sure you're adding the items to the correct trader TID. You can find all these for the map you're running in server_traders.sqf

[Kivuli]

A lot of things can cause an item you enter to not show up in game. Can you post the query you used to put them in the database?