A aana Active member Dec 20, 2016 #1 Hello, i would like to know how i can have a list of all the member who post more than X message this last 30 days. What is the request to do ? Thanks.
Hello, i would like to know how i can have a list of all the member who post more than X message this last 30 days. What is the request to do ? Thanks.
Jake Bunce Well-known member Dec 21, 2016 #2 Run this query on your database: https://xenforo.com/community/threa...te-the-top-poster-member.124077/#post-1120041 Upvote 0 Downvote
Run this query on your database: https://xenforo.com/community/threa...te-the-top-poster-member.124077/#post-1120041
A aana Active member Dec 21, 2016 #3 Hello, Thanks. But seem's a little different no ? I am looking to know how many of my members have post more than 10 or 20 messages on the last 30 days. Is it the same query ? Upvote 0 Downvote
Hello, Thanks. But seem's a little different no ? I am looking to know how many of my members have post more than 10 or 20 messages on the last 30 days. Is it the same query ?
Jake Bunce Well-known member Dec 21, 2016 #4 It shows total post counts since the date in order, so the top results are the ones you want. Upvote 0 Downvote