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

XF 1.5 Is there a way to see which users are using a particular style on our site?

Discussion in 'XenForo Questions and Support' started by gavpeds, Dec 17, 2015.

  1. gavpeds

    gavpeds Active Member

    As the title says really.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    There is no option for that.
  3. wang

    wang Well-Known Member

    This can be done with a sql query. If you are comfortable with running queries, go to your phpmyadmin, choose the database that you used for installing your forum and run this query in the SQL box.

    SELECT style.title AS 'Style', user.username AS 'User'
    FROM `xf_style` AS style
    LEFT JOIN xf_user AS user ON
    (style.style_id = user.user_id)
    ORDER BY style.style_id;
    This will list all styles and members using them.
  4. Snog

    Snog Well-Known Member

  5. AndyB

    AndyB Well-Known Member

    Use phpMydmin, view the xf_user table, search by style_id.
  6. Misayuki

    Misayuki New Member

    Strange that this is not a feature of the software though. You'd expect it kind of.....
  7. Vitor Dos Reis

    Vitor Dos Reis Active Member

    Can this query be changed to count user in each style?


Share This Page