1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Get number of active users and daily avg posts/threads?

Discussion in 'XenForo Questions and Support' started by RickM, May 2, 2011.

  1. RickM

    RickM Well-Known Member

    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
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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.

    See this post:

    http://xenforo.com/community/thread...out-your-forum-daily-stats.13711/#post-179627
     
    RickM likes this.
  3. RickM

    RickM Well-Known Member

    Thanks Jake - much appreciated :)
     

Share This Page