How To Query Theme Usage

[z929669]

There doesn't seem to be a tool that provides usage statistics for themes. I have three themes and want to determine how frequently each is used by my members in order to validate continued support of each theme.

Does anyone know where this info might be in the database so that I can query for it? It MUST be in the DB either explicitly or implicitly, but it's not obvious.

Thanks!

EDIT: I don't think theme is 'remembered' solely using session/cookie data, because my last chosen theme is persistent across browsers, so it should be in the DB somewhere.

Edited February 17, 2021 by z929669

[Morrigan]

Pretty sure its the "Skin" column in the core_members. 0 and blank I believe is default.

Edited February 18, 2021 by Morrigan

[z929669]

I only see acp_skin col, and it's NULL for every record in members table

Doh! missed it on page two of the col list ... thank you!

 

EDIT: If anyone else comes across this, here is a query (NULL means the member hasn't chosen a theme and are therefore using the default):
 

SELECT
name
,set_id
,set_name
FROM `core_members` m
inner join `core_themes` t on t.set_id=m.skin

and ...
 

SELECT count(*)
FROM `core_members` m
inner join `core_themes` t on t.set_id=m.skin
where set_id = 1

 

Edited February 18, 2021 by z929669

[Matt]

I quite like this idea.

[Daniel F]

We have a free 3rd party app in our marketplace which could be used for this.

 

[Matt]

[Square Wheels]

2 hours ago, Daniel F said:

We have a free 3rd party app in our marketplace which could be used for this.

 

Yup, I love this one.