A simple MySQL connector for ArmA 3 build with Pythia. Used and maintained by Rosenrudel.

• Get the latest version of Pythia
• Install pythia on your arma server as a normal mod
• Get the latest version of Pythia-MySQL
• Install Pythia-MySQL on your arma server as a normal mod
• Open both mods in the explorer and drag the 'requirements.txt' from Pythia-MySQL onto the 'install_requirements' from Pythia

In a production env. it is recommended to use Pythia-Mysql as a server mod only.

Example function, which loads the last player position from the database and then teleports the player to this position.

params['_player'];

// Connect to the db
private _db = [
                '127.0.0.1', 
                'MyUser', 
                'MyPasswd', 
                'MyDatabase', 
                3306
                ] call H2_PythiaMySQL_fnc_connect;

// Get the players uid, 
// which in this case is the primary ident. for the table players
private _uid = getPlayerUID _player;

// Get the position from the table 'players'
private _pos = [
                    [
                        _db, 
                        "SELECT xPos, yPos, zPos FROM players WHERE uid = %s", 
                        [_uid]
                    ],
                    {
                        [_cursor] call H2_PythiaMySQL_fnc_fetchone;
                    }
                ] call H2_PythiaMySQL_fnc_with_cursor;

// Teleports the player
_player setPos _pos;
// Close db
[_db] call H2_PythiaMySQL_fnc_close;

H2_PythiaMySQL_fnc_connect

Establishes a connection to a database and returns a database handle. The handle is needed for all further commands.

Example:

private _handle = ['127.0.0.1', 
                   'MyUser', 
                   'MyPasswd', 
                   'MyDatabase', 
                   3306
                  ] call H2_PythiaMySQL_fnc_connect;

H2_PythiaMySQL_fnc_close

Closes a previously established connection.

Example:

[_handle] call H2_PythiaMySQL_fnc_close;

H2_PythiaMySQL_fnc_execute

Executes a MySQL query. In the query '%s' can be used as a placeholder for arguments. If no cursor handle is supplied in the arguments a new cursor handle is created and returned. The cursor is needed to later retrieve the query results.

Example:

private _cursor = [
                    "SELECT * FROM players WHERE name = %s", 
                    ["Dieter"]
                  ] call H2_PythiaMySQL_fnc_execute;

H2_PythiaMySQL_fnc_fetchone

Fetches the next row of a query result set after a query with execute was processed.

Example:

private _result = [_cursor] call H2_PythiaMySQL_fnc_fetchone;

H2_PythiaMySQL_fnc_fetchall

Fetches all rows of a query result set after a query with execute was processed.

Example:

private _results = [_cursor] call H2_PythiaMySQL_fnc_fetchall;

H2_PythiaMySQL_fnc_close_cursor

Closes a database cursor. Should be done for every unnecessary cursor, because to many open cursors could lead to a failure of the database connection.

Example:

[_cursor] call H2_PythiaMySQL_fnc_close_cursor;

H2_PythiaMySQL_fnc_with_cursor

Executes a query in the given database and store the result (if available). Then, execute some code. After the code is done, free the variable. Code executed can reference the variable _cursor (variable handle). In case of an error, callback will not be executed. So this is more or less a wrapper which handles the opening and closing of the cursor for you.

Example:

private _result = [
                    [_handle, "SELECT * FROM players where name = %s;", ['alice']],
		            {
			            [_cursor] call H2_PythiaMySQL_fnc_fetchall;
                    }
                  ] call H2_PythiaMySQL_fnc_with_cursor;