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

wang

Well-known member
As the title says really.
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.

Code:
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.
 

Vitor Dos Reis

Active 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.

Code:
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.
Can this query be changed to count user in each style?

Thanks
 

Miles Gillham

New member
Old thread but... this query will give you a count of users who have nominated a style (otherwise they will use the default style).

SQL:
select style.title as 'Style', count(user.username) as 'Users' from xf_style as style left join xf_user as user on style.style_id=user.style_id group by style.title;
 
Top