Have a look at Changing user options defaults and values. It is for 3.0 but should get you started.rajpb wrote: ↑Fri Nov 22, 2019 9:22 amIn the user profile it is possible to set how to be informed about each type of notification (on the forum and by email). In what table are these settings stored? This is not in phpbb_users.
Why I need it?
Many people set up notifications by email and later stop looking at the forum. Now forum sends a large number of unnecessary emails and now is on spam list. Unfortunately, it is not possible for the administrator to change these settings globally and I need change them in the database.
This extension will not do what the OP is asking for - it only works on new registrations, whereas the OP wants to be able to change the settings for existing registrations (something that personally should not be done)
I wasn't giving a solution to the OP, just 2 links with which the OP could get a good grip on how notifications are stored in the database, specifically in reply to :
There isn't ?