[TUTORIAL][Altis Life 4.4r3] RyanTTs Dynamic Market System

/*
##################### DYNAMIC MARKET SCRIPT #####################
### AUTHOR: RYAN TT.                                          ###
### STEAM: www.steamcommunity.com/id/ryanthett                ###
###                                                           ###
### DISCLAIMER: THIS SCRIPT CAN BE USED ON EVERY SERVER ONLY  ###
###             WITH THIS HEADER / NOTIFICATION               ###
#################################################################
*/

_switch = _this select 0;
_whatanumber = 1;

switch (_switch) do
{
    case 0:
    {
        _query = format["UPDATE dynmarket SET prices = '%1' WHERE id=1;",DYNMARKET_Items_CurrentPriceArr];
        waitUntil {sleep (random 0.3); !DB_Async_Active};
        _queryResult = [_query,1] call DB_fnc_asyncCall;
        diag_log "### DYNMARKET >> SUCCESSFULLY BACKUP'D CURRENT PRICES TO DATABASE! ###";
    };

    case 1:
    {
        _query = format["SELECT prices FROM dynmarket WHERE id=1;"];

        waitUntil{sleep (random 0.3); !DB_Async_Active};
        _tickTime = diag_tickTime;
        _queryResult = [_query,2] call DB_fnc_asyncCall;
        //DYNMARKET_Items_CurrentPriceArr = _queryResult select 0;
        _pricearray = _queryResult select 0;
        if (count _pricearray < 1) then {
            diag_log "########################## DYNAMIC MARKET ##########################";
            diag_log "### >> CAN'T LOAD PRICES FROM DATABASE: ERROR 01x                ###";
            diag_log "###        THE REQUESTED PRICEARRAY WAS UNEXPECTEDLY EMPTY!      ###";
            diag_log "###        IF YOU ARE RUNNING DYNMARKET FOR THE FIRST TIME,      ###";
            diag_log "###        PLEASE IGNORE THIS ERROR!                             ###";
            diag_log "####################################################################";
        } else {
            DYNMARKET_Items_CurrentPriceArr = _pricearray;
            {
                _itemName = _x select 0;
                _itemNewPrice = _x select 1;
                _index = -1;
                {
                    _index = _index + 1;
                    _curItemName = _x select 0;
                    if (_curItemName==_itemName) then {
                        DYNMARKET_sellarraycopy set [_index,[_itemName,_itemNewPrice]];
                    };
                } forEach DYNMARKET_sellarraycopy;
            } forEach DYNMARKET_Items_CurrentPriceArr;
            diag_log "########################## DYNAMIC MARKET ##########################";
            diag_log "### >> SUCCESSFULLY LOADED PRICES FROM DATABASE!                 ###";
            diag_log "####################################################################";
        };
    };
};

/*
##################### DYNAMIC MARKET SCRIPT #####################
### AUTHOR: RYAN TT.                                          ###
### STEAM: www.steamcommunity.com/id/ryanthett                ###
###                                                           ###
### DISCLAIMER: THIS SCRIPT CAN BE USED ON EVERY SERVER ONLY  ###
###             WITH THIS HEADER / NOTIFICATION               ###
#################################################################
*/

// ███████████████████████████████████████████████████████████████████████
// █████████████████ DYNAMIC MARKET BASIC CONFIGURATION ██████████████████
// ███████████████████████████████████████████████████████████████████████

DYNMARKET_Serveruptime         = 04;   // Serveruptime after restart in hours
DYNMARKET_UseExternalDatabase  = true; // Should the script use the External Database?
DYNMARKET_PriceUpdateInterval  = 15;   // After how many minutes should the price be updated?
DYNMARKET_CreateBackups        = true; // Should the server save write the prices regulary into the Database? If false, it will save the prices before Server-restart?
DYNMARKET_CreateBackupInterval = 03;   // After how many updates (PriceUpdateIntervals) should the prices be saved into the Database?
DYNMARKET_UserNotification     = true; // Should the user be informed with a hint whenever the prices got updated?

// █████████████████ USER NOTIFICATION TEXTS  █████████████████

DYNMARKET_UserNotification_Text = 
[
    "Your prices have been updated!",
    "The new prices are being calculated by the server..."
];

