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; }
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; } |