UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support listing users signed on to a particular forum

[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.]