<?php require 'header.php'; ?>

	<section id="content" class="sbr">
		<div class="menu-shadow"></div>
		<div class="container clearfix">
			<div class="page-header clearfix" style="margin-bottom: 20px;">
				<h1>View the Guestbook</h1>
				<div class="line"></div>
			</div>
			<!--/ .page-header-->

			<section id="main" class="twelve columns">
				<article class="entry clearfix">

					<div class="entry-body">
					<center><b><a href="guestbook.php#sign">Sign the Guestbook</a></b></center>

<br>All messages will be forwarded to Michael, but individual replies will not be sent.<br><br>

<?php
$pdo = getReadDb();
$sql = "SELECT * FROM guestbook WHERE displayitem=1";
$params = [];
if (isset($_GET['id']) && is_numeric($_GET['id'])) {
    $sql .= " AND id < ?";
    $params[] = $_GET['id'];
}
$sql .= " ORDER BY id DESC LIMIT 45";
$stmt = $pdo->prepare($sql);
$stmt->execute($params);
$entries = $stmt->fetchAll();
$lastId = null;

foreach ($entries as $row):
    if ($row['displayitem'] == '1'):
        $lastId = $row['id'];
?>
<table cellspacing="4" cellpadding="2" border="0" width="100%">
<tr><td align="right" width="120"><strong>Name:</strong></td><td width="100%"><?= h($row['name']) ?> <?php if (isset($getUser) && $getUser && $getUser['userlevel'] == '10'): ?><a href="deleteguestbook.php?id=<?= h($row['id']) ?>">delete entry</a><?php endif; ?></td></tr>
<tr><td align="right" width="120"><strong>Posted on:</strong></td><td width="250"><?= date('F j, Y', strtotime($row['currentdatetime'])) ?> <?= date('h:i A', strtotime($row['currentdatetime'])) ?></td></tr>
<tr><td align="right" width="120"><strong>Where are you from?:</strong></td><td width="435"> <?= h($row['location']) ?></td></tr>
<tr><td align="right" width="120"><strong>Referred By:</strong> </td><td width="250"> <?= h($row['referredby']) ?></td></tr>
<tr><td align="right" width="120" valign="top"><strong>Comments:</strong> </td><td width="250"><?= paragraphFormat(h($row['comments'])) ?></td></tr>
</table>
<hr color="black">
<?php
    endif;
endforeach;
?>

<strong><div align="center"><a href="guestbook.php?id=<?= h($lastId) ?>">Click Here for More Messages...</a></div></strong>
<p>
<strong><font face="arial" size="+1">&nbsp;Sign the Guestbook:<br>

Just a reminder that anonymous posts will be deleted, and that all posters do have their IP address, and their ISP name logged.
 </font>
</strong>
<a name="sign">
<?php $captchaCode = rand(1, 10000); ?>
<form action="sendguestbook.php" method="post">
<input type="hidden" name="Member" value="">
<input type="hidden" name="Email" value="">
<input type="hidden" name="HomepageURL" value="">
<input type="hidden" name="Homepagetitle" value="">
<center><table width="370" border="1">

<tr>
<td valign="top" style="vertical-align:middle;">&nbsp;<b>Name:</b></td>
<td valign="top" style="vertical-align:middle;">&nbsp;&nbsp;<input name="Name" maxlength="30" type="text" size="25">
<input name="Name_required" type="hidden" value="You must enter your name."></td>
</tr>

<tr>
<td style="vertical-align:middle;">&nbsp;<b>E-Mail Address:</b></td>
<td style="vertical-align:middle;">&nbsp;&nbsp;<input name="EMail" maxlength="30" type="text" size="25">
</td>
</tr>
<tr>
<td style="vertical-align:middle;">&nbsp;<b>Member # (Optional):</b></td>
<td style="vertical-align:middle;">&nbsp;&nbsp;<input name="Member" maxlength="30" type="text" size="25"></td>
</tr>
<tr>
<td style="vertical-align:middle;">&nbsp;<b>Where are you from?:</b></td>
<td style="vertical-align:middle;">&nbsp;&nbsp;<input name="Location" maxlength="30" type="text" size="25"></td>
</tr>
<tr>
<td style="vertical-align:middle;">&nbsp;<b>Referred By:</b></td>
<td style="vertical-align:middle;">&nbsp;
<select size="1" name="ReferredBy">
<option value="Just Surfed On In">Just Surfed On In</option>
<option value="Search Engine">Search Engine</option>
<option value="Web Ring">Web Ring</option>
<option value="E-Mail">E-Mail</option>
<option value="From a Friend">From a Friend</option>
<option value="Newsgroup">Newsgroup</option>
</select></td>
</tr>
<tr>
<td style="vertical-align:middle;">&nbsp;<b>Homepage Title:</b></td>
<td style="vertical-align:middle;">&nbsp;&nbsp;<input name="HomepageTitle" maxlength="30" type="text" size="25">
</td>
</tr>
<tr>
<td style="vertical-align:middle;">&nbsp;<b>Homepage URL:</b></td>
<td style="vertical-align:middle;">&nbsp;&nbsp;<input name="HomepageURL" maxlength="30" type="text" size="25">
</td>
</tr>

 <tr align="left" valign="top">
      <td style="vertical-align:middle;">&nbsp;<b>Enter the code number shown
<strong><font size="+1" face="verdana"><?= $captchaCode ?></font></strong>
<input name="chide" value="<?= $captchaCode ?>" type="hidden">
			</td>
      <td style="vertical-align:middle;">
	  	    <p>
          &nbsp;&nbsp;<input name="captchaText" type="text" size="25" maxlength="100">
          <br>
		</p></td>
    </tr>

<tr>
<td colspan="2">
<center>
<p><br>
&nbsp;<b>Comments:
<textarea name="comments" rows="10" cols="40"></textarea><br>
<input type="submit" value="Submit"></form></center>
</td>
</tr>

</table></center>


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

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

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



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