source: beta/pages/online.php@ 373

<?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=online&amp;order=".$sort."&amp;dir=".$dir."\">".$show."</a>";
} 
echo "
Ve hře se právě nachází ".$server -> MangosOnline()." hráčů.
<table border=\"1\" width=\"555\">
  <tr>
    <th align=\"center\">Frakce</th>
    <th align=\"center\">".MakeLink("Nick","name")."</th>
    <th align=\"center\">".MakeLink("Rasa","race")."</th>
    <th align=\"center\">".MakeLink("Class","class")."</th>
    <th align=\"center\">".MakeLink("Lvl","level")."</th>
    <th align=\"center\">".MakeLink("Mapa","map")."</th>
    <th align=\"center\">".MakeLink("Honory","highest_rank")."<br />".MakeLink("Aréna body","arena_points")."</th>
  </tr>
";
  $db -> select_db("characters");
  $sql = $db -> query("SELECT guid,name,race,class,zone,map,
  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1499), ' ', -1) AS UNSIGNED) AS highest_rank,
  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) AS UNSIGNED) AS level,
  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1500), ' ', -1) AS UNSIGNED) AS arena_points,
  mid(lpad( hex( CAST(substring_index(substring_index(data,' ',37),' ',-1) as unsigned) ),8,'0'),4,1) AS gender
  FROM `characters` WHERE `online`= 1 ORDER BY `".$order_by."` $order_dir;");
while($row = $sql -> fetch_array())
{
  $aliance = array (1, 3, 4, 7, 11);
  $frakce = (in_array($row["race"],$aliance))?"<img src=\"imgs/inc/a.gif\">":"<img src=\"imgs/inc/h.gif\">";
  $gender = ($row["gender"] == 0)?"m":"f";
  echo "
    <tr>
      <td align=\"center\">".$frakce."</td>
      <td align=\"center\">".$row["name"]."</td>
      <td align=\"center\"><img src=\"imgs/icons/".$player -> GetPlayerRace($row["race"])."-".$gender.".gif\"></td>
      <td align=\"center\"><img src=\"imgs/icons/".$player -> GetPlayerClass($row["class"]).".gif\"></td>
      <td align=\"center\">".$row["level"]."</td>
      <td align=\"center\">".$server -> MapName($row["map"])."<br />(".$server -> ZoneName($row["zone"]).")</td>
      <td align=\"center\">".$row["highest_rank"]."<br />".$row["arena_points"]."</td>
    </tr>
  ";




}
echo "</table>";




?>