<?php
require 'init.php';
$c->add('main');
$c->assign('menu', $menu->output);
$tp = new template();
$tp->add('team-info');
$r = $mysql->getRow("select arena_team.*,arena_team_stats.* from arena_team,arena_team_stats where arena_team_stats.arenateamid = arena_team.arenateamid and name = '?1' and type = ?2", $_GET['name'], (int) $_GET['type'], 'char');
if (!$r) {
$_SYSTEM->error("Arena Team not found.");
}
$tp->assign('name', $r['name']);
$tp->assign('type', $r['type']);
$rank = getArenaRank($r['arenateamid']);
$place = getPlace($rank[1]);
$tp->assign('rank', $rank[0]);
$tp->assign('place', $place);
$tp->assign('rank_border', $rank[2]);
$tp->assign('wg', $r['games']);
$tp->assign('ww', $r['wins']);
$tp->assign('wl', $r['games'] - $r['wins']);
$tp->assign('wp', $r['games'] ? round($r['wins'] / $r['games'] * 100) : 0);
$tp->assign('wr', $r['rating']);
$tp->assign('sg', $r['played']);
$tp->assign('sw', $r['wins2']);
$tp->assign('sl', $r['played'] - $r['wins2']);
$tp->assign('sp', $r['played'] ? round($r['wins2'] / $r['played'] * 100) : 0);
$icon = getSmallArenaIcon($r);
$tp->assign('icon', $icon);
$m = $mysql->getRows("select arena_team_member.*,characters.name,characters.race,characters.class,?3 as level,?4 as gender,guild.name as gname from arena_team_member inner join characters on arena_team_member.guid= characters.guid left join guild on guild.guildid = ?2 where arena_team_member.arenateamid = ?1", $r['arenateamid'], SQL_template(CHAR_GUILD_OFFSET), SQL_template(CHAR_LEVEL_OFFSET), CHAR_GENDER_OFFSET, 'char');
if ($m) {
$c->assign('menu', $menu->output);
$tp = new template();
$tp->add('character-empty');
$tabs = new template();
$tabs->add('character-global-tabs');
$tp->assign('tabs', '<script type="text/javascript">characterTab = \'character\';characterSubTab=\'arena\';</script>' . $tabs->output);
include 'sections/character.php';
$types = array(2, 3, 5);
foreach ($types as $type) {
$mems = array();
$members_list = '';
if (!$character->arena_team[$type]['name']) {
continue;
}
$team = $mysql->getRow("select arena_team.*,arena_team_stats.*\n\t\t\t\t\tfrom arena_team,arena_team_stats\n\t\t\t\t\twhere arena_team.arenateamid = arena_team_stats.arenateamid and arena_team.name = '?1'", $character->arena_team[$type]['name'], 'char');
$rank = getArenaRank($character->arena_team[$type]['arenateamid']);
$place = getPlace($rank[1]);
$members = $mysql->getRows("select arena_team_member.*,characters.name,characters.race from arena_team_member,characters where arena_team_member.arenateamid = ?1 and characters.guid = arena_team_member.guid", $team['arenateamid'], 'char');
if (!$members) {
continue;
}
foreach ($members as $mem) {
if ($mems[$mem['name']]) {
continue;
}
$mems[$mem['name']] = true;
$team_faction = character::getAlliance($mem['race']);
$members_list .= '<a href="character-sheet.php?Realm=' . $character->realm . '&name=' . $mem['name'] . '">' . $mem['name'] . '</a>, ';
if ($mem['name'] == $character->name) {
$me = $mem;
}
