16.01.2020, 05:59
Quote:
I need help, updating player passwords won't work
Code:
UpdatePlayerPass(playerid, newpass[]) { for(new i = 0; i < 16; i++) Player[playerid][Salt][i] = random(94) + 33; SHA256_PassHash(newpass, Player[playerid][Salt], Player[playerid][Password], 64); mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `Password` = %s, 'Salt' = %e WHERE `ID` = %d LIMIT 1", Player[playerid][Password],Player[playerid][Salt], Player[playerid][ID]); mysql_tquery(g_SQL, query); return 1; } |
By the way, you do not need LIMIT clause if `ID` is PRIMARY KEY (which should be).