tock LoadHouse() {

    for(new i=0;i<MAX_HOUSE;i++) {
	    new query[128];
		format(query, sizeof(query), "SELECT * FROM `house` WHERE `id` = '%d' LIMIT 1", i+1);
		mysql_tquery(sqlBase, query, "OnLoadHouse", "i", i); }

	return 1; }

//==============================================================================

private OnLoadHouse(houseid) {

	new rows, fields;
	new str[24];
	new inte;

	cache_get_row_count(rows);
	cache_get_field_count(fields);

    cache_get_value_name_int(0, "hBought", hInfo[houseid][hBought]);
    cache_get_value_name(0, "hOwner", str, 64); strmid(hInfo[houseid][hOwner], str, 0, strlen(str), 255);
    cache_get_value_name_int(0, "hInt", inte);
    cache_get_value_name_float(0, "hPosX", hInfo[houseid][hPosX]);
    cache_get_value_name_float(0, "hPosY", hInfo[houseid][hPosY]);
    cache_get_value_name_float(0, "hPosZ", hInfo[houseid][hPosZ]);
    cache_get_value_name_int(0, "hPrice", hInfo[houseid][hPrice]);
    cache_get_value_name_int(0, "hLevel", hInfo[houseid][hLevel]);
    cache_get_value_name_int(0, "hPosta", hInfo[houseid][hPosta]);
    cache_get_value_name_int(0, "hSmece", hInfo[houseid][hSmece]);
    cache_get_value_name_int(0, "hNovine", hInfo[houseid][hNovine]);
    cache_get_value_name_int(0, "hPice", hInfo[houseid][hPice]);
    cache_get_value_name_int(0, "hLocked", hInfo[houseid][hLocked]);