section.php

<?php
/* Web Intersect Social Network Template System and CMS v1.34
 * Copyright (c) 2011 Adam Khoury
 * Licensed under the GNU General Public License version 3.0 (GPLv3)
 * http://www.webintersect.com/license.php
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.

 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU General Public License for more details.

 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * Date: February 9, 2010
 *------------------------------------------------------------------------------------------------*/
session_start();
include_once ("../wi_class_files/agoTimeFormat.php");
$myAgoObject = new convertToAgo;
include_once "../scripts/connect_to_mysql.php"; // Connect to the database
// Get the section ID from the url variable coming in
if (isset($_GET['id']) && $_GET['id'] != "") {
	$sid = preg_replace('#[^0-9]#i', '', $_GET['id']); // filter all characters except numbers for security
} else {
	echo "ERROR: Variables to run this script have been removed from the URL.";
	exit();
}
// Query the database for that section id, make sure it exists and get the section title
$sql = mysql_query("SELECT * FROM forum_sections WHERE id='$sid' LIMIT 1");
$numRows = mysql_num_rows($sql);
if ($numRows < 1) {
	echo "ERROR: That section deos not exist you have tampered with our URLs.";
	exit();
}
while($row = mysql_fetch_array($sql)){
	$sectionTitle = $row["title"];
}
// Use the section ID to query the "forum_posts" table in the database to get all the threads for this section
$sql = mysql_query("SELECT * FROM forum_posts WHERE type='a' AND section_id='$sid' ORDER BY date_time DESC LIMIT 25");
$dynamicList = "";
$numRows = mysql_num_rows($sql)or die(mysql_error());
if ($numRows < 1) {
	$dynamicList = "There are no threads in this section yet. You can be the first to post.";
} else {
	while($row = mysql_fetch_array($sql)){
	    $thread_id = $row["id"];
		$post_author = $row["post_author"];
		$post_author_id = $row["post_author_id"];
		$date_time = $row["date_time"];
		$convertedTime = ($myAgoObject -> convert_datetime($date_time));
        $whenPost = ($myAgoObject -> makeAgo($convertedTime));
		$thread_title = $row["thread_title"];
		$dynamicList .= '<img src="style/threadPic.jpg" width="26" height="18" alt="Topic" /> ' . $post_author . ' - <a href="view_thread.php?id=' . $thread_id . '">' . $thread_title . '</a> - ' . $whenPost . '<br />';
    }
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="style/style.css" rel="stylesheet" type="text/css" />
<title><?php echo $sectionTitle; ?> Forum</title>
</head>
<body>
<?php include_once("template_header.php"); ?>
<table style="background-color: #F0F0F0; border:#069 1px solid; border-top:none;" width="900" border="0" align="center" cellpadding="12" cellspacing="0">
  <tr>
    <td width="731" valign="top">
    <div id="breadcrumbs"><a href="http://www.webintersect.com">Web Intersect Home</a> &larr; <a href="http://www.webintersect.com/forum">Forum Home</a></div>
    <h1 style="margin-left:12px;"><?php echo $sectionTitle; ?> Forum</h1>
      <form action="new_topic.php" method="post">
      <input name="forum_id" type="hidden" value="<?php echo $sid; ?>" />
      <input name="forum_title" type="hidden" value="<?php echo $sectionTitle; ?>" />
      <input name="myBtn1" type="submit" value="Create New Topic" style="font-size:16px; padding:12px;" />
     </form>
      <br /><br />
      <div style="margin-left:12px; font-size:14px; line-height:1.5em;"><?php echo $dynamicList; ?></div>
    <br /><br /><br /></td>
    <td width="189" valign="top"><div style=" width:160px; height:600px; background-color: #999; color: #CCC; padding:12px;"> <br />
      <br />
      <br />
      <h3>Ad Space or Whatever</h3>
    </div></td>
  </tr>
</table>
<?php include_once("template_footer.php"); ?>
</body>
</html>