}
}
$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}";
