Previous Thread
Next Thread
Print Thread
Rate Thread
Ian_W #314038 05/06/2007 2:41 AM
Joined: Nov 2003
Posts: 482
Enthusiast
Enthusiast
Offline
Joined: Nov 2003
Posts: 482
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

Sponsored Links
#314710 07/13/2007 8:26 PM
Joined: Jan 2000
Posts: 5,830
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,830
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).


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Jan 2000
Posts: 5,830
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,830
Likes: 20
This thread is bugged and has been submitted as a bug report, recreating this so SD can "pretify" his post wink...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts

Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
badfrog
badfrog
somewhere on the coast of Maine
Posts: 94
Joined: March 2007
Forum Statistics
Forums63
Topics37,570
Posts293,918
Members13,848
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,830
Greg Hard 4,625
Top Posters(30 Days)
Gizmo 1
Top Likes Received
isaac 81
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2023 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)