Announcement

Collapse
No announcement yet.

How do I set the email options manually

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

  • 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.

  • #2
    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

    Comment


    • #3
      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.

      Comment


      • #4
        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.

        Comment


        • #5
          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.

          Comment


          • #6
            Same as the other queries, but the number is 256.

            Comment


            • #7
              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?

              Comment


              • #8
                That is in that thread:

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

                Comment


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

                  Comment

                  widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                  Working...
                  X