Jump to content

Overpoch Database Trader Entries


kat

Recommended Posts

Here's some extra stuff that my players have found missing.  Added in regular AK and DMR ammo into mine as well.

 

Make sure to adjust your IDs and TIDs so you don't overwrite anything you have in your traders.

 

INSERT INTO `Traders_DATA` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES
(8879, '["RH_m1s",3]', 5000, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8880, '["RH_m1sacog",3]', 5000, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8881, '["RH_m1saim",3]', 5000, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8882, '["RH_m1seot",3]', 5000, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8883, '["RH_m1sshd",3]', 5000, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8884, '["RH_m1ssp",3]', 5000, '[2,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8885, '["RH_sc2",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8886, '["RH_sc2acog",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8887, '["RH_sc2aim",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8888, '["RH_sc2eot",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8889, '["FHQ_MSR_DESERT",3]', 5000, '[6,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar10oz",1]', 0, 715, 'trade_weapons'),
(8890, '["RH_hk417sp",3]', 5000, '[4,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 0, 701, 'trade_weapons'),
(8891, '["vil_60Rnd_545x39_AK",1]', 5000, '[4,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 0, 705, 'trade_items'),
(8892, '["vil_45Rnd_545x39_AK",1]', 5000, '[3,"ItemSilverBar",1]', '[1,"ItemSilverBar",1]', 0, 705, 'trade_items'),
(8893, '["30Rnd_545x39_AK",1]', 5000, '[2,"ItemSilverBar",1]', '[1,"ItemSilverBar",1]', 0, 705, 'trade_items'),
(8894, '["20Rnd_762x51_DMR",1]', 5000, '[2,"ItemSilverBar10oz",1]', '[1,"ItemSilverBar10oz",1]', 0, 705, 'trade_items'),
(8895, '["vil_100Rnd_762x39_RPD",1]', 5000, '[2,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 0, 705, 'trade_items'),
(8896, '["vil_20Rnd_9x39_SP6_VAL",1]', 5000, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 0, 705, 'trade_items'),
(8897, '["vil_20Rnd_9x39_SP6ns_OC",1]', 5000, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 0, 705, 'trade_items');

Link to comment
Share on other sites

  • 2 weeks later...

HI I keep getting a Hive Execution CHILD error when I try to use these entry's ive narrowed it down and know its these entries because ive removed all my custom traders and custom information in my db and my server works fine but whenever trying to use these (even with chernarus default traders) i get a CHILD:399|'Random TID' error that makes anybody trying to login get a black screen and booted back to the lobby.

Does anybody know how to fix this? any help will be appreciated.  

 

Looks like a database error, I would suggest to you to delete the last thing you added or if you have kept a back up. You could start over again and be more cautious.

Link to comment
Share on other sites

I tried to pass this into the query section, but it doesn't seem to be working, I think I am doing something wrong, I am using navicat. Please help. Thanks

Go to ur database and right click dayz_epoch then queries then select the sql from where ever you have it then use that and it puts it in

unless its got duplicate entries whitch it does by defualt i have my edited ones i can pm you if you want and youll have to change the TIDS to your trader

 

-NGHD Ready To Help :D

Link to comment
Share on other sites

Hey guys, thanks for this kat! helped me a lot :)

 

To return the favour, I've uploaded the files for the guns and ammo, everything Kat posted, plus I added M4's, TAR's and the M14's, also I tried to organise the ammo part into sections the best I could for anyone wanting to have ammo organised on their traders E.g. Sniper ammo in one tab, LMG ammo in another.

 

Just remember to change the TID's to your own :)

 

Hope you guys can get some use out of it!

 

https://www.dropbox.com/s/zkaq29kb4h0jk90/overpoch%20guns%20and%20ammo.rar

 

Credits: Kat

and Reactortrip for his post with some missing guns/ammo

Link to comment
Share on other sites

  • 2 weeks later...

Hey guys, thanks for this kat! helped me a lot :)

 

To return the favour, I've uploaded the files for the guns and ammo, everything Kat posted, plus I added M4's, TAR's and the M14's, also I tried to organise the ammo part into sections the best I could for anyone wanting to have ammo organised on their traders E.g. Sniper ammo in one tab, LMG ammo in another.

 

Just remember to change the TID's to your own :)

 

Hope you guys can get some use out of it!

 

https://www.dropbox.com/s/zkaq29kb4h0jk90/overpoch%20guns%20and%20ammo.rar

 

Credits: Kat

and Reactortrip for his post with some missing guns/ammo

That link is busted.

Link to comment
Share on other sites

  • 4 months later...

 

ACR tan camo:

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_CCO",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_CCO_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_CCO_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_CCO_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_CCO_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_CCO_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_CCO_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_CCO_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_G33",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_G33_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_G33_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_G33_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_G33_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_G33_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_G33_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_G33_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HAMR",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HAMR_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HAMR_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HAMR_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HAMR_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HAMR_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HAMR_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HAMR_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HWS",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HWS_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HWS_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HWS_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HWS_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HWS_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HWS_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_HWS_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_IRN",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_IRN_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_IRN_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_IRN_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_IRN_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_IRN_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_IRN_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_IRN_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_RCO",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_RCO_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_RCO_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_RCO_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_RCO_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_RCO_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_RCO_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_TAN_RCO_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 695, 'trade_weapons');

 
ACR woodland camo:

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_CCO",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_CCO_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_CCO_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_CCO_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_CCO_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_CCO_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_CCO_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_CCO_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_G33",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_G33_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_G33_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_G33_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_G33_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_G33_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_G33_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_G33_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HAMR",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HAMR_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HAMR_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HAMR_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HAMR_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HAMR_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HAMR_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HAMR_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HWS",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HWS_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HWS_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HWS_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HWS_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HWS_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HWS_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_HWS_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_IRN",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_IRN_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_IRN_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_IRN_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_IRN_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_IRN_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_IRN_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_IRN_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_RCO",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_RCO_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_RCO_GL",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_RCO_GL_F",3]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_RCO_GL_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_RCO_GL_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_RCO_SD",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_ACR_WDL_RCO_SD_F",3]', 5000, '[5,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 696, 'trade_weapons');

 
Ammunition:

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["vil_bhp_mag",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["gms_k98_mag",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["vil_usp45sd_mag",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["vil_usp45_mag",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_rem_7Rnd_338Lapua_MSR_NT",1]', 5000, '[3,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["vil_10Rnd_762x54_SV",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["vil_10Rnd_SVDK",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["vil_20Rnd_762x51_G3",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["vil_32Rnd_uzi",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["vil_32Rnd_UZI_SD",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_10Rnd_22LR_mk2",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_12Rnd_45cal_usp",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_13Rnd_9x19_bhp",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_15Rnd_9x19_usp",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_15Rnd_9x19_uspsd",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_17Rnd_9x19_g17",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_17Rnd_9x19_g17SD",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_19Rnd_9x19_g18",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_20Rnd_32cal_vz61",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_20Rnd_762x51_hk417",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_20Rnd_762x51_SD_hk417",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_20Rnd_9x19_M93",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_30Rnd_9x19_tec",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_32Rnd_9x19_Muzi",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_6Rnd_357_Mag",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_6Rnd_44_Mag",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_7Rnd_32cal_ppk",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_7Rnd_50_AE",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_8Rnd_45cal_m1911",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_8Rnd_762_tt33",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_8Rnd_9x19_Mk",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_8Rnd_9x19_Mksd",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["RH_8Rnd_9x19_P38",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_rem_20Rnd_762x51_PMAG_NT",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_rem_20Rnd_762x51_PMAG_NT_SD",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_rem_30Rnd_680x43_ACR",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_rem_30Rnd_680x43_ACR_SD",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["100Rnd_556x45",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["100Rnd_556x45_BetaCMag",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["15Rnd_9x19_M9",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["15Rnd_9x19_M9SD",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["17Rnd_9x19_glock17",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["2000Rnd_762x51_M134",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["200Rnd_556x45_M249",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["20rnd_762x51_B_SCAR",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["20Rnd_762x51_SB_SCAR",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["20Rnd_9x39_SP5_VSS",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["29Rnd_30mm_AGS30",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["48Rnd_40mm_MK19",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["5x_22_LR_17_HMR",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["75Rnd_545x39_RPK",1]', 5000, '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', 703, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["USSR_5Rnd_408",1]', 5000, '[2,"ItemGoldBar10oz",1]', '[8,"ItemGoldBar",1]', 717, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_rem_5Rnd_300Win_XM2010_NT",1]', 5000, '[8,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 717, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_rem_5Rnd_300Win_XM2010_NT_SD",1]', 5000, '[9,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', 717, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["FHQ_rem_7Rnd_338Lapua_MSR_NT_SD",1]', 5000, '[9,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', 717, 'trade_items');

 

Vehicles:

 

350z:

 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_red",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_kiwi",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_black",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_silver",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_green",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_blue",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_gold",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_white",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_pink",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_mod",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_ruben",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_v",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_city",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["350z_yellow",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');

 

Monaro:

 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Civcar",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Civcarbu",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["civcarbl",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Civcarre",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Civcarge",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Civcarwh",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Civcarsl",2]', 5000, '[3,"ItemGoldBar10oz",1]', '[1,"ItemGoldBar10oz",1]', 723, 'trade_any_vehicle');

 

Police cars:

 

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_Patrol",2]', 5000, '[1,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_Trooper_Patrol",2]', 5000, '[2,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_TrooperSL_Patrol",2]', 5000, '[2,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_NYPD_Patrol",2]', 5000, '[1,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_HighwaySL_Patrol",2]', 5000, '[2,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_UnmarkedB_Patrol",2]', 5000, '[1,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_UnmarkedG_Patrol",2]', 5000, '[1,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_LAPD_Patrol",2]', 5000, '[2,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_UnmarkedW_Patrol",2]', 5000, '[1,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_LAPDSL_Patrol",2]', 5000, '[2,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CVPI_NYPDSL_Patrol",2]', 5000, '[2,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["policecar",2]', 5000, '[1,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Copcar",2]', 5000, '[1,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Copcarhw",2]', 5000, '[2,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["Copcarswat",2]', 5000, '[2,"ItemBriefcase100oz",1]', '[8,"ItemGoldBar10oz",1]', 722, 'trade_any_vehicle');

 

When i make a query i get "insert" is not recognised or something, im really new to this and i dont understand how to do this. Please help

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Discord

×
×
  • Create New...