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);