} } $search = @da_sql_query($link, $config, "SELECT DISTINCT username,acctstarttime,framedipaddress,callingstationid\n\t\tFROM {$config['sql_accounting_table']} WHERE\n\t\tacctstoptime IS NULL AND nasipaddress = '{$name_data}' {$extra} {$sql_extra_query}\n\t\tGROUP BY username,acctstarttime,framedipaddress,callingstationid\n\t\tORDER BY acctstarttime;"); if ($search) { $now = time(); while ($row = @da_sql_fetch_array($search, $config)) { $j++; $h += 21; $user = $row['username']; $finger_info[$servers_num][$j]['ip'] = $row['framedipaddress']; if ($finger_info[$servers_num][$j]['ip'] == '') { $finger_info[$servers_num][$j]['ip'] = '-'; } $session_time = $row['acctstarttime']; $session_time = date2timediv($session_time, $now); $finger_info[$servers_num][$j]['session_time'] = time2strclock($session_time); $finger_info[$servers_num][$j]['user'] = $user; $finger_info[$servers_num][$j]['callerid'] = $row['callingstationid']; if ($finger_info[$servers_num][$j]['callerid'] == '') { $finger_info[$servers_num][$j]['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_counting[$servers_num] = $j;
if (@da_sql_num_rows($search, $config)) { $logged_now = 1; $row = @da_sql_fetch_array($search, $config); $lastlog_time = $row['acctstarttime']; $lastlog_server_ip = $row['nasipaddress']; $lastlog_server_port = $row['nasportid']; $lastlog_session_time = date2timediv($lastlog_time, 0); if ($daily_limit != 'none') { $remaining = $remaining - $lastlog_session_time; if ($remaining < 0) { $remaining = 0; } $log_color = $remaining ? 'green' : 'red'; } $lastlog_session_time_jvs = 1000 * $lastlog_session_time; $lastlog_session_time = time2strclock($lastlog_session_time); $lastlog_client_ip = $row['framedipaddress']; $lastlog_server_name = @gethostbyaddr($lastlog_server_ip); $lastlog_client_name = @gethostbyaddr($lastlog_client_ip); $lastlog_callerid = $row['callingstationid']; if ($lastlog_callerid == '') { $lastlog_callerid = 'not available'; } $lastlog_input = $row['acctinputoctets']; if ($lastlog_input) { $lastlog_input = bytes2str($lastlog_input); } else { $lastlog_input = 'not available'; } $lastlog_output = $row['acctoutputoctets']; if ($lastlog_output) {
if ($row = @da_sql_fetch_array($search, $config)) { $weekly_used = time2strclock($row[sum_sess_time]); $weekly_conns = $row[counter]; } } $search = @da_sql_query($link, $config, "SELECT COUNT(*) AS counter,sum(acctsessiontime) AS sum_sess_time FROM {$config['sql_accounting_table']} WHERE\n\tusername = '******' AND acctstoptime >= '{$today} 00:00:00'\n\tAND acctstoptime <= '{$today} 23:59:59';"); if ($search) { if ($row = @da_sql_fetch_array($search, $config)) { $daily_used = time2strclock($row[sum_sess_time]); $daily_conns = $row[counter]; } } $search = @da_sql_query($link, $config, "SELECT COUNT(*) AS counter, unix_timestamp() - unix_timestamp(acctstarttime) as diff FROM\n\t{$config['sql_accounting_table']} WHERE acctstoptime is null AND username = '******'\n\tGROUP BY username;"); if ($search) { if ($row = @da_sql_fetch_array($search, $config)) { $open_conns = $row[counter]; $online_time = $row[diff]; $weekly_used += $online_time; $daily_used += $online_time; $daily_conns += $open_conns; $weekly_conns += $open_conns; $online_time = time2strclock($online_time); } } $weekly_used = time2strclock($weekly_used); $daily_used = time2strclock($daily_used); } foreach ($vars as $val) { echo "{$val}\n"; } echo "{$weekly_used}\n{$weekly_conns}\n{$daily_used}\n{$daily_conns}\n{$open_conns}\n{$online_time}";