Register/Delete Login Session

[treeleaf20]

Hello,
I was wondering if anyone knew of a good script that when a user logins in would store a record in a table that says the time they login. After a period of inactivity (which I'm not sure how to manage either) it would destroy the session. I want to do this so I can run a query to see if the user is logged (without using Sessions) and it would delete the row if they click the logout button but if they just close the browser I would want the registered row to be deleted. Hope someone can help or point me in the right direction??

Thanks.

[devinemke]

you could setup a table called "logins" that looks something like this:

login_id (INT) PK
session_id (VARCHAR)
user_id (INT)
update (TIMESTAMP)

when a user logs in a session is started and a new records is INSERTed. During each page request, the "update" column is UPDATEd with the current timestamp. When the user logs out, simply delete the record and run [man]session_destroy[/man].

as far as deleting old records after inactivety, run an hourly cronjob that scans the table for "updates" that are older than 1 hour (or whatever time interval you want) and deletes the records and the corresponding session file.