// █████████████████ ITEM GROUP CONFIGURATION █████████████████

DYNMARKET_Items_Groups =
[
    ["Legal",
        [
            ["apple",-1,30,60],
            ["peach",-1,35,65],
            ["sugarraw",-1,400,600],
            ["sugarref",-1,600,1000],
            ["oilu",-1,800,1600],
            ["oilp",-1,1000,2600],
            ["copper",-1,700,1350],
            ["ironr",-1,950,1750],
            ["saltr",-1,500,1000],
            ["glass",-1,750,1250],
            ["diamond",-1,200,850],
            ["diamondc",-1,800,1600],
            ["cement",-1,1500,2300]
        ],
        0.5
    ],
    ["Illegal", 
        [
            ["turtle_raw"-1,4500,6000],
            ["heroinu",-1,950,1750],
            ["heroin",-1,1500,3500],
            ["cannabis",-1,500,1500],
            ["marijuana",-1,1100,3000],
            ["cocaine",-1,1000,2200],
            ["cocainep",-1,2200,4200]
        ],
        0.5
    ]
];

// █████████████████    ALL SELLABLE ITEMS    █████████████████

DYNMARKET_Items_ToTrack        = 
[

    ["apple",25],
    ["peach",50],
    ["tbacon",125],
    ["donut",130],
    ["rabbit_raw",150],
    ["rabbit_grilled",170],
    ["ornate_raw",190],
    ["ornate_grilled",190],
    ["mackerel_raw",190],
    ["mackerel_grilled",190],
    ["tuna_raw",190],
    ["tuna_grilled",190],
    ["mullet_raw",190],
    ["mullet_fried",200],
    ["catshark_raw",200],
    ["catshark_Fried",200],
    ["turtle_soup",200],
    ["turtle_raw",5000],
    ["hen_raw",200],
    ["hen_fried",200],
    ["rooster_raw",210],
    ["sheep_raw",210],
    ["sheep_grilled",155],
    ["goat_raw",155],
    ["goat_grilled",300],
    
    ["redgull",1500],
    ["coffee",10],
    ["waterBottle",10],
    
    ["pickaxe",350],
    ["fuelFull",500],
    ["spikeStrip",1200],
    ["lockpick",75],
    ["goldbar",95000],
    ["blastingcharge",35000],
    ["boltcutter",7500],
    ["defusekit",2500],
    ["storagesmall",75000],
    ["storagebig",15000],
    
    ["oil_processed",2000],
    ["copper_refined",1000],
    ["iron_refined",1250],
    ["salt_refined",800],
    ["glass",900],
    ["diamond_cut",1450],
    ["cement",2100],
    
    ["heroin_processed",2500],
    ["marijuana",2300],
    ["cocaine_processed",3500]
];

//███████████████████████████████████████████████████████████████████████
//██████████████████ DO NOT MODIFY THE FOLLOWING CODE! ██████████████████
//███████████████████████████████████████████████████████████████████████

DYNMARKET_Items_CurrentPriceArr = [];
DYNMARKET_sellarraycopy = DYNMARKET_Items_ToTrack;
DYNMARKET_Serveruptime = (DYNMARKET_Serveruptime * 3600) - 300;
{
    _currentArray = _x;
    DYNMARKET_Items_CurrentPriceArr pushBack [_currentArray select 0,_currentArray select 1,0];
} forEach DYNMARKET_Items_ToTrack;
publicVariable "DYNMARKET_UserNotification";
publicVariable "DYNMARKET_UserNotification_Text";
if (DYNMARKET_UseExternalDatabase) then {[1] call TON_fnc_HandleDB;};
DYNMARKET_UpdateCount = 0;
if (DYNMARKET_UseExternalDatabase) then {
    [] spawn {
        sleep DYNMARKET_Serveruptime;
        diag_log "### DYNMARKET >> CURRENT PRICES ARE BEING WRITTEN TO THE DATABASE    ###";
        diag_log "### DYNMARKET >> AS PLANNED, AWAITING RESULT...                      ###";
        [0] call TON_fnc_HandleDB;
    };
};
sleep 5;
[] call TON_fnc_sleeper;