Announcement

Collapse
No announcement yet.

How to override the mailing option?

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

  • How to override the mailing option?

    Can you give me the query to force all my users to accept VB mailings from the site?

    That is - to set the option as if they had said "yes" when registering?

    What's the easiest way to remove that option on registration so that all users will receive mailings?

    It would be useful for the VB "send mail" option to optionally allow override of the "no mailing" setting.

    Thanks

  • #2
    Back up your database first! Then run this query:

    UPDATE user SET allowmail=1

    Then you can remove this section in the modifyoptions , registeradult and registercoppa templates:

    <tr>
    <td bgcolor="{secondaltcolor}"><normalfont><b>Allow Bulletin Board Administrators and Moderators To Send You Email Notices?</b></normalfont></td>
    <td bgcolor="{secondaltcolor}"><normalfont>
    <input type="radio" name="allowmail" value="yes" $allowmailchecked> yes
    <input type="radio" name="allowmail" value="no" $allowmailnotchecked> no
    </normalfont></td>
    </tr>
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      the column allowmail is not valid.

      Did you mean "adminemail" perhaps?

      Comment


      • #4
        Nope - 'allowmail' is it in 2.2.1. You must be running a older version in which case 'adminemail' is probably the correct column.
        Last edited by Steve Machol; Wed 9 Jan '02, 4:35pm.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Interesting because I have 2.2.1 and looking at the user table with PHPMyADMIN it seems to have the column adminemail and not allowemail.

          I upgraded through all the VB versions starting at 2.0.3 following the instructions.

          When I ran your suggested query, it did not work, when I changed the column name to adminemail it did run OK.

          Comment


          • #6
            Interesting. I also have 'adminemail' in my tables, but this doesn't exist in my templates. However my 2.2.1 templates definitely say 'allowmail' as per the quote above.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              The "mail users" function looked at adminemail because the numbers not
              mailed match the number that were changed by the SQL query to that column.

              Comment


              • #8
                $allowmail becomes $adminemail somewhere in member.php (and register.php):
                Code:
                  $adminemail=iif($allowmail=="yes",1,0);
                and the table field is adminemail.
                Chen Avinadav
                Better to remain silent and be thought a fool than to speak out and remove all doubt.

                גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

                Comment


                • #9
                  Originally posted by FireFly
                  $allowmail becomes $adminemail somewhere in member.php (and register.php):
                  Code:
                    $adminemail=iif($allowmail=="yes",1,0);
                  and the table field is adminemail.
                  Strange. What's the purpose of doing it this way as opposed to just specifying $adminemail to begin with?
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment


                  • #10
                    Originally posted by smachol
                    Strange. What's the purpose of doing it this way as opposed to just specifying $adminemail to begin with?
                    Don't ask me, I'm just the messenger!
                    Chen Avinadav
                    Better to remain silent and be thought a fool than to speak out and remove all doubt.

                    גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

                    Comment


                    • #11
                      So for ver 2.7 do we run:

                      UPDATE user SET allowmail=1

                      or

                      UPDATE user SET adminemail=1

                      Comment


                      • #12
                        UPDATE user SET adminemail=1;
                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment

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