Subversion Repositories ALCASAR

Rev

Rev 1805 | Rev 2347 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log

<?php
//gestion de la langue
$origine='user_new';
if (is_file("../lib/langues.php"))
        include("../lib/langues.php");
require('/etc/freeradius-web/config.php');
?>
<html>
<head>
<?php
require('../lib/functions.php');
require('../lib/defaults.php');
$date = strftime('%A, %e %B %Y, %T %Z');

if (is_file("../lib/$config[general_lib_type]/user_info.php")){
        include("../lib/$config[general_lib_type]/user_info.php");
        if ($user_exists == 'no'){
                echo <<<EOM
<title>User information page</title>
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">
<link rel="stylesheet" href="/css/style.css">
</head>
<body>
<center>
<form action="user_admin.php" method=get>
<b>User Name&nbsp;&nbsp;</b>
<input type="text" size=10 name="login" value="$login">
<b>&nbsp;&nbsp;does not exist</b><br>
<input type=submit class=button value="Show User">
</body>
</html>
EOM;
                exit();
        }
}

if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
        include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
else{
        echo <<<EOM
<title>User information page</title>
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">
<link rel="stylesheet" href="style.css">
</head>
<body>
<center>
<b>Could not include SQL library functions. Aborting</b>
</body>
</html>
EOM;
        exit();
}

if(isset($item_vals['Max-Monthly-Session'][0]) && $item_vals['Max-Monthly-Session'][0] != ''){
        $monthly_limit = $item_vals['Max-Monthly-Session'][0];
} else if (isset($default_vals['Max-Monthly-Session'][0])){
        $monthly_limit = $default_vals['Max-Monthly-Session'][0];
} else {
        $monthly_limit = '';
}
$monthly_limit = ($monthly_limit) ? $monthly_limit : $config['counter_default_monthly'];

if(isset($item_vals['Max-Weekly-Session'][0]) && $item_vals['Max-Weekly-Session'][0] != ''){
        $weekly_limit = $item_vals['Max-Weekly-Session'][0];
} else if (isset($default_vals['Max-Weekly-Session'][0])){
        $weekly_limit = $default_vals['Max-Weekly-Session'][0];
} else {
        $weekly_limit = '';
}
$weekly_limit = ($weekly_limit) ? $weekly_limit : $config['counter_default_weekly'];

if(isset($item_vals['Max-Daily-Session'][0]) && $item_vals['Max-Daily-Session'][0] != ''){
        $daily_limit = $item_vals['Max-Daily-Session'][0];
} else if (isset($default_vals['Max-Daily-Session'][0])){
        $daily_limit = $default_vals['Max-Daily-Session'][0];
} else {
        $daily_limit = '';
}
$daily_limit = ($daily_limit) ? $daily_limit : $config['counter_default_daily'];

if(isset($item_vals['Session-Timeout'][0]) && $item_vals['Session-Timeout'][0] != ''){
        $session_limit = $item_vals['Session-Timeout'][0];
} else if (isset($default_vals['Session-Timeout'][0])){
        $session_limit = $default_vals['Session-Timeout'][0];
} else {
        $session_limit = '';
}
$session_limit = ($session_limit) ? $session_limit : 'none';

if(isset($item_vals['Max-All-Session'][0]) && $item_vals['Max-All-Session'][0] != ''){
        $total_limit = $item_vals['Max-All-Session'][0];
} else if (isset($default_vals['Max-All-Session'][0])){
        $total_limit = $default_vals['Max-All-Session'][0];
} else {
        $total_limit = '';
}
$total_limit = ($total_limit) ? $total_limit : 'none';

$remaining = 'unlimited time';
$log_color = 'green';

$now = time();
$week = $now - 604800;
$now_str = date("$config[sql_date_format]",$now + 86400);
$week_str = date("$config[sql_date_format]",$week);
$day = date('w');
$week_start = date($config['sql_date_format'],$now - ($day)*86400);
$month_start = date($config['sql_date_format'],$now - date('j')*86400);
$today = $day;
$now_tmp = $now;
for ($i = $day; $i >-1; $i--){
        $days[$i] = date($config['sql_date_format'],$now_tmp);
        $now_tmp -= 86400;
}
$day++;
//$now -= ($day * 86400);
$now -= 604800;
$now += 86400;
for ($i = $day; $i <= 6; $i++){
        $days[$i] = date($config['sql_date_format'],$now);
//      $now -= 86400;
        $now += 86400;
}

$daily_used = $weekly_used = $monthly_used = $lastlog_session_time = '-';
$extra_msg = '';
$used = array('-','-','-','-','-','-','-');

