How can I determine what members are subscribed to a particular thread.
What members are subscribed to a thread?
Collapse
X
-
What members are subscribed to a thread?
Tags: None -
There is no built-in way to do this. You could run this query:
SELECT userid, threadid FROM subscribethread WHERE threadid='xxx';Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
-
thanks
Thanks Steve! That was just what I needed. I changed the query a little to see who was subscribed to my "News and Announcements" forum and found it was 0! In fact only 8 members out 700 were subscribed to any thread/forum at all! So I posted an announcement on how to subscribe to threads and forums. I had assumed that many more than 8 were subscribed. This was a big help. Thanks again for your suggestion!Comment
-
Originally posted by Steve MacholThere is no built-in way to do this. You could run this query:
SELECT userid, threadid FROM subscribethread WHERE threadid='xxx';
in the same fashion is there anyway to force all users to be subscribed to a forum?
I assume I can write an INSERT statement to put the subscription in.. but I'd have to write a script to check for it and insert it and run it periodically for that to work for new users. Any way through defaults to set this?Comment
-
I don't know how to do this. Maybe someone else will know.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Originally posted by Steve MacholI don't know how to do this. Maybe someone else will know.
My goal is to notify all users via email whenever someone posts in the 'important' forum. Any other suggestions on how to do that? Anyone?Comment
-
I hate to bump an older thread, but I too am trying to find out who is subscribed to a particular forum. Someone modified the query for the thread, but between the newer versions of vb and the change from threads to forums, I don't want to risk tinkering with SQL. Anyone know the query?Huntsville's Premiere Car and Bike e-magazine: www.huntsvillecarscene.comComment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment