Denying Multi Login with same ID

Atiq

Here is what i want :

"If a user is looged in and another user with the same login/password tries to enter the system he should not be able to login until the other user logged out of the system."

I can store the entry for the user in the table. And as long as that entry stays in the table other users can not login.

But the problem is when should i delete this entry from table.

When user presses logout is Ok.

But what if the light goes off or any other unintential log out .

Please advise.

Regards,

Atiq

Kudose

You could make a script to dump the table after however many minutes and reload itself with the current active sessions.

Atiq

Thanks

But my question stays the same!

How and when can i delete the entry from table.

crimaniak

Originally posted by Atiq
Thanks

But my question stays the same!

How and when can i delete the entry from table.

You need HEAP table with logged users. Every time when user see page in private area you update this table. If user is logged out you delete his record from this table. If user try to logon you first delete from this table all items not updated last $timeout minutes (20 minutes for example), then check for double login.

CREATE TABLE LoggedUsers
(
UserID INT PRIMARY KEY,
TS TIMESTAMP,
INDEX(TS)
) Type=HEAP;