} else {
$do_query = 1;
}
}
}
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;
}
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"]);
?>
</span></i></q></td>
<td><q><span id="emblem_<?php
echo $i;
?>
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
echo $guildId, "&realm=", REALM_NAME;
?>
"><?php
echo $lang["guild_roster"];
?>
$team["personal_win_loss"] = $team["wons_season"] . " - " . ($team["played_season"] - $team["wons_season"]);
$team["personal_win_percent"] = round($team["wons_season"] / $team["played_season"] * 100);
} else {
$team["personal_win_loss"] = "0 - 0";
$team["personal_win_percent"] = 0;
}
$team["link"] = "index.php?searchType=teaminfo&arenateamid=" . $team["arenateamid"] . "&realm=" . REALM_NAME;
// Captain
$char_data = explode(" ", $team["data"]);
$team["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);
$team["gender"] = $captain_gender[3];
// Faction Info //
$team["faction_name"] = GetFaction($team["race"]);
$team["faction"] = $team["faction_name"] == "alliance" ? 0 : 1;
$team["members"] = "";
switchConnection("characters", REALM_NAME);
$membersquery = execute_query("SELECT `name` FROM `characters`, `arena_team_member`\r\n\t\t WHERE `characters`.`guid` = `arena_team_member`.`guid` AND `arenateamid` = " . $team["arenateamid"]);
while ($member = mysql_fetch_assoc($membersquery)) {
$memberLink = "<a href=\"index.php?searchType=profile&character=" . $member["name"] . "&realm=" . REALM_NAME . "\">" . $member["name"] . "</a>";
$team["members"] .= $team["members"] ? ", " . $memberLink : $memberLink;
}
?>
</td><td class="tip-right"></td>
</tr>
<tr>
<td class="tip-bot-left"></td><td class="tip-bot"></td><td class="tip-bot-right"></td>
</tr>
</table>
}
} else {
if ($adminaction == "delself") {
if (strcmp($_REQUEST['sure'], 'yes') == 0) {
DeleteSelf($login, $password, $chatpath);
echo "<input type='hidden' name='adminaction' value='logout'>";
} else {
echo "<p>Clicking the button below will delete yourself...</p>";
echo "<input type='hidden' name='sure' value='yes'>";
echo "<input type='hidden' name='adminaction' value='delself'>";
}
} else {
if ($adminaction == "faction" && CheckFlags("LZmM", $userlevel)) {
$fedit = $_REQUEST['fedit'];
if (!$fedit && !CheckFlags("ZmM", $userlevel)) {
$fedit = GetFaction($login, $chatpath);
}
if ($fedit) {
$ficon = $_REQUEST['ficon'];
if ($ficon) {
AlterFaction($fedit, $ficon);
} else {
$fact = GetFactionDetails($chatpath, $fedit);
echo "Editing " . ucwords($fact[2]) . "<br>\nFaction icon: <input type=text name=ficon value=\"{$fact['3']}\">";
echo "<input type=hidden name=adminaction value={$adminaction}><input type=hidden name=fedit value=\"{$fedit}\">";
}
} else {
echo "Edit faction <select name=fedit>";
$fact = @count_mysql_query("SELECT id,name FROM uo_chat_faction WHERE chat='{$chatpath}' ORDER BY name ASC", $handler);
while ($facl = @mysql_fetch_row($fact)) {
echo "<option value={$facl['0']}>{$facl['1']}";
if ($do_query) {
$arenateams = array();
switchConnection("characters", REALM_NAME);
$gquery = execute_query("SELECT `arena_team`.`arenateamid`, `name`, `captainguid`, `type`, `rating` FROM `arena_team`, `arena_team_stats` WHERE `arena_team`.`arenateamid` = `arena_team_stats`.`arenateamid` AND `arena_team`.`name` LIKE '%" . change_whitespace($SearchQuery) . "%'");
$totalResults = mysql_num_rows($gquery);
while ($gresults = mysql_fetch_assoc($gquery)) {
$theGuid = $gresults["arenateamid"];
$theName = $gresults["name"];
$theType = $gresults["type"];
$theRating = $gresults["rating"];
$theCaptain = $gresults["captainguid"];
$theMembers = mysql_result(execute_query("SELECT COUNT(*) FROM `arena_team_member` WHERE `arenateamid` = " . $gresults["arenateamid"]), 0);
$captaindata = mysql_fetch_assoc(execute_query("SELECT `name`, `race` FROM `characters` WHERE `guid` = " . $theCaptain . " LIMIT 1"));
$theCaptainName = $captaindata["name"];
$theCaptainRace = $captaindata["race"];
$theFaction = GetFaction($theCaptainRace);
$arenateams[] = array($theGuid, $theName, $theCaptainName, $theMembers, $theFaction, $theType, $theRating);
}
if ($totalResults) {
// Now output arenateam data //
$orders = array("name", "captain", "members", "faction", "type", "rating");
$orderOppositeSort = array();
$orderSymbol = array();
$orderClassSuffix = array();
foreach ($orders as $val) {
$orderOppositeSort[$val] = "DESC";
$orderSymbol[$val] = "";
$orderClassSuffix[$val] = "";
}
if (isset($_GET["orderBy"])) {
// client is using an order by //
$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"]);
?>
<tr>
<td>
<div>
<p></p>
</div>
</td><td><q><i><span class="veryplain"><?php
echo $counter;
?>
</span></i></q></td>
<td><q><a href="index.php?searchType=profile&character=<?php
echo $char["name"] . "&realm=" . REALM_NAME;
?>
" onmouseover="showTip('<?php
echo $lang["char_link"];
<option value="5">Penktas</option>
<option value="6">Šeštas</option>
</select>
<input type="submit" value="Siųsti" />
</form></center>';
}
} else {
echo '<div class="errorbox">Šis žaidėjas ne Jūsų frakcijoje</div>';
}
} else {
$result = mysql_query('SELECT Faction,FRank FROM players WHERE id=' . $id);
$row = mysql_fetch_array($result);
$memresult = mysql_query('SELECT COUNT(id) FROM players WHERE Faction=' . $row['Faction']);
$memrow = mysql_fetch_array($memresult);
$resultz = mysql_query('SELECT id,Name,PhNumber,FRank FROM players WHERE Faction=' . $row['Faction'] . ' ORDER BY FRank DESC');
echo '<center><span style="font-size:24px;font-weight:bold;padding-left:18px;">' . GetFaction($row['Faction']) . '</span>';
echo '<div style="background-color:#c7eebd;border:1px solid #2f8c19;color:#2f8c19;padding:12px;width:50%;"><span style="font-size:14px;font-weight:bold">Darbuotojų sąrašas:</span>
<table border="1" cellpadding="3" cellspacing="0" rules="rows" frame="below">
<tr><th>Vardas_Pavardė</th> <th>Rangas</th> <th>IC numeris</th> <th></th> <th></th></tr>';
while ($rowz = mysql_fetch_array($resultz)) {
echo '<tr><td>' . $rowz['Name'] . '</td> <td>' . $rowz['FRank'] . '</td> <td>' . $rowz['PhNumber'] . '</td> <td><a href="?pareigos=' . $rowz['id'] . '"><img src="images/edit.png" border="0"></a> <td><a href="?ismesti=' . $rowz['id'] . '"><img src="images/trinti.png" border="0"></a></td></tr>
';
}
echo '</table>Išviso: ' . $memrow['COUNT(id)'] . '</div></center>';
}
} else {
echo '<div class="errorbox">Jūs nesate jokios frakcijos vadovas</div><br /><div style="text-align:center"><a href="/home">Grįžti atgal</a></div>';
}
} else {
header('Location: /home');
}
}
}
if ($do_query) {
$guilds = array();
switchConnection("characters", REALM_NAME);
$gquery = execute_query("SELECT `guildid`, `name`, `leaderguid` FROM `guild` WHERE `name` LIKE '%" . change_whitespace($SearchQuery) . "%'");
$totalResults = mysql_num_rows($gquery);
while ($gresults = mysql_fetch_assoc($gquery)) {
$theGuid = $gresults["guildid"];
$theName = $gresults["name"];
$theLeader = $gresults["leaderguid"];
$theMembers = mysql_result(execute_query("SELECT COUNT(*) FROM `guild_member` WHERE `guildid` = " . $gresults["guildid"]), 0);
$leaderdata = mysql_fetch_assoc(execute_query("SELECT `name`, `race` FROM `characters` WHERE `guid` = " . $theLeader . " LIMIT 1"));
$theLeaderName = $leaderdata["name"];
$theLeaderRace = $leaderdata["race"];
$theFaction = GetFaction($theLeaderRace);
$guilds[] = array($theGuid, $theName, $theLeaderName, $theMembers, $theFaction);
}
if ($totalResults) {
// Now output guild data //
$orders = array("name", "leader", "members", "faction");
$orderOppositeSort = array();
$orderSymbol = array();
$orderClassSuffix = array();
foreach ($orders as $val) {
$orderOppositeSort[$val] = "DESC";
$orderSymbol[$val] = "";
$orderClassSuffix[$val] = "";
}
if (isset($_GET["orderBy"])) {
// client is using an order by //
}
?>
</div>
</div>
</div>
</div>
<div class="parchment-top">
<div class="parchment-content">
<div class="mini-search-start-state" id="results-side-switch">
<?php
startcontenttable("player-side");
?>
<div class="profile-wrapper">
<div class="profile">
<div class="faction-<?php
echo GetFaction($stat["race"]);
?>
">
<div class="profile-left">
<div class="profile-right">
<div class="profile-content">
<script type="text/javascript">
rightSideImage = "character";
changeRightSideImage(rightSideImage);
</script>
<div class="profile-header">
<div class="profile-avatar">
<div class="profile-placeholder">
<a class="avatar-position"><img src="images/portraits/<?php
echo GetCharacterPortrait($stat["level"], $stat["gender"], $stat["race"], $stat["class"]);
?>
