[CaTaLiNusS]

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_get_field("Licitatie", result); HouseInfo[i][hLicitatie] = strval(result);
}
mysql_free_result();
printf("Houses: %d", index);
return 1;
}