EXTDB - MAKE DATABASE ON SERVER

Thanks to Babast from FOXCOM TEAM for this tutorial

To make Database or HIVE on your server (keep items/position/health when you disconnect/reconnect) like in Wasteland or DayZ, follow theses steps (tutorial done with Nitrado's server https://server.nitrado.net/) :

STEP 1 : Go to https://bitbucket.org/torndeco/extdb3/downloads

Download the latest version (for exemple 1020)

STEP 2 : Extract files/folders anywhere from file

Go inside @extDB3 and open extdb3-conf file below, remplace following paragraph with you SQL server informations

For exemple for my server it will be :

[Database]
IP = ms293.nitrado.net
Port = 3306
Username = ni279XXX_3_DB
Password = teXXXX0V
Database = ni279XXX_3_DB

STEP 3 : Connect to your FTP server access with FileZilla, and drop @extdb3 folder inside Arma 3 folder of your server

STEP 4 : Drop tbbmalloc.dll file inside Arma 3 folder of your server

STEP 5 : In Settings section of your server on Nitrado, add in "Additional server mods" this : @extDB3
Click too in "Auto Init"
Click on save below

STEP 6 : Download Pack ExtDB3 below and uncompress with 7zip somewhere

STEP 7 : In the BAS_persistence folder (inside Pack ExtDB3), go to sql_custom folder
Take basstard.ini file
Open fillezila and go your server on FileZilla

Drop basstard.ini inside Arma 3\@extDB3\sql_custom on your server

STEP 8 : Go back to nitrado and on Dashboard on right below, there is PHPmyadmin link. Click on and place your username and password

STEP 9 : On PHPmyadmin, go to import on the top

Click on your database name on the left (exemple : ni279257_3_DB), and click on "Browse", and select, inside the BAS_Persistence folder, file named database_v1.0.sql
Click on "Execute" below

STEP 10 : In your mission folder, create INIT.sqf file, and past (past it totally on the top to avoid problem)

/* Compile basstard's persistence */
call compileFinal preprocessFile "addons\BAS_persistence\client\BAS_persistence_client_initialization.sqf";

STEP 11 : In your mission folder, make dossier "addons"

STEP 12 : Inside BAS_persitence folder (of your Pack ExtDB3 folder), take and drop initServer.sqf file inside your mission folder

STEP 13 : Inside BAS_persitence folder (of your Pack ExtDB3 folder), take and drop onPlayerRespawn file inside your mission folder

STEP 14 : On your mission folder, open your description.ext, and past theses lines :

briefing = 0;
respawnOnStart = 0;

STEP 15 : Place the BAS_persistence folder (of your Pack ExtDB3 folder) in your "addons" folder, it must be like that

your_mission\addons\BAS_persistence

After this,

In your_mission\addons\BAS_persistence, delete following files :
-init
-initServer
-Onplayerrespawn
-Database_v1.0
-sqk_custom

just client and server folders stay in this folder

STEP 16 : In your mission folder, go to InitServer.sqf

Delete this :

/******************************************************************************************
* This work is licensed under the APL-SA. Copyright © 2016 basstard @ BI Forums          *
******************************************************************************************
   Author :        basstard
   Date :            22/09/2016 (jj/mm/aaaa)
   Version :        0.1

   Description :   Server side initialization script

   Usage :           Put this file in the mission root folder

   Syntax :       N/A

   Parameters :   N/A
*/

/* Compile basstard's persistence */
call compile preprocessFileLineNumbers "BAS_persistence\server\BAS_persistence_server_initialization.sqf";

and past following code :

/******************************************************************************************
* This work is licensed under the APL-SA. Copyright © 2016 basstard @ BI Forums          *
******************************************************************************************
   Author :        basstard
   Date :            22/09/2016 (jj/mm/aaaa)
   Version :        0.1

   Description :   Server side initialization script

   Usage :           Put this file in the mission root folder

   Syntax :       N/A

   Parameters :   N/A
*/

/* Compile basstard's persistence */
call compile preprocessFile "addons\BAS_persistence\server\BAS_persistence_server_initialization.sqf";

STEP 17 : In your mission foldier, go to
your_mission\addons\BAS_persistence\client
and open "BAS_persistence_client_initialization"

Under /* Compile functions linked to safezone functionnalities */ line:

Delete ->

BAS_persistence_client_fnc_databaseAsyncCall = compile preprocessFile "addons\BAS_persistence\client\fn_asyncCall.sqf";
call compile preprocessFile "addons\BAS_persistence\client\BAS_persistence_client_functions.sqf";

And place this :

BAS_persistence_client_fnc_databaseAsyncCall = compile preprocessFile "addons\BAS_persistence\client\fn_asyncCall.sqf";
call compile preprocessFile "addons\BAS_persistence\client\BAS_persistence_client_functions.sqf";