if ($member->authorizeLogin($_SESSION['btPassword'])) {
$memberInfo = $member->get_info_filtered();
if ($member->hasAccess($consoleObj) && $consoleCatObj->select($_POST['catID'])) {
$addSQL = "";
$selectedConsole = "";
if ($_POST['cnID'] != "" && $consoleObj->SELECT($_POST['cnID'])) {
$addSQL = " AND console_id != '" . $_POST['cnID'] . "'";
$consoleInfo = $consoleObj->get_info_filtered();
if ($consoleInfo['consolecategory_id'] == $_POST['catID']) {
$arrBeforeAfter = $consoleObj->findBeforeAfter();
$selectedConsole = $arrBeforeAfter[0];
}
}
define('MEMBERRANK_ID', $memberInfo['rank_id']);
$consoleCatInfo = $consoleCatObj->get_info_filtered();
$arrConsoles = $consoleCatObj->getAssociateIDs();
$sqlConsoles = "('" . implode("','", $arrConsoles) . "')";
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "console WHERE console_id IN " . $sqlConsoles . $addSQL . " ORDER BY sortnum");
while ($row = $result->fetch_assoc()) {
$strSelect = "";
if ($row['console_id'] == $selectedConsole) {
$strSelect = "selected";
}
echo "<option value='" . $row['console_id'] . "' " . $strSelect . ">" . filterText($row['pagetitle']) . "</option>";
$counter++;
}
}
}
if ($counter == 0) {
echo "<option value='first'>(no other options in category)</option>";
}
include_once "../../../../classes/rank.php";
include_once "../../../../classes/consoleoption.php";
include_once "../../../../classes/consolecategory.php";
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$consoleObj = new ConsoleOption($mysqli);
$consoleCatObj = new ConsoleCategory($mysqli);
$cID = $consoleObj->findConsoleIDByName("Manage Console Options");
$consoleObj->select($cID);
if ($member->authorizeLogin($_SESSION['btPassword'])) {
$memberInfo = $member->get_info_filtered();
if ($member->hasAccess($consoleObj) && $consoleObj->select($_POST['cID'])) {
define('MEMBERRANK_ID', $memberInfo['rank_id']);
$consoleInfo = $consoleObj->get_info();
$consoleCatObj->select($consoleInfo['consolecategory_id']);
$arrAssociates = $consoleCatObj->getAssociateIDs("ORDER BY sortnum");
array_unshift($arrAssociates, "");
unset($arrAssociates[0]);
$intSortNum = $consoleInfo['sortnum'];
$moveUp = $intSortNum - 1;
$moveDown = $intSortNum + 1;
$makeMove = "";
if ($_POST['cDir'] == "up" and $consoleObj->select($arrAssociates[$moveUp])) {
$makeMove = "before";
} elseif ($_POST['cDir'] == "down" and $consoleObj->select($arrAssociates[$moveDown])) {
$makeMove = "after";
}
if ($makeMove != "") {
$newSpot = $consoleObj->makeRoom($makeMove);
if (is_numeric($newSpot)) {
$consoleObj->select($_POST['cID']);
