I just tried it but it hasn't made any difference, I made a test account after making the changes and that bottom box is still unchecked for email notifications.....stevemaury wrote:https://www.phpbb.com/support/docs/en/3 ... nd-values/
Code: Select all
SELECT user_notify_type FROM phpbb_users
Code: Select all
UPDATE phpbb_users SET user_notify = 1
Code: Select all
'user_notify' => 1,
'user_notify_pm' => 1,
'user_notify_type' => NOTIFY_EMAIL,
'user_allow_pm' => 1,
'user_allow_viewonline' => 1,
'user_allow_viewemail' => 1,
'user_allow_massemail' => 1,
Code: Select all
'user_notify' => 1,
'user_notify_pm' => 1,
'user_notify_type' => NOTIFY_BOTH,
'user_allow_pm' => 1,
'user_allow_viewonline' => 1,
'user_allow_viewemail' => 1,
'user_allow_massemail' => 1,
Code: Select all
UPDATE phpbb_users SET user_notify = 1
NOTIFY_BOTH is not correct, that is for both email and XMPP notifications.Bullseye! wrote:This what it looked like after I made the edits:Code: Select all
'user_notify' => 1, 'user_notify_pm' => 1, 'user_notify_type' => NOTIFY_BOTH, 'user_allow_pm' => 1, 'user_allow_viewonline' => 1, 'user_allow_viewemail' => 1, 'user_allow_massemail' => 1,
Because it is the wrong query. Your users may be upset that you have now subscribed them, by default, to any topics they post in.Bullseye! wrote:I made the edit again ran this query:
and it has still made no differenceCode: Select all
UPDATE phpbb_users SET user_notify = 1
Code: Select all
UPDATE phpbb_user_notifications SET notify = 1 WHERE item_type = 'notification.type.pm' AND method = 'notification.method.email'
They like to be notified about replies to topics they have posted in, they can always unsubscribe/opt out anywayOyabun1 wrote:NOTIFY_BOTH is not correct, that is for both email and XMPP notifications.Bullseye! wrote:This what it looked like after I made the edits:Code: Select all
'user_notify' => 1, 'user_notify_pm' => 1, 'user_notify_type' => NOTIFY_BOTH, 'user_allow_pm' => 1, 'user_allow_viewonline' => 1, 'user_allow_viewemail' => 1, 'user_allow_massemail' => 1,
Because it is the wrong query. Your users may be upset that you have now subscribed them, by default, to any topics they post in.Bullseye! wrote:I made the edit again ran this query:
and it has still made no differenceCode: Select all
UPDATE phpbb_users SET user_notify = 1
The query to enable email notifications for PMs for existing members would be:Code: Select all
UPDATE phpbb_user_notifications SET notify = 1 WHERE item_type = 'notification.type.pm' AND method = 'notification.method.email'