There is no actual file that contains a list of email addresses that your board software uses for contacting the registered users in your forums. When a user selects in their preferences to receive emails when regestering under "Receive Administrator Emails" then this is what is used to determine if they get an email from your message system.
This allows for birthday email, mass emails from selected users under the member Managament search feature, and watched forums and topics as well as private message email alerts.
There is no actual file that contains a list of email addresses that your board software uses for contacting the registered users in your forums. When a user selects in their preferences to receive emails when regestering under "Receive Administrator Emails" then this is what is used to determine if they get an email from your message system.
This allows for birthday email, mass emails from selected users under the member Managament search feature, and watched forums and topics as well as private message email alerts.
Hi,
I am aware of this, but I would like to be able to do a mass edit on the main email list file. Is there a main file that stores the email list? And where is it, in what folder?
I would like to be able to do a mass edit on the main email list file. Is there a main file that stores the email list? And where is it, in what folder?
The answer is that the there is no file or folder which contains email addresses.
The emails addresses are stored in a database table ubbt_USER_PROFILE >> USER_REAL_EMAIL -- the address all forum communication is done with. ubbt_USER_PROFILE >> USER_DISPLAY_EMAIL -- the address users display on their profile, if any.
see attached screenshot.
---
If you just want to create a list for mailing-mailing your users, go to 1) Control Panel > Member Management 2) enter your search/filter OR leave blank. press [Submit] 3a) select "Email" from the Action 3b) select either "Selected" or "All" results 4) from the email options page, choose to "Export" or "Send Email Directly". press [Generate Emails]
---
If all you want to do it just EDIT a user's email prefs 1) Control Panel > Database Tools > SQL Command
Query the DB to see how many members will allow the Admin to send them bulk emails. SELECT COUNT(*) FROM ubbt_USER_PROFILE WHERE USER_ACCEPT_ADMIN_EMAILS='On'
-OR-
Allow all members to receive email from admins. UPDATE ubbt_USER_PROFILE SET USER_ACCEPT_ADMIN_EMAILS= 'On' WHERE USER_ID > 1
Turn OFF all members to receive email from admins. UPDATE ubbt_USER_PROFILE SET USER_ACCEPT_ADMIN_EMAILS = NULL WHERE USER_ID > 1
-OR-
Disable Emails to users when an item on their Watch List is updated (new posts/new replies) UPDATE ubbt_USER_PROFILE SET USER_EMAIL_WATCHLISTS= '0' WHERE USER_ID > 1
This is just a quick write-up of some common SQL commands you could use to get the described job done. They are posted purely for example.
The following should be obvious, but I feel compelled to write it anyways: MAKE A BACKUP OF YOUR DATABASE BEFORE MAKING ANY CHANGES.
DOUBLE-CHECK YOUR QUERY BEFORE EXECUTING IT. ONCE YOU EXECUTE IT, THE ONLY WAY TO GO BACK IS THROUGH A BACKUP.
ONLY YOU ARE RESPONSIBLE FOR THE ACTIONS YOU PERFORM ON YOUR OWN FORUMS.
Hum, yes I see. I thought there might be a text file but I am guessing there is not one. What I wanted to do was, delete or import several emails at one time.
What I wanted to do was, delete or import several emails at one time.
If I understand what you're getting at, It seems that what you're looking for is a "List Manager." Something where you send email to a list of addresses.
UBB.threads relies on member accounts which have a username, password, forum settings and preferences tied together. Each of these is required.
There is no way to import a list of email addresses which are not tied to passwords/settings/preferences. They all are required features.
With an "Email List Manager," you can import a list of email addresses created from another source. At its very basic setting, each email address has nothing else tied to it, except a toggle between "send emails to this address" and "dont send emails to this address."
Ultimately, I would advise that you keep your "external" email addresses separate from your UBB.threads member email addresses. 1) Create an email template to use. 2a) Send out emails to your Email List subscribers using that template which mentions that the email was sent from an Email List Manager, and directions of how to unsubscribe from that. 2b) Send out Emails to your UBB.threads members using a slightly altered template, which mentions that the email was sent because they are a current member on your forums, and directions of how to unsubscribe from that. Use the Member Manager directions I posted above, to send these type of emails.
Question, is there a way that a UBB member can automatically unsubscribe from the list without me going to their account to unsubscribe them? I know they can go to their setting and change it but most do not.
Control Panel > Languages > [Language Editor TAB] Choose Specific Language File > mailer.php
In the EMAIL_FOOTER_HTML section, Find:
Quote
This email was sent to you because your profile and/or board configuration allows it.<br />You may change your preferences at any time.
Replace with:
Quote
This email was sent to you because your profile and/or board configuration allows it.<br />You may at anytime <a href=\"{$config['FULL_URL']}/ubbthreads.php?ubb=editdisplay\" style=\"color:#fff\">manage your message preferences</a>.
note: edit the "Replace with" line any way that you see fit. Just make sure to use full HTML/style inline formatting, as email clients wont be able to use CSS file location calls.
You can also substitute the smarty {$config['FULL_URL']} code, with a hardcoded FULL SITE URL if you run in to any errors using it.
Question, will 7.6.0 have any type of reporting for email notification/delivery/opens/clicks/views ?
We do not plan to violate a users privacy by adding tracking to outbound emails; if one wanted to edit the template and change the links to some sort of link tracker, that'd be something they'd have to do independently, either by themselves or with a 3rd party developer.