'; if (test_port($server[$realm_id]['addr'],$server[$realm_id]['game_port'])) { $stats = $sqlr->fetch_assoc($sqlr->query('SELECT starttime, maxplayers FROM uptime WHERE realmid = '.$realm_id.' ORDER BY starttime DESC LIMIT 1'), 0); $uptimetime = time() - $stats['starttime']; function format_uptime($seconds) { $secs = intval($seconds % 60); $mins = intval($seconds / 60 % 60); $hours = intval($seconds / 3600 % 24); $days = intval($seconds / 86400); $uptimeString=''; if ($days) { $uptimeString .= $days; $uptimeString .= ((1 === $days) ? ' day' : ' days'); } if ($hours) { $uptimeString .= ((0 < $days) ? ', ' : '').$hours; $uptimeString .= ((1 === $hours) ? ' hour' : ' hours'); } if ($mins) { $uptimeString .= ((0 < $days || 0 < $hours) ? ', ' : '').$mins; $uptimeString .= ((1 === $mins) ? ' minute' : ' minutes'); } if ($secs) { $uptimeString .= ((0 < $days || 0 < $hours || 0 < $mins) ? ', ' : '').$secs; $uptimeString .= ((1 === $secs) ? ' second' : ' seconds'); } return $uptimeString; } $staticUptime = $lang_index['realm'].' '.htmlentities(get_realm_name($realm_id)).' '.$lang_index['online'].' for '.format_uptime($uptimetime); unset($uptimetime); $output .= '

'.$staticUptime.'
'.$lang_index['maxplayers'].': '.$stats['maxplayers'].'

'; unset($staticUptime); unset($stats); $online = true; } else { $output .= '

'.$lang_index['realm'].' '.htmlentities(get_realm_name($realm_id)).' '.$lang_index['offline_or_let_high'].'

