'.(($action) ? $lang_stat['on_statistics'] : $lang_stat['srv_statistics']).'

'; unset($horde_chars); unset($horde_pros); unset($allies_chars); unset($allies_pros); $order_race = (isset($_GET['race'])) ? 'AND race ='.$sqlc->quote_smart($_GET['race']) : ''; $order_class = (isset($_GET['class'])) ? 'AND class ='.$sqlc->quote_smart($_GET['class']) : ''; if(isset($_GET['level'])) { $lvl_min = $sqlc->quote_smart($_GET['level']); $lvl_max = $lvl_min + 4; $order_level = 'AND level >= '.$lvl_min.' AND level <= '.$lvl_max.''; } else $order_level = ''; if(isset($_GET['side'])) { if ('h' == $sqlc->quote_smart($_GET['side'])) $order_side = 'AND race IN(2,5,6,8,10)'; elseif ('a' == $sqlc->quote_smart($_GET['side'])) $order_side = 'AND race IN (1,3,4,7,11)'; } else $order_side = ''; // RACE foreach ($race as $id) { $race[$id[0]][2] = $sqlc->result($sqlc->query('SELECT count(guid) FROM characters WHERE race = '.$id[0].' '.$order_class.' '.$order_level.' '.$order_side.(($action) ? ' AND online= 1' : '')), 0); $race[$id[0]][3] = round((($race[$id[0]][2])*100)/$total_chars,1); } $output .= ' '; // RACE END // CLASS foreach ($class as $id) { $class[$id[0]][2] = $sqlc->result($sqlc->query('SELECT count(guid) FROM characters WHERE class = '.$id[0].' '.$order_race.' '.$order_level.' '.$order_side.(($action) ? ' AND online= 1' : '')), 0); $class[$id[0]][3] = round((($class[$id[0]][2])*100)/$total_chars,1); } unset($order_level); $output .= ' '; // CLASS END // LEVEL foreach ($level as $id) { $level[$id[0]][3] = $sqlc->result($sqlc->query('SELECT count(guid) FROM characters WHERE level >= '.$id[1].' AND level <= '.$id[2].' '.$order_race.' '.$order_class.' '.$order_side.(($action) ? ' AND online= 1' : '').''), 0); $level[$id[0]][4] = round((($level[$id[0]][3])*100)/$total_chars,1); } unset($order_level); unset($order_class); unset($order_race); unset($total_chars); unset($order_side); $output .= '

'.$lang_stat['general_info'].'

'; if($action) $output .= ' '.$lang_index['tot_users_online'].' : '.$total_chars.'

'; else { $query = $sqlr->query('SELECT count(*) FROM account UNION SELECT count(*) FROM account WHERE gmlevel > 0'); $total_acc = $sqlr->result($query, 0); $total_gms = $sqlr->result($query, 1); unset($query); $data = date('Y-m-d H:i:s'); $data_1 = mktime(date('H'), date('i'), date('s'), date('m'), date('d')-1, date('Y')); $data_1 = date('Y-m-d H:i:s', $data_1); $uniqueIPs = $sqlr->result($sqlr->query('select distinct count(last_ip) from account where last_login > \''.$data_1.'\' and last_login < \''.$data.'\''), 0); unset($data_1); unset($data); $max_ever = $sqlr->result($sqlr->query('SELECT maxplayers FROM uptime WHERE realmid = '.$realm_id.' ORDER BY maxplayers DESC LIMIT 1'), 0); $max_restart = $sqlr->result($sqlr->query('SELECT maxplayers FROM uptime WHERE realmid = '.$realm_id.' ORDER BY starttime DESC LIMIT 1'), 0); $uptime = $sqlr->fetch_row($sqlr->query('SELECT AVG(uptime)/60, MAX(uptime)/60, ( 100*SUM(uptime)/( UNIX_TIMESTAMP()-MIN(starttime) ) ) FROM uptime WHERE realmid = '.$realm_id.'')); $output .= '

'.$lang_stat['uptime_prec'].': '.$lang_stat['avg_uptime'].': '.$lang_stat['max_uptime'].': '.$lang_stat['tot_accounts'].': '.$lang_stat['tot_chars_on_realm'].':	'.round($uptime[2],1).'% '.(int)($uptime[0]/60).':'.(int)(($uptime[0]%60)).'h '.(int)($uptime[1]/60).':'.(int)(($uptime[1]%60)).'h '.$total_acc.' '.$total_chars.'		'.$lang_stat['unique_ip'].': '.$lang_stat['max_players'].' : '.$lang_stat['max_ever'].' : '.$lang_stat['max_restart'].' :	'.$uniqueIPs.' '.$max_ever.' '.$max_restart.'
'.$lang_stat['average_of'].' '.round($total_chars/$total_acc,1).' '.$lang_stat['chars_per_acc'].' '.$lang_stat['total_of'].' '.$total_gms.' '.$lang_stat['gms_one_for'].' '.round($total_acc/$total_gms,1).' '.$lang_stat['players'].'

'; unset($uptime); unset($uniqueIPs); unset($max_restart); unset($max_ever); unset($total_gms); unset($total_acc); } //there is always less hordies $horde_chars = $sqlc->result($sqlc->query('SELECT count(guid) FROM characters WHERE race IN(2,5,6,8,10)'.(($action) ? ' AND online= 1' : '')), 0); $horde_pros = round(($horde_chars*100)/$total_chars ,1); $allies_chars = $total_chars - $horde_chars; $allies_pros = 100 - $horde_pros; $output .= '

'.$lang_stat['horde'].': '.$horde_chars.' ('.$horde_pros.'%)

'.$lang_stat['alliance'].': '.$allies_chars.' ('.$allies_pros.'%)

'.$lang_stat['chars_by_race'].'

'; foreach ($race as $id) { $height = ($race[$id[0]][3])*4; $output .= ' '; } $output .= ' '; foreach ($race as $id) { $output .= ' '; } unset($race); $output .= '

'.$race[$id[0]][1].' '.$race[$id[0]][2].'
'.$race[$id[0]][3].'%

'.$lang_stat['chars_by_class'].'

'; foreach ($class as $id) { $height = ($class[$id[0]][3])*4; $output .= ' '; } $output .= ' '; foreach ($class as $id) { $output .= ' '; } unset($class); $output .= '

'.$class[$id[0]][1].' '.$class[$id[0]][2].'
'.$class[$id[0]][3].'%

'.$lang_stat['chars_by_level'].'

'; foreach ($level as $id) { $height = ($level[$id[0]][4])*4; $output .= ' '; } unset($height); $output .= ' '; foreach ($level as $id) $output .= ' '; unset($id); unset($level); $output .= '

'.$level[$id[0]][1].'-'.$level[$id[0]][2].' '.$level[$id[0]][3].'
'.$level[$id[0]][4].'%

'; // LEVEL END makebutton($lang_stat['reset'], 'stat.php', 720); $output .= '