NLetter Version 1.9.5 - English Manual (short version)


:: Inhalt ::

1. License conditions
2. Install requirement
3. Installation
4. Changelog
5. Other



1. License conditions
  • You are not allowed to remove or change the copyright nor making the it invisible. You are allowed to remove the copyright with a corresponding license, but not allowed to add your own copyright to the script.
  • You may not copy the source code or parts of them for using it for scripts other than the provided USOLVED script.
  • USOLVED is not responsible for the site's content on which the scripts are used.
  • The author assumes no liability or guarantee for the offered scripts.
  • The scripts can be used for free for private purposes, as long as the copyright is visible. The same applies for nonprofit association.
    You need to purchase a license if you would like to use a script on commercial sites and are authorized to remove the copyright with a corresponding license. This applies for companies and profit-making individual persons.
  • A license is just per domain. It may not be used on more than one site.
  • The scripts may not be published on any other sites for download.
  • It's not allowed to use our scripts on pornograpfic, violently and in general on sites with illegal content.
  • With downloading a script you agree to the license conditions.



2. Install requirement

A web server with at least PHP v4.0 and a MySQL Database.



3. Installation


New installation:
    After unpacking the ZIP file you have to upload all files to your server with a FTP programm. If you don't know what a FTP programm is, search for such a programm with a search engine. SmartFTP is a good free one.

    1.) Upload all files and folders of the ZIP file to your server

    2.) Browse to the folder settings/ and choose the CHMOD 777 for the file config.php (Normally possible when you right-click the file and choose 'CHMOD' from the drop down menu)

    3.) If you like to use the SQl export function, you can set also CHMOD 777 for the whole folder settings/ optionally.
    And if you also like to use the picture upload function, you need to set CHMOD 777 for the folder images/upload.

    4.) Now type in the address to the install file ( install.php) on your webbrowser. For example:
    http://wwww.address.net/mysite/nletter/install.php

    5.) If you typed in the correct path you will now see a note if the CHMOD was correct and if you can use the real-time-sending function. Click on continue and you must type in your database connection data. These data is often equal like your ftp login. Otherwise ask your ISP. After clicking continue a test connection will be established. If this was successfull you can now type in your personal login for the admin center of NLetter. The installation is now finished and you can use NLetter.



    There are two options to show the script on your website. Either a direct link to the file newsletter.php or include the form directly into your website. Write the fallowing code into yor existing *.php file (not the absolute http://... path):

    <? include("relative_path_to_the_script/newsletter.php"); ?>
    (e.g. when you like to include the script to root/index.php and the script is installied in root/nletter, you would need this command include("nletter/newsletter.php");)

    The same goes for the contact form, but the file is named contactform.php.


4. Changelog 

## Version 1.9.5 ##
+ Choose a language separated from the one in the admin center
+ User management to add and administrate new NLetter members
+ You can now define a general salutation if no fore- and surname was given
+ Danish language pack (thanks to Dorthe)
+ Dutch language pack (thanks to Jan Deuten)
+ Image file browser added
+ Captcha code for the contact form added
+ Page script for the subscriber management
+ Optional drop down menu for the group choice
+ You can now use the place holder {PROFILE_LINK} in the welcome e-mail for instant subscriptions
* Locked users were wrongly counted in the group stats
* Text with apostrophes and activated WYSIWYG-Editor couln't be saved as template
* Breaks in the signature with activated WYSIWYG-Editor will be transcripted again
* Some fixes with the blacklist import
* Fixes a bug that caused multiply notification outputs when you included the form and archive on the same page

=================================================================================================
Files:
========

Changed Files:
    contactform.php
    newsletter.php
    admin.php

    settings/lang_de.php
    settings/lang_en.php
    settings/lang_fr.php

    images/icon_fr_sendin_new.gif

    inc/admin_executejob.php
    inc/admin_ex_import.php
    inc/admin_setuser.php
    inc/admin_sendmails.php
    inc/admin_sendform.php
    inc/admin_sendin.php
    inc/admin_settings_contact.php
    inc/admin_settings_nl.php
    inc/admin_settings_nl_text.php
    inc/admin_settings_misc.php
    inc/newsletter_subscribecheck.php
    inc/user_login.php
    inc/user_check.php

    tpl/styles.css
    tpl/tpl_newsletter_htmlform.php

Added Files:
    images/flag_dk.gif
    images/flag_nl.gif

    images/icon_dk_adminindex.gif
    images/icon_dk_ex_import.gif
    images/icon_dk_newsletter.gif
    images/icon_dk_newsletterindex.gif
    images/icon_dk_sendin.gif
    images/icon_nl_sendin_new.gif
    images/icon_dk_sendinindex.gif
    images/icon_dk_settings.gif
    images/icon_dk_setuser.gif
    images/flag_dk.gif

    images/icon_nl_adminindex.gif
    images/icon_nl_ex_import.gif
    images/icon_nl_newsletter.gif
    images/icon_nl_newsletterindex.gif
    images/icon_nl_sendin.gif
    images/icon_nl_sendin_new.gif
    images/icon_nl_sendinindex.gif
    images/icon_nl_settings.gif
    images/icon_nl_setuser.gif
    images/flag_nl.gif

    inc/admin_filebrowser.php
    inc/js/prototype.js

    inc/captcha/

    settings/lang_dk.php
    settings/lang_nl.php



Database:
=========
Added:

	Table _settings:
    sendin_captcha int(1) NOT NULL
    replace_form_alt_titlecheck int(1) NOT NULL
    replace_form_alt_title varchar(250) NOT NULL
    group_select int(1) NOT NULL

	Table _intern_users:
    id_group int(10) NOT NULL
    id_language int(10) NOT NULL

	Table _info:
    licencedomain varchar(100) NOT NULL
    licencekey varchar(100) NOT NULL

	Table _archiv:
    views int(10) NOT NULL


Inserts:

    INSERT INTO {$prefix}_language (language_name,language_file,language_aktiv) VALUES ('Danish','lang_dk.php','0')
    INSERT INTO {$prefix}_language (language_name,language_file,language_aktiv) VALUES ('Dutch','lang_nl.php','0')


    INSERT INTO $prefix"."_intern_groups (groupname) VALUES ('Admin')

    INSERT INTO $prefix"."_intern_permission_name (perm_name) VALUES ('enter_newsletter')
    INSERT INTO $prefix"."_intern_permission_name (perm_name) VALUES ('enter_contact')
    INSERT INTO $prefix"."_intern_permission_name (perm_name) VALUES ('enter_usersettings')
    INSERT INTO $prefix"."_intern_permission_name (perm_name) VALUES ('enter_settings')
    INSERT INTO $prefix"."_intern_permission_name (perm_name) VALUES ('enter_eximport')

Created:

    Table _intern_groups
    Table _intern_permission
    Table _intern_permission_name
    Table _captcha

Removed:

	Table _intern_users:
	loginsave int(1) NOT NULL


-------------------------------------------------------------------------------------------------
## Version 1.9.4 ##
+ Option to forward e-mails with the contact form
+ Option to define a signature for the contact form
+ Option to add a salutation field for the contact form
+ See stats on how much a newsletter was read
+ French selectable as a lanaguage in the admin center
+ Licence key can be now entered with the admin center
* Fixed sort by name bug in the user list
* Blacklist will not be ignored anymore while importing e-mails from a txt file
* No more redundant entries after adding addresses with the blacklist
* Fixed apostrophe bug while saving a template
* Fixed apostrophe bug while saving a newsletter to the archive

=================================================================================================
Files:
========

Changed Files:
    contactform.php
    newsletter.php
    admin.php

    settings/lang_de.php
    settings/lang_en.php
    settings/styles.css

    inc/admin_dispatchjob.php
    inc/admin_ex_import.zip
    inc/admin_executejob.php
    inc/admin_sendform.php
    inc/admin_setuser.php
    inc/admin_settings_nl.php
    inc/admin_sendmails.php
    inc/admin_settings_contact.php
    inc/admin_sendin.php
    inc/admin_tooltips.php

Added Files:
    images/flag_fr.gif
    images/icon_fr_adminindex.gif
    images/icon_fr_newsletterindex.gif
    images/icon_fr_newsletter.gif
    images/icon_fr_sendin.gif
    images/icon_fr_sendinindex.gif
    images/icon_fr_settings.gif
    images/icon_fr_setuser.gif

    settings/lang_fr.php

    inc/admin_licence.php
	inc/newsletter_countviews.php



Database:
=========
Added:

	Table _settings:
    sendin_sig text NOT NULL
    sendin_title int(1) NOT NULL
    attach_viewcount int(1) NOT NULL

	Table _send_in:
    title int(1) NOT NULL

	Table _info:
    licencedomain varchar(100) NOT NULL
    licencekey varchar(100) NOT NULL

	Table _archiv:
    views int(10) NOT NULL


Inserts:

	INSERT INTO _language (language_name,language_file,language_aktiv) VALUES ('French','lang_fr.php','0')"


-------------------------------------------------------------------------------------------------
## Version 1.9.3 ##
+ More flexibility with the archive template
+ Prevent multiple group selection
+ Unlock users manually
* The selected group will be saved after simulating the dispatching of emails
* MySQL error fixed when including both - the newsletter and archive - on one page

=================================================================================================
Files:
========

Changed Files:
    newsletter.php
    contactform.php

    tpl/tpl_global_header.php
    tpl/tpl_newsletter_htmlform.php
    tpl/tpl_newsletter_archive.php
    tpl/tpl_newsletter_userprofile.php

    settings/lang_de.php
    settings/land_en.php

    inc/admin_sendform.php
    inc/admin_settings_nl.php
    inc/admin_setuser.php
    inc/newsletter_subscribecheck.php
    inc/newsletter_editcheck.php
    inc/admin_useredit.php

Added Files:
	images/warning.gif

Moved Files:
	settings/styles_output.css to tpl/styles.css


Database:
=========
Added:

	Table _settings:
	group_choice_radio int(1) NOT NULL

-------------------------------------------------------------------------------------------------
## Version 1.9.2 ##
+ All user data is now editable in the subscriber list
+ View users that are currently locked in the subscriber list
* It's again possible to use global css style sheet informations in the newsletter template
* Fixed bug with editing default html code definitions

=================================================================================================
Files:
========

Changed Files:
	newsletter.php
	contactform.php
	settings/lang_de.php
	settings/lang_en.php
	inc/admin_useredit.php
	inc/admin_executejob.php
	inc/admin_settings_nl_text.php
	inc/admin_setuser.php
	inc/js/divtools.js


-------------------------------------------------------------------------------------------------
## Version 1.9.1 ##
+ It's now possible to send attachments with the newsletter
+ Archive-Template to view the sent newsletters

=================================================================================================
Files:
========

Changed Files:
    admin.php
    newsletter.php
    contactform.php
    settings/lang_de.php
    settings/lang_en.php
    inc/admin_settings_nl.php
    inc/admin_settings_nl_text.php
    inc/admin_executejob.php
    inc/admin_tooltips.php
    inc/admin_sendform.php
    inc/admin_sendmails.php
    inc/admin_setuser.php
    inc/admin_dispatchjob.php
    tpl/tpl_newsletter_archive.php

Added Files:
    inc/js/fileupload.js
    images/attachment.gif


Database:
=========
Added:

	Table _archiv:
	attachments text NOT NULL

	Table _resume:
	attachments text NOT NULL

	Table _settings:
	attachment_upload int(1) NOT NULL


-------------------------------------------------------------------------------------------------
## Version 1.9 ##
+ Sourcecode ouput is now easier to customize and has been extracted to template files
+ Subscriber can change their profile (like groups, name, etc.)
+ New Place-Holders available (forename, surname, title, group)
	Attention:
	All placer-holders must be written in capital letters,
	please edit your templates accordingly.
	The place-holder {NAME} isn't available anymore and is now accessable with {FORENAME}
+ ReadMe enhanced
+ Some tunings in the Admin Center
+ New import format for foreign scripts "email@address.com;Title;Forename;Surname"
* Fixed a bug with changing the own user login data
* Fixed a bug with the deinstalll routine
* Fixed a bug under IE with the WYSIWYG picture insert routine
* Again NEWSolved Pro. compatibility
=================================================================================================
Files:
========

Changed Files:
    newsletter.php
    admin.php
    inc/admin_settings_misc.php
    inc/newsletter_subscribecheck.php
    inc/newsletter_unsubscribesubcheck.php
    inc/admin_settings_nl.php
    inc/admin_setuser.php
    inc/admin_ex_import.php
    inc/admin_tooltips.php
    inc/admin_dispatchjob.php
    inc/admin_sendform.php
    inc/admin_executejob.php
    inc/user_check.php
    inc/user_login.php
    inc/admin_settings_misc.php
    inc/newsletter_flashsubmit.php
    settings/lang_de.php
    settings/lang_en.php
    settings/styles.css
    settings/styles_output.css

Added Files and Folders:
    inc/newsletter_functions.php
    inc/admin_useredit.php
    inc/admin_blacklist.php
    inc/admin_newsolved.php
    inc/admin_settings_nl_text.php
    inc/newsletter_editcheck.php
    inc/admin_dynamic_code.php
    ./tpl

Renamed Files:
    inc/functions.php => inc/admin_dbimport.php
    ./sendin => ./contactform.php

Removed Files:
	inc/newsletter_cron.php


Database:
=========

Changed:
	Table _entries:
	"id_unique varchar(6) NOT NULL" => "id_unique varchar(12) NOT NULL"

Renamed:
	Table _settings:
	"form_name" => "form_forename"

	Table _entries:
	"name" => "forename"

Removed:
	Table _settings:
	"layout_height"
	"default_unsubscribe"

Added:
	Table _settings:
	layout_textfieldwidth varchar(3) NOT NULL
	form_title int(1) NOT NULL
	form_surname int(1) NOT NULL
	replace_form_expression_title varchar(250) NOT NULL
	replace_form_expression_name varchar(250) NOT NULL
	replace_form_title_mr varchar(250) NOT NULL
	replace_form_title_mrs varchar(250) NOT NULL
	replace_form_ifempty_forename varchar(250) NOT NULL
	replace_form_ifempty_surname varchar(250) NOT NULL

	Table _entries:
	title int(1) NOT NULL
	surname varchar(50) NOT NULL

-------------------------------------------------------------------------------------------------
## Version 1.8.8 ##
* Fixed pictures upload deactivation bug
+ It's now possible to choose a default group
+ Changed the WYSIWYG editor(FCKeditor instead of RTE)
+ Various JavaScripts packed into an own file
+ Layout changes in the write-newsletter form
+ SQL Export for e-mail adresses incl. groups
+ SQL Export for e-mail addresses from specific grouops
+ ReadMe file a little bit enhanced
=================================================================================================
Changed Files:
newsletter.php, sendin.php, admin.php, admin_sendform.php, admin_ex_import.php
lang_de.php, lang_en.php, admin_setuser.php, install.php, newsletter_subscribecheck.php,
admin_dispatchjob.php, admin_executejob.php

Added Files:
FCKeditor, divtools.js, admin_dbexport_emails.php, admin_dbexport_groups.php, arrow_up_img.gif,
arrow_up_tpl.gif, arrow_up_img_over.gif, arrow_up_tpl_over.gif

Changed DB:
default_group int(1) NOT NULL zu nletter_groups hinzugefügt

-------------------------------------------------------------------------------------------------
## Version 1.8.7 ##
* Fixed a bug in the resume function (settings weren't saved)
+ Simultaneously dispatching of emails to different groups
* Automatic eMail bug fixed after subscription
* Changed Micro-seconds in Mili-seconds for send method > 1.7

-------------------------------------------------------------------------------------------------
## Version 1.8.6 ##
+ Added resume function for send-method > 1.7

-------------------------------------------------------------------------------------------------
## Version 1.8.5 ##
+ picture upload
* change groups with deactivated group management

-------------------------------------------------------------------------------------------------
## Version 1.8.4 ##
+ WYSIWYG editor added (Cross-Browser Rich Text Editor (www.kevinroth.com))

-------------------------------------------------------------------------------------------------
## Version 1.8.3 ##
* fixed a serios bug with the sending progress that was caused due the 1.8.2 update

-------------------------------------------------------------------------------------------------
## Version 1.8.2 ##
+ Preview function for html emails
# changed the login system

-------------------------------------------------------------------------------------------------
## Version 1.8.1 ##
+ hide groups
+ save templates
+ choose a charset
+ vary the size of the email textfield
+ resume function again awailable for send method v1.7
* no more erors on the flash form with activated groups




5. Other

Other software that has been used for this script under LGPL:
- FCKeditor (Homepage)

If you have questions, criticism or suggestions to our scripts, please feel free to write us an email under info@usolved.net or www.usolved.net.