Prev   Next

Back to the top of the FAQ

Q. Limit logins? How do I get it to work with my ODBC/SQL/mySQL database?

A. Limit logins is only available in WebQuota.

You have a ODBC database table with username, password fields.
Add another field and call it Blocked, default to "No".
In the ODBC dialog use the custom statement and specify the names of your username and password fields. In the middle text box, have something like this:
"From userAccounts where Blocked="No" And "
with spaces at the end.

In the Limit Logons dialog open the Update ODBC dialog and set the DSN, table and username field appropriately.
In the "Field to Update", select the field "Blocked".
In the Update Value text box, put in "Yes".
Then if limit-logins is exceeded, the Blocked field for that user will change from "No" to "Yes", and the custom statement will return no records, and the user will be blocked from logging in again.

Back to the top of the FAQ

Prev   Next