Announcement

Collapse
No announcement yet.

Remove all thread subscriptions?

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

  • Remove all thread subscriptions?

    Is there a query that will bulk remove everyone's email notification subscriptions (not just reset the option)? I could have sworn I saw something about this and cannot find it anymore. Thanks .
    "I can't seem to bring myself to say, 'Well, I guess I'll be toddling along.'
    It isn't that I can't toddle. It's that I can't guess I'll toddle."

    --Robert Benchley (1889-1945)

  • #2
    Maybe this is what you are looking for.

    Admin Control Panel > Import & Maintenance > Execute SQL Query > Automatic Query

    On-line manual with more details: Execute SQL Query

    Comment


    • #3
      Thanks Floris. However, unless I'm just misreading them, there aren't any queries to actually blanket strip existing email notifications. Maybe it was over at vb.org I saw this.
      "I can't seem to bring myself to say, 'Well, I guess I'll be toddling along.'
      It isn't that I can't toddle. It's that I can't guess I'll toddle."

      --Robert Benchley (1889-1945)

      Comment


      • #4
        Hm, yeah. This is probably for future and current preference, but won't do already subscribed ones. Sorry.

        (I'll ask a friend if he knows)

        Comment


        • #5
          Originally posted by welo
          Is there a query that will bulk remove everyone's email notification subscriptions (not just reset the option)? I could have sworn I saw something about this and cannot find it anymore. Thanks .
          Backup your database, then run this query:

          DELETE FROM subscribethread;

          This will remove ALL thread subscriptions.
          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


          • #6
            in vB2 you could prune all subscribed threads, has this disappeared?

            Comment


            • #7
              That was never a feature in vB2.
              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


              • #8
                It so was, from the admin panel you were able to unsubscribe everyone from their subscribed threads!

                Comment


                • #9
                  Originally posted by Steve Machol
                  Backup your database, then run this query:

                  DELETE FROM subscribethread;

                  This will remove ALL thread subscriptions.
                  So basically to remove all subscriptions I just need to empty the prefix_subscribethread table? I thought of that and wasn't sure what else I might screw up if I did it.
                  "I can't seem to bring myself to say, 'Well, I guess I'll be toddling along.'
                  It isn't that I can't toddle. It's that I can't guess I'll toddle."

                  --Robert Benchley (1889-1945)

                  Comment


                  • #10
                    Originally posted by Deep Blue
                    It so was, from the admin panel you were able to unsubscribe everyone from their subscribed threads!
                    You are right. Here are the different options.

                    vB3:
                    Unsubscribe All Users from Specific Threads
                    Unsubscribe All Threads from Specific Users

                    vB2:
                    Unsubscribe users from specific threads
                    Mass unsubscribe users from threads (by date)
                    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

                    Loading...
                    Working...
                    X