<?php
session_start();
require("includes/configure.php");

$con = mysql_connect("$configure[dbservname]","$configure[dbuname]","$configure[dbpaswd]");
if (!$con)
  {
  die('Could not connect to MySQL. There is an error in your configure.php file: ' . mysql_error());
  }

$db_selected = mysql_select_db("$configure[dbname]", $con);
if (!$db_selected)
  {
  die ("MySQL can\'t use the specified database : " . mysql_error());
  }

mysql_select_db("$configure[dbname]", $con);

$cat_query = mysql_query("SELECT * FROM categories");
$for_query = mysql_query("SELECT * FROM forums WHERE id = " . $row[forum_id]);

include("header.php");
include("navigation.php");

?>
<!-- Start Login Box -->
<div align="left">
   <table border="1">
     <tr>
        <td>Welcome back, Sajuuk!</td>
        <td>Hello there Guest! <br /><a href="register.php">Register an account with us</a> or log in below!</td>
     </tr>
     <tr>
        <td>You were online last time at 12:00PM GMT</td>
        <td>Username: <input type="text" /></td>
     </tr>
     <tr>
        <td>You currently have 0 Private Messages</td>
        <td>Password: <input type="password" /><form action="success.php" method="get"><input type="submit" /></form></td>
     </tr>
   </div>
</table>
<!-- End Login Box -->
<br />
<!-- Start Welcome box -->
<if condition="$show['unregistered']">
<table border="1">
   <tr>
       <td><strong>Welcome to the forums!</strong></td>
   </tr>
   <tr>
       <td>You are currently viewing this forum as an unregistered user. This means you are restricted to viewing forums and threads only. To be able to communicate privately with other users and post messages, you will need to <a href="register.php">create an account</a>. <b>This forum is not constructed as it should be, I am only showing you what the final product for the forum will be.</td>
   </tr>
</table>
<else />
</if>
<!-- End Welcome box -->
<br />
<!-- Start Main Forums -->
<table border="1">
   <tr>
      <td>Status</td>
      <td>Forum Name / Description</td>
      <td>Threads</td>
      <td>Posts</td>
      <td>Last Post</td>
   </tr>
   <?php echo mysql_error();
         while($row = mysql_fetch_array($cat_query)) {
         // Display category,

         while($frm = mysql_fetch_array($for_query)) {
         // Display forum(s)
         }
   }
   ?>
   <?php /*
while($row = mysql_fetch_array($result))

           {
           echo "<tr>";
           echo "<td colspan=\"5\">" . $row[category_name] . "::" . $row[category_desc] . "</td>";
           echo "</tr>";
           echo "<tr>";
           echo "<td>" . "<b>Open!</b>" . "</td>";
           echo '<td>' . "<a href=\"forumview.php?id=$row[forum_id]\">" . $row[forum_name] . "</a>" . '<br />' . $row[forum_desc] . '</td>';
           echo "<td>" . $row[total_thread_count] . "</td>";
           echo "<td>" . $row[total_post_count] . "</td>";
           echo "<td>" . $row[latest_post_forum] . "</td>";
           echo "</tr>";
           }
*/
  ?>
</table>
<br />
<!-- End Main Forums -->

<!-- Start Who is Online -->
<table border="1">
   <tr>
      <td>Who is Viewing the forums? <a href="online.php">Complete Listings</a></td>
   </tr>
   <tr>
      <td>There are 2 registered users, 3 guests and one search engine spider viewing the forums right now.<br />
          The maximum number of users, guests and search engine spiders combined totals 5.<br />
          <a href="user.php?id=1"><span style="color: purple;font-weight: bold;"><i>Sajuuk</i></span></a>, <!-- <a href="user.php?id="2">Invsible</a> --><a href="user.php?id=3"><span style="color: purple;font-weight: bold;font-style: italic;">Alex</span></a>
      </td>
   </tr>
   <tr>
       <td>Forum Statistics</td>
   </tr>
   <tr>
       <td>2 Threads and 3 Posts have been made on these forums.<br />
           20 Bugs have been filed in the bug tracker so far.<br />
           The newest user to join this forum is <a href="user.php?id=3">Alex</a>
       </td>
   </tr>
</table>
<!-- End Who is Online -->
<br />
<?php include("footer.php"); ?>