sql query to Uncheck / disable to all users email notification in her control panel

[gnrx]

Hi,

All users of my forum, actually they have active default the option email notification when have new reply.
When I was installed my forum, I was configured for, all new users have this option enabled.

After a few years with my forum, I want change this option for all old users.

How made this change for all my old users?

Thank you very much!

PD: Sorry if I not explained very well

[z3r0]

Assuming you are a super admin (can run queries in your config.php) then

admincp -> left column near the bottom "Mantenance section" -> Execute SQL Query -> From the drop down set to "Subscribe with no notification" or "Do not subscribe" -> press continue

This only changes the setting going forward and any threads they are currently subscribed to will be unaffected.

[gnrx]

Hi,
Thank you very much for your help.
All fine.

Again, thank you!