How do I set the email options manually

[truthaddict]

I am using my own registration page in which I have included selective entries like username,password,email,first name and last name, once the values are inserted in user table I want to set
Receive Admin Emails: Yes
Receive Private Messages: Yes
Send Notification Email When a Private Message is Received: Yes
Automatic Thread Subscription Mode to : Instant email notification

please let me know how do I set these values using mysql queries.

[Jake Bunce]

See this thread for a detailed explanation. These queries will update all user records unless you add something like "AND userid = X" on the end, where X is the userid of the new user.

Receive Admin Emails: Yes

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

Receive Private Messages: Yes

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

Send Notification Email When a Private Message is Received: Yes

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

Automatic Thread Subscription Mode to : Instant email notification

UPDATE user SET autosubscribe = 1

[truthaddict]

See this thread for a detailed explanation. These queries will update all user records unless you add something like "AND userid = X" on the end, where X is the userid of the new user.



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



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



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



UPDATE user SET autosubscribe = 1

Thanks Jake,
it works fine . It is showing all the values correct in the forum admin panel
Receive Admin Emails: Yes
Receive Private Messages: Yes
Send Notification EmailWhen a Private Message is Received: Yes
Automatic Thread Subscription Mode to : Instant email notification
and the option value set in table is 6175.
but still its not sending the Welcome Email to the registred user, am I wrong any where?

[Jake Bunce]

but still its not sending the Welcome Email to the registred user, am I wrong any where?

This is from your custom script? The stock registration script has PHP code to send the welcome email. You would need to duplicate this. For help with something like this you should post on www.vbulletin.org.

[truthaddict]

Hello Jake,
Thanks a lot for this information. I need to set/unset one more field in the user table which is "Receive Email from Other Members" how do I set it using sql query or is there in option chart so that I can see the option value for the each Email Option there.

Thanks again.

[Jake Bunce]

Same as the other queries, but the number is 256.

[truthaddict]

Same as the other queries, but the number is 256.

Thanks Jake,

now the last one how do I unset it?

[Jake Bunce]

That is in that thread:

Turn OFF a bit:
UPDATE tablename SET fieldname = fieldname - # WHERE fieldname & #

[truthaddict]

ohh sorry, I missed out that.
Thanks a lot for your help Jake.