[alishvasis]

Hi Alls
I'v Wrote MySql ChangePassword Script But Not True Change Password...
Anyone Can Fix It Please ? TnX

PHP код:

CMD:changepass(playerid,params[])
{
    new oldpass[128];
    new query[313], name[24], WPhash[145], escape[145];
    if(sscanf(params, "s[128]", WPhash)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changepass (New Password)");
    {
        GetPlayerName(playerid,name,24);
        mysql_real_escape_string(oldpass, escape);
        WP_Hash(WPhash, sizeof(WPhash), escape);
        mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `password` = '%s' WHERE `name` = '%s'", WPhash, name);
         mysql_tquery(koneksi, query);
        SendClientMessage(playerid, COLOR_GREEN, "Password Changed!");
    }
    return 1;
} 


[F1N4L]

Try

Код:

CMD:changepass(playerid,params[]) 
{ 
    new oldpass[128]; 
    new query[313], name[24], WPhash[145], escape[145]; 
    if(sscanf(params, "s[128]", WPhash)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changepass (New Password)"); 
    { 
        GetPlayerName(playerid,name,24); 
        mysql_real_escape_string(oldpass, escape); 
        WP_Hash(WPhash, sizeof(WPhash), escape); 
        mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `password` = '%s' WHERE `name` = '%s'", WPhash, name); 
        mysql_query(koneksi, query, false); 
        SendClientMessage(playerid, COLOR_GREEN, "Password Changed!"); 
    } 
    return 1; 
}

[alishvasis]

Quote:

Originally Posted by F1N4L Try Код: CMD:changepass(playerid,params[]) { new oldpass[128]; new query[313], name[24], WPhash[145], escape[145]; if(sscanf(params, "s[128]", WPhash)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changepass (New Password)"); { GetPlayerName(playerid,name,24); mysql_real_escape_string(oldpass, escape); WP_Hash(WPhash, sizeof(WPhash), escape); mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `password` = '%s' WHERE `name` = '%s'", WPhash, name); mysql_query(koneksi, query, false); SendClientMessage(playerid, COLOR_GREEN, "Password Changed!"); } return 1; }

not Work And Not Change True

[F1N4L]

Quote:

Originally Posted by alishvasis not Work And Not Change True

The variable oldpass and escape aren't use!
I remove mysql escape funcion...

Try:

Код:

CMD:changepass(playerid,params[]) 
{ 
    new query[313], name[24], WPhash[145];
    if(isnull(params)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changepass (New Password)"); 
    
	GetPlayerName(playerid,name,24); 
	WP_Hash(WPhash, sizeof(WPhash), params); 
	mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `password` = '%s' WHERE `name` = '%s'", WPhash, name); 
	mysql_query(koneksi, query, false); 
	SendClientMessage(playerid, COLOR_GREEN, "Password Changed!"); 
    
    return 1; 
}

[alishvasis]

Quote:

Originally Posted by F1N4L The variable oldpass and escape aren't use! I remove mysql escape funcion... Try: Код: CMD:changepass(playerid,params[]) { new query[313], name[24], WPhash[145]; if(isnull(params)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changepass (New Password)"); GetPlayerName(playerid,name,24); WP_Hash(WPhash, sizeof(WPhash), params); mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `password` = '%s' WHERE `name` = '%s'", WPhash, name); mysql_query(koneksi, query, false); SendClientMessage(playerid, COLOR_GREEN, "Password Changed!"); return 1; }

Thanks Its Worked ! + Rep

Now Anyone Can Make High Quality Changepass ?

/ChangePass <oldpassword> <newPassword> >>> Anyone Can Make This ?

[F1N4L]

Try...

Код:

CMD:changepass(playerid,params[]) 
{ 
    new query[313], name[24], WPhash[145], Cache: Result, GetOldPass[145], OldPass[60], NewPass[60];
	
    if(sscanf(params, "s[60]s[60]", OldPass, NewPass)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changepass (Old Password) (New Password)"); 
    
	GetPlayerName(playerid, name,24);  
	
	mysql_format(koneksi, query, sizeof(query), "SELECT `password` FROM `player` WHERE `name` = '%s'", name); 
	
	Result = mysql_query(koneksi, query); 
	
	if(cache_num_rows()) cache_get_field_content(0, "password`", GetOldPass);
	
	cache_delete(Result);
	
	WP_Hash(WPhash, sizeof(WPhash), OldPass);
	
	if(strcmp(WPhash, GetOldPass, false) == 0)
	{	
		WP_Hash(WPhash, sizeof(WPhash), NewPass); 
		
		mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `password` = '%s' WHERE `name` = '%s'", WPhash, name);
		
		mysql_query(koneksi, query, false); 
		
		SendClientMessage(playerid, COLOR_GREEN, "Password Changed!"); 
	}
	else SendClientMessage(playerid, COLOR_GREEN, "Old Password is Wrong!"); 
    
    return 1; 
}

[alishvasis]

Quote:

Originally Posted by F1N4L Try... Код: CMD:changepass(playerid,params[]) { new query[313], name[24], WPhash[145], Cache: Result, GetOldPass[145], OldPass[60], NewPass[60]; if(sscanf(params, "s[60]s[60]", OldPass, NewPass)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changepass (Old Password) (New Password)"); GetPlayerName(playerid, name,24); mysql_format(koneksi, query, sizeof(query), "SELECT `password` FROM `player` WHERE `name` = '%s'", name); Result = mysql_query(koneksi, query); if(cache_num_rows()) cache_get_field_content(0, "password`", GetOldPass); cache_delete(Result); WP_Hash(WPhash, sizeof(WPhash), OldPass); if(strcmp(WPhash, GetOldPass, false) == 0) { WP_Hash(WPhash, sizeof(WPhash), NewPass); mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `password` = '%s' WHERE `name` = '%s'", WPhash, name); mysql_query(koneksi, query, false); SendClientMessage(playerid, COLOR_GREEN, "Password Changed!"); } else SendClientMessage(playerid, COLOR_GREEN, "Old Password is Wrong!"); return 1; }

Not Work I'v Put True Old Password But Said Old Password is Wrong
And Get Error In Mysql

Код HTML:

16:28:09	CMySQLResult::GetRowDataByName	WARNING	field not found ("password`")

But I Have This field!

[F1N4L]

Quote:

Originally Posted by alishvasis Not Work I'v Put True Old Password But Said Old Password is Wrong

The old password is hashed?

[alishvasis]

Quote:

Originally Posted by F1N4L The old password is hashed?

Код HTML:

16:28:09	CMySQLResult::GetRowDataByName	WARNING	field not found ("password`")

But I Have This field!

[F1N4L]

Quote:

Originally Posted by alishvasis Код HTML: 16:28:09 CMySQLResult::GetRowDataByName WARNING field not found ("password`") But I Have This field!

The error:

Код:

if(cache_num_rows()) cache_get_field_content(0, "password`", GetOldPass);

Sorry, try now:

Код:

CMD:changepass(playerid,params[]) 
{ 
    new query[313], name[24], WPhash[145], Cache: Result, GetOldPass[145], OldPass[60], NewPass[60];
	
    if(sscanf(params, "s[60]s[60]", OldPass, NewPass)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changepass (Old Password) (New Password)"); 
    
	GetPlayerName(playerid, name,24);  
	
	mysql_format(koneksi, query, sizeof(query), "SELECT `password` FROM `player` WHERE `name` = '%s'", name); 
	
	Result = mysql_query(koneksi, query); 
	
	if(cache_num_rows()) cache_get_field_content(0, "password", GetOldPass);
	
	cache_delete(Result);
	
	WP_Hash(WPhash, sizeof(WPhash), OldPass);
	
	if(strcmp(WPhash, GetOldPass, false) == 0)
	{	
		WP_Hash(WPhash, sizeof(WPhash), NewPass); 
		
		mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `password` = '%s' WHERE `name` = '%s'", WPhash, name);
		
		mysql_query(koneksi, query, false); 
		
		SendClientMessage(playerid, COLOR_GREEN, "Password Changed!"); 
	}
	else SendClientMessage(playerid, COLOR_GREEN, "Old Password is Wrong!"); 
    
    return 1; 
}