Subversion Repositories ALCASAR

Rev

Rev 509 | Rev 1091 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 509 Rev 901
1
<?php
1
<?php
2
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
2
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
3
	include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
3
	include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
4
else{
4
else{
5
	echo "<b>Could not include SQL library</b><br>\n";
5
	echo "<b>Could not include SQL library</b><br>\n";
6
	exit();
6
	exit();
7
}
7
}
8
include_once('../lib/functions.php');
8
include_once('../lib/functions.php');
9
if ($config[sql_use_operators] == 'true'){
9
if ($config[sql_use_operators] == 'true'){
10
	include("../lib/operators.php");
10
	include("../lib/operators.php");
11
	$text = ',op';
11
	$text = ',op';
12
	$passwd_op = ",':='";
12
	$passwd_op = ",':='";
13
}
13
}
14
$da_abort=0;
14
$da_abort=0;
15
$op_val2 = '';
15
$op_val2 = '';
16
$link = @da_sql_pconnect($config);
16
$link = @da_sql_pconnect($config);
17
if ($link){
17
if ($link){
18
	if (is_file("../lib/crypt/$config[general_encryption_method].php")){
18
	if (is_file("../lib/crypt/$config[general_encryption_method].php")){
19
		include("../lib/crypt/$config[general_encryption_method].php");
19
		include("../lib/crypt/$config[general_encryption_method].php");
20
		/*Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)*/
20
		/*Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)*/
21
		$passwd_imp = $passwd;
21
		$passwd_imp = $passwd;
22
		/*Fin Ajout*/
22
		/*Fin Ajout*/
23
		$passwd = da_encrypt($passwd);
23
		$passwd = da_encrypt($passwd);
24
		$passwd = da_sql_escape_string($passwd);
24
		$passwd = da_sql_escape_string($passwd);
25
		$res = @da_sql_query($link,$config,
25
		$res = @da_sql_query($link,$config,
26
		"INSERT INTO $config[sql_check_table] (attribute,value,username $text)
26
		"INSERT INTO $config[sql_check_table] (attribute,value,username $text)
27
		VALUES ('$config[sql_password_attribute]','$passwd','$login' $passwd_op);");
27
		VALUES ('$config[sql_password_attribute]','$passwd','$login' $passwd_op);");
28
		if (!$res || !@da_sql_affected_rows($link,$res,$config)){
28
		if (!$res || !@da_sql_affected_rows($link,$res,$config)){
29
			echo "<b>Unable to add user $login: " . da_sql_error($link,$config) . "</b><br>\n";
29
			echo "<b>Unable to add user $login: " . da_sql_error($link,$config) . "</b><br>\n";
30
			$da_abort=1;
30
			$da_abort=1;
31
		}
31
		}
32
		if ($config[sql_use_user_info_table] == 'true' && !$da_abort){
32
		if ($config[sql_use_user_info_table] == 'true' && !$da_abort){
33
			$res = @da_sql_query($link,$config,
33
			$res = @da_sql_query($link,$config,
34
			"SELECT username FROM $config[sql_user_info_table] WHERE
34
			"SELECT username FROM $config[sql_user_info_table] WHERE
35
			username = '$login';");
35
			username = '$login';");
36
			if ($res){
36
			if ($res){
37
				if (!@da_sql_num_rows($res,$config)){
37
				if (!@da_sql_num_rows($res,$config)){
38
					$Fcn = da_sql_escape_string($Fcn);
38
					$Fcn = da_sql_escape_string($Fcn);
39
					$Fmail = da_sql_escape_string($Fmail);
39
					$Fmail = da_sql_escape_string($Fmail);
40
					$Fou = da_sql_escape_string($Fou);
40
					$Fou = da_sql_escape_string($Fou);
41
					$Fhomephone = da_sql_escape_string($Fhomephone);
41
					$Fhomephone = da_sql_escape_string($Fhomephone);
42
					$Fworkphone = da_sql_escape_string($Fworkphone);
42
					$Fworkphone = da_sql_escape_string($Fworkphone);
43
					$Fmobile = da_sql_escape_string($Fmobile);	
43
					$Fmobile = da_sql_escape_string($Fmobile);	
44
					$res = @da_sql_query($link,$config,
44
					$res = @da_sql_query($link,$config,
45
					"INSERT INTO $config[sql_user_info_table]
45
					"INSERT INTO $config[sql_user_info_table]
46
					(username,name,mail,department,homephone,workphone,mobile) VALUES
46
					(username,name,mail,department,homephone,workphone,mobile) VALUES
47
					('$login','$Fcn','$Fmail','$Fou','$Fhomephone','$Ftelephonenumber','$Fmobile');");
47
					('$login','$Fcn','$Fmail','$Fou','$Fhomephone','$Ftelephonenumber','$Fmobile');");
48
					if (!$res || !@da_sql_affected_rows($link,$res,$config))
48
					if (!$res || !@da_sql_affected_rows($link,$res,$config))
49
						echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
49
						echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
50
				}
50
				}
51
				else
51
				else
52
					echo "<b>Cet usager existe d&eacute;j&agrave; dans la table 'info'</b><br>\n";
52
					echo "<b>Cet usager existe d&eacute;j&agrave; dans la table 'info'</b><br>\n";
53
			}
53
			}
54
			else
54
			else
55
				echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
55
				echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
56
		}
56
		}
57
		if ($Fgroup != ''){
57
		if ($Fgroup != ''){
58
			$Fgroup = da_sql_escape_string($Fgroup);
58
			$Fgroup = da_sql_escape_string($Fgroup);
59
			$res = @da_sql_query($link,$config,
59
			$res = @da_sql_query($link,$config,
60
			"SELECT username FROM $config[sql_usergroup_table]
60
			"SELECT username FROM $config[sql_usergroup_table]
61
			WHERE username = '$login' AND groupname = '$Fgroup';");
61
			WHERE username = '$login' AND groupname = '$Fgroup';");
62
			if ($res){
62
			if ($res){
63
				if (!@da_sql_num_rows($res,$config)){
63
				if (!@da_sql_num_rows($res,$config)){
64
					$res = @da_sql_query($link,$config,
64
					$res = @da_sql_query($link,$config,
65
					"INSERT INTO $config[sql_usergroup_table]
65
					"INSERT INTO $config[sql_usergroup_table]
66
					(username,groupname) VALUES ('$login','$Fgroup');");
66
					(username,groupname) VALUES ('$login','$Fgroup');");
67
					if (!$res || !@da_sql_affected_rows($link,$res,$config))
67
					if (!$res || !@da_sql_affected_rows($link,$res,$config))
68
						echo "<b>Could not add user to group $Fgroup. SQL Error</b><br>\n";
68
						echo "<b>Could not add user to group $Fgroup. SQL Error</b><br>\n";
69
				}
69
				}
70
				else
70
				else
71
					echo "<b>User already is a member of group $Fgroup</b><br>\n";
71
					echo "<b>User already is a member of group $Fgroup</b><br>\n";
72
			}
72
			}
73
			else
73
			else
74
				echo "<b>Could not add user to group $Fgroup: " . da_sql_error($link,$config) . "</b><br>\n";
74
				echo "<b>Could not add user to group $Fgroup: " . da_sql_error($link,$config) . "</b><br>\n";
75
		}
75
		}
76
		if (!$da_abort){
76
		if (!$da_abort){
77
			if ($Fgroup != '')
77
			if ($Fgroup != '')
78
				require('../lib/defaults.php');
78
				require('../lib/defaults.php');
79
			foreach($show_attrs as $key => $attr){
79
			foreach($show_attrs as $key => $attr){
80
				if ($attrmap["$key"] == 'none')
80
				if ($attrmap["$key"] == 'none')
81
					continue;
81
					continue;
82
				if ($attrmap["$key"] == ''){
82
				if ($attrmap["$key"] == ''){
83
					$attrmap["$key"] = $key;
83
					$attrmap["$key"] = $key;
84
					$attr_type["$key"] = 'replyItem';
84
					$attr_type["$key"] = 'replyItem';
85
					$rev_attrmap["$key"] = $key;
85
					$rev_attrmap["$key"] = $key;
86
				}
86
				}
87
				if ($attr_type["$key"] == 'checkItem'){
87
				if ($attr_type["$key"] == 'checkItem'){
88
					$table = "$config[sql_check_table]";
88
					$table = "$config[sql_check_table]";
89
					$type = 1;
89
					$type = 1;
90
				}
90
				}
91
				else if ($attr_type["$key"] == 'replyItem'){
91
				else if ($attr_type["$key"] == 'replyItem'){
92
					$table = "$config[sql_reply_table]";
92
					$table = "$config[sql_reply_table]";
93
					$type = 2;
93
					$type = 2;
94
				}
94
				}
95
				$val = $$attrmap["$key"];
95
				$val = $$attrmap["$key"];
96
				/*Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)*/
96
				/*Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)*/
97
				if($key == "Session-Timeout") $sto_imp = $val;
97
				if($key == "Session-Timeout") $sto_imp = $val;
-
 
98
				if($key == "Max-All-Session") $mas_imp = $val;
98
				if($key == "Max-Daily-Session") $mds_imp = $val;
99
				if($key == "Max-Daily-Session") $mds_imp = $val;
99
				if($key == "Max-Monthly-Session") $mms_imp = $val;
100
				if($key == "Max-Monthly-Session") $mms_imp = $val;
100
				/*Fin Ajout*/
101
				/*Fin Ajout*/
101
				$val = da_sql_escape_string($val);
102
				$val = da_sql_escape_string($val);
102
				$op_name = $attrmap["$key"] . '_op';
103
				$op_name = $attrmap["$key"] . '_op';
103
				$op_val = $$op_name;
104
				$op_val = $$op_name;
104
				if ($op_val != ''){
105
				if ($op_val != ''){
105
					$op_val = da_sql_escape_string($op_val);
106
					$op_val = da_sql_escape_string($op_val);
106
					if (check_operator($op_val,$type) == -1){
107
					if (check_operator($op_val,$type) == -1){
107
						echo "<b>Invalid operator ($op_val) for attribute $key</b><br>\n";
108
						echo "<b>Invalid operator ($op_val) for attribute $key</b><br>\n";
108
						continue;
109
						continue;
109
					}
110
					}
110
					$op_val2 = ",'$op_val'";
111
					$op_val2 = ",'$op_val'";
111
				}
112
				}
112
				if ($val == '' || check_defaults($val,$op_val,$default_vals["$key"]))
113
				if ($val == '' || check_defaults($val,$op_val,$default_vals["$key"]))
113
					continue;
114
					continue;
114
				$res = @da_sql_query($link,$config,
115
				$res = @da_sql_query($link,$config,
115
				"INSERT INTO $table (attribute,value,username $text)
116
				"INSERT INTO $table (attribute,value,username $text)
116
				VALUES ('$attrmap[$key]','$val','$login' $op_val2);");
117
				VALUES ('$attrmap[$key]','$val','$login' $op_val2);");
117
				if (!$res || !@da_sql_affected_rows($link,$res,$config))
118
				if (!$res || !@da_sql_affected_rows($link,$res,$config))
118
					echo "<b>Query failed for attribute $key: " . da_sql_error($link,$config) . "</b><br>\n";
119
					echo "<b>Query failed for attribute $key: " . da_sql_error($link,$config) . "</b><br>\n";
119
			}
120
			}
120
		}
121
		}
121
		echo "<b>Usager correctement cr&eacute;&eacute;</b><br>\n";
122
		echo "<b>Usager correctement cr&eacute;&eacute;</b><br>\n";
122
	}
123
	}
123
	else
124
	else
124
		echo "<b>Could not open encryption library file</b><br>\n";
125
		echo "<b>Could not open encryption library file</b><br>\n";
125
}
126
}
126
else
127
else
127
	echo "<b>Could not connect to SQL database</b><br>\n";
128
	echo "<b>Could not connect to SQL database</b><br>\n";
128
?>
129
?>
129
 
130