Yes, I agree.
SELECT theme, COUNT(uid) FROM ".$GLOBALS['prefix']."users GROUP BY theme ORDER BY COUNT(uid) DESC LIMIT 10
I managed to write that statement after some research. XD Took a few tries to get it right though. It's purpose is to count all the users using a particular theme, for ever theme at least 1 user is using. x.x and also select the theme name.
|