Announcement

Collapse
No announcement yet.

How do I set the email options manually

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Leave a comment:


  • Jake Bunce
    replied
    That is in that thread:

    Originally posted by Jake Bunce
    Turn OFF a bit:
    UPDATE tablename SET fieldname = fieldname - # WHERE fieldname & #

    Leave a comment:


  • truthaddict
    replied
    Originally posted by Jake Bunce
    Same as the other queries, but the number is 256.
    Thanks Jake,
    now the last one how do I unset it?

    Leave a comment:


  • Jake Bunce
    replied
    Same as the other queries, but the number is 256.

    Leave a comment:


  • truthaddict
    replied
    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.
    Last edited by truthaddict; Mon 12 Sep '05, 12:54am.

    Leave a comment:


  • Jake Bunce
    replied
    Originally posted by truthaddict
    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.

    Leave a comment:


  • truthaddict
    replied
    Originally posted by 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.



    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?
    Last edited by truthaddict; Fri 9 Sep '05, 1:33am.

    Leave a comment:


  • Jake Bunce
    replied
    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.

    Originally posted by truthaddict
    Receive Admin Emails: Yes
    UPDATE user SET options = options + 16 WHERE NOT(options & 16)

    Originally posted by truthaddict
    Receive Private Messages: Yes
    UPDATE user SET options = options + 2048 WHERE NOT(options & 2048)

    Originally posted by truthaddict
    Send Notification Email When a Private Message is Received: Yes
    UPDATE user SET options = options + 4096 WHERE NOT(options & 4096)

    Originally posted by truthaddict
    Automatic Thread Subscription Mode to : Instant email notification
    UPDATE user SET autosubscribe = 1

    Leave a comment:


  • truthaddict
    started a topic How do I set the email options manually

    How do I set the email options manually

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X