Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [How To?] SQL query for enable PM
#1
Not Solved
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]


Thanks.
Reply
#2
Not Solved
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)