[Forum] SQL Query to Change "Save a copy of sent messages in my Sent Items folder by default"

[mbecker]

I am trying to switch the "Save a copy of sent messages in my Sent Items folder by default" preference to "Yes" for all of my users, but I can't find a way to do it easily in the Usergroup Manager, and there is not a pre-defined SQL Query available.

I have found the following thread on the subject:

http://www.vbulletin.com/forum/showt...ivate-messages

but that only seems to apply to newly registered users. Is there a way to change this preference for everyone in the "Registered Users" usergroup?

[Trevor Hannant]

Try this:

UPDATE user SET options=options + 33554432 WHERE NOT(options & 33554432);

From http://www.vbulletin.com/forum/showt...tions-en-masse

[mbecker]

Will do, thanks.

I've bookmarked the linked post; it will definitely come in hand in the future.

[hugh_]

Try this:

UPDATE user SET options=options + 33554432 WHERE NOT(options & 33554432);

From http://www.vbulletin.com/forum/showt...tions-en-masse

Does this work with vBulletin 3.8.x?