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?
How to change default thread subscription mode for all users an a particular usergroup
Collapse
X
-
You'll need to run a this manual query
Code:UPDATE user SET autosubscribe = -1 WHERE usergroupid ='[B]GROUPID[/B]'
Replace GROUPID with usergroup id,
👍 1 -
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
-
Yes,
-1 means no subscriptions
0 means subscribe with no notificationComment
-
use that query
Code:DELETE `subscribethread` FROM `subscribethread` LEFT JOIN `user` ON `subscribethread`.`userid` = `user`.`userid` WHERE `subscribethread`.`emailupdate` <> '0' AND `user`.`usergroupid` = '[B]GROUPID[/B]'
Replace GROUPID with usergroup id,
👍 1Comment
-
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment