Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (Gizmo), 62 guests, and 209 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Softrak
Softrak
Vancouver, BC
Posts: 72
Joined: January 2007
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
isaac 13
SteveS 8
Morgan 5
Ruben 4
jorb 4
Zarzal 2
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
BSA photos
Previous Thread
Next Thread
Print Thread
Email File? #258539
07/08/16 05:32 PM
07/08/16 05:32 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
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!

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Email File? [Re: sundance] #258540
07/09/16 01:53 PM
07/09/16 01:53 PM
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 17,013
Portland, OR; USA
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.
Need to Upgrade?
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!
Re: Email File? [Re: Gizmo] #258543
07/11/16 12:35 PM
07/11/16 12:35 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
Hi Gizmo,

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

Re: Email File? [Re: sundance] #258544
07/11/16 03:08 PM
07/11/16 03:08 PM
JAISP  Offline
Veteran
Joined: Feb 2007
Posts: 1,335
Pennsylvania
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.

Re: Email File? [Re: JAISP] #258545
07/11/16 04:02 PM
07/11/16 04:02 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
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?

Re: Email File? [Re: sundance] #258546
07/11/16 04:37 PM
07/11/16 04:37 PM
isaac  Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,242
California
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.


Attached Files 20160709_11-59-57.PNG

isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Released
Re: Email File? [Re: isaac] #258547
07/11/16 05:52 PM
07/11/16 05:52 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
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.

Re: Email File? [Re: sundance] #258548
07/11/16 07:12 PM
07/11/16 07:12 PM
isaac  Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,242
California
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/16 07:20 PM.

isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Released
Re: Email File? [Re: isaac] #258549
07/11/16 09:01 PM
07/11/16 09:01 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
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.

Re: Email File? [Re: sundance] #258550
07/11/16 09:24 PM
07/11/16 09:24 PM
isaac  Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,242
California
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/16 09:27 PM.

isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Released
Re: Email File? [Re: sundance] #258551
07/12/16 12:32 PM
07/12/16 12:32 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
Perfect, thank you!

Re: Email File? [Re: sundance] #258552
07/12/16 12:40 PM
07/12/16 12:40 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
I just tested it and that string of code worked perfectly, TY!

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

Re: Email File? [Re: sundance] #258553
07/12/16 12:43 PM
07/12/16 12:43 PM
isaac  Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,242
California
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.


isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Released
Re: Email File? [Re: sundance] #258554
07/12/16 02:36 PM
07/12/16 02:36 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
Cool thx, how soon?

Re: Email File? [Re: sundance] #258555
07/12/16 10:57 PM
07/12/16 10:57 PM
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 17,013
Portland, OR; USA


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.
Need to Upgrade?
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!
Re: Email File? [Re: sundance] #258560
07/13/16 12:32 PM
07/13/16 12:32 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
Question, will 7.6.0 have any type of reporting for email notification/delivery/opens/clicks/views ?

Re: Email File? [Re: sundance] #258564
07/13/16 03:37 PM
07/13/16 03:37 PM
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 17,013
Portland, OR; USA
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.
Need to Upgrade?
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!
Re: Email File? [Re: Gizmo] #258565
07/13/16 03:59 PM
07/13/16 03:59 PM
S
sundance  Offline OP
member
Joined: Aug 2012
Posts: 115
roger that, thank you for the info!


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
table issue
by TheBrit. 12/13/18 06:05 PM
testing table layout
by TheBrit. 12/13/18 11:16 AM
header.php after update from 7.5.x to 7.6.x
by Zarzal. 12/12/18 05:29 AM
Does 7.6.2 support php 71?
by Baldeagle. 12/12/18 02:17 AM
Cannot contact support
by . 12/11/18 06:43 PM
Forum Statistics
Forums36
Topics35,178
Posts191,669
Members12,122
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2