<?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-10.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 - Boo Town -->
<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;">
Bootown Halloween Fun is back this October!
</div>
<font style="font-family:Arial, Helvetica, sans-serif;font-size:14px;line-height:21px;">
<a href="http://www.heritagesquareamusementpark.com" target="_blank"><img src="http://kidspages.org/newsletter/images/2010-10-01/heritagesquare-bootown.jpg" width="340" height="227" border="0" alt="" /></a><br />
<p>Bootown Halloween Fun is Colorado's first and largest bi-level 3-D maze full of colorful and festive enchantment. Bootown is the place for children of all ages and family entertainment! On top of the adventure-filled 3-D Maze, take a walk through the huge pumpkin patch or pumpkin painting area. With FREE parking and affordable Halloween fun, Heritage Square is the place to be this October!</p>
<strong>
BooTown Hours<br />
Weekends in October from 11 am to 7pm<br />
Oct 8 thru Oct 31<br />
Glowing 3-D Maze Craze -- Nightly from 7pm-till<br />
<br />
Pricing<br />
Bootown 3D Maze is $8 per person (parents are free with children under 3)<br />
Admission includes your own set of 3D glasses and plenty of Halloween excitement.<br />
Paint-your-own pumpkins are $4 per pumpkin -- pumpkin and paint included in price!<br />
<br />
Visit us at <a href="http://www.heritagesquareamusementpark.com" target="_blank">www.heritagesquareamusementpark.com</a><br />for more.
</strong>
<p>Have fun with your family and help local underserved families: A donation to Metro Community Provider Network (MCPN) is made with the purchase of every BooTown ticket.</p>
</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 - Boo Town -->
<!-- 2 Butterfly Pavilion -->
<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;">
Halloween at the<br />Butterfly Pavilion!
</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.butterflies.org" target="_blank"><img src="http://kidspages.org/newsletter/images/2010-10-01/BufferflyPavilion.jpg" width="250" height="288" border="0" alt="" /></a>
</div>
<p>Experience Metro Denver's premier Halloween event for the whole family at the Butterfly Pavilion on October 22 & 23! Discover how fascinating spiders, tarantulas, and scorpions can be while enjoying a safe and educational trick-or-treating experience. Let us take the creepy out of the creepy crawlies! Enjoy hands-on activities, immersive exhibits, outdoor adventures and so much more! Costumes are encouraged! Learn more at <a href="http://www.butterflies.org" target="_blank">www.butterflies.org</a>.</p>
<strong>
Butterfly Pavilion<br />
6252 West 104th Avenue, Westminster<br />
303-469-5441<br />
For more information, crawl or fly over to <a href="http://butterflies.org" target="_blank">butterflies.org</a>
</strong>
<div>
<a href="http://butterflies.org" target="_blank"><img src="http://kidspages.org/newsletter/images/2010-06-01/ButterflyPavilion-logo.gif" width="213" height="104" 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 Butterfly Pavilion -->
<!-- 3 Elitch Gardens -->
<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;">
Tricks and Plenty of Treats at Elitch Gardens' Fright Fest
</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.ElitchGardens.com/FrightFestDenver" target="_blank"><img src="http://kidspages.org/newsletter/images/2011-10-01/FFgirl.jpg" width="184" height="282" border="0" alt="" /></a>
</div>
<p>Elitch Gardens Fright Fest is back and ready to bring tricks and treats to families across Colorado. With over 35,000 square feet of haunted space and 275 gallons of fog juice used, it's no wonder why Fright Fest is Denver's largest Halloween event. From October 1-31, little ghosts and goblins can enjoy the Trick or Treat Trail, partake in "Ghouls Matches" with costume and scream contests, and test their stomachs at "Gross Out For Kids" where they'll join the Hip HopSicals on stage and try out ghastly milkshake concoctions.</p>
<strong>
Every Saturday and Sunday from October 1-31<br />from noon-5pm.<br />
<br />
Buy daily admission tickets online -- just $37.99 for guests 48" or over; $27.99 for guests under 48" or over 62 years. Children 3 and under are free. Some attractions during Fright Fest will have an additional fee, but making you scream is priceless!<br />
<br />
Visit us at <a href="http://www.ElitchGardens.com/FrightFestDenver" target="_blank">www.ElitchGardens.com/FrightFestDenver</a><br />
</strong>
<div>
<a href="http://www.ElitchGardens.com/FrightFestDenver" target="_blank"><img src="http://kidspages.org/newsletter/images/2011-07-01/ElitchGardens-logo.gif" width="270" height="234" 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 Elitch Gardens -->
<!-- 4 Heritage Square -- Apline Slide -->
<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;">
Heritage Square Alpine Slide<br />
It's more than a ride...it's an experience!
</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.heritagesquarealpineslide.com" target="_blank"><img src="http://kidspages.org/newsletter/images/2011-10-01/alpinelogo.gif" width="199" height="97" border="0" alt="" /></a>
</div>
<p>Take the scenic chair lift to the top of the mountain, grab a sled and cruise down one of two 1/2 mile tracks. Home of Colorado's Best Alpine Slide and a Colorado Tradition for Over 30 years!</p>
<strong>Canned Food Drive</strong>
<p>Bring a can of food and get: $1 off on a single ride ($8) or $1.00 off a child's ticket ($4) (one can per ticket)</p>
<strong>
Saturdays & Sundays, Noon-5pm<br />
Through October 31<br />
303-279-1661<br />
Visit us at <a href="http://www.heritagesquarealpineslide.com" target="_blank">www.heritagesquarealpineslide.com</a><br />
</strong>
<div>
<a href="http://www.heritagesquarealpineslide.com" target="_blank"><img src="http://kidspages.org/newsletter/images/2010-10-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>
<!-- /4 Heritage Square -- Apline Slide -->
</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/2011-10-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 2011 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 = "October and Halloween 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 />";
?>
