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


    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?


  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query:

    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:

    RickM likes this.
  3. RickM

    RickM Well-Known Member

    Thanks Jake - much appreciated :)

Share This Page