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>"; }
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>"; }