[FOTIS6]

Use something that:

Код:

public OnGameModeInit()
{
     for(new i = 0; i < MAX_HOUSES; i++)
     {
          new str[32];
          format(str, 32, "SELECT * FROM `houses` WHERE `houseID` = '%d'", i);
          mysql_function_query(g_iHandle, str, true, "House_Load", "i", i);
     }
     return 1;
}

Код:

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

    cache_get_data(rows, fields, g_iHandle); 

    if(rows)
    { 
        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); 

        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); 
    } 
    if(HouseData[i][houseExists])
	{ 
        format(str, sizeof(str), "SELECT * FROM `housestorage` WHERE `ID` = '%d'", HouseData[i][houseID]); 

        mysql_function_query(g_iHandle, str, true, "OnLoadStorage", "d", i); 

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

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