source: branches/old/arena.php

<?php

include('global.php');
ShowHeader();
$Database->select_db('characters');
require_once("minimanager/lang/czech.php");
require_once("minimanager/scripts/defines.php");
require_once("minimanager/scripts/id_tab.php");

echo('<h3>Arénové týmy:</h3><div align="center">');
if(!array_key_exists('order_by2', $_SESSION)) $_SESSION['order_by2'] = 'rating';
if(array_key_exists('order_by', $_GET)) $_SESSION['order_by2'] = $Database->real_escape_string($_GET['order_by']);
$order_by = $_SESSION['order_by2'];

        if(!array_key_exists('dir2', $_SESSION)) $_SESSION['dir2'] = 1;
        if(array_key_exists('dir', $_GET)) $_SESSION['dir2'] = $Database->real_escape_string($_GET['dir']);
        $dir = $_SESSION['dir2'];
        $dir = ($dir) ? 0 : 1;
        $order_dir = ($dir) ? "ASC" : "DESC";

 $PerPage = 20;
 if(array_key_exists('page', $_GET)) $_SESSION['page2'] = $Database->real_escape_string($_GET['page']);
 if(array_key_exists('page', $_SESSION)) $Page = $_SESSION['page2']; else $Page = 0; 

 $itemperpage = 30;
 $DbResult = $Database->query("SELECT count(*) FROM arena_team");
 $Row = $DbResult->fetch_array();
 $all_record = $Row[0];

 $query = $Database->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 LIMIT ".($Page * $PerPage).",".$PerPage);
echo($Database->error);
 $this_page = $query->num_rows;

 $output = "<font class=\"bold\">Celkem týmů: $all_record</font><br />";
 $output .= "<table class=\"TableGuilda\" border=\"1\" cellspacing=\"0\" cellpadding=\"2\">
   <tr>
        <th width=\"22%\"><a href=\"?order_by=atname&amp;dir=$dir\">".($order_by=='atname' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['arenateam_name']}</a></th>
        <th width=\"10%\"><a href=\"?order_by=tot_chars&amp;dir=$dir\">".($order_by=='tot_chars' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['captain']}</a></th>
        <th width=\"7%\"><a href=\"?order_by=attype&amp;dir=$dir\">".($order_by=='attype' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['type']}</a></th>
        <th width=\"7%\"><a href=\"?order_by=membres&amp;dir=$dir\">".($order_by=='members' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['members']}</a></th>
        <th width=\"7%\"><a href=\"?order_by=rating&amp;dir=$dir\">".($order_by=='rating' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['rating']}</a></th>
        <th width=\"7%\"><a href=\"?order_by=games&amp;dir=$dir\">".($order_by=='games' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['games']}</a></th>
        <th width=\"7%\"><a href=\"?order_by=wins&amp;dir=$dir\">".($order_by=='wins' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['wins']}</a></th>
   </tr>";

while ($data = $query->fetch_assoc())
{
        $output .= "<tr>
                         <td>".$data['atname']."</td>
                         <td>".$data['l_name']."</td>
                         <td>".$lang_arenateam[$data['attype']]."</td>
                         <td>".$data['tot_chars']."</td>
                         <td>".$data['atrating']."</td>
                         <td>".$data['atgames']."</td>
                         <td>".$data['atwins']."</td>
            </tr>";
}

 $output .= "</table>".PagesList('?page=', $Page, $all_record, $PerPage)."</center>";
 echo($output);
 ShowFooter();

?>