Mass update "Copies of sent messages"

[ibaker]

Can someone advise what the sql would be to mass update all users "Save a copy of sent messages in my Sent Items folder by default" to TRUE

Thanks!

[Jake Bunce]

There is no setting or preference for that. You would have to edit the template itself to make that box checked to begin with:

Admin CP -> Styles & Templates -> Style Manager -> « » -> Private Message Templates -> pm_newpm

This requires some HTML ability.

[ibaker]

Thanks Jake
I migrated the data from a 3.7 install to a 3.8 one and this field seems not to have come across causing over 3,000 users to not have this check box indicating true

[Lats]

Try this...

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

[ibaker]

Thanks Lats - worked great

[Jake Bunce]

Oh wow, there is a preference:

User CP -> Edit Options -> Save a copy of sent messages in my Sent Items folder by default