Announcement

Collapse
No announcement yet.

What members are subscribed to a thread?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Samir
    replied
    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?

    Leave a comment:


  • flynnibus
    replied
    Originally posted by Steve Machol
    I don't know how to do this. Maybe someone else will know.
    I guess I'll look at the table and see how the subscriptions are stored..

    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?

    Leave a comment:


  • Steve Machol
    replied
    I don't know how to do this. Maybe someone else will know.

    Leave a comment:


  • flynnibus
    replied
    Originally posted by Steve Machol
    There is no built-in way to do this. You could run this query:

    SELECT userid, threadid FROM subscribethread WHERE threadid='xxx';
    Steve,

    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?

    Leave a comment:


  • arob42
    replied
    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!

    Leave a comment:


  • Steve Machol
    replied
    There is no built-in way to do this. You could run this query:

    SELECT userid, threadid FROM subscribethread WHERE threadid='xxx';

    Leave a comment:


  • arob42
    started a topic What members are subscribed to a thread?

    What members are subscribed to a thread?

    How can I determine what members are subscribed to a particular thread.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X