Notifications by email - where are they in database?

Need some custom code changes to the phpBB core simple enough that you feel doesn't require an extension? Then post your request here so that community members can provide some assistance.

NOTE: NO OFFICIAL SUPPORT IS PROVIDED IN THIS SUB-FORUM
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: NO OFFICIAL SUPPORT IS PROVIDED IN THIS SUB-FORUM
Post Reply
rajpb
Registered User
Posts: 31
Joined: Sat Mar 24, 2018 11:12 pm

Notifications by email - where are they in database?

Post by rajpb » Fri Nov 22, 2019 9:22 am

In 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.

Image

User avatar
david63
Registered User
Posts: 16798
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Notifications by email - where are they in database?

Post by david63 » Fri Nov 22, 2019 10:50 am

rajpb wrote:
Fri Nov 22, 2019 9:22 am
This is not in phpbb_users.
Yes it is - user_options
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
warmweer
Registered User
Posts: 3165
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Notifications by email - where are they in database?

Post by warmweer » Fri Nov 22, 2019 2:40 pm

rajpb wrote:
Fri Nov 22, 2019 9:22 am
In 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.
Have a look at Changing user options defaults and values. It is for 3.0 but should get you started.
Also there's an extension being developed [3.2][RC] New User Default Settings
The year is 2192. The British Prime Minister visits Brussels to ask for an extension of the Brexit deadline. No one remembers where this tradition originated, but every year it attracts many tourists from all over the world.

User avatar
david63
Registered User
Posts: 16798
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Notifications by email - where are they in database?

Post by david63 » Fri Nov 22, 2019 2:50 pm

warmweer wrote:
Fri Nov 22, 2019 2:40 pm
Also there's an extension being developed [3.2][RC] New User Default Settings
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)

In this situation, and if it was my board, then I would make these users non active.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
warmweer
Registered User
Posts: 3165
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Notifications by email - where are they in database?

Post by warmweer » Fri Nov 22, 2019 3:01 pm

david63 wrote:
Fri Nov 22, 2019 2:50 pm
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 :
rajpb wrote:
Fri Nov 22, 2019 9:22 am
In what table are these settings stored?
The year is 2192. The British Prime Minister visits Brussels to ask for an extension of the Brexit deadline. No one remembers where this tradition originated, but every year it attracts many tourists from all over the world.

rajpb
Registered User
Posts: 31
Joined: Sat Mar 24, 2018 11:12 pm

Re: Notifications by email - where are they in database?

Post by rajpb » Mon Nov 25, 2019 6:50 am

Table I ame looking for is phpbb_user_notifications.
But info about defaults is usefull too. Thanks all.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66898
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Notifications by email - where are they in database?

Post by Lumpy Burgertushie » Mon Nov 25, 2019 4:29 pm

there is no table with the title of user_notifications. sorry about the mistake.
there is one titled user_options. that includes the notification settings the user has set for themselves.

I have not idea how you would do what you want with the info in that table and personally it seems like a lot of trouble to solve your problem that way.
also, I assume there are many many other board users that have this same situation without it causing the problems you are describing so I wonder if there is something else causing it.
luck,
robert
Last edited by Lumpy Burgertushie on Mon Nov 25, 2019 5:54 pm, edited 1 time in total.
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51889
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Notifications by email - where are they in database?

Post by Brf » Mon Nov 25, 2019 5:45 pm

Lumpy Burgertushie wrote:
Mon Nov 25, 2019 4:29 pm
there is no table with the title of user_notifications.
There isn't ?
Attachments
user_notif.jpg

User avatar
Lumpy Burgertushie
Registered User
Posts: 66898
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Notifications by email - where are they in database?

Post by Lumpy Burgertushie » Mon Nov 25, 2019 5:52 pm

well, stupid me. I looked under notifications but did not bother to look under user

sorry for the incorrect information.


I will edit.

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Post Reply

Return to “phpBB Custom Coding”