Subversion Repositories ALCASAR

Rev

Rev 925 | Rev 1827 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 925 Rev 1805
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
}