The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
![]()
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 |
#2
|
|||
|
|||
![]()
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.
|
#3
|
||||
|
||||
![]() Quote:
Yes, im quite sure, as this is a school reunion website, so it is vital that users can contact each other. Any ideas? ![]() |
#4
|
|||
|
|||
![]()
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 |
#5
|
||||
|
||||
![]()
Nice one, thankyou....
I would have never worked that out! ![]() By the way, if anyone uses this code, you must put your database prefix before the USER eg vb_user |
#6
|
|||
|
|||
![]()
prefix, oh prefix...
yeah, this is the query, BUT remember this will query properly if the default options are not changed... |
#7
|
||||
|
||||
![]() Quote:
|
#8
|
||||
|
||||
![]()
Dont worry, ive found it!
That automatic query option is a fantastic way of quickly identifying a query. |
![]() |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|