Announcement

Collapse
No announcement yet.

How to change default thread subscription mode for all users an a particular usergroup

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

  • How to change default thread subscription mode for all users an a particular usergroup

    There is a tool for changing subscription mode for all users (AdminCP -> Maintenance -> Execute SQL Query). But I want to change it only for users who are in a certain usergroup. How to do that?

  • #2
    You'll need to run a this manual query
    Code:
    UPDATE user SET autosubscribe = -1 WHERE usergroupid ='GROUPID'
    * Don't forget to add table prefix if you use it,
    Replace GROUPID with usergroup id,


    Former vBulletin Support Staff
    Need Help?, Or P.M. Me

    Comment


    • #3
      What's the difference between "autosubscribe = -1" and "autosubscribe = 0"? I googled and found out that the first option stands for "no subsciption" and the other one means "subscribe without no notification". Isn't it the same thing in vB 4.2?

      Comment


      • #4
        Yes,
        -1 means no subscriptions
        0 means subscribe with no notification

        Former vBulletin Support Staff
        Need Help?, Or P.M. Me

        Comment


        • #5
          Cool, thanks.

          Also, do you know how to delete all already existing subscriptions for users in a certain usergroup?

          Comment


          • #6
            use that query
            Code:
            DELETE `subscribethread` FROM `subscribethread`
            LEFT JOIN `user` ON `subscribethread`.`userid` = `user`.`userid`
            WHERE `subscribethread`.`emailupdate` <> '0' AND `user`.`usergroupid` = 'GROUPID'
            * Don't forget to add table prefix if you use it,
            Replace GROUPID with usergroup id,

            Former vBulletin Support Staff
            Need Help?, Or P.M. Me

            Comment


            • #7
              Thank you very much!

              Comment


              • #8
                You're welcome

                Former vBulletin Support Staff
                Need Help?, Or P.M. Me

                Comment

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