How do I see how many users use each skin?

[Gabriel_5991]

I want to know how many users use each skin so I can delete skins nobody uses.

 

Is there a way to do it, I saw forums that display it in the bottom in the skin selector and etc... How do I do it?

[PrinceOfAbyss]

Go to you ACP > Support > SQL Toolbox and run the following SQL statement:

 

SELECT skin, COUNT(member_id) AS used_by FROM ibf_members GROUP BY skin

 

It will most probably return users using skin id 0 and also NULL skin. These are people that were using a skin that no longer exists in your forum.

 

Eg this statement returns in my case the following:

 

skin -> used_by

... -> 86

0 -> 39

1 -> 2169

13 -> 2

14 -> 3

16 -> 1

 

Now all you have to do is sum the people for the NULL and 0 'skins' to the people of your default skin (in my case it is id 13) and you end up with the correct statistics.

Edited March 28, 2011 by PrinceOfAbyss

[najaru]

Thanks PrinceofAbyss

 

and i think that if we want to force all users to a specific skin we can use:

 

UPDATE ibf_members SET skin = X

 

i'm right?