WebSVN – ALCASAR – Diff – /web/acc/manager/htdocs/clear_opensessions.php


<?php
//gestion de la langue
if (is_file("../lib/langues.php"))
	include("../lib/langues.php");
require('/etc/freeradius-web/config.php');
if(!isset($clear_sessions)) $clear_sessions = 0;
if (is_file("../lib/$config[general_lib_type]/user_info.php"))
	include("../lib/$config[general_lib_type]/user_info.php");
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>Clear opensession</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();
}
 
echo <<<EOM
<html>
<head>
<title>Clear opensession</title>
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">
<link rel="stylesheet" href="/css/style.css">
</head>
<body>
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
	<tr><th>$l_users_managment</th></tr>
	<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1"
height="2"></td></tr>
</TABLE>
<TABLE width="100%" border=0 cellspacing=0 cellpadding=1>
	<tr bgcolor="#666666"><td>
	<TABLE width="100%" border=0 cellspacing=0 cellpadding=2>
		<tr><td valign="middle" align="left">
<center>
<table border=0 width=640 cellpadding=0 cellspacing=2>
EOM;
 
include("../html/user_toolbar.html.php");
 
print <<<EOM
</table>
 
<br>
<table border=0 width=620 cellpadding=1 cellspacing=1>
<tr valign=top>
<td width=400></td>
<td bgcolor="black">
	<table border=0 width=100% cellpadding=2 cellspacing=0>
	<tr bgcolor="#907030" align=right valign=top><th>
	<font color="white">$l_user : $login ($cn)</font>&nbsp;
	</th></tr>
	</table>
</td></tr>
<tr bgcolor="black" valign=top><td colspan=2>
	<table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>
	<tr><td>
EOM;
 