$link = da_sql_pconnect($config);
if ($link){
        $search = da_sql_query($link,$config,
        "SELECT sum(acctsessiontime) AS sum_sess_time,
        sum(acctinputoctets) AS sum_in_octets,
        sum(acctoutputoctets) AS sum_out_octets,
        avg(acctsessiontime) AS avg_sess_time,
        avg(acctinputoctets) AS avg_in_octets,
        avg(acctoutputoctets) AS avg_out_octets,
        COUNT(*) as counter FROM
        $config[sql_accounting_table] WHERE username = '$login'
        AND acctstarttime >= '$week_str' AND acctstarttime <= '$now_str';");
        if ($search){
                $row = da_sql_fetch_array($search,$config);
                $tot_time = time2str($row['sum_sess_time']);
                $tot_input = bytes2str($row['sum_in_octets']);
                $tot_output = bytes2str($row['sum_out_octets']);
                $avg_time = time2str($row['avg_sess_time']);
                $avg_input = bytes2str($row['avg_in_octets']);
                $avg_output = bytes2str($row['avg_out_octets']);
                $tot_conns = $row['counter'];
        }
        else
                echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
        $search = da_sql_query($link,$config,
        "SELECT sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE username = '$login'
        AND acctstarttime >= '$week_start' AND acctstarttime <= '$now_str';");
        if ($search){
                $row = da_sql_fetch_array($search,$config);
                $weekly_used = $row['sum_sess_time'];
        }
        else
                echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
        if ($monthly_limit != 'none' || (isset($config['counter_monthly_calculate_usage']) && $config['counter_monthly_calculate_usage'] == 'true')){
                $search = da_sql_query($link,$config,
                "SELECT sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE username = '$login'
                AND acctstarttime >= '$month_start' AND acctstarttime <= '$now_str';");
                if ($search){
                        $row = da_sql_fetch_array($search,$config);
                        $monthly_used = $row['sum_sess_time'];
                }
                else
                        echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
        }
        $search = da_sql_query($link,$config,
        "SELECT COUNT(*) AS counter FROM $config[sql_accounting_table] WHERE username = '$login'
        AND acctstoptime >= '$week_str' AND acctstoptime <= '$now_str'
        AND (acctterminatecause LIKE 'Login-Incorrect%' OR
        acctterminatecause LIKE 'Invalid-User%' OR
        acctterminatecause LIKE 'Multiple-Logins%');");
        if ($search){
                $row = da_sql_fetch_array($search,$config);
                $tot_badlogins = $row['counter'];
        }
        else
                echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
        for($i = 0; $i <=6; $i++){
                if ($days[$i] == '')
                        continue;
                $search = da_sql_query($link,$config,
                "SELECT sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE
                username = '$login' AND acctstoptime >= '$days[$i] 00:00:00'
                AND acctstoptime <= '$days[$i] 23:59:59';");
                if ($search){
                        $row = da_sql_fetch_array($search,$config);
                        $used[$i] = $row['sum_sess_time'];
                        if ($daily_limit != 'none' && $used[$i] > $daily_limit)
                                $used[$i] = "<font color=red>" . time2str($used[$i]) . "</font>";
                        else
                                $used[$i] = time2str($used[$i]);
                        if ($today == $i){
                                $daily_used = $row['sum_sess_time'];
                                if ($daily_limit != 'none'){
                                        $remaining = $daily_limit - $daily_used;
                                        if ($remaining <=0)
                                                $remaining = 0;
                                        $log_color = ($remaining) ? 'green' : 'red';
                                        if (!$remaining)
                                                $extra_msg = '(Out of daily quota)';
                                }
                                $daily_used = time2str($daily_used);
                                if ($daily_limit != 'none' && !$remaining)
                                        $daily_used = "<font color=red>$daily_used</font>";
                        }
                }
                else
                        echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
        }
        if ($weekly_limit != 'none'){
                $tmp = $weekly_limit - $weekly_used;
                if ($tmp <=0){
                        $tmp = 0;
                        $extra_msg .= '(Out of weekly quota)';
                }
                if (!is_numeric($remaining))
                        $remaining = $tmp;
                if ($remaining > $tmp)
                        $remaining = $tmp;
                $log_color = ($remaining) ? 'green' : 'red';
        }
        $weekly_used = time2str($weekly_used);
        if ($weekly_limit != 'none' && !$tmp)
                $weekly_used = "<font color=red>$weekly_used</font>";

        if ($monthly_limit != 'none'){
                $tmp = $monthly_limit - $monthly_used;
                if ($tmp <=0){
                        $tmp = 0;
                        $extra_msg .= '(Out of monthly quota)';
                }
                if (!is_numeric($remaining))
                        $remaining = $tmp;
                if ($remaining > $tmp)
                        $remaining = $tmp;
                $log_color = ($remaining) ? 'green' : 'red';
        }
        if ($monthly_limit != 'none' || (isset($config['counter_monthly_calculate_usage']) && $config['counter_monthly_calculate_usage'] == 'true')){
                $monthly_used = time2str($monthly_used);
                if ($monthly_limit != 'none' && !$tmp)
                        $monthly_used = "<font color=red>$monthly_used</font>";
        }
        if ($session_limit != 'none'){
                if (!is_numeric($remaining))
                        $remaining = $session_limit;
                if ($remaining > $session_limit)
                        $remaining = $session_limit;
        }

        $search = da_sql_query($link,$config,
        "SELECT " . da_sql_limit(1,0,$config) . " * FROM $config[sql_accounting_table]
        WHERE username = '$login' AND acctstoptime IS NULL " . da_sql_limit(1,1,$config) . "
         ORDER BY acctstarttime DESC " . da_sql_limit(1,2,$config). " ;");
        if ($search){
                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)
                                $lastlog_output = bytes2str($lastlog_output);
                        else
                                $lastlog_output = 'not available';
                }
        }
        else
                echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
        if (!isset($logged_now) || !$logged_now){
                $search = da_sql_query($link,$config,
                "SELECT " . da_sql_limit(1,0,$config) . " * FROM $config[sql_accounting_table]
                WHERE username = '$login' AND acctsessiontime != '0' " . da_sql_limit(1,1,$config) . "
                 ORDER BY acctstoptime DESC " . da_sql_limit(1,2,$config). " ;");
                if ($search){
                        if (da_sql_num_rows($search,$config)){
                                $row = da_sql_fetch_array($search,$config);
                                $lastlog_time = $row['acctstarttime'];
                                $lastlog_server_ip = $row['nasipaddress'];
                                $lastlog_server_port = $row['nasportid'];
                                $lastlog_session_time = time2str($row['acctsessiontime']);
                                $lastlog_client_ip = $row['framedipaddress'];
                $lastlog_server_name = ($lastlog_server_ip != '') ? @gethostbyaddr($lastlog_server_ip) : '-';
                $lastlog_client_name = ($lastlog_client_ip != '') ? @gethostbyaddr($lastlog_client_ip) : '-';
                                $lastlog_callerid = $row['callingstationid'];
                                if ($lastlog_callerid == '')
                                        $lastlog_callerid = 'not available';
                                $lastlog_input = $row['acctinputoctets'];
                                $lastlog_input = bytes2str($lastlog_input);
                                $lastlog_output = $row['acctoutputoctets'];
                                $lastlog_output = bytes2str($lastlog_output);
                        }
                        else
                                $not_known = 1;
                }
                else
                        echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
        }
}
else
        echo "<b>Could not connect to SQL database</b><br>\n";

$monthly_limit = (is_numeric($monthly_limit)) ? time2str($monthly_limit) : $monthly_limit;
$weekly_limit = (is_numeric($weekly_limit)) ? time2str($weekly_limit) : $weekly_limit;
$daily_limit = (is_numeric($daily_limit)) ? time2str($daily_limit) : $daily_limit;
$session_limit = (is_numeric($session_limit)) ? time2str($session_limit) : $session_limit;
$total_limit = (is_numeric($total_limit)) ? time2str($total_limit) : $total_limit;
$remaining = (is_numeric($remaining)) ? time2str($remaining) : $remaining;

if (isset($item_vals['Dialup-Access'][0]) && $item_vals['Dialup-Access'][0] == 'FALSE' || (!isset($item_vals['Dialup-Access'][0]) && $attrmap['Dialup-Access'] != '' && $attrmap['Dialup-Access'] != 'none'))
        $msg =<<<EON
<font color=red><b> $l_locked_user </b></font>
EON;
else
        $msg =<<<EON
$l_user_remain_login<font color="$log_color"> <b>$remaining $extra_msg</b></font>
EON;
$lock_msg = (isset($item_vals['Dialup-Lock-Msg'][0])) ? $item_vals['Dialup-Lock-Msg'][0] : '';
if ($lock_msg != '')
        $descr =<<<EON
<font color=red><b>$lock_msg </b</font>
EON;
else
        $descr = '-';

$expiration = isset($default_vals['Expiration'][0]) ? $default_vals['Expiration'][0] : '';
if (isset($item_vals['Expiration'][0]))
        $expiration = $item_vals['Expiration'][0];

if ($expiration != ''){
        $expiration = strtotime($expiration);
        if ($expiration != -1 && $expiration < time())
                $descr = <<<EOM
<font color=red><b>$l_user_expired</b></font>
EOM;
}

require('../html/user_admin.html.php');
?>