rendered paste body<DIV class="main" style="width: 95%;"><h4>Viewing all topics</h4><p><table style="border: 1px solid silver" bgcolor="#FFFFFF" border="0" bordercolor="#ececec" cellpadding="0" cellspacing="0" width="100%"> <tr> <td width="50%" align="left" valign="top" style="border-right: 1px dotted silver; padding: 5px"> <font color="black"><strong>Topic</strong></font> </td> <td align="center" style="padding: 5px; border-right: 1px dotted silver;" valign="top"> <div id="c13987"><strong>Threads</strong></div> </td> <td align="center" style="padding: 5px; border-right: 1px dotted silver;" valign="top"> <div id="c13987"><strong>Posts</strong></div> </td> <td width="25%" align="center" style="padding: 5px; border-right: 1px dotted silver;" valign="top"> <div id="c13987"><strong>Last Post</strong></div> </td> </tr> <?php /* +---------------------------------------------------------------------------------------- | Generate the MySQL Query and execute it +---------------------------------------------------------------------------------------- */ $tblname = 'forum_topics'; $query_category = "SELECT * FROM `".$tblname."`"; $result_category = mysql_query($query_category); /* +---------------------------------------------------------------------------------------- | When topics returned, while loop display all the topics +---------------------------------------------------------------------------------------- */ while( $forum_r=mysql_fetch_array($result_category) ) { $forum_id = $forum_r["ID"]; $forum_topic = $forum_r["Topic"]; ?> <tr> <td width="50%" align="left" valign="top" style="border-top: 1px dotted silver; border-right: 1px dotted silver; padding: 5px; vertical-align: middle;"> <font color="black"><a href="?id=forums&page=listt&topic=<?php echo $forum_id; ?>"><?php echo $forum_topic; ?></a></font> </td> <td align="center" style="border-top: 1px dotted silver; padding: 5px; border-right: 1px dotted silver; vertical-align: middle;" valign="top"> <div id="c13987"><?php echo $threads->limit($forum_id); ?></div> </td> <td align="center" style="border-top: 1px dotted silver; padding: 5px; border-right: 1px dotted silver; vertical-align: middle;" valign="top"> <div id="c13987"><?php echo $posts->limit($forum_id); ?></div> </td> <td width="25%" align="center" style="border-top: 1px dotted silver; padding: 5px; border-right: 1px dotted silver;" valign="top"> <div id="c13987"><?php echo $last->post($forum_id); ?></div> </td> </tr> <?php } echo '</table></p><p>'; /* +---------------------------------------------------------------------------------------- | If the user is an Administrator, show the staff forums +---------------------------------------------------------------------------------------- */ if ($profile->title() == 'Administrator') { ?> <table style="border: 1px solid silver" bgcolor="#FFFFFF" border="0" bordercolor="#ececec" cellpadding="0" cellspacing="0" width="100%"> <tr> <td width="50%" align="left" valign="top" style="border-right: 1px dotted silver; padding: 5px"> <font color="black"><strong>Topic</strong></font> </td> <td align="center" style="padding: 5px; border-right: 1px dotted silver;" valign="top"> <div id="c13987"><strong>Threads</strong></div> </td> <td align="center" style="padding: 5px; border-right: 1px dotted silver;" valign="top"> <div id="c13987"><strong>Posts</strong></div> </td> <td width="25%" align="center" style="padding: 5px; border-right: 1px dotted silver;" valign="top"> <div id="c13987"><strong>Last Post</strong></div> </td> </tr> <?php /* +---------------------------------------------------------------------------------------- | Generate the MySQL Query and execute it +---------------------------------------------------------------------------------------- */ $tblname = 'forum_topics'; $query_category = "SELECT * FROM `".$tblname."` WHERE Staff='1'"; $result_category = mysql_query($query_category); /* +---------------------------------------------------------------------------------------- | When topics returned, while loop display all the topics +---------------------------------------------------------------------------------------- */ while( $forum_r=mysql_fetch_array($result_category) ) { $forum_id = $forum_r["ID"]; $forum_topic = $forum_r["Topic"]; ?> <tr> <td width="50%" align="left" valign="top" style="border-top: 1px dotted silver; border-right: 1px dotted silver; padding: 5px; vertical-align: middle;"> <font color="black"><a href="?id=forums&page=listt&topic=<?php echo $forum_id; ?>"><?php echo $forum_topic; ?></font> </td> <td align="center" style="border-top: 1px dotted silver; padding: 5px; border-right: 1px dotted silver; vertical-align: middle;" valign="top"> <div id="c13987"><?php echo $threads->limit($forum_id); ?></div> </td> <td align="center" style="border-top: 1px dotted silver; padding: 5px; border-right: 1px dotted silver; vertical-align: middle;" valign="top"> <div id="c13987"><?php echo $posts->limit($forum_id); ?></div> </td> <td width="25%" align="center" style="border-top: 1px dotted silver; padding: 5px; border-right: 1px dotted silver;" valign="top"> <div id="c13987"><?php echo $last->post($forum_id); ?></div> </td> </tr> <?php } } ?></p>