[TUT] Farmboost Script mit MySQL für A3L 5.0.0

#include "..\..\script_macros.hpp"
/*
    File: fn_farmboost.sqf
    Author: Alex Smith

    Description:
    -
*/





private ["_code"];
params ["_code"];




if (count _code isEqualTo 0) exitWith {
    hint "Der Code ist ungültig!";
};

//arma is scheiße
private _darray = _code select 0;
private _selarray = _darray select 3;





if (_selarray == "A") then {
    hint "Der Farmboost (200% Farmen, 200% Verarbeiten) wurde erfolgreich eingelöst! Du kannst den Code nichtmehr benutzen!";
    life_farmboost_A = true;
    publicVariable "life_farmboost_A";
};
 if (_selarray == "B") then {
    hint "Der Farmboost (100% Farmen, 100% Verarbeiten) wurde erfolgreich eingelöst! Du kannst den Code nichtmehr benutzen!";
    life_farmboost_B = true;
    publicVariable "life_farmboost_B";
};
 if (_selarray == "C") then {
    hint "Der Farmboost (50% Farmen, 50% Verarbeiten) wurde erfolgreich eingelöst! Du kannst den Code nichtmehr benutzen!";
    life_farmboost_C = true;
    publicVariable "life_farmboost_C";
};

life_farmboost = true;
publicVariable "life_farmboost";


if(!life_farmboost) then {
    hint "Ein schwerwiegender Fehler ist aufgetreten! Bitte kontaktiere schnellstmöglich einen Admin!";
};

#include "..\..\script_macros.hpp"
/*
    File: fn_farmboost.sqf
    Author: Alex Smith

    Description:
    -
*/
private["_value"];

//13377
_dialog = findDisplay 76548;


_value = ctrlText 13377;




if !(isnil "life_farmboost") exitWith {
hint "Bitte warte bis zum nächsten Restart, dann kannst du deinen Farmboost einlösen!";
};

hint "Dein Code wird geprüft...";
if (life_HC_isActive) then {
    [_value, player] remoteExecCall ["HC_fnc_getFarmcodes",HC_Life];
} else {
    [_value, player] remoteExecCall ["TON_fnc_getFarmcodes",RSERV];
};

class farmcodeeingabe
{
    idd = 76548;
    movingEnable = true;
    
    class ControlsBackground
    {
        class Life_RscTitleBackground : Life_RscText 
        {
            idc = -1;
            x = 0.3;
            y = 0.2;
            w = 0.47;
            h = (1/25);
            colorBackground[] = {0.102,0,0.4078,1};
            
        };
        class MainBackground : Life_RscText 
        {
            idc = -1;
            x = safeZoneX + safeZoneW * 0.41770834;
            y = safeZoneY + safeZoneH * 0.35925926;
            w = safeZoneW * 0.19375;
            h = safeZoneH * 0.09166667;
            colorBackground[] = {0,0,0,0.7};
            
        };
        
    };
    class Controls
    {
        class inputBox : Life_RscEdit 
        {
            idc = 13377;
            x = safeZoneX + safeZoneW * 0.44375;
            y = safeZoneY + safeZoneH * 0.375;
            w = safeZoneW * 0.1375;
            h = safeZoneH * 0.025;
            text = "";
            colorBackground[] = {1,1,1,1};
            colorDisabled[] = {0.2,0.2,0.2,1};
            colorSelection[] = {1,0,0,1};
            colorText[] = {0,0,0,1};
        };
        class payTicket : Life_RscButtonMenu 
        {
            idc = -1;
            x = safeZoneX + safeZoneW * 0.4671875;
            y = safeZoneY + safeZoneH * 0.40925926;
            w = safeZoneW * 0.08958334;
            h = safeZoneH * 0.02222223;
            text = "Einlösen";
            colorBackground[] = {0.6,0.2,0,1};
            onButtonClick = "[] call life_fnc_farmboostquery;";
            class HitZone
            {
                top = 0.0;
                right = 0.0;
                bottom = 0.0;
                left = 0.0;
                
            };
            class ShortcutPos
            {
                top = 0.005;
                left = (6.25*(((safezoneW/safezoneH)min1.2)/40))-0.0225-0.005;
                w = 0.0225;
                h = 0.03;
                
            };
            class TextPos
            {
                top = (((((safezoneW/safezoneH)min1.2)/1.2)/25)-(((((safezoneW/safezoneH)min1.2)/1.2)/25)*1))/2;
                right = 0.005;
                bottom = 0.0;
                left = 0.25*(((safezoneW/safezoneH)min1.2)/40);
                
            };
            
        };
        
    };
    
};

if !(isnil "life_farmboost") then {    
if(life_farmboost_A) then {
        _amount = (_amount * 3);
    };
    if(life_farmboost_B) then {
        _amount = (_amount * 2);
    };
    if(life_farmboost_C) then {
        _amount = round((_amount * 1.5));
    };
};

_time = 0.28;

        if !(isnil "life_farmboost") then {

        if(life_farmboost_A) then {
        _time = 0.09;
        };
        if(life_farmboost_B) then {
        _time = 0.14;
        };
      if(life_farmboost_C) then {
        _time = 0.19;
    };
};




        uiSleep _time;

        _cP = _cP + 0.10;

#include "\life_server\script_macros.hpp"
/*
    File: fn_getFarmcodes.sqf
    Author: Alex Smith

    Description:
    Hör auf zu lesen und kopier schneller!
*/




private ["_code","_tickTime","_queryResult", "_queryResult2"];

params ["_code", "_unit"];

_query = format ["SELECT id, code, active, type FROM farmkeys WHERE code='%1' AND active='1'",_code];


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



    diag_log "------------- FARMCODE!! -------------";
    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 (_queryResult isEqualType "") exitWith {};


_queryREM = format ["UPDATE farmkeys SET active='0' WHERE code='%1'",_code];
_queryREMRES = [_queryREM,1] call DB_fnc_asyncCall;



    diag_log "------------- FARMCODEREMOVE!! -------------";
    diag_log format ["QUERY: %1",_queryREM];
    diag_log format ["Time to complete: %1 (in seconds)",(diag_tickTime - _tickTime)];
    diag_log format ["Result: %1",_queryREMRES];
    diag_log "------------------------------------------------";



[_queryResult] remoteExec ["life_fnc_farmboost",_unit];