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 tableubbt_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 to1) 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 prefs1) 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.