if ($clear_sessions == 1)
	{
# close active sessions
	exec ("sudo /usr/local/sbin/alcasar-logout.sh $login");
# delete open accounting sessions
	$now = time();
	$today_now = date("Y-m-d H:i:s",$now);
	$link = da_sql_pconnect($config);
	if ($link)
		{
		$res = da_sql_query($link,$config,
		"UPDATE $config[sql_accounting_table] SET acctstoptime = '$today_now', acctterminatecause='Admin-Reset'
		WHERE username='$login' AND acctstoptime IS NULL;");
		if (! $res)
			echo "<b>Error deleting open sessions for user" . da_sql_error($link,$config) . "</b><br>\n";
		}
	else
		echo "<b>Could not connect to SQL database</b><br>\n";
	}
# Count of accounting open sessions (in database)
$open_accnt_sessions = 0;
$link = da_sql_pconnect($config);
if ($link){
	$search = da_sql_query($link,$config,
	"SELECT COUNT(*) AS counter FROM $config[sql_accounting_table]
	WHERE username = '$login' AND acctstoptime IS NULL;");
	if ($search){
		if ($row = da_sql_fetch_array($search,$config))
			$open_accnt_sessions = $row['counter'];
	}
	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";
 
# Count of chilli open sessions (for coova-chilli)
$open_chilli_sessions = 0;
exec ("sudo /usr/sbin/chilli_query list|cut -d\" \" -f5,6|grep $login|grep ^1|wc -l" , $open_chilli_sessions);
 
?>
   <form method=post>
      <input type=hidden name=login value=<?php print $login ?>>
      <input type=hidden name=clear_sessions value="0">
	<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>
<tr>
<td align=center>
<?
if (($open_accnt_sessions == 0) && ($open_chilli_sessions[0] == 0))
	{
	echo "$l_no_open_session";
	}
else	{
	echo "<b>$open_chilli_sessions[0]</b> $l_opened_sessions<br><b>$open_accnt_sessions</b> $l_active_accounting<br>";
	echo "$l_want_to_close ";
	echo "<input type=submit class=button value=\"$l_yes_close\" OnClick=\"this.form.clear_sessions.value=1\">";
	}
?>
</form>
</td></tr></table>
</td></tr></table>
</TD></TR></TABLE>
</body>
</html>
 

Rev 925	Rev 1805
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{`
11	`echo <<<EOM`	12	`echo <<<EOM`
12	`<title>Clear opensession</title>`	13	`<title>Clear opensession</title>`
13	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`	14	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`
14	`<link rel="stylesheet" href="style.css">`	15	`<link rel="stylesheet" href="style.css">`
15	`</head>`	16	`</head>`
16	`<body>`	17	`<body>`
17	`<center>`	18	`<center>`
18	`<b>Could not include SQL library functions. Aborting</b>`	19	`<b>Could not include SQL library functions. Aborting</b>`
19	`</body>`	20	`</body>`
20	`</html>`	21	`</html>`
21	`EOM;`	22	`EOM;`
22	`exit();`	23	`exit();`
23	`}`	24	`}`
24		25
25	`echo <<<EOM`	26	`echo <<<EOM`
26	`<html>`	27	`<html>`
27	`<head>`	28	`<head>`
28	`<title>Clear opensession</title>`	29	`<title>Clear opensession</title>`
29	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`	30	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`
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>`
41	`<tr><td valign="middle" align="left">`	42	`<tr><td valign="middle" align="left">`
42	`<center>`	43	`<center>`
43	`<table border=0 width=640 cellpadding=0 cellspacing=2>`	44	`<table border=0 width=640 cellpadding=0 cellspacing=2>`
44	`EOM;`	45	`EOM;`
45		46
46	`include("../html/user_toolbar.html.php");`	47	`include("../html/user_toolbar.html.php");`
47		48
48	`print <<<EOM`	49	`print <<<EOM`
49	`</table>`	50	`</table>`
50		51
51	`<br>`	52	`<br>`
52	`<table border=0 width=620 cellpadding=1 cellspacing=1>`	53	`<table border=0 width=620 cellpadding=1 cellspacing=1>`
53	`<tr valign=top>`	54	`<tr valign=top>`
54	`<td width=400></td>`	55	`<td width=400></td>`
55	`<td bgcolor="black">`	56	`<td bgcolor="black">`
56	`<table border=0 width=100% cellpadding=2 cellspacing=0>`	57	`<table border=0 width=100% cellpadding=2 cellspacing=0>`
57	`<tr bgcolor="#907030" align=right valign=top><th>`	58	`<tr bgcolor="#907030" align=right valign=top><th>`
58	`<font color="white">$l_user : $login ($cn)</font> `	59	`<font color="white">$l_user : $login ($cn)</font> `
59	`</th></tr>`	60	`</th></tr>`
60	`</table>`	61	`</table>`
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	`}`
100	`else`	101	`else`
101	`echo "<b>Could not connect to SQL database</b><br>\n";`	102	`echo "<b>Could not connect to SQL database</b><br>\n";`
102		103
103	`# Count of chilli open sessions (for coova-chilli)`	104	`# Count of chilli open sessions (for coova-chilli)`
104	`$open_chilli_sessions = 0;`	105	`$open_chilli_sessions = 0;`
105	`exec ("sudo /usr/sbin/chilli_query list\|cut -d\" \" -f5,6\|grep $login\|grep ^1\|wc -l" , $open_chilli_sessions);`	106	`exec ("sudo /usr/sbin/chilli_query list\|cut -d\" \" -f5,6\|grep $login\|grep ^1\|wc -l" , $open_chilli_sessions);`
106		107
107	`?>`	108	`?>`
108	`<form method=post>`	109	`<form method=post>`
109	`<input type=hidden name=login value=<?php print $login ?>>`	110	`<input type=hidden name=login value=<?php print $login ?>>`
110	`<input type=hidden name=clear_sessions value="0">`	111	`<input type=hidden name=clear_sessions value="0">`
111	`<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>`	112	`<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>`
112	`<tr>`	113	`<tr>`
113	`<td align=center>`	114	`<td align=center>`
114	`<?`	115	`<?`
115	`if (($open_accnt_sessions == 0) && ($open_chilli_sessions[0] == 0))`	116	`if (($open_accnt_sessions == 0) && ($open_chilli_sessions[0] == 0))`
116	`{`	117	`{`
117	`echo "$l_no_open_session";`	118	`echo "$l_no_open_session";`
118	`}`	119	`}`
119	`else {`	120	`else {`
120	`echo "<b>$open_chilli_sessions[0]</b> $l_opened_sessions<br><b>$open_accnt_sessions</b> $l_active_accounting<br>";`	121	`echo "<b>$open_chilli_sessions[0]</b> $l_opened_sessions<br><b>$open_accnt_sessions</b> $l_active_accounting<br>";`
121	`echo "$l_want_to_close ";`	122	`echo "$l_want_to_close ";`
122	`echo "<input type=submit class=button value=\"$l_yes_close\" OnClick=\"this.form.clear_sessions.value=1\">";`	123	`echo "<input type=submit class=button value=\"$l_yes_close\" OnClick=\"this.form.clear_sessions.value=1\">";`
123	`}`	124	`}`
124	`?>`	125	`?>`
125	`</form>`	126	`</form>`
126	`</td></tr></table>`	127	`</td></tr></table>`
127	`</td></tr></table>`	128	`</td></tr></table>`
128	`</TD></TR></TABLE>`	129	`</TD></TR></TABLE>`
129	`</body>`	130	`</body>`
130	`</html>`	131	`</html>`
131		132

Subversion Repositories ALCASAR

(root)/web/acc/manager/htdocs/clear_opensessions.php – Rev 925 → 1805