Check logged in users

Anon

I would like to list people logged in to my system. I use sessions to see if a user is logged in. Now, I'm thinking of making a column in my user table (MySQL) which shows if the user is online, but I need it to be reset after a certain time of inactivity, let's say you're logged in for 1 hour before you are automaticly logged out or something.

How can I do this in a smart way? Set the value in the table from 1 (online) to 0 (offline)?

I tried looking in the PHP Manual and search this forums but I couldn't find anything that helped me...

Thanks in advance...
Jorgen Bitzekis a.k.a. Joffe

Anon

If you are running your sessions from a database, create a cron to delete them occationally..just have a timestamp column in the sessions for 'last access' and just do a select from sessions join on users to get currently logged in users

Anon

Well, the problem is that I don't run my session from a database. I see if the entered login name and passwords matches with a row in the database and then makes a session which carries $verified_user and if $verified_user = $user (which is defined in the URL) it allows to show the correct page, otherwise an error is displayed.

Any good way to solve this, and I need some code example since I haven't done anything like this at all before..

Thanks.

Anon

Make the first part of your script to check a timestamp in the db of all people who have the logged in column checked. If the tstamp is too old, reset it.

Also periodically update the timestamp to keep the session active while they are using the site.