<?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/2009-06-01/KidsPagesLogo-0906.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%;">
<p style="margin: 0 0 4px 0">FREE Family Fun Galore!</p>
<p style="margin: 0 0 4px 0"><a href="http://KidsPages.org" target="_blank">Click here</a> to visit your Complete Family Resource for<br />Festivities and Family Fun throughout the Front Range!</p>
</div>
</div>
</td>
</tr>
<tr>
<td height="100%" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<!-- 1 -->
<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:2px;color:#005bab;">
Leapin' Lizards! Your favorite red-headed orphan and her dog are back on the BDT stage all summer long!
</div>
<font style="font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:21px;">
<div style="float:right;padding: 5px 0px 5px 5px;"><a href="http://www.bouldersdinnertheatre.com" target="_blank"><img src="http://kidspages.org/newsletter/images/2009-06-15/Annie.jpg" width="220" height="240" border="0" alt="" /></a></div>
<p>Annie is a spunky Depression-era orphan determined to find her parents, who abandoned her years ago on the doorstep of a New York City Orphanage run by the cruel, embittered Miss Hannigan. In adventure after fun-filled adventure, Annie foils Miss Hannigan's evil machinations, befriends President Franklin Delano Roosevelt and finds a new family and home in billionaire Oliver Warbucks, his personal secretary Grace Farrell and a lovable mutt named Sandy.</p>
<p>Annie won seven Tony Awards, including Best Musical and Best Score, and features some of the most famous music on Broadway, including: <em>Hard Knock Life</em>, <em>Tomorrow</em>, <em>I Think I'm Gonna Like It Here</em> and <em>You're Never Fully Dressed Without a Smile</em>.</p>
<p>Family 4-Packs are on sale now beginning at just $100! (Family 4-Packs are valid for June and July performances only, and cannot be combined with any other discount, offer or promotion, including group, senior and/or child ticket pricing.)</p>
<strong>
<p>Playing at Boulder's Dinner Theatre<br />through September 5.</p>
Reserve your tickets today online at <a href="http://www.bouldersdinnertheatre.com" target="_blank">www.bouldersdinnertheatre.com</a>, or by calling or visiting our box office.<br/>
5501 Arapahoe Ave., Boulder<br />
303-449-6000
</strong>
<div>
<a href="http://www.bouldersdinnertheatre.com" target="_blank"><img src="http://kidspages.org/newsletter/images/2009-06-15/BoulderDinnerTheatreLogo.gif" width="301" height="86" 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 -->
<!-- 2 -->
<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:2px;color:#005bab;">
8th Annual Arvada Gold Strike Festival
</div>
<font style="font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:21px;">
<div style="float:right;padding: 5px 0px 5px 5px;"><a href="http://www.historicarvada.org" target="_blank"><img src="http://kidspages.org/newsletter/images/2009-06-15/GoldStrikeFestival.jpg" width="163" height="295" border="0" alt="" /></a></div>
<p>Mark your calendar now for a very special Gold Strike Festival -- this year to be held on the 158th anniversary of Lewis Ralston's discovery of gold on June 22, 1850 in Ralston Creek.</p>
<p>With nearly 100 vendors, live music, a Pets & Kids Parade, and special activities for the kids, you'll want to be there for the Arvada Gold Strike Festival!</p>
<strong>
Saturday & Sunday June 20-21<br />
<a href="http://www.historicarvada.org" target="_blank">www.historicarvada.org</a>
</strong>
<div>
<a href="http://www.historicarvada.org" target="_blank"><img src="http://kidspages.org/newsletter/images/2009-06-15/ArvadaGoldStrikeLogo.gif" width="150" 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>
<!-- /2 -->
<!-- 3 -->
<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:2px;color:#005bab;">
The best Birthdays in town are at Heritage Square!
</div>
<font style="font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:21px;">
<div style="float:right;padding: 5px 0px 5px 5px;"><a href="http://www.HeritageSquareAmusementPark.com" target="_blank"><img src="http://kidspages.org/newsletter/images/2009-06-15/HeritageSquare.jpg" width="200" height="213" border="0" alt="" /></a></div>
<p>Let them handle all of the details while you just enjoy the fun! The kids will have plenty to do with all of their attractions including <a href="http://www.heritagesquareamusementpark.com/arcade.html" target="_blank">arcade games</a>, <a href="http://www.heritagesquareamusementpark.com/minigolf.html" target="_blank">miniature golf</a>, <a href="http://www.heritagesquareamusementpark.com/gokarts.html" target="_blank">3 go-kart tracks</a>, and more! They have special birthday party tables that are reserved especially for you. They provide food, drink, all paper wares, and anything else that is necessary. It is the <a href="http://www.heritagesquareamusementpark.com/birthdayparties.html" target="_blank">perfect birthday party</a>!</p>
<strong>
<p><a href="http://www.heritagesquareamusementpark.com/kidspages.html" target="_blank">Click here</a> for their Kids' Pages Birthday Specials!</p>
Visit their website at <a href="http://www.HeritageSquareAmusementPark.com" target="_blank">www.HeritageSquareAmusementPark.com</a> for more information or call 303-PARTIES.
</strong>
<div>
<a href="http://www.HeritageSquareAmusementPark.com" target="_blank"><img src="http://kidspages.org/newsletter/images/2009-05-01/HeritageSquare-logo.gif" width="270" height="97" 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 -->
</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/2009-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: Fairs and Festivals Galore! -->
<div style="padding-right:0px;padding-top:0px;padding-bottom:10px;">
<a href="http://kidspages.org/2009/06/monthly-feature/fairs-festivals-in-june-and-july-2009-part-one" target="_blank"><img src="http://kidspages.org/newsletter/images/2009-06-01/sidebar1-FairsAndFestivals.jpg" width="150" height="100" border="0" alt="" /></a>
</div>
<div align="center" style="font-size:17px; line-height: 19px; font-weight:bold; color:#4e5670;">
Fairs and<br />Festivals Galore!
</div>
<div style="text-align:center;line-height:150%;">
<p style="margin-top:5px;">
Summer in Colorado is full of sun, fun, fairs and festivals! Enjoy music, culinary delights, dancing, artwork, rodeos, picnics, midways, three-legged races and much, much more <em>every</em> weekend this June and July. Best of all, most of the festivals offer FREE admission, although there is usually a charge for food and some activities. Click here for a schedule of all the awesome family fun!
</p>
<p style="margin-top:0px;"><a href="http://kidspages.org/2009/06/monthly-feature/fairs-festivals-in-june-and-july-2009-part-one" target="_blank">Read it now.</a></p>
</div>
<br />
<!-- /Sidebar: Fairs and Festivals Galore! -->
<!-- Sidebar: Are we there yet? -->
<div style="padding-right:0px;padding-top:0px;padding-bottom:10px;">
<a href="http://kidspages.org/2009/06/monthly-feature/are-we-there-yet" target="_blank"><img src="http://kidspages.org/newsletter/images/2009-06-01/sidebar2-AreWeThereYet.jpg" width="150" height="118" border="0" alt="" /></a>
</div>
<div align="center" style="font-size:17px; line-height: 19px; font-weight:bold; color:#4e5670;">
Are we there yet?
</div>
<div style="text-align:center;line-height:150%;">
<p style="margin-top:5px;">
Family vacations are a time to make memories, not a time for stress. Learn Six Steps for Trip Success in this month's Kids' Pages and make your family road trip one you'll cherish.
</p>
<p style="margin-top:0px;"><a href="http://kidspages.org/2009/06/monthly-feature/are-we-there-yet" target="_blank">Read it now.</a></p>
</div>
<br />
<!-- /Sidebar: Are we there yet? -->
<!-- Sidebar: Wild About Wildlife! -->
<div style="padding-right:0px;padding-top:0px;padding-bottom:10px;">
<a href="http://kidspages.org/2009/06/monthly-feature/please-dont-feed-the-animals" target="_blank"><img src="http://kidspages.org/newsletter/images/2009-06-01/sidebar3-Wildlife.jpg" width="150" height="113" border="0" alt="" /></a>
</div>
<div align="center" style="font-size:17px; line-height: 19px; font-weight:bold; color:#4e5670;">
Wild About Wildlife!
</div>
<div style="text-align:center;line-height:150%;">
<p style="margin-top:5px;">
One of the perks of living in Colorado is enjoying all of the breathtaking scenery that surrounds us. The open space areas, parks and forests are rich assets to our state and also home to many species of wildlife. But did you know that some wildlife can exist and thrive in close proximity to neighborhoods and suburban communities? Why shouldn't you feed the animals? Learn this and much more about<br />our Colorado Wildlife<br />this month!
</p>
<p style="margin-top:0px;"><a href="http://kidspages.org/2009/06/monthly-feature/please-dont-feed-the-animals" target="_blank">Read it now.</a></p>
</div>
<!-- /Sidebar: Wild About Wildlife! -->
</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 bimonthly 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 2009 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 your Complete Family Resource for Festivities and Family Fun throughout the Front Range!

EOT;

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

  $mail->Body    = $body;
  $mail->AltBody = $text_body;
  $mail->Subject = "MORE Free Family Fun this June 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 />";
?>
