Михаил73
Ученик
Ребят, выручайте, уже около часу сижу не могу понять в чем косяк...
mysql_log
Из public OnPlayerConnect(playerid)
Из public OnDialogResponse
Создание акков CreateNewAccount
И сохранение
В чем же проблема?
mysql_log
Код:
[11:37:34] [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 '`password` = '123456' WHERE `player_name` = 'Mihail_Alexandrov'' at line 1
Код:
format(query_string, sizeof(query_string), "SELECT * FROM `accounts` WHERE `player_name` = '%s'", PlayerInfo[playerid][pName]);
mysql_function_query(mysql_connect_ID, query_string, true, "FindPlayerInTable","i", playerid);
Код:
format(query_string, sizeof(query_string), "SELECT * FROM `accounts` WHERE `player_name` = '%s'", PlayerInfo[playerid][pName]);
mysql_function_query(mysql_connect_ID, query_string, true, "UploadPlayerAccount","i", playerid);
Код:
format(query_string, sizeof(query_string), "INSERT INTO `accounts` (`player_name`, `password`) VALUES ('%s', '%s')", PlayerInfo[playerid][pName], password);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
Код:
format(query_string, sizeof(query_string), "%s `player_name` = '%s'", query_string, PlayerInfo[playerid][pName]);
format(query_string, sizeof(query_string), "%s `password` = '%s'", query_string, PlayerInfo[playerid][pPassword]);
Код:
format(query_string, sizeof(query_string), "%s WHERE `player_name` = '%s'", query_string, PlayerInfo[playerid][pName]);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
