connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); $start = (isset($_GET['start'])) ? $sql->quote_smart($_GET['start']) : 0; $order_by = (isset($_GET['order_by'])) ? $sql->quote_smart($_GET['order_by']) :"honor"; $query = $sql->query("SELECT guid, name, race, class, CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS honor , CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_KILL+1)."), ' ', -1) AS UNSIGNED) AS kills, level, CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_ARENA_POINTS+1)."), ' ', -1) AS UNSIGNED) AS arena, CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) as GNAME, gender FROM `characters` where race in (1,3,4,7,11) ORDER BY $order_by DESC LIMIT 25;"); $this_page = $sql->num_rows($query); $output .= "

"; while ($char = $sql->fetch_row($query)) { $guild_name = $sql->fetch_row($sql->query("SELECT `name` FROM `guild` WHERE `guildid`=".$char[8].";")); $output .= " "; } $output .= "

{$lang_honor['allied']} {$lang_honor ['browse_honor']}
{$lang_honor['guid']}	{$lang_honor['race']}	{$lang_honor['class']}	{$lang_honor['level']}	{$lang_honor['honor']}	{$lang_honor['honor points']}	Kills	AP	{$lang_honor['guild']}
".htmlentities($char[1])."			".char_get_level_color($char[6])."		$char[4]	$char[5]	$char[7]	".htmlentities($guild_name[0])."

"; $query = $sql->query("SELECT guid,name,race,class, CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS honor , CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_KILL+1)."), ' ', -1) AS UNSIGNED) AS kills, level, CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_ARENA_POINTS+1)."), ' ', -1) AS UNSIGNED) AS arena, CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) as GNAME, gender FROM `characters` where race not in (1,3,4,7,11) ORDER BY $order_by DESC LIMIT 25;"); $this_page = $sql->num_rows($query); $output .= "

"; while ($char = $sql->fetch_row($query)) { $guild_name = $sql->fetch_row($sql->query("SELECT `name` FROM `guild` WHERE `guildid`=".$char[8].";")); $output .= " "; } $output .= "

{$lang_honor['horde']} {$lang_honor ['browse_honor']}
{$lang_honor['guid']}	{$lang_honor['race']}	{$lang_honor['class']}	{$lang_honor['level']}	{$lang_honor['honor']}	{$lang_honor['honor points']}	Kills	AP	{$lang_honor['guild']}
".htmlentities($char[1])."			".char_get_level_color($char[6])."		$char[4]	$char[5]	$char[7]	".htmlentities($guild_name[0])."

"; require_once("footer.php"); ?>