Force Change Password

[Deku]

I would like to ask for an npc that will force the player to change his password as soon as he logs in, that the password change is mandatory

thank you very much

Edit: I am suspecting a database leak and wanted everyone to change their password in a safe way

Edited May 19, 2020 by Deku

[Start_]

	mes "ID";
	input .@inputId$;
	next;
	mes "Old PW";
	input .@inputPw$;
	next;
	query_sql ("SELECT `account_id` FROM `login` WHERE `userid`='"+.@inputId$+"' AND `user_pass`='"+.@inputPw$+"'", .@sum);
	if(.@sum<=0){
		mes "Incorrect ID or PW";
		close;
	}
	next;
	mes "New PW";
	input .@inputPw$;
	if(.@inputPw$!=""){
		query_sql "UPDATE `login` SET `user_pass` = '"+.@inputPw$+"' WHERE `userid` = '"+.@inputId$+"'";
		mes "Done";
		close;
	}
	mes "Canceled";
	end;

This is simple password change scripts. you can adapt it.

[sader1992]

~

---------------------------------------

*escape_sql(<value>)

Converts the value to a string and escapes special characters so that it is safe to
use in query_sql(). Returns the escaped form of the given value.

Example:
	.@name$ = "John's Laptop";
	.@esc_str$ = escape_sql(.@name$); // Escaped string: John\'s Laptop

---------------------------------------

 

also it's better to create a script in the website , change the stat of all the accounts to prevent them from login and update the stat once they create a new password.