Skip to content


phpBB – force your users to subscribe to thread by default

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.

Posted in phpBB, web development.


0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.



Some HTML is OK

or, reply to this post via trackback.