Добрый вечер, создал систему создания домов на сервере, но они не загружаются из базы данных. Чет не дописал где-то((
Выручайте.
PHP код:
mysql_tquery(database,"SELECT * FROM `houses`","LoadHouses","");
PHP код:
publics LoadHouses()
{
new rows,string[126];
cache_get_row_count(rows);
for(new i = 0; i < HOME; i++)
{
cache_get_value_name_int(i,"ID",HouseInfo[i][hID]);
cache_get_value_name_int(i,"Owner",HouseInfo[i][hOwner]);
cache_get_value_name_float(i,"Enter1",HouseInfo[i][hEnter][0]);
cache_get_value_name_float(i,"Enter2",HouseInfo[i][hEnter][1]);
cache_get_value_name_float(i,"Enter3",HouseInfo[i][hEnter][2]);
cache_get_value_name_float(i,"Exit1",HouseInfo[i][hEnter][0]);
cache_get_value_name_float(i,"Exit2",HouseInfo[i][hEnter][1]);
cache_get_value_name_float(i,"Exit3",HouseInfo[i][hEnter][2]);
if(HouseInfo[i][hOwned] == 0)
{
format(string,sizeof(string),"{00FF00}Дом №%d\n{33CCFF}Класс: {FFFF00}Нет\n{33CCFF}Уровень: {FFFF00}Нет\n{33CCFF}Цена: {FFFF00}$0",i);
HouseInfo[i][hMIcon] = CreateDynamicMapIcon(HouseInfo[i][hEnter][0],HouseInfo[i][hEnter][1],HouseInfo[i][hEnter][2],31,0xFFFFFFAA,0,-1,-1,400.0);
HouseInfo[i][hPickup][0] = CreateDynamicPickup(1273,23,HouseInfo[i][hEnter][0],HouseInfo[i][hEnter][1],HouseInfo[i][hEnter][2],-1);
HouseInfo[i][hPickup][1] = CreateDynamicCP(HouseInfo[i][hEnter][0],HouseInfo[i][hEnter][1],HouseInfo[i][hEnter][2],1.0,-1,-1,-1,3.0);
}
else if(HouseInfo[i][hOwned] == 1)
{
format(string,sizeof(string),"{00FF00}Дом №%d\n{33CCFF}Класс: {FFFF00}Нет\n{33CCFF}Владелец: {00FF00}Нет",i);
HouseInfo[i][hMIcon] = CreateDynamicMapIcon(HouseInfo[i][hEnter][0],HouseInfo[i][hEnter][1],HouseInfo[i][hEnter][2],32,0xFFFFFFAA,0,-1,-1,400.0);
HouseInfo[i][hPickup][0] = CreateDynamicPickup(19522,23,HouseInfo[i][hEnter][0],HouseInfo[i][hEnter][1],HouseInfo[i][hEnter][2],-1);
HouseInfo[i][hPickup][1] = CreateDynamicCP(HouseInfo[i][hEnter][0],HouseInfo[i][hEnter][1],HouseInfo[i][hEnter][2],1.0,-1,-1,-1,3.0);
}
HouseInfo[i][hLabel] = Create3DTextLabel(string,0xFFFFFFFF,HouseInfo[i][hEnter][0],HouseInfo[i][hEnter][1],HouseInfo[i][hEnter][2]+1,20.0,0,1);
}
printf("Загружено [%i] домов.",HOME);
return 1;
}
PHP код:
stock UpdateHouse(id)
{
new string[126];
DestroyDynamicPickup(HouseInfo[id][hPickup][0]);
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);
}
Update3DTextLabelText(HouseInfo[id][hLabel],0xFFFFFFFF,string);
}
PHP код:
CMD:addhouse(playerid,params[])
{
new Float:X,Float:Y,Float:Z;
new Float:EX,Float:EY,Float:EZ,int;
if(Player[playerid][pAdmin] != 10 && Player[playerid][pAdmin] != 11 || AdminDuty[playerid] == 0)return NoRights(playerid,!"[ОШИБКА] {FFFFFF}Недостаточно прав для использования команды.");
if(sscanf(params,"d",params[0]))return SendClientMessage(playerid,0x00BFFFAA,"[КОМАНДЫ] {FFFFFF}/addhouse [Класс].");
if(params[0] > 6 || params[0] < 1)return NoRights(playerid,!"[ОШИБКА] {FFFFFF}Доступное значение класса дома от 1 до 6.");
switch(params[0])
{
case 1:
{
EX = 243.7219;
EY = 304.7986;
EZ = 999.1484;
int = 1;
}
case 2:{}
case 3:{}
case 4:{}
case 5:{}
case 6:{}
case 7:
{
}
}
GetPlayerPos(playerid,X,Y,Z);
HouseInfo[HOME][hID] = HOME;
HouseInfo[HOME][hInt] = int;
HouseInfo[HOME][hEnter][0] = X;
HouseInfo[HOME][hEnter][1] = Y;
HouseInfo[HOME][hEnter][2] = Z;
HouseInfo[HOME][hExit][0] = EX;
HouseInfo[HOME][hExit][1] = EY;
HouseInfo[HOME][hExit][2] = EZ;
HouseInfo[HOME][hPickup] = CreateDynamicPickup(1273,23,HouseInfo[HOME][hEnter][0],HouseInfo[HOME][hEnter][1],HouseInfo[HOME][hEnter][2],-1);
new string[500];
format(string,sizeof(string),"INSERT INTO `houses` (`Interior` ,`Enter1`,`Enter2`,`Enter3`,`Exit1`,`Exit2`,`Exit3`)\
VALUES (%i,'%f','%f','%f','%f','%f','%f')",int,X,Y,Z,EX,EY,EZ);
mysql_query(database,string,false);
UpdateHouse(HOME);
HOME++;
return 1;
}