<?php
/**
 * newboard.php - Modern message board view (replaces newboard.cfm)
 *
 * Auth check. Table display of threads from wbtable with alternating row colors.
 * Post message form at bottom. Links to readmessage.php.
 */
require 'header.php';
requireLogin();

$db = getReadDb();

// Fetch recent threads from wbtable
$stmt = $db->prepare("SELECT * FROM wbtable ORDER BY lastcomment DESC LIMIT 50");
$stmt->execute();
$threads = $stmt->fetchAll();
?>

	<section id="content" class="sbr">
		<div class="menu-shadow"></div>
		<div class="container clearfix">
			<div class="page-header clearfix" style="margin-bottom: 20px;">
				<h1>Message Board </h1>
				<strong><div align="center"><a href="newboard.php#post">Post a New Message</a> | <a href="board.php">Classic View</a></div></strong>

				<div class="line"></div>
			</div>
			<!--/ .page-header-->

			<section id="main" class="twelve columns">
				<article class="entry clearfix">
					<!--/ .entry-title-->

					<!--/ .preloader-->

					<!--/ .entry-meta-->

					<div class="entry-body">


<p>

<div align="center">
<table width="100%" cellspacing="0" cellpadding="4" border="1" bordercolor="black">
<tr style="background-color:black;border-color: black;border-style: solid;border-width: 1px;">
<td style="padding:4px;"><font face="arial" size="-1" color="white"><strong>Topic</strong></td>
<td style="padding:4px;"><font face="arial" size="-1" color="white"><strong>Replies</strong></td>
<td style="padding:4px;"><font face="arial" size="-1" color="white"><strong>Last Comment</strong></td>
<td style="padding:4px;"><font face="arial" size="-1" color="white"><strong>Started By</strong></td>
</tr>
<?php
$currentRow = 0;
foreach ($threads as $row):
    $currentRow++;
    $bgColor = ($currentRow % 2 === 1) ? '#ffffff' : '#ffffcf';
    $topicId = (int)$row['id'];
?>
<tr style="background-color:<?php echo $bgColor; ?>">
<td style="border-color: black;border-style: solid;border-width: 1px;padding:4px;"><font color="black" size="-1"><a href="readmessage.php?m=<?php echo $topicId; ?>&amp;mid=<?php echo $topicId; ?>" style="text-decoration: underline;"><?php echo h($row['topic']); ?></a></td>
<td style="border-color: black;border-style: solid;border-width: 1px;padding:4px;"><font color="black" size="-1"><div align="center"><?php echo (int)$row['replies']; ?></div></td>
<td style="border-color: black;border-style: solid;border-width: 1px;padding:4px;"><font color="black" size="-1">
<?php
    $lc = $row['lastcomment'];
    echo date('n/j/y', strtotime($lc)) . ' ' . date('h:i:s A', strtotime($lc));
?>
<br>by: <?php echo h($row['lastcommentbyfirst']) . ' ' . h(mb_substr($row['lastcommentbylast'], 0, 1)); ?>.</td>
<td style="border-color: black;border-style: solid;border-width: 1px;padding:4px;"><font color="black" size="-1"><?php echo h($row['topicstartedbyfirst']) . ' ' . h(mb_substr($row['topicstartedbylast'], 0, 1)); ?>.</td>
</tr>
<?php endforeach; ?>
</table>
</div>
<p>

<a name="post">
<form action="postmessage.php" method="post">
<br><table width="540" cellspacing="5" cellpadding="5">
	  <tr><td colspan="2"><strong><font face="Arial" size="+1">Post Message</font></strong></td>
	  </tr>
	  <tr><td>
	  <b><font size="-1" face="Arial">Name:</font></b>
	  </td><td>
	  <?php echo h($getUser['fname']) . ' ' . h($getUser['lname']); ?>
	  <input name="fname" value="<?php echo h($getUser['fname']); ?>" type="hidden">
	  <input name="lname" value="<?php echo h($getUser['lname']); ?>" type="hidden">
 </td></tr><tr><td>
	  <b><font size="-1" face="Arial">Member:</font></b>
	  </td><td>
	  <?php echo h($getUser['member']); ?> <input name="member" value="<?php echo h($getUser['member']); ?>" type="hidden">
	  </td>
	  </tr>
	  <tr>
	  <td>
	  <b><font size="-1" face="Arial">E-Mail:</font></b>
	  </td>
	  <td>
	  <?php echo h($getUser['email']); ?>
	  <input name="email" value="<?php echo h($getUser['email']); ?>" type="hidden">
	  </td>
	  </tr>
	  <tr>
	  <td>
	  <b><font size="-1" face="Arial"><b>Subject:</b></font>
	  </td>
	  <td>
	  <input name="Subject" size="50" maxlength="100" style="border: 1px;border-style: dashed;border-color:purple;">
	  <input type="hidden" name="Subject_required" value="You must enter a Subject!">
	  </td>
	  </tr>
	  <tr>
	  <td colspan="2">
	  <p>
	  <b><font size="-1" face="Arial">Message:</font></b>
      <textarea name="Message" rows="10" cols="65" wrap="virtual" style="border: 1px;border-style: dashed;border-color:purple;"></textarea>
	  </td>
	  </tr>
      <tr>
      <td>
      <b><font face="Arial" size="-1">Optional Link:</font></b>
      </td>
      <td>
      <input name="Link" size="50" style="border: 1px;border-style: dashed;border-color:purple;">
	  <input type="hidden" name="Link"><br>
      </td>
      </tr>
      <tr>
      <td>
      <b><font face="Arial" size="-1">Link Title:</font></b>
      </td>
      <td>
      <input name="LinkTitle" size="50" style="border: 1px;border-style: dashed;border-color:purple;">
	  <input type="hidden" name="LinkTitle"><br>
      </td>
      </tr>
      <tr>
      <td>
      <b><font face="Arial" size="-1">Optional Image:</font></b>
      </td>
      <td>
      <input name="Image" size="50" style="border: 1px;border-style: dashed;border-color:purple;">
	  <input type="hidden" name="Image"><br>
      </td>
      </tr>
	  <tr colspan="2">
      <td colspan="2">
      <b><font face="Arial" size="-1">Also send responses to my email address:</font></b>
      <input name="responses" type="checkbox" style="border: 1px;border-style: dashed;border-color:purple;">
	  <br>
</td></tr></table>
<center><b><input type="submit" name="Preview" value="Preview">&nbsp;<input type="submit" value="Post Message"></b></center>
</center></form>
</td></tr></table>



						<!--/ .about-author-->

					</div>
					<!--/ .entry-body-->

				</article>
				<!--/ .entry-->
			</section>				<!--/ #main-->


<?php require 'sidebar.php'; ?>
<?php require 'footer.php'; ?>