Overpoch Codeing Help !!!!

[Fusion123555]

Hello. Ive been coding a overpoch server for a week now. I have everything done but adding overwatch items to traders through my sql. Ive tried and tried and tried but i can not figure it out . If someone could please help me please let me know. Remember I Will pay . 

To contact me you can add me on skype - Bearofthewiild 

Or join my Teamspeak - atl-voice.fragnet.net:9997

[ElDubya]

Your best bet would be to use config based traders. There are a few threads on here with the required information. Config based traders are LOADS quicker than database traders and, in my opinion, a lot easier to use.

[Tech_Support]

For SQL use query's like these

 

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES
('["ItemRuby",1]', 250, '[5,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 702, 'trade_items'),
('["ItemTopaz",1]', 250, '[6,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 702, 'trade_items'),
('["ItemObsidian",1]', 250, '[7,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 702, 'trade_items'),
('["ItemSapphire",1]', 250, '[8,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 702, 'trade_items'),
('["ItemAmethyst",1]', 250, '[9,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 702, 'trade_items'),
('["ItemEmerald",1]', 250, '[1,"ItemSapphire",1]', '[1,"ItemSapphire",1]',0, 702, 'trade_items'),
('["ItemCitrine",1]', 250, '[1,"ItemAmethyst",1]', '[1,"ItemAmethyst",1]',0, 702, 'trade_items'),
('["ItemKiloHemp",1]', 250, '[1,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]',0, 702, 'trade_items'),
('["ItemKiloHemp",1]', 250, '[1,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]',0, 694, 'trade_items'),
('["ItemRuby",1]', 250, '[5,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 694, 'trade_items'),
('["ItemTopaz",1]', 250, '[6,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 694, 'trade_items'),
('["ItemObsidian",1]', 250, '[7,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 694, 'trade_items'),
('["ItemSapphire",1]', 250, '[8,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 694, 'trade_items'),
('["ItemAmethyst",1]', 250, '[9,"ItemBriefcase100oz",1]', '[5,"ItemBriefcase100oz",1]',0, 694, 'trade_items'),


INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES
('["ItemMixOil",1]', 1000, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 662, 'trade_items'),
('["ItemMixOil",1]', 1000, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 530, 'trade_items'),
('["ItemMixOil",1]', 1000, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 508, 'trade_items'),
('["ChainSaw",3]', 1000, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, 662, 'trade_weapons'),
('["ChainSaw",3]', 1000, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, 530, 'trade_weapons'),
('["ChainSaw",3]', 1000, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, 508, 'trade_weapons')


INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES
('["M110_TWS_EP1",3]', 100, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, 477, 'trade_weapons'),
('["M110_TWS_EP1",3]', 100, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, 627, 'trade_weapons'),
('["M110_NVG_EP1",3]', 100, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, 477, 'trade_weapons'),
('["M110_NVG_EP1",3]', 100, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]',0, 627, 'trade_weapons')