[AphexCCFC]

Hello. I am using MySQL plugin R6-2.

I have tried setting the floats as varchars but still with no success.

Here is my code incase I changed it a little:

pawn Код:

stock LoadHouseInfo()
{
    new query[300], savingstring[20], string[256];
    for(new houseid=1; houseid<MAX_HOUSES; houseid++)
    {
        format(query, sizeof(query), "SELECT * FROM houses WHERE ID=%d", houseid);
        mysql_query(query);
        mysql_store_result();
        if(mysql_num_rows() == 1) continue;
        while(mysql_fetch_row_format(query,"|"))
        {
            mysql_fetch_field_row(savingstring, "Address"); HouseInfo[houseid][hAddress] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "Owner"); HouseInfo[houseid][hOwner] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "Owned"); HouseInfo[houseid][hOwned] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "Price"); HouseInfo[houseid][hPrice] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "X"); HouseInfo[houseid][hX] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "Y"); HouseInfo[houseid][hY] = strval(savingstring);
            mysql_fetch_field_row(savingstring, "Z"); HouseInfo[houseid][hZ] = strval(savingstring);
        }
        mysql_free_result();
        HouseInfo[houseid][hPickUp] = CreateDynamicPickup(1273, 1, HouseInfo[houseid][hX], HouseInfo[houseid][hY], HouseInfo[houseid][hZ], 0);
        format(string, sizeof(string), ""Green"ID: %d\nHouse Address: %s\nOwner: %s\nPrice: $%d", HouseInfo[houseid][hID], HouseInfo[houseid][hAddress], HouseInfo[houseid][hOwner], HouseInfo[houseid][hPrice]);
        HouseInfo[houseid][hText] = CreateDynamic3DTextLabel(string, -1, HouseInfo[houseid][hX], HouseInfo[houseid][hY], HouseInfo[houseid][hZ], 20.0);
        printf("All houses have been successfully loaded.");
        format(string, sizeof(string), "House ID: %d", HouseInfo[houseid][hID]);
        printf(string);
        houseid++;
        break;
    }
    return 1;
}

The issue isn't with the database because the information saves into the database, it just doesn't save into the variables. When I restart the gamemode the house doesn't recreate.