Jump to content

How To Query Theme Usage


z929669
Go to solution Solved by Daniel F,

Recommended Posts

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 by z929669
Link to comment
Share on other sites

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 by z929669
Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...