PDA

View Full Version : SQL for setting all visitor messages to yes?


Outlaw Mantis
08-06-2016, 06:08 PM
I noticed a lot of accounts have visitor messaging disabled for some reason. Do you have a query I can execute to change the setting to yes (yes for enable) for all users? Thanks!

MarkFL
08-06-2016, 07:03 PM
Try this query:

UPDATE `user` SET `options` = `options` | 8388608

Outlaw Mantis
08-07-2016, 09:09 AM
Works great. Thanks. :D