[Dayz Epoch Server]

100% use Vilayer. Hosted 2 dayz servers, minecraft server, and 2 Teamspeak servers with them.

 

They are very knowledgeable and answer tickets quickly which is rare with dayz server hosts.

 

They also helped transferring server files, was quick and painless, can't speak highly enough about them.

[Help with DayZ overpoch{Vilayer}]

Hey Im using Vilayer to run an overwatch server. Their recent changes to the control panel have made it so vehicles are no longer respawning on my server. Ive had ticket  #689510 in with them for 2 weeks now and still the problem hasn't been resolved. Hell, it took them 6 days just to reply. Is there a way that anyone knows, to respawn vehicles on my server using my database? Im running out of vehicles here.

I would recommend buying TSW , the silent warrior. This will allow you to create vehicle spawn point easily, and it's that fastest way I know how to other than manually spawning in vehicles and inserting them into the database.

 

It's only 15USD and I think it's worth it.

 

Vehicles wont spawn if there are more vehicles than there are spawn point, even if you have the vehicles set to 10000. TSW will allow you to add in those vehicles spawn points faster than any other method.

[[SQL Tool] Trader SQL Statement Generator]

You don't have to copy paste it to other sections you know, one time is enough :)

It seemed like it made more sense here.

[[SQL Tool] Trader SQL Statement Generator]

Hey guys, I created this excel spreadsheet a few weeks back to speed along the process of inserting all the Overwatch weapons into my database.

 

Allows you to create mass SQL statements easily.

 

Here is a screenshot:

 

 

Once you're done, add this to the begginning of the statement:

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES

YOU MUST REMOVE THE LAST COMMA FROM YOUR STATMENTS

or you'll get an error.

 

Very Easy!

 

You can get it here:

 

http://ge.tt/2UmgLQp1/v/0

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

RebelDexter,

 

 Thnx, for the info, its amazing what a couple of misplaced quotes in notepad++ will do. That's what I get for messing with all that data at 0330 in the morning!!

That's usually my problem sadly! Glad you got it fixed!

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

Hmmm okay, i will follow the tutorial once more and fingers crossed :)

Vilayer says they have an option to install it from the mods page now.

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

okay so is there any fix for this then?

 

Thanks

Is your server active or are you starting a new one? if you're starting a new one I would uninstall everything and start over. Make sure you have 1.0.5.1 installed.

If it's active I'm not sure what you can do, sorry.

[Epoch Trader Data SQL Generator!!!]

bump

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

I've added 3 overpoch traders to my server and most of the weapons into the traders inventory. Everything works great until I try to sell something.

 

I go in to sell my weapon and its highlighted green as it should be, but when I go to sell it for the first time I get this in-game error:

 

Script z\addons\dayz_code\actions\'trade_weapons.sqf' not found

 

Error only shows up the one time, but still can't sell anything afterwards.

 

It only seems to do it with the 3 added traders, albeit I only checked 2 of the regular Epoch traders and I sold them regular Epoch items.

 

Checked my server report and nothing, so I thought it might be client side, but I couldn't find anything in the ArmaOA2.RPT either. Not sure if there is somewhere else I should be looking. 

 

Any help would be greatly appreciated.    

In your trader_data table under the afile column do you have 'trade_weapons' instead of trade_weapons?

 

So there shouldnt be the '

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

Vilayer bud for my sins :)

strange so do I yet my database is set up differently, how strange..

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

id item qty buy sell order tid afile

 

Ive just added them with your coding and still nothing. Weird thing is i deleted the ammunation, well i thought i did and its back??

 

Weird stuff :P

Your database is sent up differently from mine, which host do you use?

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

Its saying i have a syntax error in that query. This is really annoying the crap out of me :P.

 

Must carry on!!

 

Also havent i got to put " before and after the gold?

What are the columns of your trader_data table?

 

AND YES there should be ""

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES
('["RH_massdaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_massdacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_massd",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_maseotech",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbsdeotech",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbsdaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbsdacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbsd",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbeotech",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masb",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_mas",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons')

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

1.0.5.1 and Overwatch obviously :)

Alright it seems like you are using the wrong SQL statements to insert the weapons...

 

Try using this:

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES
('["RH_massdaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_massdacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_massd",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_maseotech",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbsdeotech",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbsdaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbsdacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbsd",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbeotech",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masbaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masb",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_masacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons'),
('["RH_mas",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]',0, 577, 'trade_weapons')

Also, I created an Excel sheet that will create these statements automatically for you, here a link to the forum post for that:

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

yeah they are fine. which is the odd thing.

What version of epoch are you running? 

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

Yeah in my HeidiSql file.

Ive renamed 577 from 'Ammunation' to 'Masada Variants'.

 

577 Masada Variants 151

