1
|
<?php
|
2
|
|
3
|
/**
|
4
|
*
|
5
|
* @category admin
|
6
|
* @package pages
|
7
|
* @author Ryan Djurovich (2004-2009), WebsiteBaker Project
|
8
|
* @copyright 2009-2012, WebsiteBaker 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: delete.php 2100 2014-02-11 15:13:12Z darkviper $
|
14
|
* @filesource $HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/admin/users/delete.php $
|
15
|
* @lastmodified $Date: 2014-02-11 16:13:12 +0100 (Tue, 11 Feb 2014) $
|
16
|
*
|
17
|
*/
|
18
|
|
19
|
/* -------------------------------------------------------- */
|
20
|
// Must include code to stop this file being accessed directly
|
21
|
if(!defined('WB_URL')) {
|
22
|
require_once(dirname(dirname(dirname(__FILE__))).'/framework/globalExceptionHandler.php');
|
23
|
throw new IllegalFileException();
|
24
|
}
|
25
|
/* -------------------------------------------------------- */
|
26
|
function delete_user($admin, $aActionRequest)
|
27
|
{
|
28
|
$oDb = WbDatabase::getInstance();
|
29
|
$oTrans = Translate::getInstance();
|
30
|
$oTrans->enableAddon('admin\\users');
|
31
|
$aUserID = array();
|
32
|
$bRetVal = false;
|
33
|
|
34
|
$action = 'default';
|
35
|
$action = (isset($aActionRequest['delete']) ? 'delete' : $action );
|
36
|
$action = (isset($aActionRequest['delete_outdated']) ? 'delete_outdated' : $action );
|
37
|
$action = (isset($aActionRequest['enable_outdated']) ? 'enable_outdated' : $action );
|
38
|
|
39
|
switch($action) :
|
40
|
case 'delete': // delete the user
|
41
|
if(isset($aActionRequest['user_id'])) {
|
42
|
if(!is_array($aActionRequest['user_id'])) {
|
43
|
$aUserID[] = $aActionRequest['user_id'];
|
44
|
} else {
|
45
|
$aUserID = $aActionRequest['user_id'];
|
46
|
}
|
47
|
}
|
48
|
break;
|
49
|
case 'delete_outdated': // delete Users awaiting activation
|
50
|
if(isset($aActionRequest['activation_user_id'])) {
|
51
|
if(!is_array($aActionRequest['activation_user_id'])) {
|
52
|
$aUserID[] = $aActionRequest['activation_user_id'];
|
53
|
} else {
|
54
|
$aUserID = $aActionRequest['activation_user_id'];
|
55
|
}
|
56
|
}
|
57
|
break;
|
58
|
case 'enable_outdated': // enable Users awaiting activation
|
59
|
if(isset($aActionRequest['activation_user_id'])) {
|
60
|
if(!is_array($aActionRequest['activation_user_id'])) {
|
61
|
$aUserID[] = $aActionRequest['activation_user_id'];
|
62
|
} else {
|
63
|
$aUserID = $aActionRequest['activation_user_id'];
|
64
|
}
|
65
|
}
|
66
|
break;
|
67
|
default: // show userlist with empty modify mask
|
68
|
endswitch; // end of switch
|
69
|
|
70
|
// if(isset($aActionRequest['activation_user_id'])) {
|
71
|
// if(!is_array($aActionRequest['activation_user_id'])) {
|
72
|
//
|
73
|
// $aUserID[] = $aActionRequest['activation_user_id'];
|
74
|
// } else {
|
75
|
// $aUserID = $aActionRequest['activation_user_id'];
|
76
|
// }
|
77
|
// } else {
|
78
|
// if(isset($aActionRequest['user_id'])) {
|
79
|
// if(!is_array($aActionRequest['user_id'])) {
|
80
|
//
|
81
|
// $aUserID[] = $aActionRequest['user_id'];
|
82
|
// } else {
|
83
|
// $aUserID = $aActionRequest['user_id'];
|
84
|
// }
|
85
|
// }
|
86
|
// }
|
87
|
|
88
|
|
89
|
foreach ( $aUserID AS $key => $value)
|
90
|
{
|
91
|
switch ($_SERVER['REQUEST_METHOD']) :
|
92
|
case 'GET': // insert/update user
|
93
|
$_GET['user_id'] =$aUserID[$key];
|
94
|
break;
|
95
|
default: // show userlist with empty modify mask
|
96
|
$_POST['user_id'] =$aUserID[$key];
|
97
|
endswitch; // end of switch
|
98
|
$user_id = intval($admin->checkIDKEY('user_id', 0, $_SERVER['REQUEST_METHOD']));
|
99
|
|
100
|
// Check if user id is a valid number and doesnt equal 1
|
101
|
if($user_id == 0){
|
102
|
msgQueue::add($oTrans->MESSAGE_GENERIC_FORGOT_OPTIONS );
|
103
|
return $bRetVal;
|
104
|
}
|
105
|
|
106
|
if( ($user_id < 2 ) )
|
107
|
{
|
108
|
// if($admin_header) { $admin->print_header(); }
|
109
|
msgQueue::add($oTrans->MESSAGE_GENERIC_SECURITY_ACCESS );
|
110
|
return $bRetVal;
|
111
|
}
|
112
|
|
113
|
if( ($msg = msgQueue::getError()) == '')
|
114
|
{
|
115
|
|
116
|
switch($action) :
|
117
|
case 'enable_outdated': // enable Users awaiting activation
|
118
|
$sql = 'SELECT `display_name` FROM `'.$oDb->TablePrefix.'users` '.
|
119
|
'WHERE `user_id` = '.$user_id;
|
120
|
if( ($sDisplayUser = $oDb->getOne($sql)) != null ) {
|
121
|
$sql = 'UPDATE `'.$oDb->TablePrefix.'users` '
|
122
|
. 'SET `active`=1, '
|
123
|
. '`confirm_code`=\'\', '
|
124
|
. '`confirm_timeout`=0 '
|
125
|
. 'WHERE `user_id`='.$user_id;
|
126
|
if($oDb->doQuery($sql)) {
|
127
|
msgQueue::add($oTrans->MESSAGE_USERS_ADDED.' ('.$sDisplayUser.')', true);
|
128
|
$bRetVal = true;
|
129
|
} else {
|
130
|
msgQueue::add($oTrans->TEXT_ENABLE.$oTrans->MESSAGE_GENERIC_NOT_COMPARE.' ('.$sDisplayUser.')');
|
131
|
}
|
132
|
}
|
133
|
break;
|
134
|
default: // show userlist with empty modify mask
|
135
|
$sql = 'SELECT `active` FROM `'.$oDb->TablePrefix.'users` '.
|
136
|
'WHERE `user_id` = '.$user_id;
|
137
|
if( ($iDeleteUser = $oDb->getOne($sql)) != null ) {
|
138
|
if($iDeleteUser) {
|
139
|
// Deactivate the user
|
140
|
$sql = 'UPDATE `'.$oDb->TablePrefix.'users` SET '.
|
141
|
'`active` = 0 '.
|
142
|
'WHERE `user_id` = '.$user_id;
|
143
|
if( $oDb->doQuery($sql) ) {
|
144
|
msgQueue::add($oTrans->TEXT_USERS_MARKED_DELETED, true);
|
145
|
}
|
146
|
} else {
|
147
|
|
148
|
|
149
|
$sql = 'DELETE FROM `'.$oDb->TablePrefix.'users` '.
|
150
|
'WHERE `user_id` = '.$user_id;
|
151
|
if( $oDb->doQuery($sql) ) {
|
152
|
msgQueue::add($oTrans->MESSAGE_USERS_DELETED, true);
|
153
|
}
|
154
|
}
|
155
|
$bRetVal = true;
|
156
|
}
|
157
|
if($oDb->isError()) {
|
158
|
msgQueue::add( implode('<br />',explode(';',$oDb->getError())) );
|
159
|
$bRetVal = false;
|
160
|
}
|
161
|
endswitch; // end of switch
|
162
|
} // getError
|
163
|
} // foreach users
|
164
|
if(isset($aActionRequest['clearmsg'])) { msgQueue::clear(); }
|
165
|
return $bRetVal;
|
166
|
}
|
167
|
|
168
|
if(!isset($aActionRequest)) {
|
169
|
$requestMethod = '_'.strtoupper($_SERVER['REQUEST_METHOD']);
|
170
|
$aActionRequest = (isset(${$requestMethod})) ? ${$requestMethod} : null;
|
171
|
$aActionRequest['clearmsg'] = true;
|
172
|
}
|