Seperate Konten Feuerwehr/Cops/Zivis bitte hilfe 5.0

//Prepare the query statement..
_query = format ["INSERT INTO players (pid, name, cash, bankacc, westcash, westbankacc, independentcash, independentbankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('%1', '%2', '%3', '%4', '%5', '%6', '%7', '%8', '%9', '""[]""','""[]""','""[]""','""[]""','""[]""','""[]""')",
    _uid,
    _name,
    _money,
    _bank,
    _money, //added for westcash
    _bank, //added for westbankacc
    _money, //added for independentcash
    _bank, //added for independentbankacc
    _alias
];

/*
    File: fn_insertPlayerInfo.sqf
    Author: Bryan "Tonic" Boardwine

    Description:
    Upon first join inital player data is sent to the server and added to the database.
    Setup data gets sent to life_server\Functions\MySQL\fn_insertRequest.sqf
*/
if (life_session_completed) exitWith {}; //Why did this get executed when the client already initialized? F.... arma...
cutText[localize "STR_Session_QueryFail","BLACK FADED"];
//[0, localize "STR_Session_QueryFail"] call mav_introcam_fnc_updateCinematicStatus;
0 cutFadeOut 9999999;
private ["_bank", "_bankcop", "_bankmed"];

/*
switch (playerSide) do {                            //Das hier ausklammern!
    case west: {
        _bankcop = LIFE_SETTINGS(getNumber,"bank_cop");
    };
    case civilian: {
        _bank = LIFE_SETTINGS(getNumber,"bank_civ");
    };
    case independent: {
        _bankmed = LIFE_SETTINGS(getNumber,"bank_med");
    };
};*/

_bankcop = LIFE_SETTINGS(getNumber,"bank_cop");         // <- Einfügen
_bank = LIFE_SETTINGS(getNumber,"bank_civ");            // <- Einfügen
_bankmed = LIFE_SETTINGS(getNumber,"bank_med");         // <- Einfügen

if (life_HC_isActive) then {
    [getPlayerUID player,profileName,CASH,_bank,_bankcop,_bankmed,player] remoteExecCall ["HC_fnc_insertRequest",HC_Life];  // ,_bankcop,_bankmed     Einfügen!
} else {
    [getPlayerUID player,profileName,CASH,_bank,_bankcop,_bankmed,player] remoteExecCall ["DB_fnc_insertRequest",RSERV];    // ,_bankcop,_bankmed     Einfügen!
};

#include "\life_server\script_macros.hpp"
/*
    File: fn_insertRequest.sqf
    Author: Bryan "Tonic" Boardwine

    Description:
    Adds a player to the database upon first joining of the server.
    Recieves information from core\sesison\fn_insertPlayerInfo.sqf
*/
private ["_queryResult","_query","_alias"];
params [
    "_uid",
    "_name",
    ["_money",-1,[0]],
    ["_bank",-1,[0]],
    ["_bankcop",-1,[0]],        //<- Einfügen
    ["_bankmed",-1,[0]],        //<- Einfügen
    ["_returnToSender",objNull,[objNull]]
];

//Error checks
if ((_uid isEqualTo "") || (_name isEqualTo "")) exitWith {systemChat "Bad UID or name";}; //Let the client be 'lost' in 'transaction'
if (isNull _returnToSender) exitWith {systemChat "ReturnToSender is Null!";}; //No one to send this to!

_query = format ["SELECT pid, name FROM players WHERE pid='%1'",_uid];


_tickTime = diag_tickTime;
_queryResult = [_query,2] call DB_fnc_asyncCall;

if (EXTDB_SETTING(getNumber,"DebugMode") isEqualTo 1) then {
    diag_log "------------- Insert Query Request -------------";
    diag_log format ["QUERY: %1",_query];
    diag_log format ["Time to complete: %1 (in seconds)",(diag_tickTime - _tickTime)];
    diag_log format ["Result: %1",_queryResult];
    diag_log "------------------------------------------------";
};

//Double check to make sure the client isn't in the database...
if (_queryResult isEqualType "") exitWith {[] remoteExecCall ["SOCK_fnc_dataQuery",(owner _returnToSender)];}; //There was an entry!
if !(count _queryResult isEqualTo 0) exitWith {[] remoteExecCall ["SOCK_fnc_dataQuery",(owner _returnToSender)];};

//Clense and prepare some information.
_name = [_name] call DB_fnc_mresString; //Clense the name of bad chars.
_alias = [[_name]] call DB_fnc_mresArray;
_money = [_money] call DB_fnc_numberSafe;
_bank = [_bank] call DB_fnc_numberSafe;
_bankcop = [_bankcop] call DB_fnc_numberSafe;        //<- Einfügen
_bankmed = [_bankmed] call DB_fnc_numberSafe;        //<- Einfügen

//Prepare the query statement..
_query = format ["INSERT INTO players (pid, name, cash, bankacc, westcash, westbankacc, independentcash, independentbankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('%1', '%2', '%3', '%4', '%5', '%6', '%7', '%8', '%9','""[]""','""[]""','""[]""','""[]""','""[]""','""[]""')",
    _uid,
    _name,
    _money,
    _bank,
    _money,         //added for westcash
    _bankcop,         //added for westbankacc                    //<- Einfügen
    _money,         //added for independentcash
    _bankmed,         //added for independentbankacc            //<- Einfügen
    _alias
];

[_query,1] call DB_fnc_asyncCall;
[] remoteExecCall ["SOCK_fnc_dataQuery",(owner _returnToSender)];