[Release] DayZ OverPoch Trader Items SQL

[jacobpslagle]

Okay so I am adding items to our traders for our OverPoch server. While I was writing SQL queries I though, what if I magically put all those queries on this website so other server owner/developers could use them to add/make adjustments to there servers.  Well here they are. Make sure you know basic SQL and you know how the trader system works before you attempt to change your traders. Also make sure your Trader ID's are correct. I used the default ones, but make sure everything is correctly typed in.

 

I will be starting off with the sniper rifles and ammo and as I progress I will update this post. Please subscribe to this post to stay informed of my changes. Enjoy :)

// Sniper Rifles: Trader ID 605 Neutral Weapons Trader 

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'vil_SVD_M', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'vil_SVD_P21', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'vil_SVD_S', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_MSR_DESERT', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_MSR_NV_DESERT', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_MSR_NV_SD_DESERT', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_MSR_SD_DESERT', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_RSASS_TAN', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_RSASS_SD_TAN', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'vil_SV_98_69', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'vil_SV_98_SD', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'vil_SVDK', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_XM2010_DESERT', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_XM2010_NV_DESERT', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_XM2010_NV_SD_DESERT', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_XM2010_SD_DESERT', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '605', 'trade_weapons'),

// Sniper Rifle Ammo: Trader ID 614 Neutral Ammo Trader

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_rem_7Rnd_338Lapua_MSR_NT', '50', '[1,"ItemGoldBar",1]', '[1,"ItemGoldBar",1]', '0', '614', 'trade_items'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_rem_7Rnd_338Lapua_MSR_NT_SD', '50', '[2,"ItemGoldBar",1]', '[2,"ItemGoldBar",1]', '0', '614', 'trade_items'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_rem_20Rnd_762x51_PMAG_NT', '50', '[2,"ItemGoldBar",1]', '[2,"ItemGoldBar",1]', '0', '614', 'trade_items'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_rem_20Rnd_762x51_PMAG_NT_SD', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '614', 'trade_items'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'vil_10Rnd_762x54_SV', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '614', 'trade_items'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'vil_10Rnd_SVDK', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '614', 'trade_items'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_rem_5Rnd_300Win_XM2010_NT', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '614', 'trade_items'),

INSERT INTO `dayz_epoch`.`traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (NULL, 'FHQ_rem_5Rnd_300Win_XM2010_NT_SD', '50', '[4,"ItemGoldBar",1]', '[4,"ItemGoldBar",1]', '0', '614', 'trade_items'),

[pr0dukt]

I am pretty sure someone released a version of all the guns somewhere in SQL. Good Luck, its alot of work 

[NGHD]

I have already released this and they're all sort to there gun types. and it has also been added to the overpoch all in one post. this post is useless