<?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");

  $where = 'TRUE';
  if (@$_REQUEST['to_list']){
   $where .= " AND to_list = '".mysql_escape($_REQUEST['to_list'])."'";
  }

  list($messageList, $_nlb_messagesMetaData) = getRecords(array(
    'tableName'   => '_nlb_messages',
    'loadUploads' => true,
    'allowSearch' => false,
    'orderBy'     => 'sent_date DESC',
    'where'       => $where,
  ));

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

  list($_nlb_messages, $_nlb_messagesMetaData) = getRecords(array(
    'tableName'   => '_nlb_messages',
  	'loadUploads' => true,
    'allowSearch' => false,
  	'orderBy'   	=> 'sent_date DESC',
    'where'       => $where,
  ));

  $_nlb_messages = nlb_viewers_replacePlaceholders($_nlb_messages);

  $mainMessage = @$_nlb_messages[0];

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

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

<title>Newsletter Archives</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>Newsletter Archives</h1>

<table cellspacing="2" cellpadding="4">
 <tr>
  <td valign="top">

    <b>Latest Newsletters</b><br/><br/>
<?php
$newsLetterLists = mysql_select('_nlb_lists'); // mailing lists
?>

<?php if ($newsLetterLists): ?>
  <form method="get" action="?">
  First select which list you want to view:<br>
    <select name="to_list">
      <option value="">--</option>
      <?php foreach($newsLetterLists as $list): ?>
        <option value="<?php echo htmlencode($list['num']); ?>" <?php selectedIf($list['num'], @$_REQUEST['to_list']); ?>>
          <?php echo htmlencode($list['name']); ?>
        </option>
      <?php endforeach; ?>
    </select>
    <br>
    <input type="submit" value="Submit">

    <br><br>
    Select a specific message below:<br>
    <?php if ($messageList): ?>
 <select name="message_num">
   <option value="">--</option>
   <?php foreach($messageList 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>
<?php endif; ?>
  </td>
   <td valign="top">
    <b><?php echo htmlencode($mainMessage['subject']) ?></b><br/>
    <?php echo $mainMessage['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("35", $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>
