Доброй ночи пользователи p-p.
Пишу для своего мода динамическую сис домов, вроде все готово, но есть 1 проблемка, создая дом всё появляется, когда рестарчу сервер
дома этого нету.
В логах mysql появляется это:
PHP код:
[02:26:45] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `hID` = '0'' at line 1
[02:26:45] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `hID` = '1'' at line 1
[02:26:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `hID` = '0'' at line 1
[02:26:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `hID` = '1'' at line 1
Выявил что это после срабатывания стока: SaveHouse.
Вот вам создание дома:
PHP код:
case 6:
{
if(response)
{
new Float:x[3], str[32];
GetPlayerPos(playerid, x[0], x[1], x[2]);
GetPVarString(playerid, "h_name", str, 32);
TotalHouse++;
HouseInfo[TotalHouse][hID] = TotalHouse;
HouseInfo[TotalHouse][hX] = x[0];
HouseInfo[TotalHouse][hY] = x[1];
HouseInfo[TotalHouse][hZ] = x[2];
HouseInfo[TotalHouse][hPrice] = GetPVarInt(playerid, "h_price");
HouseInfo[TotalHouse][hInterior] = GetPVarInt(playerid, "h_int");
HouseInfo[TotalHouse][hVirtWorld] = TotalHouse;
strmid(HouseInfo[TotalHouse][hAddress], str, 0, 32, 32);
strmid(HouseInfo[TotalHouse][hOwner], "None", 0, 5, 5);
SaveHouse();
HouseInfo[TotalHouse][hVirtWorld] = CreatePickup(19470,23,x[0],x[1],x[2],0);
format(LString, 128, "Продаётся\nАндрес: %s\nЦена: $%d", HouseInfo[TotalHouse][hAddress], HouseInfo[TotalHouse][hPrice]);
HouseInfo[TotalHouse][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 код:
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, "", "");
}
}