@Mark3121 - this SQL query will get the results you are after:One stat I can never find is how many unique forum members visit each month, the monthly statistics in the admin for users active are wrong as it just adds up the users active daily.
Great addon though Matt![]()
SELECT COUNT(*)
FROM xf_user
WHERE last_activity > UNIX_TIMESTAMP ( DATE_SUB ( NOW (), INTERVAL 30 DAY ) )
whoa, 5 updates since I installed this
Someone has been busy
It's looking great btw
Want me to stick that into the Users section of this add-on in the ACP?
New update allows you to enable Showcase stats if you have @bobster65 's add-on installed (this is disabled by default)
View attachment 52153
It also includes the active users for the past 7 and 30 days in the User Stats section
View attachment 52152
MattW updated Daily Statistics with a new update entry:
Showcase Stats and Active User Stats
Read the rest of this update entry...
Only if you want to see the Active Users bit.Do I need to update to this Matt since I installed the version with showcase?
Results are cached and only updated once per hour via the cron jobStats are not showing up for me - just installed and daily posts, registrations and threads are all at 0. New posts not incrementing...
It won't even install on anything less than 1.2 BetaWill my site crash and burn if I install this, or is it just some functions that won't work?
I ask because I don't want to upgrade to Xenforo 1.2.x, running Xenforo 1.1.4 right now.
PerfectNew users today = totalUsers
New threads today = totalThreads
New posts today = totalPosts
You should have able to find them searching for the phrase, that's all I've just done.
We use essential cookies to make this site work, and optional cookies to enhance your experience.