function dispManageTable($arrBoards, $indent = 0)
{
global $mysqli, $MAIN_ROOT, $THEME, $cID;
$boardObj = new ForumBoard($mysqli);
$counter = 0;
$x = 0;
foreach ($arrBoards as $boardID) {
$boardObj->select($boardID);
$boardInfo = $boardObj->get_info_filtered();
$dispUpArrow = "<a href='javascript:void(0)' onclick=\"moveBoard('up', '" . $boardInfo['forumboard_id'] . "')\"><img src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/buttons/uparrow.png' width='24' height='24' title='Move Up'></a>";
$dispDownArrow = "<a href='javascript:void(0)' onclick=\"moveBoard('down', '" . $boardInfo['forumboard_id'] . "')\"><img src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/buttons/downarrow.png' width='24' height='24' title='Move Down'></a>";
if ($x == 0) {
$dispUpArrow = "<img src='" . $MAIN_ROOT . "images/transparent.png' width='24' height='24'>";
}
if ($boardObj->getHighestSortNum() == $boardInfo['sortnum']) {
$dispDownArrow = "<img src='" . $MAIN_ROOT . "images/transparent.png' width='24' height='24'>";
}
if ($counter == 1) {
$addCSS = " alternateBGColor";
$counter = 0;
} else {
$addCSS = "";
$counter = 1;
}
echo "\n\t\t\t<tr>\n\t\t\t\t<td class='dottedLine main" . $addCSS . "' style='width: 76%; padding-left: 10px'>" . str_repeat(" ", $indent) . "<b><a href='" . $MAIN_ROOT . "members/console.php?cID=" . $cID . "&bID=" . $boardInfo['forumboard_id'] . "&action=edit'>" . $boardInfo['name'] . "</a></b></td>\n\t\t\t\t<td class='dottedLine main" . $addCSS . "' style='width: 6%' align='center'>" . $dispUpArrow . "</td>\n\t\t\t\t<td class='dottedLine main" . $addCSS . "' style='width: 6%' align='center'>" . $dispDownArrow . "</td>\n\t\t\t\t<td class='dottedLine main" . $addCSS . "' style='width: 6%' align='center'><a href='" . $MAIN_ROOT . "members/console.php?cID=" . $cID . "&bID=" . $boardInfo['forumboard_id'] . "&action=edit'><img src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/buttons/edit.png' width='24' height='24' title='Edit Board'></a></td>\n\t\t\t\t<td class='dottedLine main" . $addCSS . "' style='width: 6%' align='center'><a href='javascript:void(0)' onclick=\"deleteBoard('" . $boardInfo['forumboard_id'] . "')\"><img src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/buttons/delete.png' width='24' height='24' title='Delete Board'></a></td>\n\t\t\t</tr>\n\t\t";
$x++;
$arrSubForums = $boardObj->getSubForums();
if (count($arrSubForums) > 0) {
dispManageTable($arrSubForums, $indent + 1);
}
}
}
function listSubForums($forumID, $filterOut, $indent = 1)
{
global $mysqli;
$boardObj = new ForumBoard($mysqli);
$boardObj->select($forumID);
$arrSubForums = $boardObj->getSubForums();
foreach ($arrSubForums as $value) {
if ($filterOut != $value) {
$boardObj->select($value);
$boardInfo = $boardObj->get_info_filtered();
echo "<option value='" . $boardInfo['forumboard_id'] . "'>" . str_repeat(" ", $indent) . "· " . $boardInfo['name'] . "</option>";
$moreSubForums = $boardObj->getSubForums();
if (count($moreSubForums) > 0) {
listSubForums($value, $filterOut, $indent + 1);
}
}
}
}
}
$arrSpecialMenuItems['newmembers'] .= "<div style='clear: both'></div></div>";
// LATEST FORUM ACTIVITY
$forumActivityObj = new ForumBoard($mysqli);
$arrSpecialMenuItems['forumactivity'] = "<div style='margin-left: 3px; margin-right: 3px; margin-top: 5px; margin-bottom: 20px'>";
$counter = 0;
$postCount = 0;
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "forum_post ORDER BY dateposted DESC");
while ($row = $result->fetch_assoc()) {
$blnShowPost = false;
$forumActivityObj->objTopic->select($row['forumtopic_id']);
$menuTopicInfo = $forumActivityObj->objTopic->get_info_filtered();
$forumActivityObj->objPost->select($menuTopicInfo['forumpost_id']);
$menuTopicPostInfo = $forumActivityObj->objPost->get_info_filtered();
$forumActivityObj->select($menuTopicInfo['forumboard_id']);
$menuBoardInfo = $forumActivityObj->get_info_filtered();
if ($menuBoardInfo['accesstype'] == 0) {
$blnShowPost = true;
$postCount++;
} elseif ($menuBoardInfo['accesstype'] == 1 && LOGGED_IN && $forumActivityObj->memberHasAccess($memberInfo)) {
$blnShowPost = true;
$postCount++;
}
if ($blnShowPost) {
$addCSS = "";
if ($counter == 0) {
$addCSS = " alternateBGColor";
$counter = 1;
} else {
$counter = 0;
}
include_once $prevFolder . "classes/download.php";
include_once $prevFolder . "classes/downloadcategory.php";
$attachmentObj = new Download($mysqli);
$downloadCatObj = new DownloadCategory($mysqli);
$downloadCatObj->selectBySpecialKey("forumattachments");
$forumAttachmentCatID = $downloadCatObj->get_info("downloadcategory_id");
}
$boardObj = new ForumBoard($mysqli);
$categoryObj = new BasicOrder($mysqli, "forum_category", "forumcategory_id");
$categoryObj->set_assocTableName("forum_board");
$categoryObj->set_assocTableKey("forumboard_id");
if (!$boardObj->select($_GET['bID']) || $boardObj->select($_GET['bID']) && !$boardObj->memberHasAccess($memberInfo)) {
echo "<script type='text/javascript'>window.location = '" . $MAIN_ROOT . "members'</script>";
exit;
}
$boardInfo = $boardObj->get_info_filtered();
$blnPostReply = false;
$addToForm = "";
if (isset($_GET['tID']) && $boardObj->objTopic->select($_GET['tID'])) {
$blnPostReply = true;
$topicInfo = $boardObj->objTopic->get_info();
// Check if topic is actually in the selected board
if ($topicInfo['forumboard_id'] != $boardInfo['forumboard_id']) {
echo "<script type='text/javascript'>window.location = '" . $MAIN_ROOT . "members'</script>";
exit;
} elseif ($topicInfo['lockstatus'] == 1) {
echo "\n\t\t\t<div id='lockedMessage' style='display: none'>\n\t\t\t\t<p class='main' align='center'>\n\t\t\t\t\tThis topic is locked!\n\t\t\t\t</p>\n\t\t\t</div>\n\t\t\t<script type='text/javascript'>\n\t\t\t\t\$(document).ready(function() {\n\t\t\t\t\t\$('#lockedMessage').dialog({\n\t\t\t\t\t\ttitle: 'Post Reply - Locked!',\n\t\t\t\t\t\tshow: 'scale',\n\t\t\t\t\t\tmodal: true,\n\t\t\t\t\t\twidth: 400,\n\t\t\t\t\t\tzIndex: 999999,\n\t\t\t\t\t\tresizable: false,\n\t\t\t\t\t\tbuttons: {\n\t\t\t\t\t\t\t'OK': function() {\n\t\t\t\t\t\t\t\t\$(this).dialog('close');\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t},\n\t\t\t\t\t\tclose: function(event, ui) {\n\t\t\t\t\t\t\twindow.location = '" . $MAIN_ROOT . "forum/viewtopic.php?tID=" . $topicInfo['forumtopic_id'] . "'\t\t\t\t\t\t\n\t\t\t\t\t\t}\n\t\t\t\t\t\n\t\t\t\t\t});\n\n\t\t\t\t});\n\t\t\t</script>\n\t\t";
exit;
}
$boardObj->objPost->select($topicInfo['forumpost_id']);
$postInfo = $boardObj->objPost->get_info_filtered();
$boardObj->objTopic->select($firstPostInfo['forumtopic_id']);
$lastPostID = $boardObj->objTopic->get_info("lastpost_id");
$boardObj->objPost->select($lastPostID);
$lastPostInfo = $boardObj->objPost->get_info_filtered();
$postMemberObj->select($lastPostInfo['member_id']);
$dispLastPost = "<div class='boardLastPostTitle'><a href='viewtopic.php?tID=" . $firstPostInfo['forumtopic_id'] . "#" . $lastPostID . "' title='" . $firstPostInfo['title'] . "'>" . $firstPostInfo['title'] . "</a></div>by " . $postMemberObj->getMemberLink() . "<br>" . getPreciseTime($lastPostInfo['dateposted']);
} else {
$dispLastPost = "<div style='text-align: center'>No Posts</div>";
}
$dispTopicCount = $boardObj->countTopics();
$dispPostCount = $boardObj->countPosts();
$arrDispSubForums = array();
$arrSubForums = $boardObj->getSubForums();
foreach ($arrSubForums as $value) {
$subForumObj->select($value);
$subForumInfo = $subForumObj->get_info_filtered();
$arrDispSubForums[] = "<a href='" . $MAIN_ROOT . "forum/viewboard.php?bID=" . $value . "'>" . $subForumInfo['name'] . "</a>";
}
$dispSubForums = "";
if (count($arrDispSubForums) > 0) {
$dispSubForums = "<br><br><b>Sub-Forums:</b><br> " . implode(" <b>|</b> ", $arrDispSubForums);
}
$dispBoards .= "\n\t\t\t\t<tr class='boardRows" . $newTopicBG . "'>\n\t\t\t\t\t<td class='boardName dottedLine" . $newTopicBG . "'><a href='viewboard.php?bID=" . $boardInfo['forumboard_id'] . "'>" . $boardInfo['name'] . "</a>" . $dispNewTopicIMG . "<br><span class='boardDescription'>" . $boardInfo['description'] . $dispSubForums . "</span></td>\n\t\t\t\t\t<td class='dottedLine boardLastPost" . $newTopicBG . "'>" . $dispLastPost . "</td>\n\t\t\t\t\t<td class='dottedLine boardTopicCount" . $newTopicBG . "' align='center'>" . $dispTopicCount . "<span id='forumPageTopicCount' style='display: none'> Topics</span></td>\n\t\t\t\t\t<td class='dottedLine boardTopicCount boardPostCount" . $newTopicBG . "' align='center'>" . $dispPostCount . "<span id='forumPagePostCount' style='display: none'> Posts</span></td>\n\t\t\t\t\n\t\t\t\t</tr>\n\t\t\t";
}
}
if ($dispBoards != "") {
echo "\n\t\t\t<tr>\n\t\t\t\t<td colspan='4' class='boardCategory'>\n\t\t\t\t\t" . $catInfo['name'] . "\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td class='boardTitles'>Forum:</td>\n\t\t\t\t<td class='boardTitles forumLastPost'>Last Post:</td>\n\t\t\t\t<td class='boardTitles forumTopicCount'>Topics:</td>\n\t\t\t\t<td class='boardTitles forumTopicCount'>Posts:</td>\n\t\t\t</tr>\n\t\t";
echo $dispBoards;
echo "<tr><td colspan='4'><br></td></tr>";
}
}
exit;
} else {
$memberInfo = $member->get_info();
$consoleObj->select($_GET['cID']);
if (!$member->hasAccess($consoleObj)) {
exit;
}
}
$boardObj = new ForumBoard($mysqli);
if (!$boardObj->objTopic->select($_GET['topicID'])) {
echo "\n\t\t<script type='text/javascript'>\n\t\t\twindow.location = '" . $MAIN_ROOT . "members'\n\t\t</script>\n\t";
exit;
}
$topicInfo = $boardObj->objTopic->get_info_filtered();
$boardObj->select($boardObj->objTopic->get_info("forumboard_id"));
$boardInfo = $boardObj->get_info_filtered();
$forumCatObj = new Basic($mysqli, "forum_category", "forumcategory_id");
$boardObj->objPost->select($topicInfo['forumpost_id']);
$postInfo = $boardObj->objPost->get_info_filtered();
$boardIDs = $boardObj->getAllBoards();
$catName = "";
$nonSelectableItems = array();
foreach ($boardIDs as $id) {
$boardObj->select($id);
$forumCatID = $boardObj->get_info("forumcategory_id");
$forumCatObj->select($forumCatID);
if ($forumCatObj->get_info_filtered("name") != $catName) {
$catName = $forumCatObj->get_info_filtered("name");
$catKey = "category_" . $forumCatID;
$forumBoardOptions[$catKey] = "<b>" . $catName . "</b>";
$nonSelectableItems[] = $catKey;
$breadcrumbObj->addCrumb("Search Forum", $MAIN_ROOT . "forum/search.php");
$breadcrumbObj->addCrumb("Search Results");
}
include $prevFolder . "include/breadcrumb.php";
$arrMemberList = array();
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "members WHERE disabled = '0' AND rank_id != '1' ORDER BY username");
while ($row = $result->fetch_assoc()) {
$arrMemberList[] = array("id" => $row['member_id'], "value" => filterText($row['username']));
}
$memberList = json_encode($arrMemberList);
$filterBoardOptions[0] = "Search All Boards";
$result = $mysqli->query("SELECT " . $dbprefix . "forum_board.forumboard_id FROM " . $dbprefix . "forum_board, " . $dbprefix . "forum_category WHERE " . $dbprefix . "forum_board.forumcategory_id = " . $dbprefix . "forum_category.forumcategory_id AND " . $dbprefix . "forum_board.subforum_id = '0' ORDER BY " . $dbprefix . "forum_category.ordernum DESC, " . $dbprefix . "forum_board.sortnum");
while ($row = $result->fetch_assoc()) {
$boardObj->select($row['forumboard_id']);
if ($boardObj->memberHasAccess($memberInfo)) {
$filterBoardOptions[$row['forumboard_id']] = $boardObj->get_info_filtered("name");
if (count($boardObj->getSubForums()) > 0) {
recurseSubForums(" ");
}
}
}
function recurseSubForums($spacing)
{
global $filterBoardOptions, $boardObj, $memberInfo;
$arrSubforums = $boardObj->getSubForums();
foreach ($arrSubforums as $boardID) {
$boardObj->select($boardID);
if ($boardObj->memberHasAccess($memberInfo)) {
$filterBoardOptions[$boardObj->get_info("forumboard_id")] = $spacing . $boardObj->get_info_filtered("name");
if (count($boardObj->getSubForums()) > 0) {
recurseSubForums(" " . $spacing);
