vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   How to tell how many users are using a certain skin? (https://vborg.vbsupport.ru/showthread.php?t=235604)

Dunhamzzz 02-11-2010 12:34 PM

How to tell how many users are using a certain skin?
 
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 02-11-2010 09:26 PM

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

Gladius2007 08-27-2014 10:58 PM

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 08-27-2014 11:13 PM

User table, styleid field.

tpearl5 08-27-2014 11:51 PM

Specifically
Code:

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

Gladius2007 08-28-2014 12:54 AM

Great, thanks!

--------------- Added [DATE]1409191318[/DATE] at [TIME]1409191318[/TIME] ---------------

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 08-28-2014 01:20 AM

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 08-28-2014 01:38 AM

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

nhawk 08-28-2014 11:28 AM

Quote:

Originally Posted by Gladius2007 (Post 2512935)
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 08-28-2014 11:48 AM

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 [DATE]1409230432[/DATE] at [TIME]1409230432[/TIME] ---------------

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....


All times are GMT. The time now is 09:14 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01061 seconds
  • Memory Usage 1,729KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete