case 3:
                {
                    mysql_query(Mysql_users, "SELECT * FROM `"NAMU_LENTELE"`" ); 
                    if(cache_num_rows())
                    {
                        for(new i=0; i<cache_num_rows(); i++)
                        {
                            if(GetPlayerMoney(playerid) < HouseData[i][Namokaina])
                            {
                                SendClientMessage(playerid,COLOR_RED,"Atsipraљome, bet jums nepakanka pinigų nusipirkti љį nąmą."); //You don't have money to buy this house
                            }
                            else
                            {
                                GivePlayerMoney(playerid, -HouseData[i][Namokaina]);
                                SendClientMessage(playerid, -1,"{0080C0}Nusipirkote namą. Namo valdymas: /namas"); //You bought house. House commands: /house
                                mysql_format(Mysql_users, query, sizeof(query), "UPDATE `"NAMU_LENTELE"` SET Savininkas='%s', Parduodamas='0', Pavadinimas='%s namas' WHERE `ID` = '%i'", PlayerData[playerid][Fullname], PlayerData[playerid][Fullname], HouseData[i][ID]); // Set Owner='%s', Buyable='0', HouseName='%s house' WHERE `HouseID`='%i'
                                mysql_tquery(Mysql_users, query, "", "");
                                HouseData[i][Parduodamas] = 0;
                                new Vardas[MAX_PLAYER_NAME];
                                format(HouseData[i][Savininkas], 64, "%s", Vardas);

                                HouseData[i][Savininkas] = Vardas;

                            }
                        }
                    }
                }

forward LoadHouseData(playerid);
public LoadHouseData(playerid)
{
    AntiDeAMX();
    if(cache_num_rows())
    {
        for(new i=0; i<cache_num_rows(); i++)
        {
            HouseData[i][ID] = cache_get_field_content_int(i, "ID", Mysql_users);
            cache_get_field_content(i, "Pavadinimas", HouseData[i][Pavadinimas], Mysql_users, 129);
            cache_get_field_content(i, "Savininkas", HouseData[i][Savininkas], Mysql_users, 129);
            HouseData[i][Namokaina] = cache_get_field_content_int(i, "Namokaina", Mysql_users);
            HouseData[i][Parduodamas] = cache_get_field_content_int(i, "Parduodamas", Mysql_users);
            HouseData[i][PositionX] = cache_get_field_content_float(i, "PositionX", Mysql_users);
            HouseData[i][PositionY] = cache_get_field_content_float(i, "PositionY", Mysql_users);
            HouseData[i][PositionZ] = cache_get_field_content_float(i, "PositionZ", Mysql_users);
            HouseData[i][Interior] = cache_get_field_content_int(i, "Interior", Mysql_users);


            new labelstring[500];
            switch(HouseData[i][Parduodamas])
            {
                case 0:
                {
                    format(labelstring,sizeof(labelstring),"Namas Nr. %i\n %s\nNamo savininkas: %s\nNamo valdymas ENTER.", HouseData[i][ID], HouseData[i][Pavadinimas], HouseData[i][Savininkas]);
                    //PickupData[HouseData[playerid][ID]][Namas] = CreatePickup(1273, 1, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ], -1);
                    PickupData[i][Namas] = CreatePickup(1273, 2, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ], -1);

                }
                case 1:
                {
                    format(labelstring,sizeof(labelstring),"Namas Nr. %i parduodamas\n %s\nNamo savininkas: %s\nNamo kaina: %i\nNamo pirkimas ENTER.", HouseData[i][ID], HouseData[i][Pavadinimas], HouseData[i][Savininkas]);
                    //PickupData[HouseData[playerid][ID]][Namas] = CreatePickup(1272, 1, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ], -1);
                    PickupData[i][Namas] = CreatePickup(1272, 2, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ], -1);
                }
            }
            Create3DTextLabel(labelstring, -1, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ]+0.75, 40.0, 0, 0);
            Update3DTextLabelText(HouseData[i][ID], -1, labelstring);
            

            
            
            
            printf("[%i] - Kuriame nama namo ID: %i Pavadinimas: %s Savininkas %s",i, HouseData[i][ID], HouseData[i][Pavadinimas], HouseData[i][Savininkas]);
        }
    }
    return 1;
}