Previous Thread
Next Thread
Print Thread
Hop To
Anonymous
Unregistered
Anonymous
Unregistered
I see where I can search for users by group or
administrative role, but is it possible to find out how many users are subscribed to a particular forum?

Lawrence

Anonymous
Unregistered
Anonymous
Unregistered
[6.3.1]

Number of users subscribed to board XXXX:

SELECT COUNT(*) FROM w3t_Subscribe
WHERE S_Board = 'XXXX'

Users subscribed to board XXXX:

SELECT U_Username FROM w3t_Subscribe
LEFT JOIN w3t_Users ON U_Number = S_Uid
WHERE S_Board = 'XXXX'

XXXX is the board keyword.

-----
UBB.threads beta tester / threadsdev.com moderator
Software consulting services including UBB.threads problem resolution / installs / upgrades / customization.

[This message was edited by Dave_L on August 25, 2003 at 07:30 AM.]


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)