Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jan 2003
Posts: 263
Member
Member
Joined: Jan 2003
Posts: 263
I would like to know how many members have logged in on my site in the past 24 hours or on a specific day.
Does anyone know a query for this ?

Sponsored Links
Joined: Jan 2003
Posts: 263
Member
Member
Joined: Jan 2003
Posts: 263
Anyone ?

Joined: May 2003
Posts: 1,068
Junior Member
Junior Member
Offline
Joined: May 2003
Posts: 1,068
It's already built into threads, in the Admin menu look for User Stats and it will give you that info and a lot more. If you want the query itself you can dig it up from admin/showstats.php

Joined: Jan 2003
Posts: 263
Member
Member
Joined: Jan 2003
Posts: 263
Thank's Eric!
[]My stats:
Users that have logged in the past 24 hours 94
Users that have logged in the past 7 days 250
..... [/]

Are the 94/24 hours unique logins ? I mean, if I login 10 times a day, will I be counted 10 times ? And what about users that are "always logged in" (cookie) ? Are they being counted ?

What I would like to see, is a list of users that have visited my site in the last 24 hours or 7 days

Joined: Sep 2003
Posts: 488
Code Monkey
Code Monkey
Joined: Sep 2003
Posts: 488
[]Pasqualist said:
Are the 94/24 hours unique logins ? I mean, if I login 10 times a day, will I be counted 10 times ? And what about users that are "always logged in" (cookie) ? Are they being counted ?[/]

Hi Pasqualist,

The U_Laston field is used in that query, so it would only count as once per user no matter how many times they logged in and out.

It gets set whenever a temporary cookie isn't found, which would indicate the start of a new session. So the only way a person would not show up for those stats, is if they have stayed loggin in _and_ haven't closed their browser. Either one will terminate the session and the Laston field will be updaded when they return.

[]What I would like to see, is a list of users that have visited my site in the last 24 hours of 7 days [/]

I'll make a mod for it, should be pretty easy

You won't be able to know when a user has logged out or started a new session if it was previous to their current one though.

For example, if they login (start new session) and logout (terminate session) once per day for the last seven days, you will only be able to know the last time they logged in (started a new session) because there are no fields to store that info by default.

However if they logged in 7 days ago and are still using the same session and browser instance, you will know they have visited the site at least once during that length of time, or perhaps left it open the whole time in their taskbar.

To know exactly which days they viewed/surfed the forums though, there's really no way to tell unless they posted.

Sponsored Links
Joined: Sep 2003
Posts: 488
Code Monkey
Code Monkey
Joined: Sep 2003
Posts: 488


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,834
Joined: January 2000
Forum Statistics
Forums63
Topics37,575
Posts293,931
Members13,824
Most Online6,139
Sep 21st, 2024
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,834
Greg Hard 4,625
Top Posters(30 Days)
Gizmo 1
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2025 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)