<?php
  require_once 'conn.php';
  require_once 'functions.php';
  require_once 'http.php';
  if (!isset($\_GET[\text{'}f\text{'}]))\; redirect(\text{'}index.php\text{'});\; require\_once\; \text{'}header.php\text{'};$forumid = $\_GET[\text{'}f\text{'}];$forum = getForum($forumid);\; echo\; breadcrumb($forumid, "F");
  if (isset($\_GET[\text{'}page\text{'}]))\; \{$page = $\_GET[\text{'}page\text{'}];\; \}\; else\; \{$page = 1;
  }
  $limit\; =$admin['pageLimit']['value'];
  if ($limit\; ==\; "")$limit = 25;
  $start\; =\; ($page - 1) * $admin[\text{'}pageLimit\text{'}][\text{'}value\text{'}];$sql = "CREATE TEMPORARY TABLE tmp ( " .
         "topic_id INT(11) NOT NULL DEFAULT 0, " .
         "postdate datetime NOT NULL default '0000-00-00 00:00:00')";
  mysql_query($sql)\; or\; die(mysql\_error()\; .\; "$<br>" . sql);
  
  $sql\; =\; "LOCK\; TABLES\; forum\_users\; READ,forum\_posts\; READ";\; mysql\_query($sql) 
    or die(mysql_error() . "<br>" . $sql);$sql = "INSERT INTO tmp SELECT topic_id, MAX(date_posted) " .
         "FROM forum_posts " .
         "WHERE forum_id = $forumid\; "\; .\; "AND\; topic\_id\; >\; 0\; "\; .\; "GROUP\; BY\; topic\_id";\; mysql\_query($sql) 
    or die(mysql_error() . "<br>" . $sql);$sql = "UNLOCK TABLES";
  mysql_query($sql)\; or\; die(mysql\_error()."$<br>".sql);
  
  //die('stop');
  $sql\; =\; "SELECT\; SQL\_CALC\_FOUND\_ROWS\; "\; .\; "t.id\; as\; topic\_id,\; t.subject\; as\; t\_subject,\; "\; .\; "u.name\; as\; t\_author,\; count(p.id)\; as\; numreplies,\; "\; .\; "t.date\_posted\; as\; t\_posted,\; tmp.postdate\; as\; re\_posted\; "\; .\; "FROM\; forum\_users\; u\; "\; .\; "JOIN\; forum\_posts\; t\; "\; .\; "ON\; t.author\_id\; =\; u.id\; "\; .\; "LEFT\; JOIN\; tmp\; "\; .\; "ON\; t.id\; =\; tmp.topic\_id\; "\; .\; "LEFT\; JOIN\; forum\_posts\; p\; "\; .\; "ON\; p.topic\_id\; =\; t.id\; "\; .\; "WHERE\; t.forum\_id\; =$forumid " .
         "AND t.topic_id = 0 " .
         "GROUP BY t.id " .
         "ORDER BY re_posted DESC " .
         "LIMIT $start,$limit";
  $result\; =\; mysql\_query($sql)
    or die(mysql_error() . "<br>" . $sql);$numrows = mysql_num_rows($result);\; if\; ($numrows == 0) {
    $msg\; =\; "There\; are\; currently\; no\; posts.\; Would\; you\; "\; .\; "like\; to\; be\; the\; first\; person\; to\; create\; a\; thread?";$title = "Welcome to " . $forum[\text{'}name\text{'}];$dest = "compose.php?forumid=" . $forumid;$sev = "Info";
    $message\; =\; msgBox($msg,$title,$dest,$sev);\; echo$message;
  } else {
    if (isset($\_SESSION[\text{'}user\_id\text{'}]))\; \{\; echo\; topicReplyBar(0,$_GET['f'], "right");
    }
    echo "<table class=\"forumtable\" cellspacing=\"0\" ";
    echo "cellpadding=\"2\"><tr>";
    echo "<th class=\"thread\">Thread</th>";
    echo "<th class=\"author\">Author</th>";
    echo "<th class=\"replies\">Replies</th>";
    echo "<th class=\"lastpost\">Last Post</th>";
    echo "</tr>";
    $rowclass\; =\; "";\; while\; ($row = mysql_fetch_array($result))\; \{$rowclass = ($rowclass\; ==\; "row1"?"row2":"row1");\; if\; ($row['re_posted'] == "") {
        $lastpost\; =$row['t_posted'];
      } else {
        $lastpost\; =$row['re_posted'];
      }
      if ((isset($\_SESSION[\text{'}user\_id\text{'}]))\; and\; ($_SESSION['last_login'] < $lastpost))\; \{$newpost = true;
      } else {
        $newpost\; =\; false;\; \}\; echo\; "$<tr class=\"rowclass\">";
      echo "<td class=\"thread\">" . (row['topic_id'] . "\">" . $row[\text{'}t\_subject\text{'}]\; .\; "$</a></td>";
      echo "<td class=\"author\">" . row['t_author'] . "</td>";
      echo "<td class=\"replies\">" . $row[\text{'}numreplies\text{'}]\; .\; "$</td>";
      echo "<td class=\"lastpost\">" . lastpost . "</td>";
      echo "</tr>\n";
    }
    echo "</table>";
    echo paginate($limit);\; echo\; "$<p>" . NEWPOST . " = New Post(s)</p>";
  }
  sql = "DROP TABLE tmp";
  mysql_query($sql)\; or\; die(mysql\_error()."$<br>".sql);
  
  require_once 'footer.php';
  ?>