forward LoadMysqlHouses();
public LoadMysqlHouses()
{
	new rows,string[128];
    cache_get_row_count(rows);
    if(!rows)return print("NO NUMROWS");
	if(rows)
	{
	//	for(new i;i<sizeof(i);i++)
	    for(new i; i<rows; i++)
 		{
		    new idx;
		    cache_get_value_name_int(i, "hID", idx);
		    cache_get_value_name_int(i, "hID", HouseInfo[idx][hHouseID]);
		    cache_get_value_name_int(i, "hcreated", HouseInfo[idx][hCreated]);
	        cache_get_value_name_float(i, "hentrancex", HouseInfo[idx][hEntrancex]);
	        cache_get_value_name_float(i, "hentrancey", HouseInfo[idx][hEntrancey]);
	        cache_get_value_name_float(i, "hentrancez", HouseInfo[idx][hEntrancez]);
	        cache_get_value_name_float(i, "hexitx", HouseInfo[idx][hExitx]);
	        cache_get_value_name_float(i, "hexity", HouseInfo[idx][hExity]);
	        cache_get_value_name_float(i, "hexitz", HouseInfo[idx][hExitz]);

	        cache_get_value_name(i, "howner", HouseInfo[idx][hOwner], MAX_PLAYER_NAME);
	        cache_get_value_name(i, "hdiscription", HouseInfo[idx][hDiscription], 128);  // hDiscription Länge?


			cache_get_value_name_int(i, "hvalue", HouseInfo[idx][hValue]);


		    cache_get_value_name_int(i, "hhel", HouseInfo[idx][hHel]);
		    cache_get_value_name_int(i, "harm", HouseInfo[idx][hArm]);
		    cache_get_value_name_int(i, "hint", HouseInfo[idx][hInt]);
			cache_get_value_name_int(i, "hlock", HouseInfo[idx][hLock]);
			cache_get_value_name_int(i, "howned", HouseInfo[idx][hOwned]);


		    cache_get_value_name_int(i, "hrooms", HouseInfo[idx][hRooms]);
		    cache_get_value_name_int(i, "hrent", HouseInfo[idx][hRent]);
		    cache_get_value_name_int(i, "hrentabil", HouseInfo[idx][hRentabil]);
			cache_get_value_name_int(i, "hdate", HouseInfo[idx][hDate]);
			cache_get_value_name_int(i, "hlevel", HouseInfo[idx][hLevel]);

			updateHouse(i);
		}
		return 1;
	}
	return 1;
}

updateHouse(idx)
{
	new string[128];
	if(HouseInfo[idx][hPickup]!=-1)
	{
		DestroyPickup(HouseInfo[idx][hPickup]);
	}
	if(HouseInfo[idx][hText]!=Text3D:-1)
	{
	    Delete3DTextLabel(HouseInfo[idx][hText]);
	}
	if(HouseInfo[idx][hOwned] == 0)
	{
		HouseInfo[idx][hPickup] = AddStaticPickup(1273, 1, HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],-1);
		format(string, sizeof(string), "==== [HausID: %d] ====\nBesitzer: %s\nBeschreibung: %s\nPreis: %d$\n/buyhouse zum kaufen",HouseInfo[idx][hHouseID],HouseInfo[idx][hOwner],HouseInfo[idx][hDiscription],HouseInfo[idx][hValue]);
		HouseInfo[idx][hText] = Create3DTextLabel(string,0x0091FFFF,HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],18.0,0,0);

 	}
  	if(HouseInfo[idx][hOwned] == 1)
	{
	    if(HouseInfo[idx][hRentabil] == 0)
	    {
	        HouseInfo[idx][hPickup] = AddStaticPickup(19522, 1, HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],-1);
 			format(string, sizeof(string), "==== [HausID: %d] ====\nBesitzer: %s\nBeschreibung: %s\nPreis: %d$\nMiete: Nicht mietbar\nEinmieten mit /renthouse",HouseInfo[idx][hHouseID],HouseInfo[idx][hOwner],HouseInfo[idx][hDiscription],HouseInfo[idx][hValue]);
			HouseInfo[idx][hText] = Create3DTextLabel(string,0x0091FFFF,HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],18.0,0,0);
		}
		else
		{
 			HouseInfo[idx][hPickup] = AddStaticPickup(19523, 1, HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],-1);
 			format(string, sizeof(string), "==== [HausID: %d] ====\nBesitzer: %s\nBeschreibung: %s\nPreis: %d$\nMiete: %d$\nEinmieten mit /renthouse",HouseInfo[idx][hHouseID],HouseInfo[idx][hOwner],HouseInfo[idx][hDiscription],HouseInfo[idx][hValue],HouseInfo[idx][hRent]);
			HouseInfo[idx][hText] = Create3DTextLabel(string,0x0091FFFF,HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],18.0,0,0);
		}
	}

}