Redirect to Changepassword page on default password

[JAYM]

Redirect to Changepassword page on default password
I want to add function where if it detect the password of user when default password="12345" it will redirect to changepassword page upon logging in.
I tried to put the code to custom scripts but it doest work.
Please help thank you.

$userid = CurrentUserID();
    $pswd = ExecuteScalar("SELECT password FROM userlogin WHERE id='$userid'");

    if ($pswd == "12345"){
        header('Location: changepassword');
    } else{
      header('Location: home');
    }

[mobhar]

Are you sure the password in users table are stored as plain text (not ecrypted)?

[JAYM]

Yes the password is not encrypted and its just plain text

[mobhar]

In which server event did you put that code?

[JAYM]

I put the code here but is doesnt work
Global -> All Pages -> Page_loading
Global -> All Pages -> User_Validated
Table Specific -> Login Page -> UserLoggedIn

[mobhar]

You should only put the code in User_LoggedIn server event.

In addition, change this part:
header('Location: changepassword');

to:
$this->terminate('changepassword');

and this part:
header('Location: home');

to:
$this->terminate('home');

[JAYM]

Thanks its working now.