Contributions
Simple Visitor Newsletter with HTML Support
/////////Simple Visitor Newsletter with HTML Support v 1.0
Created By Central50
/////////
I have searched and looked at different contribs for this purpose, but how complicated can you be? Do I really want to sit here for
4-5 hours adding coding, making sure it works with my shop, etc? And I did not see good reviews about them either. Well I got fed up
and created my own.
What this does is adds an info box where your visitor can enter their e-mail address to receive newsletters. Simply enough? It also
checks to see if the e-mail address already exists in your visitor table, as well as it checks to see if your visitor is really a customer.
If either of those values are true, it will say that account exists already. This prevents multiple newsletters being sent to the same address.
Now here is the kicker, when that visitor turns around and registers for an account, create_account.php will check to see if the e-mail exists
in you visitor table. If their e-mail is there, it will delete it and automatically turn their newsletter sub on. So pretty much what that means
is they will be a newsletter sub still and not have multiple newsletters sent to them.
Also included is HTML support for your newsletter. You might not know, but stock OSc Newsletters only send out in text format. The new newsletter
module file included in this package has a fix that I found on the forums. Might as well as throw it into a contrib, but the credit for that is
deserved to the person who wrote it.
I will later create the ability for you to edit the e-mails in the visitor table, see the list, send only to those visitors, etc.
USE AT YOUR OWN RISK ---------- ALWAYS BACKUP BACKUP BACKUP BACKUP BACKUP
Expand All / Collapse All
Simple Visitor Newsletter With HTML Support, Bulk Mail and Admin v 2.2
"English" language only
compiled by iLC, 19 Jul 2011:
-----------------------------
This version is combination of the files for visitor email admin,
html support and bulk emailing support with some minor mods.
Please note that this version has the "English" language files only.
The changes are:
- the missing table_background_visitor.gif is provided
- table 'visitors' is renamed as 'visitors_email' to avoid conflict with other contributions
- corrected some information in this "install.txt" files
Thanks to Central50 and others who have supported this contribution so far.
-- Regards iLC
Hi,
thanks for this contribute, made my life a whole lot easier! I needed the email list on the admin side in danish language, so I translated this. Maybe others could make use of this too.
Corrections for english
Solved Error in DB
Please read the TXT file
Why display the visitormail box when a customer is registered?
In step 6 of the installation, add:
if (tep_session_is_registered('customer_id')) {
} else {
include(DIR_WS_BOXES . 'visitoremail.php');
}
instead of:
include(DIR_WS_BOXES . 'visitoremail.php');
No file uploaded.
- screenshot (in english)
- replaced button for the "delete" image (button_remove.gif).
- layout change in: admin/visitor_mail_list.php
This contrib is exactly the same as done by -GuiGui- 18 Dec 2008
The only change is in: admin/visitor_mail_list.php
I wanted to change the layout to look more consistent with the rest of the admin layout. The color of the row changes on mouse over. See the screen shot.
- added screenshot (in french sorry)
- Fix some french translation
- replaced $HTTP_GET_VARS by $_GET
- manage translation for success message
- input text box to add an email on the fly
I made a few ajestments in the install file.
Some extra code nooeds to be put in the language files.
Here is a little contibution.
I have included Translations for Dutch and French.
Made a modification with the help of Gosub.
He gave me the solution for problem encounterd during the installation.
Enjoy.
All credits go to Gosub and Central50.
Here is a little contribution to the contribution I coded.
It lets you administrate the visitor mails listed in your stores database.
It has a nifty import from text file function that grabs only e-mail addresses
out of any text file filled with anything. And it lets you see all the addresses
and you can delete, but only one at a time.
Thx Central50 for the original contribution!
Regards from Gosub
Now with "e-mail already exists" check so you don’t get duplicates!
Here is a little contribution to the contribution I coded.
It lets you administrate the visitor mails listed in your stores database.
It has a nifty import from text file function that grabs only e-mail addresses
out of any text file filled with anything. And it lets you see all the addresses
and you can delete, but only one at a time.
Thx Central50 for the original contribution!
Regards from Gosub
I agree with Oren, I do not see why you need to edit the login page. Once the customer creates their account, the system automatically pulls the information and deletes the database entry from the visitor table.
Mod is looking great everyone, thanks for keeping it going through my absence.
I disagree with osBen. The system DOES work and doesn't require the alteration to login.php
----------
One fie to fix or your error messages won't work:
includes/languages/english/visitoremail.php
change:
ERROR_ALREADY_EXIST
to:
ALREADY_EXIST
and change:
ERROR_FROM_ADDRESS
to
ERROR_TO_ADDRESS
* you can also use the replacement file in this package.
----------
I had a problem with the database query. For some reason it won't accept it due to bad syntax (I use 1and1.com php 4.0). I used the following instead:
CREATE TABLE `visitor` (
`email` varchar(255) NOT NULL default 'CHARACTER SET utf8 COLLATE utf8_swedish_ci',
PRIMARY KEY (`email`)
) TYPE=MyISAM;
The installation instruction,s step 1 should be performed on both the create_account.php *and login.php*, otherwise emails are not deleted from the visitor table when a person upgrades to a customer account.
The installation instruction,s step 1 should be performed on both the create_account.php *and login.php*, otherwise emails are not deleted from the visitor table when a person upgrades to a customer account.
The installation instruction,s step 1 should be performed on both the create_account.php *and login.php*, otherwise emails are not deleted from the visitor table when a person upgrades to a customer account.
If you want to give the visitors option to unsubscribe then download this contribution "Newsletter unsubscribe", install it and after that follow the instructions in readme - file attached.
There are perhaps better ways of doing what I have done, as I am quite noob to php. But it is working for me.
This is only the readme - file, not the whole package.
I have installed "Simple Visitor Newsletter with HTML Support" version 2.0
[PORTUGUÊS ABAIXO]
This version is a blend of an upgraded verion of Advanced Bulk Mail contribution (by Nick Weisser, Nov 12 2004, http://www.oscommerce.com/community/contributions,2624/category,all/search,bulk) and the Simple Visitor Newsletter with HTML Support (Central50, Jun 6, 2007, http://www.oscommerce.com/community/contributions,5196/category,all/search,NEWSLETTER).
This new version includes missing file includes/boxes/visitoremail.php and also the new contribution from jan64 (notification subscriber), with the text in languages folder.
The main purpose is to send several newsletters without PHP timeout nor hosting blocking due to the large number of sendings, so you can send a large amount of mails like regular e-mail sending.
You can program que quantity of mails to send and the time between each send.
The quantity of mails to send is defined in the constant BULKMAILER_LIMIT.
The time between each e-mail sending is defined in the constant BULKMAILER_INTERVAL.
These two constants will be located at Admin Panel -> Configuration -> Max values
Create a newsletter as usual choosing the newsletter_bulk module from the dropdown list.
I hope you enjoy this version.
=================
E-mails de informativos para visitantes simples com suporte a HTML e envio em blocos.
Esta nova versão inclui arquivo esquecido includes/boxes/visitoremail.php e também a nova contribuição de jan64 (notification subscriber), com os textos no diretório languages.
Esta contribuição é uma mistura da contribuição Advanced Bulk Mail contribution (de Nick Weisser, 12 de novembro de 2004, http://www.oscommerce.com/community/contributions,2624/category,all/search,bulk) com a versão anterior desta (de Central50, 6 de junho de 2007, http://www.oscommerce.com/community/contributions,5196/category,all/search,NEWSLETTER).
A idéia é enviar diversos e-mails sem que sua hospedagem reconheça isso como spam (até porque não é) nem esgote o tempo de envio pelo php.
É possível programar a quantidade de e-mails a enviar, bem como o intervalo entre os envios.
A quantidade de e-mails a enviar é definida pela constante BULKMAILER_LIMIT e o intervalo por BULKMAILER_INTERVAL, ambas localizadas no Painel Administrativo -> Configuração -> Valores máximos.
Para usar a função BULK, basta selecionar newsletter_bulk na lista ao criar um informativo.
Sobre o envio a visitantes simples, consiste de uma nova tabela onde o visitante precisa preencher somente seu e-mail para receber os informativos, com possibilidade de envio em HTML.
Espero que vc goste desta versão.
All credits go to central50.
you only have to replace visitoremail.php with this "new" visitoremail.php.
When somebody subscribe there will be send an email to the shop owner with emailadress en ipadress from the subsciber.
Thats all.
!!!!!!!!!!!ALWAYS BACKUP!!!!!!!!!
[PORTUGUÊS ABAIXO]
This version is a blend of an upgraded verion of Advanced Bulk Mail contribution (by Nick Weisser, Nov 12 2004, http://www.oscommerce.com/community/contributions,2624/category,all/search,bulk) and the Simple Visitor Newsletter with HTML Support (Central50, Jun 6, 2007, http://www.oscommerce.com/community/contributions,5196/category,all/search,NEWSLETTER).
The main purpose is to send several newsletters without PHP timeout nor hosting blocking due to the large number of sendings, so you can send a large amount of mails like regular e-mail sending.
You can program que quantity of mails to send and the time between each send.
The quantity of mails to send is defined in the constant BULKMAILER_LIMIT.
The time between each e-mail sending is defined in the constant BULKMAILER_INTERVAL.
These two constants will be located at Admin Panel -> Configuration -> Max values
Create a newsletter as usual choosing the newsletter_bulk module from the dropdown list.
I hope you enjoy this version.
=================
E-mails de informativos para visitantes simples com suporte a HTML e envio em blocos.
Esta contribuição é uma mistura da contribuição Advanced Bulk Mail contribution (de Nick Weisser, 12 de novembro de 2004, http://www.oscommerce.com/community/contributions,2624/category,all/search,bulk) com a versão anterior desta (de Central50, 6 de junho de 2007, http://www.oscommerce.com/community/contributions,5196/category,all/search,NEWSLETTER).
A idéia é enviar diversos e-mails sem que sua hospedagem reconheça isso como spam (até porque não é) nem esgote o tempo de envio pelo php.
É possível programar a quantidade de e-mails a enviar, bem como o intervalo entre os envios.
A quantidade de e-mails a enviar é definida pela constante BULKMAILER_LIMIT e o intervalo por BULKMAILER_INTERVAL, ambas localizadas no Painel Administrativo -> Configuração -> Valores máximos.
Para usar a função BULK, basta selecionar newsletter_bulk na lista ao criar um informativo.
Sobre o envio a visitantes simples, consiste de uma nova tabela onde o visitante precisa preencher somente seu e-mail para receber os informativos, com possibilidade de envio em HTML.
Espero que vc goste desta versão.
This will give you a single line subscribe box with a go/enter button. My sites are highly modded and I don't have box space.
Did not spell Subscribe right and forgot to update that in the package, woops.
Full Package.
Please note that this button is the layout from my site. You may wish to change it to fit yours.
/////////Simple Visitor Newsletter with HTML Support v 1.0
Created By Central50
/////////
I have searched and looked at different contribs for this purpose, but how complicated can you be? Do I really want to sit here for
4-5 hours adding coding, making sure it works with my shop, etc? And I did not see good reviews about them either. Well I got fed up
and created my own.
What this does is adds an info box where your visitor can enter their e-mail address to receive newsletters. Simply enough? It also
checks to see if the e-mail address already exists in your visitor table, as well as it checks to see if your visitor is really a customer.
If either of those values are true, it will say that account exists already. This prevents multiple newsletters being sent to the same address.
Now here is the kicker, when that visitor turns around and registers for an account, create_account.php will check to see if the e-mail exists
in you visitor table. If their e-mail is there, it will delete it and automatically turn their newsletter sub on. So pretty much what that means
is they will be a newsletter sub still and not have multiple newsletters sent to them.
Also included is HTML support for your newsletter. You might not know, but stock OSc Newsletters only send out in text format. The new newsletter
module file included in this package has a fix that I found on the forums. Might as well as throw it into a contrib, but the credit for that is
deserved to the person who wrote it.
I will later create the ability for you to edit the e-mails in the visitor table, see the list, send only to those visitors, etc.
USE AT YOUR OWN RISK ---------- ALWAYS BACKUP BACKUP BACKUP BACKUP BACKUP
Note: Contributions are used at own risk.