I'd like a feature that lets me see how many users are using each theme, as well as how many users have no saved theme preferences.

This info would help me decide which themes are still needed, and which are not worth the effort to keep maintaining and should be removed.

If it allowed me to see which specific users were using each theme, even better. 

That way I could see if the people still using a theme are active users, inactive, trolls, etc.

Try this query.  If you have a table prefix, you'll need to add it.

 

SELECT core_members.name, core_themes.set_name, core_members.skin
FROM core_themes INNER JOIN core_members ON core_themes.set_id = core_members.skin
ORDER BY core_themes.set_name;

Hi There,

Thanks for the reply. I'm on the Cloud plan, so I don't believe that I have a way to query the database for this info myself, unfortunately.

Do you have an admin panel?  If yes, use the SQL Toolbox in there.  It's only a select query, it won't make updates.

wow, awesome! Never knew that feature existed, since there doesn't seem to be any links to it in the admin navigation.

 

 

wow, awesome! Never knew that feature existed, since there doesn't seem to be any links to it in the admin navigation.

 

It's buried.

ACP --> System --> Support --> Support --> far right under MySQL Version you'll see the link.  Plus a phpinfo page too.

Check out this free file by @Fosters

 

 

Check out this free file by @Fosters

 

That didn't exist when I posted my solution.

My solution also tells you who's using it, but I installed @Fosters anyhow.

 

That didn't exist when I posted my solution.

My solution also tells you who's using it, but I installed @Fosters anyhow.

That's a nice idea, I'll add this feature to the next release