Force to Change Password After Reset Password in osTicket v1.6 RC5

For those of you who have implemented my MOD about Add Forgot Password Feature for HelpDesk Officer into osTicket v1.6 RC5 and need to force the helpdesk officer to change their password on the next login, then this modification for you! I made this modification since there was a question asked to myself about it. Please note that you can do this following modification only if you have already implemented my MOD above.

Open your \scp\activatepassword.php file, and find this code:

47
48
49

		$sql = "UPDATE ".STAFF_TABLE." SET passwd='".$new_password."', 
		        new_passwd='', new_passwd_activate=''  
		        WHERE email='".$user_email."'";

then replace with this following code:

47
48
49

		$sql = "UPDATE ".STAFF_TABLE." SET passwd='".$new_password."', 
		        change_passwd=1, new_passwd='', new_passwd_activate=''  
		        WHERE email='".$user_email."'";

Now after helpdesk officer reset the password, on the next login they will being forced by osTicket to have to change their password before to continue their work. Hope it helps you.