ctml Great idea! Thanks for the tip. 👏
ctml Of course that would overwrite any preferences currently set by the users, but they can always go back and disable them again if needed.
Yes, that's my thinking, I wouldn't usually be inclined to alter everyone's personal preferences, if it wasn't for so many of our users commenting that they're missing posts and expecting email notifications but haven't worked out how to set them themselves! I've got a growing push for our community to be moved to Slack, but this should settle things down until I can work out a true push notification solution.
FYI, if anyone needs to do something similar, you can't run a SQL query within a table that you're updating. There's a cheeky workaround as follows:
UPDATE users
SET preferences = (SELECT * FROM (SELECT preferences FROM users WHERE username = 'troymccann') as t)
WHERE username != 'troymccann'
