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