Want to change thread subscription type for ALL MY threads

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • imahawki
    Member
    • Aug 2007
    • 89

    [Forum] Want to change thread subscription type for ALL MY threads

    Maybe a weird question but I want to change the subscription type from daily email to through my control panel only for EVERY thread I'm subscribed to. Problem is I want to do this on the forum that I operate and I'm subscribed to nearly 6,000 threads. I don't want to click through over 100 pages of threads and change the type of subscription.
  • BirdOPrey5
    Senior Member
    • Jul 2008
    • 9613
    • 5.6.3

    #2
    In the Admin CP -> Users -> Search for User -> (Username)

    In the drop down box at the top one of the options is to delete all subscriptions for the username.

    That is the right/supported way of doing it... the following is not supported-

    If you're looking for an SQL Query the table would be subscribethread but be sure you backup your database before attempting to manually edit your database.

    Code:
    UPDATE subscribethread SET emailupdate = 0 WHERE userid = 1
    assuming you want to change the settings for userid 1.

    emailupdate = 0, this will stop all email updates but keep you subscribed in the control panel... other options are 1, 2, and 3- corresponding to different email options, but I'm not sure which is immediate, daily, or weekly.

    Comment

    • Drakie
      Senior Member
      • Oct 2010
      • 140

      #3
      How do I disable subscriptions for ALL users on ALL threads?

      Would it be something like:
      UPDATE subscribethread SET emailupdate = 0 WHERE userid = * ????
      Can you believe this? The developers overlooked one of the most important features of a forum!
      VOTE HERE FOR:
      Alert/Notification when being quoted
      http://tracker.vbulletin.com/browse/VBIV-8606

      Comment

      • BirdOPrey5
        Senior Member
        • Jul 2008
        • 9613
        • 5.6.3

        #4
        The above query for all users would be:

        Code:
        UPDATE subscribethread SET emailupdate = 0
        As always we strongly recommend making a database backup before running any manual command

        Comment

        • gnrx
          Senior Member
          • Feb 2009
          • 241

          #5
          Originally posted by BirdOPrey5
          The above query for all users would be:

          Code:
          UPDATE subscribethread SET emailupdate = 0
          As always we strongly recommend making a database backup before running any manual command
          Sorry for bump this thread, but this thread is perfect for me.

          I execute this sql query for disable for all mails the mail notification every day (emailupdate = 0) but this not have notification in panel control, I try (with my user) all options, 0, 1, 2 and 3 but any.
          The iddea is, set to all users that, in the actual thread subscriptions, have notification of new reply in control panel (like with new mp).

          Its possible this?

          Thanks and regards!

          Comment

          • Trevor Hannant
            vBulletin Support
            • Aug 2002
            • 24326
            • 5.7.X

            #6
            Try the queries here:



            Also make sure you're including any table prefix when making the change if your tables have a prefix - and as Joe states above, take a full backup of your database before running ANY query directly against it.
            Vote for:

            - Admin Settable Paid Subscription Reminder Timeframe (vB6)
            - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

            Comment

            • gnrx
              Senior Member
              • Feb 2009
              • 241

              #7
              Thanks!
              This is just that I need.

              Comment

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