public function getForumActivity($amountToShow = 5)
{
$forumObj = new ForumBoard($this->MySQL);
$arrReturn = array();
$memberInfo = $this->memberObj->get_info();
$result = $this->MySQL->query("SELECT forumpost_id FROM " . $this->MySQL->get_tablePrefix() . "forum_post ORDER BY dateposted DESC");
while (count($arrReturn) < $amountToShow && ($row = $result->fetch_assoc())) {
$forumPostID = $row['forumpost_id'];
$forumObj->objPost->select($forumPostID);
$topicID = $forumObj->objPost->get_info("forumtopic_id");
$forumObj->objTopic->select($topicID);
$boardID = $forumObj->objTopic->get_info("forumboard_id");
$forumObj->select($boardID);
$boardAccessType = $forumObj->get_info("accesstype");
if (!in_array($forumPostID, $arrReturn) && $boardAccessType == 0) {
$arrReturn[] = $forumPostID;
} elseif (!in_array($forumPostID, $arrReturn) && $boardAccessType == 1 && $this->blnLoggedIn && $forumObj->memberHasAccess($memberInfo)) {
$arrReturn[] = $forumPostID;
}
}
return $arrReturn;
}
$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;
}
$arrSpecialMenuItems['forumactivity'] .= "<div class='dottedLine " . $addCSS . "' style='padding: 5px 5px'>";
$menuMemberObj->select($row['member_id']);
$forumMemberInfo = $menuMemberObj->get_info_filtered();
$checkURL = parse_url($forumMemberInfo['avatar']);
$postCount = 0;
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "forum_post ORDER BY dateposted DESC");
$arrShownTopics = array();
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 (!in_array($row['forumtopic_id'], $arrShownTopics) && $menuBoardInfo['accesstype'] == 0) {
$blnShowPost = true;
$postCount++;
$arrShownTopics[] = $row['forumtopic_id'];
} elseif (!in_array($row['forumtopic_id'], $arrShownTopics) && $menuBoardInfo['accesstype'] == 1 && LOGGED_IN && $forumActivityObj->memberHasAccess($memberInfo)) {
$blnShowPost = true;
$postCount++;
$arrShownTopics[] = $row['forumtopic_id'];
}
if ($blnShowPost) {
$addCSS = "";
if ($counter == 0) {
$addCSS = " alternateBGColor";
$counter = 1;
} else {
$counter = 0;
}
$arrSpecialMenuItems['forumactivity'] .= "<div class='dottedLine " . $addCSS . "' style=\"overflow: auto; position: relative; padding: 5px 5px;\">";
$menuMemberObj->select($row['member_id']);
$forumMemberInfo = $menuMemberObj->get_info_filtered();
$consoleObj->select($forumAttachmentsCID);
$blnCheckForumAttachments = $member->hasAccess($consoleObj);
$consoleObj->select($cID);
if ($blnCheckForumAttachments) {
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";
$breadcrumbObj->setTitle("Forum");
$breadcrumbObj->addCrumb("Home", $MAIN_ROOT);
$breadcrumbObj->addCrumb("Forum");
include $prevFolder . "include/breadcrumb.php";
$boardObj->showSearchForm();
echo "\t\n\t<table class='forumTable'>\n";
$result = $mysqli->query("SELECT forumcategory_id FROM " . $dbprefix . "forum_category ORDER BY ordernum DESC");
while ($row = $result->fetch_assoc()) {
$arrForumCats[] = $row['forumcategory_id'];
$categoryObj->select($row['forumcategory_id']);
$catInfo = $categoryObj->get_info_filtered();
$arrBoards = $categoryObj->getAssociateIDs("AND subforum_id = '0' ORDER BY sortnum", true);
$dispBoards = "";
foreach ($arrBoards as $boardID) {
$boardObj->select($boardID);
if ($boardObj->memberHasAccess($memberInfo)) {
$boardInfo = $boardObj->get_info_filtered();
$arrForumTopics = $boardObj->getForumTopics();
$newTopicBG = "";
$dispNewTopicIMG = "";
if ($LOGGED_IN && $boardObj->hasNewTopics($memberInfo['member_id'])) {
$dispNewTopicIMG = " <img style='margin-left: 5px' src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/forum-new.png' title='New Posts!'>";
$newTopicBG = " boardNewPostBG";
}
// Get Last Post Display Info
if (count($arrForumTopics) > 0) {
$boardObj->objPost->select($arrForumTopics[0]);
$firstPostInfo = $boardObj->objPost->get_info_filtered();
$boardObj->objTopic->select($firstPostInfo['forumtopic_id']);
$lastPostID = $boardObj->objTopic->get_info("lastpost_id");
$boardObj->objPost->select($lastPostID);
}
$pageoptions .= "<option value='" . $i . "'" . $selectPage . ">" . $i . "</option>";
}
$dispPageSelectTop = "";
$dispPageSelectBottom = "";
if ($blnPageSelect) {
$dispPageSelectTop = "\n\t<p style='margin-top: 0px'><b>Page:</b> <select id='pageSelectTop' class='textBox'>" . $pageoptions . "</select> <input type='button' id='btnPageSelectTop' class='submitButton' value='GO' style='width: 40px'></p>\n\t<p style='margin-top: 0px'>" . $dispPreviousPage . $dispNextPage . "</p>\n\t";
$dispPageSelectBottom = "\n\t<p style='margin-top: 0px'><b>Page:</b> <select id='pageSelectBottom' class='textBox'>" . $pageoptions . "</select> <input type='button' id='btnPageSelectBottom' class='submitButton' value='GO' style='width: 40px'></p>\n\t<p style='margin-top: 0px'>" . $dispPreviousPage . $dispNextPage . "</p>\n\t";
}
// Subforums
$subForumObj = new ForumBoard($mysqli);
$arrSubForums = $boardObj->getSubForums();
$dispSubForums = "";
foreach ($arrSubForums as $boardID) {
$subForumObj->select($boardID);
if ($subForumObj->memberHasAccess($memberInfo)) {
$subForumInfo = $subForumObj->get_info_filtered();
$arrForumTopics = $subForumObj->getForumTopics();
$newTopicBG = "";
$dispNewTopicIMG = "";
if ($LOGGED_IN && $subForumObj->hasNewTopics($memberInfo['member_id'])) {
$dispNewTopicIMG = " <img style='margin-left: 5px' src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/forum-new.png' title='New Posts!'>";
$newTopicBG = " boardNewPostBG";
}
// Get Last Post Display Info
if (count($arrForumTopics) > 0) {
$subForumObj->objPost->select($arrForumTopics[0]);
$firstPostInfo = $subForumObj->objPost->get_info_filtered();
$subForumObj->objTopic->select($firstPostInfo['forumtopic_id']);
$lastPostID = $subForumObj->objTopic->get_info("lastpost_id");
$subForumObj->objPost->select($lastPostID);
