1. Dashboard
  2. Forum
    1. Unerledigte Themen
  3. Downloads
  4. Galerie
    1. Alben
  5. Toolbox
    1. Passwort Generator
    2. Portchecker
  6. Mitglieder
    1. Mitgliedersuche
    2. Benutzer online
    3. Trophäen
    4. Team
Fr: 04 Juli 2025
  • Anmelden oder registrieren
  • Suche
Dieses Thema
  • Alles
  • Dieses Thema
  • Dieses Forum
  • Artikel
  • Forum
  • Dateien
  • Seiten
  • Bilder
  • Erweiterte Suche

Schön, dass du den Weg zu NodeZone.net gefunden hast! Aktuell bist du nicht angemeldet und kannst deshalb nur eingeschränkt auf unsere Community zugreifen. Um alle Funktionen freizuschalten, spannende Inhalte zu entdecken und dich aktiv einzubringen, registriere dich jetzt kostenlos oder melde dich mit deinem Account an.

Anmelden oder registrieren
    1. Nodezone.net Community
    2. Forum
    3. Gameserver & Hosting
    4. ArmA Series - ArmA 3 / Reforger
    5. Tutorials & Releases

    PapaBear's Persistent Proficiency System 3.1.4.8

      • Altis Life
    • AmaZiinG
    • 20. September 2016 um 16:54
    • AmaZiinG
      Profi
      Reaktionen
      496
      Beiträge
      798
      Dateien
      4
      Bilder
      46
      • 20. September 2016 um 16:54
      • #1

      Mission:

      1. Geht in die Functions.h und schreibt unter class Functions das:

      Code
      class profSetUp {};
      class addExp {};


      tragt unterclass Config  das ein:

      Code
      class profType {};

      2. Schreibt folgendes in eure Masterhandler.h ein:

      Code: Masterhandler.h
      #include "prof.hpp"

      3. Stringable.xml fügt ihr ganz unten das ein:


      Code
      <Package name="Life_Prof">
      
      
      
      
      <Key ID="STR_Prof_Oil">
      <Original>Oil Proficiency</Original>
      <English>Oil Proficiency</English>
      <German>Öl Können</German>
      <French>compétence d'huile</French>
      <Italian>Proficiency olio</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Sand">
      <Original>Sand Proficiency</Original>
      <English>Sand Proficiency</English>
      <German>Sand Können</German>
      <French>compétence d'sable</French>
      <Italian>Proficiency sabbia</Italian>
      <Portuguese>areia de Proficiência </Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Rock">
      <Original>Rock Proficiency</Original>
      <English>Rock Proficiency</English>
      <German>Rock Können</German>
      <French>compétence d'rock</French>
      <Italian>Proficiency roccia</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Salt">
      <Original>Salt Proficiency</Original>
      <English>Salt Proficiency</English>
      <German>Öl Können</German>
      <French>compétence d'huile</French>
      <Italian>Proficiency olio</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Canabis">
      <Original>Cannabis Proficiency</Original>
      <English>Cannabis Proficiency</English>
      <German>Öl Können</German>
      <French>compétence d'huile</French>
      <Italian>Proficiency olio</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Heroin">
      <Original>Heroin Proficiency</Original>
      <English>Heroin Proficiency</English>
      <German>Öl Können</German>
      <French>compétence d'huile</French>
      <Italian>Proficiency olio</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Cocain">
      <Original>Cocaine Proficiency</Original>
      <English>Cocaine Proficiency</English>
      <German>Öl Können</German>
      <French>compétence d'huile</French>
      <Italian>Proficiency olio</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Diamond">
      <Original>Diamond Proficiency</Original>
      <English>Diamond Proficiency</English>
      <German>Öl Können</German>
      <French>compétence d'huile</French>
      <Italian>Proficiency olio</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Iron">
      <Original>Iron Proficiency</Original>
      <English>Iron Proficiency</English>
      <German>Öl Können</German>
      <French>compétence d'huile</French>
      <Italian>Proficiency olio</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Copper">
      <Original>Copper Proficiency</Original>
      <English>Copper Proficiency</English>
      <German>Öl Können</German>
      <French>compétence d'huile</French>
      <Italian>Proficiency olio</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      
      
      
      
      <Key ID="STR_Prof_Fruit">
      <Original>Fruit Proficiency</Original>
      <English>Fruit Proficiency</English>
      <German>Öl Können</German>
      <French>compétence d'huile</French>
      <Italian>Proficiency olio</Italian>
      <Portuguese>Proficiência Oil</Portuguese>
      </Key>
      Alles anzeigen

      4.In der Player_inv.hpp fügt ihr ganz unten das ein:

      Code
      class ProfButton : life_RscButtonMenu { 
      	text = "Proficiency";
      	colorBackground[] = {"(profilenamespace getvariable ['GUI_BCG_RGB_R',0.3843])", "(profilenamespace getvariable ['GUI_BCG_RGB_G',0.7019])", "(profilenamespace getvariable ['GUI_BCG_RGB_B',0.8862])", 0.5};
      	onButtonClick = "[] call life_fnc_profSetup;
      	";
      	x = 0.11;
      	y = 0.70;
      	w = (5.75 / 40);
      	h = (1 / 25);
       };

      5.In der Fn_VarToStr.sqf im letzten case das einfügen:

      Code
      //Prof Block
      
      
      
      
      case "Oil_Prof": {(localize "STR_Prof_Oil")};
      case "Iron_Prof": {(localize "STR_Prof_Iron")};
      case "Copper_Prof": {(localize "STR_Prof_Copper")};
      case "Rock_Prof": {(localize "STR_Prof_Rock")};
      case "Fruit_Prof": {(localize "STR_Prof_Fruit")};
      case "Salt_Prof": {(localize "STR_Prof_Salt")};
      case "Sand_Prof": {(localize "STR_Prof_Sand")};
      case "Diamond_Prof": {(localize "STR_Prof_Diamond")};
      case "Cocain_Prof": {(localize "STR_Prof_Cocain")};
      case "Canabis_Prof": {(localize "STR_Prof_Canabis")};
      case "Heroin_Prof": {(localize "STR_Prof_Heroin")};
      Alles anzeigen

      6. Ersetzt die fn_updateRequest durch das:

      Code
      /*File: fn_updateRequest.sqfAuthor: Bryan "Tonic" Boardwine Description:Ain't got time to describe it, READ THE FILE NAME!*/
      
      
      
      
      private["_uid","_side","_cash","_bank","_licenses","_gear","_name","_query","_thread"];
      _uid = [_this,0,"",[""]] call BIS_fnc_param;
      _name = [_this,1,"",[""]] call BIS_fnc_param;
      _side = [_this,2,sideUnknown,[civilian]] call BIS_fnc_param;
      _cash = [_this,3,0,[0]] call BIS_fnc_param;
      _bank = [_this,4,5000,[0]] call BIS_fnc_param;
      _licenses = [_this,5,[],[[]]] call BIS_fnc_param;
      _gear = [_this,6,[],[[]]] call BIS_fnc_param;
      _prof = [_this, 7,[],[[]]] call BIS_fnc_param;
      
      
      
      
      //Get to those error checks.
      if((_uid == "") OR (_name == "")) exitWith {};
      
      
      
      
      //Parse and setup some data.
      _name = [_name] call DB_fnc_mresString;
      _gear = [_gear] call DB_fnc_mresArray;
      _cash = [_cash] call DB_fnc_numberSafe;
      _bank = [_bank] call DB_fnc_numberSafe;
      
      
      
      
      //Does something license related but I can't remember I only know it's important?
      for "_i" from 0 to count(_licenses)-1 do {_bool = [(_licenses select _i) select 1] call DB_fnc_bool;
      _licenses set[_i,[(_licenses select _i) select 0,_bool]];
      };
      _licenses = [_licenses] call DB_fnc_mresArray;
      _prof = [_prof] call DB_fnc_mresArray;
      switch (_side) do {case west: {_query = format["UPDATE players SET name='%1', cash='%2', bankacc='%3', cop_gear='%4', cop_licenses='%5', cop_prof='%7' WHERE playerid='%6'",_name,_cash,_bank,_gear,_licenses,_uid,_prof];
      };
      case civilian: {_query = format["UPDATE players SET name='%1', cash='%2', bankacc='%3', civ_licenses='%4', civ_gear='%6', arrested='%7', civ_prof='%8' WHERE playerid='%5'",_name,_cash,_bank,_licenses,_uid,_gear,[_this select 8] call DB_fnc_bool,_prof];
      };
      case independent: {_query = format["UPDATE players SET name='%1', cash='%2', bankacc='%3', med_licenses='%4', med_gear='%6',med_prof='%7' WHERE playerid='%5'",_name,_cash,_bank,_licenses,_uid,_gear,_prof];
      };
      };
      waitUntil {sleep (random 0.3);
      !DB_Async_Active};
      _queryResult = [_query,1] call DB_fnc_asyncCall;
      Alles anzeigen

      7. Unter” if(has_license) then “ müsst er alles ersetzten (Fn_processaction.sqf)

      Code
      if(_hasLicense) then{_time = 0.3;
      _cpUp = 0.01;
      _profName = [_type] call life_fnc_profType;
      _data  = missionNamespace getVariable "_profName";
      if( _profName != "" ) then {switch ( _data select 0 ) do{case 1: { _time = 0.4;
      _cpUp = 0.01;
      };
      case 2: { _time = 0.35;
      _cpUp = 0.01;
      };
      case 3: { _time = 0.3;
      _cpUp = 0.01;
      };
      case 4: { _time = 0.25;
      _cpUp = 0.01;
      };
      case 5: { _time = 0.2;
      _cpUp = 0.01;
      };
      case 6: { _time = 0.2;
      _cpUp = 0.02;
      };
      case 7: { _time = 0.2;
      _cpUp = 0.03;
      };
      case 8: { _time = 0.2;
      _cpUp = 0.04;
      };
      case 9: { _time = 0.15;
      _cpUp = 0.05;
      };
      case 10: { _time = 0.1;
      _cpUp = 0.07;
      };
      };
      };
      while{true} do{sleep _time;
      _cP = _cP + _cpUp;
      _progress progressSetPosition _cP;
      _pgText ctrlSetText format["%3 (%1%2)...",round(_cP * 100),"%",_upp];
      if(_cP >= 1) exitWith {};
      if(player distance _vendor > 10) exitWith {};
      };
      if(player distance _vendor > 10) exitWith {hint localize "STR_Process_Stay";
      5 cutText ["","PLAIN"];
      life_is_processing = false;
      };
      if(!([false,_oldItem,_oldVal] call life_fnc_handleInv)) exitWith {5 cutText ["","PLAIN"];
      life_is_processing = false;
      };
      if(!([true,_newItem,_oldVal] call life_fnc_handleInv)) exitWith {5 cutText ["","PLAIN"];
      [true,_oldItem,_oldVal] call life_fnc_handleInv;
      life_is_processing = false;
      };
      5 cutText ["","PLAIN"];
      titleText[format[localize "STR_Process_Processed",_oldVal,_itemName],"PLAIN"];
      if( _profName != "" ) then { [_profName,40] call life_fnc_addExp;
      };
      life_is_processing = false;
      }
      
      
      
      
      else{if(life_cash < _cost) exitWith {hint format[localize "STR_Process_License",[_cost] call life_fnc_numberText];
      5 cutText ["","PLAIN"];
      life_is_processing = false;
      };
      _time = 0.9;
      _cpUp = 0.01;
      _profName = [_type] call life_fnc_profType;
      _data  = missionNamespace getVariable "_profName";
      if( _profName != "" ) then {switch ( _data select 0) do{case 1: { _time = 0.9;
      _cpUp = 0.01;
      };
      case 2: { _time = 0.8;
      _cpUp = 0.01;
      };
      case 3: { _time = 0.7;
      _cpUp = 0.01;
      };
      case 4: { _time = 0.6;
      _cpUp = 0.01;
      };
      case 5: { _time = 0.5;
      _cpUp = 0.01;
      };
      case 6: { _time = 0.4;
      _cpUp = 0.01;
      };
      case 7: { _time = 0.3;
      _cpUp = 0.01;
      };
      case 8: { _time = 0.2;
      _cpUp = 0.01;
      };
      case 9: { _time = 0.2;
      _cpUp = 0.02;
      };
      case 10: { _time = 0.2;
      _cpUp = 0.03;
      };
      };
      };
      while{true} do{sleep _time;
      _cP = _cP + _cpUp;
      _progress progressSetPosition _cP;
      _pgText ctrlSetText format["%3 (%1%2)...",round(_cP * 100),"%",_upp];
      if(_cP >= 1) exitWith {};
      if(player distance _vendor > 10) exitWith {};
      };
      if(player distance _vendor > 10) exitWith {hint localize "STR_Process_Stay";
      5 cutText ["","PLAIN"];
      life_is_processing = false;
      };
      if(life_cash < _cost) exitWith {hint format[localize "STR_Process_License",[_cost] call life_fnc_numberText];
      5 cutText ["","PLAIN"];
      life_is_processing = false;
      };
      if(!([false,_oldItem,_oldVal] call life_fnc_handleInv)) exitWith {5 cutText ["","PLAIN"];
      life_is_processing = false;
      };
      if(!([true,_newItem,_oldVal] call life_fnc_handleInv)) exitWith {5 cutText ["","PLAIN"];
      [true,_oldItem,_oldVal] call life_fnc_handleInv;
      life_is_processing = false;
      };
      5 cutText ["","PLAIN"];
      titleText[format[localize "STR_Process_Processed2",_oldVal,_itemName,[_cost] call life_fnc_numberText],"PLAIN"];
      life_cash = life_cash - _cost;
      if( _profName != "" ) then {[_profName,40] call life_fnc_addExp;
      };
      life_is_processing = false;
      };
      Alles anzeigen

      8.Unter ”life_action_inuse = true“ müsst er alles ersetzten (Fn_pickaxeUse.sqf)

      Code
      life_action_inUse = true;
      _time = 0;
      _profName = [_gather] call life_fnc_profType;
      
      
      
      
      if( _profName != "" ) then {_data = missionNamespace getVariable (_profName);
      _time = ( 3 - (0.25 * (_data select 0)));
      };
      
      
      
      
      for "_i" from 0 to 2 do{player playMove "AinvPercMstpSnonWnonDnon_Putdown_AmovPercMstpSnonWnonDnon";
      waitUntil{animationState player != "AinvPercMstpSnonWnonDnon_Putdown_AmovPercMstpSnonWnonDnon";
      };
      sleep _time;
      };
      
      
      
      
      if(([true,_mine,_diff] call life_fnc_handleInv)) then{_itemName = [([_mine,0] call life_fnc_varHandle)] call life_fnc_varToStr;
      titleText[format[localize "STR_ISTR_Pick_Success",_itemName,_diff],"PLAIN"];
      if( _profName != "" ) then {[_profName,25] call life_fnc_addExp;
      };
      };
      
      
      
      
      life_action_inUse = false;
      Alles anzeigen


      9.Unter ”life_action_inuse = true“ müsst er alles ersetzten (fn_gather.sqf)

      Code
      life_action_inUse = true;
      _time = 0;
      _profName = [_gather] call life_fnc_profType;
       if( _profName != "" ) then {_data = missionNamespace getVariable (_profName);
      _time = ( 3 - (0.25 * (_data select 0)));
      };
      
      
      
      
      for "_i" from 0 to 2 do{player playMove "AinvPercMstpSnonWnonDnon_Putdown_AmovPercMstpSnonWnonDnon";
      waitUntil{animationState player != "AinvPercMstpSnonWnonDnon_Putdown_AmovPercMstpSnonWnonDnon";
      };
      sleep _time;
      };
      
      
      
      
      if(([true,_gather,_diff] call life_fnc_handleInv)) then{_itemName = [([_gather,0] call life_fnc_varHandle)] call life_fnc_varToStr;
      titleText[format[localize "STR_NOTF_Gather_Success",_itemName,_diff],"PLAIN"];
      if( _profName != "" ) then {[_profName,25] call life_fnc_addExp;
      };
      };
      
      
      
      
      life_action_inUse = false;
      Alles anzeigen

      10. Unter ”life_gear = _this select 8 down;“ müsst er alles ersetzten (fn_requestRecieved.sqf)

      Code
      life_gear = _this select 8;
      [] call life_fnc_loadGear;
      
      
      
      
      if(count (_this select 9) > 0) then {{missionNamespace setVariable [(_x select 0),[parseNumber (_x select 1), parseNumber (_x select 2)]];
      } foreach (_this select 9);
      };
      
      
      
      
      //Parse side specific information.
      switch(playerSide) do {case west: {__CONST__(life_coplevel, parseNumber(_this select 7));
      __CONST__(life_medicLevel,0);
      life_blacklisted = _this select 10;
      };
      case civilian: {life_is_arrested = _this select 7;
      __CONST__(life_coplevel, 0);
      __CONST__(life_medicLevel, 0);
      life_houses = _this select 10;
      {_house = nearestBuilding (call compile format["%1", _x select 0]);
      life_vehicles pushBack _house;
      } foreach life_houses;
      life_gangData = _This select 11;
      
      
      
      
      if(count life_gangData != 0) then {[] spawn life_fnc_initGang;
      };
      [] spawn life_fnc_initHouses;
      };
      case independent: {__CONST__(life_medicLevel, parseNumber(_this select 7));
      __CONST__(life_coplevel,0);
      };
      };
      
      
      
      
      if(count (_this select 13) > 0) then {{life_vehicles pushBack _x;
      } foreach (_this select 12);
      };
      life_session_completed = true;
      Alles anzeigen

      11. In der configuration.sqf sucht nach://Setup License Variables{missionNamespace setVariable[(_x select 0),false];} foreach life_licenses; und scheibt folgendes darunter:

      Code
      life_prof =[["Oil_Prof","civ"],["Iron_Prof","civ"],["Copper_Prof","civ"],["Heroin_Prof","civ"],["Canabis_Prof","civ"],["Cocain_Prof","civ"],["Salt_Prof","civ"],["Fruit_Prof","civ"],["Diamond_Prof","civ"],["Rock_Prof","civ"],["Sand_Prof","civ"]];
      
      
      
      
      //Setup License Variables
      
      
      
      
      {missionNamespace setVariable[(_x select 0),[1,0]];} foreach life_prof;
      Alles anzeigen

      12. Ladet euch diesen Ordner herunter:Level System (3).zip und fügt die Dateien ein.

      Live_Server


      13. Ersetzt in der fn_Updaterequest.sqf alles durch das:

      Code
      /*File: fn_updateRequest.sqfAuthor: Bryan "Tonic" Boardwine Description:Ain't got time to describe it, READ THE FILE NAME!*/
      
      
      
      
      private["_uid","_side","_cash","_bank","_licenses","_gear","_name","_query","_thread"];
      _uid = [_this,0,"",[""]] call BIS_fnc_param;
      _name = [_this,1,"",[""]] call BIS_fnc_param;
      _side = [_this,2,sideUnknown,[civilian]] call BIS_fnc_param;
      _cash = [_this,3,0,[0]] call BIS_fnc_param;
      _bank = [_this,4,5000,[0]] call BIS_fnc_param;
      _licenses = [_this,5,[],[[]]] call BIS_fnc_param;
      _gear = [_this,6,[],[[]]] call BIS_fnc_param;
      _prof = [_this, 7,[],[[]]] call BIS_fnc_param;
      
      
      
      
      //Get to those error checks.
      if((_uid == "") OR (_name == "")) exitWith {};
      
      
      
      
      //Parse and setup some data.
      _name = [_name] call DB_fnc_mresString;
      _gear = [_gear] call DB_fnc_mresArray;
      _cash = [_cash] call DB_fnc_numberSafe;
      _bank = [_bank] call DB_fnc_numberSafe;
      
      
      
      
      //Does something license related but I can't remember I only know it's important?
      for "_i" from 0 to count(_licenses)-1 do {_bool = [(_licenses select _i) select 1] call DB_fnc_bool;
      _licenses set[_i,[(_licenses select _i) select 0,_bool]];
      };
      _licenses = [_licenses] call DB_fnc_mresArray;
      _prof = [_prof] call DB_fnc_mresArray;
      switch (_side) do {case west: {_query = format["UPDATE players SET name='%1', cash='%2', bankacc='%3', cop_gear='%4', cop_licenses='%5', cop_prof='%7' WHERE playerid='%6'",_name,_cash,_bank,_gear,_licenses,_uid,_prof];
      };
      case civilian: {_query = format["UPDATE players SET name='%1', cash='%2', bankacc='%3', civ_licenses='%4', civ_gear='%6', arrested='%7', civ_prof='%8' WHERE playerid='%5'",_name,_cash,_bank,_licenses,_uid,_gear,[_this select 8] call DB_fnc_bool,_prof];
      };
      case independent: {_query = format["UPDATE players SET name='%1', cash='%2', bankacc='%3', med_licenses='%4', med_gear='%6',med_prof='%7' WHERE playerid='%5'",_name,_cash,_bank,_licenses,_uid,_gear,_prof];
      };
      };
      waitUntil {sleep (random 0.3);
      !DB_Async_Active};
      _queryResult = [_query,1] call DB_fnc_asyncCall;
      Alles anzeigen

      Mein Discord:
      https://discord.gg/4UMWmpfDet

    • AmaZiinG
      Profi
      Reaktionen
      496
      Beiträge
      798
      Dateien
      4
      Bilder
      46
      • 20. September 2016 um 16:58
      • #2

      14. Ersetzt in der fn_QueryRequest.sqf alles durch das:
      Danke an dingo !


      Zitat von dingo
      Code: fn_queryRequest.sqf
      /*
      	File: fn_queryRequest.sqf
      	Author: Bryan "Tonic" Boardwine
      	Description:
      	Handles the incoming request and sends an asynchronous query 
      	request to the database.
      	Return:
      	ARRAY - If array has 0 elements it should be handled as an error in client-side files.
      	STRING - The request had invalid handles or an unknown error and is logged to the RPT.
      */
      private["_uid","_side","_query","_return","_queryResult","_qResult","_handler","_thread","_tickTime","_loops","_returnCount"];
      _uid = [_this,0,"",[""]] call BIS_fnc_param;
      _side = [_this,1,sideUnknown,[civilian]] call BIS_fnc_param;
      _ownerID = [_this,2,ObjNull,[ObjNull]] call BIS_fnc_param;
      
      
      
      
      if(isNull _ownerID) exitWith {};
      _ownerID = owner _ownerID;
      
      
      
      
      /*
      	_returnCount is the count of entries we are expecting back from the async call.
      	The other part is well the SQL statement.
      */
      _query = switch(_side) do {
      	case west: {_returnCount = 10; format["SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, cop_licenses, coplevel, cop_gear, cop_prof, blacklist FROM players WHERE playerid='%1'",_uid];};
      	case civilian: {_returnCount = 9; format["SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_prof FROM players WHERE playerid='%1'",_uid];};
      	case independent: {_returnCount = 9; format["SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, med_licenses, mediclevel, med_gear, med_prof FROM players WHERE playerid='%1'",_uid];};
      };
      
      
      
      
      waitUntil{sleep (random 0.3); !DB_Async_Active};
      _tickTime = diag_tickTime;
      _queryResult = [_query,2] call DB_fnc_asyncCall;
      
      
      
      
      diag_log "------------- Client 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 "------------------------------------------------";
      
      
      
      
      if(typeName _queryResult == "STRING") exitWith {
      	[[],"SOCK_fnc_insertPlayerInfo",_ownerID,false,true] spawn life_fnc_MP;
      };
      
      
      
      
      if(count _queryResult == 0) exitWith {
      	[[],"SOCK_fnc_insertPlayerInfo",_ownerID,false,true] spawn life_fnc_MP;
      };
      
      
      
      
      //Blah conversion thing from a2net->extdb
      private["_tmp"];
      _tmp = _queryResult select 2;
      _queryResult set[2,[_tmp] call DB_fnc_numberSafe];
      _tmp = _queryResult select 3;
      _queryResult set[3,[_tmp] call DB_fnc_numberSafe];
      
      
      
      
      //Parse licenses (Always index 6)
      _new = [(_queryResult select 6)] call DB_fnc_mresToArray;
      if(typeName _new == "STRING") then {_new = call compile format["%1", _new];};
      _queryResult set[6,_new];
      
      
      
      
      //Convert tinyint to boolean
      _old = _queryResult select 6;
      for "_i" from 0 to (count _old)-1 do
      {
      	_data = _old select _i;
      	_old set[_i,[_data select 0, ([_data select 1,1] call DB_fnc_bool)]];
      };
      
      
      
      
      _queryResult set[6,_old];
      
      
      
      
      _new = [(_queryResult select 8)] call DB_fnc_mresToArray;
      if(typeName _new == "STRING") then {_new = call compile format["%1", _new];};
      _queryResult set[8,_new];
      //PROFICENCYS
      //Parse licenses (Always index 9)
      _new = [(_queryResult select 9)] call DB_fnc_mresToArray;
      if(typeName _new == "STRING") then {_new = call compile format["%1", _new];};
      _queryResult set[9,_new]; 
      //Convert string to number
      _old = _queryResult select 9;
      for "_i" from 0 to (count _old)-1 do
      {
           _data = _old select _i;
      	 _old set[_i,[_data select 0, ([_data select 1,1] call DB_fnc_numberSafe),([_data select 2,1] call DB_fnc_numberSafe) ]];
      }; 
      _queryResult set[9,_old];
      
      
      
      
      //Parse data for specific side.
      switch (_side) do { 
          case west: {
      	    _queryResult set[10,([_queryResult select 10,1] call DB_fnc_bool)];
      	}; 
      	case civilian: {
      	    _queryResult set[7,([_queryResult select 7,1] call DB_fnc_bool)]; 
      		_houseData = _uid spawn TON_fnc_fetchPlayerHouses;
      	    waitUntil {scriptDone _houseData};
      		_queryResult pushBack (missionNamespace getVariable[format["houses_%1",_uid],[]]);
      	    _gangData = _uid spawn TON_fnc_queryPlayerGang;
      		waitUntil{scriptDone _gangData};_queryResult pushBack (missionNamespace getVariable[format["gang_%1",_uid],[]]);
      	};
      };
      Alles anzeigen

      DATENBANK !


      Fügt das in eure Datenbank ein:

      Code
      ALTER TABLE `arma3life`.`players` ADD COLUMN `cop_prof` TEXT NULL DEFAULT NULL AFTER `blacklist`,ADD COLUMN `civ_prof` TEXT NULL DEFAULT NULL AFTER `cop_prof`,ADD COLUMN `med_prof` TEXT NULL DEFAULT NULL AFTER `civ_prof`;

      So jetzt seid ihr Fertig, wenn es Probleme gibt schreibt es unter dem Tutorial !

      Mein Discord:
      https://discord.gg/4UMWmpfDet

      Einmal editiert, zuletzt von AmaZiinG (12. Dezember 2016 um 13:55)

    • Tyreed
      Anfänger
      Reaktionen
      5
      Trophäen
      11
      Beiträge
      25
      • 20. September 2016 um 17:42
      • #3

      Hi habe es grade mal ebend überflogen,
      hab es vor Ewigkeiten auch mal bei RPG gesehen.

      Da fiel mir auf, dass die deutsche Übersetzung in der Stringable.xml alles gleich ist, dort steht überall --> <German>Öl Können</German>
      Jeder der dies nutzt müsste das halt ebend noch selbst umschreiben.

      Lob an dich AmaZiinG
      dafür dass du dir die mühe gemacht hast es zu übersetzen.

      Gruß Ty

    • AmaZiinG
      Profi
      Reaktionen
      496
      Beiträge
      798
      Dateien
      4
      Bilder
      46
      • 20. September 2016 um 18:20
      • #4
      Zitat von Tyreed

      Hi habe es grade mal ebend überflogen,
      hab es vor Ewigkeiten auch mal bei RPG gesehen.

      Da fiel mir auf, dass die deutsche Übersetzung in der Stringable.xml alles gleich ist, dort steht überall --> <German>Öl Können</German>
      Jeder der dies nutzt müsste das halt ebend noch selbst umschreiben.

      Lob an dich AmaZiinG
      dafür dass du dir die mühe gemacht hast es zu übersetzen.

      Gruß Ty

      Das war das kleinste Problem ^^ Es war viel schwieriger die ganzen 3 sqfs richtig wieder hinzurücken, vorher war alles auf einer Zeile.

      Mein Discord:
      https://discord.gg/4UMWmpfDet

    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 20. September 2016 um 18:33
      • #5

      Tja gibt ne Menge fehler das ding!

      Code
      18:27:54 Error in expression <rue] spawn life_fnc_MP;
      };
      
      
      
      
      extdbprivate["_tmp"];
      _tmp = _queryResult select 2;
      >
      18:27:54   Error position: <["_tmp"];
      _tmp = _queryResult select 2;
      >
      18:27:54   Error Missing ;
      18:27:54 File life_server\Functions\MySQL\fn_queryRequest.sqf, line 33
      18:27:54 Error in expression <rue] spawn life_fnc_MP;
      };
      
      
      
      
      extdbprivate["_tmp"];
      _tmp = _queryResult select 2;
      >
      18:27:54   Error position: <["_tmp"];
      _tmp = _queryResult select 2;
      >
      18:27:54   Error Missing ;
      18:27:54 File life_server\Functions\MySQL\fn_queryRequest.sqf, line 33
      18:27:54 Attempt to override final function - rscminimap_script
      18:27:54 Attempt to override final function - rscdisplayloading_script
      18:27:54 Attempt to override final function - rscdisplayloading_script
      18:27:54 Attempt to override final function - rscdisplayloading_script
      18:27:54 Attempt to override final function - rscdiary_script
      18:27:54 Attempt to override final function - rscdisplaysinglemission_script
      18:27:54 Attempt to override final function - rscdiary_script
      18:27:54 Attempt to override final function - rscdisplayremotemissions_script
      18:27:54 Attempt to override final function - rscdisplayloading_script
      18:27:54 Attempt to override final function - rscdiary_script
      18:27:54 Attempt to override final function - rscdiary_script
      18:27:54 Attempt to override final function - rscdisplaystrategicmap_script
      18:27:54 Attempt to override final function - rscdisplaycommon_script
      18:27:54 Attempt to override final function - rscdisplaygarage_script
      18:27:55 Attempt to override final function - rscdisplayhostsettings_script
      18:27:55 Attempt to override final function - rscdisplayloading_script
      18:27:55 Attempt to override final function - rscdisplaycurator_script
      18:27:55 Attempt to override final function - display3deneditcomposition_script
      18:27:55 Attempt to override final function - display3deneditattributes_script
      18:27:55 Attempt to override final function - display3deneditattributes_script
      18:27:55 Attempt to override final function - rscdisplayhostsettings_script
      18:27:55 Attempt to override final function - rscdisplaycommon_script
      18:27:55 Attempt to override final function - rscdisplaydebriefing_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:55 Attempt to override final function - rscunitinfo_script
      18:27:56 'restart' voteThreshold must be in 0..1 range. Using global voteThreshold
      Initializing Steam server - Game Port: 2302, Steam Query Port: 2303
      Steam AppId from steam_appid.txt: 107410
      Item STR_Admin_Title listed twice
      Item STR_Admin_GetID listed twice
      Item STR_NOTF_ActionCancel listed twice
      Item STR_GUI_VehInfo listed twice
      Item STR_PM_Craft listed twice
      Unsupported language English in stringtable
      Item STR_Admin_Title listed twice
      Item STR_Admin_GetID listed twice
      Item STR_NOTF_ActionCancel listed twice
      Item STR_GUI_VehInfo listed twice
      Item STR_PM_Craft listed twice
      Unsupported language English in stringtable
      File mpmissions\__cur_mp.Altis\maverick\tuning\dialogs\titles.hpp, line 35: '/Life_Prof_Dialog/controlsBackground/Title/controls/CloseBTN/RscTitles/maverick_dialog_tuning_text.onLoad': Missing ';' at the end of line
      Warning Message: File mpmissions\__cur_mp.Altis\description.ext, line 374: /Life_Prof_Dialog/controlsBackground/Title/controls/CloseBTN/: Missing '}'
      Class Life_RscText destroyed with lock count 17
      Class Life_RscTitle destroyed with lock count 1
      Class life_RscPicture destroyed with lock count 5
      Class Life_RscStructuredText destroyed with lock count 5
      Class Life_RscButtonMenu destroyed with lock count 6
      Class Life_RscProgress destroyed with lock count 4
      Class Life_RscListBox destroyed with lock count 1
      Class Life_RscSlider destroyed with lock count 3
      Class Life_RscBackground destroyed with lock count 1
      Mission Team-Wings.Altis: Missing 'description.ext::Header'
      Connected to Steam servers
      Starting mission:
       Mission file: Team-Wings (__cur_mp)
       Mission world: Altis
       Mission directory: mpmissions\__cur_mp.Altis\
      Unknown hit sound type in A3\data_f\Penetration\tyre.bisurf.soundHit
      Strange convex component145 in a3\plants_f\tree\t_pinuss2s_b_f.p3d:geometryView
      Strange convex component149 in a3\plants_f\tree\t_pinuss2s_b_f.p3d:geometryView
      Attempt to override final function - bis_functions_list
      Attempt to override final function - bis_functions_listpreinit
      Attempt to override final function - bis_functions_listpostinit
      Attempt to override final function - bis_functions_listrecompile
      Attempt to override final function - bis_fnc_missiontaskslocal
      Attempt to override final function - bis_fnc_missionconversationslocal
      Attempt to override final function - bis_fnc_missionflow
      class HitPoints::HitFuel not found in Land_Camping_Light_F
      Strange convex component127 in a3\structures_f\mil\cargo\cargo_tower_v2_ruins_f.p3d:geometryView
      class HitPoints::HitFuel not found in PortableHelipadLight_01_blue_F
      Strange convex component04 in a3\structures_f\households\slum\slum_house02_ruins_f.p3d:geometryFire
      Strange convex component03 in a3\structures_f\households\slum\slum_house02_ruins_f.p3d:geometryView
      Strange convex component322 in a3\structures_f\research\dome_big_f.p3d:geometryFire
      Strange convex component327 in a3\structures_f\research\dome_big_f.p3d:geometryFire
      Strange convex component16 in a3\boat_f_gamma\boat_civil_04\boat_civil_04_f.p3d:geometryView
      Strange convex component25 in a3\boat_f_gamma\boat_civil_04\boat_civil_04_f.p3d:geometryView
      Strange convex component26 in a3\boat_f_gamma\boat_civil_04\boat_civil_04_f.p3d:geometryView
      Strange convex component27 in a3\boat_f_gamma\boat_civil_04\boat_civil_04_f.p3d:geometryView
      class HitPoints::HitFuel not found in C_Boat_Civil_04_F
      Loading movesType CfgGesturesMale
      MovesType CfgGesturesMale load time 56 ms
      Loading movesType CfgMovesMaleSdr
      MovesType CfgMovesMaleSdr load time 4683 ms
      class HitPoints::HitFuel not found in RoadCone_L_F
      No speaker given for Mike Hall
      No speaker given for Jahi Madaki
      No speaker given for Jahi Mbanefo
      No speaker given for Dwan Stewart
      soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
      No speaker given for Patterson Byrne
      No speaker given for Ryan Jones
      No speaker given for Tan Ng
      No speaker given for Tyler Newton
      soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
      No speaker given for Terrence Davis
      No speaker given for Batou Inouyie
      Wrong vertex mapping for person collision geometry found in a3\characters_f\civil\c_nikos.p3d. Selection 1c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f\civil\c_nikos.p3d. Selection 2c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f\civil\c_nikos.p3d. Selection 3c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f\civil\c_nikos.p3d. Selection 4c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f\civil\c_nikos.p3d. Selection 5c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f\civil\c_nikos.p3d. Selection 6c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f\civil\c_nikos.p3d. Selection 7c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f\civil\c_nikos.p3d. Selection 8c not found
      Wrong geometry convex component mapping  for person collision geometry found in a3\characters_f\civil\c_nikos.p3d. Convex component number 3. not found
      No speaker given for Thanos Strambopoulos
      No speaker given for Biton Kanelloupou
      Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 1c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 2c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 3c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 4c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 5c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 6c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 7c not found
      Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 8c not found
      Wrong geometry convex component mapping  for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Convex component number 3. not found
      No speaker given for Leventis Haikias
      No speaker given for Azibo Ngige
      No speaker given for Jammie Newton
      No speaker given for Liang Yeung
      No speaker given for Nuru Ibori
      No speaker given for Katungi Madaki
      No speaker given for Zahur Ibori
      No speaker given for Hasan Okadigbo
      No speaker given for Tyler Snowe
      No speaker given for Harrison Smith
      No speaker given for Jack Smith
      No speaker given for Batou Kuma
      No speaker given for Matthew Bayh
      No speaker given for Kirabo Mbanefo
      No speaker given for Corey Brown
      No speaker given for Michael Robinson
      No speaker given for Chad Faulkner
      No speaker given for Hasan Inouyie
      No speaker given for William Blackburn
      soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
      No speaker given for Theodoros Zenon
      No speaker given for Chrystophoros Papageorgiou
      No speaker given for Panos Manetta
      No speaker given for Ethan Dayton
      No speaker given for Samuel James
      No speaker given for Tyler Spiegelman
      No speaker given for Luke Bayh
      No speaker given for Harrison Jones
      No speaker given for William Hughes
      No speaker given for Bradley O'Sullivan
      No speaker given for Jack Kirby
      No speaker given for Vasilis Lagos
      No speaker given for Ian Smith
      Error in expression <this allowdamage false;>
        Error position: <allowdamage false;>
        Error allowdamage: Type Group, expected Object
      Error in expression <this allowDamage false; this enableSimulation>
        Error position: <allowDamage false; this enableSimulation>
        Error allowdamage: Type Group, expected Object
      Error: Object(2 : 3358) not found
      Error: Object(2 : 3362) not found
      Error: Object(2 : 3366) not found
      Error: Object(2 : 3370) not found
      Error: Object(2 : 3374) not found
      Error: Object(2 : 3378) not found
      Error: Object(2 : 3382) not found
      Error: Object(2 : 3386) not found
      Error: Object(2 : 3390) not found
      Error: Object(2 : 3394) not found
      Error: Object(2 : 3398) not found
      Error: Object(2 : 3402) not found
      Error: Object(2 : 3406) not found
      Error: Object(2 : 3410) not found
      Error: Object(2 : 3414) not found
      Error: Object(2 : 3418) not found
      Error: Object(2 : 3422) not found
      Error: Object(2 : 3426) not found
      Error: Object(2 : 3430) not found
      Error: Object(2 : 3434) not found
      Error: Object(2 : 3438) not found
      Error: Object(2 : 3442) not found
      Error: Object(2 : 3446) not found
      Error: Object(2 : 3450) not found
      Error: Object(2 : 3454) not found
      Error: Object(2 : 3455) not found
      Error: Object(2 : 3631) not found
      Error: Object(2 : 3673) not found
      Error: Object(2 : 3677) not found
      Error: Object(2 : 3681) not found
      Error: Object(2 : 3685) not found
      Error: Object(2 : 3689) not found
      Error: Object(2 : 3693) not found
      Error: Object(2 : 3697) not found
      Error: Object(2 : 3701) not found
      Error: Object(2 : 3705) not found
      Error: Object(2 : 3709) not found
      Error: Object(2 : 3747) not found
      Error: Object(2 : 3751) not found
      Error: Object(2 : 3755) not found
      Error: Object(2 : 3759) not found
      Error: Object(2 : 3763) not found
      Error: Object(2 : 3767) not found
      c:\w\stable\futura\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
       Mission id: d9418e0a8d81fd3aac24f5a92d788d228afc17ea
      "Marktpreise erstellt!"
      Error in expression <l("life_market_prices")) then
      {
      [] call life_fnc_marketconfiguration;
      diag_log ">
        Error position: <life_fnc_marketconfiguration;
      diag_log ">
        Error Undefined variable in expression: life_fnc_marketconfiguration
      File mpmissions\__cur_mp.Altis\init.sqf, line 37
      "life_ATMhacked: 0"
      Error in expression <bullet\bulletWindClient.sqf";
      
      
      
      
      [] spawn life_fnc_autoMessages; 
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      if(isDedic>
        Error position: <life_fnc_autoMessages; 
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      if(isDedic>
        Error Undefined variable in expression: life_fnc_automessages
      File mpmissions\__cur_mp.Altis\init.sqf, line 28
      EXTDB:: LOCK SUCCESSFULL
      Alles anzeigen
    • Tyreed
      Anfänger
      Reaktionen
      5
      Trophäen
      11
      Beiträge
      25
      • 20. September 2016 um 18:56
      • #6

      ne menge Fehler ist übertrieben ich sehe nur ein der durch das TuT entsteht und zwar in der QueryRequest.

      welche Version nutzt du denn @ Team - Wings?

    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 20. September 2016 um 19:08
      • #7

      Sorry ich weiß die 3.1.4.8 haben alle fehler gefixed so weit nur irgendwas stimmt mit dem dialog nicht da ist ein Fehler drinnen, weil wenn man auf den Server geht sind überall KL Einheiten wenn ich nur das Dialog rausnehme also prof.hpp dann geht alles wieder! :D
      LoL

    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 20. September 2016 um 19:16
      • #8
      Code
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Error in expression <id];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTi>
        Error position: <DB_Async_Active};_tickTime = diag_tickTi>
        Error Undefined variable in expression: db_async_active
      File life_server\Functions\MySQL\fn_queryRequest.sqf, line 1
      Alles anzeigen
    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 20. September 2016 um 19:22
      • #9

      Hat jemand einen Tipp wie ich des fixen kann?

      C
      19:16:36 Error in expression <rue] spawn life_fnc_MP;
      };
      
      
      
      
      extdbprivate["_tmp"];
      _tmp = _queryResult select 2;
      >
      19:16:36   Error position: <["_tmp"];
      _tmp = _queryResult select 2;
      >
      19:16:36   Error Missing ;
      19:16:36 File life_server\Functions\MySQL\fn_queryRequest.sqf, line 33
      19:16:36 Error in expression <rue] spawn life_fnc_MP;
      };
      
      
      
      
      extdbprivate["_tmp"];
      _tmp = _queryResult select 2;
      >
      19:16:36   Error position: <["_tmp"];
      _tmp = _queryResult select 2;
      >
      19:16:36   Error Missing ;
      19:16:36 File life_server\Functions\MySQL\fn_queryRequest.sqf, line 33
      Alles anzeigen
    • Tyreed
      Anfänger
      Reaktionen
      5
      Trophäen
      11
      Beiträge
      25
      • 20. September 2016 um 19:33
      • #10

      Bei dem SQL Teil hier---

      ALTER TABLE `arma3life`.`players` ADD COLUMN `cop_prof` TEXT NULL DEFAULT NULL AFTER `blacklist`,ADD COLUMN `civ_prof` TEXT NULL DEFAULT NULL AFTER `cop_prof`,ADD COLUMN `med_prof` TEXT NULL DEFAULT NULL AFTER `civ_prof`;

      hast du bei ALTER TABLE `arma3life`
      Dein Datenbank Namen eingetragen?

    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 20. September 2016 um 19:41
      • #11

      Jap

    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 20. September 2016 um 19:43
      • #12
      C
      /*File: fn_queryRequest.sqfAuthor: Bryan "Tonic" Boardwine Description:Handles the incoming request and sends an asynchronous query request to the database. Return:ARRAY - If array has 0 elements it should be handled as an error in client-side files.STRING - The request had invalid handles or an unknown error and is logged to the RPT.*/private["_uid","_side","_query","_return","_queryResult","_qResult","_handler","_thread","_tickTime","_loops","_returnCount"];_uid = [_this,0,"",[""]] call BIS_fnc_param;_side = [_this,1,sideUnknown,[civilian]] call BIS_fnc_param;_ownerID = [_this,2,ObjNull,[ObjNull]] call BIS_fnc_param; if(isNull _ownerID) exitWith {};_ownerID = owner _ownerID; /*_returnCount is the count of entries we are expecting back from the async call.The other part is well the SQL statement.*/_query = switch(_side) do {case west: {_returnCount = 11; format["SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, cop_licenses, coplevel, cop_gear, cop_prof, blacklist FROM players WHERE playerid='%1'",_uid];};case civilian: {_returnCount = 10; format["SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_prof FROM players WHERE playerid='%1'",_uid];};case independent: {_returnCount = 10; format["SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, med_licenses, mediclevel, med_gear, med_prof FROM players WHERE playerid='%1'",_uid];};}; waitUntil{sleep (random 0.3); !DB_Async_Active};_tickTime = diag_tickTime;_queryResult = [_query,2] call DB_fnc_asyncCall; diag_log "------------- Client 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 "------------------------------------------------"; if(typeName _queryResult == "STRING") exitWith {[[],"SOCK_fnc_insertPlayerInfo",_ownerID,false,true] spawn life_fnc_MP;}; if(count _queryResult == 0) exitWith {[[],"SOCK_fnc_insertPlayerInfo",_ownerID,false,true] spawn life_fnc_MP;}; //Blah conversion thing from a2net->extdbprivate["_tmp"];_tmp = _queryResult select 2;_queryResult set[2,[_tmp] call DB_fnc_numberSafe];_tmp = _queryResult select 3;_queryResult set[3,[_tmp] call DB_fnc_numberSafe]; //Parse licenses (Always index 6)_new = [(_queryResult select 6)] call DB_fnc_mresToArray;if(typeName _new == "STRING") then {_new = call compile format["%1", _new];};_queryResult set[6,_new]; //Convert tinyint to boolean_old = _queryResult select 6;for "_i" from 0 to (count _old)-1 do{_data = _old select _i;_old set[_i,[_data select 0, ([_data select 1,1] call DB_fnc_bool)]];}; _queryResult set[6,_old]; _new = [(_queryResult select 8)] call DB_fnc_mresToArray;if(typeName _new == "STRING") then {_new = call compile format["%1", _new];};_queryResult set[8,_new]; //PROFICENCYS//Parse licenses (Always index 9)_new = [(_queryResult select 9)] call DB_fnc_mresToArray;if(typeName _new == "STRING") then {_new = call compile format["%1", _new];};_queryResult set[9,_new]; //Convert string to number_old = _queryResult select 9;for "_i" from 0 to (count _old)-1 do{_data = _old select _i;_old set[_i,[_data select 0, ([_data select 1,1] call DB_fnc_numberSafe),([_data select 2,1] call DB_fnc_numberSafe) ]];}; _queryResult set[9,_old]; //Parse data for specific side.switch (_side) do {case west: {_queryResult set[10,([_queryResult select 10,1] call DB_fnc_bool)];}; case civilian: {_queryResult set[7,([_queryResult select 7,1] call DB_fnc_bool)]; _houseData = _uid spawn TON_fnc_fetchPlayerHouses;waitUntil {scriptDone _houseData};_queryResult pushBack (missionNamespace getVariable[format["houses_%1",_uid],[]]);_gangData = _uid spawn TON_fnc_queryPlayerGang;waitUntil{scriptDone _gangData};_queryResult pushBack (missionNamespace getVariable[format["gang_%1",_uid],[]]);};}; _keyArr = missionNamespace getVariable [format["%1_KEYS_%2",_uid,_side],[]];_queryResult set[13,_keyArr]; [_queryResult,"SOCK_fnc_requestReceived",_ownerID,false] spawn life_fnc_MP;
      C
      /*File: fn_updateRequest.sqfAuthor: Bryan "Tonic" Boardwine Description:Ain't got time to describe it, READ THE FILE NAME!*/private["_uid","_side","_cash","_bank","_licenses","_gear","_name","_query","_thread"];_uid = [_this,0,"",[""]] call BIS_fnc_param;_name = [_this,1,"",[""]] call BIS_fnc_param;_side = [_this,2,sideUnknown,[civilian]] call BIS_fnc_param;_cash = [_this,3,0,[0]] call BIS_fnc_param;_bank = [_this,4,5000,[0]] call BIS_fnc_param;_licenses = [_this,5,[],[[]]] call BIS_fnc_param;_gear = [_this,6,[],[[]]] call BIS_fnc_param;_prof = [_this, 7,[],[[]]] call BIS_fnc_param; //Get to those error checks.if((_uid == "") OR (_name == "")) exitWith {}; //Parse and setup some data._name = [_name] call DB_fnc_mresString;_gear = [_gear] call DB_fnc_mresArray;_cash = [_cash] call DB_fnc_numberSafe;_bank = [_bank] call DB_fnc_numberSafe; //Does something license related but I can't remember I only know it's important?for "_i" from 0 to count(_licenses)-1 do {_bool = [(_licenses select _i) select 1] call DB_fnc_bool;_licenses set[_i,[(_licenses select _i) select 0,_bool]];}; _licenses = [_licenses] call DB_fnc_mresArray; _prof = [_prof] call DB_fnc_mresArray; switch (_side) do {case west: {_query = format["UPDATE players SET name='%1', cash='%2', bankacc='%3', cop_gear='%4', cop_licenses='%5', cop_prof='%7' WHERE playerid='%6'",_name,_cash,_bank,_gear,_licenses,_uid,_prof];};case civilian: {_query = format["UPDATE players SET name='%1', cash='%2', bankacc='%3', civ_licenses='%4', civ_gear='%6', arrested='%7', civ_prof='%8' WHERE playerid='%5'",_name,_cash,_bank,_licenses,_uid,_gear,[_this select 8] call DB_fnc_bool,_prof];};case independent: {_query = format["UPDATE players SET name='%1', cash='%2', bankacc='%3', med_licenses='%4', med_gear='%6',med_prof='%7' WHERE playerid='%5'",_name,_cash,_bank,_licenses,_uid,_gear,_prof];};}; waitUntil {sleep (random 0.3); !DB_Async_Active};_queryResult = [_query,1] call DB_fnc_asyncCall;
    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 26. September 2016 um 09:30
      • #13

      Hey diese Tutorial enthält paar Fehler z.B die HPP da ist beim Code verschönern/Ordnen was verloren gegangen deswegen konnte man das nicht laden.. die HPP von der main Seite klappt super. Wollte es dir nur sagen und sag mal womit du den code konvertiert hast. ^^ Danke

      Mfg Pius von Team-Wings

    • nflug
      Nerd
      Reaktionen
      225
      Trophäen
      9
      Beiträge
      781
      • 26. September 2016 um 10:03
      • #14
      Zitat von Team-Wings

      Hey diese Tutorial enthält paar Fehler z.B die HPP da ist beim Code verschönern/Ordnen was verloren gegangen deswegen konnte man das nicht laden.. die HPP von der main Seite klappt super. Wollte es dir nur sagen und sag mal womit du den code konvertiert hast. ^^ Danke

      Mfg Pius von Team-Wings

      ich würde sagen mit der Enter Taste und viel Gedult :D

      #MAKE_ARMA_NOT_WAR

      ⥴ Scripts made with love

      Why do programmers work in dark rooms?

      Because light attracts bugs...

    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 26. September 2016 um 11:31
      • #15

      Gibts da nicht so ne website?

    • AmaZiinG
      Profi
      Reaktionen
      496
      Beiträge
      798
      Dateien
      4
      Bilder
      46
      • 26. September 2016 um 13:23
      • #16
      Zitat von Team-Wings

      Hey diese Tutorial enthält paar Fehler z.B die HPP da ist beim Code verschönern/Ordnen was verloren gegangen deswegen konnte man das nicht laden.. die HPP von der main Seite klappt super. Wollte es dir nur sagen und sag mal womit du den code konvertiert hast. ^^ Danke

      Mfg Pius von Team-Wings

      Okay danke das du es gesagt hast, ich werde mich drum kümmern.

      Mein Discord:
      https://discord.gg/4UMWmpfDet

    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 26. September 2016 um 13:54
      • #17

      Die Queryrequest geht auch nicht nur so nebenbei ^^

    • AmaZiinG
      Profi
      Reaktionen
      496
      Beiträge
      798
      Dateien
      4
      Bilder
      46
      • 26. September 2016 um 14:04
      • #18
      Zitat von Team-Wings

      Die Queryrequest geht auch nicht nur so nebenbei ^^

      Die muss man halt die Zeilen raussuchen und einfügen in seiner Queryrequest.

      Mein Discord:
      https://discord.gg/4UMWmpfDet

    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 26. September 2016 um 15:32
      • #19

      weißt du vielleicht welche genau?

    • ChickenWeed
      Kenner
      Reaktionen
      63
      Trophäen
      10
      Beiträge
      528
      Bilder
      7
      • 5. Oktober 2016 um 09:20
      • #20

      Irgendeiner einen Fehler gefunden ? :^(

    Registrieren oder Einloggen

    Du bist noch kein Mitglied von NodeZone.net? Registriere dich kostenlos und werde Teil einer großartigen Community!

    Registrieren

    Ähnliche Themen

    • Persistent Proficiency System (Level System/Exp System)

      • AmaZiinG
      • 7. Februar 2017 um 22:11
      • Tutorials & Releases
    • Level/Exp System für die Version 1.3.4.8 Seal Drop

      • lordbrs
      • 22. Mai 2017 um 12:05
      • Hilfeforum
    • PapaBear's Persistent Proficiency System 4.4 R3

      • AmaZiinG
      • 7. Februar 2017 um 16:04
      • Hilfeforum
    • Skillsystem gesucht

      • Gruffi
      • 19. September 2016 um 17:56
      • Hilfeforum

    Wichtige Links & Informationen

    Server & Hosting-Ressourcen

      Server Administration & Hosting Basics

      Windows Server Support & Guides

      Linux Server Configuration & Help

      Setting up TeamSpeak 3 & VoIP Servers

      Domains & Web Hosting for Beginners & Professionals

      Cloud Hosting, Docker & Kubernetes Tutorials

    Gameserver & Modding-Ressourcen

      ArmA 3 Tutorials & Script Collection

      Renting & Operating Gameservers

      DayZ Server Management & Help

      FiveM (GTA V) Server & Script Development

      Rust Server Modding & Administration

      Setting up & Optimizing ARK Survival Servers

    NodeZone.net – Deine Community für Gameserver, Server-Hosting & Modding

      NodeZone.net ist dein Forum für Gameserver-Hosting, Rootserver, vServer, Webhosting und Modding. Seit 2015 bietet unsere Community eine zentrale Anlaufstelle für Server-Admins, Gamer und Technikbegeisterte, die sich über Server-Management, Hosting-Lösungen und Spielemodding austauschen möchten.


      Ob Anleitungen für eigene Gameserver, Hilfe bei Root- und vServer-Konfigurationen oder Tipps zu Modding & Scripting – bei uns findest du fundiertes Wissen und praxisnahe Tutorials. Mit einer stetig wachsenden Community findest du hier Antworten auf deine Fragen, Projektpartner und Gleichgesinnte für deine Gaming- und Serverprojekte. Schließe dich NodeZone.net an und werde Teil einer aktiven Community rund um Server-Hosting, Gameserver-Management und Modding-Ressourcen.

    Wer jetzt nicht teilt ist selber Schuld:
    1. Nutzungsbestimmungen
    2. Datenschutzerklärung
    3. Impressum
    4. Urheberrechts- oder Lizenzverstoß melden
  • Trimax Design coded & layout by Gino Zantarelli 2023-2025©
    Community-Software: WoltLab Suite™