Hi all,

I posted this Mod suggestion over at UBBDev here.

Thought I would mention it here because there at least seems to be more activity here than there.

I'm guessing due to the request from Rick for mod/hacks to be done there, replies, solutions should be done there

Here's the query....



replace 30 with the number of days
...and 60 with the total number wanted on the list.

I think Rick provided me with this code

Nah, that's not quite what I'm after. That's a listing of top posters.

What I'm really trying to get to is 1) How many of my users are logging in within the time frame. 2) out of that set, how many of them are actually even making a post. I don't care WHO they are, just the number of users who've logged in that are making posts.

While the number of users making posts is probably the true sense of "active", I'm curious as well to how much of my userbase is at least coming by for a read, even if they're not commenting, and I'm just wanting raw numbers so it's easy to get a feel of it as a percentage of my overall total base.

So, I've got just under 2000 registered users. I kind of want to know, at a easily viewed place, how many of those 2000 are logging in over the past day, week, month. Let's say it's only 300. Then I know that rougly only 1/7th of my total user base is logging in regularly.

Next to that then, if I'm seeing 300 logging in over x period....hmmm...how many are actually posting, let's say I've only got 100 actually posting.

Anyway, that's what I'm looking for.

Not so.
It is a list of 'active' posters - which is a part of what you are looking for.

But, whatever...

You are correct, my mistake.

Where would I put this code? I'm interested in it.

Thanks

Code didn't work for me

have you tried creating a search based one hose parameters and saving it?

I saved it to a thing in the message board.

There is a an easier query without grouping for this:



for posting activity in the last 30 days

Replace USER_LAST_POST_TIME with USER_LAST_VISIT_TIME if "active" for you is also a user that logged in.

Small job to add this to the stats island.