PHP Basic::get_info_filtered方法代码示例

 public function displayCustomPageLink()
 {
     $customPageObj = new Basic($this->MySQL, "custompages", "custompage_id");
     $menuCustomPageInfo = $this->menuItemObj->objCustomPage->get_info();
     $customPageObj->select($menuCustomPageInfo['custompage_id']);
     echo "\n\t\t\t<div style='text-align: " . $menuCustomPageInfo['textalign'] . "'>\n\t\t\t" . $menuCustomPageInfo['prefix'] . "<a href='" . MAIN_ROOT . "custompage.php?pID=" . $menuCustomPageInfo['custompage_id'] . "' target='" . $menuCustomPageInfo['linktarget'] . "'>" . $customPageObj->get_info_filtered("pagename") . "</a>\n\t\t\t</div>\n\t\t\t";
 }

 public function displayCustomPageLink()
 {
     $customPageObj = new Basic($this->MySQL, "custompages", "custompage_id");
     $menuCustomPageInfo = $this->menuItemObj->objCustomPage->get_info();
     $customPageObj->select($menuCustomPageInfo['custompage_id']);
     $menuItemInfo = $customPageObj->get_info_filtered();
     $menuItemInfo['name'] = $menuItemInfo['pagename'];
     $menuCustomPageInfo['link'] = MAIN_ROOT . "custompage.php?pID=" . $menuItemInfo['custompage_id'];
     $this->formatLink($menuItemInfo, $menuCustomPageInfo);
 }

 function calcStat($gameStatID, $memberObj)
 {
     $calculatedValue = 0;
     $gameStatObj = new Basic($this->MySQL, "gamestats", "gamestats_id");
     if ($gameStatObj->select($gameStatID) && isset($memberObj)) {
         $gameStatInfo = $gameStatObj->get_info_filtered();
         $gameStat1Obj = new Basic($this->MySQL, "gamestats", "gamestats_id");
         $gameStat2Obj = new Basic($this->MySQL, "gamestats", "gamestats_id");
         if ($gameStatInfo['stattype'] == "calculate" && $gameStat1Obj->select($gameStatInfo['firststat_id']) && $gameStat2Obj->select($gameStatInfo['secondstat_id'])) {
             $gameStats1Info = $gameStat1Obj->get_info_filtered();
             $gameStats2Info = $gameStat2Obj->get_info_filtered();
             $gameStat1Type = $gameStats1Info['stattype'];
             $gameStat2Type = $gameStats2Info['stattype'];
             if ($gameStat1Type == "calculate") {
                 $gameStat1Value = $this->calcStat($gameStats1Info['gamestats_id'], $memberObj);
             } else {
                 $gameStat1Value = $memberObj->getGameStatValue($gameStats1Info['gamestats_id']);
             }
             if ($gameStat2Type == "calculate") {
                 $gameStat2Value = $this->calcStat($gameStats2Info['gamestats_id'], $memberObj);
             } else {
                 $gameStat2Value = $memberObj->getGameStatValue($gameStats2Info['gamestats_id']);
             }
             switch ($gameStatInfo['calcop']) {
                 case "div":
                     if ($gameStat2Value == 0) {
                         $gameStat2Value = 1;
                     }
                     $calculatedValue = round($gameStat1Value / $gameStat2Value, $gameStatInfo['decimalspots']);
                     break;
                 case "mul":
                     $calculatedValue = round($gameStat1Value * $gameStat2Value, $gameStatInfo['decimalspots']);
                     break;
                 case "sub":
                     $calculatedValue = round($gameStat1Value - $gameStat2Value, $gameStatInfo['decimalspots']);
                     break;
                 default:
                     $calculatedValue = round($gameStat1Value + $gameStat2Value, $gameStatInfo['decimalspots']);
             }
         }
     }
     return $calculatedValue;
 }

             } else {
                 $addAppForm->errors[] = "&nbsp;&nbsp;&nbsp;<b>&middot;</b> Unable to save information to the database.  Please contact the website administrator.";
             }
         }
         if (count($addAppForm->errors) > 0) {
             $_POST['saveComponent'] = false;
         }
     }
     if (!$_POST['saveComponent']) {
         if (($appCompInfo['componenttype'] == "select" || $appCompInfo['componenttype'] == "multiselect") && $countErrors == 0) {
             $appSelectOptionObj = new Basic($mysqli, "app_selectvalues", "appselectvalue_id");
             $arrSelectValues = $appComponentObj->getAssociateIDs();
             $tempArr = array();
             foreach ($arrSelectValues as $selectValueID) {
                 $appSelectOptionObj->select($selectValueID);
                 $appSelectValue = $appSelectOptionObj->get_info_filtered("componentvalue");
                 $tempArr[$selectValueID] = $appSelectValue;
             }
             asort($tempArr);
             $_SESSION['btAppComponent']['cOptions'] = $tempArr;
         } elseif ($countErrors == 0) {
             $_SESSION['btAppComponent']['cOptions'] = array();
         }
     }
 } else {
     echo "\n\t\t\t<script type='text/javascript'>\n\t\t\t\t\$(document).ready(function() {\n\t\t\t\t\t\$('#appComponentForm').dialog('close');\n\t\t\t\t});\n\t\t\t</script>\n\t\t";
 }
 $addAppForm->components['name']['value'] = $appCompInfo['name'];
 $addAppForm->components['type']['value'] = $appCompInfo['componenttype'];
 $addAppForm->components['required']['value'] = $appCompInfo['required'];
 $addAppForm->components['tooltip']['value'] = $appCompInfo['tooltip'];

