Count logged in users

Hi Ray,

Do you know of a way to get a count of logged in users? I have been searching the internet but cannot find a definitive answer, yet I know it can be done. One suggestion was to count the active sessions but I have no idea of where you store these sessions or how to count them. There are other suggestions from adding columns to the database to using processlist in information_schema but I can't find anything that actually shows me how to do this. However you seem to have an amazing ability to find solutions so I was hoping you've already solved this.

Thanks

You are trying to show "Currently logged in users" is that correct?

It isn't very easy to pull off in php. You would have to update the database with every page visit to keep track of when someone is online. You could create a plugin file to do this for you and include it on the top of every page.

First add a column to your users table "UserLastVisit" and make it a Date/Time data type or timestamp.

UPDATE users SET UserLastVisit= NOW() WHERE UserID = IDSavedOnLogin

Then to get how many people are on the site at any given moment you use a recordset with the query:

SELECT COUNT(*) AS CurrentUsers FROM users WHERE UserLastVisit> DATE_SUB(NOW(), INTERVAL 20 MINUTE)

Thanks Ray, I'll probably set up a session with you when I get a little closer to finishing this project.