XF 2.2 How to find the most active members in 2023?

[Anatoliy]

Hi,

I'd like to make a post on my forum to list and thank members who were the most active last year. Can anybody suggest how to find them?

It's easy for new members who registered in 2023. In ACP -> Users I can filter by the registration period and then sort them by posts number or received reactions.

But what about old(many many years) members? Can I somehow see the amount of posts/reactions they made/received in 2023?

 

[Anatoliy]

I guess I could run some sql request in posts table, where date of post > n. That will give me total number of posts. I remember that there is "count" or something, that would give me an array with usernames as keys and post count as value.

Can you help with this please?

 

[James]

XF 2.2 Post in thread 'How many posts in a given timeframe for a given user?'

Jan 3, 2022

At this time of the year, I like to generate a whole bunch of stats for my sites from the previous year which I then turn into nice charts and tables and publish on my site for my users (although it's mostly for my benefit - helps me identify outliers and troublemakers!)

Here is a variation on a query that I use to generate a count of posts made each day - I copy the output into a spreadsheet, calculate a 28 day moving average (so I'll typically set the start date to 28 days before Jan 1st), and then generate a pretty chart showing average post counts per day throughout the year.

It is...

• Sim

• 

 

[Mr Lucky]

EDIT: Removed as not the right answer