Are all other traders working?

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

 

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7596, '["RH_massdaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7595, '["RH_massdacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7594, '["RH_massd",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7593, '["RH_maseotech",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7592, '["RH_masbsdeotech",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7591, '["RH_masbsdaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7590, '["RH_masbsdacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7589, '["RH_masbsd",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7588, '["RH_masbeotech",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7587, '["RH_masbaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7586, '["RH_masbacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7585, '["RH_masb",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7584, '["RH_masaim",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7583, '["RH_masacog",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES (7582, '["RH_mas",3]', 250, '[4,"ItemGoldBar10oz",1]', '[2,"ItemGoldBar10oz",1]', 0, 577, 'trade_weapons');

 

Thats my data base entries. Basically im trying to add them to the Bandit Trader cause im changing that to an overpoch only trader.

Heres my server traders 

// Overpoch Vendor

menu_GUE_Soldier_MG = [

[["Masada Variants",577],["Clothing",575],["Helicopter Armed",512],["Military Armed",569],["Trucks Armed",534],["Weapons",627]],

[],

"neutral"

];

Obviously im just trying to change one category at a time, so masada variants is the old ammunation. But the weapons dont show.

 

Hope this is what you meant :)

 

Did you create the Masada Variant Trader TID?

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

Cheers for the suggestion, tried it but to no success. Any other ideas? :(

Yeah, check for typos, if you don't see anything I would start completely from scratch.

 

Delete everything you have done and try again, or put copies/screenshots of your files so we can see exactly what is in your files.

 

I'd double check your mission.sqf as well make sure everything looks good there, seems like something is wrong in the server_traders file.

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

Ah, right. Good spot :P

 

And yeah, they're added, otherwise they wouldn't spawn...?

177    Soldier_Bodyguard_AA12_PMC    24    neutral    (Empty)    Overpoch Weapons
178    Soldier_MG_PMC    24    neutral    (Empty)    Overpoch Ammo

Edit:

Changed the type to weapon(3) but no categories still...

Try adding in a category that already exists to the trader to attempt to debug what the issue is. Add like the blackmarket weapon to 

 

// Overpoch Weapons

Soldier_Bodyguard_AA12_PMC = [

    [["Overpoch Weapons",693]],

    [],

    "neutral"

];

 

to see if it's  the actual trader or the category that's causing the issue.

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

Thanks for the clarification, RebelDexter! Will give the spreadsheet you made a go later.

First I added this into trader_tids table;

 

693    Overpoch Weapons    177
694    Overpoch Ammo       178

And then I tried adding those 2 items to the new traders, simply to test them out;

 

8068    ["FHQ_ACR_SNW_CCO",1]    1000    [1,"ItemGoldBar10oz",1]    [4,"ItemGoldBar",1]    0    693    trade_weapons
8069    ["FHQ_rem_30Rnd_680x43_ACR",1]    1000    [2,"ItemSilverBar",1]    [1,"ItemSilverBar",1]    0    694    trade_items

And this is what I added to server_traders.sqf;

Obviously I added them to the end of the serverTraders array as well!

 

// Overpoch Weapons
Soldier_Bodyguard_AA12_PMC = [
	[["Overpoch Weapons",693]],
	[],
	"neutral"
];
//Overpoch Ammo
Soldier_MG_PMC = [
	[["Overpoch Ammo",694]],
	[],
	"neutral"
];

Any ideas what I might have missed?

Edit:

 

It might be worth to mention that the traders spawn and I can indeed open the menu, but there are no categories to select items/weapons from.

I only see one issue with this data,  

 

This is what your statements should look like, I put my change in big red, the 3:

8068 ["FHQ_ACR_SNW_CCO",3] 1000 [1,"ItemGoldBar10oz",1] [4,"ItemGoldBar",1] 0 693 trade_weapons

8069 ["FHQ_rem_30Rnd_680x43_ACR",1] 1000 [2,"ItemSilverBar",1] [1,"ItemSilverBar",1] 0 694 trade_items

 

Also, did you add the trader to the table that lists their skin? I can't remember for the life of me the name, but it is where you list what skin they have and their trader name.

[Epoch Trader Data SQL Generator!!!]

If you have any question about adding items let me know!

[[Tutorial] Overpoch - Custom traders, all weapons/ammo/vehicles in menus]

I'm trying to edit the table trader_items, and if I try to add an item which is already in the list - it gives me the following error;

1062 - Duplicate entry '30Rnd_556x45_Stanag-1' for key 'itemsntypes'

Edit:

 

Also, I can't seem to get my traders to work. They're spawned and I can interact with them just fine, but they don't have any categories. I've double-checked the database to make sure they're linking to the correct TID.

I also added the correct TID in the server_traders.sqf. Any ideas?

What version of epoch are you running? the trader_items table isn't used in 1.0.5.1

 

All you need to do is add the category to Trader_tids and make sure the item is added in the trader_data table.

 

You can actually use this excel sheet I made to easily add items to the trader:

 

you should post your missions.sqf , and server_trader file.

[Overpoch Server, No safe zones, Extra Trader Cities, Add vehicles, more!]

Moved to Community Servers.

 

 

Hey guys,

 

I've been helping get this server running and I think it's a server unlike any other.

 

As a player I tried to create a server I would like to play on, all of our admins are mature adults 22+

 

A few of the features:

 

Hard AI missions, high loot missions have mounted RPGs protecting the crates, all difficult AI have custom Stalker skin.

 

2 extra trader cities in Zelengorsk and Tulga

 

No Safezones

 

Gem and Rocket launcher trader up north in custom cave.

 

MANY custom areas including an AI stronghold up north that yields 3 crates of loot.

 

If you have an questions send me a message and I will gladly help you join!

 

We have a strong base but duh to the changes with steam we have lost some momentum and need help getting back to a respectable player count, we want to have some fun!

 

IP: 142.4.215.173

 

[Some custom Skins I've made.]

How exactly do you go about doing this?

 

Thanks!

[Epoch Trader Data SQL Generator!!!]

Use it everyday! at least the days I add stuff to the trader

[The new Heli ch53 doesnt spawn]

delete the ch_53_dz in your database

remove it from your dynamic vehicles

 

That's what I needed to do, also remove it from your dynamic vehicles