File: add_badusers.php3

package info (click to toggle)
freeradius 2.0.4%2Bdfsg-6
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 14,884 kB
  • ctags: 9,109
  • sloc: ansic: 73,328; sh: 12,392; php: 6,679; perl: 3,075; makefile: 1,316; sql: 1,197; python: 171; tcl: 35; sed: 23
file content (38 lines) | stat: -rw-r--r-- 1,196 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php3"))
	include_once("../lib/sql/drivers/$config[sql_type]/functions.php3");
else{
	echo "<b>Could not include SQL library</b><br>\n";
	exit();
}

$date=date($config[sql_full_date_format]);
$lockmsg_name = $attrmap['Dialup-Lock-Msg'] . '0';
$msg = $$lockmsg_name;
$admin = '-';
if ($_SERVER["PHP_AUTH_USER"] != '')
	$admin = $_SERVER["PHP_AUTH_USER"];
if ($msg == '')
	echo "<b>Lock Message should not be empty</b><br>\n";
else{
	$sql_servers = array();
	if ($config[sql_extra_servers] != '')
		$sql_servers = explode(' ',$config[sql_extra_servers]);
	$sql_servers[] = $config[sql_server];
	foreach ($sql_servers as $server){
		$link = @da_sql_host_connect($server,$config);
		if ($link){
			$r = da_sql_query($link,$config,
			"INSERT INTO $config[sql_badusers_table] (username,incidentdate,admin,reason)
			VALUES ('$login','$date','$admin','$msg');");
			if (!$r)
				echo "<b>SQL Error:" . da_sql_error($link,$config) . "</b><br>\n";
			else
				echo "<b>User added to badusers table</b><br>\n";
			da_sql_close($link,$config);
		}
		else
			echo "<b>SQL Error: Could not connect to SQL database: $server</b><br>\n";
	}
}
?>