Beiträge von Derverdox

class CfgGather {
    class Resources {
    class apple {
        amount = 5;
        zones[] = { "apple_1", "apple_2", "apple_3", "apple_4" };
        item = "";
        zoneSize = 30;
    };
    class peach {
        amount = 5;
        zones[] = { "peaches_1", "peaches_2", "peaches_3", "peaches_4" };
        item = "";
        zoneSize = 30;
    };
    class heroin_unprocessed {
        amount = 3;
        zones[] = { "heroin_1" };
        item = "";
        zoneSize = 30;
    };
    class cocaine_unprocessed {
        amount = 3;
        zones[] = { "cocaine_1" };
        item = "";
        zoneSize = 30;
    };
    class cannabis {
        amount = 3;
        zones[] = { "weed_1" };
        item = "";
        zoneSize = 30;
    };
    class sugar {
        amount = 3;
        zones[] = { "sugar_1" };
        item = "";
        zoneSize = 30;
    };
    class banana {
        amount = 3;
        zones[] = { "banana_1" };
        item = "";
        zoneSize = 30;
    };
        class wheat {
        amount = 3;
        zones[] = { "wheat_1" };
        item = "";
        zoneSize = 30;
    };
 };
/*
This block can be set using percent,if you want players to mine only one resource ,just leave it as it is.
Example:
 class copper_unrefined
 {
 amount = 2;
 zones[] = { "copper_mine" };
 item = "pickaxe";
 mined[] = { "copper_unrefined" };
This will make players mine only copper_unrefined
Now let's go deeper
Example 2:
 class copper_unrefined
 {
 amount = 2;
 zones[] = { "copper_mine" };
 item = "pickaxe";
 mined[] = { {"copper_unrefined",0,25},{"iron_unrefined",25,95},{"diamond_uncut",95,100} };
 };
 This will give :
 25(±1)% to copper_unrefined;
 70(±1)% to iron_unrefined;
 5%(±1)% to diamond_uncut;
 ! Watch Out !
 If percents are used,you MUST put more than 1 resource in the mined parameter
 mined[] = { {"copper_unrefined",0,25} }; NOT OK (But the script will work)
 mined[] = { {"copper_unrefined",0,45 },{"iron_unrefined",45} }; NOT OK (The script won't work )
 mined[] = { {"copper_unrefined",0,45},{"copper_unrefined",80,100} }; NOT OK
 mined[] = { "copper_unrefined" }; OK
 mined[] = { {"copper_unrefined",0,35} , { "iron_unrefined" ,35,100 } }; OK
*/
 class Minerals {
    class copper_unrefined {
        amount = 2;
        zones[] = { "copper_mine" };
        item = "pickaxe";
        mined[] = {"copper_unrefined"};
        zoneSize = 30;
    };
    class iron_unrefined {
        amount = 2;
        zones[] = { "iron_mine" };
        item = "pickaxe";
        mined[] = { "iron_unrefined" };
        zoneSize = 30;
    };
    class salt_unrefined {
        amount = 2;
        zones[] = { "salt_mine" };
        item = "pickaxe";
        mined[] = { "salt_unrefined" };
        zoneSize = 30;
    };
    class diamond_uncut {
        amount = 2;
        zones[] = { "diamond_mine" };
        item = "pickaxe";
        mined[] = { "diamond_uncut" };
        zoneSize = 30;
    };
    class rock {
        amount = 2;
        zones[] = { "rock_quarry" };
        item = "pickaxe";
        mined[] = { "rock" };
        zoneSize = 30;
    };
    class oil_unprocessed {
        amount = 2;
        zones[] = { "oil_field_1", "oil_field_2" };
        item = "pickaxe";
        mined[] = { "oil_unprocessed" };
        zoneSize = 30;
    };
 };
};

#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]],
    ["_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;

//In der gelieferten Version nimmt er eine playerid! Die ist aber in der 5.0 (wahrscheinlich auch in der 4.0) die "pid"
_query = format ["INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('%1', '%2', '%3', '%4', '%5','""[]""','""[]""','""[]""','""[]""','""[]""','""[]""')",
    _uid,
    _name,
    _money,
    _bank,
    _alias
];
_query_2 = format["INSERT INTO perso(pid, persoCop, persoMed, persoCiv, persoEast) VALUES ('%1','""[]""','""[]""','""[]""','""[]""')",_uid];
[_query,1] call DB_fnc_asyncCall;
[_query_2,1] call DB_fnc_asyncCall;
[] remoteExecCall ["SOCK_fnc_dataQuery",(owner _returnToSender)];