forward LoadBusinesses();
public LoadBusinesses()
{
    new interiorcount[19];
    if(cache_num_rows())
    {
        for(new id = 1; id < cache_num_rows(); id++)
        {

            cache_get_value_int(id, "SQLID", BusinessInfo[id][SQLID]);

            cache_get_value(id, "Name", BusinessInfo[id][Name], 32);

            cache_get_value_float(id, "ExteriorX", BusinessInfo[id][ExteriorX]);
            cache_get_value_float(id, "ExteriorY", BusinessInfo[id][ExteriorY]);
            cache_get_value_float(id, "ExteriorZ", BusinessInfo[id][ExteriorZ]);
            cache_get_value_float(id, "ExteriorA", BusinessInfo[id][ExteriorA]);

            cache_get_value_int(id, "Interior", BusinessInfo[id][Interior]);
            cache_get_value_int(id, "VirtualWorld", BusinessInfo[id][VirtualWorld]);

            cache_get_value_float(id, "InteriorX", BusinessInfo[id][InteriorX]);
            cache_get_value_float(id, "InteriorY", BusinessInfo[id][InteriorY]);
            cache_get_value_float(id, "InteriorZ", BusinessInfo[id][InteriorZ]);
            cache_get_value_float(id, "InteriorA", BusinessInfo[id][InteriorA]);



            cache_get_value_int(id, "Price", BusinessInfo[id][Price]);
            cache_get_value_int(id, "Owned", BusinessInfo[id][Owned]);
            cache_get_value_int(id, "Kasa", BusinessInfo[id][Kasa]);


            cache_get_value_int(id, "CashSafe", BusinessInfo[id][CashSafe]);
            cache_get_value_int(id, "Type", BusinessInfo[id][Type]);
            cache_get_value_int(id, "Locked", BusinessInfo[id][Locked]);
            cache_get_value_int(id, "OwnerID", BusinessInfo[id][OwnerID]);
            cache_get_value_int(id, "Products", BusinessInfo[id][Products]);

            Total_Biz_Created++;

            //BusinessInfo[id][World] = interiorcount[BusinessInfo[id][Interior]];
            interiorcount[BusinessInfo[id][Interior]]++;
            CreateBusiness(id);

        }
    }

    //mysql_close(Database2);
    printf("[MYSQL]: %d Businesses have been successfully loaded from the database.", Total_Biz_Created);
    return 1;
}



