|
|
Joined: Nov 2003
Posts: 482
Enthusiast
|
|
Enthusiast
Joined: Nov 2003
Posts: 482 |
For ubbt 7.1.1: SELECT CONCAT('[*]',STYLE_NAME,'')
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
|
|
|
|
|
Joined: Jan 2000
Posts: 5,834 Likes: 20
UBBDev Owner
Time Lord
|
|
UBBDev Owner
Time Lord
Joined: Jan 2000
Posts: 5,834 Likes: 20 |
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).
|
|
|
|
|
Joined: Jan 2000
Posts: 5,834 Likes: 20
UBBDev Owner
Time Lord
|
|
UBBDev Owner
Time Lord
Joined: Jan 2000
Posts: 5,834 Likes: 20 |
This thread is bugged and has been submitted as a bug report, recreating this so SD can "pretify" his post  ...
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 5,834
Joined: January 2000
|
|
|
Forums63
Topics37,583
Posts293,955
Members13,824
| |
Most Online151,614
Nov 14th, 2025
|
|
Currently Online 1336
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 3
|
|
|
|
