source: honor.php@ 392

<?php
  include('global.php');
  ShowHeader();

  echo('<h3>Nejlepší hráči:</h3><div align="center">');
  $Database->select_db('characters');

  $HonorRanks = array(
    array(1000, 'Vojín', 'Zvěd'),
    array(5000, 'Desátník', 'Bručoun'),
    array(10000, 'Seržant', 'Seržant'),
    array(15000, 'Velící seržant', 'Starší seržant'),
    array(20000, 'Major seržant', 'Nejvyšší seržant'),
    array(25000, 'Rytíř', 'Kamenný strážce'),
    array(30000, 'Rytíř poručík', 'Krvavý strážce'),
    array(35000, 'Rytíř kapitán', 'Legionář'),
    array(40000, 'Rytíř vůdce', 'Setník'),
    array(45000, 'Poručík velitel', 'Vůdce'),
    array(50000, 'Velitel', 'Poručík generál'),
    array(55000, 'Maršál', 'Generál'),
    array(60000, 'Polní maršál', 'Válečník'),
    array(65001, 'Nejvyšší maršál', 'Vrchní válečník'),
  );  
  
        if(!array_key_exists('order_by', $_SESSION)) $_SESSION['order_by'] = 'highest_rank';
        if(array_key_exists('order_by', $_GET)) $_SESSION['order_by'] = $Database->real_escape_string($_GET['order_by']);
        $order_by = $_SESSION['order_by'];

        if(!array_key_exists('dir', $_SESSION)) $_SESSION['dir'] = 1;
        if(array_key_exists('dir', $_GET)) $_SESSION['dir'] = $Database->real_escape_string($_GET['dir']);
        $dir = $_SESSION['dir'];
        $dir = ($dir) ? 0 : 1;
        $order_dir = ($dir) ? "ASC" : "DESC";
        
        $result = $Database->query("SELECT count(*) FROM `characters`");
        $Row = $result->fetch_array();
        $total_online = $Row[0];

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

        require_once("minimanager/scripts/defines.php");
        $result = $Database->query("SELECT guid,name,race,class,zone,map,
                        CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS highest_rank,
                        CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1).'), " ", -1) AS UNSIGNED) AS level,account
                        FROM `characters` WHERE 1 '.$order_side.' ORDER BY '.$order_by.' '.$order_dir.' LIMIT '.$Page*$PerPage.','.$PerPage);
       //echo($Database->error);

        require_once("minimanager/lang/english.php");
  $lang_index = array(
        // ----- INDEX.PHP -----
        'realm' => 'Realm',
        'online' => 'Online',
        'offline_or_let_height' => 'Offline or Latency too Height',
        'delete' => 'Delete',
        'tot_users_online' => 'Celkem postav',
        'name' => 'Jméno',
        'race' => 'Rasa',
        'class' => 'Třída',
        'level' => 'Úroveň',
        'map' => 'Mapa',
        'zone' => 'Zóna',
        'honor_kills' => 'Body cti',
  );
        
        $output = "<font class=\"bold\">{$lang_index['tot_users_online']}: $total_online</font><br />
        <table width=\"70%\" class=\"TableGuilda\" border=\"1\" cellspacing=\"0\" cellpadding=\"2\">
        <tr> 
        <th>Pořadí</th><th><a href=\"?order_by=name&amp;dir=$dir\">".($order_by=='name' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['name']}</a></th>
        <th><a href=\"?order_by=race&amp;dir=$dir\">".($order_by=='race' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['race']}</a></th>
        <th><a href=\"?order_by=class&amp;dir=$dir\">".($order_by=='class' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['class']}</a></th>
        <th><a href=\"?order_by=level&amp;dir=$dir\">".($order_by=='level' ? "<img src=\"images/online_player/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['level']}</a></th>
  
    <th colspan=\"2\"><a href=\"?order_by=highest_rank&amp;dir=$dir\">".($order_by=='highest_rank' ? "<img src=\"images/online_player//arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['honor_kills']}</a></th>
        </tr>";

        require_once("minimanager/scripts/id_tab.php");
        $Index = $Page*$PerPage;
        while($char = $result->fetch_row())
  {
    $zone = get_zone_name($char[4]);
    if($zone == ' ') $zone = '&nbsp;';
    $race = get_player_race($char[2]);
    if(($char[2] == 1) or ($char[2] == 3) or ($char[2] == 4) or ($char[2] == 7) or ($char[2] == 11))
    {
      $color = '#9090ff';
      $RankNameIndex = 1;
    } else 
    {
      $color = '#FF5050';
      $RankNameIndex = 2;
    }
    $RankIndex = 0;
    foreach($HonorRanks as $HonorRankIndex => $HonorRank)
    {
      if($char[6] > $HonorRank[0]) 
      {
        $RankIndex = $HonorRankIndex;
      }
    }
                $output .= '<tr><td>'.($Index+1).".</td>
                 <td style=\"color: ".$color.";\">$char[1]</td>
         <td><img src='images/online_player/{$char[2]}-0.gif' onmousemove='toolTip(\"".$race."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
                 <td><img src='images/online_player/{$char[3]}.gif' onmousemove='toolTip(\"".get_player_class($char[3])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
                 <td>$char[7]</td>
                 <td><img src=\"images/honor_ranks/rank".($RankIndex+1).".gif\" alt=\"".$HonorRanks[$RankIndex][$RankNameIndex]."\">&nbsp;".$HonorRanks[$RankIndex][$RankNameIndex]."</td><td>$char[6]</td>
         </tr>";
    $Index++;
        }
   $output .= "</table>";
   $output .= PagesList('?page=', $Page, $total_online, $PerPage);
   $output .= '</div>';
  echo($output);

  ShowFooter();
?>