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;



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

--------------- Added [DATE]1375647927[/DATE] at [TIME]1375647927[/TIME] ---------------

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



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.