CMD:createhouse(playerid, params[])
{
	new pret, nivel;
	if(PlayerInfo[playerid][pAdmin] < 6) return SCM(playerid, COLOR_WHITE, "Nu ai acces!");
	if(CreateHouse[playerid] == 1) return SCM(playerid, COLOR_YELLOW2, "Eroare: Deja creezi o casa!");
	if(sscanf(params, "ii", pret, nivel)) return SendClientMessage(playerid, COLOR_GREY, "Sintaxa: {FFFFFF}/createhouse <pret> <nivel>");
    PlayerTextDrawSetString(playerid, ShopTDs[1], "Seteaza");
	CreateHouse[playerid] = 1;
	SInterior[playerid] = 1;
	pPret[playerid] = pret;
	pNivel[playerid] = nivel;
	GetPlayerPos(playerid, pPos[playerid][0], pPos[playerid][1], pPos[playerid][2]);
    pInteriorID[playerid] = GetPlayerInterior(playerid), pVirtual[playerid] = GetPlayerVirtualWorld(playerid);
	SetInteriorCamera(playerid);
	ShowShopTDs(playerid);
	SetPlayerVirtualWorld(playerid, playerid+900);
	return 1;
}


//dupa ce am adaugat interiorul
new x = SInterior[playerid]-1;
		    new xQuery[1024];
			mysql_format(SQL, xQuery, sizeof(xQuery),"INSERT INTO houses (`Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Interior`, `Level`, `Value`) VALUES ('%f', '%f', '%f', '%f', '%f', '%f', '%d', '%d', '%d')",
			pPos[playerid][0], pPos[playerid][1], pPos[playerid][2], InteriorPos[x][0], InteriorPos[x][1], InteriorPos[x][2], GetPlayerInterior(playerid), pNivel[playerid], pPret[playerid]);
			new Cache: result = mysql_query(SQL, xQuery);
			new i = cache_insert_id();
			cache_delete(result);
			HouseInfo[i][hID] = i;
			HouseInfo[i][hExitx] = InteriorPos[x][0];
			HouseInfo[i][hExity] = InteriorPos[x][1];
			HouseInfo[i][hExitz] = InteriorPos[x][2];
			HouseInfo[i][hEntrancex] = pPos[playerid][0];
			HouseInfo[i][hEntrancey] = pPos[playerid][1];
			HouseInfo[i][hEntrancez] = pPos[playerid][2];
			HouseInfo[i][hLevel] = pNivel[playerid];
			HouseInfo[i][hVirtual] = i;
			format(string, sizeof(string), "SELECT `houses` SET `Virtual`='%d' WHERE `ID`='%d'", i, i);
			mysql_query(SQL, string);
			HouseInfo[i][hValue] = pPret[playerid];
			HouseInfo[i][hInterior] = GetPlayerInterior(playerid);

			HUpdate(i, hExitxx);
			HUpdate(i, hExityx);
			HUpdate(i, hExitzx);
			HUpdate(i, hInteriorx);
			OnPropTextdrawUpdate(1, i);
			SCM(playerid, COLOR_GOLD, "Casa a fost creata cu succes!");
			format(string, sizeof(string), "Informatii: Interior %d, Nivel %d, Pret $%s.", x, pNivel[playerid], FormatNumber(pPret[playerid]));
			SCM(playerid, COLOR_GOLD, string);
			HideShopTDs(playerid), SetCameraBehindPlayer(playerid), SetPlayerPos(playerid, pPos[playerid][0], pPos[playerid][1], pPos[playerid][2]);
			SetPlayerVirtualWorld(playerid, pVirtual[playerid]);
			SetPlayerInterior(playerid, pInteriorID[playerid]);
			CreateHouse[playerid] = 0;


public LoadProperty()
{
	new result[100],index = 0;
    mysql_query(SQL,"SELECT * FROM `houses` ORDER BY `houses`.`ID` ASC");
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        housess++;
		index++;
		new i = index;
		mysql_get_field("ID", result);				HouseInfo[i][hID] = strval(result);
   	    mysql_get_field("Entrancex", result);		HouseInfo[i][hEntrancex] = floatstr(result);
    	mysql_get_field("Entrancey", result);		HouseInfo[i][hEntrancey] = floatstr(result);
        mysql_get_field("Entrancez", result);		HouseInfo[i][hEntrancez] = floatstr(result);
        mysql_get_field("Exitx", result);			HouseInfo[i][hExitx] = floatstr(result);
        mysql_get_field("Exity", result);			HouseInfo[i][hExity] = floatstr(result);
        mysql_get_field("Exitz", result);			HouseInfo[i][hExitz] = floatstr(result);
        mysql_get_field("Owner", result);			strmid(HouseInfo[i][hOwner], result, 0, 32, 32);
        mysql_get_field("Discription", result);		strmid(HouseInfo[i][hDiscription], result, 0, 24, 24);
        mysql_get_field("Value", result);			HouseInfo[i][hValue] = strval(result);
        mysql_get_field("Hel", result);				HouseInfo[i][hHel] = strval(result);
        mysql_get_field("Arm", result);				HouseInfo[i][hArm] = strval(result);
        mysql_get_field("Interior", result);		HouseInfo[i][hInterior] = strval(result);
        mysql_get_field("Lockk", result);			HouseInfo[i][hLock] = strval(result);
        mysql_get_field("Owned", result);			HouseInfo[i][hOwned] = strval(result);
        mysql_get_field("Rent", result);			HouseInfo[i][hRent] = strval(result);
        mysql_get_field("Rentabil", result);		HouseInfo[i][hRentabil] = strval(result);
        mysql_get_field("Takings", result);			HouseInfo[i][hTakings] = strval(result);
        mysql_get_field("Level", result);			HouseInfo[i][hLevel] = strval(result);
        mysql_get_field("Virtual", result);			HouseInfo[i][hVirtual] = strval(result);
	}
	mysql_free_result();
	printf("Houses: %d", index);
	return 1;
}