<?
require_once("../config.php");
require_once("header.php");

if($HTTP_COOKIE_VARS["admin_log"]=="in")
{
echo "<p class=\"bodymd\">[ <a href=\"index.php\">Link Admin Home</a> | <a href=\"index.php?ax=addcat\">Add a Category</a> | <a href=\"index.php?ax=add\">Add a Link</a> | <a href=\"index.php?ax=logout\">Logout</a> | <a href=\"index.php?ax=install\">Install Links</a> ]</p>";



if(isset($_POST[s1]))
{
	if(empty($_POST[subject]) || empty($_POST[mm]))
	{
		echo "<br><center><font color=red size=2 face=verdana><b>All fields are required!</b></font></center>";
	}
	else
	{
		//get the users list
		$q1 = "select * from dd_newsletter";
		$r1 = mysql_query($q1) or die(mysql_error());
	
		if(mysql_num_rows($r1) > '0')
		{
			$from = "From: $noreply_mail <$noreply_mail>";
			$subject = $_POST[subject];
			while($a1 = mysql_fetch_array($r1))
			{
				$to = $a1[nemail];
				mail($to, $subject, $_POST[mm], $from);

				$i++;
			}

		}

		if(empty($i))
		{
			$i = "0";
		}

		echo "<br><center>$i messages was sent</center>";
	}
}

//get the users number
$q2 = "select count(*) from dd_newsletter";
$r2 = mysql_query($q2) or die(mysql_error());
$a2 = mysql_fetch_array($r2);
?>

<br>

<form method=post>

  <table align=center width=340>
    <caption align=right>&nbsp;
    </caption>
    <tr style="background-color:#ffffff; color:black; font-weight:bold">
      <td align=center><font size=1 face=verdana>You have 
        <?=$a2[0]?>
        registered newsletter subscribers!</font> </td>
    </tr>
    <tr style="background-color:#000000; color:white; font-weight:bold"> 
      <td align=center>Newsletter' Subject Line:</td>
    </tr>
    <tr> 
      <td align=center><input type=text name=subject size=41></td>
    </tr>
    <tr style="background-color:#000000; color:white; font-weight:bold"> 
      <td align=center>Message:</td>
    </tr>
    <tr> 
      <td align=center><textarea cols=39 rows=10 name=mm></textarea></td>
    </tr>
    <tr> 
      <td align=center> <input type=submit name=s1 value=Send> </td>
    </tr>
  </table>

</form>
<?
//get the subscribers
$q1 = "select * from dd_newsletter";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) == '0')
{
	exit();
}

while($a1 = mysql_fetch_array($r1))
{
	?>
<center>
  <table width="400" border="0" cellspacing="0" cellpadding="3">
    <tr> 
      <td width="216"> 
        <?=$a1[nemail]?>
      </td>
      <td width="74"><div align="center"><a class=DNav href="ContacSubscriber.php?nemail=<?=$a1[nemail]?>">email</a></div></td>
      <td width="74"><div align="center"><a class=DNav href="DeleteSubscriber.php?nemail=<?=$a1[nemail]?>">delete</a> 
        </div></td>
    </tr>
  </table>
  </center>
	<?
}
}

else
{
	echo "<a href=index.php>Click here to login</a>";
			
			}

require_once("footer.php");
	ob_end_flush();
?>