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