function view_guild()
{
global $lang_guild, $lang_global, $output, $realm_db, $characters_db, $mmfpm_db, $realm_id, $itemperpage, $action_permission, $user_lvl, $user_id, $showcountryflag;
if (!isset($_GET['id'])) {
redirect("guild.php?error=1&realm={$realmid}");
}
$sqlr = new SQL();
$sqlr->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
if (empty($_GET['realm'])) {
$realmid = $realm_id;
} else {
$realmid = $sqlr->quote_smart($_GET['realm']);
if (!is_numeric($realmid)) {
$realmid = $realm_id;
}
}
$sqlc = new SQL();
$sqlc->connect($characters_db[$realmid]['addr'], $characters_db[$realmid]['user'], $characters_db[$realmid]['pass'], $characters_db[$realmid]['name']);
$guild_id = $sqlc->quote_smart($_GET['id']);
if (is_numeric($guild_id)) {
} else {
redirect("guild.php?error=6&realm={$realmid}");
}
//==========================SQL INGUILD and GUILDLEADER======================
$q_inguild = $sqlc->query("select 1 from guild_member where guildid = '{$guild_id}' and guid in (select guid from characters where account = '{$user_id}')");
$inguild = $sqlc->result($q_inguild, 0, '1');
if ($user_lvl < $action_permission['update'] && !$inguild) {
redirect("guild.php?error=6&realm={$realmid}");
}
$q_amIguildleader = $sqlc->query("select 1 from guild where guildid = '{$guild_id}' and leaderguid in (select guid from characters where account = '{$user_id}')");
$amIguildleader = $sqlc->result($q_amIguildleader, 0, '1');
$q_guildmemberCount = $sqlc->query("SELECT 1 from guild_member where guildid = '{$guild_id}'");
$guildmemberCount = $sqlc->num_rows($q_guildmemberCount);
//====================SQL INGUILD and GUILDLEADER end========================
//==========================$_GET and SECURE=================================
$start = isset($_GET['start']) ? $sqlc->quote_smart($_GET['start']) : 0;
if (is_numeric($start)) {
} else {
$start = 0;
}
$order_by = isset($_GET['order_by']) ? $sqlc->quote_smart($_GET['order_by']) : "mrank";
if (!preg_match("/^[_[:lower:]]{1,10}\$/", $order_by)) {
$order_by = "mrank";
}
$dir = isset($_GET['dir']) ? $sqlc->quote_smart($_GET['dir']) : 1;
if (!preg_match("/^[01]{1}\$/", $dir)) {
$dir = 1;
}
$order_dir = $dir ? "ASC" : "DESC";
$dir = $dir ? 0 : 1;
//==========================$_GET and SECURE end=============================
$query = $sqlc->query("SELECT guildid, name, info, MOTD, createdate,\r\n (select count(*) from guild_member where guildid = '{$guild_id}') as mtotal,\r\n (select count(*) from guild_member where guildid = '{$guild_id}' and guid in\r\n (select guid from characters where online = 1)) as monline\r\n FROM guild WHERE guildid = '{$guild_id}'");
$guild_data = $sqlc->fetch_row($query);
$output .= "\r\n<center>\r\n\t<div id=\"tab_content\">\r\n\t\t<div id=\"tab\">\r\n\t\t\t<ul>\r\n\t\t\t\t<li id=\"selected\"><a href=\"guild.php?action=view_guild&realm={$realmid}&error=3&id={$guild_data['0']}\">" . $lang_guild['members'] . "</a></li>\r\n\t\t\t\t<li><a href=\"guildbank.php?id={$guild_id}&realm={$realmid}\">" . $lang_guild['guildbank'] . "</a></li>\r\n\t\t\t</ul>\r\n\t\t</div>\r\n";
$output .= "\r\n <script type=\"text/javascript\">\r\n answerbox.btn_ok='{$lang_global['yes']}';\r\n answerbox.btn_cancel='{$lang_global['no']}';\r\n </script>\r\n\t\t<div id=\"tab_content2\">\r\n\t\t\t<table class=\"hidden\" style=\"width: 100%;\">\r\n <tr>\r\n <td>\r\n <table class=\"lined\"style=\"width: 100%;\">\r\n <tr>\r\n <td width=\"25%\"><b>{$lang_guild['create_date']}:</b><br />" . date('o-m-d', $guild_data[4]) . "</td>\r\n <td width=\"50%\" class=\"bold\">{$guild_data['1']}</td>\r\n <td width=\"25%\"><b>{$lang_guild['tot_m_online']}:</b><br />{$guild_data['6']} / {$guild_data['5']}</td>\r\n </tr>";
if ($guild_data[2] != '') {
$output .= "\r\n <tr>\r\n <td colspan=\"3\"><b>{$lang_guild['info']}:</b><br />{$guild_data['2']}</td>\r\n </tr>";
}
if ($guild_data[3] != '') {
$output .= "\r\n <tr>\r\n <td colspan=\"3\"><b>{$lang_guild['motd']}:</b><br />{$guild_data['3']}</td>\r\n </tr>";
}
$output .= "\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align=\"right\">" . generate_pagination("guild.php?action=view_guild&realm={$realmid}&id={$guild_id}&order_by={$order_by}&dir=" . ($dir ? 0 : 1) . "", $guildmemberCount, $itemperpage, $start) . "</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <table class=\"lined\" style=\"width: 100%;\">\r\n <tr>\r\n <th width=\"1%\">{$lang_guild['remove']}</th>\r\n <th width=\"20%\"><a href=\"guild.php?action=view_guild&error=3&realm={$realmid}&id={$guild_id}&order_by=cname&start={$start}&dir={$dir}\">" . ($order_by == 'cname' ? "<img src=\"img/arr_" . ($dir ? "up" : "dw") . ".gif\" alt=\"\" /> " : "") . "{$lang_guild['name']}</a></th>\r\n <th width=\"1%\"><a href=\"guild.php?action=view_guild&error=3&realm={$realmid}&id={$guild_id}&order_by=crace&start={$start}&dir={$dir}\">" . ($order_by == 'crace' ? "<img src=\"img/arr_" . ($dir ? "up" : "dw") . ".gif\" alt=\"\" /> " : "") . "{$lang_guild['race']}</a></th>\r\n <th width=\"1%\"><a href=\"guild.php?action=view_guild&error=3&realm={$realmid}&id={$guild_id}&order_by=class&start={$start}&dir={$dir}\">" . ($order_by == 'cclass' ? "<img src=\"img/arr_" . ($dir ? "up" : "dw") . ".gif\" alt=\"\" /> " : "") . "{$lang_guild['class']}</a></th>\r\n <th width=\"1%\"><a href=\"guild.php?action=view_guild&error=3&realm={$realmid}&id={$guild_id}&order_by=clevel&start={$start}&dir={$dir}\">" . ($order_by == 'clevel' ? "<img src=\"img/arr_" . ($dir ? "up" : "dw") . ".gif\" alt=\"\" /> " : "") . "{$lang_guild['level']}</a></th>\r\n <th width=\"23%\"><a href=\"guild.php?action=view_guild&error=3&realm={$realmid}&id={$guild_id}&order_by=mrank&start={$start}&dir={$dir}\">" . ($order_by == 'mrank' ? "<img src=\"img/arr_" . ($dir ? "up" : "dw") . ".gif\" alt=\"\" /> " : "") . "{$lang_guild['rank']}</a></th>\r\n <th width=\"25%\">{$lang_guild['pnote']}</th>\r\n <th width=\"25%\">{$lang_guild['offnote']}</th>\r\n <th width=\"1%\"><a href=\"guild.php?action=view_guild&error=3&realm={$realmid}&id={$guild_id}&order_by=clogout&start={$start}&dir={$dir}\">" . ($order_by == 'clogout' ? "<img src=\"img/arr_" . ($dir ? "up" : "dw") . ".gif\" alt=\"\" /> " : "") . "{$lang_guild['llogin']}</a></th>\r\n <th width=\"1%\"><a href=\"guild.php?action=view_guild&error=3&realm={$realmid}&id={$guild_id}&order_by=conline&start={$start}&dir={$dir}\">" . ($order_by == 'conline' ? "<img src=\"img/arr_" . ($dir ? "up" : "dw") . ".gif\" alt=\"\" /> " : "") . "{$lang_guild['online']}</a></th>";
if ($showcountryflag) {
require_once 'libs/misc_lib.php';
$sqlm = new SQL();
$sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);
$output .= "\r\n <th width=\"1%\">{$lang_global['country']}</th>";
}
$output .= "\r\n </tr>";
$members = $sqlc->query("SELECT gm.guid as cguid, c.name as cname, c.`race` as crace ,c.`class` as cclass,\r\n c.`level` AS clevel,\r\n gm.rank AS mrank, (SELECT rname FROM guild_rank WHERE guildid ='{$guild_id}' AND rid = mrank) AS rname,\r\n gm.Pnote, gm.OFFnote, gender,\r\n c.`online` as conline, c.`account`, c.`logout_time` as clogout\r\n FROM guild_member as gm left outer join characters as c on c.guid = gm.guid\r\n WHERE gm.guildid = '{$guild_id}' ORDER BY {$order_by} {$order_dir} LIMIT {$start}, {$itemperpage}");
while ($member = $sqlr->fetch_row($members)) {
$result = $sqlr->query("SELECT gmlevel FROM account WHERE id ='{$member['11']}'");
$owner_gmlvl = $sqlr->result($result, 0, 'gmlevel');
$output .= "\r\n <tr>";
// gm, gildleader or own account! are allowed to remove from guild
$output .= $user_lvl >= $action_permission['delete'] || $amIguildleader || $member[11] == $user_id ? "\r\n <td>\r\n <img src=\"img/aff_cross.png\" alt=\"\" onclick=\"answerBox('{$lang_global['delete']}: <font color=white>{$member[1]}</font><br />{$lang_global['are_you_sure']}', 'guild.php?action=rem_char_from_guild&realm={$realmid}&id={$member['0']}&guld_id={$guild_id}');\" style=\"cursor:pointer;\" />\r\n </td>" : "\r\n <td>\r\n </td>";
$output .= $user_lvl < $owner_gmlvl ? "\r\n <td>" . htmlentities($member[1]) . "</td>" : "\r\n <td><a href=\"char.php?id={$member['0']}&realm={$realmid}\">" . htmlentities($member[1]) . "</a></td>";
$output .= "\r\n <td><img src='img/c_icons/{$member[2]}-{$member[9]}.gif' onmousemove='toolTip(\"" . char_get_race_name($member[2]) . "\",\"item_tooltip\")' onmouseout='toolTip()' alt=\"\" /></td>\r\n <td><img src='img/c_icons/{$member[3]}.gif' onmousemove='toolTip(\"" . char_get_class_name($member[3]) . "\",\"item_tooltip\")' onmouseout='toolTip()' alt=\"\" /></td>\r\n <td>" . char_get_level_color($member[4]) . "</td>\r\n <td>" . htmlentities($member[6]) . " (" . $member[5] . ")</td>\r\n <td>" . htmlentities($member[7]) . "</td>\r\n <td>" . htmlentities($member[8]) . "</td>\r\n <td>" . get_days_with_color($member[12]) . "</td>\r\n <td>" . ($member[10] ? "<img src=\"img/up.gif\" alt=\"\" />" : "-") . "</td>";
if ($showcountryflag) {
$country = misc_get_country_by_account($member[11], $sqlr, $sqlm);
$output .= "\r\n <td>" . ($country['code'] ? "<img src='img/flags/" . $country['code'] . ".png' onmousemove='toolTip(\"" . $country['country'] . "\",\"item_tooltip\")' onmouseout='toolTip()' alt=\"\" />" : "-") . "</td>";
}
$output .= "\r\n </tr>";
}
unset($member);
$output .= "\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align=\"right\">" . generate_pagination("guild.php?action=view_guild&error=3&realm={$realmid}&id={$guild_id}&order_by={$order_by}&dir=" . !$dir, $guildmemberCount, $itemperpage, $start) . "</td>\r\n </tr>\r\n </table>\r\n\t\t</div>\r\n\t</div>\r\n <br />";
$output .= "\r\n <table class=\"hidden\">\r\n <tr>\r\n <td>";
if ($user_lvl >= $action_permission['delete'] || $amIguildleader) {
makebutton($lang_guild['del_guild'], "guild.php?action=del_guild&realm={$realmid}&id={$guild_id}\" type=\"wrn", 130);
$output .= "\r\n </td>\r\n <td>";
}
makebutton($lang_guild['show_guilds'], "guild.php?realm={$realmid}\" type=\"def", 130);
$output .= "\r\n </td>\r\n </tr>\r\n </table>\r\n\t</center>\r\n";
}
function view_team()
{
global $output, $characters_db, $realm_id, $corem_db, $logon_db, $site_encoding, $action_permission, $user_lvl, $user_id, $showcountryflag, $sql, $core;
if (!isset($_GET["id"])) {
redirect("arenateam.php?error=1");
}
$arenateam_id = $sql["char"]->quote_smart($_GET["id"]);
if ($core == 1) {
$query = $sql["char"]->query("SELECT id, name, type,\r\n INET_NTOA(backgroundcolour) AS BackgroundColor,\r\n INET_NTOA(bordercolour) AS BorderColor,\r\n INET_NTOA(emblemcolour) AS EmblemColor,\r\n emblemstyle AS EmblemStyle, borderstyle AS BorderStyle\r\n FROM arenateams\r\n WHERE id='" . $arenateam_id . "'");
} elseif ($core == 2) {
$query = $sql["char"]->query("SELECT arenateamid AS id, name, type,\r\n INET_NTOA(BackgroundColor) AS BackgroundColor,\r\n INET_NTOA(BorderColor) AS BorderColor,\r\n INET_NTOA(EmblemColor) AS EmblemColor,\r\n EmblemStyle, BorderStyle\r\n FROM arena_team\r\n WHERE arenateamid='" . $arenateam_id . "'");
} else {
$query = $sql["char"]->query("SELECT arenaTeamId AS id, name, type,\r\n INET_NTOA(BackgroundColor) AS BackgroundColor,\r\n INET_NTOA(BorderColor) AS BorderColor,\r\n INET_NTOA(EmblemColor) AS EmblemColor,\r\n EmblemStyle, BorderStyle\r\n FROM arena_team\r\n WHERE arenaTeamId='" . $arenateam_id . "'");
}
$arenateam_data = $sql["char"]->fetch_assoc($query);
if ($core == 1) {
// arenateams.data format: [week games] [week wins] [season games] [season wins]
$query = "SELECT id, rating,\r\n SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 2), ' ', 1) AS games, \r\n SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 2), ' ', -1) AS wins,\r\n SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', -2), ' ', 1) AS played, \r\n SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', -2), ' ', -1) AS wins2,\r\n ranking, player_data1, player_data2, player_data3, player_data4, player_data5,\r\n player_data6, player_data7, player_data8, player_data9, player_data10\r\n FROM arenateams WHERE id='" . $arenateam_id . "'";
$query = $sql["char"]->query($query);
} elseif ($core == 2) {
$query = "SELECT arena_team.arenateamid AS id, rating,\r\n games_week AS games, wins_week AS wins, games_season AS played, wins_season AS wins2, rank AS ranking,\r\n (SELECT COUNT(*) FROM arena_team_member WHERE arenateamid=id) AS tot_chars\r\n FROM arena_team\r\n LEFT JOIN arena_team_stats ON arena_team_stats.arenateamid=arena_team.arenateamid\r\n LEFT JOIN arena_team_member ON arena_team_member.arenateamid=arena_team.arenateamid\r\n WHERE arena_team.arenateamid='" . $arenateam_id . "'";
$query = $sql["char"]->query($query);
$m_query = "SELECT * FROM arena_team_member WHERE arenateamid='" . $arenateam_id . "'";
$m_query = $sql["char"]->query($m_query);
} else {
$query = "SELECT arena_team.arenaTeamId AS id, rating,\r\n arena_team.weekGames, arena_team.weekWins, arena_team.weekGames AS played, arena_team.seasonWins, rank AS ranking,\r\n (SELECT COUNT(*) FROM arena_team_member WHERE arenaTeamId=id) AS tot_chars\r\n FROM arena_team\r\n LEFT JOIN arena_team_member ON arena_team_member.arenaTeamId=arena_team.arenaTeamId\r\n WHERE arena_team.arenaTeamId='" . $arenateam_id . "'";
$query = $sql["char"]->query($query);
$m_query = "SELECT guid, weekWins AS wons_week, weekGames AS played_week,\r\n seasonWins AS wons_season, seasonGames AS played_season, personalRating as personal_rating\r\n FROM arena_team_member WHERE arenaTeamId='" . $arenateam_id . "'";
$m_query = $sql["char"]->query($m_query);
}
$arenateamstats_data = $sql["char"]->fetch_row($query);
$rating_offset = 1550;
if ($core == 1) {
if ($arenateam_data["type"] == 1) {
$rating_offset += 6;
} elseif ($arenateam_data["type"] == 2) {
$rating_offset += 12;
}
} else {
if ($arenateam_data["type"] == 3) {
$rating_offset += 6;
} elseif ($arenateam_data["type"] == 5) {
$rating_offset += 12;
}
}
$total_members = 0;
if ($core == 1) {
for ($m = 0; $m < 10; $m++) {
$temp = explode(' ', $arenateamstats_data[$m + 7]);
if ($temp[0]) {
$members[$m] = $temp;
}
if ($members[$m][0]) {
$total_members += 1;
}
}
} else {
$total_members = $arenateamstats_data[7];
}
$losses_week = $arenateamstats_data[2] - $arenateamstats_data[3];
if ($arenateamstats_data[2]) {
$winperc_week = round(10000 * $arenateamstats_data[3] / $arenateamstats_data[2]) / 100;
} else {
$winperc_week = $arenateamstats_data[2];
}
$losses_season = $arenateamstats_data[4] - $arenateamstats_data[5];
if ($arenateamstats_data[4]) {
$winperc_season = round(10000 * $arenateamstats_data[5] / $arenateamstats_data[4]) / 100;
} else {
$winperc_season = $arenateamstats_data[4];
}
// extract banner colors
$background_color = explode(".", $arenateam_data["BackgroundColor"]);
$border_color = explode(".", $arenateam_data["BorderColor"]);
$emblem_color = explode(".", $arenateam_data["EmblemColor"]);
// Trinity stores Team type as 2, 3, 5; ArcEmu & MaNGOS use 0, 1, 2
if ($core != 3) {
if ($arenateam_data["type"] == 0) {
$banner_style = 2;
$banner_span = 8;
} elseif ($arenateam_data["type"] == 1) {
$banner_style = 3;
$banner_span = 9;
} elseif ($arenateam_data["type"] == 2) {
$banner_style = 5;
$banner_span = 11;
}
} else {
if ($arenateam_data["type"] == 2) {
$banner_style = 2;
$banner_span = 8;
} elseif ($arenateam_data["type"] == 3) {
$banner_style = 3;
$banner_span = 9;
} elseif ($arenateam_data["type"] == 5) {
$banner_style = 5;
$banner_span = 11;
}
}
$output .= '
<script type="text/javascript">
answerbox.btn_ok="' . lang("global", "yes_low") . '";
answerbox.btn_cancel="' . lang("global", "no") . '";
</script>
<div class="fieldset_border arena_fieldset center">
<span class="legend">' . lang("arenateam", "arenateam") . ' (' . lang("arenateam", $arenateam_data["type"] . ($core == 1 ? "A" : "MT")) . ')</span>
<table class="lined" id="arena_table_with_banner">
<tr class="bold">
<td rowspan="' . $banner_span . '">
<div class="arena_banner">
<img src="libs/banner_lib.php?action=banner&f=' . $banner_style . '&r=' . $background_color[1] . '&g=' . $background_color[2] . '&b=' . $background_color[3] . '" class="banner_img" alt="" />
<img src="libs/banner_lib.php?action=border&f=' . $arenateam_data["BorderStyle"] . '&f2=' . $banner_style . '&r=' . $border_color[1] . '&g=' . $border_color[2] . '&b=' . $border_color[3] . '" class="border_img" alt="" />
<img src="libs/banner_lib.php?action=emblem&f=' . $arenateam_data["EmblemStyle"] . '&r=' . $emblem_color[1] . '&g=' . $emblem_color[2] . '&b=' . $emblem_color[3] . '&s=0.55" class="emblem_img" alt="" />
</div>
</td>
<td colspan="' . ($showcountryflag ? 14 : 13) . '">' . htmlentities($arenateam_data["name"], ENT_COMPAT, $site_encoding) . '</td>
</tr>
<tr>
<td colspan="' . ($showcountryflag ? 14 : 13) . '">' . lang("arenateam", "tot_members") . ': ' . $total_members . '</td>
</tr>
<tr>
<td colspan="4">' . lang("arenateam", "this_week") . ':</td>
<td colspan="2">' . lang("arenateam", "games_played") . ': ' . $arenateamstats_data[2] . '</td>
<td colspan="2">' . lang("arenateam", "games_won") . ': ' . $arenateamstats_data[3] . '</td>
<td colspan="2">' . lang("arenateam", "games_lost") . ': ' . $losses_week . '</td>
<td colspan="' . ($showcountryflag ? 4 : 3) . '">' . lang("arenateam", "ratio") . ': ' . $winperc_week . ' %</td>
</tr>
<tr>
<td colspan="4">' . lang("arenateam", "this_season") . ':</td>
<td colspan="2">' . lang("arenateam", "games_played") . ': ' . $arenateamstats_data[4] . '</td>
<td colspan="2">' . lang("arenateam", "games_won") . ': ' . $arenateamstats_data[5] . '</td>
<td colspan="2">' . lang("arenateam", "games_lost") . ': ' . $losses_season . '</td>
<td colspan="' . ($showcountryflag ? 4 : 3) . '">' . lang("arenateam", "ratio") . ': ' . $winperc_season . ' %</td>
</tr>
<tr>
<td colspan="' . ($showcountryflag ? 14 : 13) . '">' . lang("arenateam", "standings") . ': ' . $arenateamstats_data[6] . ' (' . $arenateamstats_data[1] . ')</td>
</tr>
<tr>
<th style="width: 1%;">' . lang("arenateam", "remove") . '</th>
<th style="width: 1%;">' . lang("arenateam", "name") . '</th>
<th style="width: 1%;">' . lang("char", "race") . '</th>
<th style="width: 1%;">' . lang("char", "class") . '</th>
<th style="width: 1%;">' . lang("arenateam", "personalrating") . '</th>
<th style="width: 1%;">' . lang("arenateam", "lastlogin") . '</th>
<th style="width: 1%;">' . lang("char", "online") . '</th>
<th style="width: 1%;">' . lang("arenateam", "played_week") . '</th>
<th style="width: 1%;">' . lang("arenateam", "wons_week") . '</th>
<th style="width: 5%;">' . lang("arenateam", "win") . ' %</th>
<th style="width: 1%;">' . lang("arenateam", "played_season") . '</th>
<th style="width: 1%;">' . lang("arenateam", "wons_season") . '</th>
<th style="width: 5%;">' . lang("arenateam", "win") . ' %</th>';
if ($showcountryflag) {
$output .= '
<th style="width: 1%;">' . lang("global", "country") . '</th>';
}
$output .= '
</tr>';
if ($core == 1) {
// arena team player structure [player_id] [week_played] [week_win] [season_played] [season_win] [rating]
foreach ($members as $member) {
$query = "SELECT acct, name, level, race, class, online, timestamp, gender\r\n FROM characters WHERE guid='" . $member[0] . "'";
$result = $sql["char"]->query($query);
$member_char = $sql["char"]->fetch_row($result);
$accid = $member_char[0];
$output .= '
<tr>';
if ($user_lvl >= $action_permission["delete"] || $accid == $user_id) {
$output .= '
<td>
<img src="img/aff_cross.png" alt="" onclick="answerBox(\'' . lang("global", "delete") . '\': <spen class=\'color_white\'>' . $member[1] . '</span><br />' . lang("global", "are_you_sure") . '\', \'arenateam.php?action=rem_char_from_team&id=' . $member[0] . '&arenateam_id=' . $arenateam_id . '\');" id="arenateam_delete_cursor" />
</td>';
} else {
$output .= '
<td>
</td>';
}
if ($member[1]) {
$ww_pct = round(10000 * $member[2] / $member[1]) / 100;
} else {
$ww_pct = $member[1];
}
if ($member[3]) {
$ws_pct = round(10000 * $member[4] / $member[3]) / 100;
} else {
$ws_pct = $member[3];
}
$output .= '
<td><a href="char.php?id=' . $member[0] . '">' . htmlentities($member_char[1], ENT_COMPAT, $site_encoding) . '</a></td>
<td><img src="img/c_icons/' . $member_char[3] . '-' . $member_char[7] . '.gif" onmousemove="oldtoolTip(\'' . char_get_race_name($member_char[3]) . '\',\'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" /></td>
<td><img src="img/c_icons/' . $member_char[4] . '.gif" onmousemove="oldtoolTip(\'' . char_get_class_name($member_char[4]) . '\',\'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" /></td>
<td>' . $member[5] . '</td>
<td>' . get_days_with_color($member_char[6]) . '</td>
<td><img src="img/' . ($member_char[5] ? 'up' : 'down') . '.gif" alt="" /></td>
<td>' . $member[1] . '</td>
<td>' . $member[2] . '</td>
<td>' . $ww_pct . '</td>
<td>' . $member[3] . '</td>
<td>' . $member[4] . '</td>
<td>' . $ws_pct . '</td>';
if ($showcountryflag) {
require_once './libs/misc_lib.php';
$country = misc_get_country_by_account($member_char[0]);
$output .= '
<td>' . ($country["code"] ? '<img src="img/flags/' . $country["code"] . '.png" onmousemove="oldtoolTip(\'' . $country["country"] . '\',\'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" />' : '-') . '</td>';
}
$output .= '
</tr>';
}
} else {
while ($member = $sql["char"]->fetch_assoc($m_query)) {
$query = "SELECT account AS acct, name, level, race, class, online, logout_time AS timestamp, gender\r\n FROM characters WHERE guid='" . $member["guid"] . "'";
$result = $sql["char"]->query($query);
$member_char = $sql["char"]->fetch_assoc($result);
$accid = $member_char["acct"];
$output .= '
<tr>';
if ($user_lvl >= $action_permission["delete"] || $accid == $user_id) {
$output .= '
<td><img src="img/aff_cross.png" alt="" onclick="answerBox(\'' . lang("global", "delete") . '\': <span class=\'color_white\'>' . $member["name"] . '</span><br />' . lang("global", "are_you_sure") . '\', \'arenateam.php?action=rem_char_from_team&id=' . $member["guid"] . '&arenateam_id=' . $arenateam_id . '\');" class="arenateam_delete_cursor" /></td>';
} else {
$output .= '
<td>
</td>';
}
if ($member["played_week"]) {
$ww_pct = round(10000 * $member["wons_week"] / $member["played_week"]) / 100;
} else {
$ww_pct = $member["played_week"];
}
if ($member["played_season"]) {
$ws_pct = round(10000 * $member["wons_season"] / $member["played_season"]) / 100;
} else {
$ws_pct = $member["played_season"];
}
// arena team player structure [player_id] [week_played] [week_win] [season_played] [season_win] [rating]
$output .= '
<td><a href="char.php?id=' . $member["guid"] . '">' . htmlentities($member_char["name"], ENT_COMPAT, $site_encoding) . '</a></td>
<td><img src="img/c_icons/' . $member_char["race"] . '-' . $member_char["gender"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_race_name($member_char["race"]) . '\',\'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" /></td>
<td><img src="img/c_icons/' . $member_char["class"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_class_name($member_char["class"]) . '\',\'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" /></td>
<td>' . $member["personal_rating"] . '</td>
<td>' . get_days_with_color($member_char["timestamp"]) . '</td>
<td>' . ($member_char["online"] ? '<img src="img/up.gif" alt="" />' : '<img src="img/down.gif" alt="" />') . '</td>
<td>' . $member["played_week"] . '</td>
<td>' . $member["wons_week"] . '</td>
<td>' . $ww_pct . '</td>
<td>' . $member["played_season"] . '</td>
<td>' . $member["wons_season"] . '</td>
<td>' . $ws_pct . '</td>';
if ($showcountryflag) {
require_once './libs/misc_lib.php';
$country = misc_get_country_by_account($accid);
$output .= '
<td>' . ($country["code"] ? '<img src="img/flags/' . $country["code"] . '.png" onmousemove="oldtoolTip(\'' . $country["country"] . '\',\'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" />' : '-') . '</td>';
}
$output .= '
</tr>';
}
}
$output .= '
</table>
<br />
<table class="hidden">
<tr>
<td>';
if ($user_lvl >= $action_permission["delete"]) {
makebutton(lang("arenateam", "del_team"), "arenateam.php?action=del_team&id=" . $arenateam_id . "&name=" . $arenateam_data["name"] . "\" type=\"wrn", 180);
$output .= '
</td>
<td>';
makebutton(lang("arenateam", "arenateams"), "arenateam.php\" type=\"def", 130);
$output .= '
</td>
</tr>';
} else {
makebutton(lang("arenateam", "arenateams"), "arenateam.php", 130);
$output .= '
</td>
</tr>';
}
$output .= '
</table>
</div>';
}
function view_guild()
{
global $output, $logon_db, $characters_db, $corem_db, $realm_id, $itemperpage, $action_permission, $user_lvl, $user_id, $showcountryflag, $site_encoding, $show_guild_emblem, $sql, $core;
if (!isset($_GET["id"])) {
redirect("guild.php?error=1");
}
$guild_id = $sql["char"]->quote_smart($_GET["id"]);
if (!is_numeric($guild_id)) {
redirect("guild.php?error=6");
}
//==========================SQL INGUILD and GUILDLEADER======================
if ($core == 1) {
$q_inguild = $sql["char"]->query("SELECT 1 FROM guild_data WHERE guildid='" . $guild_id . "' AND playerid IN (SELECT guid FROM characters WHERE acct='" . $user_id . "')");
} else {
$q_inguild = $sql["char"]->query("SELECT 1 FROM guild_member WHERE guildid='" . $guild_id . "' AND guid IN (SELECT guid FROM characters WHERE account='" . $user_id . "')");
}
$inguild = $sql["char"]->result($q_inguild, 0, "1");
if ($user_lvl < $action_permission["update"] && !$inguild) {
redirect("guild.php?error=6");
}
if ($core == 1) {
$q_amIguildleader = $sql["char"]->query("SELECT 1 FROM guilds WHERE guildid='" . $guild_id . "' AND leaderguid IN (SELECT guid FROM characters WHERE acct='" . $user_id . "')");
} else {
$q_amIguildleader = $sql["char"]->query("SELECT 1 FROM guild WHERE guildid='" . $guild_id . "' AND leaderguid IN (SELECT guid FROM characters WHERE account='" . $user_id . "')");
}
$amIguildleader = $sql["char"]->result($q_amIguildleader, 0, "1");
if ($core == 1) {
$q_guildmemberCount = $sql["char"]->query("SELECT 1 FROM guild_data WHERE guildid='" . $guild_id . "'");
} else {
$q_guildmemberCount = $sql["char"]->query("SELECT 1 from guild_member where guildid='" . $guild_id . "'");
}
$guildmemberCount = $sql["char"]->num_rows($q_guildmemberCount);
//====================SQL INGUILD and GUILDLEADER end========================
//==========================$_GET and SECURE=================================
$start = isset($_GET["start"]) ? $sql["char"]->quote_smart($_GET["start"]) : 0;
if (is_numeric($start)) {
} else {
$start = 0;
}
$order_by = isset($_GET["order_by"]) ? $sql["char"]->quote_smart($_GET["order_by"]) : "mrank";
if (!preg_match("/^[_[:lower:]]{1,10}\$/", $order_by)) {
$order_by = "mrank";
}
$dir = isset($_GET["dir"]) ? $sql["char"]->quote_smart($_GET["dir"]) : 1;
if (!preg_match("/^[01]{1}\$/", $dir)) {
$dir = 1;
}
$order_dir = $dir ? "ASC" : "DESC";
$dir = $dir ? 0 : 1;
//==========================$_GET and SECURE end=============================
if ($core == 1) {
$query = $sql["char"]->query("SELECT guildid, guildname AS name, guildinfo AS info, MOTD, createdate,\n (SELECT COUNT(*) FROM guild_data WHERE guildid='" . $guild_id . "') AS mtotal,\n (SELECT COUNT(*) FROM guild_data WHERE guildid='" . $guild_id . "' AND playerid IN\n (SELECT guid FROM characters WHERE online=1)) AS monline,\n emblemStyle AS EmblemStyle,\n emblemColor AS EmblemColor,\n borderStyle AS BorderStyle,\n borderColor AS BorderColor,\n backgroundColor AS BackgroundColor\n FROM guilds WHERE guildid='" . $guild_id . "'");
} else {
$query = $sql["char"]->query("SELECT guildid, name, info, MOTD, createdate,\n (SELECT COUNT(*) FROM guild_member where guildid='" . $guild_id . "') AS mtotal,\n (SELECT COUNT(*) FROM guild_member where guildid='" . $guild_id . "' AND guid IN\n (SELECT guid FROM characters WHERE online=1)) AS monline,\n EmblemStyle, EmblemColor, BorderStyle, BorderColor, BackgroundColor\n FROM guild WHERE guildid='" . $guild_id . "'");
}
$guild_data = $sql["char"]->fetch_assoc($query);
$output .= '
<script type="text/javascript">
answerbox.btn_ok="' . lang("global", "yes") . '";
answerbox.btn_cancel="' . lang("global", "no") . '";
</script>
<div class="guild_fieldset fieldset_border">
<span class="legend">' . lang("guild", "guild") . '</span>
<table class="lined">
<tr>
<td style="width: 25%;" class="hidden"><b>' . lang("guild", "create_date") . ':</b><br />' . date("o-m-d", $guild_data["createdate"]) . '</td>
<td style="width: 50%;" class="bold hidden" colspan="2">' . $guild_data["name"] . '</td>
<td style="width: 25%;" class="hidden"><b>' . lang("guild", "tot_m_online") . ':</b><br />' . $guild_data["monline"] . ' / ' . $guild_data["mtotal"] . '</td>
</tr>
<tr>
<td colspan="2" class="hidden"><b>' . lang("guild", "info") . ':</b><br />' . $guild_data["info"] . '</td>
<td colspan="2" class="hidden"><b>' . lang("guild", "motd") . ':</b><br />' . $guild_data["MOTD"] . '</td>
</tr>';
if ($show_guild_emblem) {
$output .= '
<tr>
<td colspan="4" class="hidden">
<div id="guild_emblem">
<div>
<img id="guild_view_background" src="img/emblems/Background_' . doubledigit($guild_data["BackgroundColor"]) . '.png" alt="" />
<img id="guild_view_emblem" src="img/emblems/Emblem_' . doubledigit($guild_data["EmblemStyle"]) . '_' . doubledigit($guild_data["EmblemColor"]) . '.png" alt="" />
<img id="guild_view_border" src="img/emblems/Border_' . doubledigit($guild_data["BorderStyle"]) . '_' . doubledigit($guild_data["BorderColor"]) . '.png" alt="" />
<img id="guild_emblem_border" src="img/EmblemBorder.png" alt="" />
</div>
</div>
</td>
</tr>
<tr>
<td id="guild_pages_background" style="text-align: right;" colspan="4">' . generate_pagination("guild.php?action=view_guild&id=" . $guild_id . "&order_by=" . $order_by . "&dir=" . ($dir ? 0 : 1), $guildmemberCount, $itemperpage, $start) . '</td>
</tr>
</table>
<table class="lined">
<tr>
<th style="width: 1%;">' . lang("guild", "remove") . '</th>
<th style="width: 15%;"><a href="guild.php?action=view_guild&error=3&id=' . $guild_id . '&order_by=cname&start=' . $start . '&dir=' . $dir . '">' . ($order_by == "cname" ? '<img src="img/arr_' . ($dir ? "up" : "dw") . '.gif" alt="" /> ' : '') . lang("guild", "name") . '</a></th>
<th style="width: 1%;"><a href="guild.php?action=view_guild&error=3&id=' . $guild_id . '&order_by=crace&start=' . $start . '&dir=' . $dir . '">' . ($order_by == "crace" ? '<img src="img/arr_' . ($dir ? "up" : "dw") . '.gif" alt="" /> ' : '') . lang("guild", "race") . '</a></th>
<th style="width: 1%;"><a href="guild.php?action=view_guild&error=3&id=' . $guild_id . '&order_by=class&start=' . $start . '&dir=' . $dir . '">' . ($order_by == "cclass" ? '<img src="img/arr_' . ($dir ? "up" : "dw") . '.gif" alt="" /> ' : '') . lang("guild", "class") . '</a></th>
<th style="width: 1%;"><a href="guild.php?action=view_guild&error=3&id=' . $guild_id . '&order_by=clevel&start=' . $start . '&dir=' . $dir . '">' . ($order_by == "clevel" ? '<img src="img/arr_' . ($dir ? "up" : "dw") . '.gif" alt="" /> ' : '') . lang("guild", "level") . '</a></th>
<th style="width: 25%;"><a href="guild.php?action=view_guild&error=3&id=' . $guild_id . '&order_by=mrank&start=' . $start . '&dir=' . $dir . '">' . ($order_by == "mrank" ? '<img src="img/arr_' . ($dir ? "up" : "dw") . '.gif" alt="" /> ' : '') . lang("guild", "rank") . '</a></th>
<th style="width: 15%;">' . lang("guild", "pnote") . '</th>
<th style="width: 15%;">' . lang("guild", "offnote") . '</th>
<th style="width: 15%;"><a href="guild.php?action=view_guild&error=3&id=' . $guild_id . '&order_by=clogout&start=' . $start . '&dir=' . $dir . '">' . ($order_by == "clogout" ? '<img src="img/arr_' . ($dir ? "up" : "dw") . '.gif" alt="" /> ' : '') . lang("guild", "llogin") . '</a></th>
<th style="width: 1%;"><a href="guild.php?action=view_guild&error=3&id=' . $guild_id . '&order_by=conline&start=' . $start . '&dir=' . $dir . '">' . ($order_by == "conline" ? '<img src="img/arr_' . ($dir ? "up" : "dw") . '.gif" alt="" /> ' : '') . lang("guild", "online") . '</a></th>';
}
if ($showcountryflag) {
require_once "libs/misc_lib.php";
$output .= '
<th style="width: 1%;">' . lang("global", "country") . '</th>';
}
$output .= '
</tr>';
// this_is_junk: WTF? O_o
if ($core == 1) {
$members = $sql["char"]->query("SELECT gm.playerid AS cguid, c.name AS cname, c.`race` AS crace, c.`class` AS cclass,\n c.`level` AS clevel,\n gm.guildrank AS mrank, (SELECT rankname FROM guild_ranks WHERE guildid='" . $guild_id . "' AND rankid=mrank) AS rname,\n gm.publicNote AS pnote, gm.officerNote AS offnote, gender,\n c.`online` AS conline, c.`acct`, c.`timestamp` AS clogout\n FROM guild_data AS gm LEFT OUTER JOIN characters AS c ON c.guid=gm.playerid\n WHERE gm.guildid='" . $guild_id . "' ORDER BY " . $order_by . " " . $order_dir . " LIMIT " . $start . ", " . $itemperpage);
} else {
$members = $sql["char"]->query("SELECT gm.guid AS cguid, c.name AS cname, c.`race` AS crace, c.`class` AS cclass,\n c.`level` AS clevel,\n gm.rank AS mrank, (SELECT rname FROM guild_rank WHERE guildid='" . $guild_id . "' AND rid=mrank) AS rname,\n gm.pnote AS pnote, gm.offnote AS offnote, gender,\n c.`online` AS conline, c.`account` AS acct, c.`logout_time` AS clogout\n FROM guild_member AS gm LEFT OUTER JOIN characters AS c ON c.guid=gm.guid\n WHERE gm.guildid='" . $guild_id . "' ORDER BY " . $order_by . " " . $order_dir . " LIMIT " . $start . ", " . $itemperpage);
}
while ($member = $sql["char"]->fetch_assoc($members)) {
if ($core == 1) {
$query = "SELECT * FROM accounts WHERE acct='" . $member["acct"] . "'";
$result = $sql["logon"]->query($query);
$result = $sql["logon"]->fetch_assoc($result);
$user = $result["login"];
} else {
$query = "SELECT * FROM account WHERE id='" . $member["acct"] . "'";
$result = $sql["logon"]->query($query);
$result = $sql["logon"]->fetch_assoc($result);
$user = $result["username"];
}
$result = $sql["mgr"]->query("SELECT SecurityLevel AS gm FROM config_accounts WHERE Login='******'");
$owner_gmlvl = $sql["logon"]->result($result, 0, "gm");
if ($owner_gmlvl >= 1073741824) {
$owner_gmlvl -= 1073741824;
}
$output .= '
<tr>';
// gm, guildleader or own account! are allowed to remove from guild
$output .= $user_lvl >= $action_permission["delete"] || $amIguildleader || $member["acct"] == $user_id ? '<td><img src="img/aff_cross.png" alt="" onclick="answerBox(\'' . lang("global", "delete") . ': <font color=white>' . $member["cname"] . '</font><br />' . lang("global", "are_you_sure") . '\', \'guild.php?action=rem_char_from_guild&realm=' . $realmid . '&id=' . $member["cguid"] . '&guld_id=' . $guild_id . '\');" class="guild_edit_delete_cursor" /></td>' : '<td></td>';
$output .= '
<td><a href="char.php?id=' . $member["cguid"] . '">' . htmlentities($member["cname"], ENT_COMPAT, $site_encoding) . '</a></td>
<td><img src="img/c_icons/' . $member["crace"] . '-' . $member["gender"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_race_name($member["crace"]) . '\',\'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" /></td>
<td><img src="img/c_icons/' . $member["cclass"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_class_name($member["cclass"]) . '\',\'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" /></td>
<td>' . char_get_level_color($member["clevel"]) . '</td>
<td>' . htmlentities($member["rname"], ENT_COMPAT, $site_encoding) . ' (' . $member["mrank"] . ')</td>
<td>' . htmlentities($member["pnote"], ENT_COMPAT, $site_encoding) . '</td>
<td>' . htmlentities($member["offnote"], ENT_COMPAT, $site_encoding) . '</td>
<td><span style="font-weight: bold;">' . get_days_with_color($member["clogout"]) . '</span></td>
<td><img src="img/' . ($member["conline"] ? 'up' : 'down') . '.gif" alt="" /></td>';
if ($showcountryflag) {
// this_is_junk: apparently sometimes guilds end up with members who don't exist. O_o
// and because they don't exist, they don't have anything in their acct field.
// which misc_get_country_by_account() doesn't like.
if ($member["acct"]) {
$country = misc_get_country_by_account($member["acct"]);
} else {
$country = 0;
}
$output .= '
<td>' . ($country["code"] ? '<img src="img/flags/' . $country["code"] . '.png" onmousemove="oldtoolTip(\'' . $country["country"] . '\',\'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" />' : '-') . '</td>';
}
$output .= '
</tr>';
}
unset($member);
$output .= '
<tr>
<td align="right" class="hidden">' . generate_pagination("guild.php?action=view_guild&error=3&id=" . $guild_id . "&order_by=" . $order_by . "&dir=" . !$dir, $guildmemberCount, $itemperpage, $start) . '</td>
</tr>
</table>
<br />';
$output .= '
<table class="hidden center">
<tr>
<td>';
if ($user_lvl >= $action_permission["delete"] || $amIguildleader) {
makebutton(lang("guild", "del_guild"), "guild.php?action=del_guild&realm=" . $realm_id . "&id=" . $guild_id . "&name=" . $guild_data["name"] . "\" type=\"wrn", 130);
$output .= '
</td>
<td>';
}
makebutton(lang("guild", "guildbank"), "guildbank.php?id=" . $guild_id, 130);
$output .= '
</td>
<td>';
makebutton(lang("guild", "show_guilds"), "guild.php\" type=\"def", 130);
$output .= '
</td>
</tr>
</table>
</div>';
}
function view_team()
{
global $lang_arenateam, $lang_global, $output, $characters_db, $realm_id, $realm_db, $mmfpm_db, $action_permission, $user_lvl, $user_id, $showcountryflag;
if (!isset($_GET['id'])) {
redirect("arenateam.php?error=1");
}
$sqlc = new SQL();
$sqlc->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
$arenateam_id = $sqlc->quote_smart($_GET['id']);
$query = $sqlc->query("SELECT arenateamid, name, type FROM arena_team WHERE arenateamid = '{$arenateam_id}'");
$arenateam_data = $sqlc->fetch_row($query);
$query = $sqlc->query("SELECT arenateamid, rating, weekGames, weekWins, seasonGames, seasonWins, rank FROM arena_team WHERE arenateamid = '{$arenateam_id}'");
$arenateamstats_data = $sqlc->fetch_row($query);
$rating_offset = 1550;
if ($arenateam_data[2] == 3) {
$rating_offset += 6;
} else {
if ($arenateam_data[2] == 5) {
$rating_offset += 12;
}
}
$members = $sqlc->query("SELECT arena_team_member.guid,characters.name, arena_team_member.personalRating, level, arena_team_member.weekGames, arena_team_member.weekWins, arena_team_member.seasonGames, arena_team_member.seasonWins, characters.race, characters.class, characters.online, characters.account, characters.logout_time, gender, account FROM arena_team_member,characters LEFT JOIN arena_team_member k1 ON k1.guid=characters.guid AND k1.arenateamid='{$arenateam_id}' WHERE arena_team_member.arenateamid = '{$arenateam_id}' AND arena_team_member.guid=characters.guid ORDER BY characters.name");
$total_members = $sqlc->num_rows($members);
$losses_week = $arenateamstats_data[2] - $arenateamstats_data[3];
if ($arenateamstats_data[2]) {
$winperc_week = round(10000 * $arenateamstats_data[3] / $arenateamstats_data[2]) / 100;
} else {
$winperc_week = $arenateamstats_data[2];
}
$losses_season = $arenateamstats_data[4] - $arenateamstats_data[5];
if ($arenateamstats_data[4]) {
$winperc_season = round(10000 * $arenateamstats_data[5] / $arenateamstats_data[4]) / 100;
} else {
$winperc_season = $arenateamstats_data[4];
}
$output .= "\r\n <script type=\"text/javascript\">\r\n answerbox.btn_ok='{$lang_global['yes_low']}';\r\n answerbox.btn_cancel='{$lang_global['no']}';\r\n </script>\r\n <center>\r\n <fieldset>\r\n <legend>{$lang_arenateam['arenateam']} ({$arenateam_data[2]}v{$arenateam_data[2]})</legend>\r\n <table class=\"lined\" style=\"width: 100%;\">\r\n <tr class=\"bold\">\r\n <td colspan=\"" . ($showcountryflag ? 14 : 13) . "\">" . htmlentities($arenateam_data[1]) . "</td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"" . ($showcountryflag ? 14 : 13) . "\">{$lang_arenateam['tot_members']}: {$total_members}</td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"4\">{$lang_arenateam['this_week']}</td>\r\n <td colspan=\"2\">{$lang_arenateam['games_played']} : {$arenateamstats_data['2']}</td>\r\n <td colspan=\"2\">{$lang_arenateam['games_won']} : {$arenateamstats_data['3']}</td>\r\n <td colspan=\"2\">{$lang_arenateam['games_lost']} : {$losses_week}</td>\r\n <td colspan=\"" . ($showcountryflag ? 4 : 3) . "\">{$lang_arenateam['ratio']} : {$winperc_week} %</td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"4\">{$lang_arenateam['this_season']}</td>\r\n <td colspan=\"2\">{$lang_arenateam['games_played']} : {$arenateamstats_data['4']}</td>\r\n <td colspan=\"2\">{$lang_arenateam['games_won']} : {$arenateamstats_data['5']}</td>\r\n <td colspan=\"2\">{$lang_arenateam['games_lost']} : {$losses_season}</td>\r\n <td colspan=\"" . ($showcountryflag ? 4 : 3) . "\">{$lang_arenateam['ratio']} : {$winperc_season} %</td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"" . ($showcountryflag ? 14 : 13) . "\">{$lang_arenateam['standings']} {$arenateamstats_data[6]} ({$arenateamstats_data[1]})</td>\r\n </tr>\r\n <tr>\r\n <th width=\"1%\">{$lang_arenateam['remove']}</th>\r\n <th width=\"1%\">{$lang_arenateam['name']}</th>\r\n <th width=\"1%\">Race</th>\r\n <th width=\"1%\">Class</th>\r\n <th width=\"1%\">Personal Rating</th>\r\n <th width=\"1%\">Last Login (Days)</th>\r\n <th width=\"1%\">Online</th>\r\n <th width=\"1%\">{$lang_arenateam['played_week']}</th>\r\n <th width=\"1%\">{$lang_arenateam['wons_week']}</th>\r\n <th width=\"1%\">Win %</th>\r\n <th width=\"1%\">{$lang_arenateam['played_season']}</th>\r\n <th width=\"1%\">{$lang_arenateam['wons_season']}</th>\r\n <th width=\"1%\">Win %</th>";
if ($showcountryflag) {
require_once 'libs/misc_lib.php';
$sqlr = new SQL();
$sqlr->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
$sqlm = new SQL();
$sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);
$output .= "\r\n <th width=\"1%\">{$lang_global['country']}</th>";
}
$output .= "\r\n </tr>";
while ($member = $sqlc->fetch_row($members)) {
$accid = $member[11];
$output .= "\r\n <tr>";
if ($user_lvl >= $action_permission['delete'] || $accid == $user_id) {
$output .= "\r\n <td><img src=\"img/aff_cross.png\" alt=\"\" onclick=\"answerBox('{$lang_global['delete']}: <font color=white>{$member[1]}</font><br />{$lang_global['are_you_sure']}', 'arenateam.php?action=rem_char_from_team&id={$member['0']}&arenateam_id={$arenateam_id}');\" style=\"cursor:pointer;\" /></td>";
} else {
$output .= "\r\n <td> </td>";
}
if ($member[4]) {
$ww_pct = round(10000 * $member[5] / $member[4]) / 100;
} else {
$ww_pct = $member[4];
}
if ($member[6]) {
$ws_pct = round(10000 * $member[7] / $member[6]) / 100;
} else {
$ws_pct = $member[6];
}
$output .= "\r\n <td><a href=\"char.php?id={$member['0']}\">" . htmlentities($member[1]) . "</a></td>\r\n <td><img src='img/c_icons/{$member[8]}-{$member[13]}.gif' onmousemove='toolTip(\"" . char_get_race_name($member[8]) . "\",\"item_tooltip\")' onmouseout='toolTip()' /></td>\r\n <td><img src='img/c_icons/{$member[9]}.gif' onmousemove='toolTip(\"" . char_get_class_name($member[9]) . "\",\"item_tooltip\")' onmouseout='toolTip()' /></td>\r\n <td>{$member['2']}</td>\r\n <td>" . get_days_with_color($member[12]) . "</td>\r\n <td>" . ($member[10] ? "<img src=\"img/up.gif\" alt=\"\" />" : "-") . "</td>\r\n <td>{$member['4']}</td>\r\n <td>{$member['5']}</td>\r\n <td>{$ww_pct} %</td>\r\n <td>{$member['6']}</td>\r\n <td>{$member['7']}</td>\r\n <td>{$ws_pct} %</td>";
if ($showcountryflag) {
$country = misc_get_country_by_account($member[14], $sqlr, $sqlm);
$output .= "\r\n <td>" . ($country['code'] ? "<img src='img/flags/" . $country['code'] . ".png' onmousemove='toolTip(\"" . $country['country'] . "\",\"item_tooltip\")' onmouseout='toolTip()' alt=\"\" />" : "-") . "</td>";
}
$output .= "\r\n </tr>";
}
$output .= "\r\n </table>\r\n <br />\r\n <table class=\"hidden\">\r\n <tr>\r\n <td>";
if ($user_lvl >= $action_permission['delete']) {
makebutton($lang_arenateam['del_team'], "arenateam.php?action=del_team&id={$arenateam_id}\" type=\"wrn", 180);
$output .= "\r\n </td>\r\n <td>";
makebutton($lang_arenateam['arenateams'], "arenateam.php\" type=\"def", 130);
$output .= "\r\n </td>\r\n </tr>\r\n <tr>\r\n </tr>";
} else {
makebutton($lang_arenateam['arenateams'], "arenateam.php", 130);
$output .= "\r\n </td>\r\n </tr>";
}
$output .= "\r\n </table>\r\n </fieldset>\r\n </center>";
}
