Dynamic Market

class life_dynmarket_prices {
	idd = 7100;
	name= "life_dynmarket_prices";
	movingEnable = false;
	enableSimulation = true;
	onLoad = "[] spawn {sleep 1;[] call life_fnc_LoadIntoListbox;};";




	class controlsBackground {
	};




	class controls {







class TitleMarkt: Life_RscTitle
{
	idc = 1005656000;
	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])", "(profilenamespace getvariable ['GUI_BCG_RGB_A',0.7])"};




	sizeEx = 0.05;
	text = "Market"; //--- ToDo: Localize;
	x = 0.276563 * safezoneW + safezoneX;
	y = 0.367043 * safezoneH + safezoneY;
	w = 0.446875 * safezoneW;
	h = 0.020900 * safezoneH;
};




class RscFrame_1800: Life_RscText
{
	idc = -1;




	x = 0.276563 * safezoneW + safezoneX;
	y = 0.390043 * safezoneH + safezoneY;
	w = 0.446875 * safezoneW;
	h = 0.319914 * safezoneH;
	colorBackground[] = {0,0,0,1};
};
class RscListbox_1500: Life_RscListBox
{
	idc = 7055;
	onLBSelChanged = "[] spawn {[] call life_fnc_DisplayPrices;};";




	x = 0.282292 * safezoneW + safezoneX;
	y = 0.398839 * safezoneH + safezoneY;
	w = 0.211979 * safezoneW;
	h = 0.302321 * safezoneH;
	sizeEx = 0.0260;
};
class RscText_1000: Life_RscText
{
	idc = -1;




	text = "Current Sell Price"; //--- ToDo: Localize;
	x = 0.5 * safezoneW + safezoneX;
	y = 0.401039 * safezoneH + safezoneY;
	w = 0.217708 * safezoneW;
	h = 0.0219914 * safezoneH;
};
class RscText_1001: Life_RscText
{
	idc = 7056;




	text = "Please select an Item"; //--- ToDo: Localize;
	x = 0.5 * safezoneW + safezoneX;
	y = 0.420831 * safezoneH + safezoneY;
	w = 0.20625 * safezoneW;
	h = 0.0549786 * safezoneH;
	sizeEx = 0.060;
};
class RscText_1002: Life_RscText
{
	idc = -1;




	text = "Amout of Items sold by You"; //--- ToDo: Localize;
	x = 0.5 * safezoneW + safezoneX;
	y = 0.5 * safezoneH + safezoneY;
	w = 0.217708 * safezoneW;
	h = 0.0229914 * safezoneH;
};
class RscText_1003: Life_RscText
{
	idc = 7057;




	text = "2345"; //--- ToDo: Localize;
	x = 0.5 * safezoneW + safezoneX;
	y = 0.513195 * safezoneH + safezoneY;
	w = 0.20625 * safezoneW;
	h = 0.0559786 * safezoneH;
	sizeEx = 0.060;
};
class RscButtonMenu_2400: Life_RscButtonMenu
{
	onButtonClick = "closeDialog 0;";




	idc = 1006;
	text = "OKAY"; //--- ToDo: Localize;
	x = 0.5 * safezoneW + safezoneX;
	y = 0.67697 * safezoneH + safezoneY;
	w = 0.217708 * safezoneW;
	h = 0.0259914 * safezoneH;
	colorText[] = {1,1,1,1};
	colorBackground[] = {0,0.52,0.03,1};
};
class RscText_1007: Life_RscStructuredText
{
	idc = 7058;




	text = ""; //--- ToDo: Localize;
	x = 0.5 * safezoneW + safezoneX;
	//y = 0.447221 * safezoneH + safezoneY;
	y = 0.460221 * safezoneH + safezoneY;
	w = 0.20625 * safezoneW;
	h = 0.0549786 * safezoneH;
	colorText[] = {0.33,0.33,0.33,1};
};
};
};

/*
##################### 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 = "";
		switch (_whatanumber) do {
			case 1: {_query = format["UPDATE dynmarket SET prices='%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 = switch(_whatanumber) do {
			case 1: {_returnCount = 11; 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 "####################################################################";
		};
	};
};