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

[Devtard]

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?

[AliMadkour]

You'll need to run a this manual query

UPDATE user SET autosubscribe = -1 WHERE usergroupid ='[B]GROUPID[/B]'

* Don't forget to add table prefix if you use it,
Replace GROUPID with usergroup id,

[Devtard]

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?

[AliMadkour]

Yes,
-1 means no subscriptions
0 means subscribe with no notification

[Devtard]

Cool, thanks.

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

[AliMadkour]

use that query

DELETE `subscribethread` FROM `subscribethread`
LEFT JOIN `user` ON `subscribethread`.`userid` = `user`.`userid`
WHERE `subscribethread`.`emailupdate` <> '0' AND `user`.`usergroupid` = '[B]GROUPID[/B]'

* Don't forget to add table prefix if you use it,
Replace GROUPID with usergroup id,

[Devtard]

Thank you very much!

[AliMadkour]

You're welcome