<?php
include 'connect.php3';
include 'secure.php3';
include 'parse.php3';
$s_board = 5;

if($s_accessLevel > 0)
{
	if($forum != "")
	{
		$s_forum = $forumID;
		header("Location: "."forum.php3");
	}

include 'header.php3';
	
	?>
	<table cellspacing="0" cellpadding="0" border="0">
		<tr>
			<td><img src="../ul.jpg" width="8px"></td>
			<td bgcolor="ffffff"></td>
			<td><img src="../ur.jpg" width="8px"></td>
		</tr>
		<tr><td bgcolor="ffffff"></td>
		<td>
	<?php

	if($newForum)
	{
	  $name = HTMLSpecialChars($name);
	  $result = mysql_query("SELECT * FROM FORUM WHERE name='$name' AND boardID='$s_board'",$db);
	  if(!$myrow = mysql_fetch_array($result))
	  {
		  $sql = "INSERT INTO FORUM (name,boardID) VALUES ('$name','$s_board')";
		  $result = mysql_query($sql);
	  }
	}
	
	if($s_accessLevel == 1)
	{	
		if ($confirmed)
		{	
		  $sql = sprintf("DELETE FROM FORUM WHERE forumID=%d", $forumID);
		  $result = mysql_query($sql);
		  echo "forum deleted successfully<br>";
		}
		else if ($delete)
		{
			?>
			<form method="get" action="<?php echo $PHP_SELF?>">
				Are you sure you wish to delete forum <?php echo "$forumID" ?>?
				<input type="hidden" name="forumID" value=<?php echo "$forumID" ?>>
				<input type="submit" name="confirmed" value="  yes  ">
				<input type="submit" name="notconfirmed" value="  no   ">
			</form>
			<?php
		}
		if ($modify)
		{
			$name = HTMLSpecialChars($name);
			$boardID = HTMLSpecialChars($boardID);
			$sql = "UPDATE FORUM SET name='$name',boardID='$boardID' WHERE forumID=$forumID";
		    $result = mysql_query($sql);
			echo "forum modified successfully<br>";
		}
	}
	
	$result = mysql_query("SELECT * FROM FORUM WHERE boardID='$s_board' ORDER BY forumID DESC",$db);

	if ($myrow = mysql_fetch_array($result))
	{
	  echo "<table bgcolor=ffffff border=0 cellpadding=8 cellspacing=4>\n";
	  if($s_accessLevel==1)
		{?><tr>
				<td bgcolor=0080CB><font face="lucida console" size=2><b>Delete</b></font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><b>Forum ID</b></font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><b>Go to Forum</b></font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><b>Topics</b></font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><b>Posts</b></font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><b>Modify Forum</b></font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><b>Board ID</b></font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><b>Modify</b></font></td>
			</tr><?php }
	  else
		{?><tr>
			<td bgcolor=0080CB><font face="lucida console" size=2><b>Forum</b></font></td>
			<td bgcolor=0080CB><font face="lucida console" size=2><b>Topics</b></font></td>
			<td bgcolor=0080CB><font face="lucida console" size=2><b>Posts</b></font></td>
		</tr><?php }

	  do
	  {
		$forumIDtemp = $myrow["forumID"];
		$topics = mysql_query("SELECT * FROM TOPIC WHERE forumID='$forumIDtemp'",$db);

		$numTopics = 0;
		$numPosts = 0;
		if ($myrowtemp = mysql_fetch_array($topics))
		{
			do
			{
				$topicIDtemp = $myrowtemp["topicID"];
				$numTopics++;
				$temp2Result = mysql_query("SELECT * FROM POST WHERE topicID='$topicIDtemp'",$db);
				if($myrowtemp2 = mysql_fetch_array($temp2Result))
				{
					do
					{
						$numPosts++;
					}while ($myrowtemp2 = mysql_fetch_array($temp2Result));
				}
			}while ($myrowtemp = mysql_fetch_array($topics));
		}
		
		?>
	    <tr>
			<?php if($s_accessLevel==1)
			{?>
			<form method="get" action="<?php echo $PHP_SELF?>">
				<td bgcolor=0080CB><font face="lucida console" size=2><input type="submit" name="delete" value="delete forum"></font></td>
				<input type="hidden" name="forumID" value="<?php echo $myrow["forumID"]?>">
				<td bgcolor=0080CB><font face="lucida console" size=2><?php echo $myrow["forumID"] ?></font></td>
			<?php } ?>
				<td bgcolor=0080CB><font face="lucida console" size=2><a href="<?php echo $PHP_SELF?>?forumID=<?php echo $myrow["forumID"]?>&forum=<?php echo urlencode($myrow["name"])?>"><?php echo $myrow["name"]?></a></font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><?php echo $numTopics ?></font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><?php echo $numPosts ?></font></td>
			<?php if($s_accessLevel==1)
			{?>
				<td bgcolor=0080CB><font face="lucida console" size=2><input type="text" name="name" size=32 value="<?php echo $myrow["name"] ?>"</font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><input type="text" name="boardID" size=8 value="<?php echo $myrow["boardID"] ?>"</font></td>
				<td bgcolor=0080CB><font face="lucida console" size=2><input type="submit" name="modify" value="modify"></font></td>
			</form>
			<?php
			}?>
				    </tr>
	    <?php
	  }while ($myrow = mysql_fetch_array($result));

	  echo "</table>\n";

	}
	else
	{
	  echo "Sorry, no records were found!";	
	}

	?>

	</td><td bgcolor="ffffff"></td>
	</tr>
	<tr>
		<td><img src="../ll.jpg" width="8px"></td>
		<td bgcolor="ffffff"></td>
		<td><img src="../lr.jpg" width="8px"></td>
	</tr>
	</table>

	<table><form method="get" action="<?php echo $PHP_SELF?>">
		<tr>
			<td><font face="lucida console" size=2><b>New forum name: <input type="text" size=32 name="name"></b></font></td>
			<td><input type="submit" name="newForum" value="New Forum"></td>
		</tr>
	</form></table>

	</body>
	</html>
<?php
}
?>