<?php
  function trimBody($theText,$lmt=100, $s\_chr="@@@",$s_cnt=1) {
    $pos\; =\; 0;$trimmed = FALSE;
    for ($i\; =\; 1;$i <= $s\_cnt;$i++) {
      if ($tmp\; =\; strpos($theText, $s\_chr,$pos)) {
        $pos\; =$tmp;
        $trimmed\; =\; TRUE;\; \}\; else\; \{$pos = strlen($theText);$trimmed = FALSE;
        break;
      }
    }
    $theText\; =\; substr($theText, 0, $pos);\; if\; (strlen($theText) > $lmt)\; \{$theText = substr($theText,\; 0,$lmt);
      $theText\; =\; substr($theText, 0, strrpos($theText,\text{'}\; \text{'}));$trimmed = TRUE;
    }
    if ($trimmed)$theText .= '...';
    return $theText;\; \}\; function\; msgBox($m, $t,$d=<index.php>, $s="Info")\; \{$theMsg = "<div id=\"requestConfirm" . $s\; .\; "\backslash ">";$theMsg .= "<h2>" . $t\; .\; "$</h2>\n";
    theMsg .= "<p>" . $m\; .\; "$</p>";
    theMsg .= "<p><a href=\"" . $d\; .\; "\backslash "\; ";$theMsg .= "class=\"buttonlink\">";
    $theMsg\; .=\; "Yes$</a>";
    theMsg .= "<a href=\"index.php\" class=\"buttonlink\">";
    $theMsg\; .=\; "No$</a></p>";
    theMsg .= "</div>";
    return $theMsg;\; \}\; function\; getForum($id) {
    $sql\; =\; "SELECT\; forum\_name\; as\; name,\; forum\_desc\; as\; description,\; "\; .\; "forum\_moderator\; as\; mod\; ".\; "FROM\; forum\_forum\; ".\; "WHERE\; id\; =\; "\; .$id;
    $result\; =\; mysql\_query($sql)
      or die(mysql_error() . "<br>" . $sql);$row = mysql_fetch_array($result);\; return$row;
  }
  
  function getForumID($topicid)\; \{$sql = "SELECT forum_id FROM forum_posts WHERE id=$topicid";$result = mysql_query($sql)\; or\; die(mysql\_error()\; .\; "$<br>" . sql);
    $row\; =\; mysql\_fetch\_array($result);
    return $row[\text{'}forum\_id\text{'}];\; \}\; function\; breadcrumb($id, $getfrom="F")\; \{$sep = "<span class=\"bcsep\">";
    sep .= "</span>";
    if ($getfrom\; ==\; "P")\; \{$sql = "SELECT forum_id, subject FROM forum_posts " .
             "WHERE id = " . $id;$result = mysql_query($sql)\; or\; die(mysql\_error()\; .\; "$<br>" . sql);
      $row\; =\; mysql\_fetch\_array($result);
      $id\; =$row['forum_id'];
      $topic\; =$row['subject'];
    }
    $row\; =\; getForum($id);
    </a>sep";
    switch ($getfrom)\; \{\; case\; "P":$bc .= "<a href=\"viewforum.php?f=$id\backslash ">".$row['name'] .
              "</a>$sep"\; .$topic;
        break;
  
      case "F":
        $bc\; .=$row['name'];
        break;
    }
   return "<h4 class=\"breadcrumb\">" . $bc\; .\; "$</h4>";
  }
  
  function showTopic(topicid, $showfull=TRUE)\; \{\; global$conn;
    global $userid;\; global$limit;
  
    echo breadcrumb($topicid,\; "P");\; if\; (isset($_GET['page'])) {
      $page\; =$_GET['page'];
    } else {
      $page\; =\; 1;\; \}\; if\; ($limit == "") $limit\; =\; 25;$start = ($page\; -\; 1)\; *$limit;
    if (isset($\_SESSION[\text{'}user\_id\text{'}]))\; \{\; echo\; topicReplyBar($topicid, getForumID($topicid),\; "right");\; \}$sql = "SELECT SQL_CALC_FOUND_ROWS ".
             "p.id, p.subject, p.body, p.date_posted, " .
             "p.date_updated, u.name as author, u.id as author_id, " .
             "u.signature as sig, c.count as postcount, " .
             "p.forum_id as forum_id, f.forum_moderator as mod, " .
             "p.update_id, u2.name as updated_by " .
           "FROM forum_forum f " .
           "JOIN forum_posts p " .
           "ON f.id = p.forum_id " .
           "JOIN forum_users u " .
           "ON u.id = p.author_id " .
           "LEFT JOIN forum_users u2 " .
           "ON u2.id = p.update_id " .
           "LEFT JOIN forum_postcount c " .
           "ON u.id = c.user_id " .
           "WHERE (p.topic_id = $topicid\; OR\; p.id\; =$topicid) " .
           "ORDER BY p.topic_id, p.date_posted ".
           "LIMIT $start,$limit";
    $result\; =\; mysql\_query($sql, $conn)\; or\; die(mysql\_error()\; .\; "$<br>" . sql);
    $pagelinks\; =\; paginate($limit);
    if (mysql_num_rows($result)\; ==\; 0)\; \{$msg = "There are currently no posts.  Would you " .
             "like to be the first person to create a thread?";
      $title\; =\; "No\; Posts...";$dest = "compose.php?forumid=" . $forumid;$sev = "Info";
      $message\; =\; msgBox($msg,$title,$dest,$sev);\; echo$message;
    } else {
      echo "<table class=\"forumtable\" cellspacing=\"0\" ";
      echo "cellpadding=\"2\"><tr>";
      echo "<th class=\"author\">Author</th>";
      echo "<th class=\"post\">Post</th>";
      echo "</tr>";
      $rowclass\; =\; "";\; while\; ($row = mysql_fetch_array($result))\; \{$lastupdate = "";
        $editlink\; =\; "";$dellink = "";
        pcount = "";
        $pdate\; =\; "";$sig = "";
        if ($showfull)\; \{$body = $row[\text{'}body\text{'}];\; if\; (isset($_SESSION['user_id'])) {
            row['forum_id'] . "&topicid=row['id'] .
              "\" class=\"buttonlink\">REPLY</a>&nbsp;";
          } else {
            $replylink\; =\; "";\; \}\; if\; ($row['update_id'] > 0) {
          $lastupdate\; =\; "$<p class=\"smallNote\">Last updated: " .
               row['date_updated'] . " by " .
               $row[\text{'}updated\_by\text{'}]\; .\; "$</p>";
          }
          if ((userid == $row[\text{'}author\_id\text{'}])\; or\; ($userid == $row[\text{'}mod\text{'}])\; or\; ($_SESSION['access_lvl'] > 2)) {
            row['id'].
              "\" class=\"buttonlink\">EDIT</a>&nbsp;";
            row['id'] .
              "\" class=\"buttonlink\">DELETE</a>&nbsp;";
          }
          $pcount\; =\; "$<br><span class=\"textsmall\">Posts: " .
            (row['postcount']==""?"0":$row[\text{'}postcount\text{'}])\; .\; "$</span>";
          pdate = $row[\text{'}date\_posted\text{'}];$sig = ($row[\text{'}sig\text{'}]\; !=\; ""?"$<p class=\"sig\">".
                 bbcode(nl2br(row['sig'])):"")."</p>";
        } else {
          $body\; =\; trimBody($body);
        }
        $rowclass\; =\; ($rowclass == "row1"?"row2":"row1");
        echo "<tr class=\"$rowclass\backslash ">";\; echo\; "$<td class=\"author\">" . row['author'];
        echo $pcount;\; echo\; "$</td><td class=\"post\"><p>";
        if (isset(_SESSION['user_id'])
            and (row['date_posted'])) {
          echo NEWPOST . " ";
        }
        if (isset($\_GET[\text{'}page\text{'}]))\; \{$pagelink = "&page=" . $\_GET[\text{'}page\text{'}];\; \}\; else\; \{$pagelink = "";
        }
        echo "<a name=\"post" . $row[\text{'}id\text{'}]\; .\; "\backslash "\; href=\backslash "viewtopic.php?t="\; .$topicid .$pagelink\; ."\#post".$row['id'] . "\">".POSTLINK."</a>";
        if (isset($row[\text{'}subject\text{'}]))\; \{\; echo\; "$<strong>" . row['subject'] . "</strong>";
        }
        echo "</p><p>" . bbcode(nl2br(htmlspecialchars($body)))\; .\; "$</p>";
        echo sig;
        echo $lastupdate;\; echo\; "$</td></tr>";
        echo "<tr class=\"rowclass\"><td class=\"authorfooter\">";
        echo $pdate\; .\; "$</td><td class=\"threadfooter\">";
        echo replylink;
        echo $editlink;\; echo$dellink;
        echo "</td></tr>\n";
      }
      echo "</table>";
      echo $pagelinks;\; echo\; "$<p>".NEWPOST." = New Post&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
      echo POSTLINK." = Post link (use to bookmark)</p>";
    }
  }
  
  function isParent(page) {
    $currentpage\; =$_SERVER['PHP_SELF'];
    if (strpos($currentpage,$page) === false) {
      return FALSE;
    } else {
      return TRUE;
    }
  }
  
  function topicReplyBar($topicid,$forumid,$pos="right")\; \{$html = "<p class=\"buttonBar" . $pos\; .\; "\backslash ">";\; if\; ($topicid > 0) {
      forumid" .
               "&topicid=topicid\" " .
               "class=\"buttonlink\">Reply to Thread</a>";
    }
    if ($forumid\; >\; 0)\; \{$html .= "<a href=\"compose.php?forumid=$forumid\backslash "\; "\; .\; "class=\backslash "buttonlink\backslash ">New\; Thread$</a>";
    }
    html .= "</p>";
    return $html;\; \}\; function\; userOptionList($level) {
    $sql\; =\; "SELECT\; id,\; name,\; access\_lvl\; "\; .\; "FROM\; forum\_users\; "\; .\; "WHERE\; access\_lvl="\; .$level . " " .
           "ORDER BY name";
    $result\; =\; mysql\_query($sql) 
      or die(mysql_error());
  
    while ($row\; =\; mysql\_fetch\_array($result)) {
      echo "<option value=\"". $row[\text{'}id\text{'}]\; .\; "\backslash ">"\; .\; htmlspecialchars($row['name']) . "</option>";
    }
  }
  
  function paginate($limit=10)\; \{\; global$admin;
  
    $sql\; =\; "SELECT\; FOUND\_ROWS();";$result = mysql_query($sql)\; or\; die(mysql\_error());$row = mysql_fetch_array($result);$numrows = $row[0];$pagelinks = "<div class=\"pagelinks\">";
    if ($numrows\; >$limit) {
      if(isset($\_GET[\text{'}page\text{'}]))\{$page = $\_GET[\text{'}page\text{'}];\; \}\; else\; \{$page = 1;
      }
      $currpage\; =$_SERVER['PHP_SELF'] . "?" . $\_SERVER[\text{'}QUERY\_STRING\text{'}];$currpage = str_replace("&page=".$page,"",$currpage);
  
      if($page\; ==\; 1)\{$pagelinks .= "<span class=\"pageprevdead\">&lt; PREV</span>";
      }else{
        $pageprev\; =$page - 1;
        $pagelinks\; .=\; "$<a class=\"pageprevlink\" href=\"" . currpage .
                      "&page=" . $pageprev\; .\; "\backslash "><\; PREV$</a>";
      }
  
      numofpages = ceil($numrows\; /$limit);
      $range\; =$admin['pageRange']['value'];
      if ($range\; ==\; ""\; or$range == 0) $range\; =\; 7;$lrange = max(1,$page-(($range-1)/2));
      $rrange\; =\; min($numofpages,$page+(($range-1)/2));
      if (($rrange\; -$lrange) < ($range\; -\; 1))\; \{\; if\; ($lrange == 1) {
          $rrange\; =\; min($lrange + ($range-1),$numofpages);
        } else {
          $lrange\; =\; max($rrange - ($range-1),\; 0);\; \}\; \}\; if\; ($lrange > 1) {
        $pagelinks\; .=\; "..";\; \}\; else\; \{$pagelinks .= "&nbsp;&nbsp;";
      }
      for($i\; =\; 1;$i <= $numofpages;$i++){
        if ($i\; ==$page) {
          $pagelinks\; .=\; "$<span class=\"pagenumdead\">i</span>";
        } else {
          if (i and rrange) {
            $pagelinks\; .=\; "$<a class=\"pagenumlink\" " .
                          "href=\"" . currpage . "&page=" . $i\; .\; "\backslash ">"\; .$i . "</a>";
          }
        }
      }
      if (numofpages) {
        $pagelinks\; .=\; "..";\; \}\; else\; \{$pagelinks .= "&nbsp;&nbsp;";
      }
  
      if(($numrows\; -\; ($limit * $page))\; >\; 0)\{$pagenext = $page\; +\; 1;$pagelinks .= "<a class=\"pagenextlink\" href=\"" . pagenext . "\">NEXT &gt;</a>";
      } else {
        $pagelinks\; .=\; "$<span class=\"pagenextdead\">NEXT &gt;</span>";
      }
    } else {
      pagelinks .= "<span class=\"pageprevdead\">&lt; " .
                    "PREV</span>&nbsp;&nbsp;";
      $pagelinks\; .=\; "$<span class=\"pagenextdead\"> " .
                    "NEXT &gt;</span>&nbsp;&nbsp;";
    }
    pagelinks .= "</div>";
    return $pagelinks;\; \}\; function\; bbcode($data) {
    $sql\; =\; "SELECT\; *\; FROM\; forum\_bbcode";$result = mysql_query($sql);\; if\; (mysql\_num\_rows($result) > 0) {
      while($row\; =\; mysql\_fetch\_array($result)) {
        $bbcode[\text{'}tpl\text{'}][]\; =\; "/"\; .\; html\_entity\_decode($row['template'],ENT_QUOTES). "/i";
        $bbcode[\text{'}rep\text{'}][]\; =\; html\_entity\_decode($row['replacement'],ENT_QUOTES);
      }
      $data1\; =\; preg\_replace($bbcode['tpl'],$bbcode[\text{'}rep\text{'}],$data);
      $count\; =\; 1;\; while\; (($data1 != $data)\; and\; ($count < 4)) {
        $count++;$data = $data1;$data1 = preg_replace($bbcode[\text{'}tpl\text{'}],$bbcode['rep'],$data);\; \}\; \}\; return$data;
  }
  ?>