XF 2.2 Disable "and receive email notifications" by default

[Compi]

The emails my forum can send hourly are limited, I want to disable the checkmark to be ticked by default when creating a post. It should still be clickable and working if a user decides to want emails

 

[Mr Lucky]

For new users registration you can set the defaults in ACP > Options > User registration

yoursite.com/admin.php?options/groups/usersAndRegistration/



For existing you need to do a database query.

It's a long time since I did this, try on a test froum before trusting I have this 100% correct!

UPDATE `xf_user_option`
SET `interaction_watch_state` = COALESCE(NULLIF(interaction_watch_state,''), 'watch_no_email')

UPDATE `xf_user_option`
SET `creation_watch_state` = COALESCE(NULLIF(creation_watch_state,''), 'watch_no_email')

 

[Compi]

thanks a lot!

 

[Mr Lucky]

You're welcome, but do test that query before doing it live!

 

[orex]

Can someone please confirm if the query actually works and safe to execute. Doesn't have a test board to try it first.

 

[JordanH]

Tested, doesn't seem to work.