Set "Receive Email from Admins/Members" to ticked for all members
 

In User Control Panel > Edit Options, there are the following two options with "tick" box:
Receive Email from Administrators
Receive Email from Other Members

I want to set these boxes to "ticked" (yes) for all members. Is there any option to Admin CP to do it or something query that I must run to set it?

You can do this query:


I've tried it, but you might want to test it first on one user by adding "WHERE userid = X" to the query.

Thanks in advance, it works fine on my test forum!

Two last similar question:
1. What is the query to change only the "Receive Email from Administrators" to ticked for all members? (i want to decide)
2. I want to set the field "Time zone" for all users to "(GMT +2:00) Kaliningrad, South Africa, Cairo". What is the query?

and you can probably guess what the query for the other one would be :).

I think it would be:

Thank you very much! :D