Problem - Printable Version

Problem - 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: Problem (/showthread.php?tid=501418)

Problem - DeathKing - 18.03.2014

Код HTML:

			new New[130];
			RandomString(New, sizeof(New));
			strcat(New, inputtext);
			WP_Hash(PlayerInfo[playerid][pPass], sizeof(New), New);

			new query[2000];
			mysql_format(SQL, query, 200, "INSERT INTO `players` (`UserName`, `PassWord`, `Salt`) VALUES (%e, %s, %s)", GetPlayerNameEx(playerid), PlayerInfo[playerid][pPass], New);
			mysql_pquery(SQL, query, "CreateAccount", "d", playerid);

i get this

PHP код:



connection: 1, len: 200, format: "INSERT INTO `players` (`UserName`, `PassWord`, `Salt`) VALUES (%e, %s, %s)"


destination size is too small


connection: 1, query: "INSERT INTO `players` (`UserName`, `PassWord`, `Salt`) VALUES (R", callback: "CreateAccount", format: "d"


starting query execution


(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 '' at line 1

Re: Problem - CuervO - 18.03.2014

Код:

mysql_format(SQL, query, 200, "INSERT INTO `players` (`UserName`, `PassWord`, `Salt`) VALUES (%e, %s, %s)", GetPlayerNameEx(playerid), PlayerInfo[playerid][pPass], New);

"destination size is too small "