} } } if ($do_query) { // Return the captain of the arenateam // $captaindata = mysql_fetch_assoc(execute_query("SELECT `name`, `race`, `class`, `data` FROM `characters` WHERE `guid` = " . $arenateam["captainguid"] . " LIMIT 1")); $char_data = explode(" ", $captaindata["data"]); $captaindata["level"] = $char_data[$defines["LEVEL"][CLIENT]]; $captain_gender = dechex($char_data[$defines["GENDER"][CLIENT]]); unset($char_data); $captain_gender = str_pad($captain_gender, 8, 0, STR_PAD_LEFT); $captaindata["gender"] = $captain_gender[3]; // Faction Info // $faction_name = GetFaction($captaindata["race"]); $faction_number = $faction_name == "alliance" ? 0 : 1; $mlquery = execute_query("SELECT * FROM `characters`, `arena_team_member` WHERE `characters`.`guid`=`arena_team_member`.`guid` and `arenateamid` = " . $arenateam["arenateamid"] . exclude_GMs() . " ORDER BY `personal_rating` DESC"); // Get number of members in arenateam // $arenateam_members = mysql_num_rows($mlquery); // Statistics // if ($arenateam["wins"]) { $arenateam["win_percent_week"] = round($arenateam["wins"] / $arenateam["games"] * 100); } else { $arenateam["win_percent_week"] = 0; } if ($arenateam["wins2"]) { $arenateam["win_percent_season"] = round($arenateam["wins2"] / $arenateam["played"] * 100); } else { $arenateam["win_percent_season"] = 0; } $arenateam["losses_week"] = $arenateam["games"] - $arenateam["wins"]; $arenateam["losses_season"] = $arenateam["played"] - $arenateam["wins2"];
} else { $do_query = 1; } } } if ($do_query) { // Return the leader of the guild // $gleader = execute_query("SELECT `name`, `race`, `class`, `data` FROM `characters` WHERE `guid` = " . $guild["leaderguid"] . " LIMIT 1"); $gmdata = mysql_fetch_assoc($gleader); $char_data = explode(" ", $gmdata["data"]); $gmdata["level"] = $char_data[$defines["LEVEL"][CLIENT]]; $gm_gender = dechex($char_data[$defines["GENDER"][CLIENT]]); unset($char_data); $gm_gender = str_pad($gm_gender, 8, 0, STR_PAD_LEFT); $gmdata["gender"] = $gm_gender[3]; $mlquery = execute_query("SELECT * FROM `characters`, `guild_member` WHERE `characters`.`guid`=`guild_member`.`guid` and `guildid` = " . $guild["guildid"] . exclude_GMs() . " ORDER BY `rank` ASC"); // Get number of members in guild // $guild_members = mysql_num_rows($mlquery); // Faction Info // // Member Data // $faction = GetFaction($gmdata["race"]); ?> <div class="sub-head"> <div id="divCharTabs"> <div class="tabs"> <div class="hide"> <div class="select1"> <ul> <li class="tab-left"></li> <li class="tab-content"> <a class="active" href="index.php?searchType=guildinfo&guildid=<?php
<td width="12%" align="center"><a href="index.php?searchType=team&type=<?php echo $type, "&realm=", REALM_NAME; ?> &sortBy=rating"><?php echo $lang["rating"]; ?> </a></td><td align="right"> <div> <b></b> </div> </td> </tr> <?php // Query // switchConnection("characters", REALM_NAME); $pvpquery = execute_query("SELECT at.`arenateamid`, at.`name`, `BackgroundColor`, `EmblemStyle`, `EmblemColor`, `BorderColor`, `rating`, `wins2`, `played` - `wins2` AS `losses`, `rank`, c.`name` AS captain_name, `race`\r\nFROM `arena_team` AS at, `arena_team_stats` AS atm, `characters` AS c\r\nWHERE at.`arenateamid` = atm.`arenateamid` AND `played` <> 0 AND `type` = " . $type . " AND `captainguid` = c.`guid`" . exclude_GMs() . " ORDER BY `" . $orderField . "` DESC LIMIT " . $config["TeamTop"]); $i = 0; while ($team = mysql_fetch_assoc($pvpquery)) { $i++; $team["faction"] = GetFaction($team["race"]); $team["captain_name"] = $team["captain_name"] ? $team["captain_name"] : $lang["unknown"]; $teamMembers = mysql_result(execute_query("SELECT COUNT(*) FROM `arena_team_member` WHERE `arenateamid` = " . $team["arenateamid"]), 0); ?> <tr> <td> <div> <p></p> </div> </td><td><q><i><span class="veryplain"><?php echo ordinal_suffix($team["rank"]); ?>
</a></td><td align="right"> <div> <b></b> </div> </td> </tr> <?php // Query // if ($orderField == "kills") { $tablefield = $defines["KILLS"][CLIENT]; } else { //if($orderField == "honor") $tablefield = $defines["HONOR"][CLIENT]; } switchConnection("characters", REALM_NAME); $pvpquery = execute_query("SELECT `guid`, `data`, `name`, `race`, `class` FROM `characters`\r\nWHERE CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', " . ($tablefield + 1) . "), ' ', -1) AS UNSIGNED) > 0" . exclude_GMs() . " ORDER BY CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', " . ($tablefield + 1) . "), ' ', -1) AS UNSIGNED) DESC LIMIT " . $config['PvPTop']); $counter = 0; while ($char = mysql_fetch_assoc($pvpquery)) { $counter++; $char_data = explode(" ", $char["data"]); $char["kills"] = $char_data[$defines["KILLS"][CLIENT]]; $char["honor"] = $char_data[$defines["HONOR"][CLIENT]]; $char["level"] = $char_data[$defines["LEVEL"][CLIENT]]; $char_gender = dechex($char_data[$defines["GENDER"][CLIENT]]); unset($char_data); $char_gender = str_pad($char_gender, 8, 0, STR_PAD_LEFT); $char["gender"] = $char_gender[3]; switchConnection("characters", REALM_NAME); $gquery = mysql_fetch_assoc(execute_query("SELECT `guildid` FROM `guild_member` WHERE `guid` = " . $char["guid"] . " LIMIT 1")); $char["guildid"] = $gquery ? $gquery["guildid"] : 0; $char["faction"] = GetFaction($char["race"]);
</a></td><td align="right"> <div> <b></b> </div> </td> </tr> <?php // Query // if ($orderField == "arenapoints") { $tablefield = "CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', " . ($defines["ARENAPOINTS"][CLIENT] + 1) . "), ' ', -1) AS UNSIGNED)"; } else { //if($orderField == "personal_rating") $tablefield = "`personal_rating`"; } switchConnection("characters", REALM_NAME); $pvpquery = execute_query("SELECT c.`guid`, `data`, c.`name`, `race`, `class`, atm.`arenateamid`, `personal_rating`, at.`name` AS arena_team_name, `captainguid`\r\nFROM `characters` AS c, `arena_team_member` AS atm, `arena_team` AS at\r\nWHERE c.`guid` = atm.`guid` AND atm.`arenateamid` = at.`arenateamid` AND `type` = " . $type . exclude_GMs() . " ORDER BY " . $tablefield . " DESC LIMIT " . $config["ArenaTop"]); $counter = 0; while ($char = mysql_fetch_assoc($pvpquery)) { $counter++; $char_data = explode(" ", $char["data"]); $char["arenapoints"] = $char_data[$defines["ARENAPOINTS"][CLIENT]]; $char["level"] = $char_data[$defines["LEVEL"][CLIENT]]; $char_gender = dechex($char_data[$defines["GENDER"][CLIENT]]); unset($char_data); $char_gender = str_pad($char_gender, 8, 0, STR_PAD_LEFT); $char["gender"] = $char_gender[3]; $char["faction"] = GetFaction($char["race"]); if (!isset($arenateamInfoTooltip[$char["arenateamid"]])) { switchConnection("characters", REALM_NAME); if ($teamCaptain = mysql_fetch_assoc(execute_query("SELECT `name` FROM `characters` WHERE `guid` = " . $char["captainguid"] . " LIMIT 1"))) { $teamCaptainName = $teamCaptain["name"];
<?php if (!defined("Armory")) { header("Location: ../error.php"); exit; } $error = ""; if (!isset($_GET["character"])) { $error = "If you are seeing this error message, you must have followed a bad link to this page."; } else { if (!($request = validate_string($_GET["character"]))) { $error = "You have entered " . $_GET["character"] . " which is invalid character name."; } else { switchConnection("characters", REALM_NAME); $StatQuery = execute_query("SELECT `guid`, `data`, `name`, `race`, `class` FROM `characters` WHERE `name` = '" . $request . "'" . exclude_GMs() . " LIMIT 1"); if (!($data = mysql_fetch_assoc($StatQuery))) { $error = "Character " . $request . " does not exist on realm " . REALM_NAME; } } } if ($error) { ?> <div class="parchment-top"> <div class="parchment-content"> <?php showerror("character", $error); } else { require "configuration/statisticshandler.php"; $stat = assign_stats($data); switchConnection("characters", REALM_NAME); $guildid = mysql_fetch_assoc(execute_query("SELECT `guildid` FROM `guild_member` WHERE `guid` = " . $stat["guid"] . " LIMIT 1"));