Jump to content

[Release] DayZ OverPoch Trader Items SQL


Recommended Posts

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'),
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...