Passed
Pull Request — master (#4388)
by Evertton
05:56
created
api/Controller/Api/BaseController.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -47,7 +47,7 @@  discard block
 block discarded – undo
47 47
         $requestUri = $request->getRequestUri();
48 48
 
49 49
         $uri = parse_url($requestUri, PHP_URL_PATH);
50
-        $uri = explode( '/', $uri );
50
+        $uri = explode('/', $uri);
51 51
         return $this->sanitizeUrl(array_slice($uri, ((int) array_search('index.php', $uri) + 1)));
52 52
     }
53 53
 
@@ -74,7 +74,7 @@  discard block
 block discarded – undo
74 74
     {
75 75
         $filters = [];
76 76
         $array_size = count($array);
77
-        for ($i=0; $i < $array_size; $i++) {
77
+        for ($i = 0; $i < $array_size; $i++) {
78 78
             array_push($filters, 'trim|escape');
79 79
         }
80 80
         
@@ -92,7 +92,7 @@  discard block
 block discarded – undo
92 92
      * @param mixed  $data
93 93
      * @param string $httpHeader
94 94
      */
95
-    protected function sendOutput($data, $httpHeaders=array()): void
95
+    protected function sendOutput($data, $httpHeaders = array()): void
96 96
     {
97 97
         header_remove('Set-Cookie');
98 98
 
Please login to merge, or discard this patch.
api/inc/jwt_utils.php 1 patch
Indentation   +50 added lines, -50 removed lines patch added patch discarded remove patch
@@ -37,45 +37,45 @@  discard block
 block discarded – undo
37 37
  * @return boolean
38 38
  */
39 39
 function is_jwt_valid($jwt) {
40
-	try {
41
-		$decoded = (array) JWT::decode($jwt, new Key(DB_PASSWD, 'HS256'));
40
+    try {
41
+        $decoded = (array) JWT::decode($jwt, new Key(DB_PASSWD, 'HS256'));
42 42
 
43
-		// Check if expiration is reached
44
-		if ($decoded['exp'] - time() < 0) {
45
-			return false;
46
-		}
43
+        // Check if expiration is reached
44
+        if ($decoded['exp'] - time() < 0) {
45
+            return false;
46
+        }
47 47
 /*
48 48
 		$decoded1 = JWT::decode($jwt, new Key(DB_PASSWD, 'HS256'), $headers = new stdClass());
49 49
 		print_r($headers);
50 50
 */
51 51
 
52
-		return true;
53
-	} catch (InvalidArgumentException $e) {
54
-		// provided key/key-array is empty or malformed.
55
-		return false;
56
-	} catch (DomainException $e) {
57
-		// provided algorithm is unsupported OR
58
-		// provided key is invalid OR
59
-		// unknown error thrown in openSSL or libsodium OR
60
-		// libsodium is required but not available.
61
-		return false;
62
-	} catch (SignatureInvalidException $e) {
63
-		// provided JWT signature verification failed.
64
-		return false;
65
-	} catch (BeforeValidException $e) {
66
-		// provided JWT is trying to be used before "nbf" claim OR
67
-		// provided JWT is trying to be used before "iat" claim.
68
-		return false;
69
-	} catch (ExpiredException $e) {
70
-		// provided JWT is trying to be used after "exp" claim.
71
-		return false;
72
-	} catch (UnexpectedValueException $e) {
73
-		// provided JWT is malformed OR
74
-		// provided JWT is missing an algorithm / using an unsupported algorithm OR
75
-		// provided JWT algorithm does not match provided key OR
76
-		// provided key ID in key/key-array is empty or invalid.
77
-		return false;
78
-	}
52
+        return true;
53
+    } catch (InvalidArgumentException $e) {
54
+        // provided key/key-array is empty or malformed.
55
+        return false;
56
+    } catch (DomainException $e) {
57
+        // provided algorithm is unsupported OR
58
+        // provided key is invalid OR
59
+        // unknown error thrown in openSSL or libsodium OR
60
+        // libsodium is required but not available.
61
+        return false;
62
+    } catch (SignatureInvalidException $e) {
63
+        // provided JWT signature verification failed.
64
+        return false;
65
+    } catch (BeforeValidException $e) {
66
+        // provided JWT is trying to be used before "nbf" claim OR
67
+        // provided JWT is trying to be used before "iat" claim.
68
+        return false;
69
+    } catch (ExpiredException $e) {
70
+        // provided JWT is trying to be used after "exp" claim.
71
+        return false;
72
+    } catch (UnexpectedValueException $e) {
73
+        // provided JWT is malformed OR
74
+        // provided JWT is missing an algorithm / using an unsupported algorithm OR
75
+        // provided JWT algorithm does not match provided key OR
76
+        // provided key ID in key/key-array is empty or invalid.
77
+        return false;
78
+    }
79 79
 }
80 80
 
81 81
 function base64url_encode($data) {
@@ -84,23 +84,23 @@  discard block
 block discarded – undo
84 84
 
85 85
 function get_authorization_header()
86 86
 {
87
-	$request = symfonyRequest::createFromGlobals();
88
-	$authorizationHeader = $request->headers->get('Authorization');
89
-	$headers = null;
87
+    $request = symfonyRequest::createFromGlobals();
88
+    $authorizationHeader = $request->headers->get('Authorization');
89
+    $headers = null;
90 90
 	
91
-	if (null !== $authorizationHeader) {
92
-		$headers = trim($authorizationHeader);
93
-	} else if (function_exists('apache_request_headers') === true) {
94
-		$requestHeaders = (array) apache_request_headers();
95
-		// Server-side fix for bug in old Android versions (a nice side-effect of this fix means we don't care about capitalization for Authorization)
96
-		$requestHeaders = array_combine(array_map('ucwords', array_keys($requestHeaders)), array_values($requestHeaders));
97
-		//print_r($requestHeaders);
98
-		if (isset($requestHeaders['Authorization']) === true) {
99
-			$headers = trim($requestHeaders['Authorization']);
100
-		}
101
-	}
91
+    if (null !== $authorizationHeader) {
92
+        $headers = trim($authorizationHeader);
93
+    } else if (function_exists('apache_request_headers') === true) {
94
+        $requestHeaders = (array) apache_request_headers();
95
+        // Server-side fix for bug in old Android versions (a nice side-effect of this fix means we don't care about capitalization for Authorization)
96
+        $requestHeaders = array_combine(array_map('ucwords', array_keys($requestHeaders)), array_values($requestHeaders));
97
+        //print_r($requestHeaders);
98
+        if (isset($requestHeaders['Authorization']) === true) {
99
+            $headers = trim($requestHeaders['Authorization']);
100
+        }
101
+    }
102 102
 	
103
-	return $headers;
103
+    return $headers;
104 104
 }
105 105
 
106 106
 function get_bearer_token() {
@@ -117,8 +117,8 @@  discard block
 block discarded – undo
117 117
 
118 118
 function get_bearer_data($jwt) {
119 119
     // split the jwt
120
-	$tokenParts = explode('.', $jwt);
121
-	$payload = base64_decode($tokenParts[1]);
120
+    $tokenParts = explode('.', $jwt);
121
+    $payload = base64_decode($tokenParts[1]);
122 122
 	
123 123
     // HEADER: Get the access token from the header
124 124
     if (empty($payload) === false) {
Please login to merge, or discard this patch.
api/Controller/Api/FolderController.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -48,7 +48,7 @@  discard block
 block discarded – undo
48 48
                     $arrFolders = $folderModel->getFoldersInfo(explode(",", $userData['folders_list']));
49 49
                     $responseData = json_encode($arrFolders);
50 50
                 } catch (Error $e) {
51
-                    $strErrorDesc = $e->getMessage() . ' Something went wrong! Please contact support.3';
51
+                    $strErrorDesc = $e->getMessage().' Something went wrong! Please contact support.3';
52 52
                     $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
53 53
                 }
54 54
             }
@@ -121,7 +121,7 @@  discard block
 block discarded – undo
121 121
                         
122 122
                         $responseData = json_encode($arrFolder);
123 123
                     } catch (Error $e) {
124
-                        $strErrorDesc = $e->getMessage() . ' Something went wrong! Please contact support.1';
124
+                        $strErrorDesc = $e->getMessage().' Something went wrong! Please contact support.1';
125 125
                         $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
126 126
                     }
127 127
                 }
Please login to merge, or discard this patch.
scripts/background_tasks___items_handler.php 2 patches
Braces   +12 added lines, -4 removed lines patch added patch discarded remove patch
@@ -86,7 +86,9 @@  discard block
 block discarded – undo
86 86
 
87 87
 if (DB::count() > 0) {
88 88
     // handle tasks inside this process
89
-    if (WIP === true) error_log("Process in progress: ".$process_to_perform['increment_id']);
89
+    if (WIP === true) {
90
+        error_log("Process in progress: ".$process_to_perform['increment_id']);
91
+    }
90 92
     handleTask(
91 93
         $process_to_perform['increment_id'],
92 94
         json_decode($process_to_perform['arguments'], true),
@@ -103,7 +105,9 @@  discard block
 block discarded – undo
103 105
     );
104 106
     
105 107
     if (DB::count() > 0) {
106
-        if (WIP === true) error_log("New process ta start: ".$process_to_perform['increment_id']);
108
+        if (WIP === true) {
109
+            error_log("New process ta start: ".$process_to_perform['increment_id']);
110
+        }
107 111
         // update DB - started_at
108 112
         DB::update(
109 113
             prefixTable('background_tasks'),
@@ -306,7 +310,9 @@  discard block
 block discarded – undo
306 310
     if ($args['step'] === 'create_users_files_key') {
307 311
         // Loop on all files for this item
308 312
         // and encrypt them for each user
309
-        if (WIP === true) provideLog('[DEBUG] '.print_r($args['files_keys'], true), $SETTINGS);
313
+        if (WIP === true) {
314
+            provideLog('[DEBUG] '.print_r($args['files_keys'], true), $SETTINGS);
315
+        }
310 316
         foreach($args['files_keys'] as $file) {
311 317
             storeUsersShareKey(
312 318
                 prefixTable('sharekeys_items'),
@@ -323,7 +329,9 @@  discard block
 block discarded – undo
323 329
     } elseif ($args['step'] === 'create_users_fields_key') {
324 330
         // Loop on all encrypted fields for this item
325 331
         // and encrypt them for each user
326
-        if (WIP === true) provideLog('[DEBUG] '.print_r($args, true), $SETTINGS);
332
+        if (WIP === true) {
333
+            provideLog('[DEBUG] '.print_r($args, true), $SETTINGS);
334
+        }
327 335
         foreach($args['fields_keys'] as $field) {
328 336
             storeUsersShareKey(
329 337
                 prefixTable('sharekeys_fields'),
Please login to merge, or discard this patch.
Spacing   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -78,7 +78,7 @@  discard block
 block discarded – undo
78 78
 DB::debugmode(false);
79 79
 $process_to_perform = DB::queryfirstrow(
80 80
     'SELECT *
81
-    FROM ' . prefixTable('background_tasks') . '
81
+    FROM ' . prefixTable('background_tasks').'
82 82
     WHERE is_in_progress = %i AND process_type IN ("item_copy", "new_item", "update_item", "item_update_create_keys")
83 83
     ORDER BY increment_id ASC',
84 84
     1
@@ -96,7 +96,7 @@  discard block
 block discarded – undo
96 96
     // search for next process to handle
97 97
     $process_to_perform = DB::queryfirstrow(
98 98
         'SELECT *
99
-        FROM ' . prefixTable('background_tasks') . '
99
+        FROM ' . prefixTable('background_tasks').'
100 100
         WHERE is_in_progress = %i AND (finished_at = "" OR finished_at IS NULL) AND process_type IN ("item_copy", "new_item", "update_item", "item_update_create_keys")
101 101
         ORDER BY increment_id ASC',
102 102
         0
@@ -114,7 +114,7 @@  discard block
 block discarded – undo
114 114
             $process_to_perform['increment_id']
115 115
         );
116 116
 
117
-        provideLog('[PROCESS][#'. $process_to_perform['increment_id'].'][START]', $SETTINGS);
117
+        provideLog('[PROCESS][#'.$process_to_perform['increment_id'].'][START]', $SETTINGS);
118 118
         handleTask(
119 119
             $process_to_perform['increment_id'],
120 120
             json_decode($process_to_perform['arguments'], true),
@@ -136,7 +136,7 @@  discard block
 block discarded – undo
136 136
 // launch a new iterative process
137 137
 $process_to_perform = DB::queryfirstrow(
138 138
     'SELECT *
139
-    FROM ' . prefixTable('background_tasks') . '
139
+    FROM ' . prefixTable('background_tasks').'
140 140
     WHERE is_in_progress = %i AND process_type IN ("item_copy", "new_item", "update_item", "item_update_create_keys")
141 141
     ORDER BY increment_id DESC',
142 142
     1
@@ -159,10 +159,10 @@  discard block
 block discarded – undo
159 159
  */
160 160
 function handleTask(int $processId, array $ProcessArguments, array $SETTINGS, int $itemId = null): bool
161 161
 {
162
-    provideLog('[PROCESS][#'. $processId.'][START]', $SETTINGS);
162
+    provideLog('[PROCESS][#'.$processId.'][START]', $SETTINGS);
163 163
     $task_to_perform = DB::queryfirstrow(
164 164
         'SELECT *
165
-        FROM ' . prefixTable('background_subtasks') . '
165
+        FROM ' . prefixTable('background_subtasks').'
166 166
         WHERE task_id = %i AND finished_at IS NULL
167 167
         ORDER BY increment_id ASC',
168 168
         $processId
@@ -177,7 +177,7 @@  discard block
 block discarded – undo
177 177
         if ((int) $task_to_perform['sub_task_in_progress'] === 0) {
178 178
             // handle next task
179 179
             $args = json_decode($task_to_perform['task'], true);
180
-            provideLog('[TASK][#'. $task_to_perform['increment_id'].'][START]Task '.$args['step'], $SETTINGS);
180
+            provideLog('[TASK][#'.$task_to_perform['increment_id'].'][START]Task '.$args['step'], $SETTINGS);
181 181
 
182 182
             // flag as in progress
183 183
             DB::update(
@@ -219,7 +219,7 @@  discard block
 block discarded – undo
219 219
             DB::update(
220 220
                 prefixTable('background_subtasks'),
221 221
                 array(
222
-                    'sub_task_in_progress' => 0,    // flag sub task is no more in prgoress
222
+                    'sub_task_in_progress' => 0, // flag sub task is no more in prgoress
223 223
                     'task' => json_encode(["status" => "Done"]),
224 224
                     'is_in_progress' => -1,
225 225
                     'finished_at' => time(),
@@ -234,7 +234,7 @@  discard block
 block discarded – undo
234 234
             // are all tasks done?
235 235
             DB::query(
236 236
                 'SELECT *
237
-                FROM ' . prefixTable('background_subtasks') . '
237
+                FROM ' . prefixTable('background_subtasks').'
238 238
                 WHERE task_id = %i AND finished_at IS NULL',
239 239
                 $processId
240 240
             );
@@ -264,7 +264,7 @@  discard block
 block discarded – undo
264 264
 
265 265
         } else {
266 266
             // Task is currently being in progress by another server process
267
-            provideLog('[TASK][#'. $task_to_perform['increment_id'].'][WARNING] Similar task already being processes', $SETTINGS);
267
+            provideLog('[TASK][#'.$task_to_perform['increment_id'].'][WARNING] Similar task already being processes', $SETTINGS);
268 268
             return false;
269 269
         }
270 270
     } else {
@@ -311,7 +311,7 @@  discard block
 block discarded – undo
311 311
         // Loop on all files for this item
312 312
         // and encrypt them for each user
313 313
         if (WIP === true) provideLog('[DEBUG] '.print_r($args['files_keys'], true), $SETTINGS);
314
-        foreach($args['files_keys'] as $file) {
314
+        foreach ($args['files_keys'] as $file) {
315 315
             storeUsersShareKey(
316 316
                 prefixTable('sharekeys_items'),
317 317
                 0,
@@ -328,7 +328,7 @@  discard block
 block discarded – undo
328 328
         // Loop on all encrypted fields for this item
329 329
         // and encrypt them for each user
330 330
         if (WIP === true) provideLog('[DEBUG] '.print_r($args, true), $SETTINGS);
331
-        foreach($args['fields_keys'] as $field) {
331
+        foreach ($args['fields_keys'] as $field) {
332 332
             storeUsersShareKey(
333 333
                 prefixTable('sharekeys_fields'),
334 334
                 0,
@@ -382,6 +382,6 @@  discard block
 block discarded – undo
382 382
     DB::query(
383 383
         'DELETE FROM '.prefixTable('items_edition').'
384 384
         WHERE timestamp < %i',
385
-        ($SETTINGS['delay_item_edition'] > 0) ? time() - ($SETTINGS['delay_item_edition']*60) : time() - EDITION_LOCK_PERIOD
385
+        ($SETTINGS['delay_item_edition'] > 0) ? time() - ($SETTINGS['delay_item_edition'] * 60) : time() - EDITION_LOCK_PERIOD
386 386
     );
387 387
 }
388 388
\ No newline at end of file
Please login to merge, or discard this patch.
scripts/background_tasks___do_calculation.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -74,7 +74,7 @@  discard block
 block discarded – undo
74 74
     // get count of Items in this folder
75 75
     $get = DB::queryfirstrow(
76 76
         'SELECT count(*) as num_results
77
-        FROM ' . prefixTable('items') . '
77
+        FROM ' . prefixTable('items').'
78 78
         WHERE inactif = %i AND id_tree = %i',
79 79
         0,
80 80
         $child->id
@@ -83,14 +83,14 @@  discard block
 block discarded – undo
83 83
     $ret[$child->id]['id'] = $child->id;
84 84
 
85 85
     // get number of subfolders
86
-    $nodeDescendants =$tree->getDescendants($child->id, false, false, true);
86
+    $nodeDescendants = $tree->getDescendants($child->id, false, false, true);
87 87
     $ret[$child->id]['subfoldersCount'] = count($nodeDescendants);
88 88
 
89 89
     // get items number in subfolders
90 90
     if (count($nodeDescendants) > 0) {
91 91
         $get = DB::queryfirstrow(
92 92
             'SELECT count(*) as num_results
93
-            FROM ' . prefixTable('items') . '
93
+            FROM ' . prefixTable('items').'
94 94
             WHERE inactif = %i AND id_tree IN (%l)',
95 95
             0,
96 96
             implode(',', $nodeDescendants)
@@ -138,7 +138,7 @@  discard block
 block discarded – undo
138 138
     // Get item key
139 139
     $itemKey = DB::queryFirstRow(
140 140
         'SELECT share_key
141
-        FROM ' . prefixTable('sharekeys_items') . '
141
+        FROM ' . prefixTable('sharekeys_items').'
142 142
         WHERE user_id = %i AND object_id = %i',
143 143
         TP_USER_ID,
144 144
         $item['itemId']
Please login to merge, or discard this patch.
scripts/task_maintenance_clean_orphan_objects.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch
@@ -131,64 +131,64 @@
 block discarded – undo
131 131
 
132 132
     // Delete all item keys for which no user exist
133 133
     DB::query(
134
-        'DELETE k FROM ' . prefixTable('sharekeys_items') . ' k
135
-        LEFT JOIN ' . prefixTable('users') . ' u ON k.user_id = u.id
134
+        'DELETE k FROM '.prefixTable('sharekeys_items').' k
135
+        LEFT JOIN ' . prefixTable('users').' u ON k.user_id = u.id
136 136
         WHERE u.id IS NULL OR u.deleted_at IS NOT NULL'
137 137
     );
138 138
 
139 139
     // Delete all files keys for which no user exist
140 140
     DB::query(
141
-        'DELETE k FROM ' . prefixTable('sharekeys_files') . ' k
142
-        LEFT JOIN ' . prefixTable('users') . ' u ON k.user_id = u.id
141
+        'DELETE k FROM '.prefixTable('sharekeys_files').' k
142
+        LEFT JOIN ' . prefixTable('users').' u ON k.user_id = u.id
143 143
         WHERE u.id IS NULL OR u.deleted_at IS NOT NULL'
144 144
     );
145 145
 
146 146
     // Delete all fields keys for which no user exist
147 147
     DB::query(
148
-        'DELETE k FROM ' . prefixTable('sharekeys_fields') . ' k
149
-        LEFT JOIN ' . prefixTable('users') . ' u ON k.user_id = u.id
148
+        'DELETE k FROM '.prefixTable('sharekeys_fields').' k
149
+        LEFT JOIN ' . prefixTable('users').' u ON k.user_id = u.id
150 150
         WHERE u.id IS NULL OR u.deleted_at IS NOT NULL'
151 151
     );
152 152
 
153 153
     // Delete all item logs for which no user exist
154 154
     DB::query(
155
-        'DELETE l FROM ' . prefixTable('log_items') . ' l
156
-        LEFT JOIN ' . prefixTable('users') . ' u ON l.id_user = u.id
155
+        'DELETE l FROM '.prefixTable('log_items').' l
156
+        LEFT JOIN ' . prefixTable('users').' u ON l.id_user = u.id
157 157
         WHERE u.id IS NULL OR u.deleted_at IS NOT NULL'
158 158
     );
159 159
 
160 160
     // Delete all system logs for which no user exist
161 161
     DB::query(
162
-        'DELETE l FROM ' . prefixTable('log_system') . ' l
163
-        LEFT JOIN ' . prefixTable('users') . ' u ON l.qui = u.id
162
+        'DELETE l FROM '.prefixTable('log_system').' l
163
+        LEFT JOIN ' . prefixTable('users').' u ON l.qui = u.id
164 164
         WHERE i.id IS NULL OR u.deleted_at IS NOT NULL'
165 165
     );
166 166
 
167 167
     // Delete all item keys for which no object exist
168 168
     DB::query(
169
-        'DELETE k FROM ' . prefixTable('sharekeys_items') . ' k
170
-        LEFT JOIN ' . prefixTable('items') . ' i ON k.object_id = i.id
169
+        'DELETE k FROM '.prefixTable('sharekeys_items').' k
170
+        LEFT JOIN ' . prefixTable('items').' i ON k.object_id = i.id
171 171
         WHERE i.id IS NULL'
172 172
     );
173 173
 
174 174
     // Delete all files keys for which no object exist
175 175
     DB::query(
176
-        'DELETE k FROM ' . prefixTable('sharekeys_files') . ' k
177
-        LEFT JOIN ' . prefixTable('items') . ' i ON k.object_id = i.id
176
+        'DELETE k FROM '.prefixTable('sharekeys_files').' k
177
+        LEFT JOIN ' . prefixTable('items').' i ON k.object_id = i.id
178 178
         WHERE i.id IS NULL'
179 179
     );
180 180
 
181 181
     // Delete all fields keys for which no object exist
182 182
     DB::query(
183
-        'DELETE k FROM ' . prefixTable('sharekeys_fields') . ' k
184
-        LEFT JOIN ' . prefixTable('items') . ' i ON k.object_id = i.id
183
+        'DELETE k FROM '.prefixTable('sharekeys_fields').' k
184
+        LEFT JOIN ' . prefixTable('items').' i ON k.object_id = i.id
185 185
         WHERE i.id IS NULL'
186 186
     );
187 187
 
188 188
     // Delete all item logs for which no object exist
189 189
     DB::query(
190
-        'DELETE l FROM ' . prefixTable('log_items') . ' l
191
-        LEFT JOIN ' . prefixTable('items') . ' i ON k.id_item = i.id
190
+        'DELETE l FROM '.prefixTable('log_items').' l
191
+        LEFT JOIN ' . prefixTable('items').' i ON k.id_item = i.id
192 192
         WHERE i.id IS NULL'
193 193
     );
194 194
 
Please login to merge, or discard this patch.
scripts/background_tasks___userKeysCreation.php 1 patch
Spacing   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -69,7 +69,7 @@  discard block
 block discarded – undo
69 69
 
70 70
 $processToPerform = DB::queryfirstrow(
71 71
     'SELECT *
72
-    FROM ' . prefixTable('background_tasks') . '
72
+    FROM ' . prefixTable('background_tasks').'
73 73
     WHERE (finished_at IS NULL OR finished_at = "") AND process_type = %s
74 74
     ORDER BY increment_id ASC',
75 75
     'create_user_keys'
@@ -115,7 +115,7 @@  discard block
 block discarded – undo
115 115
             // Extract the subtask parameters
116 116
             $subTaskParams = json_decode($subTask['task'], true);
117 117
 
118
-            error_log('Subtask in progress: '.$subTask['increment_id']." (".$taskId.") - ".print_r($subTaskParams,true));
118
+            error_log('Subtask in progress: '.$subTask['increment_id']." (".$taskId.") - ".print_r($subTaskParams, true));
119 119
 /*
120 120
             $fichier = fopen(__DIR__.'/log.txt', 'a');
121 121
             fwrite($fichier, 'Step : '.$subTaskParams['step']." - index : ".$subTaskParams['index']."\n");
@@ -128,7 +128,7 @@  discard block
 block discarded – undo
128 128
                     // Get total number of items
129 129
                     DB::query(
130 130
                         'SELECT *
131
-                        FROM ' . prefixTable('items') . '
131
+                        FROM ' . prefixTable('items').'
132 132
                         '.(isset($taskArgumentsArray['only_personal_items']) === true && $taskArgumentsArray['only_personal_items'] === 1 ? 'WHERE perso = 1' : '')
133 133
                     );
134 134
                     createAllSubTasks($subTaskParams['step'], DB::count(), $subTaskParams['nb'], $taskId);
@@ -137,7 +137,7 @@  discard block
 block discarded – undo
137 137
                     // Get total number of items
138 138
                     DB::query(
139 139
                         'SELECT *
140
-                        FROM ' . prefixTable('log_items') . '
140
+                        FROM ' . prefixTable('log_items').'
141 141
                         WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes"'
142 142
                     );
143 143
                     createAllSubTasks($subTaskParams['step'], DB::count(), $subTaskParams['nb'], $taskId);
@@ -146,7 +146,7 @@  discard block
 block discarded – undo
146 146
                     // Get total number of items
147 147
                     DB::query(
148 148
                         'SELECT *
149
-                        FROM ' . prefixTable('categories_items') . '
149
+                        FROM ' . prefixTable('categories_items').'
150 150
                         WHERE encryption_type = "teampass_aes"'
151 151
                     );
152 152
                     createAllSubTasks($subTaskParams['step'], DB::count(), $subTaskParams['nb'], $taskId);
@@ -163,9 +163,9 @@  discard block
 block discarded – undo
163 163
                     // Get total number of items
164 164
                     DB::query(
165 165
                         'SELECT *
166
-                        FROM ' . prefixTable('files') . ' AS f
167
-                        INNER JOIN ' . prefixTable('items') . ' AS i ON i.id = f.id_item
168
-                        WHERE f.status = "' . TP_ENCRYPTION_NAME . '"'
166
+                        FROM ' . prefixTable('files').' AS f
167
+                        INNER JOIN ' . prefixTable('items').' AS i ON i.id = f.id_item
168
+                        WHERE f.status = "' . TP_ENCRYPTION_NAME.'"'
169 169
                     );
170 170
                     createAllSubTasks($subTaskParams['step'], DB::count(), $subTaskParams['nb'], $taskId);
171 171
                 }
@@ -192,7 +192,7 @@  discard block
 block discarded – undo
192 192
     // Check if subtasks have to be created
193 193
     DB::query(
194 194
         'SELECT *
195
-        FROM ' . prefixTable('background_subtasks') . '
195
+        FROM ' . prefixTable('background_subtasks').'
196 196
         WHERE task_id = %i AND task LIKE %ss',
197 197
         $taskId,
198 198
         $action
@@ -224,7 +224,7 @@  discard block
 block discarded – undo
224 224
 function countActiveSymfonyProcesses() {
225 225
     // Compter le nombre de processus actifs
226 226
     return DB::queryFirstField(
227
-        'SELECT COUNT(*) FROM ' . prefixTable('background_subtasks') . 
227
+        'SELECT COUNT(*) FROM '.prefixTable('background_subtasks'). 
228 228
         ' WHERE process_id IS NOT NULL AND finished_at IS NULL'
229 229
     );
230 230
 }
@@ -235,7 +235,7 @@  discard block
 block discarded – undo
235 235
 function getSubTasks($taskId) {
236 236
     $task_to_perform = DB::query(
237 237
         'SELECT *
238
-        FROM ' . prefixTable('background_subtasks') . '
238
+        FROM ' . prefixTable('background_subtasks').'
239 239
         WHERE task_id = %i AND finished_at IS NULL
240 240
         ORDER BY increment_id ASC',
241 241
         $taskId
@@ -286,7 +286,7 @@  discard block
 block discarded – undo
286 286
 function reloadSubTask($subTaskId) {
287 287
     // Récupérer les informations de la sous-tâche de la base de données
288 288
     $subTask = DB::queryFirstRow(
289
-        'SELECT * FROM ' . prefixTable('background_subtasks') . ' WHERE increment_id = %i', 
289
+        'SELECT * FROM '.prefixTable('background_subtasks').' WHERE increment_id = %i', 
290 290
         $subTaskId
291 291
     );
292 292
 
@@ -332,7 +332,7 @@  discard block
 block discarded – undo
332 332
     // Get all processes
333 333
     $subtasks = DB::query(
334 334
         'SELECT *
335
-        FROM ' . prefixTable('background_subtasks') . '
335
+        FROM ' . prefixTable('background_subtasks').'
336 336
         WHERE process_id IS NOT NULL AND finished_at IS NULL'
337 337
     );
338 338
 
Please login to merge, or discard this patch.
pages/api.php 1 patch
Spacing   +25 added lines, -25 removed lines patch added patch discarded remove patch
@@ -71,7 +71,7 @@  discard block
 block discarded – undo
71 71
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('api') === false) {
72 72
     // Not allowed page
73 73
     $session->set('system-error_code', ERR_NOT_ALLOWED);
74
-    include $SETTINGS['cpassman_dir'] . '/error.php';
74
+    include $SETTINGS['cpassman_dir'].'/error.php';
75 75
     exit;
76 76
 }
77 77
 
@@ -158,7 +158,7 @@  discard block
 block discarded – undo
158 158
                                     <?php
159 159
                                     $rowsKeys = DB::query(
160 160
                                         'SELECT *
161
-                                        FROM ' . prefixTable('api') . '
161
+                                        FROM ' . prefixTable('api').'
162 162
                                         WHERE type = %s
163 163
                                         ORDER BY timestamp ASC',
164 164
                                         'key'
@@ -181,15 +181,15 @@  discard block
 block discarded – undo
181 181
                                             <?php
182 182
                                             foreach ($rowsKeys as $key) {
183 183
                                                 echo '
184
-                                                    <tr data-id="' . $key['increment_id'] . '">
185
-                                                    <td width="50px"><i class="fas fa-trash infotip pointer delete-api-key" title="' . $lang->get('del_button') . '"></i></td>
186
-                                                    <td><span class="edit-api-key pointer">' . $key['label'] . '</span></td>
187
-                                                    <td>' . $key['value']. '</td>   
188
-                                                    <td><i class="fas '.((int) $key['enabled'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="enabled" data-increment-id="' . $key['increment_id'] . '"></i></td>
189
-                                                    <td><i class="fas '.((int) $key['allowed_to_create'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_create" data-increment-id="' . $key['increment_id'] . '"></i></td>
190
-                                                    <td><i class="fas '.((int) $key['allowed_to_read'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_read" data-increment-id="' . $key['increment_id'] . '"></i></td>
191
-                                                    <td><i class="fas '.((int) $key['allowed_to_update'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_update" data-increment-id="' . $key['increment_id'] . '"></i></td>
192
-                                                    <td><i class="fas '.((int) $key['allowed_to_delete'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_delete" data-increment-id="' . $key['increment_id'] . '"></i></td>                   
184
+                                                    <tr data-id="' . $key['increment_id'].'">
185
+                                                    <td width="50px"><i class="fas fa-trash infotip pointer delete-api-key" title="' . $lang->get('del_button').'"></i></td>
186
+                                                    <td><span class="edit-api-key pointer">' . $key['label'].'</span></td>
187
+                                                    <td>' . $key['value'].'</td>   
188
+                                                    <td><i class="fas '.((int) $key['enabled'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="enabled" data-increment-id="'.$key['increment_id'].'"></i></td>
189
+                                                    <td><i class="fas '.((int) $key['allowed_to_create'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_create" data-increment-id="'.$key['increment_id'].'"></i></td>
190
+                                                    <td><i class="fas '.((int) $key['allowed_to_read'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_read" data-increment-id="'.$key['increment_id'].'"></i></td>
191
+                                                    <td><i class="fas '.((int) $key['allowed_to_update'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_update" data-increment-id="'.$key['increment_id'].'"></i></td>
192
+                                                    <td><i class="fas '.((int) $key['allowed_to_delete'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_delete" data-increment-id="'.$key['increment_id'].'"></i></td>                   
193 193
                                                 </tr>';
194 194
                                             } ?>
195 195
                                         </tbody>
@@ -224,7 +224,7 @@  discard block
 block discarded – undo
224 224
                                 <div class="col-12 mt-4" id="table-api-ip">
225 225
                                     <?php
226 226
                                     $rowsIps = DB::query(
227
-                                                'SELECT increment_id, label, timestamp value FROM ' . prefixTable('api') . '
227
+                                                'SELECT increment_id, label, timestamp value FROM '.prefixTable('api').'
228 228
                                                 WHERE type = %s
229 229
                                                 ORDER BY timestamp ASC',
230 230
                                                 'ip'
@@ -242,10 +242,10 @@  discard block
 block discarded – undo
242 242
                                             <?php
243 243
                                             foreach ($rowsIps as $ip) {
244 244
                                                 echo '
245
-                                                <tr data-id="' . $ip['increment_id'] . '">
246
-                                                    <td width="50px"><i class="fas fa-trash infotip pointer delete-api-ip" title="' . $lang->get('del_button') . '"></i></td>
247
-                                                    <td><span class="edit-api-ip pointer" data-field="label">' . $ip['label'] . '</span></td>
248
-                                                    <td><span class="edit-api-ip pointer" data-field="value">' . $ip['value'] . '</span></td>
245
+                                                <tr data-id="' . $ip['increment_id'].'">
246
+                                                    <td width="50px"><i class="fas fa-trash infotip pointer delete-api-ip" title="' . $lang->get('del_button').'"></i></td>
247
+                                                    <td><span class="edit-api-ip pointer" data-field="label">' . $ip['label'].'</span></td>
248
+                                                    <td><span class="edit-api-ip pointer" data-field="value">' . $ip['value'].'</span></td>
249 249
                                                 </tr>';
250 250
                                             } ?>
251 251
                                         </tbody>
@@ -281,8 +281,8 @@  discard block
 block discarded – undo
281 281
                                     <?php
282 282
                                     $rowsKeys = DB::query(
283 283
                                         'SELECT a.*, u.name, u.lastname, u.login
284
-                                        FROM ' . prefixTable('api') . ' AS a
285
-                                        INNER JOIN ' . prefixTable('users') . ' AS u ON a.user_id = u.id
284
+                                        FROM ' . prefixTable('api').' AS a
285
+                                        INNER JOIN ' . prefixTable('users').' AS u ON a.user_id = u.id
286 286
                                         WHERE a.type = %s
287 287
                                         ORDER BY u.login ASC',
288 288
                                         'user'
@@ -303,13 +303,13 @@  discard block
 block discarded – undo
303 303
                                             <?php
304 304
                                             foreach ($rowsKeys as $key) {
305 305
                                                 echo '
306
-                                                    <tr data-id="' . $key['increment_id'] . '">
307
-                                                    <td>' . $key['name'] . ' ' . $key['lastname'] . ' (<i>'.$key['login'].'</i>)</td>
308
-                                                    <td><i class="fas '.((int) $key['enabled'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="enabled" data-increment-id="' . $key['increment_id'] . '"></i></td>
309
-                                                    <td><i class="fas '.((int) $key['allowed_to_create'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_create" data-increment-id="' . $key['increment_id'] . '"></i></td>
310
-                                                    <td><i class="fas '.((int) $key['allowed_to_read'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_read" data-increment-id="' . $key['increment_id'] . '"></i></td>
311
-                                                    <td><i class="fas '.((int) $key['allowed_to_update'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_update" data-increment-id="' . $key['increment_id'] . '"></i></td>
312
-                                                    <td><i class="fas '.((int) $key['allowed_to_delete'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_delete" data-increment-id="' . $key['increment_id'] . '"></i></td>
306
+                                                    <tr data-id="' . $key['increment_id'].'">
307
+                                                    <td>' . $key['name'].' '.$key['lastname'].' (<i>'.$key['login'].'</i>)</td>
308
+                                                    <td><i class="fas '.((int) $key['enabled'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="enabled" data-increment-id="'.$key['increment_id'].'"></i></td>
309
+                                                    <td><i class="fas '.((int) $key['allowed_to_create'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_create" data-increment-id="'.$key['increment_id'].'"></i></td>
310
+                                                    <td><i class="fas '.((int) $key['allowed_to_read'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_read" data-increment-id="'.$key['increment_id'].'"></i></td>
311
+                                                    <td><i class="fas '.((int) $key['allowed_to_update'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_update" data-increment-id="'.$key['increment_id'].'"></i></td>
312
+                                                    <td><i class="fas '.((int) $key['allowed_to_delete'] === 1 ? 'fa-toggle-on text-info' : 'fa-toggle-off').' mr-1 text-center pointer api-clickme-action" data-field="allowed_to_delete" data-increment-id="'.$key['increment_id'].'"></i></td>
313 313
                                                 </tr>';
314 314
                                             } ?>
315 315
                                         </tbody>
Please login to merge, or discard this patch.
pages/admin.php 2 patches
Braces   +1 added lines, -2 removed lines patch added patch discarded remove patch
@@ -224,8 +224,7 @@
 block discarded – undo
224 224
                             </div>
225 225
         <?php
226 226
     }
227
-}
228
-catch (Exception $e) {
227
+} catch (Exception $e) {
229 228
     error_log('TEAMPASS Error - admin page - '.$e->getMessage());
230 229
     // deepcode ignore ServerLeak: no critical information is provided
231 230
     echo 'An error occurred. Please refer to server logs.';
Please login to merge, or discard this patch.
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -71,7 +71,7 @@  discard block
 block discarded – undo
71 71
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('admin') === false) {
72 72
     // Not allowed page
73 73
     $session->set('system-error_code', ERR_NOT_ALLOWED);
74
-    include $SETTINGS['cpassman_dir'] . '/error.php';
74
+    include $SETTINGS['cpassman_dir'].'/error.php';
75 75
     exit;
76 76
 }
77 77
 
@@ -262,7 +262,7 @@  discard block
 block discarded – undo
262 262
                     <div class="card-body">
263 263
                         <?php
264 264
                         // Display information about server
265
-                        $dbSize = DB::queryFirstRow("SELECT ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS 'size' FROM information_schema.TABLES WHERE table_schema = '" . DB_NAME . "'");
265
+                        $dbSize = DB::queryFirstRow("SELECT ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS 'size' FROM information_schema.TABLES WHERE table_schema = '".DB_NAME."'");
266 266
 
267 267
                         // Get OS
268 268
                         $uname = php_uname('s');
@@ -301,7 +301,7 @@  discard block
 block discarded – undo
301 301
 
302 302
                         // Test internet access
303 303
                         $connected = @fsockopen("www.cloudflare.com", 443, $errno, $errstr, 1); // API Duo API (MFA).
304
-                        if ($connected){
304
+                        if ($connected) {
305 305
                             fclose($connected);
306 306
                             $internetAccess = '
307 307
                             <p>
@@ -318,17 +318,17 @@  discard block
 block discarded – undo
318 318
                         }
319 319
 
320 320
                         echo 
321
-                        '<p>' . $os.
321
+                        '<p>'.$os.
322 322
                             '<br><span class="ml-4"></span>'.
323 323
                         '</p>'.
324 324
                         $internetAccess.
325
-                        '<p><i class="fa-brands fa-php mr-2"></i>PHP version: ' . phpversion().
325
+                        '<p><i class="fa-brands fa-php mr-2"></i>PHP version: '.phpversion().
326 326
                             '<br><span class="ml-4">Memory limit: '.(ini_get('memory_limit')).'</span>'.
327 327
                             '<br><span class="ml-4">Memory usage: '.formatSizeUnits(memory_get_usage()).'</span>'.
328 328
                             '<br><span class="ml-4">Maximum time execution: '.ini_get('max_execution_time').'</span>'.
329 329
                             '<br><span class="ml-4">Maximum file size upload: '.ini_get('upload_max_filesize').'</span>'.
330 330
                         '</p>'.
331
-                        '<p><i class="fa-solid fa-server mr-2"></i>Server version: ' . DB::serverVersion().
331
+                        '<p><i class="fa-solid fa-server mr-2"></i>Server version: '.DB::serverVersion().
332 332
                             '<br><span class="ml-4">Database size: '.($dbSize['size']).'MB</span>'.
333 333
                         '</p>';
334 334
 
@@ -336,11 +336,11 @@  discard block
 block discarded – undo
336 336
                         $serverTime = localtime(time(), true);
337 337
                         echo '<div class="row">'.
338 338
                             '<div class="col-6"><i class="fa-solid fa-clock mr-2"></i>Server time:</div>'.
339
-                            '<div class="col-6"><span class="badge badge-info">' . 
340
-                            str_pad(strval($serverTime['tm_hour']), 2, "0", STR_PAD_LEFT) . ':' .
341
-                            str_pad(strval($serverTime['tm_min']), 2, "0", STR_PAD_LEFT) . ':' .
342
-                            str_pad(strval($serverTime['tm_sec']), 2, "0", STR_PAD_LEFT) .
343
-                            '</span></div>' .
339
+                            '<div class="col-6"><span class="badge badge-info">'. 
340
+                            str_pad(strval($serverTime['tm_hour']), 2, "0", STR_PAD_LEFT).':'.
341
+                            str_pad(strval($serverTime['tm_min']), 2, "0", STR_PAD_LEFT).':'.
342
+                            str_pad(strval($serverTime['tm_sec']), 2, "0", STR_PAD_LEFT).
343
+                            '</span></div>'.
344 344
                         '</div>'.
345 345
                         '<div class="row">'.
346 346
                             '<div class="col-6"><span class="ml-4">Timezone:</span></div>'.
Please login to merge, or discard this patch.