2 if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php3"))
3 include_once("../lib/sql/drivers/$config[sql_type]/functions.php3");
5 echo "<b>Could not include SQL library</b><br>\n";
8 include_once('../lib/functions.php3');
9 if ($config[sql_use_operators] == 'true'){
10 include("../lib/operators.php3");
16 $link = @da_sql_pconnect($config);
18 if (is_file("../lib/crypt/$config[general_encryption_method].php3")){
19 include("../lib/crypt/$config[general_encryption_method].php3");
20 $passwd = da_encrypt($passwd);
21 $passwd = da_sql_escape_string($passwd);
22 $res = @da_sql_query($link,$config,
23 "INSERT INTO $config[sql_check_table] (attribute,value,username $text)
24 VALUES ('$config[sql_password_attribute]','$passwd','$login' $passwd_op);");
25 if (!$res || !@da_sql_affected_rows($link,$res,$config)){
26 echo "<b>Unable to add user $login: " . da_sql_error($link,$config) . "</b><br>\n";
29 if ($config[sql_use_user_info_table] == 'true' && !$da_abort){
30 $res = @da_sql_query($link,$config,
31 "SELECT username FROM $config[sql_user_info_table] WHERE
32 username = '$login';");
34 if (!@da_sql_num_rows($res,$config)){
35 $Fcn = da_sql_escape_string($Fcn);
36 $Fmail = da_sql_escape_string($Fmail);
37 $Fou = da_sql_escape_string($Fou);
38 $Fhomephone = da_sql_escape_string($Fhomephone);
39 $Fworkphone = da_sql_escape_string($Fworkphone);
40 $Fmobile = da_sql_escape_string($Fmobile);
41 $res = @da_sql_query($link,$config,
42 "INSERT INTO $config[sql_user_info_table]
43 (username,name,mail,department,homephone,workphone,mobile) VALUES
44 ('$login','$Fcn','$Fmail','$Fou','$Fhomephone','$Ftelephonenumber','$Fmobile');");
45 if (!$res || !@da_sql_affected_rows($link,$res,$config))
46 echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
49 echo "<b>User already exists in user info table.</b><br>\n";
52 echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n";
55 $Fgroup = da_sql_escape_string($Fgroup);
56 $res = @da_sql_query($link,$config,
57 "SELECT username FROM $config[sql_usergroup_table]
58 WHERE username = '$login' AND groupname = '$Fgroup';");
60 if (!@da_sql_num_rows($res,$config)){
61 $res = @da_sql_query($link,$config,
62 "INSERT INTO $config[sql_usergroup_table]
63 (username,groupname) VALUES ('$login','$Fgroup');");
64 if (!$res || !@da_sql_affected_rows($link,$res,$config))
65 echo "<b>Could not add user to group $Fgroup. SQL Error</b><br>\n";
68 echo "<b>User already is a member of group $Fgroup</b><br>\n";
71 echo "<b>Could not add user to group $Fgroup: " . da_sql_error($link,$config) . "</b><br>\n";
75 require('../lib/defaults.php3');
76 foreach($show_attrs as $key => $attr){
77 if ($attrmap["$key"] == 'none')
79 if ($attrmap["$key"] == ''){
80 $attrmap["$key"] = $key;
81 $attr_type["$key"] = 'replyItem';
82 $rev_attrmap["$key"] = $key;
84 if ($attr_type["$key"] == 'checkItem'){
85 $table = "$config[sql_check_table]";
88 else if ($attr_type["$key"] == 'replyItem'){
89 $table = "$config[sql_reply_table]";
92 $val = $$attrmap["$key"];
93 $val = da_sql_escape_string($val);
94 $op_name = $attrmap["$key"] . '_op';
97 $op_val = da_sql_escape_string($op_val);
98 if (check_operator($op_val,$type) == -1){
99 echo "<b>Invalid operator ($op_val) for attribute $key</b><br>\n";
102 $op_val2 = ",'$op_val'";
104 if ($val == '' || check_defaults($val,$op_val,$default_vals["$key"]))
106 $res = @da_sql_query($link,$config,
107 "INSERT INTO $table (attribute,value,username $text)
108 VALUES ('$attrmap[$key]','$val','$login' $op_val2);");
109 if (!$res || !@da_sql_affected_rows($link,$res,$config))
110 echo "<b>Query failed for attribute $key: " . da_sql_error($link,$config) . "</b><br>\n";
113 echo "<b>User created successfully</b><br>\n";
116 echo "<b>Could not open encryption library file</b><br>\n";
119 echo "<b>Could not connect to SQL database</b><br>\n";