Line 1... |
Line 1... |
1 |
<?php
|
1 |
<?php
|
2 |
//gestion de la langue
|
2 |
//gestion de la langue
|
3 |
if (is_file("../lib/langues.php"))
|
3 |
if (is_file("../lib/langues.php"))
|
4 |
include("../lib/langues.php");
|
4 |
include("../lib/langues.php");
|
5 |
require('/etc/freeradius-web/config.php');
|
5 |
require('/etc/freeradius-web/config.php');
|
- |
|
6 |
if(!isset($clear_sessions)) $clear_sessions = 0;
|
6 |
if (is_file("../lib/$config[general_lib_type]/user_info.php"))
|
7 |
if (is_file("../lib/$config[general_lib_type]/user_info.php"))
|
7 |
include("../lib/$config[general_lib_type]/user_info.php");
|
8 |
include("../lib/$config[general_lib_type]/user_info.php");
|
8 |
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
|
9 |
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
|
9 |
include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
|
10 |
include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
|
10 |
else{
|
11 |
else{
|
Line 30... |
Line 31... |
30 |
<link rel="stylesheet" href="/css/style.css">
|
31 |
<link rel="stylesheet" href="/css/style.css">
|
31 |
</head>
|
32 |
</head>
|
32 |
<body>
|
33 |
<body>
|
33 |
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
|
34 |
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
|
34 |
<tr><th>$l_users_managment</th></tr>
|
35 |
<tr><th>$l_users_managment</th></tr>
|
35 |
<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1"
|
36 |
<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1"
|
36 |
height="2"></td></tr>
|
37 |
height="2"></td></tr>
|
37 |
</TABLE>
|
38 |
</TABLE>
|
38 |
<TABLE width="100%" border=0 cellspacing=0 cellpadding=1>
|
39 |
<TABLE width="100%" border=0 cellspacing=0 cellpadding=1>
|
39 |
<tr bgcolor="#666666"><td>
|
40 |
<tr bgcolor="#666666"><td>
|
40 |
<TABLE width="100%" border=0 cellspacing=0 cellpadding=2>
|
41 |
<TABLE width="100%" border=0 cellspacing=0 cellpadding=2>
|
Line 61... |
Line 62... |
61 |
</td></tr>
|
62 |
</td></tr>
|
62 |
<tr bgcolor="black" valign=top><td colspan=2>
|
63 |
<tr bgcolor="black" valign=top><td colspan=2>
|
63 |
<table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>
|
64 |
<table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>
|
64 |
<tr><td>
|
65 |
<tr><td>
|
65 |
EOM;
|
66 |
EOM;
|
66 |
|
67 |
|
67 |
if ($clear_sessions == 1)
|
68 |
if ($clear_sessions == 1)
|
68 |
{
|
69 |
{
|
69 |
# close active sessions
|
70 |
# close active sessions
|
70 |
exec ("sudo /usr/local/sbin/alcasar-logout.sh $login");
|
71 |
exec ("sudo /usr/local/sbin/alcasar-logout.sh $login");
|
71 |
# delete open accounting sessions
|
72 |
# delete open accounting sessions
|
72 |
$now = time();
|
73 |
$now = time();
|
73 |
$today_now = date("Y-m-d H:i:s",$now);
|
74 |
$today_now = date("Y-m-d H:i:s",$now);
|
74 |
$link = @da_sql_pconnect($config);
|
75 |
$link = da_sql_pconnect($config);
|
75 |
if ($link)
|
76 |
if ($link)
|
76 |
{
|
77 |
{
|
77 |
$res = @da_sql_query($link,$config,
|
78 |
$res = da_sql_query($link,$config,
|
78 |
"UPDATE $config[sql_accounting_table] SET acctstoptime = '$today_now', acctterminatecause='Admin-Reset'
|
79 |
"UPDATE $config[sql_accounting_table] SET acctstoptime = '$today_now', acctterminatecause='Admin-Reset'
|
79 |
WHERE username='$login' AND acctstoptime IS NULL;");
|
80 |
WHERE username='$login' AND acctstoptime IS NULL;");
|
80 |
if (! $res)
|
81 |
if (! $res)
|
81 |
echo "<b>Error deleting open sessions for user" . da_sql_error($link,$config) . "</b><br>\n";
|
82 |
echo "<b>Error deleting open sessions for user" . da_sql_error($link,$config) . "</b><br>\n";
|
82 |
}
|
83 |
}
|
83 |
else
|
84 |
else
|
84 |
echo "<b>Could not connect to SQL database</b><br>\n";
|
85 |
echo "<b>Could not connect to SQL database</b><br>\n";
|
85 |
}
|
86 |
}
|
86 |
# Count of accounting open sessions (in database)
|
87 |
# Count of accounting open sessions (in database)
|
87 |
$open_accnt_sessions = 0;
|
88 |
$open_accnt_sessions = 0;
|
88 |
$link = @da_sql_pconnect($config);
|
89 |
$link = da_sql_pconnect($config);
|
89 |
if ($link){
|
90 |
if ($link){
|
90 |
$search = @da_sql_query($link,$config,
|
91 |
$search = da_sql_query($link,$config,
|
91 |
"SELECT COUNT(*) AS counter FROM $config[sql_accounting_table]
|
92 |
"SELECT COUNT(*) AS counter FROM $config[sql_accounting_table]
|
92 |
WHERE username = '$login' AND acctstoptime IS NULL;");
|
93 |
WHERE username = '$login' AND acctstoptime IS NULL;");
|
93 |
if ($search){
|
94 |
if ($search){
|
94 |
if ($row = @da_sql_fetch_array($search,$config))
|
95 |
if ($row = da_sql_fetch_array($search,$config))
|
95 |
$open_accnt_sessions = $row['counter'];
|
96 |
$open_accnt_sessions = $row['counter'];
|
96 |
}
|
97 |
}
|
97 |
else
|
98 |
else
|
98 |
echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
|
99 |
echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
|
99 |
}
|
100 |
}
|