' : '
';
function MakeLink($show, $sort)
{
global $dir, $dir_img, $html;
if(isset($_GET['order']) and $_GET['order'] == $sort) $arrow = $dir_img;
else $arrow = '';
return($arrow.''.$show.'');
}
$Realm = new Realm($System, $_COOKIE['RealmIndex']);
$db = $Realm->CharactersDatabase;
$count = $db->query('SELECT COUNT(*) FROM arena_team')->fetch_row();
$all_record = $count[0];
echo('Arénové týmy :
');
echo('Celkem týmů : '.$all_record.'
| '.MakeLink('Tým', 'atname').' |
Kapitán |
'.MakeLink('Typ', 'attype').' |
'.MakeLink('Členů', 'tot_chars').' |
'.MakeLink('Rating', 'atrating').' |
'.MakeLink('Her vyhráno', 'atwins').' |
'.MakeLink('Her hráno', 'atgames').' |
');
$query = $db->query('SELECT arena_team.arenateamid AS atid, arena_team.name AS atname, arena_team.captainguid AS lguid, arena_team.type AS attype, (SELECT name FROM `characters` WHERE guid = lguid) AS l_name, (SELECT COUNT(*) FROM arena_team_member WHERE arenateamid = atid) AS tot_chars, rating AS atrating, games as atgames, wins as atwins FROM arena_team, arena_team_stats WHERE arena_team.arenateamid = arena_team_stats.arenateamid ORDER BY '.$order_by.' '.$order_dir);
while($row = $query->fetch_assoc())
{
echo('
| '.$row['atname'].' |
'.$row['l_name'].' |
'.$row['attype'].' |
'.$row['tot_chars'].' |
'.$row['atrating'].' |
'.$row['atwins'].' |
'.$row['atgames'].' |
');
}
echo('
');
?>