Newsletter SiteAdmin area ManagingPart II ( Part I )
Admin area.Newsletter subscription script Admin area need not be close to the general subscription files. It can be any where. It can be integrated to the part of your site admin making it a common admin area.
List PageIt will display all the subscribers with their status.
Listing will be done by paging of records and by default it is set to 10 records per page.
Admin can delete any member or can change the status to Active or to Fresh.
Post PageAdmin can enter subject of the newsletter and can compose the newsletter. After this the newsletter can be posted to all subscribers or it can be saved to post it in future.
Clean confirm tableMany visitors will subscribe but fail to confirm by visiting the link. This may happen due to various reasons but we need not keep those records for longer period. We can't expect someone to visit the confirmation page through the email link after two days of submitting the email address.
So one page is kept to remove such address which are more than 2 days old. The number of days can be changed by changing the days inside the SQL delete query.
Download in CSV format.Inside the Admin area there is a link saying Export. This page will generate CSV data of subscribers records and it will prompt for download. CSV file is generated by reading all the records of our nl_email table.
How to Install.Open config.php file and enter all details including database login id and password. Change the base URL path and FROM email address.
Use the SQL dump file to create your tables. Inside Admin area there is install.php file. Open this file and enter your admin userid and password. This file will insert your admin userid and password to nl_admin table. After adding admin details, remove install files from Admin area.
Testing your mail functionThere is an option to check your mail function. You can enter your email address and the script will send a test mail to you.
If your mail server is not configured then you will get warning message.
You must delete this install.php & installck.php files before using the script. This is a security problem. By using this file any one can create Admin privilege and enter into Admin area.
While login to admin area script will check for install.php & installck.php files and if it is not deleted then login will not be allowed.
Crypt functionScript uses crypt function to encrypt admin password while storing. If your server does not have crypt function support you may go for lower level encryption.
Checking your server support to run this scriptInstall file will check your server configuration and required support. For this there is a check.php file available at root directory. If any required support is not available then you will get message. If you are getting error message then you need to install those supports in your local server. There are links saying you how can enable those supports. After checking you can remove check.php file at root.
If crypt function is not available then there is low level encryption available using md5 function. For this you need to change install.php and loginck.php and passwordck.php file inside admin directory.
These three files you can download here
This article is written by plus2net.com team.