source: trunk/pages/arena.php@ 560

<?php
// razeni
  $order_by = (isset($_GET["order"])) ? $db->real_escape_string($_GET["order"]) : "name";
  $dir = (isset($_GET["dir"])) ? $db->real_escape_string($_GET["dir"]) : "down";
  $order_dir = ($dir == "up") ? "ASC" : "DESC";
  $dir = ($dir == "down") ? "up" : "down";
  $dir_img = ($dir == "down") ? "<img src=\"imgs/inc/up.gif\">" : "<img src=\"imgs/inc/down.gif\">";
function MakeLink ($show,$sort)
{
  global $dir , $dir_img;
  if (isset($_GET["order"]) AND $_GET["order"] == $sort)
  {
    $arrow = $dir_img."";
  }
  else
  {
    $arrow = "";
  }
  return $arrow."<a href=\"?page=arena&amp;order=".$sort."&amp;dir=".$dir."\">".$show."</a>";
} 
include("inc/db.php");
$db -> select_db("$db_characters");
$count = $db -> query("SELECT count(*) FROM arena_team;") -> fetch_array();
$all_record = $count[0];
echo "
<center><h3>Arénové týmy :</h3></center>
Celkem týmů : <b>".$all_record."</b>
<center>
  <table border=\"1\" width=\"540\">
    <tr>
      <th>".MakeLink("Tým","atname")."</th>
      <th>Kapitán</th>
      <th>".MakeLink("Typ","attype")."</th>
      <th>".MakeLink("Členů","tot_chars")."</th>
      <th>".MakeLink("Rating","atrating")."</th>
      <th>".MakeLink("Her vyhráno","atwin")."</th>
      <th>".MakeLink("Her hráno","atgames")."</th>
    </tr>
"; 
$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_array())
  {
    echo "
      <tr>
        <td align=\"center\">".$row["atname"]."</td>
        <td align=\"center\">".$row["l_name"]."</td>
        <td align=\"center\">".$row["attype"]."</td>
        <td align=\"center\">".$row["tot_chars"]."</td>
        <td align=\"center\">".$row["atrating"]."</td>
        <td align=\"center\">".$row["atwins"]."</td>
        <td align=\"center\">".$row["atgames"]."</td>
      </tr>  
    ";
  }
echo "</table></center>";
?>