PDA

View Full Version : Problem


DeathKing
18/03/2014, 04:14 AM
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


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

CuervO
18/03/2014, 04:45 AM
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 "