include $prevFolder . "_setup.php";
$diplomacyObj = new Basic($mysqli, "diplomacy", "diplomacy_id");
if (!$diplomacyObj->select($_GET['dID'])) {
    echo "\n\t\t<script type='text/javascript'>\n\t\t\twindow.location = '" . $MAIN_ROOT . "diplomacy'\n\t\t</script>\n\t";
    exit;
}
$ipbanObj = new Basic($mysqli, "ipban", "ipaddress");
if ($ipbanObj->select($IP_ADDRESS, false)) {
    $ipbanInfo = $ipbanObj->get_info();
    if (time() < $ipbanInfo['exptime'] or $ipbanInfo['exptime'] == 0) {
        die("<script type='text/javascript'>window.location = '" . $MAIN_ROOT . "banned.php';</script>");
    } else {
        $ipbanObj->delete();
    }
}
$diplomacyInfo = $diplomacyObj->get_info_filtered();
$diplomacyStatusObj = new BasicOrder($mysqli, "diplomacy_status", "diplomacystatus_id");
$diplomacyStatusObj->select($diplomacyInfo['diplomacystatus_id']);
$statusInfo = $diplomacyStatusObj->get_info_filtered();
if ($statusInfo['imageurl'] == "") {
    $dispStatus = $statusInfo['name'];
} else {
    if (strpos($statusInfo['imageurl'], "http://") === false) {
        $statusInfo['imageurl'] = "../" . $statusInfo['imageurl'];
    }
    $dispImgWidth = "";
    $dispImgHeight = "";
    if ($statusInfo['imagewidth'] != 0) {
        $dispImgWidth = " width = '" . $statusInfo['imagewidth'] . "' ";
    }
    if ($statusInfo['imageheight'] != 0) {

 if ($newGame->addNew($arrColumns, $arrValues)) {
     $newGameInfo = $newGame->get_info_filtered();
     // Try adding stats
     $showErrorMessage = "";
     $newStat = new Basic($mysqli, "gamestats", "gamestats_id");
     $arrColumns = array("name", "stattype", "ordernum", "decimalspots", "gamesplayed_id", "hidestat", "textinput");
     $arrSavedStats = array();
     // First insert all stats so we can get their actual database ids
     // After we add them, save the info array to a separate array
     foreach ($_SESSION['btStatCache'] as $key => $statInfo) {
         $arrValues = array($statInfo['statName'], $statInfo['statType'], $key, $statInfo['rounding'], $newGameInfo['gamesplayed_id'], $statInfo['hideStat'], $statInfo['textInput']);
         if (!$newStat->addNew($arrColumns, $arrValues)) {
             $countErrors++;
             $dispError .= "&nbsp;&nbsp;<b>&middot;</b> " . filterText($statInfo['statName']) . "<br>";
         } else {
             $arrSavedStats[] = $newStat->get_info_filtered();
         }
     }
     /*
      * 	1. Make sure that all of the game stats were successfully inserted into the db
      *  2. For each stat that was an auto-calculated stat, we need to update the firststat and secondstat IDs
      *  3. We can identify the correct $arrSavedStat index by accessing the stat order which is stored in
      *     $_SESSION[btStatCache][key][firstStat] and $_SESSION[btStatCache][key][secondStat]
      */
     if ($countErrors == 0) {
         $arrColumns = array("firststat_id", "secondstat_id", "calcop");
         foreach ($arrSavedStats as $key => $statInfo) {
             if ($statInfo['stattype'] == "calculate") {
                 $intFirstStatOrder = $_SESSION['btStatCache'][$key]['firstStat'];
                 $intFirstStatID = $arrSavedStats[$intFirstStatOrder]['gamestats_id'];
                 $intSecondStatOrder = $_SESSION['btStatCache'][$key]['secondStat'];

<?php

if (!defined("SHOW_PROFILE_MAIN")) {
    exit;
}
// SQUADS
$arrSquads = $member->getSquadList();
$squadObj = new Basic($mysqli, "squads", "squad_id");
$dispSquads = "";
foreach ($arrSquads as $squadID) {
    $squadObj->select($squadID);
    $squadInfo = $squadObj->get_info_filtered();
    if ($squadInfo['logourl'] != "") {
        $dispSquads .= "<a href='" . $MAIN_ROOT . "squads/profile.php?sID=" . $squadID . "'><img src='" . $squadInfo['logourl'] . "' class='squadLogo'></a><div class='dottedLine' style='width: 90%; margin-top: 20px; margin-bottom: 20px'></div>";
    } else {
        $dispSquads .= "<span class='largeFont'><b><a href='" . $MAIN_ROOT . "squads/profile.php?sID=" . $squadID . "'>" . $squadInfo['name'] . "</a></b><div class='dottedLine' style='width: 90%; margin-top: 20px; margin-bottom: 20px'></div>";
    }
}
if ($dispSquads != "") {
    echo "\n\t\t\t<div class='formTitle' style='text-align: center; margin-top: 20px'>Squads</div>\n\t\t\t<table class='profileTable' style='border-top-width: 0px'>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='main' align='center'>\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t" . $dispSquads . "\n\t\t\t\t\t\t</p>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t</table>\n\t\t";
}

         $arrColumns = array("newspost", "lasteditmember_id", "lasteditdate");
         $arrValues = array($_POST['message'], $memberInfo['member_id'], $time);
         if ($squadNewsObj->update($arrColumns, $arrValues)) {
             $_POST['cancel'] = true;
         } else {
             $countErrors++;
             $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> Unable to save information to database! Please contact the website administrator.<br>";
         }
     }
     if ($countErrors > 0) {
         $_POST = filterArray($_POST);
         $_POST['submit'] = false;
     }
 }
 if (!$_POST['submit'] && !$_POST['cancel']) {
     $squadNewsInfo = $squadNewsObj->get_info_filtered();
     if ($dispError != "") {
         echo "\n\t\t\t\t<div class='errorDiv'>\n\t\t\t\t<strong>Unable to edit shoutbox post because the following errors occurred:</strong><br><br>\n\t\t\t\t{$dispError}\n\t\t\t\t</div>\n\t\t\t\t";
     }
     echo "\n\t\t\t\n\t\t\t\t\t<table class='formTable'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td class='formLabel' valign='top'>Message:</td>\n\t\t\t\t\t\t\t<td class='main'>\n\t\t\t\t\t\t\t\t<textarea rows='10' cols='55' class='textBox' id='message_" . $squadNewsInfo['squadnews_id'] . "'>" . $squadNewsInfo['newspost'] . "</textarea>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td class='main' align='center' colspan='2'><br><br>\n\t\t\t\t\t\t\t\t<input type='button' onclick=\"saveNewsPost('" . $squadNewsInfo['squad_id'] . "', '" . $squadNewsInfo['squadnews_id'] . "')\" value='Save' class='submitButton' style='width: 90px'><br><br>\n\t\t\t\t\t\t\t\t<a href='javascript:void(0)' onclick=\"cancelEdit('" . $squadNewsInfo['squad_id'] . "', '" . $squadNewsInfo['squadnews_id'] . "')\">Cancel</a>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t</form>\n\t\t\t\n\t\t\t";
 }
 if ($_POST['cancel']) {
     $squadNewsInfo = $squadNewsObj->get_info_filtered();
     $member->select($squadNewsInfo['member_id']);
     $squadMemberInfo = $member->get_info_filtered();
     if ($squadMemberInfo['avatar'] == "") {
         $squadMemberInfo['avatar'] = $MAIN_ROOT . "themes/" . $THEME . "/images/defaultavatar.png";
     }
     $dispLastEdit = "";
     if ($member->select($squadNewsInfo['lasteditmember_id'])) {
         $dispLastEditTime = getPreciseTime($squadNewsInfo['lasteditdate']);

        $selectCat = $downloadCatInfo['ordernum'] + 1;
        $afterSelected = "selected";
    } else {
        $selectCat = $downloadCatInfo['ordernum'] - 1;
    }
    $result = $mysqli->query("SELECT * FROM " . $dbprefix . "downloadcategory WHERE downloadcategory_id != '" . $downloadCatInfo['downloadcategory_id'] . "' ORDER BY ordernum DESC");
    while ($row = $result->fetch_assoc()) {
        $strSelected = "";
        if ($selectCat == $row['ordernum']) {
            $strSelected = "selected";
        }
        $catOrderOptions .= "<option value='" . $row['downloadcategory_id'] . "' " . $strSelected . ">" . filterText($row['name']) . "</option>";
        $countCategories++;
    }
    if ($countCategories == 0) {
        $catOrderOptions = "<option value='first'>(no other categories)</option>";
    }
    $arrDownloadExts = $downloadCatObj->getExtensions();
    $arrDispDLExts = array();
    foreach ($arrDownloadExts as $extID) {
        $downloadExtensionObj->select($extID);
        $arrDispDLExts[] = $downloadExtensionObj->get_info_filtered("extension");
    }
    $dispDownloadExts = implode(", ", $arrDispDLExts);
    echo "\n\t\n\t\t<form action='console.php?cID=" . $cID . "&catID=" . $_GET['catID'] . "&action=edit' method='post' enctype='multipart/form-data'>\n\t\t\t<div class='formDiv'>\n\t\t";
    if ($dispError != "") {
        echo "\n\t\t<div class='errorDiv'>\n\t\t<strong>Unable to edit download category because the following errors occurred:</strong><br><br>\n\t\t{$dispError}\n\t\t</div>\n\t\t";
    }
    $selectAccessType = $downloadCatInfo['accesstype'] == 1 ? " selected" : "";
    echo "\n\t\t\t\tUse the form below to edit the selected download category.<br><br>\n\t\t\t\t\n\t\t\t\t<table class='formTable'>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td class='formLabel'>Category Name:</td>\n\t\t\t\t\t\t<td class='main'><input type='text' name='catname' class='textBox' value = '" . $downloadCatInfo['name'] . "' style='width: 250px'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td class='formLabel'>Category Order:</td>\n\t\t\t\t\t\t<td class='main'>\n\t\t\t\t\t\t\t<select name='beforeafter' class='textBox'><option value='before'>Before</option><option value='after' " . $afterSelected . ">After</option></select><br>\n\t\t\t\t\t\t\t<select name='catorder' class='textBox'>" . $catOrderOptions . "</select>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td class='formLabel'>Extensions: <a href='javascript:void(0)' onmouseover=\"showToolTip('Enter the acceptable extensions for downloads in this category.  Separate multiple extensions with a comma (,).')\" onmouseout='hideToolTip()'>(?)</a></td>\n\t\t\t\t\t\t<td class='main'><input type='text' name='catexts' class='textBox' value='" . $dispDownloadExts . "' style='width: 250px'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td class='formLabel'>Access Type:</td>\n\t\t\t\t\t\t<td class='main'><select name='accesstype' class='textBox'><option value='0'>Everyone</option><option value='1'" . $selectAccessType . ">Members Only</option></select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td class='main' colspan='2' align='center'>\n\t\t\t\t\t\t\t<br><br>\n\t\t\t\t\t\t\t<input type='submit' name='submit' value='Edit Download Category' class='submitButton' style='width: 175px'><br><br>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t</div>\n\t\t</form>\n\t\n\t";
}

$downloadObj = new Download($mysqli);
$downloadCatObj = new DownloadCategory($mysqli);
$downloadExtObj = new Basic($mysqli, "download_extensions", "extension_id");
$cID = $_GET['cID'];
$dispError = "";
$countErrors = 0;
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "downloadcategory WHERE specialkey = '' ORDER BY ordernum DESC");
while ($row = $result->fetch_assoc()) {
    $arrDownloadCat[] = $row['downloadcategory_id'];
    $dispSelected = isset($_GET['catID']) && $_GET['catID'] == $row['downloadcategory_id'] ? " selected" : "";
    $downloadcatoptions .= "<option value='" . $row['downloadcategory_id'] . "'" . $dispSelected . ">" . $row['name'] . "</option>";
    $downloadCatObj->select($row['downloadcategory_id']);
    $arrExtensions = array();
    foreach ($downloadCatObj->getExtensions() as $downloadExtID) {
        $downloadExtObj->select($downloadExtID);
        $arrExtensions[] = $downloadExtObj->get_info_filtered("extension");
    }
    $dispExtensions = implode(", ", $arrExtensions);
    $downloadCatJS .= "arrCatExtension[" . $row['downloadcategory_id'] . "] = '" . $dispExtensions . "';\n\t";
}
if (count($arrDownloadCat) == 0) {
    echo "\n\t\t<div style='display: none' id='errorBox'>\n\t\t\t<p align='center'>\n\t\t\t\tA download category must be added before adding downloads!\n\t\t\t</p>\n\t\t</div>\n\t\t\n\t\t<script type='text/javascript'>\n\t\t\tpopupDialog('Add Download', '" . $MAIN_ROOT . "members', 'errorBox');\n\t\t</script>\n\t";
    exit;
}
if ($_POST['submit']) {
    // Check Name
    if (trim($_POST['title']) == "") {
        $countErrors++;
        $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> You must give your download a title.<br>";
    }
    // Check Section

    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"));
function post_topic_redirect()
{

 * Author: Bluethrust Web Development
 * E-mail: support@bluethrust.com
 * Website: http://www.bluethrust.com
 *
 * License: http://www.bluethrust.com/license.php
 *
 */
include_once "../../../../_setup.php";
include_once "../../../../classes/member.php";
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$consoleObj = new ConsoleOption($mysqli);
$diplomacyRequestsCID = $consoleObj->findConsoleIDByName("View Diplomacy Requests");
$consoleObj->select($diplomacyRequestsCID);
$diplomacyRequestObj = new Basic($mysqli, "diplomacy_request", "diplomacyrequest_id");
if ($member->authorizeLogin($_SESSION['btPassword']) && $diplomacyRequestObj->select($_POST['reqID']) && $member->hasAccess($consoleObj)) {
    $diplomacyRequestInfo = $diplomacyRequestObj->get_info_filtered();
    if (isset($_POST['confirmDecline'])) {
        // Send E-mail Confirmation
        $emailTo = $diplomacyRequestInfo['email'];
        $emailFrom = "confirmemail@bluethrust.com";
        $emailSubject = $websiteInfo['clanname'] . " - Diplomacy Request: Declined";
        $emailMessage = "\nHi " . $diplomacyRequestInfo['name'] . ",\n\n\n\t\t\nYour diplomacy request has been declined.\n\n\n-" . $websiteInfo['clanname'];
        //mail($emailTo, $emailSubject, $emailMessage, "From: ".$emailFrom);
        $diplomacyRequestObj->delete();
        include "diplomacyrequests.php";
        $member->logAction("Declined " . $diplomacyRequestInfo['clanname'] . "'s diplomacy request.");
    } else {
        echo "\n\t\t\t<div id='confirmDialogBox' style='display: none'>\n\t\t\t\t<p class='main' align='center'>\n\t\t\t\t\tAre you sure you want to decline <b>" . $diplomacyRequestInfo['clanname'] . "'s</b> diplomacy request?\n\t\t\t\t</p>\n\t\t\t</div>\n\t\t\t<script type='text/javascript'>\n\t\t\n\t\t\t\t\$(document).ready(function() {\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\t\$('#confirmDialogBox').dialog({\n\t\t\t\t\t\n\t\t\t\t\t\ttitle: 'Decline Diplomacy Request',\n\t\t\t\t\t\tmodal: true,\n\t\t\t\t\t\tzIndex: 99999,\n\t\t\t\t\t\twidth: 400,\n\t\t\t\t\t\tshow: 'scale',\n\t\t\t\t\t\tbuttons: {\n\t\t\t\t\t\t\t'Yes': function() {\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\$.post('" . $MAIN_ROOT . "members/include/diplomacy/include/declinerequest.php', { reqID: " . $_POST['reqID'] . ", confirmDecline: 1 }, function(data) {\n\t\t\t\t\t\t\t\t\t\$('#diplomacyRequests').fadeOut(250);\n\t\t\t\t\t\t\t\t\t\$('#diplomacyRequests').html(data);\n\t\t\t\t\t\t\t\t\t\$('#diplomacyRequests').fadeIn(250);\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t});\n\t\t\t\t\t\t\t\t\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\t},\n\t\t\t\t\t\t\t'Cancel': function() {\n\t\t\t\t\t\t\t\t\$(this).dialog('close');\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\n\t\t\t\t\t\t}\n\t\t\t\t\t\t\n\t\t\t\t\t});\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t});\n\t\t\t\n\t\t\t</script>\n\t\t\n\t\t";
    }
}

    $memberInfo = $member->get_info();
    $consoleObj->select($_GET['cID']);
    if (!$member->hasAccess($consoleObj)) {
        exit;
    }
}
if (!$member->requestedIA()) {
    $i = 1;
    $arrComponents = array("reason" => array("display_name" => "Reason", "type" => "textarea", "tooltip" => "Leave a reason and for how long you will be inactive for a better chance of being approved.", "attributes" => array("class" => "textBox formInput", "style" => "width: 35%", "rows" => "4"), "db_name" => "reason", "sortorder" => $i++), "submit" => array("value" => "Send Request", "attributes" => array("class" => "submitButton formSubmitButton"), "sortorder" => $i++, "type" => "submit"));
    $requestIAObj = new Basic($mysqli, "iarequest", "iarequest_id");
    $setupFormArgs = array("name" => "console-" . $cID, "components" => $arrComponents, "saveObject" => $requestIAObj, "saveType" => "add", "saveAdditional" => array("member_id" => $memberInfo['member_id'], "requestdate" => time()), "saveMessage" => "Inactive Request Sent!", "attributes" => array("action" => $MAIN_ROOT . "members/console.php?cID=" . $cID, "method" => "post"), "description" => "Use the form below to request to be inactive.  When inactive, you will be able to log in, however you will not have access to any console options.  A higher ranking member will have to approve your request before your status is set to inactive.");
} else {
    // Already requested to be inactive
    $iaRequestObj = new Basic($mysqli, "iarequest", "iarequest_id");
    $iaRequestObj->select($member->requestedIA(true));
    $requestInfo = $iaRequestObj->get_info_filtered();
    $dispRequestStatus = "<span class='pendingFont'>Pending</span>";
    $dispSendMessages = " You may send additional messages using the form below.";
    if ($requestInfo['requeststatus'] == 1) {
        $member->select($requestInfo['reviewer_id']);
        $dispRequestStatus = "<span class='allowText'>Approved</span> by " . $member->getMemberLink() . " - " . getPreciseTime($requestInfo['reviewdate']);
        $member->select($memberInfo['member_id']);
        $dispSendMessages = "  A higher ranking member must delete the request before you can issue another request.";
    } elseif ($requestInfo['requeststatus'] == 2) {
        $member->select($requestInfo['reviewer_id']);
        $dispRequestStatus = "<span class='denyText'>Denied</span> by " . $member->getMemberLink() . " - " . getPreciseTime($requestInfo['reviewdate']);
        $member->select($memberInfo['member_id']);
        $dispSendMessages = "  A higher ranking member must delete the request before you can issue another one.";
    }
    $i = 1;
    $arrComponents = array("requestinfosection" => array("type" => "section", "sortorder" => $i++, "options" => array("section_title" => "Request Information:")), "requestdate" => array("display_name" => "Request Date", "type" => "custom", "html" => "<div class='formInput'>" . getPreciseTime($requestInfo['requestdate']) . "</div>", "sortorder" => $i++), "status" => array("display_name" => "Status", "type" => "custom", "html" => "<div class='formInput'>" . $dispRequestStatus . "</div>", "sortorder" => $i++), "reason" => array("display_name" => "Reason", "type" => "custom", "html" => "<div class='formInput'>" . nl2br($requestInfo['reason']) . "</div>", "sortorder" => $i++), "messagessection" => array("type" => "section", "sortorder" => $i++, "options" => array("section_title" => "Messages:")), "messages" => array("type" => "custom", "sortorder" => $i++, "html" => "<div id='loadingSpiral' style='display: none'><p align='center' class='main'><img src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/loading-spiral2.gif'><br>Loading</p></div><div id='iaMessages'></div>"));

 */
if (!isset($member) || substr($_SERVER['PHP_SELF'], -11) != "console.php") {
    include_once "../../../../_setup.php";
    include_once "../../../../classes/member.php";
    include_once "../../../../classes/basicorder.php";
    $consoleObj = new ConsoleOption($mysqli);
    $member = new Member($mysqli);
    $member->select($_SESSION['btUsername']);
    $cID = $consoleObj->findConsoleIDByName("View Member Applications");
    $consoleObj->select($cID);
    if (!$member->authorizeLogin($_SESSION['btPassword']) || !$member->hasAccess($consoleObj)) {
        exit;
    }
}
$diplomacyStatusObj = new Basic($mysqli, "diplomacy_status", "diplomacystatus_id");
$addClanCID = $consoleObj->findConsoleIDByName("Diplomacy: Add a Clan");
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "diplomacy_request WHERE confirmemail = '1'");
while ($row = $result->fetch_assoc()) {
    $row = filterArray($row);
    foreach ($row as $key => $value) {
        if ($value == "") {
            $row[$key] = "Not Set";
        }
    }
    $diplomacyStatusObj->select($row['diplomacystatus_id']);
    $dispRequestStatus = $diplomacyStatusObj->get_info_filtered("name");
    echo "\n\t\t<div class='dottedBox' style='margin-top: 20px; width: 90%; margin-left: auto; margin-right: auto;'>\n\t\t\t<table class='formTable' style='width: 95%'>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel' valign='top'>Submitted By:</td>\n\t\t\t\t\t<td class='main' valign='top'>" . $row['name'] . " (<a href='mailto:" . $row['email'] . "'>" . $row['email'] . "</a>)</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel'>Date Submitted:</td>\n\t\t\t\t\t<td class='main'>" . getPreciseTime($row['dateadded']) . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel' valign='top'>Clan Name:</td>\n\t\t\t\t\t<td class='main' valign='top'>" . $row['clanname'] . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel' valign='top'>Clan Leaders:</td>\n\t\t\t\t\t<td class='main' valign='top'>" . $row['leaders'] . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel' valign='top'>Requested Status:</td>\n\t\t\t\t\t<td class='main' valign='top'>" . $dispRequestStatus . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel' valign='top'>Clan Tag:</td>\n\t\t\t\t\t<td class='main' valign='top'>" . $row['clantag'] . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel' valign='top'>Games Played:</td>\n\t\t\t\t\t<td class='main' valign='top'>" . $row['gamesplayed'] . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel' valign='top'>Website:</td>\n\t\t\t\t\t<td class='main' valign='top'><a href='" . $row['website'] . "' target='_blank'>" . $row['website'] . "</a></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel' valign='top'>Clan Size:</td>\n\t\t\t\t\t<td class='main' valign='top'>" . ucfirst($row['clansize']) . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='formLabel' valign='top'>Message:</td>\n\t\t\t\t\t<td class='main' valign='top'>" . nl2br($row['message']) . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='main' align='center' colspan='2'>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<b><a href='" . $MAIN_ROOT . "members/console.php?cID=" . $addClanCID . "&reqID=" . $row['diplomacyrequest_id'] . "'>Add Clan</a></b> - <b><a href='javascript:void(0)' onclick=\"declineRequest('" . $row['diplomacyrequest_id'] . "')\">Decline</a></b>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t</table>\n\t\t</div>\n\t";
}
if ($result->num_rows == 0) {
    echo "\n\t\t<div class='shadedBox' style='width: 400px; margin-top: 50px; margin-left: auto; margin-right: auto'>\n\t\t\t<p class='main' align='center'>\n\t\t\t\t<i>There are currently no diplomacy requests.</i>\n\t\t\t</p>\n\t\t</div>\n\t";
}

 * Author: Bluethrust Web Development
 * E-mail: support@bluethrust.com
 * Website: http://www.bluethrust.com
 *
 * License: http://www.bluethrust.com/license.php
 *
 */
include_once "../../../../_setup.php";
include_once "../../../../classes/member.php";
include_once "../../../../classes/consoleoption.php";
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$consoleObj = new ConsoleOption($mysqli);
$cID = $consoleObj->findConsoleIDByName("Manage Custom Form Pages");
$consoleObj->select($cID);
$customPageObj = new Basic($mysqli, "custompages", "custompage_id");
if ($member->authorizeLogin($_SESSION['btPassword'])) {
    $memberInfo = $member->get_info_filtered();
    if ($member->hasAccess($consoleObj) && $customPageObj->select($_POST['cpID'])) {
        define('MEMBERRANK_ID', $memberInfo['rank_id']);
        $customPageInfo = $customPageObj->get_info_filtered();
        if ($_POST['confirm'] == "1") {
            $customPageObj->delete();
            include "main.php";
        } else {
            echo "<p align='center'>Are you sure you want to delete the custom page <b>" . $customPageInfo['pagename'] . "</b>?";
        }
    } elseif (!$customPageObj->select($_POST['cpID'])) {
        echo "<p align='center'>Unable find the selected custom page.  Please try again or contact the website administrator.</p>";
    }
}