コード例 #1
0
function _PushCharactersTable($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $URL, $_80)
{
    global $L;
    $connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB);
    $REALM_ARRAY = array();
    $CHAR_ARRAY = array();
    $query = mysql_query("SELECT `id`,`name` FROM `realmlist`;", $connection) or die(mysql_error());
    while ($result = mysql_fetch_array($query)) {
        $REALM_ARRAY[$result['name']] = $result['id'];
    }
    foreach ($REALM_ARRAY as $RealmName => $RealmID) {
        $connection = _MySQLConnect(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID));
        $query = mysql_query("SELECT `guid`,`name`,`level`,`race`,`class`,`gender` FROM `characters` WHERE `account` = " . (int) _getAccountID() . ";", $connection) or die(mysql_error());
        while ($result = mysql_fetch_array($query)) {
            if ($_80 == 80 && $result['level'] < 80) {
                continue;
            }
            $CHAR_ARRAY[$RealmID . $result['guid']]['CharName'] = $result['name'];
            $CHAR_ARRAY[$RealmID . $result['guid']]['CharGUID'] = $result['guid'];
            $CHAR_ARRAY[$RealmID . $result['guid']]['CharClass'] = $result['class'];
            $CHAR_ARRAY[$RealmID . $result['guid']]['CharRace'] = $result['race'];
            $CHAR_ARRAY[$RealmID . $result['guid']]['CharLevel'] = $result['level'];
            $CHAR_ARRAY[$RealmID . $result['guid']]['CharGender'] = $result['gender'];
            $CHAR_ARRAY[$RealmID . $result['guid']]['RealmName'] = $RealmName;
            $CHAR_ARRAY[$RealmID . $result['guid']]['RealmID'] = $RealmID;
        }
        mysql_close($connection) or die(mysql_error());
    }
    $TRIGGER = "";
    $H2 = empty($CHAR_ARRAY) ? $L[62] : $L[61];
    echo "\n            <div class = 'text-center'>\n                <h2>" . $H2 . "</h2>\n                <fieldset>";
    foreach ($CHAR_ARRAY as $key => $value) {
        if ($TRIGGER != $value['RealmID']) {
            echo "<legend>" . $value['RealmName'] . "</legend>";
            $TRIGGER = $value['RealmID'];
        }
        echo "\n            <a href = " . $URL . "?realmid=" . $value['RealmID'] . "&guid=" . $value['CharGUID'] . "><div style = 'width:273px;' class = 'charBox alert'>\n            <table>\n                <tr>\n                    <td width = '73'>\n                        <img class = 'img-rounded' src = '_template/img/_faces/" . _getAvatarPicString($value['CharLevel'], $value['CharGender'], $value['CharRace'], $value['CharClass']) . "'\n                        border = 'none'>\n                    </td>\n                    <td width = '200'>\n                    <h4>" . $value['CharName'] . "</h4>\n                        <span class = ''>" . _getCharacter_L_R_S_C_STR($value['CharLevel'], $value['CharGender'], $value['CharRace'], $value['CharClass']) . "</span><br/>\n                    </td>\n                </tr>\n            </table>\n            </div></a>";
    }
    echo "</fieldset>\n            </div>";
}
コード例 #2
0
function _FORM_CHAR_BLOCK($CA, $H = null, $G = null, $NL = null, $NN = null, $NR = null, $NC = null, $C = null)
{
    global $L;
    $class_STR = isset($class_STR) ? "alert alert-success" : "alert";
    $H = isset($H) ? " (" . $H . ")" : "";
    echo "\n            <div class = 'charBox " . $class_STR . "'>\n            <table>";
    $NAME_AFTER = isset($C) ? "???" : $CA['CharName'];
    $NAME_AFTER = isset($NN) ? "???" : $CA['CharName'];
    echo "\n                <tr>\n                    <td width = '73'>\n                        <img class = 'img-rounded' src = '_template/img/_faces/";
    if (isset($NR) || isset($NC) || isset($C)) {
        echo "0-0-0-0.png";
    } else {
        echo _getAvatarPicString(isset($NL) ? $NL : $CA['CharLevel'], $CA['CharGender'], $CA['CharRace'], $CA['CharClass']);
    }
    echo "' border = 'none'></img>\n                    </td>\n                    <td width = '362'><h4>" . $NAME_AFTER . $H . "</h4>\n                        <span class = 'pull-left'>" . _getCharacter_L_R_S_C_STR(isset($NL) ? $NL : $CA['CharLevel'], isset($C) ? -1 : $CA['CharGender'], isset($NR) ? "???" : $CA['CharRace'], isset($NC) ? "???" : $CA['CharClass']) . "<br/>" . _getCharMoneySTR($CA['CharMoney']) . "</span>";
    echo "\n                        <span class = 'pull-right'>\n                        " . $L[119] . ": " . $CA['RealmName'] . "<br/>\n                        " . $L[118] . ": " . $CA['CharHKills'] . "</span>\n                    </td>\n                </tr>\n            </table>\n        </div>";
}