Recieve email from other members query please
 

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

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? :)

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

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

prefix, oh prefix...

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

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

Dont worry, ive found it!

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