Не слхраняется созданный дом в бд.
Добрый день не сохраняется созданный дом в бд, пересмотрел весь код не могу понять из за чего.
PHP код:
enum hInfo
{
hID,
hAddress[64],//Адрес
hOwner[MAX_PLAYER_NAME],//Владелец
hPrice,//Цена
hLock,//Двери(Открыты, закрыты)
hInterior,//Интерьер
hVirtWorld,//Виртуальный мир
Text3D:hText,//3DText
Float:hX,//X Координата
Float:hY,//Y Координата
Float:hZ//Z Координата
};
new HouseInfo[MAX_HOUSES][hInfo];
new TotalHouse = 0;
PHP код:
if(strcmp("/addhome", cmdtext, true, 13) == 0)
{
return ShowPlayerDialog(playerid,3,DIALOG_STYLE_INPUT,"Адрес","Введите Адрес:","Далее","Отмена");
}
PHP код:
case 3:
{
if(response)
{
if(!strlen(inputtext)) return ShowPlayerDialog(playerid, 3, DIALOG_STYLE_INPUT, "Адрес", "Введите Адрес:", "Далее","Отмена");
SetPVarString(playerid, "h_name", inputtext);
ShowPlayerDialog(playerid, 4, DIALOG_STYLE_INPUT, "Стоимость", "Введите стоимость Дома:", "Далее", "Отмена");
}
}
case 4:
{
if(response)
{
if(!strlen(inputtext)) return ShowPlayerDialog(playerid, 4, DIALOG_STYLE_INPUT, "Стоимость", "Введите стоимость Дома:","Далее","Назад");
SetPVarInt(playerid, "h_price", strval(inputtext));
LString = "";
for(new i; i < sizeof(hInts); i++)
{
strcat(LString, hInts[i][hiName]);
strcat(LString, "\n");
}
ShowPlayerDialog(playerid, 5, DIALOG_STYLE_LIST, "Интерьер", LString, "Далее", "Назад");
}
else DeletePVar(playerid, "h_name"), ShowPlayerDialog(playerid, 1000, DIALOG_STYLE_INPUT, "Адрес","Введите Адрес:", "Далее", "Отмена");
}
case 5:
{
if(response)
{
SetPVarInt(playerid, "h_int", listitem);
ShowPlayerDialog(playerid, 6, DIALOG_STYLE_MSGBOX, "Подтверждение", "Вы действительно желаете создать Дом?", "V", "X");
}
else DeletePVar(playerid, "h_price"), ShowPlayerDialog(playerid, 4, DIALOG_STYLE_INPUT, "Стоимость", "Введите стоимость Дома:", "Далее", "Назад");
}
case 6:
{
if(response)
{
new Float:x[3], str[32];
GetPlayerPos(playerid, x[0], x[1], x[2]);
GetPVarString(playerid, "h_name", str, 32);
for(new i = 0; i <= TotalHouse; i++)
{
TotalHouse++;
HouseInfo[i][hID] = TotalHouse;
HouseInfo[i][hX] = x[0];
HouseInfo[i][hY] = x[1];
HouseInfo[i][hZ] = x[2];
HouseInfo[i][hPrice] = GetPVarInt(playerid, "h_price");
HouseInfo[i][hInterior] = GetPVarInt(playerid, "h_int");
HouseInfo[i][hVirtWorld] = TotalHouse;
strmid(HouseInfo[i][hAddress], str, 0, 32, 32);
strmid(HouseInfo[i][hOwner], "None", 0, 5, 5);
SaveHouse();
HouseInfo[i][hVirtWorld] = CreatePickup(19470,23,x[0],x[1],x[2],0);
format(LString, 128, "Продаётся\nАндрес: %s\nЦена: $%d", HouseInfo[i][hAddress], HouseInfo[i][hPrice]);
HouseInfo[i][hText] = Create3DTextLabel(LString, 0xFFFFFFFF, x[0], x[1], x[2] + 0.5, 10.0, 0, 0);
GameTextForPlayer(playerid, "~w~House ~g~Created",100,1);
DeletePVar(playerid, "h_price"), DeletePVar(playerid, "h_name"), DeletePVar(playerid, "h_int");
}
}
else DeletePVar(playerid,"h_price"), DeletePVar(playerid, "h_name"), DeletePVar(playerid, "h_int");
}
PHP код:
public LoadHouse()
{
new time = GetTickCount();
new temp[64],rows,fields;
cache_get_data(rows, fields, mysql_variable);
if(rows)
{
for(new idx = 1; idx <= rows; idx++)
{
cache_get_field_content(idx-1,"hID",temp,mysql_variable), HouseInfo[idx][hID] = strval(temp);
cache_get_field_content(idx-1,"hAddress",temp,mysql_variable), HouseInfo[idx][hAddress] = strval(temp);
cache_get_field_content(idx-1,"hX",temp,mysql_variable), HouseInfo[idx][hX] = floatstr(temp);
cache_get_field_content(idx-1,"hY",temp,mysql_variable), HouseInfo[idx][hY] = floatstr(temp);
cache_get_field_content(idx-1,"hZ",temp,mysql_variable), HouseInfo[idx][hZ] = floatstr(temp);
cache_get_field_content(idx-1,"hInterior",temp,mysql_variable), HouseInfo[idx][hInterior] = strval(temp);
cache_get_field_content(idx-1,"hOwner",HouseInfo[idx][hOwner],mysql_variable,24);
cache_get_field_content(idx-1,"hVirtWorld",temp,mysql_variable), HouseInfo[idx][hVirtWorld] = strval(temp);
cache_get_field_content(idx-1,"hPrice",temp,mysql_variable), HouseInfo[idx][hPrice] = strval(temp);
cache_get_field_content(idx-1,"hLock",temp,mysql_variable), HouseInfo[idx][hLock] = strval(temp);
if(!strcmp(HouseInfo[idx][hOwner],"None",true))
{
HouseInfo[idx][hVirtWorld] = CreatePickup(19470, 23, HouseInfo[idx][hX], HouseInfo[idx][hY], HouseInfo[idx][hZ], 0);
format(LString,128,"Продаётся\nАдрес: %s\nЦена: $%d", HouseInfo[idx][hAddress], HouseInfo[idx][hPrice]);
HouseInfo[idx][hText] = Create3DTextLabel(LString, 0xFFFFFFFF, HouseInfo[idx][hX], HouseInfo[idx][hY], HouseInfo[idx][hZ] + 0.5, 10.0, 0, 0);
}
else
{
HouseInfo[idx][hVirtWorld] = CreatePickup(1273, 23, HouseInfo[idx][hX], HouseInfo[idx][hY], HouseInfo[idx][hZ],0);
format(LString, 128, "Дом\nАдрес: %s\nВладелец: %s", HouseInfo[idx][hAddress],HouseInfo[idx][hOwner]);
HouseInfo[idx][hText] = Create3DTextLabel(LString, 0xFFFFFFFF, HouseInfo[idx][hX], HouseInfo[idx][hY], HouseInfo[idx][hZ] +0.5, 10.0, 0, 0);
}
//CreatePickup(1318, 23, HouseInfo[idx][hExitx], HouseInfo[idx][hExity], HouseInfo[idx][hExitz], idx+50);
TotalHouse++;
}
}
printf("[Загружено домов]: <%d>. Времени затрачено: <%d мс>", TotalHouse, GetTickCount()-time);
return true;
}
stock UpdateHouse(b)
{
DestroyPickup(HouseInfo[b][hVirtWorld]);
if(!strcmp(HouseInfo[b][hOwner],"None",true))
{
HouseInfo[b][hVirtWorld] = CreatePickup(19470, 23, HouseInfo[b][hX], HouseInfo[b][hY], HouseInfo[b][hZ],0);
format(LString, 128, "Продаётся\nАдрес: %s\nЦена: $%d", HouseInfo[b][hAddress], HouseInfo[b][hPrice]);
Update3DTextLabelText(HouseInfo[b][hText],0xFFFFFFFF,LString);
}
else
{
HouseInfo[b][hVirtWorld] = CreatePickup(1273, 23, HouseInfo[b][hX], HouseInfo[b][hY], HouseInfo[b][hZ], 0);
format(LString,128,"Дом\nАдресес: %s\nВладелец: %s",HouseInfo[b][hAddress],HouseInfo[b][hOwner]);
Update3DTextLabelText(HouseInfo[b][hText],0xFFFFFFFF,LString);
}
return true;
}
stock SaveHouse()
{
new query[600];
new temp[128];
for(new i = 0; i <= TotalHouse; i++)
{
mysql_format(mysql_variable, query, sizeof(query), "UPDATE `house` SET ");
format(temp,sizeof(temp),"`hAddress` = '%s',",HouseInfo[i][hAddress]);strcat(query,temp,sizeof(query));
format(temp,sizeof(temp),"`hOwner` = '%s',",HouseInfo[i][hOwner]);strcat(query,temp,sizeof(query));
format(temp,sizeof(temp),"`hX` = '%f',",HouseInfo[i][hX]);strcat(query,temp,sizeof(query));
format(temp,sizeof(temp),"`hY` = '%f',",HouseInfo[i][hY]);strcat(query,temp,sizeof(query));
format(temp,sizeof(temp),"`hZ` = '%f',",HouseInfo[i][hZ]);strcat(query,temp,sizeof(query));
format(temp,sizeof(temp),"`hInterior` = '%d',",HouseInfo[i][hInterior]);strcat(query,temp,sizeof(query));
format(temp,sizeof(temp),"`hVirtWorld` = '%d',",HouseInfo[i][hVirtWorld]);strcat(query,temp,sizeof(query));
format(temp,sizeof(temp),"`hPrice` = '%d',",HouseInfo[i][hPrice]);strcat(query,temp,sizeof(query));
format(temp,sizeof(temp),"`hLock` = '%d'",HouseInfo[i][hLock]);strcat(query,temp,sizeof(query));
format(temp,sizeof(temp),"WHERE `hID` = '%i'",HouseInfo[i][hID]);strcat(query,temp,sizeof(query));
mysql_function_query(mysql_variable, query, true, "", "");
}
}