[iKevin]

Hi all,

I've got a big problem with loading houses, tho, they don't load when I start the server. I posted the .inc to pastebin so you guys can help me out.

http://pastebin.com/zeWWsh9V

Please, do so.

[iKevin]

Bump.

[Unte99]

Use this https://sampwiki.blast.hk/wiki/MySQL/R33#cache_get_data at top of OnLoadOwnedHouses function to check if mysql is returning any rows.

[Ritzy2K]

Yep, Use cache_get_data to retrieve saved data, This is my house loading code. - You can take some idea. If you cannot fix it, ill write it for you.

Код:

forward House_Load();
public House_Load()
{
	static
	    rows,
	    fields,
		str[128];

	cache_get_data(rows, fields, g_iHandle);

	for (new i = 0; i < rows; i ++) if (i < MAX_HOUSES)
	{
		HouseData[i][houseExists] = true;
		HouseData[i][houseLights] = false;

		HouseData[i][houseID] = cache_get_field_int(i, "houseID");
		HouseData[i][houseOwner] = cache_get_field_int(i, "houseOwner");
		HouseData[i][housePrice] = cache_get_field_int(i, "housePrice");

		cache_get_field_content(i, "houseAddress", HouseData[i][houseAddress], g_iHandle, 32);

		HouseData[i][housePos][0] = cache_get_field_float(i, "housePosX");
		HouseData[i][housePos][1] = cache_get_field_float(i, "housePosY");
		HouseData[i][housePos][2] = cache_get_field_float(i, "housePosZ");
		HouseData[i][housePos][3] = cache_get_field_float(i, "housePosA");
		HouseData[i][houseInt][0] = cache_get_field_float(i, "houseIntX");
		HouseData[i][houseInt][1] = cache_get_field_float(i, "houseIntY");
		HouseData[i][houseInt][2] = cache_get_field_float(i, "houseIntZ");
		HouseData[i][houseInt][3] = cache_get_field_float(i, "houseIntA");
		HouseData[i][houseInterior] = cache_get_field_int(i, "houseInterior");
		HouseData[i][houseExterior] = cache_get_field_int(i, "houseExterior");
		HouseData[i][houseExteriorVW] = cache_get_field_int(i, "houseExteriorVW");
        HouseData[i][houseLocked] = cache_get_field_int(i, "houseLocked");
        HouseData[i][houseMoney] = cache_get_field_int(i, "houseMoney");

        for (new j = 0; j < 10; j ++)
		{
            format(str, 24, "houseWeapon%d", j + 1);
            HouseData[i][houseWeapons][j] = cache_get_field_int(i, str);

            format(str, 24, "houseAmmo%d", j + 1);
            HouseData[i][houseAmmo][j] = cache_get_field_int(i, str);
		}
		House_Refresh(i);
	}
	for (new i = 0; i < MAX_HOUSES; i ++) if (HouseData[i][houseExists]) {
		format(str, sizeof(str), "SELECT * FROM `housestorage` WHERE `ID` = '%d'", HouseData[i][houseID]);

		mysql_tquery(g_iHandle, str, "OnLoadStorage", "d", i);

		format(str, sizeof(str), "SELECT * FROM `furniture` WHERE `ID` = '%d'", HouseData[i][houseID]);

		mysql_tquery(g_iHandle, str, "OnLoadFurniture", "d", i);
	}
	return 1;
}

p.s sorry for late reply.

[iKevin]

Quote:

Originally Posted by [ND]xXZeusXx. Yep, Use cache_get_data to retrieve saved data, This is my house loading code. - You can take some idea. If you cannot fix it, ill write it for you. Код: forward House_Load(); public House_Load() { static rows, fields, str[128]; cache_get_data(rows, fields, g_iHandle); for (new i = 0; i < rows; i ++) if (i < MAX_HOUSES) { HouseData[i][houseExists] = true; HouseData[i][houseLights] = false; HouseData[i][houseID] = cache_get_field_int(i, "houseID"); HouseData[i][houseOwner] = cache_get_field_int(i, "houseOwner"); HouseData[i][housePrice] = cache_get_field_int(i, "housePrice"); cache_get_field_content(i, "houseAddress", HouseData[i][houseAddress], g_iHandle, 32); HouseData[i][housePos][0] = cache_get_field_float(i, "housePosX"); HouseData[i][housePos][1] = cache_get_field_float(i, "housePosY"); HouseData[i][housePos][2] = cache_get_field_float(i, "housePosZ"); HouseData[i][housePos][3] = cache_get_field_float(i, "housePosA"); HouseData[i][houseInt][0] = cache_get_field_float(i, "houseIntX"); HouseData[i][houseInt][1] = cache_get_field_float(i, "houseIntY"); HouseData[i][houseInt][2] = cache_get_field_float(i, "houseIntZ"); HouseData[i][houseInt][3] = cache_get_field_float(i, "houseIntA"); HouseData[i][houseInterior] = cache_get_field_int(i, "houseInterior"); HouseData[i][houseExterior] = cache_get_field_int(i, "houseExterior"); HouseData[i][houseExteriorVW] = cache_get_field_int(i, "houseExteriorVW"); HouseData[i][houseLocked] = cache_get_field_int(i, "houseLocked"); HouseData[i][houseMoney] = cache_get_field_int(i, "houseMoney"); for (new j = 0; j < 10; j ++) { format(str, 24, "houseWeapon%d", j + 1); HouseData[i][houseWeapons][j] = cache_get_field_int(i, str); format(str, 24, "houseAmmo%d", j + 1); HouseData[i][houseAmmo][j] = cache_get_field_int(i, str); } House_Refresh(i); } for (new i = 0; i < MAX_HOUSES; i ++) if (HouseData[i][houseExists]) { format(str, sizeof(str), "SELECT * FROM `housestorage` WHERE `ID` = '%d'", HouseData[i][houseID]); mysql_tquery(g_iHandle, str, "OnLoadStorage", "d", i); format(str, sizeof(str), "SELECT * FROM `furniture` WHERE `ID` = '%d'", HouseData[i][houseID]); mysql_tquery(g_iHandle, str, "OnLoadFurniture", "d", i); } return 1; } p.s sorry for late reply.

Thanks, I sent you a PM.