forum_post_view.php

<?php 
define('INCLUDE_PATH', 'include/');
require(INCLUDE_PATH.'vitals.inc.php');

require('include/header.inc.php'); 

$parent_id = intval($_REQUEST['parent']);
$post_id = intval($_REQUEST['p']);
$forum_id = intval($_REQUEST['f']);

if ($_SESSION['valid_user']) {
	//update the # thread views and the last accessed date
	$sql = "INSERT INTO forums_views VALUES ($post_id, $_SESSION[member_id], NOW(), 0)";
	$result = mysql_query($sql, $db);
	if (!$result) {
		$sql = "UPDATE forums_views SET last_accessed=NOW(), views=views+1 WHERE post_id=$post_id AND member_id=$_SESSION[member_id]";
		$result = mysql_query($sql, $db);
	}
	
	//update that this member viewed this post
	$sql = "REPLACE INTO forums_read VALUES ($post_id, $_SESSION[member_id], $forum_id, $parent_id)";
	$result = mysql_query($sql, $db);	
}

$msg = get_message($post_id);  //returns array of poster, date, html-encoded message

?>

<div id="post-title">
	<h3><div style="float:left;height:75px;"><?php echo get_title('forum', $forum_id, 'small'); ?></div>
	<div style="float:left;height:75px;">&nbsp; > &nbsp;<?php if ($parent_id) { echo "Re: &nbsp;"; } ?></div></h3>
	
	<div style="float:left; vertical-align:middle; height:75px;">
	<?php 
	if ($parent_id) {
		echo get_title('post', $parent_id,'small'); 
	} else {
		echo get_title('post', $post_id, 'small'); 
	} ?>
	</div>
	<div id="submenu" style="margin-top:41px;">
		<?php 
		if (!$parent_id) { 
			echo "<li><a href='forum_posts.php?f=$forum_id'><img src='images/arrow_left.png' alt='Back to forum posts' title='Back to forum posts' class='buttonimage' /></a></li>";
		} else {
			echo "<li><a href='forum_post_view.php?f=$forum_id&p=$parent_id'><img src='images/arrow_left.png' alt='Back to parent post' title='Back to parent post' class='buttonimage' /></a></li>";
		}
		?>		
		
	</div>	
	<div style="clear:both" /></div>
</div>

<div id="post">		
	<div id="post-info">
		<div style="padding-bottom:5px;"><?php echo $msg[0]; ?></div>
		<?php get_avatar($msg[3]); ?>
	</div>

	<div id="post-msg">
		<div style="text-align:right">
		<ul>
		<?php
		if ($_SESSION['login'] == $msg[0]) {
			echo "<li style='display:inline;padding:8px;'><a href='forum_post_edit.php?f=$forum_id&p=$post_id&parent=$parent_id'><img src='images/comment_edit.png' alt='Edit' title='Edit' /></a></li>";
		}		
		if (!$parent_id) { 
			echo "<li style='display:inline;padding:8px;'><a href='forum_post_create.php?f=$forum_id&p=$post_id'><img src='images/comment_add.png' alt='Reply' title='Reply' /></a></li>";
		} 
		 ?>
		</ul>
		</div>
		<div id="post-msg-text">
			<small><?php echo $msg[1]; ?></small><br />
			<?php  echo $msg[2]; ?>
		</div>
		<br style="clear:both" />
	</div>
	<br style="clear:both" />

	<?php
	if (!$parent_id) { 
	
		$sql = "SELECT * FROM forums_posts WHERE forum_id=".$forum_id." AND parent_id=".$post_id." ORDER BY last_comment DESC";
		$result = mysql_query($sql, $db);
		if (@mysql_num_rows($result)) { ?>
			<table class="manage">
			<tr>
				<th colspan="4">Replies</th>
			</tr>
			<?php 
				while ($row = mysql_fetch_assoc($result)) { ?>
				<tr>
					<td style="width:20px; text-align:center;">	<?php //check for new messages
						$sql = "SELECT * FROM forums_read WHERE post_id=".$row['post_id']." AND member_id=".intval($_SESSION['member_id']);
						$result2 = mysql_query($sql, $db);
						$read = @mysql_num_rows($result2);
						
						if ($_SESSION['valid_user'] && !$read) { 
							echo '<img src="images/email_red.png" alt="new message" title="new message" height="16" width="16" /> ';					
						} else {
							echo '<img src="images/email.png" alt="no new messages" title="no new messages" height="16" width="16" /> ';
						} ?>
					</td>
					<?php print_reply_link($row['post_id']); ?>
					<td style="text-align:center">
						<?php echo date('M j Y, h:ia', strtotime($row['last_comment'])); ?>
					</td>
				</tr>
			<?php
			}
		} /*else {
			echo "<p>No replies yet.</p>";
		}*/
	}
	?>
</div>

<?php require('include/footer.inc.php'); ?>