MyBB Community Forums

All my new users have the box unticked to receive private messages from other users.

What is the SQL query to enable all my users and future signups to have Private messages ENABLED SENT FROM OTHER USERS.




Thanks.

In your member_register template the receivepms field should look like this. (Make sure the value is set to 1 just like in the query)

<tr>
<td valign="top" width="1"><input type="checkbox" class="checkbox" name="receivepms" id="receivepms" value="1" {$receivepmscheck} /></td>
<td valign="top"><span class="smalltext"><label for="receivepms">{$lang->receive_pms}</label></span></td>
</tr>

As for the query you run.

UPDATE `mybb_users` SET `receivepms` = '1' WHERE `receivepms` = '0' 

Should work.