YCMD:makebusiness(playerid, params[],help)
{
	#pragma unused help

	new query[400];
	//Total_Biz_Created++;
	mysql_format(Database, query, sizeof(query), "INSERT INTO `businesses` (Name, Price, ExteriorX, ExteriorY, ExteriorZ, ExteriorA, InteriorX, InteriorY, InteriorZ, InteriorA, Interior, VirtualWorld, Type) \
		VALUES('KreiranjeBiznisa', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)");
	mysql_tquery(Database, query);




	BusinessInfo[NewBiz[playerid]][SQLID] = NewBiz[playerid];


	new vrsta, string[200];
	new Float:X, Float:Y, Float:Z, Float:A;

	if(sscanf(params, "i", vrsta)){SendClientMessage(playerid, -1, "USE: /makebusiness [bizID]"); return 1;}

	if(vrsta < 0 || vrsta > 20) return SendClientMessage(playerid, COLOR_ERROR, "That id doesnt exist yet.");
	if(vrsta == 0)
	{
		BusinessInfo[NewBiz[playerid]][InteriorX] = -25.8687;
		BusinessInfo[NewBiz[playerid]][InteriorY] = -141.2887;
		BusinessInfo[NewBiz[playerid]][InteriorZ] = 1003.5469;
		BusinessInfo[NewBiz[playerid]][InteriorA] = 0.2820;

    	BusinessInfo[NewBiz[playerid]][Interior] = 16;
    	BusinessInfo[NewBiz[playerid]][Price] = 75000;
    	//BusinessInfo[NewBiz[playerid]][Name][0] = EOS;
    	strins(BusinessInfo[NewBiz[playerid]][Name], "24/7", 0, 5);

    	//SQLID,
		//OwnerID,
	}

	GetPlayerPos(playerid, X, Y, Z);
	GetPlayerFacingAngle(playerid, A);

	BusinessInfo[NewBiz[playerid]][ExteriorX] = X;
	BusinessInfo[NewBiz[playerid]][ExteriorY] = Y;
	BusinessInfo[NewBiz[playerid]][ExteriorZ] = Z;
	BusinessInfo[NewBiz[playerid]][ExteriorA] = A;

    BusinessInfo[NewBiz[playerid]][VirtualWorld] = NewBiz[playerid];
    BusinessInfo[NewBiz[playerid]][Type] = 0;
    BusinessInfo[NewBiz[playerid]][Owned] = 0;
    BusinessInfo[NewBiz[playerid]][CashSafe] = 0;
    BusinessInfo[NewBiz[playerid]][Locked] = 0;
    BusinessInfo[NewBiz[playerid]][Kasa] = 0;
    BusinessInfo[NewBiz[playerid]][Products] = 1000;

    mysql_format(Database, query, sizeof(query), "UPDATE `businesses` SET `InteriorX` = %f, `InteriorY` = %f, `InteriorZ` = %f, `InteriorA` = %f WHERE `SQLID` = %d LIMIT 1",
		BusinessInfo[NewBiz[playerid]][InteriorX], BusinessInfo[NewBiz[playerid]][InteriorY], BusinessInfo[NewBiz[playerid]][InteriorZ], BusinessInfo[NewBiz[playerid]][InteriorA], BusinessInfo[NewBiz[playerid]][SQLID]);
    mysql_tquery(Database, query);


    mysql_format(Database, query, sizeof(query), "UPDATE `businesses` SET `InteriorX` = %f, `InteriorY` = %f, `InteriorZ` = %f, `InteriorA` = %f WHERE `SQLID` = %d LIMIT 1",
		BusinessInfo[NewBiz[playerid]][InteriorX], BusinessInfo[NewBiz[playerid]][InteriorY], BusinessInfo[NewBiz[playerid]][InteriorZ], BusinessInfo[NewBiz[playerid]][InteriorA], BusinessInfo[NewBiz[playerid]][SQLID]);
    mysql_tquery(Database, query);

    mysql_format(Database, query, sizeof(query), "UPDATE `businesses` SET `ExteriorX` = %f, `ExteriorY` = %f, `ExteriorZ` = %f, `ExteriorA` = %f WHERE `SQLID` = %d LIMIT 1",
		BusinessInfo[NewBiz[playerid]][ExteriorX], BusinessInfo[NewBiz[playerid]][ExteriorY], BusinessInfo[NewBiz[playerid]][ExteriorZ], BusinessInfo[NewBiz[playerid]][ExteriorA], BusinessInfo[NewBiz[playerid]][SQLID]);
    mysql_tquery(Database, query);

    mysql_format(Database, query, sizeof(query), "UPDATE `businesses` SET `Interior` = %d, `Name` = '%e', `VirtualWorld` = %d, `Type` = %d, `Owned` = %d WHERE `SQLID` = %d LIMIT 1",
		BusinessInfo[NewBiz[playerid]][Interior], BusinessInfo[NewBiz[playerid]][Name], BusinessInfo[NewBiz[playerid]][VirtualWorld], BusinessInfo[NewBiz[playerid]][Type], BusinessInfo[NewBiz[playerid]][Owned], BusinessInfo[NewBiz[playerid]][SQLID]);
    mysql_tquery(Database, query);

	mysql_format(Database, query, sizeof(query), "UPDATE `businesses` SET `CashSafe` = %d, `Locked` = %d, `Kasa` = %d, `Products` = %d WHERE `SQLID` = %d LIMIT 1",
		BusinessInfo[NewBiz[playerid]][CashSafe], BusinessInfo[NewBiz[playerid]][Locked], BusinessInfo[NewBiz[playerid]][Kasa], BusinessInfo[NewBiz[playerid]][Products], BusinessInfo[NewBiz[playerid]][SQLID]);
    mysql_tquery(Database, query);

    format(string,sizeof(string),"ON SALE (%d)\n %s\nICERP: %d\nTO BUZ /buybiz", NewBiz[playerid], BusinessInfo[NewBiz[playerid]][Name], BusinessInfo[NewBiz[playerid]][Price]);


    FirmaLabel[NewBiz[playerid]] = Create3DTextLabel(string, COLOR_WHITE, X, Y, Z, 25, 0, 1);
    FirmaPickup[NewBiz[playerid]] = CreatePickup(1274, 1, BusinessInfo[NewBiz[playerid]][ExteriorX], BusinessInfo[NewBiz[playerid]][ExteriorY], BusinessInfo[NewBiz[playerid]][ExteriorZ]);

	SendClientMessage(playerid, -1, "Success!");
	return 1;
}