I decided to add some Lumber and Plywood to my neutral traders with below SQL code:
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 508, 'trade_items'); INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 530, 'trade_items'); INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 662, 'trade_items'); INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 678, 'trade_items'); INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 680, 'trade_items'); INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 15, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 508, 'trade_items'); INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 50, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 530, 'trade_items'); INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 50, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 662, 'trade_items'); INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 50, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 678, 'trade_items'); INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 50, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 680, 'trade_items');
I now would like to modify the price on them however when I run the query again, navicat says that there is a duplicate entry
OK So I go into Traders_Data table and look for PartPlankPack or PartPlywoodPack but there is nothing there...?
How can I edit the price on this if it's not displaying in my SQL database? I can still buy it in traders tho... Isn't this strange?