[Forum] SQL query

[gnrx]

Hello.
I need activate for all users one option, is this (the attach to image).
I need set to yes.
Its possible by sql query?

Thanks and regards.

[Wayne Luke]

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

[gnrx]

Thanks Wayne Luke!

[gnrx]

Other query:
Change to all users save copy of send mps in folder send of mps to no?

Thanks and Happy New Year!

[Wayne Luke]

MP? Do you mean PM? Private Message?

Save a copy of sent messages (PMs)
On: UPDATE user SET options=options + 33554432 WHERE NOT(options & 33554432)
Off: UPDATE user SET options=options - 33554432 WHERE options & 33554432

[gnrx]

Thanks Wayne Luke.
Yes, MP its PM (Private Message) sorry for my english.
Again, thank you very much and Happy New Year!