Recieve email from other members query please

[Davey-UK]

Could anyone please provide me with the sql query required to make all my members accept email from other members.

I know about the setting for new members, but i need to change the members option already in the database.
Cheers

[Marco van Herwaarden]

Are you really sure you want to do this? This might not be acceptable by your members as this is a privacy setting, and each user should decide for themself if they want to share their email address.

[Davey-UK]

Are you really sure you want to do this? This might not be acceptable by your members as this is a privacy setting, and each user should decide for themself if they want to share their email address.

Thanks for the reply.

Yes, im quite sure, as this is a school reunion website, so it is vital that users can contact each other.

Any ideas? :)

[Marco van Herwaarden]

Not test, but i am 99% sure it is this setting (make backup before running manual queries, maybe test this first on a testboard).

Show Email Address
On: UPDATE user SET options=options + 256 WHERE NOT(options & 256)
Off: UPDATE user SET options=options - 256 WHERE options & 256

[Davey-UK]

Nice one, thankyou....
I would have never worked that out! :confused:

By the way, if anyone uses this code, you must put your database prefix before the USER

eg vb_user

[nexialys]

prefix, oh prefix...

yeah, this is the query, BUT remember this will query properly if the default options are not changed...

[Davey-UK]

Not test, but i am 99% sure it is this setting (make backup before running manual queries, maybe test this first on a testboard).

Show Email Address
On: UPDATE user SET options=options + 256 WHERE NOT(options & 256)
Off: UPDATE user SET options=options - 256 WHERE options & 256

Can u please give the query to do exactly the same to the PM system

[Davey-UK]

Dont worry, ive found it!

That automatic query option is a fantastic way of quickly identifying a query.