[jlalt]

Your query text is 60 char and your password is 65 char thats 125 while you mysql query size is 100, increase this value and retry the code I posted.

PHP код:

CMD:changepass(playerid,params[])   
{  
    new Query[200], pass[200];  
    if(sscanf(params, "s[200]", pass)) return Usage(playerid, "/changepass [password]");  
    if(strlen(pass) < 3 || strlen(pass) > 12) return Error(playerid, "Incorrect Password length");  
    SHA256_PassHash(pass, pInfo[playerid][Salt], pInfo[playerid][Password], 65);  
    //pInfo[playerid][Password] = pass;  
    mysql_format(Database, Query, sizeof(Query), "UPDATE `users` SET `Password` = '%e'  WHERE `pID` =%d LIMIT 1", pInfo[playerid][Password], pInfo[playerid][pID]);  
    mysql_tquery(Database, Query,"","");  
    format2(playerid, COLOR_LIGHTGREEN, "Your password has been successfully changed to (%s)", str);  
    return 1;  
}