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), "UPDATE `houses` SET `Virtual`='%d' WHERE `ID`='%d'", i, i); //Aici scriai "SELECT" in loc de "UPDATE"
            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;
}