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

[Scandal]

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?

[kh99]

You can do this query:

UPDATE user SET options = (options | (256 + 16))


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

[Scandal]

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?

[kh99]

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)

UPDATE user SET options = (options | 16)


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

2. I want to set the field "Time zone" for all users to "(GMT +2:00) Kaliningrad, South Africa, Cairo". What is the query?

I think it would be:

UPDATE user SET timezoneoffset = '2'

[Scandal]

Thank you very much! :D