Ubbt 7.1.1 queries - UBB.Developers

For ubbt 7.1.1:

Code

SELECT CONCAT('[*]',STYLE_NAME,'') 
FROM ubbt71x_STYLES 
GROUP BY STYLE_ID 
ORDER BY STYLE_NAME

then 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

Code

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

I figure we should make a separate section for our useful Threads7 queries as to keep things separate from the Threads6 stuff (since they're not interchangeable).

This thread is bugged and has been submitted as a bug report, recreating this so SD can "pretify" his post

...