EOM; } if ($config[general_decode_normal_attributes] == 'yes'){ if (is_file("../lib/lang/$config[general_prefered_lang]/utf8.php3")) include_once("../lib/lang/$config[general_prefered_lang]/utf8.php3"); else include_once('../lib/lang/default/utf8.php3'); $k = init_decoder(); $decode_normal = 1; } require('../lib/functions.php3'); require("../lib/$config[general_lib_type]/functions.php3"); if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php3")) include_once("../lib/sql/drivers/$config[sql_type]/functions.php3"); else{ echo <<
Could not include SQL library functions. Aborting EOM; exit(); } $date = strftime('%A, %e %B %Y, %T %Z'); $sql_extra_query = ''; if ($config[sql_accounting_extra_query] != '') $sql_extra_query = sql_xlat($config[sql_accounting_extra_query],$login,$config); $link = @da_sql_pconnect($config); $link2 = connect2db($config); $tot_in = $tot_rem = 0; if ($link){ $h = 21; $servers_num = 0; foreach($nas_list as $nas){ $num = 0; if ($server != ''){ if ($nas[name] == $server) $servers_num++; else continue; } else $servers_num++; $name_data = $nas[ip]; $community_data = $nas[community]; $server_name[$servers_num] = $nas[name]; $server_model[$servers_num] = $nas[model]; if ($config[general_ld_library_path] != '') putenv("LD_LIBRARY_PATH=$config[general_ld_library_path]"); $extra = ""; if ($config[$finger_type] != 'database' && $config[general_finger_type] == 'snmp'){ if ($config[$nas_type] == '') $nas_type = $config[general_nas_type]; else $nas_type = $nas[type]; if ($nas_type == '') $nas_type = 'cisco'; $users=exec("$config[general_snmpfinger_bin] $name_data $community_data $nas_type"); if (strlen($users)) $extra = "AND username IN ($users)"; } $search = @da_sql_query($link,$config, "SELECT DISTINCT username,acctstarttime,framedipaddress,callingstationid FROM $config[sql_accounting_table] WHERE acctstoptime IS NULL AND nasipaddress = '$name_data' $extra $sql_extra_query GROUP BY username ORDER BY acctstarttime;"); if ($search){ $now = time(); while($row = @da_sql_fetch_array($search,$config)){ $num++; $h += 21; $user = $row['username']; $finger_info[$servers_num][$num]['ip'] = $row['framedipaddress']; if ($finger_info[$servers_num][$num]['ip'] == '') $finger_info[$servers_num][$num]['ip'] = '-'; $session_time = $row['acctstarttime']; $session_time = date2timediv($session_time,$now); $finger_info[$servers_num][$num]['session_time'] = time2strclock($session_time); $finger_info[$servers_num][$num]['user'] = $user; $finger_info[$servers_num][$num]['callerid'] = $row['callingstationid']; if ($finger_info[$servers_num][$num]['callerid'] == '') $finger_info[$servers_num][$num]['callerid'] = '-'; if ($user_info["$user"] == ''){ $user_info["$user"] = get_user_info($link2,$user,$config,$decode_normal,$k); if ($user_info["$user"] == '' || $user_info["$user"] == ' ') $user_info["$user"] = 'Unknown User'; } } $height[$servers_num] = $h; } $server_loggedin[$servers_num] = $num; $server_rem[$servers_num] = ($config[$portnum]) ? ($config[$portnum] - $num) : 'unknown'; $tot_in += $num; if (is_numeric($server_rem[$servers_num])) $tot_rem += $server_rem[$servers_num]; } } else echo "Could not connect to SQL database
\n"; if (isset($usage_summary)){ echo "Online: $tot_in Free: $tot_rem\n"; exit(); } ?>

Online Users 
$date EOM; for($j = 1; $j <= $servers_num; $j++){ echo <<
$server_name[$j]
$server_model[$j]
$server_loggedin[$j] users connected$server_rem[$j] $config[general_caption_finger_free_lines]
EOM; if ($acct_attrs['uf'][4] != '') echo "\n"; if ($acct_attrs['uf'][9] != '') echo "\n"; echo <<name EOM; for( $k = 1; $k <= $server_loggedin[$j]; $k++){ $user = $finger_info[$j][$k][user]; if ($user == '') $user = ' '; $time = $finger_info[$j][$k][session_time]; $ip = $finger_info[$j][$k][ip]; $cid = $finger_info[$j][$k][callerid]; $inf = $user_info[$user]; echo << EOM; if ($acct_attrs['uf'][4] != '') echo "\n"; if ($acct_attrs['uf'][9] != '') echo "\n"; echo <<$inf EOM; } echo << EOM; } ?>
#user" . $acct_attrs[uf][4] . "" . $acct_attrs[uf][9] . "duration
$k$user$ip$cid$time