Question Query to uncheck "Enable Emails"

[tommyxv]

I would like to switch the 'Disable Emails' to 'Enable Emails' so all new members don't have to make the change anymore. Is there a query I can run that will uncheck 'enable emails' after I switch it over?

I don't want all the members who have checked "disable emails" to start getting emails now.

Thanks!

 

[Fillip H.]

Try this:

UPDATE user SET dbtech_thanks_settings2 = dbtech_thanks_settings2 - 2 WHERE (dbtech_thanks_settings2 & 2)

Remember to add your table prefix.

 

[tommyxv]

Perfect thanks!

 

[Fillip H.]

No problem

If you have any further questions or issues, please feel free to start a new support ticket.