16.01.2020, 02:44
I need help, updating player passwords won't work
While this code will work perfect:
Database works, kills, money, deaths it all saves, but password and salt won't, i have no idea why
Help please
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; }
Code:
UpdatePlayerKills(killerid, killNumber) { if (killerid == INVALID_PLAYER_ID) return 0; if (Player[killerid][LoggedIn] == false) return 0; Player[killerid][Killovi] += killNumber; SetPlayerScore(killerid, GetPlayerScore(killerid) + killNumber); mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `Killovi` = %d WHERE `ID` = %d LIMIT 1", Player[killerid][Killovi], Player[killerid][ID]); mysql_tquery(g_SQL, query); return 1; }
Help please