Who is subscribed to what Forum/Threads

[vanye]

tubedogg was kind enough to reply to my query below on the vbulletin.com Forums but I'm afraid being a newbie to all this when he says 'simply display the results' or indeed where to add the query I am at a loss. I can claim to having added two other hacks (whoooeeee!!!) but its stil early days. Help greatly appreciated.

Original Query: One of the users of my board has asked a very good question to which I do not have the answer & cannot find anything relating to it in the manual.

He wants to ensure that his communications are getting to his audience and thefore would like to know:-

How he can find a list of the users who have subscribed to

- a Forum
- a Thread

He also has some more advanced wishes, like which Threads have been read by which users but this really does sound like wishes, so lets stick with the first question.

Can this be done? Is it planned for 3.0 or should I look for a hack?

tubedoggs reply: There is no way to do this directly from the Admin CP but it wouldn't take much to write up a quick little script to select stuff from the subscribethread and subscribeforum tables...

SELECT user.username,subscribethread.userid FROM user,subscribethread WHERE user.userid=subscribethread.userid;
SELECT user.username,subscribeforum.userid FROM user,subscribeforum WHERE user.userid=subscribeforum.userid;

and then just display the results.

This is not planned for v3, I'm pretty sure, but you can make a suggestion in the Suggestions forum for it.