'; $online = false; } $sqlw = new SQL; $sqlw->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']); // This retrieves the actual database version from the database itself, instead of hardcoding it into a string if ($server_type) { $version = $sqlw->fetch_assoc($sqlw->query('SELECT core_revision, db_version FROM version'), 0); $output .= ' '.$lang_index['trinity_rev'].' '.$version['core_revision'].' '.$lang_index['using_db'].' '.$version['db_version'].' '; } else { $version = $sqlw->fetch_assoc($sqlw->query('SELECT version FROM db_version')); $output .= ' Mangos: '.$server[$realm_id]['rev'].' '.$lang_index['using_db'].' '.$version['version'].' '; } unset($version); //MOTD part $start_m = (isset($_GET['start_m'])) ? $sqlc->quote_smart($_GET['start_m']) : 0; if (is_numeric($start_m)); else $start_m = 0; $all_record_m = $sqlc->result($sqlc->query('SELECT count(*) FROM bugreport'), 0); if ($user_lvl >= $action_permission['delete']) $output .= ' '; $output .= '
'; if($all_record_m) { $result = $sqlc->query('SELECT id, type, content FROM bugreport ORDER BY id DESC LIMIT '.$start_m.', 3'); while($post = $sqlc->fetch_assoc($result)) { $output .= ' '; } if ($online) $output .= '%%REPLACE_TAG%%'; else $output .= ' '; } $output .= '
'; if ($user_lvl >= $action_permission['insert']) $output .= ' '.$lang_index['add_motd'].''; $output .= '
'.bbcode_bbc2html($post['content']).'
'; ($motd_display_poster) ? $output .= $post['type'] : ''; if ($user_lvl >= $action_permission['delete']) $output .= ' '; if ($user_lvl >= $action_permission['update']) $output .= ' '; $output .= '
'; //print online chars if ($online) { //==========================$_GET and SECURE================================= $start = (isset($_GET['start'])) ? $sqlc->quote_smart($_GET['start']) : 0; if (is_numeric($start)); else $start = 0; $order_by = (isset($_GET['order_by'])) ? $sqlc->quote_smart($_GET['order_by']) : 'name'; if (preg_match('/^[_[:lower:]]{1,12}$/', $order_by)); else $order_by = 'name'; $dir = (isset($_GET['dir'])) ? $sqlc->quote_smart($_GET['dir']) : 1; if (preg_match('/^[01]{1}$/', $dir)); else $dir = 1; $order_dir = ($dir) ? 'ASC' : 'DESC'; $dir = ($dir) ? 0 : 1; //==========================$_GET and SECURE end============================= if ($order_by === 'map') $order_by = 'map '.$order_dir.', zone'; elseif ($order_by === 'zone') $order_by = 'zone '.$order_dir.', map'; $order_side = ''; if( $user_lvl || $server[$realm_id]['both_factions']); else { $result = $sqlc->query('SELECT race FROM characters WHERE account = '.$user_id.' AND totaltime = (SELECT MAX(totaltime) FROM characters WHERE account = '.$user_id.') LIMIT 1'); if ($sqlc->num_rows($result)) $order_side = (in_array($sqlc->result($result, 0),array(2,5,6,8,10))) ? ' AND race IN (2,5,6,8,10) ' : ' AND race IN (1,3,4,7,11) '; } if($order_by == 'ip') $result = $sqlr->query('select id, last_ip from account where active_realm_id != 1 order by last_ip '.$order_dir.' LIMIT '.$start.', '.$itemperpage.''); else $result = $sqlc->query(' SELECT guid, name, race, class, zone, map, level, account, gender, 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_GUILD_ID+1).'), " ", -1) AS UNSIGNED) as gname '.($server_type ? ', latency ' : ' ').' FROM characters WHERE online= 1 '.($gm_online == '0' ? 'AND extra_flags &1 = 0 ' : '').$order_side.' ORDER BY '.$order_by.' '.$order_dir.' LIMIT '.$start.', '.$itemperpage.''); $total_online = $sqlc->result($sqlc->query('SELECT count(*) FROM characters WHERE online= 1'.(($gm_online_count == '0') ? ' AND extra_flags &1 = 0' : '')), 0); $replace = ' '.generate_pagination('index.php?start='.$start.'&order_by='.$order_by.'&dir='.(($dir) ? 0 : 1).'', $all_record_m, 3, $start_m, 'start_m').' '; unset($all_record_m); $output = str_replace('%%REPLACE_TAG%%', $replace, $output); unset($replace); $output .= ' '.$lang_index['tot_users_online'].': '.$total_online.' '; if ($server_type) $output .=' '; if ($showcountryflag) { require_once 'libs/misc_lib.php'; $output .= ' '; } $output .= ' '; if ($server_type) { $tlatency = 0; $latencycount = 0; } $sqlm = new SQL; $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); while ($char = $sqlc->fetch_assoc($result)) { if($order_by == 'ip') { $temp = $sqlc->fetch_assoc($sqlc->query(' SELECT guid, name, race, class, zone, map, level, account, gender, 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_GUILD_ID+1).'), " ", -1) AS UNSIGNED) as gname '.($server_type ? ', latency ' : ' ').' FROM characters WHERE online= 1 '.($gm_online == '0' ? 'AND extra_flags &1 = 0 ' : '').$order_side.' and account = '.$char['id'].'')); $char = $temp; } $gm = $sqlr->result($sqlr->query('SELECT gmlevel FROM account WHERE id='.$char['account'].''), 0); $guild_name = $sqlc->result($sqlc->query('SELECT name FROM guild WHERE guildid='.$char['gname'].'')); if ($server_type) { $lat = $char['latency']; if ('120' > $lat) $cc = ''; else if ('120' < $lat AND '350' > $lat) $cc = ''; else $cc = ''; if ($lat) $cc .= $lat; else $cc = 'Pending..'; $cc .= ' ms'; $tlatency = ($tlatency+$lat); $latencycount = ($latencycount+1); } $output .= ' '; if ($server_type) $output .=' '; if ($showcountryflag) { $country = misc_get_country_by_account($char['account'], $sqlr, $sqlm); $output .=' '; } $output .=' '; } $output .= ' '; if ($server_type) $output .= ' '; $output .= '
'.$lang_index['name'].' '.$lang_index['race'].' '.$lang_index['class'].' '.$lang_index['level'].' '.$lang_index['rank'].' '.$lang_index['guild'].' '.$lang_index['map'].' '.$lang_index['zone'].''.$lang_index['latency'].''.$lang_global['country'].'
'; if (($user_lvl >= $gm)) $output .= ' '.htmlentities($char['name']).' '; else $output .=' '.htmlentities($char['name']).''; $output .= ' '.char_get_level_color($char['level']).' '.htmlentities($guild_name).' '.get_map_name($char['map'], $sqlm).' '.get_zone_name($char['zone'], $sqlm).''.$cc.''.(($country['code']) ? '' : '-').'

'; } } //############################################################################# // MAIN //############################################################################# //$action = (isset($_GET['action'])) ? $_GET['action'] : NULL; $lang_index = lang_index(); front($sqlr, $sqlc); //unset($action); unset($action_permission); unset($lang_index); require_once 'footer.php'; ?>