<?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 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;">
Join the Fun at<br />Heritage Square!
</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-06-01/HeritageSquare-PythonScream.jpg" width="355" height="263" border="0" alt="" /></a>
</div>
<p>New rides and more attractions than ever before!</p>
<p>All Rides, attractions, go-carts, giant maze and alpine slide are now open daily.</p>
<p>Bring the whole family. Free Admission and parking.</p>
<p>Enjoy a day nestled in the foothills of Golden at Heritage Square Family Entertainment Village.</p>
<p>Heritage Square is a great place to hold your special event, corporate picnic, birthday party or family reunion.</p>
<strong>
Just 20 minutes west of Denver in Golden, Heritage Square takes fun to a new level. Free parking and no general admission fees.<br />
<br />
Check out all of the fun things happening at <a href="http://www.heritagesquare.info" target="_blank">www.heritagesquare.info</a>!<br />
<br />
</strong>
<div>
<a href="http://heritagesquare.info" target="_blank"><img src="http://kidspages.org/newsletter/images/2012-05-01/HeritageSquare-logo.gif" width="304" height="152" 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 Heritage Square -->
<!-- 2 Hipster -->
<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;">
Help Produce a Great Movie -- <em>Hipster! The Musical</em>
</div>
<font style="font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:21px;">
<div style="float:left;padding: 5px 5px 5px 0px;">
<a href="http://www.kickstarter.com/projects/adamblair/hipster-the-musical" target="_blank"><img src="http://kidspages.org/newsletter/images/2012-06-01/Hipster-Poster.jpg" width="200" height="300" border="0" alt="" /></a>
</div>
<p><em>Hipster! The Musical</em> is a feature-length comedy all about what it means to be yourself. It will make you laugh, make you cry, and make you want to sing along!</p>
<p>The film is in the early stages of production, and you are in a unique position to secure early online access to the movie, get awesome merchandise, including a t-shirt and a signed poster, and even get your very own Hipster outfit, complete with a prop from the film. You can also feel good about supporting a locally-produced film.</p>
<p>The story follows Dave, a shy college kid who must embrace his inner irony (and grow a beard) to try one last time to captivate the girl he loves through song and dance.</p>
<strong>
For more information and to help produce this movie, check out our Kickstarter campaign <a href="http://www.kickstarter.com/projects/adamblair/hipster-the-musical" target="_blank">here</a> and help make movie history!<br />
<br />
What are you waiting for, click now!<br />
<em><a href="http://www.kickstarter.com/projects/adamblair/hipster-the-musical" target="_blank">Hipster! The Musical</a></em><br />
</strong>
<div style="padding-top:5px;">
<a href="http://www.kickstarter.com/projects/adamblair/hipster-the-musical" target="_blank"><img src="http://kidspages.org/newsletter/images/2012-06-01/Hipster-logo.gif" width="310" height="176" 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 Hipster -->
<!-- 3 Harkins -->
<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;">
Here Comes  Harkins Summer Movie Fun Program for Kids!
</div>
<font style="font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:21px;">
<div style="float:left;padding: 5px 5px 5px 0px;">
<a href="http://www.harkinstheatres.com/smf" target="_blank"><img src="http://kidspages.org/newsletter/images/2012-05-01/HAR_SMF2012_Denver_176x195.jpg" width="176" height="195" border="0" alt="" /></a>
</div>
<p>It's summertime!</p>
<p>And that means two things; blockbuster movies and the Harkins Summer Movie Fun program for kids (all adults must be accompanied by children). For more than 35 years, Harkins Theatres has brought back some of Hollywood's best family films to keep kids entertained and cool during the summer.</p>
<p>Kids can enjoy a movie a week for 10 weeks, for 50 cents per film if you purchase the ten-week season ticket pack for $5. This year, blockbusters like "Kung Fu Panda 2," "Rio," and "The Smurfs" join the exciting line-up.</p>
<p>Make Harkins Summer Movie Fun for kids an annual tradition for your family.</p>
<strong>
For all titles and details, visit <a href="http://www.harkinstheatres.com/smf" target="_blank">www.harkinstheatres.com/smf</a>.
</strong>
<div>
<a href="http://www.harkinstheatres.com/smf" target="_blank"><img src="http://kidspages.org/newsletter/images/2011-06-01/Harkins-logo.gif" width="270" height="148" 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>
<!-- /3 Harkins -->
<!-- 4 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>
<!-- /4 Apex -->
</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 = "June 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 />";
?>
