What members are subscribed to a thread?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • arob42
    Member
    • Dec 2004
    • 73

    What members are subscribed to a thread?

    How can I determine what members are subscribed to a particular thread.
    "I'm going on a TOE Quest"
    Theory of Everything - www.toequest.com
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    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.


    Comment

    • arob42
      Member
      • Dec 2004
      • 73

      #3
      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!
      "I'm going on a TOE Quest"
      Theory of Everything - www.toequest.com

      Comment

      • flynnibus
        Senior Member
        • Aug 2005
        • 177

        #4
        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?

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          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

          • flynnibus
            Senior Member
            • Aug 2005
            • 177

            #6
            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?

            Comment

            • Samir
              Senior Member
              • Nov 2003
              • 287
              • 3.8.x

              #7
              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.com

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...