Beiträge von SnillocTV

/*

    Main configuration for non-persistent market system
    Will need triggers to hook into vanilla pricing methods
        Edited by: Lukas "Alduin86"

*/

////////////MAIN CONFIG

private["_queryResult","_query","_item","_itemprice","_oilpPrice","_coalrPrice","_iron_rPrice","_diamondcPrice","_copper_rPrice","_salt_rPrice","_glassPrice","_cementPrice","_turtlePrice","_marijuanaPrice","_cocainepPrice","_heroinpPrice","_goldbarPrice"];


_query = format["SELECT resource, price FROM resources"];
waitUntil{sleep (random 0.3); !DB_Async_Active};
_queryResult = [_query,2,true] call DB_fnc_asyncCall;
_rows = call compile format["%1",_queryResult]; //compile data
diag_log "------------- Market Query Request -------------";
diag_log format["Query: %1",_query];
diag_log format["Result: %1",_rows];
diag_log "------------------------------------------------";

//* _rows should look like this now: [["oilp","1000"],["diamond","2000"]];

{
    _item = (_x select 0); //on the first run = "oilp", second run = "diamond")
    _itemprice = (_x select 1); //on the first run = "1000", second run = "2000") //* Note: _price is a STRING now! 
    
    //diag_log format["%1-price %2 generated",_item,_itemprice];    
    if(_item == "oilp") then {_oilpPrice = _itemprice}; // The right price should be assigned
    if(_item == "iron_r") then {_iron_rPrice = _itemprice}; // The right price should be assigned
    if(_item == "diamondc") then {_diamondcPrice = _itemprice}; // The right price should be assigned
    if(_item == "copper_r") then {_copper_rPrice = _itemprice}; // The right price should be assigned
    if(_item == "salt_r") then {_salt_rPrice = _itemprice}; // The right price should be assigned
    if(_item == "glass") then {_glassPrice = _itemprice}; // The right price should be assigned
    if(_item == "cement") then {_cementPrice = _itemprice}; // The right price should be assigned
    if(_item == "turtle") then {_turtlePrice = _itemprice}; // The right price should be assigned
    if(_item == "marijuana") then {_marijuanaPrice = _itemprice}; // The right price should be assigned
    if(_item == "cocainep") then {_cocainepPrice = _itemprice}; // The right price should be assigned
    if(_item == "heroinp") then {_heroinpPrice = _itemprice}; // The right price should be assigned
    if(_item == "goldbar") then {_goldbarPrice = _itemprice}; // The right price should be assigned
    if(_item == "coalr") then {_coalrPrice = _itemprice}; // The right price should be assigned
    
} forEach _rows;


