MyBB Community Forums

Full Version: SQL query for enable PM
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.

[Image: 0d2d19ae9e326737e8392b956300886c.png]

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)

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

As for the query you run.

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

Should work.