How do I know how many users are using a specific style?
 

I have several styles in our forums and I was wondering if there is a way to find out who is using which style and perhaps some statistics on # of users of each style.

If you run this query...

It will show you how many users are using each style. This doesn't include users using the default style (styleid = 0) though, so you will need to run a separate query to figure that out...

Of course you need to replace "(PREFIX)" with whatever your vB table prefix is. You could write a script or plugin to do this if so inclined, but this is the quick and dirty method of getting those numbers. It's important to note that styles you disabled that users still have selected will be counted still. For example, I used to offer a style that a very small portion of my userbase selected. I declided to stop supporting it and removed it, but after disabling it they still have it set as their style ID (even though they're viewing the default style).

Hope this helps.