life_market_resources = [

    //Schema: SHORTNAME, DEFAULT-WERT, MIN-WERT, MAX-WERT, VERÄNDERUNG BEI AKTION [VERKAUF Multipliziert mit 1, Kauf multipliziert um -1
    
    ["coalr", _coalrPrice, 550, 1150, 3, 1, 
        [ 
            ["diamondc",1],
            ["copper_r",1],
            ["goldbar",1], 
            ["iron_r",1],
            ["heroinp",1],
            ["cocainep",1],
            ["turtle",3]
        ] 
    ],

    ["glass", _glassPrice, 570, 1450, 3, 1, 
        [  
            ["oilp",1],
            ["salt_r",1],
            ["marijuana",1],
            ["cocainep",1],
            ["heroinp",1],
            ["cement",1],
            ["turtle",3]
        ] 
    ],
    
    ["cement", _cementPrice, 590, 1400, 3, 1, 
        [ 
            ["oilp",1],
            ["salt_r",1],
            ["glass",1],
            ["marijuana",3],
            ["turtle",3]
        ] 
    ],

    ["salt_r", _salt_rPrice, 620, 1500, 3, 1, 
        [  
            ["oilp",1],
            ["cement",1],
            ["marijuana",1],
            ["goldbar",1], 
            ["glass",1],
            ["turtle",3]
        ] 
    ],
    
    ["iron_r", _iron_rPrice, 650, 1700, 2, 1,  
        [ 
            ["diamondc",1], 
            ["copper_r",1],
            ["cocainep",1],
            ["coalr",2],
            ["turtle",3]
        ] 
    ],

    ["oilp", _oilpPrice, 700, 1700, 2, 1, 
        [ 
            ["salt_r",1],
            ["cement",1],
            ["heroinp",2],
            ["marijuana",1],
            ["glass",1],
            ["turtle",3]
        ] 
    ],
    
    ["copper_r", _copper_rPrice, 900, 1800, 2, 1, 
        [ 
            ["diamondc",1], 
            ["iron_r",1],
            ["coalr",3],
            ["goldbar",1], 
            ["marijuana",1],
            ["turtle",3]
        ] 
    ],

    ["diamondc", _diamondcPrice, 1000, 2000, 1, 1, 
        [ 
            ["iron_r",2],
            ["copper_r",1],
            ["coalr",3],
            ["cocainep",3],
            ["glass",1],
            ["turtle",3]
        ] 
    ],

    ["goldbar", _goldbarPrice, 100000, 200000, 1, 5, 
        [ 
            ["diamondc",3], 
            ["iron_r",3],
            ["copper_r",3],
            ["coalr",3],
            ["marijuana",1],
            ["heroinp",1],
            ["cocainep",1],
            ["oilp",3],
            ["salt_r",3],
            ["cement",3],
            ["glass",3],
            ["coalr",3],
            ["turtle",3]

        ] 
    ],

    ///////////////////////////////////
    
    ["turtle", _turtlePrice, 1500, 6000, 2, 2,  
        [ 
        ] 
    ],
    
    ["marijuana", _marijuanaPrice, 1100, 2500, 2, 1,   
        [  
            ["cement",1],
            ["copper_r",3],
            ["diamondc",2],
            ["goldbar",3], 
            ["glass",1],
            ["turtle",3]
        ] 
    ],
    
    ["cocainep", _cocainepPrice, 1200, 2750, 2, 1,   
        [ 
            ["copper_r",1],
            ["iron_r",1],
            ["goldbar",3], 
            ["coalr",2],
            ["turtle",3]
        ] 
    ],
    
    ["heroinp", _heroinpPrice, 1300, 3000, 2, 1,   
        [ 
            ["diamondc",1],
            ["salt_r",3],
            ["oilp",1],
            ["copper_r",1],
            ["goldbar",3],
            ["coalr",2],
            ["turtle",3]
        ] 
    ]
];


publicVariable "life_market_resources";

diag_log "------------- Life Market Resources -------------";
diag_log format["Result: %1",life_market_resources];
diag_log "------------------------------------------------";

life_market_shortnames = [];

{
    life_market_shortnames set [count life_market_shortnames, _x select 0];
}
foreach life_market_resources;

publicVariable "life_market_shortnames";

life_market_prices = [];
{
    life_market_prices set [count life_market_prices, [_x select 0, _x select 1, 0, 0] ];
}
foreach life_market_resources;
    
publicVariable "life_market_prices";

systemChat "Market Prices Generated!";

15:49:09 Error in expression <[[''license_civ_driver'',0],[''license_civ_a>
15:49:09   Error position: <license_civ_driver'',0],[''license_civ_a>
15:49:09   Error Missing ]
15:49:09 Error in expression <[[''license_civ_driver'',0],[''license_civ_a>
15:49:09   Error position: <license_civ_driver'',0],[''license_civ_a>
15:49:09   Error Missing ]
15:49:09 Error in expression <ay = call compile format["%1", _array];
_array;>
15:49:09   Error position: <_array;>
15:49:09   Error Undefined variable in expression: _array
15:49:09 File \life_server\Functions\MySQL\fn_mresToArray1.sqf [DB_fnc_mresToArray1], line 26
15:49:09 Error in expression <[''U_C_Poloshirt_redwhite'','''','''','''',>
15:49:09   Error position: <U_C_Poloshirt_redwhite'','''','''','''',>
15:49:09   Error Missing ]
15:49:09 Error in expression <[''U_C_Poloshirt_redwhite'','''','''','''',>
15:49:09   Error position: <U_C_Poloshirt_redwhite'','''','''','''',>
15:49:09   Error Missing ]
15:49:09 Error in expression <ay = call compile format["%1", _array];
_array;>
15:49:09   Error position: <_array;>
15:49:09   Error Undefined variable in expression: _array
15:49:09 File \life_server\Functions\MySQL\fn_mresToArray1.sqf [DB_fnc_mresToArray1], line 26
15:49:09 Error in expression <] call DB_fnc_mresToArray1;
if(typeName _new == "STRING") then {_new = call comp>
15:49:09   Error position: <_new == "STRING") then {_new = call comp>
15:49:09   Error Undefined variable in expression: _new
15:49:09 File \life_server\Functions\MySQL\fn_queryRequest.sqf [DB_fnc_queryRequest], line 59