How-to disable the visitor message for all users

[Milado]

Hello

I want to disable the visitor message for all users by SQL query, then users who want to accept visitor messages can enable it again!

UPDATE user SET options = options - 8388608 WHERE options & 8388608

Is the previous query right?

Regards

[Jake Bunce]

That query looks correct. I have confirmed the bitfield value. Backup first to be safe.

[cosmicmind]

What would be the query to enable it for all users ? I imported a user database from another forum software and it appears all imported users have it disabled by default :(

[Jake Bunce]

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

[cosmicmind]

Thanks !

[Bryanb]

Is there anyway to do this within the admin control panel? Disable the Visitor Messaging? I'm rather SQL query "challenged". :rolleyes:

I'm having too many members using the Visitor Messaging thinking it's a private message. It's rather redundant when I have PMs enabled, Bloggs and User social groups.

If there is an easy way to shut this off, I'm all ears :D

[Wayne Luke]

You can disable visitor messages globally under vBulletin Options -> User Profile Options. Just uncheck it under "Enable User Profile Features".

[Bryanb]

I found it just as you were posting :o

Thanks!

Signed,

The Idiot :p