'); $Database->select_db($Config['Mangos']['DatabaseCharacters']); $order_by = (isset($_GET['order_by'])) ? $Database->real_escape_string($_GET['order_by']) : "name"; $dir = (isset($_GET['dir'])) ? $Database->real_escape_string($_GET['dir']) : 1; $order_dir = ($dir) ? "ASC" : "DESC"; $dir = ($dir) ? 0 : 1; $result = $Database->query("SELECT count(*) FROM `characters` WHERE `online`= 1"); $Row = $result->fetch_array(); $total_online = $Row[0]; $order_side = ""; 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 `online`= 1 $order_side ORDER BY $order_by $order_dir"); 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 hráčů online', '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"); 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'; else $color = '#FF5050'; $output .= ""; } $output .= "

".($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=='map' ? " " : "")."{$lang_index['map']}	{$lang_index['zone']}	".($order_by=='highest_rank' ? " " : "")."{$lang_index['honor_kills']}
$char[1]			$char[7]	".get_map_name($char[5])."	".$zone."	$char[6]