For ubbt 7.1.1:
SELECT CONCAT('[*][url=http://yourdomain.com/ubbthreads/ubbthreads.php?ubb=previewskin&skin=',STYLE_ID ,']',STYLE_NAME,'[/url]')
FROM ubbt71x_STYLES
GROUP BY STYLE_ID
ORDER BY STYLE_NAMEthen copy / paste the output between a [ list ] set of tags and you get a quick list of all your styles in clickable / named form..
reason i did it, was i was too lazy to see what was new, styles wize in order to update my custom_island..
ps: also replace 'ubbt71x_' with your board's prefix
SELECT t2.STYLE_NAME AS Style, COUNT(t2.STYLE_NAME) AS
Count FROM ubbt71x_USER_PROFILE as t1 LEFT JOIN ubbt711_STYLES
as t2 on t1.USER_STYLE = t2.STYLE_ID
GROUP BY t2.STYLE_NAME
ORDER BY t2.STYLE_NAME
Counts the number of users using each style
...
Previous Topic
Index