All pastes #896277 Raw Edit

Mine

public text v1 · immutable
·published 2008-02-08 14:55 UTC
rendered paste body
<?php
		
		include "fhead.php";
		
		if(isset($_GET['id'])){
			$forum = $_GET['id'];
			$forum = mysql_real_escape_string($forum);
			$forum = abs($forum);
		} else {
			echo '<div class="attention">Invalid forum</div>';
		}
		
		$foruminfoX = mysql_query("SELECT * FROM `[f]forums` WHERE `num` = ".$forum);
		$foruminfo = mysql_fetch_array($foruminfoX);

		$postcount = 0;
		$pagecount = 0;
		$countquery = 'SELECT * FROM `[f]topic` WHERE `forum` = '.$forum.' ORDER BY `num` DESC';
		$countresult = mysql_query($countquery);
		while($countrow = mysql_fetch_assoc($countresult)) {
			$postcount++;
		}
		$pagecount = ceil($postcount/20);
		if ($pagecount == 0) $pagecount = 1;
		if (isset($_GET['p'])) $page = $_GET['p'];
		else $page = 1;
		$startpost = ($page - 1) * 20;
?>
<br>
<br>
<div id="picker">
<form method="get" action="topic.php">
<ul class="flat">
<li><a href="searchthreads.php"><img src="http://Zagix.com/images/forums/search.gif"> Search threads</a></li>
<li>Jump to Thread: <input size="6" name="id"></li>
<li><input class="b" value="Go" type="submit"></li>
</ul>
</form>
</div>
<div id="infopane">
<span class="title"><img src="http://Zagix.com/images/forums/icons/<?php echo $foruminfo['num']; ?>.gif"> &nbsp; <?php echo $foruminfo['name']; ?> &nbsp; <img src="http://Zagix.com/images/forums/icons/<?php echo $foruminfo['num']; ?>.gif"></span>
<div class="about">
<ul class="flat">
<li><a href="codeofconduct.php"><img src="http://Zagix.com/images/forums/code.gif"> Code of Conduct</a></li>
</ul>
</div>
</div>
<div id="nocontrols" class="phold"></div>
<div id="breadcrumb">
&gt; <a href="index.php">Zagix Forums</a> &gt; <a href="forum.php?id=<?php echo $forum; ?>"><?php echo $foruminfo['name']; ?></a>
</div>
<div class="actions" id="top">
<table><tbody><tr>
<td class="nav">
<?php 
			echo '
				<form method="get" style="display: inline;">
				<input type="hidden" name="id" value="'.$forum.'">
				<ul class="flat">
				<li><a href="forum.php?id='.$forum.'">&lt;&lt; first</a> </li>
				<li><a href="forum.php?id='.$forum.'&p='.($page - 1).'">&lt; prev</a> </li>
				<li>Page <input name="p" size="2" value="'.$page.'" type="text"> of '.$pagecount.'</li>
				<li><a href="forum.php?id='.$forum.'&p='.($page + 1).'">next &gt;</a> </li>
				<li><a href="forum.php?id='.$forum.'&p='.$pagecount.'">last &gt;&gt;</a></li>
				</ul>
				<input name="grrclient" style="border: 0px none ; margin: 0px; padding: 0px; width: 0px; height: 0px; font-size: 0px;" type="submit">
				</form>
			';
 ?>
</td>
<td class="commands">
<ul class="flat">
<li><?php  if(isset($_COOKIE['rs_usr'])) echo '<img src="http://Zagix.com/images/forums/new.gif" /> <a href="post.php?f='.$forum.'">New Topic</a> '; ?> <a href="forum.php?id=<?php echo $forum; ?>"><img src="http://Zagix.com/images/forums/refresh.gif"> Refresh</a></li>
</ul>
</td></tr></tbody></table>
</div>
<div id="content" class="border">
<div class="bk"></div>
<div class="cont">
<table>
<tbody><tr>
<td class="title">&nbsp;</td>
<td class="center title">Posts</td>
<td class="title">Last Post</td>
</tr>
	<?php
    $forumquery = 'SELECT * FROM `[f]topic` WHERE `forum` = '.$forum.' ORDER BY `num` AND `sticky` DESC LIMIT '.$startpost.', 20';
    $forumresult = mysql_query($forumquery);
	while ($forumrow = mysql_fetch_assoc($forumresult)) {
		echo '
			<tr class="thdnrml">
			<td class="threadtitle">
		';
		if($forumrow['hidden'] == 1) $hidden = true; else $hidden = false;
		if($forumrow['hidden'] == 1) $forumrow['locked'] = 1;
		if($forumrow['locked'] == 1) echo '<img alt="Thread is locked" title="Thread is locked" src="http://Zagix.com/images/forums/lock.gif">';
		if($forumrow['sticky'] == 1) echo '<img alt="Thread is sticky" title="Thread is sticky" src="http://Zagix.com/images/forums/stick.gif">';
		
		if($forumrow['sticky'] == 1) echo '<a class="sticky1" href="topic.php?id='.$forumrow['num'].'">'.$forumrow['name'].'</a><br>';
		else echo ($forumrow['hidden'] == 0?'<a class="sticky2" href="topic.php?id='.$forumrow['num'].'">'.$forumrow['name'].'</a><br>':'This thread has been hidden');
		echo ($forumrow['hidden'] == 0?'<span class="nt">created by <span class="username">'.$forumrow['username'].'</span></span>':'');
		echo '
			</td>
			<td class="num">
			'.($forumrow['hidden'] == 0?$forumrow['postcount']:'').'
			</td>
		';
		echo '
			<td class="updated">
			'.($forumrow['hidden'] == 0?$forumrow['lastpostdate']:'').'
			<br>'.($forumrow['hidden'] == 0?'by '.$forumrow['lastpostname']:'').'
			</td>
			</tr>
			<tr class="spacer"><td class="spacer">&nbsp;</td></tr>
		';
	}
	?>
</tbody></table>
</div>
</div>
<div id="breadcrumb">
&gt; <a href="board.php">Zagix Forums</a> &gt; <a href="forum.php?f=<?php echo $forum; ?>"><?php echo $foruminfo['name']; ?></a>
</div>
<div class="actions" id="bottom">
<table><tbody><tr>
<td class="nav">
<?php 
			echo '
				<form method="get" style="display: inline;">
				<input type="hidden" name="id" value="'.$forum.'">
				<ul class="flat">
				<li><a href="forum.php?id='.$forum.'">&lt;&lt; first</a> </li>
				<li><a href="forum.php?id='.$forum.'&p='.($page - 1).'">&lt; prev</a> </li>
				<li>Page <input name="p" size="2" value="'.$page.'" type="text"> of '.$pagecount.'</li>
				<li><a href="forum.php?id='.$forum.'&p='.($page + 1).'">next &gt;</a> </li>
				<li><a href="forum.php?id='.$forum.'&p='.$pagecount.'">last &gt;&gt;</a></li>
				</ul>
				<input name="grrclient" style="border: 0px none ; margin: 0px; padding: 0px; width: 0px; height: 0px; font-size: 0px;" type="submit">
				</form>
			';
 ?>
</td>
<td class="commands">
<ul class="flat">
<li><a href="forum.php?id=<?php echo $forum; ?>"><img src="http://Zagix.com/images/forums/refresh.gif"> Refresh</a></li>
</ul>
</td></tr></tbody></table>
</div>
</div>
</body></html>