It is really annoying when you have a forum where you often have members who come and never return, even to check their own topics. A partial solution for this is to run the following query, which will change all users preferences so that they have topic reply notification enabled by default:
UPDATE [your phpBB database name].[the phpBB table prefix]users SET user_notify=1 WHERE [the phpBB table prefix]users.user_id >=53
NB: replace 53 with the ID of the first real member (this is to avoid modifying settings for bot users).
This was tested with phpBB 3.0.1. The most efficient way to do this would be to run this query everytime someone signs up (include the code somewhere on the sign up page…), or to a lesser degree, run it regularly with a cron job.



Thank you for this, I will give it a go. There’s actually a workaround so this script won’t have to be run each time new users join.
http://www.phpbb.com/community/viewtopic.php?f=64&t=543143
open includes/function_user.php
find ‘user_notify’ => 0,
change to ‘user_notify’ => 1,