Stylesheet Popularity for v.6.5 - 11/12/2004 8:07 PM
i would love to see this mod (Stylesheet Popularity 1.0) updated for use in the admin control panel of the 6.5.x release.
Re: Stylesheet Popularity for v.6.5 - 11/13/2004 6:02 AM
YOu can do this easily by saving the query in the admin section (that's all the old mod did was auto fill in this query.
SELECT COUNT(*) as total,U_StyleSheet as style FROM w3t_Users GROUP BY U_StyleSheet ORDER BY total DESC
Go to Control Panel -> Database Tools
Click on SQL Command tab
Enter it in the box
Click Save
Then it'll appear on the list below, you can use whenever you wish to see the results.
SELECT COUNT(*) as total,U_StyleSheet as style FROM w3t_Users GROUP BY U_StyleSheet ORDER BY total DESC
Go to Control Panel -> Database Tools
Click on SQL Command tab
Enter it in the box
Click Save
Then it'll appear on the list below, you can use whenever you wish to see the results.
Re: Stylesheet Popularity for v.6.5 - 11/13/2004 2:39 PM
Thankz Josh 