This is not possible natively in phpBB, you have to go through an extension.Hervé wrote: Fri Jan 31, 2025 10:46 am As an administrator I would like to modify the preferences of another member : how to ?
Code: Select all
SET @user_id = 123456;
UPDATE phpbb_user_notifications SET notify = 0 WHERE user_id = @user_id AND method = 'notification.method.email';
UPDATE phpbb_users SET user_allow_viewemail = 0 WHERE user_id = @user_id;
SET @user_id = 123456
to the user ID. This also sets there email to hidden if they have it viewable.WHERE user_id = @user_id AND method = 'notification.method.email'