PHP код:
publics: HouseLoad()
{
new time = GetTickCount();
new r, f;
cache_get_data(r, f);
new idxx,string[114];
for(idxx = 0; idxx < r; idxx++)
{
HouseInfo[idxx][hID] = cache_get_field_content_int(idxx, "ID", MYSQL_ARG);
cache_get_field_content(idxx, "Name", HouseInfo[idxx][hName], MYSQL_ARG, 24);
HouseInfo[idxx][hInt] = cache_get_field_content_int(idxx, "Int", MYSQL_ARG);
HouseInfo[idxx][hPrice] = cache_get_field_content_int(idxx, "Price", MYSQL_ARG);
HouseInfo[idxx][hOwned] = cache_get_field_content_int(idxx, "Owned", MYSQL_ARG);
HouseInfo[idxx][hLevel] = cache_get_field_content_int(idxx, "Level", MYSQL_ARG);
HouseInfo[idxx][hEntrx] = cache_get_field_content_float(idxx, "Entrx", MYSQL_ARG);
HouseInfo[idxx][hEntry] = cache_get_field_content_float(idxx, "Entry", MYSQL_ARG);
HouseInfo[idxx][hEntrz] = cache_get_field_content_float(idxx, "Entrz", MYSQL_ARG);
HouseInfo[idxx][hExitx] = cache_get_field_content_float(idxx, "Exitx", MYSQL_ARG);
HouseInfo[idxx][hExity] = cache_get_field_content_float(idxx, "Exity", MYSQL_ARG);
HouseInfo[idxx][hExitz] = cache_get_field_content_float(idxx, "Exitz", MYSQL_ARG);
HouseInfo[idxx][hCarx] = cache_get_field_content_float(idxx, "Carx", MYSQL_ARG);
HouseInfo[idxx][hCary] = cache_get_field_content_float(idxx, "Cary", MYSQL_ARG);
HouseInfo[idxx][hCarz] = cache_get_field_content_float(idxx, "Carz", MYSQL_ARG);
HouseInfo[idxx][hCarfa] = cache_get_field_content_float(idxx, "Carfa", MYSQL_ARG);
HouseInfo[idxx][hCar] = cache_get_field_content_int(idxx, "Car", MYSQL_ARG);
HouseInfo[idxx][hLock] = cache_get_field_content_int(idxx, "Lock", MYSQL_ARG);
TOTALHOUSE++;
if(HouseInfo[idxx][hOwned] == 0)
{
format(string, sizeof(string), "Дом выставлен на продажу\n{ffffff}[ID: {90EE90}%d{ffffff}]\nЦена: {90EE90}%d${ffffff}\nУровень: {90EE90}%d",HouseInfo[idxx][hID],HouseInfo[idxx][hPrice],HouseInfo[idxx][hLevel]);
House3D[idxx] = Create3DTextLabel(string, -1,HouseInfo[idxx][hEntrx], HouseInfo[idxx][hEntry],HouseInfo[idxx][hEntrz], 10.0, 0 );
gHousePickup[idxx] = CreatePickup(1273, 23, HouseInfo[idxx][hEntrx], HouseInfo[idxx][hEntry],HouseInfo[idxx][hEntrz], -1);
gHouseVeh[idxx] = CreateVehicle(HouseInfo[idxx][hCar], HouseInfo[idxx][hCarx], HouseInfo[idxx][hCary], HouseInfo[idxx][hCarz],HouseInfo[idxx][hCarfa], 1, 1, 300);
}
else if (HouseInfo[idxx][hOwned] == 1)
{
format(string, sizeof(string), "[ID: {90EE90}%d{ffffff}]\nВладелец: {90EE90}%s{ffffff}\nУровень: {90EE90}%d",HouseInfo[idxx][hID],HouseInfo[idxx][hName],HouseInfo[idxx][hLevel]);
House3D[idxx] = Create3DTextLabel(string, -1,HouseInfo[idxx][hEntrx], HouseInfo[idxx][hEntry],HouseInfo[idxx][hEntrz], 10.0, 0 );
gHousePickup[idxx] = CreatePickup(1272, 23, HouseInfo[idxx][hEntrx], HouseInfo[idxx][hEntry],HouseInfo[idxx][hEntrz], -1);
gHouseVeh[idxx] = CreateVehicle(HouseInfo[idxx][hCar], HouseInfo[idxx][hCarx], HouseInfo[idxx][hCary], HouseInfo[idxx][hCarz],HouseInfo[idxx][hCarfa], 1, 1, 300);
}
}
printf("[Загружено домов]: <%i>. Времени затрачено: <%i мс>",TOTALHOUSE,GetTickCount()-time);
return true;
}