<?php include 'common/includes/php_header.inc'; ?>
<?php
  // error checking
  if (!@$GLOBALS['NEWSLETTER_BUILDER_PLUGIN']) { die("You must activate the newsletter plugin to see this page."); }

  // load newsletters settings and archives
  global $newsletterSettings;
  $newsletterSettings  = mysql_get('_nlb_settings', 1);
  $archivedNewsletters = mysql_select('_nlb_messages', "send IN ('all','archive') ORDER BY sent_date DESC");

  // load newsletter
    $whereMessageNumIs = 'TRUE';

if (@$_REQUEST['message_num']){
 $whereMessageNumIs = " num = '".mysql_escape($_REQUEST['message_num'])."'";
}

list($_nlb_messages, $_nlb_messagesMetaData) = getRecords(array(
  'tableName'   => '_nlb_messages',
  'loadUploads' => true,
  'allowSearch' => false,
  'where'    	=> "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list']), '2') . "' AND " . $whereMessageNumIs,
//    'debugSql'            => true,
  'orderBy'     => 'sent_date ASC',
));

// replace placeholders
$archivedNewsletters = nlb_viewers_replacePlaceholders($archivedNewsletters);
$_nlb_messages       = nlb_viewers_replacePlaceholders($_nlb_messages);


?>
<!DOCTYPE html>
<html lang="en">
<head><meta http-equiv="Content-type" content="text/html; charset=UTF-8" />

<title>Weekly Message</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" media="screen" href="rw_common/themes/ks_headliner_5/consolidated-screen-1.css" />
<link rel="stylesheet" type="text/css" media="all" href="rw_common/themes/ks_headliner_5/consolidated-all-1.css" />

<!--[if IE 7]><link rel="stylesheet" type="text/css" media="screen" href="rw_common/themes/ks_headliner_5/css/ie7.css" />
<![endif]-->
<script type="text/javascript" src="rw_common/themes/ks_headliner_5/javascript.js"></script>



<?php include 'common/includes/gosquared.inc'; ?>
</head>
<body>
	<div id="complete-wrapper">
		<div id="container">
		<div id="wrapper">
			<div id="page">
				<div id="top">
						<div id="header-bg">
							<div id="header-left">
								<div id="logo"><a href="http://706aircadets.ca/" title="706 Air Cadets"></a> </div><!-- LOGO -->
								<div class="title-slogan">
									<h1 class="site-title"></h1>
									<h2 class="site-slogan"></h2>
								</div>
							</div>

							<div id="top-right">
								<div id="top-right-top">
									<div class="Xtra-menu"> </div>
								</div>
								<div id="logo-right"></div>
							</div>
						</div>

							<div class="clear"></div>
				</div><!-- END OF TOP -->
				<div id="navmenu-container">
					<div id="nav-menu">
					<?php include 'common/includes/menu.inc'; ?>
					</div>
				</div>
<div id="extraContainer1"></div>
<div id="header"><!-- BEGIN HEADER -->
	<div id="slideshow">

	</div>
	<div id="headline">
		<div id="extraheadlines2"></div>
	</div>
</div><!-- END OF HEADER -->


<div id="content"><!-- BEGIN CONTENT -->
	<div id="extraContainer2"></div>
		<div class="third-column">
			<div class="third-column-content"></div>
			<div class="leftcontent-pad">
				<div id="leftcolumn"></div>
			</div>
		<div class="clear"></div>
		</div>

	<div class="content-columns">
		<div class="content-pad">
		<div id="extraContainer3"></div>
		<h1>Weekly Message</h1>

<table cellspacing="2" cellpadding="4">
 <tr>
  <td valign="top">
 <form method="get" action="?">
Select a specific message below:<br>
    <?php if ($_nlb_messages): ?>
 <select name="message_num">
<option value="">--</option>
   <?php foreach($_nlb_messages as $message): ?>
     <option value="<?php echo htmlencode($message['num']); ?>" <?php selectedIf($message['num'], @$_REQUEST['message_num']); ?>>
       <?php echo htmlencode($message['subject']); ?>
     </option>

   <?php endforeach; ?>
 </select>
<?php endif; ?>
<br>
    <input type="submit" value="Submit">
  </form>


</td>
  <td valign="top">

    <b><?php echo htmlencode($message['subject']) ?></b><br/>
    <?php echo $message['html']; ?><br/>

  </td>

</tr>
</table>
		<div id="extraContainer4"></div></div>
		<div class="clear"></div>
	</div>

	<div class="sidebar">
		<div class="sidebar-content">
		<div id="myXtraMenu">
			<?php include "common/includes/top_menu.inc"; ?>
		</div><!-- #myXtraMenu -->

	</div><div class="clear"></div>
</div><!-- END OF CONTENT -->
			</div><!-- END OF PAGE -->
		</div><!-- END OF WRAPPER -->
	</div><!-- END OF CONTAINER -->

	<div class="clear"></div>
<div class="clear"></div>
	<div id="footer-wrapper">
		<div id="footer-content"></div>
		<div id="footer">
		<?php include "common/includes/footer.inc"; ?>
		<span class="breadcrumb margin-20-right"><div class="breadcrumbcontainer">
		<?php echo menu_displayBreadCrumbsHtml("15", $menuRecords); ?>
		</div></span>
		</div>
	<div class="clear"></div>
</div>

	<div class="clear"></div>
</div><!-- END OF COMPLETE-WRAPPER -->
<?php include "common/includes/endwrapper.inc"; ?>
</body>
</html>
