08.09.2013, 09:28
Change from
To
As Misiur said the query string is too small to fully store the string, this results in an uncomplete query and hence the error.
So change
To
128 is an arbitary number. You might want to change it depending on what you are trying to store. Are your passwords encrypted? If so you probably need a higher number.
pawn Код:
format(Query,sizeof(Query),"INSERT INTO `users` (pName,pPass,pAdmin,pCash) VALUES ('%s','%s,'%i','%i')",pName,EscapedText,PInfo[playerid][pAdmin],PInfo[playerid][pMoney]);
pawn Код:
format(Query, sizeof(Query), "INSERT INTO `users` (`pName`, `pPass`, `pAdmin`, `pCash`) VALUES ('%s', '%s', %i, %i)", pName, EscapedText, PInfo[playerid][pAdmin], PInfo[playerid][pMoney]);
So change
pawn Код:
new EscapedText[60],Query[80],pName[MAX_PLAYER_NAME];
pawn Код:
new EscapedText[60],Query[128],pName[MAX_PLAYER_NAME];