Theme Metrics

[Scott VZ]

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.

[Scott VZ]

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.

[Square Wheels]

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;

[Scott VZ]

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.

[Square Wheels]

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.

[Scott VZ]

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

 

[Square Wheels]

3 minutes ago, Scott Von Zee said:

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.

[Joel R]

Check out this free file by @Fosters

 

[Square Wheels]

35 minutes ago, Joel R said:

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.

[Fosters]

14 hours ago, Square Wheels said:

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