R RickM Well-known member May 2, 2011 #1 Hi, I was wondering if anyone could tell me how you work out how many users have been active within X days or months. Also, is it possible to find out how many posts have been made each day? Thanks, Rick
Hi, I was wondering if anyone could tell me how you work out how many users have been active within X days or months. Also, is it possible to find out how many posts have been made each day? Thanks, Rick
Jake Bunce Well-known member May 2, 2011 #2 RickM said: I was wondering if anyone could tell me how you work out how many users have been active within X days or months. Click to expand... Run this query: Code: SELECT COUNT(*) AS activeUsers FROM xf_user WHERE last_activity > UNIX_TIMESTAMP() - X*60*60*24 Replace X with the number of days. RickM said: Also, is it possible to find out how many posts have been made each day? Click to expand... See this post: http://xenforo.com/community/thread...out-your-forum-daily-stats.13711/#post-179627 Upvote 0 Downvote
RickM said: I was wondering if anyone could tell me how you work out how many users have been active within X days or months. Click to expand... Run this query: Code: SELECT COUNT(*) AS activeUsers FROM xf_user WHERE last_activity > UNIX_TIMESTAMP() - X*60*60*24 Replace X with the number of days. RickM said: Also, is it possible to find out how many posts have been made each day? Click to expand... See this post: http://xenforo.com/community/thread...out-your-forum-daily-stats.13711/#post-179627