jacem
Posts: 87
|
Posted: 06/04/2007, 10:48 PM |
|
If you want to restrict the login of a user without removing the user from your 'valid users' table you can not simply alter the WHERE clause in the login form properties.
What you have to do is modify the SELECT statement in the CCLoginUser in your Common script to exclude users according to your criteria.
For example if your table of valid users had a boolen type field named 'suspended' (1=suspended, 0=unsuspended) then you would need to modify the Select statement for the CCLoginUser function in the Common script to add the text
. " AND Suspended=0"
Thanks to the CC guys for the genesis of this tip when they were answering another users question on blocking concurrent logins from the same user.
|
|
|
Damian Hupfeld
|
Posted: 06/04/2007, 11:10 PM |
|
Alternatively set the the minimum access-level or group to something above 1
and you can reserve 0 or 1 for suspended
eg.
1 - Suspended
5 - Awaiting authorisation
10 - Member
20 - Editor
30 - Admin
You then do not need to modify the login form manually at all - just set the
Security Level to 10 for your Restricted pages as you create them.
Damian
"jacem" <jacem@forum.codecharge> wrote in message
news:254664f91b9e93c@news.codecharge.com...
> If you want to restrict the login of a user without removing the user from
> your
> 'valid users' table you can not simply alter the WHERE clause in the login
> form
> properties.
>
> What you have to do is modify the SELECT statement in the CCLoginUser in
> your
> Common script to exclude users according to your criteria.
>
> For example if your table of valid users had a boolen type field named
> 'suspended' (1=suspended, 0=unsuspended) then you would need to modify the
> Select statement for the CCLoginUser function in the Common script to add
> the
> text
>
> . " AND Suspended=0"
>
> Thanks to the CC guys for the genesis of this tip when they were answering
> another users question on blocking concurrent logins from the same user.
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|