[vassilis]

Loadhouses

PHP Code:

LoadHouses()
{
    new Cache:result,rows;
    new label[250];
    result = mysql_query(mysql, "SELECT * FROM `houses`");
    if((rows = cache_num_rows()))
    {
        for(new i=0; i < rows; i++)
        {
            HouseInfo[i][XEnt] = cache_get_field_content_float(i, "XEnt"); //we're getting a field 4 from row 0. And since it's an integer, we use cache_get_row_int
            HouseInfo[i][YEnt] = cache_get_field_content_float(i, "YEnt"); //Above
            HouseInfo[i][ZEnt] = cache_get_field_content_float(i, "ZEnt");//Above
            HouseInfo[i][XExit] = cache_get_field_content_float(i, "XExit");//Above. Since player's position is a float, we use cache_get_field_content_float
            HouseInfo[i][YExit] = cache_get_field_content_float(i, "YExit");//Above
            HouseInfo[i][ZExit] = cache_get_field_content_float(i, "ZExit");//Above
            HouseInfo[i][HVirtualWorld] = cache_get_field_content_int(i, "HVirtualWorld");
            HouseInfo[i][HInterior] = cache_get_field_content_int(i, "HInterior");
            HouseInfo[i][HPrice] = cache_get_field_content_int(i, "HPrice");
            HouseInfo[i][HOwnerID] = cache_get_field_content_int(0, "HOwnerID");
            HouseInfo[i][HOwned] = cache_get_field_content_int(i, "HOwned");
            HouseInfo[i][HLocked] = cache_get_field_content_int(i, "HLocked");
            cache_get_field_content(i, "HName", HouseInfo[i][HName], 30);
            if(HouseInfo[i][HOwned] == 1)
        {
                format(label,sizeof(label),""COL_GREEN"HouseName"COL_WHITE":%s\n"COL_GREEN"",HouseInfo[i][HName]);
                HouseInfo[i][H3D] = CreateDynamic3DTextLabel(label, COLOR_YELLOW, HouseInfo[i][XEnt],  HouseInfo[i][YEnt], HouseInfo[i][ZEnt], 40.0);
        }
        
        else if(HouseInfo[i][HOwned] == 0)
        {
            format(label,sizeof(label),""COL_GREEN"HouseName"COL_WHITE": No Owner\n"COL_GREEN"Price"COL_WHITE": %d",HouseInfo[i][HPrice]);
            HouseInfo[i][H3D] = CreateDynamic3DTextLabel(label, COLOR_YELLOW, HouseInfo[i][XEnt],  HouseInfo[i][YEnt], HouseInfo[i][ZEnt], 40.0);
        }
        }
        printf("Successfully Loaded All Houses! ( %d )",rows);
    }
    else
    {
        print("There are no houses to load!");
    }
        cache_delete(result);
} 


It loads correctly anything else but on
screen it has Housename as blank
it says on 3d text
"Housename: "
mysql_log

pawn Code:

[14:31:04] [DEBUG] cache_get_field_content - row: 1, field_name: "HName", connection: 30, max_len: 1
[14:31:04] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "HName", data: "test"