MyBB Community Forums

Has it worked?

I need to do this also but I'm affraid I will mess up the database.
My host is complaining and want to turn off my accounts because of thousands of mails going out from MyBB.

So I guess this query sets the default value to 0 instead of 1:

ALTER TABLE `mybb_users` CHANGE `pmnotify` `pmnotify` INT(1) NOT NULL DEFAULT '0'

But how can I change the value for all users to 0? Anyone know?

This should work:

UPDATE `mybb_users` SET `pmnotify` = '0'

Thank you Jordan. It seems like I hit the limit again today just within a few hours but I just ran your query and we'll see how I do tomorrow.