prontera,139,173,0	script	Privacy	71,{
mes "By using this features you need to provide your credentials and you cannot redo this..but you can change your password or email as much as you can.";
next;
switch(select("Change password:Change Email:Change Username")){
case 1:
	mes "Please enter your email:";
	input .@email$;
	next;
	mes "Please enter your username:";
	input .@userid$;
	next;
	query_sql "SELECT `account_id`,`userid`,`email` FROM `login` WHERE `email` = '"+escape_sql(.@email$)+"'", .@account_id,.@userid,.@email$;
	if (!.@account_id) {
	mes "Credentials is not sufficient..";
	close;
	}else{
	goto Xpassword;
	close;
	}
	break;
case 2:
	mes "Please enter your username:";
	input .@usernamex$;
	next;
	mes "Please enter your password:";
	input .@user_pass$;
	next;
	query_sql "SELECT `account_id`,`userid`,`user_pass` FROM `login` WHERE `user_pass` = '"+escape_sql(.@user_pass$)+"'", .@account_id,.@userid,.@user_pass$;
	if (!.@account_id) {
	mes "Credentials is not sufficient..";
	close;
	}else{
	goto Xemail;
	close;
	}
	break;

case 3:
	mes "Please enter your email:";
	input .@usermail$;
	next;
	mes "Please enter your password:";
	input .@paxx$;
	next;
	query_sql "SELECT `account_id`,`userid`,`user_pass` FROM `login` WHERE `user_pass` = '"+escape_sql(.@paxx$)+"'", .@account_id,.@userid,.@paxx$;
	if (!.@account_id) {
	mes "Credentials is not sufficient..";
	}else{
	goto Xusername;
	close;
	}
	break;
}

Xpassword:
	mes "Input your new password:";
	input .@password$;
	query_sql "UPDATE `login` SET `user_pass` = '"+escape_sql(.@password$)+"' WHERE `email` = '"+escape_sql(.@email$)+"' AND `userid` = '"+escape_sql(.@userid$)+"'";
	next;
	dispbottom "Your password has been changed to: " + .@password$ + "";
	close;

Xemail:
	mes "Input your new email:";
	input .@emailxz$;
	query_sql "UPDATE `login` SET `email` = '"+escape_sql(.@emailxz$)+"' WHERE `user_pass` = '"+escape_sql(.@user_pass$)+"' AND `userid` = '"+escape_sql(.@usernamex$)+"'";
	next;
	dispbottom "Your email has been changed to: " + .@emailxz$ + "";
	close;

Xusername:
	mes "Input your new username:";
	input .@usernamenew$;
	query_sql "UPDATE `login` SET `userid` = '"+escape_sql(.@usernamenew$)+"' WHERE `user_pass` = '"+escape_sql(.@paxx$)+"' AND `email` = '"+escape_sql(.@usermail$)+"'";
	next;
	dispbottom "Your username has been changed to: " + .@usernamenew$ + "";
	close;
}