Previous Thread
Next Thread
Print Thread
Hop To
#258539 07/08/2016 6:32 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Hi,

Question, where is the email file for the members in 7.5.8 and what is the name of the file??

Thank you for your help!

sundance #258540 07/09/2016 2:53 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
What exactly is it that you're trying to do? Most of the mailer languages are held in the mailer language file.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #258543 07/11/2016 1:35 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Hi Gizmo,

I am looking for the text file that contains the email list so that I may edit it.

sundance #258544 07/11/2016 4:08 PM
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
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.

JAISP #258545 07/11/2016 5:02 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Originally Posted by JAISP
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?

sundance #258546 07/11/2016 5:37 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by sundance
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.

Attachments
20160709_11-59-57.PNG


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
isaac #258547 07/11/2016 6:52 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
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.

sundance #258548 07/11/2016 8:12 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by sundance
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.

Email List Manager
https://en.wikipedia.org/wiki/Electronic_mailing_list

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

UBB.threads does a pretty good job for managing and emailing addresses for your UBB.threads members, but... If you have a list of emails completely unrelated to your UBB.threads member base, you can a expand upon your email campaign by adding a List Manager such as one of these:
AWeber - http://www.aweber.com/easy-email.htm
MailChimp - http://mailchimp.com
Campaign Monitor - https://www.campaignmonitor.com/
iContact - https://www.icontact.com/
Constant Contact - https://www.constantcontact.com/index.jsp
Vertical Response - http://www.verticalresponse.com/
ActiveCampaign - http://www.activecampaign.com/
Emma - http://myemma.com/
Mad Mimi - https://madmimi.com/
GetResponse - https://www.getresponse.com/

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.

Last edited by id242; 07/11/2016 8:20 PM.

Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
isaac #258549 07/11/2016 10:01 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
I understand thank you!

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.

sundance #258550 07/11/2016 10:24 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
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>.

When clicked on, this will take the email recipient to:
http://www.EXAMPLE.com/ubbthreads.php/ubb/editdisplay

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.

Last edited by id242; 07/11/2016 10:27 PM.

Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
sundance #258551 07/12/2016 1:32 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Perfect, thank you!

sundance #258552 07/12/2016 1:40 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
I just tested it and that string of code worked perfectly, TY!

I have another question unrelated but, is the responsive template available yet?

sundance #258553 07/12/2016 1:43 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by sundance
I have another question unrelated but, is the responsive template available yet?

yep. and its already in use on ubbcentral.com forums (this site smile ). it will be part of UBB.threads 7.6.0 when released very soon.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
sundance #258554 07/12/2016 3:36 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Cool thx, how soon?

sundance #258555 07/12/2016 11:57 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
sundance #258560 07/13/2016 1:32 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Question, will 7.6.0 have any type of reporting for email notification/delivery/opens/clicks/views ?

sundance #258564 07/13/2016 4:37 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by sundance
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #258565 07/13/2016 4:59 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
roger that, thank you for the info!


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)