当前位置: 首页>>代码示例>>PHP>>正文


PHP Rank::select方法代码示例

本文整理汇总了PHP中Rank::select方法的典型用法代码示例。如果您正苦于以下问题:PHP Rank::select方法的具体用法?PHP Rank::select怎么用?PHP Rank::select使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Rank的用法示例。


在下文中一共展示了Rank::select方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: array

$LOGIN_FAIL = true;
if ($checkMember) {
    if ($member->authorizeLogin($_SESSION['btPassword'])) {
        $LOGIN_FAIL = false;
        $memberInfo = $member->get_info();
        $_SESSION['lastConsoleCategory'] = array("catID" => $consoleInfo['consolecategory_id'], "exptime" => time() + 300);
        // Check for IA
        if ($memberInfo['onia'] == 1 && $cID != $consoleObj->findConsoleIDByName("Cancel IA")) {
            $cancelIACID = $consoleObj->findConsoleIDByName("Cancel IA");
            echo "\n\t\t\t\n\t\t\t\t<div id='iaMessage' style='display: none'>\n\t\t\t\t\t<p class='main' align='center'>You are currently Inactive!<br><br>While inactive, you do not have access to console options.<br><br><a href='" . $MAIN_ROOT . "members/console.php?cID=" . $cancelIACID . "'><b>Click Here</b></a> to become active again!</p>\n\t\t\t\t</div>\n\t\t\t\t\n\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\tpopupDialog('Inactive Member', '" . $MAIN_ROOT . "members', 'iaMessage');\n\t\t\t\t</script>\n\t\t\t";
            exit;
        }
        $memberRankID = $memberInfo['rank_id'];
        define("MEMBERRANK_ID", $memberRankID);
        $memberRank = new Rank($mysqli);
        $memberRank->select($memberRankID);
        $rankPrivileges = $memberRank->get_privileges();
        if ($member->hasAccess($consoleObj) || $consoleInfo['pagetitle'] == "Manage Forum Posts" && !isset($_GET['noaccess'])) {
            //$getClanInfo = $mysqli->query("SELECT * FROM ".$dbprefix."websiteinfo WHERE websiteinfo_id = '1'");
            $arrClanInfo = $websiteInfo;
            //$getClanInfo->fetch_assoc();
            // Console Security
            define("PREVENT_HACK", $arrClanInfo['preventhack']);
            include $prevFolder . "include/breadcrumb.php";
            if (isset($_GET['action']) && $_GET['action'] == "edit") {
                echo "\n\t\t\t\t<p align='right' style='margin-bottom: 10px; margin-right: 20px;'>&laquo; <a href='" . $MAIN_ROOT . "members/console.php?cID=" . $cID . "'>Go Back</a></p>\n\t\t\t\t";
            } elseif (!isset($_GET['action'])) {
                echo "\n\t\t\t\t<p align='right' style='margin-bottom: 20px; margin-right: 20px;'>&laquo; <a href='" . $MAIN_ROOT . "members/index.php?select=" . $consoleInfo['consolecategory_id'] . "' id='consoleTopBackButton'>Go Back</a></p>\n\t\t\t\t";
            }
            if (substr($consoleInfo['filename'], 0, strlen("../")) != "../") {
                $include_file = "include/" . $consoleInfo['filename'];
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:console.php

示例2: elseif

 if (!is_numeric($_POST['rankimagewidth']) and trim($_POST['rankimagewidth']) != "") {
     $countErrors++;
     $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> The Image Width must be a numeric value.<br>";
 } elseif ($_POST['rankimagewidth'] <= 0 and is_numeric($_POST['rankimagewidth'])) {
     $countErrors++;
     $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> The Image Width must be a value greater than 0.<br>";
 }
 if ($_FILES['rankimagefile']['name'] == "" and (trim($_POST['rankimagewidth']) == "" or $_POST['rankimagewidth'] <= 0)) {
     $countErrors++;
     $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> You must supply an image width for images that aren't uploaded.<br>";
 }
 // Check Before/After and Rank
 $beforeAfterRankOK = false;
 $rankObj = new Rank($mysqli);
 if ($_POST['rankorder'] != "first") {
     if (!$rankObj->select($_POST['rankorder'])) {
         $countErrors++;
         $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> You selected an invalid rank order. (rank)<br>";
     } else {
         $beforeAfterRankInfo = $rankObj->get_info();
         $beforeAfterRankOK = true;
         // Check to see if we can get a new rank order number
         $intNewRankOrderNum = $rankObj->makeRoom($_POST['beforeafter']);
         if (!is_numeric($intNewRankOrderNum)) {
             $countErrors++;
             $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> You selected an invalid rank order. (rank)<br>";
         }
     }
 } else {
     $result = $mysqli->query("SELECT * FROM " . $dbprefix . "ranks WHERE rank_id != '1'");
     $num_rows = $result->num_rows;
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:addrank.php

示例3: Rank

 }
 if ($_POST['autodisable'] != "") {
     if (!is_numeric($_POST['autodisable']) or is_numeric($_POST['autodisable']) and $_POST['autodisable'] < 0) {
         $countErrors++;
         $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> Auto disable must either be blank or a positive numeric value.<br>";
     }
 }
 // Check Rank Order and Promote Power
 $checkRankObj = new Rank($mysqli);
 if ($_POST['rankorder'] == $rankInfo['rank_id']) {
     // Hack attempt
     $countErrors++;
     $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> You selected an invalid rank order. (possible hack attempt?)<br>";
 }
 //Check if rank selected for rank order is an actual rank
 if ($checkRankObj->select($_POST['rankorder'])) {
     $checkRankInfo = $checkRankObj->get_info();
     if ($_POST['beforeafter'] == "before") {
         $intTempRankOrder = $checkRankInfo['ordernum'] + 1;
     } else {
         $intTempRankOrder = $checkRankInfo['ordernum'] - 1;
     }
     // If the rank order is the same do nothing keep it the same
     // If its not the same make room for the new order and then resort ordernum
     if ($intTempRankOrder == $rankInfo['ordernum']) {
         $intNewRankOrderNum = $rankInfo['ordernum'];
         $resortRanks = false;
     } else {
         $intNewRankOrderNum = $checkRankObj->makeRoom($_POST['beforeafter']);
         $resortRanks = true;
     }
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:edit.php

示例4: array

 function get_privileges()
 {
     $returnArr = array();
     $filterArray = array();
     $rankObj = new Rank($this->MySQL);
     if ($this->intTableKeyValue != "") {
         $rankObj->select($this->arrObjInfo['rank_id']);
         $arrPrivileges = $rankObj->get_privileges();
         $result = $this->MySQL->query("SELECT * FROM " . $this->MySQL->get_tablePrefix() . "console_members WHERE member_id = '" . $this->intTableKeyValue . "'");
         while ($row = $result->fetch_assoc()) {
             if ($row['allowdeny'] == 1 && !in_array($row['console_id'], $arrPrivileges)) {
                 $arrPrivileges[] = $row['console_id'];
             } elseif ($row['allowdeny'] == 0 && in_array($row['console_id'], $arrPrivileges)) {
                 $key = array_search($row['console_id'], $arrPrivileges);
                 $arrPrivileges[$key] = 0;
             }
         }
     }
     return $arrPrivileges;
 }
开发者ID:nsystem1,项目名称:clanscripts,代码行数:20,代码来源:member.php

示例5: getPreciseTime

?>
'>Home</a> > Inactive Members
</div>

<table class='formTable'>
	<tr>
		<td class='formTitle'>Rank:</td>
		<td class='formTitle'>Username:</td>
		<td class='formTitle'>Main Game:</td>
		<td class='formTitle'>Inactive Since:</td>
	</tr>
<?php 
$result = $mysqli->query("SELECT " . $dbprefix . "members.member_id, " . $dbprefix . "ranks.ordernum FROM " . $dbprefix . "members, " . $dbprefix . "ranks WHERE " . $dbprefix . "members.rank_id = " . $dbprefix . "ranks.rank_id AND " . $dbprefix . "members.onia = '1' AND " . $dbprefix . "members.disabled = '0' AND " . $dbprefix . "members.rank_id != '1' ORDER BY " . $dbprefix . "ranks.ordernum DESC");
while ($row = $result->fetch_assoc()) {
    $member->select($row['member_id']);
    $rankObj->select($member->get_info("rank_id"));
    $memberListInfo = $member->get_info_filtered();
    $rankListInfo = $rankObj->get_info_filtered();
    $dispMainGame = "Not Set";
    if ($gameObj->select($memberListInfo['maingame_id'])) {
        $gameObj->refreshImageSize();
        $gameInfo = $gameObj->get_info_filtered();
        $dispMainGame = "<img src='" . $gameInfo['imageurl'] . "' width='" . $gameInfo['imagewidth'] . "' height='" . $gameInfo['imageheight'] . "' onmouseover=\"showToolTip('" . $gameInfo['name'] . "')\" onmouseout='hideToolTip()'>";
    }
    echo "\n\t\t\t<tr>\n\t\t\t\t<td class='main' align='center'>\n\t\t\t\t\t<img src='" . $rankListInfo['imageurl'] . "' width='" . $rankListInfo['imagewidth'] . "' height='" . $rankListInfo['imageheight'] . "' onmouseover=\"showToolTip('" . $rankListInfo['name'] . "')\" onmouseout='hideToolTip()'>\n\t\t\t\t</td>\n\t\t\t\t<td class='main'>" . $member->getMemberLink() . "</td>\n\t\t\t\t<td class='main' align='center'>" . $dispMainGame . "</td>\n\t\t\t\t<td class='main' align='center'>" . getPreciseTime($memberListInfo['inactivedate']) . "</td>\n\t\t\t</tr>\n\t\t\n\t\t";
}
?>
</table>

<?php 
if ($result->num_rows > 0) {
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:inactive-members.php

示例6: MAX

}
$cID = $_GET['cID'];
$dispError = "";
$countErrors = 0;
if ($memberInfo['rank_id'] == 1) {
    $maxOrderNum = $mysqli->query("SELECT MAX(ordernum) FROM " . $dbprefix . "ranks WHERE rank_id != '1'");
    $arrMaxOrderNum = $maxOrderNum->fetch_array(MYSQLI_NUM);
    if ($maxOrderNum->num_rows > 0) {
        $result = $mysqli->query("SELECT rank_id FROM " . $dbprefix . "ranks WHERE ordernum = '" . $arrMaxOrderNum[0] . "'");
        $row = $result->fetch_assoc();
        $rankInfo['promotepower'] = $row['rank_id'];
    }
}
$rankObj = new Rank($mysqli);
if ($_POST['submit']) {
    $rankObj->select($rankInfo['promotepower']);
    $maxRankInfo = $rankObj->get_info_filtered();
    if ($rankInfo['rank_id'] == 1) {
        $maxRankInfo['ordernum'] += 1;
    }
    $arrRanks = array();
    $result = $mysqli->query("SELECT * FROM " . $dbprefix . "ranks WHERE ordernum <= '" . $maxRankInfo['ordernum'] . "' AND rank_id != '1' ORDER BY ordernum DESC");
    while ($row = $result->fetch_assoc()) {
        $arrRanks[] = $row['rank_id'];
    }
    // Check Member
    $newRank = 0;
    if (!$member->select($_POST['member']) || $_POST['member'] == $memberInfo['member_id']) {
        $countErrors++;
        $dispError = "&nbsp;&nbsp;&nbsp;<b>&middot;</b> You selected an invalid member.<br>";
    } elseif (!in_array($member->get_info("rank_id"), $arrRanks)) {
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:promotemember.php

示例7: ForumBoard

$consoleObj->select($cID);
$checkAccess1 = $member->hasAccess($consoleObj);
$cID = $consoleObj->findConsoleIDByName("Manage Boards");
$consoleObj->select($cID);
$checkAccess2 = $member->hasAccess($consoleObj);
$boardObj = new ForumBoard($mysqli);
$rankCatObj = new RankCategory($mysqli);
$rankObj = new Rank($mysqli);
if ($member->authorizeLogin($_SESSION['btPassword']) && ($checkAccess1 || $checkAccess2)) {
    // Set Access
    if (isset($_POST['accessInfo'])) {
        $arrAccessOptions = array(1, 2);
        $accessInfo = json_decode($_POST['accessInfo'], true);
        foreach ($accessInfo as $checkBoxName => $accessType) {
            $rankID = str_replace("rankaccess_", "", $checkBoxName);
            if (in_array($accessType, $arrAccessOptions) && $rankObj->select($rankID)) {
                $_SESSION['btRankAccessCache'][$checkBoxName] = $accessType;
            } elseif ($accessType == 0 && $rankObj->select($rankID)) {
                $_SESSION['btRankAccessCache'][$checkBoxName] = 0;
                unset($_SESSION['btRankAccessCache'][$checkBoxName]);
            }
        }
    }
    // Display List
    $rankoptions = "";
    $result1 = $mysqli->query("SELECT rankcategory_id FROM " . $dbprefix . "rankcategory ORDER BY ordernum DESC");
    while ($row = $result1->fetch_assoc()) {
        $rankCatObj->select($row['rankcategory_id']);
        $arrRanks = $rankCatObj->getRanks();
        $rankCatName = $rankCatObj->get_info_filtered("name");
        if (count($arrRanks) > 0) {
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:rankaccesscache.php

示例8: getimagesize

     if ($rankCatInfo['imageheight'] == 0) {
         $imageURL = $rankCatObj->getLocalImageURL();
         $imageSize = getimagesize($imageURL);
         $rankCatInfo['imageheight'] = $imageSize[1];
     }
     echo "\n\t\t\t<tr>\n\t\t\t\t<td class='main' align='center' colspan='2'><img src='" . $rankCatInfo['imageurl'] . "' width='" . $rankCatInfo['imagewidth'] . "' height='" . $rankCatInfo['imageheight'] . "' onmouseover=\"showToolTip('<b>" . $rankCatInfo['name'] . "</b><br>" . $rankCatInfo['description'] . "')\" onmouseout='hideToolTip()'></td>\n\t\t\t</tr>\n\t\t";
 } else {
     $dispCatDesc = "";
     if ($rankCatInfo['description'] != "") {
         $dispCatDesc = " style='cursor: pointer' onmouseover=\"showToolTip('<b>" . $rankCatInfo['name'] . "</b><br>" . $rankCatInfo['description'] . "')\" onmouseout='hideToolTip()'";
     }
     echo "\n\t\t\t<tr>\n\t\t\t\t<td class='formTitle' align='center' colspan='2'><span" . $dispCatDesc . ">" . $rankCatInfo['name'] . "</span></td>\n\t\t\t</tr>\n\t\t";
 }
 $arrRanks = $rankCatObj->getAssociateIDs("ORDER BY ordernum DESC");
 foreach ($arrRanks as $rankID) {
     $rankObj->select($rankID);
     $rankInfo = $rankObj->get_info_filtered();
     if ($rankInfo['hiderank'] == 0) {
         if ($rankInfo['imagewidth'] == 0) {
             $imageURL = $rankObj->getLocalImageURL();
             $imageSize = getimagesize($imageURL);
             $rankInfo['imagewidth'] = $imageSize[0];
         }
         if ($rankInfo['imageheight'] == 0) {
             $imageURL = $rankObj->getLocalImageURL();
             $imageSize = getimagesize($imageURL);
             $rankInfo['imageheight'] = $imageSize[1];
         }
         echo "\n\t\t\t\t<tr>\n\t\t\t\t\t<td align='center' valign='top' style='width: 50%'>\n\t\t\t\t\t\t<img src='" . $rankInfo['imageurl'] . "' width='" . $rankInfo['imagewidth'] . "' height='" . $rankInfo['imageheight'] . "'>\n\t\t\t\t\t</td>\n\t\t\t\t\t<td valign='top' style='width: 50%' class='main'>\n\t\t\t\t\t\t<b>" . $rankInfo['name'] . "</b><br>\n\t\t\t\t\t\t" . nl2br($rankInfo['description']) . "\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr><td colspan='2'><br></td></tr>\n\t\t\t";
     }
 }
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:ranks.php

示例9: ConsoleOption

// Classes needed for console.php
include_once $prevFolder . "classes/member.php";
include_once $prevFolder . "classes/rank.php";
include_once $prevFolder . "classes/consoleoption.php";
$cOptObj = new ConsoleOption($mysqli);
$cID = $cOptObj->findConsoleIDByName("Manage Ranks");
$cOptObj->select($cID);
$member = new Member($mysqli);
$checkMember = $member->select($_SESSION['btUsername']);
if ($checkMember) {
    if ($member->authorizeLogin($_SESSION['btPassword'])) {
        //$cID = $cOptObj->findConsoleIDByName("Add New Rank");
        $memberInfo = $member->get_info();
        if ($member->hasAccess($cOptObj)) {
            $rank = new Rank($mysqli);
            if ($rank->select($_POST['rID'])) {
                $rankInfo = $rank->get_info_filtered();
                if (!isset($_POST['confirm']) || $_POST['confirm'] == "") {
                    echo "\n\t\t\t\t\t\tAre you sure you want to delete the rank <b>" . $rankInfo['name'] . "?</b>\n\t\t\t\t\t";
                } else {
                    if ($rank->countMembers() > 0) {
                        echo "\n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\$(document).ready(function() {\n\t\t\t\t\t\t\t\t\$('#deleteMessage').html('There are currently members with the rank of <b>" . $rankInfo['name'] . "</b>.  Please change all members with this rank before deleting it.');\n\t\t\t\t\t\t\t\t\$('#deleteDiv').dialog({\n\t\t\t\t\t\t\t\t\ttitle: 'Manage Ranks - Delete Rank',\n\t\t\t\t\t\t\t\t\tmodal: true,\n\t\t\t\t\t\t\t\t\tresizable: false,\n\t\t\t\t\t\t\t\t\twidth: 400,\n\t\t\t\t\t\t\t\t\tshow: 'scale',\n\t\t\t\t\t\t\t\t\tzIndex: 99999,\n\t\t\t\t\t\t\t\t\tbuttons: {\n\t\t\t\t\t\t\t\t\t\t'OK': function() { \$(this).dialog('close'); }\n\t\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});\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t</script>\n\t\t\t\t\t\t";
                    } else {
                        if ($rank->delete()) {
                            echo "";
                            echo "\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tfunction refreshRanks() {\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}\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\$(document).ready(function() {\n\t\t\t\t\t\t\t\t\$('#deleteMessage').html('<b>" . $rankInfo['name'] . "</b> successfully deleted!');\n\t\t\t\t\t\t\t\t\$('#loadingSpiral').show();\n\t\t\t\t\t\t\t\t\$('#contentDiv').fadeOut(400);\n\t\t\t\t\t\t\t\t\$('#deleteDiv').dialog({\n\t\t\t\t\t\t\t\t\ttitle: 'Manage Ranks - Delete Rank',\n\t\t\t\t\t\t\t\t\tmodal: true,\n\t\t\t\t\t\t\t\t\tresizable: false,\n\t\t\t\t\t\t\t\t\twidth: 400,\n\t\t\t\t\t\t\t\t\tshow: 'scale',\n\t\t\t\t\t\t\t\t\tzIndex: 99999,\n\t\t\t\t\t\t\t\t\tbuttons: {\n\t\t\t\t\t\t\t\t\t\t'OK': function() {\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\$.post('" . $MAIN_ROOT . "members/include/admin/manageranks/main.php', { }, function(data) {\n\t\t\t\t\t\t\t\t\t\t\t\t\$('#contentDiv').html(data).fadeIn(400);\n\t\t\t\t\t\t\t\t\t\t\t\t\$('#loadingSpiral').hide();\n\t\t\t\t\t\t\t\t\t\t\t});\t\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\$(this).dialog('close'); \n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t}\n\t\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});\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t</script>\n\t\t\t\t\t\t\t";
                        } else {
                            echo "";
                            echo "\n\t\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\$(document).ready(function() {\n\t\t\t\t\t\t\t\t\$('#deleteMessage').html('Unable to delete rank from the database.  Please contact the website administrator.');\n\t\t\t\t\t\t\t\t\$('#deleteDiv').dialog({\n\t\t\t\t\t\t\t\t\ttitle: 'Manage Ranks - Delete Rank',\n\t\t\t\t\t\t\t\t\tmodal: true,\n\t\t\t\t\t\t\t\t\tresizeable: false,\n\t\t\t\t\t\t\t\t\twidth: 400,\n\t\t\t\t\t\t\t\t\tshow: 'scale',\n\t\t\t\t\t\t\t\t\tzIndex: 99999,\n\t\t\t\t\t\t\t\t\tbuttons: {\n\t\t\t\t\t\t\t\t\t\t'OK': function() { \$(this).dialog('close'); }\n\t\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});\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t</script>\n\t\t\t\t\t\t\t";
                        }
                    }
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:delete.php

示例10: MAX

    $rankInfo['promotepower'] = 0;
}
$cID = $_GET['cID'];
if ($memberInfo['rank_id'] == 1) {
    $maxOrderNum = $mysqli->query("SELECT MAX(ordernum) FROM " . $dbprefix . "ranks WHERE rank_id != '1'");
    $arrMaxOrderNum = $maxOrderNum->fetch_array(MYSQLI_NUM);
    if ($maxOrderNum->num_rows > 0) {
        $result = $mysqli->query("SELECT rank_id FROM " . $dbprefix . "ranks WHERE ordernum = '" . $arrMaxOrderNum[0] . "'");
        $row = $result->fetch_assoc();
        $rankInfo['promotepower'] = $row['rank_id'];
    }
}
$rankObj = new Rank($mysqli);
$medalObj = new Medal($mysqli);
$awardMedalObj = new Basic($mysqli, "medals_members", "medalmember_id");
$rankObj->select($rankInfo['promotepower']);
$maxRankInfo = $rankObj->get_info_filtered();
if ($rankInfo['rank_id'] == 1) {
    $maxRankInfo['ordernum'] += 1;
}
$arrRanks = array();
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "ranks WHERE ordernum <= '" . $maxRankInfo['ordernum'] . "' AND rank_id != '1' ORDER BY ordernum DESC");
while ($row = $result->fetch_assoc()) {
    $arrRanks[] = $row['rank_id'];
}
$sqlRanks = "('" . implode("','", $arrRanks) . "')";
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "members INNER JOIN " . $dbprefix . "ranks ON " . $dbprefix . "members.rank_id = " . $dbprefix . "ranks.rank_id WHERE " . $dbprefix . "members.rank_id IN " . $sqlRanks . " AND " . $dbprefix . "members.disabled = '0' AND " . $dbprefix . "members.member_id != '" . $memberInfo['member_id'] . "' ORDER BY " . $dbprefix . "ranks.ordernum DESC");
while ($row = $result->fetch_assoc()) {
    $rankObj->select($row['rank_id']);
    $memberOptions[$row['member_id']] = $rankObj->get_info_filtered("name") . " " . filterText($row['username']);
}
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:awardmedal.php

示例11: prepareAdditionalMemberInfo

 public function prepareAdditionalMemberInfo()
 {
     if ($this->blnLoggedIn) {
         // Private Message Info
         $consoleOptionObj = new ConsoleOption($this->MySQL);
         $pmCID = $consoleOptionObj->findConsoleIDByName("Private Messages");
         $totalPMs = $this->memberObj->countPMs();
         $totalNewPMs = $this->memberObj->countPMs(true);
         $alertPM = 0;
         if ($totalNewPMs > 0) {
             $dispPMCount = "<b>(" . $totalNewPMs . ")</b> <img src='" . MAIN_ROOT . "themes/" . THEME . "/images/pmalert.gif'>";
             $intPMCount = $totalNewPMs;
             $alertPM = 1;
         } else {
             $dispPMCount = "(" . $totalPMs . ")";
             $intPMCount = $totalPMs;
         }
         $this->data['pmCID'] = $pmCID;
         $this->data['pmCount'] = $intPMCount;
         $this->data['pmCountDisp'] = $dispPMCount;
         $this->data['pmAlert'] = $alertPM;
         $this->data['pmLink'] = "<a href='" . MAIN_ROOT . "members/console.php?cID=" . $pmCID . "' id='pmLoggedInLink'>PM Inbox " . $dispPMCount . "</a>";
         // Member Info
         $rank = new Rank($this->MySQL);
         $rank->select($this->memberObj->get_info("rank_id"));
         $this->data['memberRank'] = $rank->get_info_filtered("name");
         $this->data['memberInfo'] = $this->memberObj->get_info_filtered();
     }
 }
开发者ID:nsystem1,项目名称:clanscripts,代码行数:29,代码来源:btthememenu.php

示例12: Member

 * License: http://www.bluethrust.com/license.php
 *
 */
if (!isset($member) || substr($_SERVER['PHP_SELF'], -11) != "console.php") {
    exit;
} else {
    $memberInfo = $member->get_info();
    $consoleObj->select($_GET['cID']);
    if (!$member->hasAccess($consoleObj)) {
        exit;
    }
}
$cID = $_GET['cID'];
$memberObj = new Member($mysqli);
$rankObj = new Rank($mysqli);
$rankObj->select($memberInfo['rank_id']);
$rankInfo = $rankObj->get_info();
if ($memberInfo['promotepower'] != 0) {
    $rankInfo['promotepower'] = $memberInfo['promotepower'];
} elseif ($memberInfo['promotepower'] == -1) {
    $rankInfo['promotepower'] = 0;
}
if ($memberInfo['rank_id'] == 1) {
    $highestOrderNum = $rankObj->getHighestOrderNum();
    $rankObj->selectByOrder($highestOrderNum);
    $powerRankInfo = $rankObj->get_info();
} else {
    $rankObj->select($rankInfo['promotepower']);
    $powerRankInfo = $rankObj->get_info();
}
if ($_POST['submit']) {
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:setrecruitdate.php

示例13: Rank

$countErrors = 0;
$rankObj = new Rank($mysqli);
// Determine affected members and disallow posting to the page if no member is in the list
$arrCIDs[] = $consoleObj->findConsoleIDByName("Promote Member");
$arrCIDs[] = $consoleObj->findConsoleIDByName("Demote Member");
$arrCIDs[] = $consoleObj->findConsoleIDByName("Disable a Member");
$arrCIDs[] = $consoleObj->findConsoleIDByName("Undisable Member");
$arrCIDs[] = $consoleObj->findConsoleIDByName("Set Member's Rank");
$arrCIDs[] = $consoleObj->findConsoleIDByName("Award Medal");
$arrCIDs[] = $consoleObj->findConsoleIDByName("Revoke Medal");
$sqlCID = "('" . implode("','", $arrCIDs) . "')";
$memberoptions = "";
$result = $mysqli->query("SELECT " . $dbprefix . "members.member_id, " . $dbprefix . "members.username, " . $dbprefix . "ranks.name FROM " . $dbprefix . "console_members, " . $dbprefix . "members, " . $dbprefix . "ranks WHERE " . $dbprefix . "console_members.member_id = " . $dbprefix . "members.member_id AND " . $dbprefix . "members.rank_id = " . $dbprefix . "ranks.rank_id AND " . $dbprefix . "console_members.console_id IN " . $sqlCID . " AND " . $dbprefix . "console_members.allowdeny = '1' AND " . $dbprefix . "members.disabled = '0' ORDER BY " . $dbprefix . "ranks.ordernum DESC");
while ($row = $result->fetch_assoc()) {
    $member->select($row['member_id']);
    $rankObj->select($row['rank_id']);
    $rankObj->select($member->get_info("rank_id"));
    $rankInfo = $rankObj->get_info();
    $dispDefaultPower = "Can't Promote";
    if ($rankInfo['promotepower'] != 0 && $rankObj->select($rankInfo['promotepower'])) {
        $dispDefaultPower = $rankObj->get_info_filtered("name");
    }
    $memberoptions .= "<option value='" . $row['member_id'] . "' data-maxrank='" . $member->get_info("promotepower") . "' data-defaultpower=\"" . $dispDefaultPower . "\">" . $row['name'] . " " . $row['username'] . "</option>";
}
if ($memberoptions == "") {
    $_POST['submit'] = false;
}
if ($_POST['submit']) {
    // Check Member
    if (!$member->select($_POST['member'])) {
        $countErrors++;
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:setpromotionpower.php

示例14: MAX

}
$cID = $_GET['cID'];
$dispError = "";
$countErrors = 0;
if ($memberInfo['rank_id'] == 1) {
    $maxOrderNum = $mysqli->query("SELECT MAX(ordernum) FROM " . $dbprefix . "ranks WHERE rank_id != '1'");
    $arrMaxOrderNum = $maxOrderNum->fetch_array(MYSQLI_NUM);
    if ($maxOrderNum->num_rows > 0) {
        $result = $mysqli->query("SELECT rank_id FROM " . $dbprefix . "ranks WHERE ordernum = '" . $arrMaxOrderNum[0] . "'");
        $row = $result->fetch_assoc();
        $rankInfo['promotepower'] = $row['rank_id'];
    }
}
$rankObj = new Rank($mysqli);
if ($_POST['submit']) {
    $rankObj->select($rankInfo['promotepower']);
    $maxRankInfo = $rankObj->get_info_filtered();
    if ($rankInfo['rank_id'] == 1) {
        $maxRankInfo['ordernum'] += 1;
    }
    $arrRanks = array();
    $result = $mysqli->query("SELECT * FROM " . $dbprefix . "ranks WHERE ordernum <= '" . $maxRankInfo['ordernum'] . "' AND rank_id != '1' ORDER BY ordernum DESC");
    while ($row = $result->fetch_assoc()) {
        $arrRanks[] = $row['rank_id'];
        if ($maxRankInfo['ordernum'] > $row['ordernum']) {
            $arrMemRanks[] = $row['rank_id'];
        }
    }
    // Check Member
    if (!$member->select($_POST['member']) || $_POST['member'] == $memberInfo['member_id']) {
        $countErrors++;
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:setrank.php

示例15: MAX

    $rankInfo['promotepower'] = 0;
}
$cID = $_GET['cID'];
$dispError = "";
$countErrors = 0;
if ($memberInfo['rank_id'] == 1) {
    $maxOrderNum = $mysqli->query("SELECT MAX(ordernum) FROM " . $dbprefix . "ranks WHERE rank_id != '1'");
    $arrMaxOrderNum = $maxOrderNum->fetch_array(MYSQLI_NUM);
    if ($maxOrderNum->num_rows > 0) {
        $result = $mysqli->query("SELECT rank_id FROM " . $dbprefix . "ranks WHERE ordernum = '" . $arrMaxOrderNum[0] . "'");
        $row = $result->fetch_assoc();
        $rankInfo['promotepower'] = $row['rank_id'];
    }
}
$rankObj = new Rank($mysqli);
$rankObj->select($rankInfo['promotepower']);
$maxRankInfo = $rankObj->get_info_filtered();
$arrRanks = array();
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "ranks WHERE ordernum <= '" . $maxRankInfo['ordernum'] . "' AND rank_id != '1' ORDER BY ordernum DESC");
while ($row = $result->fetch_assoc()) {
    $arrRanks[] = $row['rank_id'];
}
if ($_POST['submit']) {
    // Check Member
    if (!$member->select($_POST['member'])) {
        $countErrors++;
        $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> You selected an invalid member.<br>";
    } elseif ($member->select($_POST['member']) && !in_array($member->get_info("rank_id"), $arrRanks)) {
        $countErrors++;
        $dispError .= "&nbsp;&nbsp;&nbsp;<b>&middot;</b> You may not change that member's password.<br>";
    }
开发者ID:nsystem1,项目名称:clanscripts,代码行数:31,代码来源:resetpassword.php


注:本文中的Rank::select方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。