How to add a filtered variable to authentication

Along with their email address, I need to allow users to authenticate (using your mySQLi authentication method) when a column in their record is set to 1. Users in the table where "Status" = 0 would not be able to login. How can I accomplish this?

Just add that as a condition in the server behavior on the "Find Record" tab for that column.

PM

You also have to validate the email address and password. Currently you are only validating the Status column, so as long as there is any record with Status=1 it will let you in. You only want to let them in if the email, password, and status fields are verified.

Huh.. how odd. The behavior USED to validate username and email.. I didn't notice that it didn't anymore. I changed that and yes, it's working as I need it to now. Thanks for the lesson.

This issue cropped up again, this time we need to validate against TWO values.. 1 or 4. I've got using $Authenticate->addFilter("Status", "=", "i", "1"); for "1" but how do I modify this for a second value, called "4"?

You would have to have the authentication code chunk repeated since you can't do an "OR" in a filter in authentication. Just leave the failed redirect blank in the first validation and then it would run the second set of code if the first failed.

Another option is to not add the status to the filter and instead add it to the list of saved session variables. Then update your access rule to check for the Status value of 1 or 4.

Logically I get those.. and was thinking the same things - but I'm unsure how to modify your code to accomplish either of these goals. Can you throw me some examples?

The easiest might be the first one... Just go to code view and copy/paste the code you have so it is repeated twice.

Then open the first one and remove the failed redirect.

Then open the second one and change the status comparison value.