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

XF 1.1 Can I check how many users are using style x?

Discussion in 'XenForo Questions and Support' started by markku, Jan 18, 2012.

  1. markku

    markku Well-Known Member

    Hey,

    I'd like to be able to check how many users are using, for example, style x.

    I've got several styles available, but I'd like to see which ones are most popular.

    Couldn't find a way from ACP.
     
  2. James

    James Well-Known Member

    You can't via the ACP, you'll have to use phpmyadmin.
     
    markku likes this.
  3. markku

    markku Well-Known Member

    Could you give a couple of tips, I have phpmyadmin installed and know a bit of my way around mysql, but I'm not sure what tables or columns to look for so I could somewhat easily spot how many users a style has.

    Or do I need some more sophisticated mysql queries to calculate the user amount of each style?

    *thanks*
     
  4. James

    James Well-Known Member

    Untested but this should work:

    Code:
    SELECT style_id, COUNT(style_id) FROM xf_user GROUP BY style_id
    
     
    markku likes this.
  5. markku

    markku Well-Known Member

    Worked. Thanks!
     

Share This Page