PHP код:
enum Hinfo
{
hID,
hOwned,
hOwner[MAX_PLAYER_NAME],
hInt,
Float:hEnter[3],
Float:hExit[3],
hMIcon,
hPickup[2],
Text3D:hLabel,
}
new HouseInfo[MAX_HOUSES][Hinfo];
new HOME;
mysql_tquery(database,"SELECT * FROM houses ORDER BY houses.id ASC","LoadHouses","");
publics LoadHouses()
{
new rows,string[126];
cache_get_row_count(rows);
if(rows)
{
for(new id = 1; id <= rows; id++)
{
cache_get_value_name_int(id-1,"ID",HouseInfo[id][hID]);
cache_get_value_name_int(id-1,"Owned",HouseInfo[id][hOwned]);
cache_get_value_name(id-1,"Owner",HouseInfo[id][hOwner], MAX_PLAYER_NAME);
cache_get_value_name_float(id-1,"Enter1",HouseInfo[id][hEnter][0]);
cache_get_value_name_float(id-1,"Enter2",HouseInfo[id][hEnter][1]);
cache_get_value_name_float(id-1,"Enter3",HouseInfo[id][hEnter][2]);
cache_get_value_name_float(id-1,"Exit1",HouseInfo[id][hEnter][0]);
cache_get_value_name_float(id-1,"Exit2",HouseInfo[id][hEnter][1]);
cache_get_value_name_float(id-1,"Exit3",HouseInfo[id][hEnter][2]);
if(HouseInfo[id][hOwned] == 0)
{
format(string,sizeof(string),"{00FF00}Дом №%d\n{33CCFF}Класс: {FFFF00}Нет\n{33CCFF}Уровень: {FFFF00}Нет\n{33CCFF}Цена: {FFFF00}$0",id);
HouseInfo[id][hMIcon] = CreateDynamicMapIcon(HouseInfo[id][hEnter][0],HouseInfo[id][hEnter][1],HouseInfo[id][hEnter][2],31,0xFFFFFFAA,0,-1,-1,400.0);
HouseInfo[id][hPickup][0] = CreateDynamicPickup(1273,23,HouseInfo[id][hEnter][0],HouseInfo[id][hEnter][1],HouseInfo[id][hEnter][2],-1);
HouseInfo[id][hPickup][1] = CreateDynamicCP(HouseInfo[id][hEnter][0],HouseInfo[id][hEnter][1],HouseInfo[id][hEnter][2],1.0,-1,-1,-1,3.0);
}
else if(HouseInfo[id][hOwned] == 1)
{
format(string,sizeof(string),"{00FF00}Дом №%d\n{33CCFF}Класс: {FFFF00}Нет\n{33CCFF}Владелец: {00FF00}Нет",id);
HouseInfo[id][hMIcon] = CreateDynamicMapIcon(HouseInfo[id][hEnter][0],HouseInfo[id][hEnter][1],HouseInfo[id][hEnter][2],32,0xFFFFFFAA,0,-1,-1,400.0);
HouseInfo[id][hPickup][0] = CreateDynamicPickup(19522,23,HouseInfo[id][hEnter][0],HouseInfo[id][hEnter][1],HouseInfo[id][hEnter][2],-1);
HouseInfo[id][hPickup][1] = CreateDynamicCP(HouseInfo[id][hEnter][0],HouseInfo[id][hEnter][1],HouseInfo[id][hEnter][2],1.0,-1,-1,-1,3.0);
}
HouseInfo[id][hLabel] = Create3DTextLabel(string,0xFFFFFFFF,HouseInfo[id][hEnter][0],HouseInfo[id][hEnter][1],HouseInfo[id][hEnter][2]+1,20.0,0,1);
HOME++;
}
}
printf("Загружено [%i] домов.",HOME);
return 1;
}