<?php
ini_set( "max_execution_time", 3600 );
require("class.phpmailer.php");

$mail = new phpmailer();

//$mail->From       = "eBlast@kidspages.org";
//$mail->AddReplyTo = "eBlast@kidspages.org";
//$mail->FromName   = "Kids' Pages Family";

$mail->Mailer     = "mail";

@MYSQL_CONNECT( "localhost", "kp_pnmonkey", "buster" );
@mysql_select_db( "kp_phoenix" );

$query = "select distinct email_address from kp_emails where ( email_address not in (select email_address from kp_emails_block) ) and ( email_address not in (select email from kp_ebook_unsubscribe) ) and ( email_address not in (select email from kp_ebook_sent ) )";

// $query = "select distinct email_address from kp_emails where email_address not in (select email_address from kp_emails_block)";
// $query = "select distinct email_address from kp_emails where ( email_address not in (select email_address from kp_emails_block) ) and ( email_address not in (select email from kp_ebook_unsubscribe) )"

echo '### Start: ' . date('l jS \of F Y h:i:s A') . "<br />";

$result = @MYSQL_QUERY($query);

$numrows = mysql_num_rows( $result );
echo "$numrows addresses to process... <br />";
$count = 0;

while ( $row = mysql_fetch_array ( $result ) )
{
  $email_address = $row["email_address"];
  $count++;

// HTML body
$body =
<<<EOT


<html>
<head>
<title>KidsPages.org - FREE Family Fun!</title>
</head>
<body>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="center" bgcolor="#FFFFFF">
<table border="0" cellpadding="0" cellspacing="0" width="575">
<tr>
<td align="left" bgcolor="#FFFFFF" height="50" valign="top"><a href="http://kidspages.org" target="_blank"><img alt="kidspages.org" src="http://kidspages.org/newsletter/images/logos/KidsPagesLogo-06.gif" width="384" height="80" border="0" /></a></td>
<td align="right" bgcolor="#FFFFFF" height="50" style="line-height:0px; font-size:0px;" valign="top">&nbsp;</td>
</tr>
<tr>
<td colspan="2">
<hr color="#B7CD60" noshade="noshade" size="1px">
</td>
</tr>
<tr>
<td colspan="2">
<div style="font-family:Arial, Helvetica, sans-serif;font-size:25px;font-weight:bold;padding-bottom:6px;color:#594022;">
<div style="font-size:15px;color:black;line-height:150%;">
</div>
</div>
</td>
</tr>
<tr>
<td height="100%" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<!-- 1 Let's Camp! -->
<tr>
<td align="left" bgcolor="#FFFFFF" height="100%">
<table border="0" cellpadding="0" cellspacing="0" height="100%" width="381">
<tr>
<td colspan="2" height="12" rowspan="2" style="line-height:0px; font-size:0px;" width="12"><img height="12" src="http://kidspages.org/newsletter/images/2008-04-01/color001_ul_corner.jpg" width="12" alt="" /></td>
<td bgcolor="#9A9B96" height="1px" style="line-height:0px; font-size:0px;" width="357"></td>
<td colspan="2" height="12" rowspan="2" style="line-height:0px; font-size:0px;" width="12"><img height="12" src="http://kidspages.org/newsletter/images/2008-04-01/color001_ur_corner.jpg" width="12" alt="" /></td>
</tr>
<tr><td bgcolor="#E2E5D2" height="11" style="line-height:0px; font-size:0px;"></td></tr>
<tr>
<td bgcolor="#9A9B96" height="100%" style="line-height:0px; font-size:0px;" width="1"></td><td bgcolor="#E2E5D2" height="100%" style="line-height:0px; font-size:0px;" width="11"></td>
<td align="left" bgcolor="#E2E5D2" height="100%" style="font-size: 12px; color:#343436; line-height:16px;" valign="top">
<div style="font-family:Arial, Helvetica, sans-serif;font-size:25px;line-height:27px;font-weight:bold;padding-bottom:10px;color:#005bab;">
LEARN TO CAMP WITH US!
</div>
<font style="font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:21px;">
<div>
<a href="http://parks.state.co.us/camping/Pages/LetsCamp.aspx" target="_blank"><img src="http://kidspages.org/newsletter/images/2012-06-15/LetsCamp.jpg" width="355" height="322" border="0" alt="" /></a>
</div>
<p>Colorado Parks and Wildlife is introducing a first-time family camping program that gives novice campers a chance to experience the Colorado outdoors. No prior outdoor knowledge is needed and there's even new loaner equipment for you and your family to use!</p>
<p>Officially named Let's Camp!, the program covers all the fundamentals of camping and cooking outdoors, while showing attendees some of the fun open-air activities that can make your camping trip one you won't forget.</p>
<p>The Let's Camp! program will take place from approximately noon on Sundays through noon on Mondays on the following dates and locations:</p>
<ul>
<li>July 1-2 at Chatfield State Park</li>
<li>July 8-9 at Golden Gate Canyon State Park</li>
<li>July 29-30 at Golden Gate Canyon State Park</li>
<li>August 5-6 at Chatfield State Park</li>
</ul>
<p>All equipment except food, sleeping bags and personal utensils/dishes will be available for participants who need it. (Don't worry, they'll even give you a list of food you should bring and help you how to cook it camping style.)</p>
<p>Registrants are encouraged to register early as space is limited.</p>
<strong>
For more information about the Let's Camp! program and to reserve your spot today, visit <a href="http://parks.state.co.us/camping/Pages/LetsCamp.aspx" target="_blank">parks.state.co.us/camping/Pages/LetsCamp.aspx</a>.
</strong>
<div>
<a href="http://parks.state.co.us/camping/Pages/LetsCamp.aspx" target="_blank"><img src="http://kidspages.org/newsletter/images/2012-06-15/ColoradoParkWildlife-logo.gif" width="355" height="127" border="0" alt="" /></a>
</div>
</font>
</td>
<td bgcolor="#E2E5D2" height="100%" width="11"></td><td bgcolor="#9A9B96" height="100%" width="1"></td>
</tr>
<tr><td colspan="5" style="line-height:0px; font-size:0px;"><img height="12" src="http://kidspages.org/newsletter/images/2008-04-01/color001_bottom.jpg" width="381" alt="" /></td></tr>
<tr><td colspan="5" style="line-height:0px; font-size:0px;"><img height="14" src="http://kidspages.org/newsletter/images/2008-04-01/pix.gif" width="1" alt="" /></td></tr>
</table>
</td>
</tr>
<!-- /1 Let's Camp! -->
</table>
</td>
<td align="right" height="100%" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="177">
<tr>
<td colspan="5" style="line-height:0px; font-size:0px;"><img alt="Kids' Pages eBlast" src="http://kidspages.org/newsletter/images/2012-06-01/kphead.gif" width="177" height="59"></td>
</tr>
<tr>
<td bgcolor="#999999" height="100%" width="1"></td>
<td bgcolor="#E3EDB9" height="100%" width="11"></td>
<td align="center" bgcolor="#E3EDB9" height="100%" style="font-family:Arial, Helvetica, sans-serif;font-size:12px; color:#343436;padding-bottom:3px; line-height:16px;" valign="top" width="153">
<br />
<!-- Sidebar: 01 -->
<div style="padding-right:0px;padding-top:0px;padding-bottom:10px;">
<a href="http://kidspages.org" target="_blank"><img src="http://kidspages.org/newsletter/images/2010-02-01/CalendarFamily.gif" width="150" height="209" border="0" alt="" /></a>
</div>
<div align="center" style="font-size:17px; line-height: 19px; font-weight:bold; color:#4e5670;">
<em>The</em> #1 Events Calendar for Front Range Families!
</div>
<div style="text-align:center;line-height:150%;">
<p style="margin-top:5px;">
<a href="http://kidspages.org" target="_blank">KidsPages.org</a> brings you the Most Comprehensive Family Calendar with hundreds of free and low-cost events. Enjoy!
</p>
<p style="margin-top:0px;"><a href="http://kidspages.org" target="_blank">Click here to visit your Family Calendar!</a></p>
</div>
<br />
<!-- /Sidebar: 01 -->
<!-- Sidebar: 02 -->
<div style="padding-right:0px;padding-top:0px;padding-bottom:10px;">
<a href="http://kidspages.org/contests" target="_blank"><img src="http://kidspages.org/newsletter/images/2010-03-01/MonthlyContests.gif" width="150" height="209" border="0" alt="" /></a>
</div>
<div align="center" style="font-size:17px; line-height: 19px; font-weight:bold; color:#4e5670;">
Kids' Pages Monthly Contests
</div>
<div style="text-align:center;line-height:150%;">
<p style="margin-top:5px;">
<b>Every month</b> <a href="http://kidspages.org/contests" target="_blank">Kids' Pages</a> has the best and most exciting contests around. Don't miss out, enter today!
</p>
<p style="margin-top:0px;"><a href="http://kidspages.org/contests" target="_blank">Click here and<br />enter to win today!</a></p>
</div>
<br />
<!-- /Sidebar: 02 -->
</td>
<td bgcolor="#E3EDB9" height="100%" style="line-height:0px; font-size:0px;" width="11"></td>
<td bgcolor="#999999" height="100%" style="line-height:0px; font-size:0px;" width="1"></td>
</tr>
<tr>
<td colspan="5" style="padding: 0 0 14px 0; line-height:0px; font-size:0px;"><img border="0" height="12" src="http://kidspages.org/newsletter/images/2008-04-01/kpbook_bottom.jpg" width="177" alt="" /></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table align="center" border="0" cellpadding="0" cellspacing="0" width="575">
<tr>
<td align="left" valign="top" width="100%">
<p style="font-size:9px;">
<font color="#000000" face="Verdana, Arial, Helvetica, sans-serif" size="1" style="font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif;">
Don't see the images in this e-mail? Please add eblast@KidsPages.org to<br /> your address book or safe senders list.<br />
<br />
You are receiving these eBlasts because of your relationship with KidsPages.org.<br />
We will never share our mailing list with anyone. If you do not wish to continue<br />
receiving these announcements, please click <a href="http://kidspages.org/unsubscribe/$email_address">here</a> to unsubscribe.<br />
<br />
&copy; Copyright 2012 Kids Pages Family Media, Inc.
</font>
</p>
</td>
</tr>
</table>
</body>
</html>


EOT;

// Plain text body (for mail clients that cannot read HTML)
$text_body  =
<<<EOT

FREE Family Fun Galore!

Go to KidsPages.org to visit the Most Comprehensive Family Calendar with hundreds of free and low-cost events. Enjoy!

EOT;

//  $mail->From       = "eBlast@kidspages.org";
//  $mail->AddReplyTo = "eBlast@kidspages.org";
//  $mail->FromName   = "Kids' Pages Family";
//  $mail->Mailer     = "mail";
//  $mail->AddReplyTo = "eBlast@kidspages.org";
//  $mail->FromName   = "Kids' Pages Family";

  $mail->SetFrom("eBlast@kidspages.org", "Kids' Pages Family");
  $mail->AddReplyTo("eBlast@kidspages.org", "Kids' Pages Family");
  $mail->Mailer     = "mail";

  $mail->Body    = $body;
  $mail->AltBody = $text_body;

//  $mail->Subject = "The #1 Events Calendar for Front Range Families!";
//  $mail->Subject = "Watch Kids' Pages Every Friday Morning on TV!";
//  $mail->Subject = "February Fun from Kids' Pages";

//  $mail->Subject = "Summer Camping Fun from Kids' Pages";

  $mail->Subject = "Let's Camp! with Colorado Parks and Wildlife";
  $mail->AddAddress( $email_address );

//    echo "NOT sending $count / $numrows to " . $email_address . "<br>";
//    $insertsql = "INSERT INTO `kp_ebook_sent` (`email`) VALUES ( '$email_address' )";
//    $insert_success = MYSQL_QUERY( $insertsql );
//    echo "insert was" . ( $insert_success ? " very" : " NOT" ) . " successful<br /><br />";

  if ( !$mail->Send() )
  {
    echo "$count / $numrows : There has been a mail error sending to " . $email_address . "<br>";
  }
  else
  {
    echo "$count / $numrows : Success sending to " . $email_address . "<br>";

    $insertsql = "INSERT INTO `kp_ebook_sent` (`email`) VALUES ( '$email_address' )";
    @MYSQL_QUERY( $insertsql );
  }

  // Clear all addresses and attachments for next loop
  $mail->ClearAddresses();
  $mail->ClearAttachments();
}

  echo "<br />";
  echo "### COMPLETE ###<br />";
  echo '### End: ' . date('l jS \of F Y h:i:s A') . "<br />";
?>
