ArmA player since ArmA2. Scripting since A3. Fluent in German, English and sqf.
Connect with me!
- 7erra's Editing Extensions (mod)
- Disable 3den Mission Preview Shortcut (mod)
- VASS: Virtual Arsenal Shop System (script)
- Older ones:
Links which I abuse a lot:
What is a Scripted Database?
A Scripted Database is a simple way to manage information with ingame functions from Bohemia Interactive. Instead of using file operations it is a semi persistent sqf database. This means that the database is only avialable during the mission and can be modified with ingame commands. The downside is that it will be wiped when the mission ends or the game/server crashes. To make the database persistent you can save it periodically to the profileNamespace.
A list of all functions which are used to operate the database can be found here: Database functions. The functions in which you should be interested in are:
And to a certain extent:
Creating A Database
There are theoretically three options:
Declaring An Empty Array
The most straightforward option. Simply add
TAG_database = ; to any script where you want to declare the database, eg initServer.sqf.
Importing From An .xml File
BIS_fnc_dbImportXML can convert the content of an xml file into an array which has the format of a Scripted Database. An xml file can be way easier to read than a nested array. Just keep in mind that you can't modify the xml file from within the game, meaning that once the mission restarts the default database from that file will be loaded and not the database which exsisted at the end of a mission.
Importing From A Config
A config can either be the description.ext (misssion config) or a config.bin(/.cpp) (global config). The BIS_fnc_dbImportConfig function can import the config classes from the config but not the values. This makes this function a bit useless as the same can be achieved with the other options but even better. Writing to the config is also only possible from outside the game and not with commands.
Operating A Database
Classes And Values
The Scripted Database consists of classes and values. Classes can be indentified by the class symbol "#" while the symbol for values is "&". The sole puropse of BIS_fnc_dbSymbolClass and BIS_fnc_dbSymbolValue is to return this sign. While the class is followed by an array which contains values, the value is only followed by its content which can be any data type. After the values content might follow another value or the array for that class ends. Here is an example of what the database looks like:
Let's format that a bit differently:
[ "#PLAYERS", // The uppermost class containing information about the players [ "#1234", // An imaginary user id to indentify a player wihtout doubt [ // Following here are some stats that the player has "&NAME", "Bob", "&KILLS", 20, "&RANK", "Seargent" ], "#5678", [ "&NAME", "Davis", "&KILLS", 0, "&RANK", "Private" ], ] ]
To get the content of a value you can use the BIS_fnc_dbValueReturn function. The first parameter is the database from which the value should be returned. The second one is the path where the value is located. The following code displays the rank the player currently has:
_puid = getPlayerUID player; _rank = [TAG_database, ["players", _puid, "rank"]] call BIS_fnc_dbValueReturn; hint _rank;
If you ever worked with configs then you might notice the similiarity between the path array and the path to a config. This is how you access a config value:
getText (missionConfigfile>> "Players" >> getPlayerUID player >> "rank");
So while the config is not editable the database is which leads us to...