z929669 Posted February 17, 2021 Share Posted February 17, 2021 (edited) 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 Link to comment Share on other sites More sharing options...
Morrigan Posted February 18, 2021 Share Posted February 18, 2021 (edited) Pretty sure its the "Skin" column in the core_members. 0 and blank I believe is default. Edited February 18, 2021 by Morrigan Link to comment Share on other sites More sharing options...
z929669 Posted February 18, 2021 Author Share Posted February 18, 2021 (edited) 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 Link to comment Share on other sites More sharing options...
Management Matt Posted February 18, 2021 Management Share Posted February 18, 2021 I quite like this idea. Link to comment Share on other sites More sharing options...
Solution Daniel F Posted February 18, 2021 Solution Share Posted February 18, 2021 We have a free 3rd party app in our marketplace which could be used for this. Square Wheels and z929669 1 1 Link to comment Share on other sites More sharing options...
Management Matt Posted February 18, 2021 Management Share Posted February 18, 2021 Link to comment Share on other sites More sharing options...
Square Wheels Posted February 18, 2021 Share Posted February 18, 2021 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. Link to comment Share on other sites More sharing options...
Recommended Posts