<?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-04.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 Apex -->
<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;">
Father's Day 5K Run,<br />Family Fun Run &<br />Father's Day Car Show!
</div>
<div>
<a href="http://apexprd.org/5k" target="_blank"><img src="http://kidspages.org/newsletter/images/2012-04-01/5KLogo.gif" width="355" height="255" border="0" alt=""></a>
</div>
<div style="font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:21px;">
<p><strong>Sunday, June 17 at the Apex Center!</strong></p>
<p>Join the fun for the fifth annual Father's Day 5K Run<br />(8am) and Family Fun Run (9am) at the Apex Center. FREE "Run Dri" running hats for the first 500 5K registrations!</p>
<p>A perfect way to celebrate Father's Day, this family-friendly event starts and ends at the Apex Center. Then from 9am to 3pm, the 8th annual Father's Day Car Show is on, with classic cars, music, refreshments and kids' activities in the Apex Center parking lot. It's free for spectators.</p>
<p>Proceeds from both events go to the Apex PRD Foundation to help keep recreation affordable for community youth.</p>
<strong>
Sign up now for the 5K...early bird registration ends April 15! The Fun Run is free for all ages, and no registration is required.<br />
<br />
Register at <a href="http://apexprd.org/5k-registration" target="_blank">apexprd.org/5k-registration</a>. For more event details, visit <a href="http://apexprd.org/5k" target="_blank">apexprd.org/5k</a>. For information on the car show, visit <a href="http://foundation.apexprd.org" target="_blank">foundation.apexprd.org</a>.<br />
<br />
</strong>
<div>
<a href="http://apexprd.org/5k" target="_blank"><img src="http://kidspages.org/newsletter/images/2011-11-01/apex-logo.gif" width="355" height="199" border="0" alt="" /></a>
</div>
</div>
</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 Apex -->
<!-- 2 Heritage Square -->
<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;">
The Heritage Square Easter Fun Festival -- FREE!
</div>
<font style="font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:21px;">
<div> 
<a href="http://heritagesquare.info" target="_blank"><img src="http://kidspages.org/newsletter/images/2012-04-01/HS-Easter.gif" width="355" height="266" border="0" alt="" /></a> 
</div> 
<p><strong>Saturday April 7th</strong></p>
<p>Meet the Easter Bunny!</p>
<p>It's an Egg-stravaganza, from 11am-3pm. Bring your Easter basket...merchants will be handing out free candy. Meet the Easter Bunny and play in the giant tower of bubbles. Best of all, entry is free.</p>
Other Entertainment Includes:<br />
<ul>
<li>Stilt Party</li>
<li>Giant Parade Puppet</li>
<li>Stretch, the 9-Foot Clown</li>
<li>Balloon Artist</li>
<li>Juggler</li>
</ul>
</strong>
Heritage Square is located just 15 minutes west of Denver. Take I-70 to exit 259 then north 1 mile to Heritage Square, parking is free and so is admission.<br />
<br />
For more information on Heritage Square, the Easter Festival, and other events go to <a href="http://www.heritagesquare.info" target="_blank">www.heritagesquare.info</a><br />
<br />
Heritage Square, where fun is a family tradition.<br />
</strong>
<div>
<a href="http://heritagesquare.info" target="_blank"><img src="http://kidspages.org/newsletter/images/2010-11-01/HeritageSquare-logo.gif" width="270" height="230" 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>
<!-- /2 Heritage Square -->
</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-04-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 = "April Fun from Kids' Pages";
  $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 />";
?>
