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)
{
printf("Housename : %s",HouseInfo[i][HName]);
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);
}
