Kmailing List Manager        ________  
Kmailing List Manager      _/ \    / / 
Kmailing List Manager    __/   \~~/ /  
Kmailing List Manager  ___/________/   
Kmailing List Manager                  

Hi,
This page is meant to tell you that it was easy to make this mailing list manager.
I invested just 2 hours and here it is. You need to modify it to suit your need.(
Only way to learn coding is play with others code.). just look at what happens 
in pages. 
  addtolist.php
  This page adds/removes e-mails to database. It should be publicly accessible.
  Adding e-mail with passwords makes user confident that no one governs him/her.
  This is done in following manner:
    Adding
    • To add e-mail to database a user gives e-mail and password.
    • Now if the e-mail is already in database, the e-mail is rejected saying 
      duplicate entry.
    • If the e-mail is not in database it is added. Both you and the user is sent a 
      mail. User is sent a welcome mail and you are sent an alert mail.
    • Apart from sending mails to you and user it also adds the e-mails in waiting
      list for your approval.
    Removing
    • If the user asks to remove it is checked if the e-mail is in database or 
      not.
    • If it is in database and the user had provided right password the e-mail is 
      removed.
    • If the e-mail is in database but password provided by user is wrong, the 
      request is rejected.
    At this point you can also add an alert mail to inform you about this act.
    
  cp.php
  This page is a sort of control panel. Put it in a protected area where only you can 
  access it. It works as in following manner:
    E-mails waiting for approval
    • Shows a table with e-mails waiting for your approval.
    • Click the check box against the mail id to approve it.
    • Hit the update button and user is approved and is sent a welcome mail along 
      with password.
    Send E-mails to members
    • A form will appear. 
    • Enter the required content (sub., message etc.).
    • Hit the send button and mails are sent to approved user one by one.
    Members 
    • Simply shows a list of only approved e-mails.
    
  Installing and configuring
  Simply do as following. 
    • Open the common.php.
    • Change the value of variable named $dbname to the name of database you 
      will create.
    • Now run this command, after changing the path to file members.sql, from 
      command prompt in MySQL's /bin dir.
      mysql>source /path/to/members.sql
    • The above procedure will create a database and a table in it.
    • Now change the value of variable named $from to your email. 
  And you are done.

  Upgrades and to-do in future.
  Satisfaction hinders progress. I had planned these things.
    • Making html emailer. Allowing to send images and media like swf and mpg content.
    • Making an installer script.
    • Doing some more research. 

  Tweaking
  Tweaking can be done by two kind of persons. 
    1. Who know php coding.
    2. Who don't know php coding.
  For both things back up the original script and open the files in a text editor. 
  Change the values and text which is readable by you. also you can use this form to 
  send the emails from another form to this page.
<!--HTML Code--------------------------->
<form method="post" action="/path/to/addtolist.php"  name="addremove">
  <div align="center"><font face="Arial, Helvetica, sans-serif" size="3"><b>Add 
    to members</b></font> 
    <table border="0" bgcolor="#000000" cellpadding="2" cellspacing="1">
      <tr bgcolor=#CCCCCC> 
        <td align="right" valign="top">Email</td>
        <td align="left" valign="top"> 
          <input type=text name=email 
	 value="" maxlength="50" size="40">
        </td>
      </tr>
      <tr bgcolor=#CCCCCC> 
        <td align="right" valign="top">Password</td>
        <td align="left" valign="top"> 
          <input type=password name=pwd 
	 value="" maxlength="16" size="16">
        </td>
      </tr>
      <tr bgcolor=#CCCCCC align="left"> 
        <td valign="top" colspan="2"> 
          <input type="radio" name="action" value="add" checked>
          Add to list<br>
          <input type="radio" name="action" value="remove">
          Remove from list</td>
      </tr>
    </table>
    <input type="submit" name="Submit" value="Submit">
  </div>
</form>
<div align="center">
<a href="http://www.kinfosys.com" target="_blank" title="KInfotechIndia.com...where technology ticks faster than time.">
<font face="Verdana, Arial, Helvetica, sans-serif" size="1">
Powered by KI
</font>
</a>
</div>
<!--HTML Code--------------------------->

You need to change the stuff accordingly. Add a registration form instead of a simple 
form to add other stuff. A request is to keep the Powered by Link as it is. This may 
get me some business that is some project to earn some currency. I don't smoke, drink 
or date. I need currency to keep my studies+expenses going on. May be I may purchase 
xtra RAM+/HDD+/Boxed Version of Suse Linux+/Sound Card+/Video Card. ;-)

Take care,
Kumar