PDA

View Full Version : # of users using a skin?


Hazzo
03-03-2005, 03:24 AM
Strange request, but maybe someone would be interested in coding sumthing like this.. Or maybe there is this already and I missed it..

We all have the skin chooser, but is there a way, after the skin title to add how many users currently use that skin?

I have a site with like 10 skins on it, but I would like to drop some of those less used skins, but I want to base that on who all/how much use the skins are getting..

Anyone up to coding something like this? Or is there a hack already like this?

DRJ
03-03-2005, 04:06 AM
This query will tell you what styles are being used.


SELECT styleid, Count(*) as Count FROM `vb3_user`
GROUP BY styleid
ORDER BY Count DESC