|
|
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_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 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,833 Likes: 20
UBBDev / UBBWiki Owner Time Lord
|
UBBDev / UBBWiki Owner Time Lord
Joined: Jan 2000
Posts: 5,833 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,833 Likes: 20
UBBDev / UBBWiki Owner Time Lord
|
UBBDev / UBBWiki Owner Time Lord
Joined: Jan 2000
Posts: 5,833 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: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|