One suggestion I gave about three months ago was to create two additional tables:
1)Status - contains all the permissions/user status information with the following fields:
ID
Status (administator, moderator, editor, power user, registered, banned)
2) User_Status - contains multiple records for each user (N->M connection):
ID
UserID
StatusID
This would allow users to have multiple statuses and be able to do multiple things in your scripts based on their status.
I do have this working (at least on the back-end)...I am still tweaking the front-end login process. But of course, I am still using Links SQL v.1.13, since it really addresses all my needs at this point. I don't anticipate upgrading to NG until probably Summer 2001 or Winter 2002.
Regards,
Eliot Lee
1)Status - contains all the permissions/user status information with the following fields:
ID
Status (administator, moderator, editor, power user, registered, banned)
2) User_Status - contains multiple records for each user (N->M connection):
ID
UserID
StatusID
This would allow users to have multiple statuses and be able to do multiple things in your scripts based on their status.
I do have this working (at least on the back-end)...I am still tweaking the front-end login process. But of course, I am still using Links SQL v.1.13, since it really addresses all my needs at this point. I don't anticipate upgrading to NG until probably Summer 2001 or Winter 2002.
Regards,
Eliot Lee