[Forum] Receive Friend Request Notification

[stijndevreede]

Hello,

For all my 1700 users the setting of recieving an email when a friend request is sent is put on. This is very annoying and is it possible to switch the setting of in the database? Or maybe a switch to put it master of in the ACP. In the database I couldn't find it, maybe someone knows?

[i3lack]

Run this query:

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

This should turn it off for all members

[stijndevreede]

Can I find the definition of the '2097152' code things?

Thanks in advance! now my server is out of service but I will try in 10 minutes

[i3lack]

This is a query it needs to be ran in the vbulletin admin cp or in your phpmyadmin forums table.

[stijndevreede]

It done the inverse, now all users 'Receive Friend Request Notification' has turned on to 'yes'
(it changed 3 records, the ones who switched it off)

[i3lack]

i wish i knew then bud. I have looked everywhere for a fix even downloaded the sql database to fiind i cant. Sorry.

[i3lack]

Make sure you backup your database and try this last one

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

it should work!

Just tested it worked for me

[stijndevreede]

Make sure you backup your database and try this last one

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

it should work!

Just tested it worked for me

It didn't work... No rows were editted

[stijndevreede]

I fixed it:

UPDATE user
SET options = 43011287
WHERE options = 11552855