So I've been wanting to create a private ArmA 2 DayZ Epoch server for a bunch of my mates to play on, however I dont have a dedicated machine and want to run it on my PC. So I looked at the server download files on the GitHub page and followed the ReadMe, however I absolutely cannot figure out how to get the MySQL server and DB set up. I have downloaded MySQL Server on my PC and created the admin role, root passwords and ran it as a windows service. I now have no clue how to create the database and am wondering if anyone can help me set this up or let me know if I've done anything wrong.
I can add on Steam or Discord if need be for convenience.
Some time ago I started a youtube channel doing DayZ Epoch tutorials. Surprisingly, my DayZ Epoch 18.104.22.168 server install video has amassed over 2500 views (and people say this game is dead).
Here are some updated videos for 22.214.171.124. There are other videos on my channel that are still relevant.
How to Install a DayZ Epoch 126.96.36.199 Server
Things you will need to download:
MySQL Community Server 5.7.22
Notepad++ SQF Highlighter (optional, but highly recommended)
How to Upgrade Your DayZ Epoch 188.8.131.52 Server to an Overpoch Server
Things you will need to download:
Overwatch Server Key
Overwatch mission.sqm (to copy and paste from)
My Overpoch Loot Tables
My Non-ZSC Overpoch Trader Files
Midget Porn (Just kidding)
How to Install Epoch Admin Tools
Do not install these with infistar.
How to Install Wicked AI for DayZ Epoch and Overpoch
How to install infistar admin tools/antihack and infistar's free BRC rcon tool
Fix for the unfortunate error in infistar v1448
How to make Battleye filter exceptions for Infistar and other mods
Eraser1's scripts.txt Exception Generator
Ebay's Guide to Battleye Filters
How to Install Ebay's Testkit
Battleye Filter Tutorial using Ebay's Testkit and infistar's BRC rcon tool
Server Install: Troubleshooting "session lost" and "wait for host" type issues.
How to install BattlEye Extended Controls for automatic restarts
I am planning on doing more of these when I get time.
I found this on another forum, but seeing as I am truly dedicated to this one, I thought I'd share what i have found concerning the question I see a lot of people ask regarding default loadouts for everyone, including respawns and new players to the server. Its customizable with current 184.108.40.206 class IDs.
Unpack dayz_server.pbo and navigate to the compiles folder. Open the file named server_playerlogin.sqf. Find the follow block of code :
_config = (configFile >> "CfgSurvival" >> "Inventory" >> "Default"); _mags = getArray (_config >> "magazines"); _wpns = getArray (_config >> "weapons"); _bcpk = getText (_config >> "backpack"); _randomSpot = true; _key = format["CHILD:203:%1:%2:%3:",_charID,[_wpns,_mags],[_bcpk,,]]; _key call server_hiveWrite; and comment this out by adding /* */ to the top and bottom of this code block. Like this
/* _config = (configFile >> "CfgSurvival" >> "Inventory" >> "Default"); _mags = getArray (_config >> "magazines"); _wpns = getArray (_config >> "weapons"); _bcpk = getText (_config >> "backpack"); _randomSpot = true; _key = format["CHILD:203:%1:%2:%3:",_charID,[_wpns,_mags],[_bcpk,,]]; _key call server_hiveWrite; */ Then directly underneath this paste the following and configure to your liking. I have tried this and it works. To understand the logic, it is pointless to add a custom sqf in the mission folder, whether it be inside the init.sqf or a "exeVM" or a "call" method pointing to another custom sqf file seeing as the init is processed before server_playerlogin.sqf.
_randomSpot = true; _inventory = [["ItemFlashlight","ItemMap","ItemGPS","NVGoggles","AK_74"],["ItemBandage","ItemPainkiller","30Rnd_545x39_AK"]]; _backpack = ["DZ_ALICE_Pack_EP1",,]; _key = format["CHILD:203:%1:%2:%3:",_charID,_inventory,_backpack]; _key call server_hiveWrite; Here is a list of most of the class ID's currently being used. Not all of them are there, but for this purpose you will find it more than adequate.
Finally we can now lay this beast to rest. Hope this will help many solve their default loadouts. I can recommend <ESSV3> by @ebayShopperif you need more than a single loadout for all spawns.
Im looking for an easy, effective way to randomize loot (weapons, ammo, toolbelt items, food, meds and building supplies) in static crate. I have a placed crate already and populated with stuff but i would like to have this random on spawn. Also i would like to know how to have this crate stay for 2 hours then destroy and respawn 15 min later. This is what my customLootCrate.sqf looks like :