Example #1
0
 public function delete()
 {
     $returnVal = false;
     if ($this->intTableKeyValue != "") {
         $arrSubForums = $this->getSubForums();
         $result[] = $this->MySQL->query("DELETE FROM " . $this->MySQL->get_tablePrefix() . "forum_post WHERE forumboard_id = '" . $this->intTableKeyValue . "'");
         $result[] = $this->MySQL->query("DELETE FROM " . $this->MySQL->get_tablePrefix() . "forum_topic WHERE forumboard_id = '" . $this->intTableKeyValue . "'");
         $result[] = $this->MySQL->query("DELETE FROM " . $this->MySQL->get_tablePrefix() . "forum_rankaccess WHERE board_id = '" . $this->intTableKeyValue . "'");
         $result[] = $this->MySQL->query("DELETE FROM " . $this->MySQL->get_tablePrefix() . "forum_memberaccess WHERE board_id = '" . $this->intTableKeyValue . "'");
         $result[] = parent::delete();
         if (count($arrSubForums) > 0) {
             $subForumObj = new ForumBoard($this->MySQL);
             $arrColumns = array("sortnum", "subforum_id");
             foreach ($arrSubForums as $subForumID) {
                 $subForumObj->select($subForumID);
                 $subForumInfo = $subForumObj->get_info();
                 $newSortNum = $subForumInfo['sortnum'] + ($this->arrObjInfo['sortnum'] - 1);
                 $arrValues = array($newSortNum, $this->arrObjInfo['subforum_id']);
                 $subForumObj->update($arrColumns, $arrValues);
             }
             $subForumObj->resortOrder();
         }
         if (!in_array(false, $result)) {
             $returnVal = true;
         }
     }
     return $returnVal;
 }
Example #2
0
 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;
 }
Example #3
0
$consoleObj = new ConsoleOption($mysqli);
$cID = $consoleObj->findConsoleIDByName("Add Board");
$consoleObj->select($cID);
$consoleInfo = $consoleObj->get_info_filtered();
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$categoryObj = new BasicOrder($mysqli, "forum_category", "forumcategory_id");
$categoryObj->set_assocTableName("forum_board");
$categoryObj->set_assocTableKey("forumboard_id");
$boardObj = new ForumBoard($mysqli);
// Check Login
$LOGIN_FAIL = true;
$arrSelectBoard = "";
if (isset($_POST['bID']) && $boardObj->select($_POST['bID'])) {
    $arrSelectBoard = $boardObj->findBeforeAfter();
    if ($boardObj->get_info("subforum_id") != 0) {
        $arrSelectBoard[0] = $boardObj->get_info("subforum_id");
    }
} else {
    $_POST['bID'] = "";
}
if ($member->authorizeLogin($_SESSION['btPassword']) && $member->hasAccess($consoleObj)) {
    if ($categoryObj->select($_POST['catID'])) {
        $arrBoards = $categoryObj->getAssociateIDs("AND subforum_id = '0' ORDER BY sortnum", true);
        foreach ($arrBoards as $value) {
            if ($_POST['bID'] != $value) {
                $boardObj->select($value);
                $boardInfo = $boardObj->get_info_filtered();
                $selectBoard = "";
                if ($_POST['bID'] != "" && $arrSelectBoard[0] == $boardInfo['forumboard_id']) {
                    $selectBoard = " selected";
Example #4
0
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;
    }
    if (($member->hasAccess($consoleObj) || $boardObj->memberIsMod($memberInfo['member_id'])) && $id != $topicInfo['forumboard_id']) {
        $spacing = str_repeat("&nbsp;&nbsp;&nbsp;&nbsp;", $boardObj->calcBoardDepth());
        $forumBoardOptions[$id] = $spacing . $boardObj->get_info_filtered("name");
    }
}
$i = 0;
$arrComponents = array("selecteditem" => array("type" => "custom", "display_name" => "Selected Topic", "sortorder" => $i++, "html" => "<div class='formInput'><b>" . $postInfo['title'] . "</b></div>"), "moveto" => array("type" => "select", "attributes" => array("class" => "formInput textBox"), "display_name" => "Move To", "validate" => array("RESTRICT_TO_OPTIONS"), "options" => $forumBoardOptions, "sortorder" => $i++, "db_name" => "forumboard_id", "non_selectable_items" => $nonSelectableItems), "postredirect" => array("type" => "checkbox", "attributes" => array("id" => "postRedirect", "class" => "formInput", "checked" => "checked"), "value" => 1, "display_name" => "Post a Redirect", "sortorder" => $i++), "postredirect_top" => array("type" => "custom", "sortorder" => $i++, "html" => "<div id='postRedirectSection'>"), "postredirect_desc" => array("type" => "textarea", "sortorder" => $i++, "attributes" => array("class" => "formInput textBox", "rows" => "5", "cols" => "40"), "display_name" => "Redirect Description", "tooltip" => "Let users know why the topic is being moved.", "value" => "This topic has been moved to [BOARD].\n\n[TOPIC_LINK]"), "postredirect_bottom" => array("type" => "custom", "sortorder" => $i++, "html" => "</div>"), "submit" => array("type" => "submit", "value" => "Move Topic", "sortorder" => $i++, "attributes" => array("class" => "submitButton formSubmitButton")));
$setupFormArgs = array("name" => "console-" . $cID, "components" => $arrComponents, "description" => "Use the form below to move the selected topic.", "saveObject" => $boardObj->objTopic, "saveMessage" => "Successfully Moved Topic!", "saveType" => "update", "saveLink" => $MAIN_ROOT . "forum/viewtopic.php?tID=" . $topicInfo['forumtopic_id'], "attributes" => array("action" => $MAIN_ROOT . "members/console.php?cID=" . $cID . "&topicID=" . $topicInfo['forumtopic_id'], "method" => "post"), "afterSave" => array("post_topic_redirect"));