How to tell how many users are using a certain skin?

[Dunhamzzz]

Hi,

I have 2 skins on my site, a light and a dark, is there a mod/method I can use to tell how people are using the light one and how many the dark?

I tried searching but as you can imagine the keywords are very popular!

[ChopSuey]

There is a mod like vb.org somewhere that shows what style they are using in postbit. I can't find it :p

[Gladius2007]

Bumping this... anyone know how to figure this out from the database? I just need to know the number of people using a certain style.

[Paul M]

User table, styleid field.

[tpearl5]

Specifically
SELECT styleid, COUNT(styleid) AS stylecount FROM user GROUP BY styleid

[Gladius2007]

Great, thanks!

--------------- Added 1409191318 at 1409191318 ---------------

Actually, not sure if that's working properly?

I got this back:

styleid stylecount
0 14411
2 4
4 1
6 2
9 2

But the style IDs don't match the style IDs as I see them in the Style Manager... I don't even have a style ID 0, for example... My active styles are 2, 9, 7 and 8 and half of those numbers aren't even in the list. Any ideas?

[tpearl5]

0 means they have nothing specifically set - in other words they are seeing whatever you have set as the default. The others have selected different styles. It's possible to have users that set an old style and haven't been back to the site since new styles have been created. Anything not listed isn't being used at all.

[Gladius2007]

Hmm, ok. Seems weird that practically nobody uses anything but default though.

[nhawk]

Hmm, ok. Seems weird that practically nobody uses anything but default though.

It's not weird at all. It's actually the norm.

When most people go to a site they accept that what they see is the way the site is suppose to look. Very few people will change the style or they may not even know that they can.

That's why your default style should be the way YOU want it to look to everyone else.

[Mark.B]

It's a bit more complex than that.

The majority of users will change their style using the style chooser at the bottom, rather than going into their options.

If they do it with the style chooser, then it's just setting a cookie, it doesn't record anything in the database. So there's no way to obtain a count of these users.

Somewhere, there's a vB3 mod that alters the style chooser so that it actually updates the user settings, just as if they had gone into the usercp (it leaves the cookie version in place for guests). I've been using it on my site (which has been on vb4 since 2010) for many years. It's loads better...

--------------- Added 1409230432 at 1409230432 ---------------

I found it...it's not a mod as such...just a discussion, but it's from this thread that I managed to make it (on vB3):
https://vborg.vbsupport.ru/showthread.php?t=210969

I asked at the very end how to make it work on vB4, I did eventually do it but it's too long ago for me to actually recall....

[Gladius2007]

It's a bit more complex than that.

The majority of users will change their style using the style chooser at the bottom, rather than going into their options.

If they do it with the style chooser, then it's just setting a cookie, it doesn't record anything in the database. So there's no way to obtain a count of these users.

Somewhere, there's a vB3 mod that alters the style chooser so that it actually updates the user settings, just as if they had gone into the usercp (it leaves the cookie version in place for guests). I've been using it on my site (which has been on vb4 since 2010) for many years. It's loads better...

--------------- Added 1409230432 at 1409230432 ---------------

I found it...it's not a mod as such...just a discussion, but it's from this thread that I managed to make it (on vB3):
https://vborg.vbsupport.ru/showthread.php?t=210969

I asked at the very end how to make it work on vB4, I did eventually do it but it's too long ago for me to actually recall....

Aaah, that certainly explains it better. I'm sure that the majority of people changed it via the style chooser, yes... so it's just cookied. That's why the numbers didn't make sense to me. I know full well that the majority would use the default theme, but I also know that more than 10 people use other available styles. Was the mod for this ever actually made or just the bits of code in that thread?

[blind-eddie]

I installed Skin view - show skin in postbit (https://vborg.vbsupport.ru/showthread.php?t=133805&highlight=Skin+view) on my test board and also installed the plugin mentioned in the first post on that thread.
Maybe it will help you figure out what your trying to achieve.

Demo: http://blind-eddie.com/forum/showthread.php?t=1476
Login: Test Account One
Password: 00000000

Once there, change your style via the Quick Style Changer.
You will see it also changes in the postbit