MyBB Community Forums

Mybb Change Default Subscription Method

UPDATE `mybb_users` SET `subscriptionmethod` = '#';


Do you see that #? Change it to one of the following:
- Change # to 0 to set Subscription Method to "Do not subscribe"
- Change # to 1 to set Subscription Method to "No email notification"
- Change # to 2 to set Subscription Method to "Instant email notification"

How to run these codes over ssh?

user@box> mysql -uroot -p
mysql> use mybbdatabase;
mysql> UPDATE `mybb_users` SET `subscriptionmethod` = '#';
mysql> exit

That should work but it depends on your environment.

thanks working! use lines in config.php

So how can we do to only a specific group id.

Do you have any idea?

So how can we do to only a specific group id.

Quote:UPDATE mybb_users SET subscriptionmethod = '#' WHERE usergroup = x;

I advise you read up on SQL. You can easily find the answer to things like this via Google.

^ there is a mistake [b]gid[/b] should be [b]usergroup[/b]

(2013-06-06, 12:33 PM).m. Wrote: [ -> ]^ there is a mistake [b]gid[/b] should be [b]usergroup[/b]

how fix this, some user option not change.