SA-MP Forums Archive
Changepass not working - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Changepass not working (/showthread.php?tid=595585)


Changepass not working - MBilal - 04.12.2015

Код:
CMD:changepassword(playerid,params[])
{
	if(pInfo[playerid][Logged] == 1)
	{
		new pass[25],query[300] ;
		if(sscanf(params, "s[25]", pass)) return SCM(playerid, yellow, "SERVER : /Changepassword <New Password>");
		if(strlen(pass) < 3 || strlen(pass) > 20) return SCM(playerid,red,"Error: Password length must be between 3 - 20 chracters!");
        WP_Hash(pInfo[playerid][Password], 129, pass);
		mysql_format(mysql, query, sizeof(query), "UPDATE `Players` SET `Password` = '%s' WHERE `Username` = '%e'", pInfo[playerid][Password], GetName(playerid));
		mysql_tquery(mysql, query, "", "");
        format(Jstring, sizeof(Jstring),"Your password has been successfully changed to '%s'",pass);
		return SCM(playerid,yellow,Jstring);
	} 
return 1;
}
new pass is not saving in mysql ? when some budy change pass new pass is not saving in mysql why?

Re: Changepass not working - jlalt - 05.12.2015

Try this [ check if work ] :
PHP код:
CMD:changepassword(playerid,params[])
{
    if(pInfo[playerid][Logged] == 1)
    {
        new pass[25],query[435] ;
        if(sscanf(params, "s[25]", pass)) return SCM(playerid, yellow, "SERVER : /Changepassword <New Password>");
        if(strlen(pass) < 3 || strlen(pass) > 20) return SCM(playerid,red,"Error: Password length must be between 3 - 20 chracters!");
        WP_Hash(pInfo[playerid][Password], 129, pass);
        mysql_format(mysql, query, sizeof(query), "UPDATE `Players` SET `Password` = '%s' WHERE `Username` = '%e'", pInfo[playerid][Password], GetName(playerid));
        mysql_tquery(mysql, query, "", "");
        format(Jstring, sizeof(Jstring),"Your password has been successfully changed to '%s'",pass);
        return SCM(playerid,yellow,Jstring);
    } 
return 1;
}