Most popular / impopular style ?

[DF031]

Good morning all,

Is there a way, using the ACP, to find out how many users are using a specific style ?

Or do I need to use phpmyadmin in order to find this out ?

[ozzy47]

Only problem with that is, you can find out if the user selected the style in the User CP options. Styles chosen in the Quick Style Chooser on the footer don't show (as they are in cookies). Which is how alot of members change the style.

[DF031]

Which is how alot of members change the style.

How do you know that ?

Is there data available on that ?

[ozzy47]

No hard data, but it has been what I have seen on sites I used to run.

[DF031]

In case I want to see that on our forum, what should I do ?

[ozzy47]

You could run this SQL query:

SELECT
user.styleid,
COUNT(user.styleid) AS total,
style.title
FROM
user
LEFT OUTER JOIN
style ON
style.styleid = user.styleid
WHERE
user.styleid <> 0
GROUP BY
styleid
ORDER BY
total

[DF031]

Thanks Ozzy

The results of the query where;

https://dl.dropboxusercontent.com/u/2287968/Forums/VBorg6584/snip.PNG

But what does that mean ? Which users are listed ? We have about 11 000

--------------- Added 1375647927 at 1375647927 ---------------

Think I got it. Deleting the WHERE statement results in:

https://dl.dropboxusercontent.com/u/2287968/Forums/VBorg6584/Capture.PNG

Does this mean that about 11 000 have not set any style and are using the default ?

[ozzy47]

Correct, styleid 0 is nothing set in the usercp.