Revision 1446
Added by DarkViper over 13 years ago
add.php | ||
---|---|---|
1 |
<?php |
|
2 |
/** |
|
3 |
* |
|
4 |
* @category admin |
|
5 |
* @package users |
|
6 |
* @author WebsiteBaker Project |
|
7 |
* @copyright 2004-2009, Ryan Djurovich |
|
8 |
* @copyright 2009-2011, Website Baker Org. e.V. |
|
9 |
* @link http://www.websitebaker2.org/ |
|
10 |
* @license http://www.gnu.org/licenses/gpl.html |
|
11 |
* @platform WebsiteBaker 2.8.x |
|
12 |
* @requirements PHP 5.2.2 and higher |
|
13 |
* @version $Id$ |
|
14 |
* @filesource $HeadURL$ |
|
15 |
* @lastmodified $Date$ |
|
16 |
* |
|
17 |
*/ |
|
18 |
|
|
19 |
// Print admin header |
|
20 |
require('../../config.php'); |
|
21 |
require_once(WB_PATH.'/framework/class.admin.php'); |
|
22 |
$admin = new admin('Access', 'users_add'); |
|
23 |
|
|
24 |
// Create a javascript back link |
|
25 |
$js_back = ADMIN_URL.'/users/index.php'; |
|
26 |
|
|
27 |
// Create new database object |
|
28 |
//$database = new database(); |
|
29 |
if( !$admin->checkFTAN() ) |
|
30 |
{ |
|
31 |
$admin->print_error($MESSAGE['GENERIC_SECURITY_ACCESS'], $js_back); |
|
32 |
exit(); |
|
33 |
} |
|
34 |
|
|
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; |
|
47 |
|
|
48 |
// Check values |
|
49 |
if($groups_id == '') { |
|
50 |
$admin->print_error($MESSAGE['USERS']['NO_GROUP'], $js_back); |
|
51 |
} |
|
52 |
if(strlen($username) < 2) { |
|
53 |
$admin->print_error($MESSAGE['USERS']['USERNAME_TOO_SHORT'], $js_back); |
|
54 |
} |
|
55 |
if(strlen($password) < 2) { |
|
56 |
$admin->print_error($MESSAGE['USERS']['PASSWORD_TOO_SHORT'], $js_back); |
|
57 |
} |
|
58 |
if($password != $password2) { |
|
59 |
$admin->print_error($MESSAGE['USERS']['PASSWORD_MISMATCH'], $js_back); |
|
60 |
} |
|
61 |
if($email != '') |
|
62 |
{ |
|
63 |
if($admin->validate_email($email) == false) |
|
64 |
{ |
|
65 |
$admin->print_error($MESSAGE['USERS']['INVALID_EMAIL'], $js_back); |
|
66 |
} |
|
67 |
} else { // e-mail must be present |
|
68 |
$admin->print_error($MESSAGE['SIGNUP']['NO_EMAIL'], $js_back); |
|
69 |
} |
|
70 |
|
|
71 |
// choose group_id from groups_id - workaround for still remaining calls to group_id (to be cleaned-up) |
|
72 |
$gid_tmp = explode(',', $groups_id); |
|
73 |
if(in_array('1', $gid_tmp)) $group_id = '1'; // if user is in administrator-group, get this group |
|
74 |
else $group_id = $gid_tmp[0]; // else just get the first one |
|
75 |
unset($gid_tmp); |
|
76 |
|
|
77 |
// Check if username already exists |
|
78 |
$results = $database->query("SELECT user_id FROM ".TABLE_PREFIX."users WHERE username = '$username'"); |
|
79 |
if($results->numRows() > 0) { |
|
80 |
$admin->print_error($MESSAGE['USERS']['USERNAME_TAKEN'], $js_back); |
|
81 |
} |
|
82 |
|
|
83 |
// Check if the email already exists |
|
84 |
$results = $database->query("SELECT user_id FROM ".TABLE_PREFIX."users WHERE email = '".$admin->add_slashes($_POST['email'])."'"); |
|
85 |
if($results->numRows() > 0) |
|
86 |
{ |
|
87 |
if(isset($MESSAGE['USERS']['EMAIL_TAKEN'])) |
|
88 |
{ |
|
89 |
$admin->print_error($MESSAGE['USERS']['EMAIL_TAKEN'], $js_back); |
|
90 |
} else { |
|
91 |
$admin->print_error($MESSAGE['USERS']['INVALID_EMAIL'], $js_back); |
|
92 |
} |
|
93 |
} |
|
94 |
|
|
95 |
// MD5 supplied password |
|
96 |
$md5_password = md5($password); |
|
97 |
|
|
98 |
// Inser the user into the database |
|
99 |
$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')"; |
|
100 |
$database->query($query); |
|
101 |
if($database->is_error()) { |
|
102 |
$admin->print_error($database->get_error()); |
|
103 |
} else { |
|
104 |
$admin->print_success($MESSAGE['USERS']['ADDED']); |
|
105 |
} |
|
106 |
|
|
107 |
// Print admin footer |
|
108 |
$admin->print_footer(); |
|
109 |
|
|
110 |
?> |
|
1 |
<?php |
|
2 |
/** |
|
3 |
* |
|
4 |
* @category admin |
|
5 |
* @package users |
|
6 |
* @author WebsiteBaker Project |
|
7 |
* @copyright 2004-2009, Ryan Djurovich |
|
8 |
* @copyright 2009-2011, Website Baker Org. e.V. |
|
9 |
* @link http://www.websitebaker2.org/ |
|
10 |
* @license http://www.gnu.org/licenses/gpl.html |
|
11 |
* @platform WebsiteBaker 2.8.x |
|
12 |
* @requirements PHP 5.2.2 and higher |
|
13 |
* @version $Id$ |
|
14 |
* @filesource $HeadURL$ |
|
15 |
* @lastmodified $Date$ |
|
16 |
* |
|
17 |
*/ |
|
18 |
|
|
19 |
// Print admin header |
|
20 |
require('../../config.php'); |
|
21 |
require_once(WB_PATH.'/framework/class.admin.php'); |
|
22 |
$admin = new admin('Access', 'users_add'); |
|
23 |
|
|
24 |
// Create a javascript back link |
|
25 |
$js_back = ADMIN_URL.'/users/index.php'; |
|
26 |
|
|
27 |
// Create new database object |
|
28 |
//$database = new database(); |
|
29 |
if( !$admin->checkFTAN() ) |
|
30 |
{ |
|
31 |
$admin->print_error($MESSAGE['GENERIC_SECURITY_ACCESS'], $js_back); |
|
32 |
exit(); |
|
33 |
} |
|
34 |
|
|
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; |
|
47 |
|
|
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 |
} |
|
71 |
|
|
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); |
|
77 |
|
|
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 |
} |
|
83 |
|
|
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 |
} |
|
95 |
|
|
96 |
// MD5 supplied password |
|
97 |
$md5_password = md5($password); |
|
98 |
|
|
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 |
} |
|
107 |
|
|
108 |
// Print admin footer |
|
109 |
$admin->print_footer(); |
|
110 |
|
|
111 |
?> |
Also available in: Unified diff
fixed validation of loginname (admin/users and signup)