SA-MP Forums Archive
MYSQL ERRORS - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL ERRORS (/showthread.php?tid=636385)


MYSQL ERRORS - KissesMouth - 26.06.2017

Hello, my problem is system register and login.
Please, help me.

errors:

Код:
[Sun Jun 25 17:20:47 2017] -------------------------
[Sun Jun 25 17:20:47 2017]      Logging Started
[Sun Jun 25 17:20:47 2017] -------------------------
[Sun Jun 25 17:20:47 2017] Connected (0) to root @ localhost via TCP/IP.
[Sun Jun 25 17:20:47 2017] MySQL Server Version 5.5.5-10.1.21-MariaDB.
[Sun Jun 25 17:20:52 2017] Error (0): Failed to exeute query. 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 'FROM players WHERE nickname='root_.' LIMIT 1' at line 1.
[Sun Jun 25 17:20:52 2017] Error (0): Function: mysql_store_result called when no prior successful query executed. 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 'FROM players WHERE nickname='root_.' LIMIT 1' at line 1.
[Sun Jun 25 17:20:52 2017] Error (0): Function: mysql_store_result called when no result stored. 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 'FROM players WHERE nickname='root_.' LIMIT 1' at line 1.
INQUIRY:

Код:
	mysql_real_escape_string(PlayerData[playerid][nickname], esc_nickname);
	mysql_real_escape_string(password, esc_password);
	format(s_buf, sizeof(s_buf), "SELECT password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, '%s')))) AS valid FROM players WHERE nickname = '%s' LIMIT 1;", esc_password, esc_nickname);
	printf(s_buf);
	mysql_query(s_buf);
	mysql_store_result();
	new valid=mysql_fetch_int();
	mysql_free_result();