Adding general building materials to traders, how?

[Ephox]

I had some items added to traders, but after 1.0.2.4 update it no longer is there. I want to add them back but i dont want to spend an hour or two trying to find the item names and TIDs. So can anyone give me the code to add the following items?

 

Lumber Pack

Plywood Pack

Combination Lock

Mortar

Cinder Blocks

 

Only to the three trader cities, not wholesalers.

[bFe]

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 15, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 15, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 15, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 508, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 15, '[3,"ItemSilverBar10oz",1]', '[15,"ItemSilverBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 15, '[3,"ItemSilverBar10oz",1]', '[15,"ItemSilverBar",1]', 662, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 15, '[3,"ItemSilverBar10oz",1]', '[15,"ItemSilverBar",1]', 508, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemComboLock",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 530, 'trade_items'); 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemComboLock",1]', 15, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 662, 'trade_items'); 

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

 

Adjust prices and quantity.

[Jaroo]

whye  when im add this code

 

6742    ["CinderBlocks",1]    15    [3,"ItemGoldBar",1]    [1,"ItemGoldBar",1]    0    530    trade_items

 

 

I have message              1062-Duplicate entry '6742' for key 'PRIMARY'

 

maybe bad code line

somebody help me pls

[LoCK0N]

means you already have cinderblocks getting sold at that trader

[alexm561]

what about supply crates? of this stuff to whole sellers?