vb.org Archive - Most popular / impopular style ?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Design and Graphics Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=253)

- - Most popular / impopular style ? (https://vborg.vbsupport.ru/showthread.php?t=300806)

DF031

08-04-2013 05:32 AM

Most popular / impopular style ?

Good morning all,

Is there a way, using the ACP, to find out how many users are using a specific style ?

Or do I need to use phpmyadmin in order to find this out ?

ozzy47

08-04-2013 09:57 AM

Only problem with that is, you can find out if the user selected the style in the User CP options. Styles chosen in the Quick Style Chooser on the footer don't show (as they are in cookies). Which is how alot of members change the style.

DF031

08-04-2013 11:31 AM

Quote:

Which is how alot of members change the style.

How do you know that ?

Is there data available on that ?

ozzy47

08-04-2013 01:54 PM

No hard data, but it has been what I have seen on sites I used to run.

DF031

08-04-2013 02:25 PM

In case I want to see that on our forum, what should I do ?

ozzy47

08-04-2013 02:33 PM

You could run this SQL query:

Code:

SELECT

        user.styleid,

        COUNT(user.styleid) AS total,

        style.title

FROM

        user

LEFT OUTER JOIN

        style ON

                style.styleid = user.styleid

WHERE

        user.styleid <> 0

GROUP BY

        styleid

ORDER BY

       total

DF031

08-04-2013 07:21 PM

Thanks Ozzy

The results of the query where;

https://dl.dropboxusercontent.com/u/...g6584/snip.PNG

But what does that mean ? Which users are listed ? We have about 11 000

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

Think I got it. Deleting the WHERE statement results in:

https://dl.dropboxusercontent.com/u/...84/Capture.PNG

Does this mean that about 11 000 have not set any style and are using the default ?

ozzy47

08-04-2013 07:38 PM

Correct, styleid 0 is nothing set in the usercp.

All times are GMT. The time now is 01:56 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01294 seconds Memory Usage 1,728KB 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)post_thanks_navbar_search (1)printthread (8)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: