How to override the mailing option?

[Pilot]

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

[Steve Machol]

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>

[Pilot]

the column allowmail is not valid.

Did you mean "adminemail" perhaps?

[Steve Machol]

Nope - 'allowmail' is it in 2.2.1. You must be running a older version in which case 'adminemail' is probably the correct column.

[Pilot]

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.

[Steve Machol]

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.

[Pilot]

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.

[Chen]

$allowmail becomes $adminemail somewhere in member.php (and register.php):

  $adminemail=iif($allowmail=="yes",1,0);

and the table field is adminemail.

[Steve Machol]

Originally posted by FireFly
$allowmail becomes $adminemail somewhere in member.php (and register.php):

  $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?

[Chen]

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!

[glenv]

So for ver 2.7 do we run:

UPDATE user SET allowmail=1

or

UPDATE user SET adminemail=1

[Steve Machol]

UPDATE user SET adminemail=1;