Tracking forum activity
Moderator: General Moderators
Tracking forum activity
Hi. I have a php forum and am pretty new to using it. Is there a way to track users that have been online .. say in the last 24 hours, etc? I know how to see the IP's of the ones who are online, but I need to know who has BEEN online. Help?
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
That may well depend on the forum you're running. With phpBB, you'll need to run a query against the database as it doesn't have a built-in display for that. The field to use would be last_session_time I believe from the *_users table. The stored timestamp is a unix timestamp adjusted to GMT time, from what I remember.
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Code: Select all
SELECT `username` FROM `_users` WHERE `user_session_time` > '{$someTime}'