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

[gavpeds]

As the title says really.

 

[Paul B]

There is no option for that.

 

[wang]

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.

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.

 

[Snog]

I woudn't normally do this, but...
https://xenforo.com/community/resources/style-statistics.2257/

Does live tracking of what users are using what style.

 

[AndyB]

As the title says really.

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

 

[Misayuki]

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

 

[foiovitor]

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.

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

Thanks

 

[Miles Gillham]

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

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;

 

[AndyB]

This add-on shows style information:

https://xenforo.com/community/resources/style-info.5468/