Почему не загружаются дома на сервере?

Kala4ik · 3 Июн 2019

Добрый вечер, создал систему создания домов на сервере, но они не загружаются из базы данных. Чет не дописал где-то((
Выручайте.

PHP:

new HOME;

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;
}

Почему не загружаются дома на сервере?

Kala4ik

Изучающий