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