Junior Spellweaver
- Joined
- Sep 22, 2007
- Messages
- 138
- Reaction score
- 2
Original thread location:
All credits go to Guru Abdul and I am in no way affiliated with this project or Rocket
You must be registered to see links
All credits go to Guru Abdul and I am in no way affiliated with this project or Rocket
Sanctuary v2.3.1The most advanced private DayZ solution is back with another amazing update! For any hosters please download and install the newest files. For easy installation check out ConanHUN's installer.
Private DayZ
DayZ 1.7.2.3!
Always first to bring you best and most up-to-date DayZ servers!
Behold! For the day has come!
Features:
- DayZ independent communication with database, leaving countless posibilities for improvement and modifications of the original DayZ mod.
- Custom database, no need for any kind of dirty hacks or spoofing.
- Support for server networks sharing the same character database (Succesfuly runs 3 servers DE01 DE02 and PL01).
- Constantly updated to provide best dayz experience ever!
- Fixes to the original DayZ mod.
- Compatible with the latest game and DayZ updates.
- Best and most advanced vehicle spawn system so far.
- Diffrent timezones settable in the database for each instance, regardless the server time!
- Compatible with signature checks v2, meaning less cheaters!
- Custom AntiCheat system to protect your server from retards!
- Initial loadout settable in the DB per instance!
- Spectator mode for admins *COMING SOON*
- Website integration *COMING SOON*
Mod requirements:
- CBA
- Arma2NET
- Arma2MYSQL by firefly
Package highlights:You must be registered to see links
- dayzX_X.sql (MySQL database)
- @Sanctuary (Server files)
- MPmissions (Latest, size-optimized mission file)
- server.bat (Autolauncher for the server)
- Sanctuary (Server configs. Remember to configure necassary stuff!)
- vehicles.pl (script generating random amount of vehicles with randomized damaged parts and spawn locations, all in one perl script, game independent)
- BEC very nice server administration tool.
HOW TO:
Installation
Suggested tools: MySQL Workbench 5.2 CE, Notepad++.
You have to complete every step for your server to work correctly!
- Merge the github repository with your main ArmA 2 directory.
- Download and install newest ArmA beta patch 94876.
- Install MySQL server and .Net connector.
- Run in query browser dayz1_91.sql to create a database named dayz.
- Create a new user (suggested name dayz) (Administration panel in Workbench) with EXECUTE SELECT UPDATE INSERT DELETE to the dayz database and a user named 'dayz'@'localhost'!.
- Set your regional settings regarding numbers to english, so the decimal separator for fractions is a dot (.) and not coma (,) (Control Panel>Regional Settings or Start>Search>"regional number").
- Configure Databases.txt. You need to input dayz,127.0.0.1,user,password according to your setup!.
- Configure files in Sanctuary folder (You are looking for: config.cfg, basic.cfg, BEServer.cfg).
- *OPTIONAL* (Perl REQUIRED)Run vehicles.pl to generate vehicles for your instance (remember that the instance number in the db and in mission file must match for the vehicles to appear).
- *OPTIONAL* Setup BEC, I've included a sample config.
*OPTIONAL* Perl
In order to run the vehicles generation script it is required that you have perl with DBI module installed!
How to setup perl:
- Install perl (I use strawberry perl for windows).
- Open cmd.
- Run 'perl -MCPAN -e shell'.
- You should get a promt cpan>. Now run this 'install Bundle::CPAN'.
- Run 'reload cpan'.
- Run 'install DBI'.
- Close cpan shell (CTRL+C then y).
- Run 'perl -w X:\path\to\vehicles.pl'.
- The script will tell you what parameters it requires
- Run it with correct parameters that suit your needs! (instance parameter is a number!)
- Vehicles are now generated!
Configure your instance!The sanctuary server let's you set custom options for every instance. For now these are:
Suggested tools: MySQL Workbench 5.2 CE.
- Timezone (This setting let's set the time of your instance)
- Initial loadout (This one let's you set the starting items for every new player on this instance)
To configure your instances open up MySQL Workbench and go to SQL Develepment section. There open database `dayz` and start editing the `instances` table. Find you instance number in the column instance or create a new one if you are missing it. Now set the timezone for your instance by inputing a desired integer into the field timezone (NOTE: The timezone is relative to your mysql server).
Example: To achieve GMT-3 for a server located in Poland GMT+1, you should use -4 as timezone.Now let's move on to the initial loadout. Here you can input any valid inventory string that you want.
Samples:Default DayZ loadout:
Custom survival loadoutCode:[]
PvP Fun Loadout ;]Code:[["ItemMap","ItemCompass","ItemMatchbox","FoodCanBakedBeans","ItemKnife","FoodCanBakedBeans"],["ItemTent","ItemBandage","ItemBandage"]]
Code:[["Mk_48_DZ","NVGoggles","Binocular_Vector","M9SD","ItemGPS","ItemToolbox","ItemEtool","ItemCompass","ItemMatchbox","FoodCanBakedBeans","ItemKnife","ItemMap","ItemWatch"],[["100Rnd_762x51_M240",47],"ItemPainkiller","ItemBandage","15Rnd_9x19_M9SD","100Rnd_762x51_M240","ItemBandage","ItemBandage","15Rnd_9x19_M9SD","15Rnd_9x19_M9SD","15Rnd_9x19_M9SD","ItemMorphine","PartWoodPile"]]
Migration:You must be registered to see links
Your instances are now configured! Start the server.bat and enjoy!
Now you should have your Sanctuary server up and running with the latest updates!
Written from scratch migration of character data from hivemind into a fresh install of my db:
Code:INSERT INTO dayz.main (id, uid, name, pos, inventory, backpack, medical, survival, humanity, kills, hs, hkills, bkills, model, state) SELECT CharacterID, character_data.PlayerID, PlayerName,Worldspace, Inventory, Backpack, Medical, Datestamp, Humanity, KillsZ, HeadshotsZ, KillsH, KillsB, Model, currentState FROM hivemind.character_data JOIN hivemind.player_data ON character_data.PlayerID = player_data.PlayerID WHERE Alive=1;
Migration of object data (It is recommended that you don't migrate your object data)
Code:INSERT INTO dayz.objects (id, uid, instance, otype, damage, oid, pos, inventory, health, fuel) SELECT ObjectID, ObjectUID, Instance, Classname, Damage, CharacterID, Worldspace, Inventory, Hitpoints, Fuel FROM hivemind.object_data;
This should take care of the migration. If something is wrong, write!
Block this port if you have a problem with joining your server, or buy ArmA 2 OA.
29910
Useful links!
Report any bugs hereYou must be registered to see links!
For latest news follow:You must be registered to see links
For ConanHUN's installer go here:You must be registered to see links
NOTICE: @anti_rocket: I've never looked at your code ever... My vehicle script is in perl. There are 2 SIMILAR selects (REALLY? selects? SIMILAR? are you kidding me? Sorry that other ppl use SQL like you). My delete with the removal of older than some days was first. You for some strange reason have 5 procedures I have one DELETE. FYI I HAD SPAWNS, CLEANUP AND DAMAGING VEHICLES before you even started to do anything, in the server_monitor using mysql(You really didnt think I hardcoded stuff, if so then you are just dumb, no other way to put it)! Check the forum if you don't belive me.
FYI2: A child can write these sql selects and they are common. It's not an achievement... SO WTF!
BTW you even thanked me for helping you with your sql script.
Mental gymnastics...You must be registered to see linksgreat episode