Login with user, password and other fields

PHPMaker General Discussion (PHPMaker)
1

Hi AllI have a table: participants for the login process
id : Int 11
users :V 25
password : V50
status : int 1 (1 active, 2 passive)I usually login using only the user and password, and the password is not encrypted.

  1. How to login with user and password and status = 1 (active)
  2. how to enter password using MD5?
    Thank You
2

cantika wrote:

How to login with user and password and status = 1 (active)

You may check the value of your status field in User_LoggingIn server event based on the $usr and $pwd params in that event, and if it contains 2, display the error message by using setFailureMessage method of current page, and then return false to cancel the login. Otherwise, if it contains 1 in the status field, then return true to allow the user logged in.

3

I set it in Login Pane > User_LoggingIn$status = $rsold[“status”];if($status==1){
return TRUE;
}else{
return FALSE;
}but failed… error. How to make that logic?
Thank You

4

cantika wrote:

$status = $rsold[“status”];

There is no $rsold[“status”], you should execute an query to the database based on the user name, the argument name is $usr in the server event.