Артемиано
Ученик
public OnHouseSave(houseid)
Вот проводится запрос.
И выдаётся в логах ошибка при покупке дома.
Код:
new query_string[386];
format(query_string, sizeof(query_string), "UPDATE `house` SET");
format(query_string, sizeof(query_string), "%s `Owned` = '%i' ,", query_string, HouseInfo[houseid][hOwned]);
format(query_string, sizeof(query_string), "%s `Owner` = '%s' ,", query_string, HouseInfo[houseid][hOwner]);
format(query_string, sizeof(query_string), "%s `Entrancex` = '%f' ,", query_string, HouseInfo[houseid][hEnterX]);
format(query_string, sizeof(query_string), "%s `Entrancey` = '%f' ,", query_string, HouseInfo[houseid][hEnterY]);
format(query_string, sizeof(query_string), "%s `Entrancez` = '%f' ,", query_string, HouseInfo[houseid][hEnterZ]);
format(query_string, sizeof(query_string), "%s `Exitx` = '%f' ,", query_string, HouseInfo[houseid][hExitX]);
format(query_string, sizeof(query_string), "%s `Exity` = '%f' ,", query_string, HouseInfo[houseid][hExitY]);
format(query_string, sizeof(query_string), "%s `Exitz` = '%f' ,", query_string, HouseInfo[houseid][hExitZ]);
format(query_string, sizeof(query_string), "%s `Value` = '%i' ,", query_string, HouseInfo[houseid][hValue]);
format(query_string, sizeof(query_string), "%s `Lock` = '%i' ,", query_string, HouseInfo[houseid][hLock]);
format(query_string, sizeof(query_string), "%s `Takings` = '%i' ,", query_string, HouseInfo[houseid][hTakings]);
format(query_string, sizeof(query_string), "%s `Int` = '%i' ,", query_string, HouseInfo[houseid][hInt]);
format(query_string, sizeof(query_string), "%s `Hel` = '%i' ,", query_string, HouseInfo[houseid][hHel]);
format(query_string, sizeof(query_string), "%s `Klass` = '%i' ,", query_string, HouseInfo[houseid][hKlass]);
format(query_string, sizeof(query_string), "%s WHERE `ID` = '%d' ", query_string, HouseInfo[houseid][hID]);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
return true;
И выдаётся в логах ошибка при покупке дома.
PHP:
[ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `ID` = '140'' at line 1
Последнее редактирование:
