Toplist of User Activity in Past 24 Hours?
Posted Sep 12, 2012 - 9:13 PM:
I was trying to make a toplist of online user activity over the past 24 hours. In member settings I set "Retain user in sessions table" to 1440 minutes, and created a sessions toplist ordered by starting time, with isrobot='0' to weed out the bots.
The toplist I'm getting is just the current users on site. It doesn't look like sessions beyond the current are being held in the database. Am I wrong in thinking that setting the retain to 1440 would give me the sort of toplist I'm looking for? Is there another way to do it?
When 'time' isn't somewhere in the toplist filtering condition, it automatically inserts a condition to filter it to people currently online. Using time > 0 to override that should get you what you want.
That 1440 minute limit does retain the sessions. If you want to also list them in the regular unmodified online users list then change the expire after setting right next to it to match.
Comments on Toplist of User Activity in Past 24 Hours?
Member
Usergroup: Customer
Joined: Nov 12, 2004
Total Topics: 9
Total Comments: 20
Posted Sep 12, 2012 - 9:13 PM:
I was trying to make a toplist of online user activity over the past 24 hours.
In member settings I set "Retain user in sessions table" to 1440 minutes, and created a sessions toplist ordered by starting time, with isrobot='0' to weed out the bots.
The toplist I'm getting is just the current users on site. It doesn't look like sessions beyond the current are being held in the database. Am I wrong in thinking that setting the retain to 1440 would give me the sort of toplist I'm looking for? Is there another way to do it?
Thanks
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
When 'time' isn't somewhere in the toplist filtering condition, it automatically inserts a condition to filter it to people currently online. Using time > 0 to override that should get you what you want.
Member
Usergroup: Customer
Joined: Nov 12, 2004
Total Topics: 9
Total Comments: 20
Ok, cool. Is there also a way to retain sessions for non-robot guests?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
That 1440 minute limit does retain the sessions. If you want to also list them in the regular unmodified online users list then change the expire after setting right next to it to match.
Member
Usergroup: Customer
Joined: Nov 12, 2004
Total Topics: 9
Total Comments: 20
Got it, thanks!