Mysql /ChangePass Help
#7

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!
Reply


Messages In This Thread
Mysql /ChangePass Help - by alishvasis - 21.07.2016, 12:09
Re: Mysql /ChangePass Help - by F1N4L - 21.07.2016, 12:43
Re: Mysql /ChangePass Help - by alishvasis - 21.07.2016, 12:57
Re: Mysql /ChangePass Help - by F1N4L - 21.07.2016, 13:26
Re: Mysql /ChangePass Help - by alishvasis - 22.07.2016, 07:28
Re: Mysql /ChangePass Help - by F1N4L - 22.07.2016, 11:43
Re: Mysql /ChangePass Help - by alishvasis - 22.07.2016, 12:01
Re: Mysql /ChangePass Help - by F1N4L - 22.07.2016, 12:02
Re: Mysql /ChangePass Help - by alishvasis - 22.07.2016, 12:04
Re: Mysql /ChangePass Help - by F1N4L - 22.07.2016, 12:12

Forum Jump:


Users browsing this thread: 1 Guest(s)