Revision 1815
Added by Dietmar about 12 years ago
add.php | ||
---|---|---|
15 | 15 |
* |
16 | 16 |
*/ |
17 | 17 |
|
18 |
// Print admin header |
|
19 |
require('../../config.php'); |
|
20 |
require_once(WB_PATH.'/framework/class.admin.php'); |
|
21 |
// suppress to print the header, so no new FTAN will be set |
|
22 |
$admin = new admin('Access', 'users_add',false); |
|
18 |
/* -------------------------------------------------------- */ |
|
19 |
// Must include code to stop this file being accessed directly |
|
20 |
if(!defined('WB_URL')) { |
|
21 |
require_once(dirname(dirname(dirname(__FILE__))).'/framework/globalExceptionHandler.php'); |
|
22 |
throw new IllegalFileException(); |
|
23 |
} |
|
24 |
/* -------------------------------------------------------- */ |
|
23 | 25 |
|
24 |
// Create a javascript back link |
|
25 |
$js_back = ADMIN_URL.'/users/index.php'; |
|
26 |
function add_user($admin, &$aActionRequest) |
|
27 |
{ |
|
28 |
global $MESSAGE,$TEXT, $HEADING; |
|
29 |
$database = WbDatabase::getInstance(); |
|
30 |
$bRetVal = false; |
|
31 |
$iMinPassLength = 6; |
|
26 | 32 |
|
27 |
if( !$admin->checkFTAN() ) |
|
28 |
{ |
|
29 |
$admin->print_header(); |
|
30 |
$admin->print_error($MESSAGE['GENERIC_SECURITY_ACCESS'], $js_back); |
|
31 |
} |
|
32 |
// After check print the header |
|
33 |
$admin->print_header(); |
|
33 |
if( !$admin->checkFTAN() ) |
|
34 |
{ |
|
35 |
// $admin->print_header(); |
|
36 |
msgQueue::add($MESSAGE['GENERIC_SECURITY_ACCESS']); |
|
37 |
return $bRetVal; |
|
38 |
} |
|
34 | 39 |
|
35 |
// Get details entered |
|
36 |
$groups_id = (isset($_POST['groups'])) ? implode(",", $admin->add_slashes($_POST['groups'])) : ''; //should check permissions |
|
37 |
$groups_id = trim($groups_id, ','); // there will be an additional ',' when "Please Choose" was selected, too |
|
38 |
$active = $admin->add_slashes($_POST['active'][0]); |
|
39 |
$username_fieldname = $admin->get_post_escaped('username_fieldname'); |
|
40 |
$username = strtolower($admin->get_post_escaped($username_fieldname)); |
|
41 |
$password = $admin->get_post('password'); |
|
42 |
$password2 = $admin->get_post('password2'); |
|
43 |
$display_name = $admin->get_post_escaped('display_name'); |
|
44 |
$email = $admin->get_post_escaped('email'); |
|
45 |
$home_folder = $admin->get_post_escaped('home_folder'); |
|
46 |
$default_language = DEFAULT_LANGUAGE; |
|
40 |
// Get details entered |
|
41 |
$groups_id = (isset($aActionRequest['groups'])) ? implode(",", $admin->add_slashes($aActionRequest['groups'])) : ''; |
|
42 |
$groups_id = trim($groups_id, ','); // there will be an additional ',' when "Please Choose" was selected, too |
|
43 |
$active = intval(strip_tags($admin->StripCodeFromText($aActionRequest['active'][0]))); |
|
44 |
$username_fieldname = strip_tags($admin->StripCodeFromText($aActionRequest['username_fieldname'])); |
|
45 |
$username = strtolower(strip_tags($admin->StripCodeFromText($aActionRequest[$username_fieldname]))); |
|
46 |
$password = strip_tags($admin->StripCodeFromText($aActionRequest['password'])); |
|
47 |
$password2 = strip_tags($admin->StripCodeFromText($aActionRequest['password2'])); |
|
48 |
$display_name = strip_tags($admin->StripCodeFromText($aActionRequest['display_name'])); |
|
49 |
$email = strip_tags($admin->StripCodeFromText($aActionRequest['email'])); |
|
50 |
$home_folder = strip_tags($admin->StripCodeFromText($aActionRequest['home_folder'])); |
|
47 | 51 |
|
48 |
// Check values |
|
49 |
if($groups_id == '') { |
|
50 |
$admin->print_error($MESSAGE['USERS']['NO_GROUP'], $js_back); |
|
51 |
} |
|
52 |
if(!preg_match('/^[a-z]{1}[a-z0-9_-]{2,}$/i', $username)) { |
|
53 |
$admin->print_error( $MESSAGE['USERS_NAME_INVALID_CHARS'].' / '. |
|
54 |
$MESSAGE['USERS_USERNAME_TOO_SHORT'], $js_back); |
|
55 |
} |
|
56 |
if(strlen($password) < 2) { |
|
57 |
$admin->print_error($MESSAGE['USERS']['PASSWORD_TOO_SHORT'], $js_back); |
|
58 |
} |
|
59 |
if($password != $password2) { |
|
60 |
$admin->print_error($MESSAGE['USERS']['PASSWORD_MISMATCH'], $js_back); |
|
61 |
} |
|
62 |
if($email != '') |
|
63 |
{ |
|
64 |
if($admin->validate_email($email) == false) |
|
65 |
{ |
|
66 |
$admin->print_error($MESSAGE['USERS']['INVALID_EMAIL'], $js_back); |
|
67 |
} |
|
68 |
} else { // e-mail must be present |
|
69 |
$admin->print_error($MESSAGE['SIGNUP']['NO_EMAIL'], $js_back); |
|
70 |
} |
|
52 |
$language = DEFAULT_LANGUAGE; |
|
53 |
$timezone = -72000; |
|
54 |
$date_format = DEFAULT_DATE_FORMAT; |
|
55 |
$time_format = DEFAULT_TIME_FORMAT; |
|
56 |
$confirm_code = ''; |
|
57 |
$confirm_timeout = 0; |
|
58 |
$remember_key = ''; |
|
59 |
$login_ip = ''; |
|
60 |
$last_reset = 0; |
|
61 |
$login_when = 0; |
|
71 | 62 |
|
72 |
// choose group_id from groups_id - workaround for still remaining calls to group_id (to be cleaned-up) |
|
73 |
$gid_tmp = explode(',', $groups_id); |
|
74 |
if(in_array('1', $gid_tmp)) $group_id = '1'; // if user is in administrator-group, get this group |
|
75 |
else $group_id = $gid_tmp[0]; // else just get the first one |
|
76 |
unset($gid_tmp); |
|
63 |
// Check values |
|
64 |
// Check values |
|
65 |
if($groups_id == "") { |
|
66 |
msgQueue::add($MESSAGE['USERS_NO_GROUP']); |
|
67 |
} else { |
|
68 |
$aGroups_id = explode(',', $groups_id); |
|
69 |
//if user is in administrator-group, get this group else just get the first one |
|
70 |
if($admin->is_group_match($groups_id,'1')) { $group_id = 1; } else { $group_id = intval($aGroups_id[0]); } |
|
71 |
} |
|
77 | 72 |
|
78 |
// Check if username already exists |
|
79 |
$results = $database->query("SELECT user_id FROM ".TABLE_PREFIX."users WHERE username = '$username'"); |
|
80 |
if($results->numRows() > 0) { |
|
81 |
$admin->print_error($MESSAGE['USERS']['USERNAME_TAKEN'], $js_back); |
|
82 |
} |
|
73 |
if(!preg_match('/^[a-z]{1}[a-z0-9_-]{2,}$/i', $username)) { |
|
74 |
msgQueue::add( $MESSAGE['USERS_NAME_INVALID_CHARS']); |
|
75 |
} |
|
83 | 76 |
|
84 |
// Check if the email already exists |
|
85 |
$results = $database->query("SELECT user_id FROM ".TABLE_PREFIX."users WHERE email = '".$admin->add_slashes($_POST['email'])."'"); |
|
86 |
if($results->numRows() > 0) |
|
87 |
{ |
|
88 |
if(isset($MESSAGE['USERS']['EMAIL_TAKEN'])) |
|
89 |
{ |
|
90 |
$admin->print_error($MESSAGE['USERS']['EMAIL_TAKEN'], $js_back); |
|
91 |
} else { |
|
92 |
$admin->print_error($MESSAGE['USERS']['INVALID_EMAIL'], $js_back); |
|
93 |
} |
|
94 |
} |
|
77 |
$sql = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'users` '. |
|
78 |
'WHERE `username` LIKE \''.$username.'\' '; |
|
79 |
// Check if username already exists |
|
80 |
if( ($iFoundUser = $database->get_one($sql)) != null ) { |
|
81 |
if($iFoundUser) { |
|
82 |
msgQueue::add($MESSAGE['USERS_USERNAME_TAKEN']); |
|
83 |
} |
|
84 |
} |
|
95 | 85 |
|
96 |
// MD5 supplied password |
|
97 |
$md5_password = md5($password); |
|
86 |
if(strlen($password) < $iMinPassLength ) { |
|
87 |
msgQueue::add($MESSAGE['USERS_PASSWORD_TOO_SHORT']); |
|
88 |
} |
|
98 | 89 |
|
99 |
// Inser the user into the database |
|
100 |
$query = "INSERT INTO ".TABLE_PREFIX."users (group_id,groups_id,active,username,password,display_name,home_folder,email,timezone, language) VALUES ('$group_id', '$groups_id', '$active', '$username','$md5_password','$display_name','$home_folder','$email','-72000', '$default_language')"; |
|
101 |
$database->query($query); |
|
102 |
if($database->is_error()) { |
|
103 |
$admin->print_error($database->get_error()); |
|
104 |
} else { |
|
105 |
$admin->print_success($MESSAGE['USERS']['ADDED']); |
|
106 |
} |
|
90 |
$pattern = '/[^'.$admin->password_chars.']/'; |
|
91 |
if (preg_match($pattern, $password)) { |
|
92 |
msgQueue::add($MESSAGE['PREFERENCES_INVALID_CHARS']); |
|
93 |
} |
|
107 | 94 |
|
108 |
// Print admin footer |
|
109 |
$admin->print_footer(); |
|
95 |
if(($password != $password2) ) { |
|
96 |
msgQueue::add($MESSAGE['USERS_PASSWORD_MISMATCH']); |
|
97 |
} |
|
98 |
|
|
99 |
// |
|
100 |
// check that display_name is unique in whoole system (prevents from User-faking) |
|
101 |
$sql = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'users` '; |
|
102 |
$sql .= 'WHERE `user_id` <> '.(int)$admin->get_user_id().' AND `display_name` LIKE "'.$display_name.'"'; |
|
103 |
if( ($iFoundUser = intval($database->get_one($sql))) > 0 ){ |
|
104 |
msgQueue::add($MESSAGE['USERS_USERNAME_TAKEN'].' ('.$TEXT['DISPLAY_NAME'].')'); |
|
105 |
} else { |
|
106 |
if($display_name == '') { |
|
107 |
msgQueue::add($MESSAGE['GENERIC_FILL_IN_ALL'].' ('.$TEXT['DISPLAY_NAME'].')'); |
|
108 |
} |
|
109 |
} |
|
110 |
|
|
111 |
if(findStringInFileList($display_name, dirname(__FILE__).'/disallowedNames')) { |
|
112 |
msgQueue::add( $TEXT['ERROR'].' '.$TEXT['DISPLAY_NAME'].' ('.$display_name.')' ); |
|
113 |
} |
|
114 |
|
|
115 |
if($email != "") |
|
116 |
{ |
|
117 |
if($admin->validate_email($email) == false) |
|
118 |
{ |
|
119 |
msgQueue::add($MESSAGE['USERS_INVALID_EMAIL'].' ('.$email.')'); |
|
120 |
} |
|
121 |
} else { // e-mail must be present |
|
122 |
msgQueue::add($MESSAGE['SIGNUP_NO_EMAIL']); |
|
123 |
} |
|
124 |
|
|
125 |
$sql = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'users` '. |
|
126 |
'WHERE `email` LIKE \''.$email.'\' '; |
|
127 |
|
|
128 |
// Check if the email already exists |
|
129 |
if( ($iFoundUser = $database->get_one($sql)) != null ) { |
|
130 |
if($iFoundUser) { |
|
131 |
if(isset($MESSAGE['USERS_EMAIL_TAKEN'])) |
|
132 |
{ |
|
133 |
msgQueue::add($MESSAGE['USERS_EMAIL_TAKEN'].' ('.$email.')'); |
|
134 |
} else { |
|
135 |
msgQueue::add($MESSAGE['USERS_INVALID_EMAIL'].' ('.$email.')'); |
|
136 |
} |
|
137 |
} |
|
138 |
} |
|
139 |
|
|
140 |
if( ($msg = msgQueue::getError()) == '') |
|
141 |
{ |
|
142 |
//if user is in administrator-group, get this group else just get the first one |
|
143 |
if($admin->is_group_match($groups_id,'1')) { $group_id = 1; $groups_id = '1'; } |
|
144 |
// Inser the user into the database |
|
145 |
$sql = 'INSERT INTO `'.TABLE_PREFIX.'users` SET '. |
|
146 |
'`group_id` = '.intval($group_id).', '. |
|
147 |
'`groups_id` = \''.mysql_real_escape_string($groups_id).'\', '. |
|
148 |
'`active` = '.intval($active).', '. |
|
149 |
'`username` = \''.mysql_real_escape_string($username).'\', '. |
|
150 |
'`password` = \''.md5($password).'\', '. |
|
151 |
'`confirm_code` = \''.mysql_real_escape_string($confirm_code).'\', '. |
|
152 |
'`confirm_timeout` = '.intval($confirm_timeout).', '. |
|
153 |
'`remember_key` = \''.mysql_real_escape_string($remember_key).'\', '. |
|
154 |
'`last_reset` = '.intval($last_reset).', '. |
|
155 |
'`display_name` = \''.mysql_real_escape_string($display_name).'\', '. |
|
156 |
'`email` = \''.mysql_real_escape_string($email).'\', '. |
|
157 |
'`timezone` = '.intval($timezone).', '. |
|
158 |
'`date_format` = \''.mysql_real_escape_string($date_format).'\', '. |
|
159 |
'`time_format` = \''.mysql_real_escape_string($time_format).'\', '. |
|
160 |
'`language` = \''.mysql_real_escape_string($language).'\', '. |
|
161 |
'`home_folder` = \''.mysql_real_escape_string($home_folder).'\', '. |
|
162 |
'`login_when` = '.intval($login_when).', '. |
|
163 |
'`login_ip` = \''.mysql_real_escape_string($login_ip).'\' '. |
|
164 |
''; |
|
165 |
if($database->query($sql)) { |
|
166 |
msgQueue::add($MESSAGE['USERS_ADDED'], true); |
|
167 |
} |
|
168 |
if($database->is_error()) { |
|
169 |
msgQueue::add( implode('<br />',explode(';',$database->get_error())) ); |
|
170 |
} |
|
171 |
} else { |
|
172 |
msgQueue::add($HEADING['ADD_USER'].' '.$MESSAGE['GENERIC_NOT_COMPARE']); |
|
173 |
|
|
174 |
} |
|
175 |
} |
|
176 |
// |
Also available in: Unified diff
! Complex code refactoring users management