'); $Database->select_db($Config['Mangos']['DatabaseCharacters']); $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 = "{$lang_index['tot_users_online']}: $total_online
"; require_once("minimanager/scripts/id_tab.php"); $Index = $Page*$PerPage; while($char = $result->fetch_row()) { $zone = get_zone_name($char[4]); if($zone == ' ') $zone = ' '; $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 .= '"; $Index++; } $output .= "

Pořadí	".($order_by=='name' ? " " : "")."{$lang_index['name']}	".($order_by=='race' ? " " : "")."{$lang_index['race']}	".($order_by=='class' ? " " : "")."{$lang_index['class']}	".($order_by=='level' ? " " : "")."{$lang_index['level']}	".($order_by=='highest_rank' ? " " : "")."{$lang_index['honor_kills']}
'.($Index+1).".	$char[1]			$char[7]	".$HonorRanks[$RankIndex][$RankNameIndex]."	$char[6]

"; $output .= PagesList('?page=', $Page, $total_online, $PerPage); $output .= '