Password Fuzzie Account

[Finch]

Well i am using Fuzzie Account system but i am facing problem on setpassword command when i set password it say on console password does not exist and password also didnt change this is command

Code Select Expand

else if ( cmd == "setpassword" )
{
           if( stats[ player.ID ].Logged == false ) MessagePlayer( "Error - You don't have Login acess.", player);
   else if ( stats[ player.ID ].Level < 7 ) MessagePlayer( "Error - You don't have access to it.", player);
else if ( !text ) qPrivMessage( "Syntax, " + cmd + " [Nick/ID] [Password]",player );
else {
local plr = GetPlayer( GetTok( text, " ", 1 ) );
if ( !plr ) qPrivMessage( "Error: Invalid Player.",player );
else {
local newpass = GetTok( text, " ", 2);
if ( newpass == null ) qPrivMessage("Enter A Valid Password.",player );
else {
qPrivMessage("Admin " + player + " Set Your Password To: " + newpass + ".", plr);
qPrivMessage(" Changed Password Of " + plr.Name + " To: " + newpass + ".", player);
QuerySQL(sqliteDB,"UPDATE Accounts SET Password='" + SHA256( password ) + "' WHERE Name='" + plr.Name + "'");
}
}
}
}


[Thijn]

You copy pasted the query, but you have to change "password" in the SHA256 function to newpass.

[Finch]

can u give there example?

[EK.IceFlake]

can u give there example?

Change

Code Select Expand

QuerySQL(sqliteDB,"UPDATE Accounts SET Password='" + SHA256( password ) + "' WHERE Name='" + plr.Name + "'");to

Code Select Expand

QuerySQL(sqliteDB,"UPDATE Accounts SET Password='" + SHA256( newpass ) + "' WHERE Name='" + plr.Name + "'");And please, next time FREAKING TRY TO FIND THE ERROR INSTEAD OF POSTING A EXABILLION STUPID ERROR TOPICS HERE!!!
Edit: I noticed this is my 123rd post