@@ -76,7 +76,7 @@ discard block |
||
76 | 76 | ) { |
77 | 77 | // Not allowed page |
78 | 78 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
79 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
79 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
80 | 80 | exit; |
81 | 81 | } |
82 | 82 | |
@@ -134,13 +134,13 @@ discard block |
||
134 | 134 | |
135 | 135 | header('Content-Description: File Transfer'); |
136 | 136 | header('Content-Type: application/octet-stream'); |
137 | - header('Content-Disposition: attachment; filename="' . $safeFilename . '"'); |
|
137 | + header('Content-Disposition: attachment; filename="'.$safeFilename.'"'); |
|
138 | 138 | header('Cache-Control: must-revalidate, no-cache, no-store'); |
139 | 139 | header('Pragma: public'); |
140 | 140 | header('Expires: 0'); |
141 | 141 | |
142 | 142 | if ($filesize !== null) { |
143 | - header('Content-Length: ' . $filesize); |
|
143 | + header('Content-Length: '.$filesize); |
|
144 | 144 | } |
145 | 145 | } |
146 | 146 | |
@@ -152,7 +152,7 @@ discard block |
||
152 | 152 | return false; |
153 | 153 | } |
154 | 154 | |
155 | - $filepath = $basePath . '/' . basename($filename); |
|
155 | + $filepath = $basePath.'/'.basename($filename); |
|
156 | 156 | |
157 | 157 | // Security: Verify the resolved path is within the allowed directory |
158 | 158 | $realBasePath = realpath($basePath); |
@@ -230,8 +230,8 @@ discard block |
||
230 | 230 | $file_info = DB::queryFirstRow( |
231 | 231 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, f.extension AS extension, |
232 | 232 | s.share_key AS share_key |
233 | - FROM ' . prefixTable('files') . ' AS f |
|
234 | - INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id) |
|
233 | + FROM ' . prefixTable('files').' AS f |
|
234 | + INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id) |
|
235 | 235 | WHERE s.user_id = %i AND s.object_id = %i', |
236 | 236 | $session->get('user-id'), |
237 | 237 | $get_fileid |
@@ -251,7 +251,7 @@ discard block |
||
251 | 251 | // Get unencrypted file info |
252 | 252 | $file_info = DB::queryFirstRow( |
253 | 253 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, f.extension AS extension |
254 | - FROM ' . prefixTable('files') . ' AS f |
|
254 | + FROM ' . prefixTable('files').' AS f |
|
255 | 255 | WHERE f.id = %i', |
256 | 256 | $get_fileid |
257 | 257 | ); |
@@ -263,13 +263,13 @@ discard block |
||
263 | 263 | |
264 | 264 | // Prepare filename for download |
265 | 265 | $filename = str_replace('b64:', '', $file_info['name']); |
266 | - $filename = basename($filename, '.' . $file_info['extension']); |
|
266 | + $filename = basename($filename, '.'.$file_info['extension']); |
|
267 | 267 | $filename = isBase64($filename) === true ? base64_decode($filename) : $filename; |
268 | - $filename = $filename . '.' . $file_info['extension']; |
|
268 | + $filename = $filename.'.'.$file_info['extension']; |
|
269 | 269 | |
270 | 270 | // Determine file path |
271 | - $candidatePath1 = $SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . $file_info['file']; |
|
272 | - $candidatePath2 = $SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($file_info['file']); |
|
271 | + $candidatePath1 = $SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.$file_info['file']; |
|
272 | + $candidatePath2 = $SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($file_info['file']); |
|
273 | 273 | |
274 | 274 | $filePath = false; |
275 | 275 | if (file_exists($candidatePath1)) { |
@@ -279,7 +279,7 @@ discard block |
||
279 | 279 | } |
280 | 280 | |
281 | 281 | if (WIP === true) { |
282 | - error_log('downloadFile.php: filePath: ' . $filePath . " - "); |
|
282 | + error_log('downloadFile.php: filePath: '.$filePath." - "); |
|
283 | 283 | } |
284 | 284 | |
285 | 285 | // Validate file path and security |
@@ -28,8 +28,8 @@ |
||
28 | 28 | * @see https://www.teampass.net |
29 | 29 | */ |
30 | 30 | |
31 | - // TO REMOVE |
|
32 | - // - selected_items_to_be_imported |
|
31 | + // TO REMOVE |
|
32 | + // - selected_items_to_be_imported |
|
33 | 33 | |
34 | 34 | return array( |
35 | 35 | 'no_previous_valide_private_key' => 'No previous private key fits provided password', |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | ) { |
78 | 78 | // Not allowed page |
79 | 79 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
80 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
80 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
81 | 81 | exit; |
82 | 82 | } |
83 | 83 | |
@@ -138,14 +138,14 @@ discard block |
||
138 | 138 | // Prepare variables |
139 | 139 | $post_key = filter_var($dataReceived['encryptionKey'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
140 | 140 | |
141 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
141 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
142 | 142 | |
143 | 143 | // get a token |
144 | 144 | $token = GenerateCryptKey(20, false, true, true, false, true); |
145 | 145 | |
146 | 146 | //save file |
147 | - $filename = time() . '-' . $token . '.sql'; |
|
148 | - $filepath = $SETTINGS['path_to_files_folder'] . '/' . $filename; |
|
147 | + $filename = time().'-'.$token.'.sql'; |
|
148 | + $filepath = $SETTINGS['path_to_files_folder'].'/'.$filename; |
|
149 | 149 | $handle = fopen($filepath, 'w+'); |
150 | 150 | |
151 | 151 | if ($handle === false) { |
@@ -163,7 +163,7 @@ discard block |
||
163 | 163 | $tables = array(); |
164 | 164 | $result = DB::query('SHOW TABLES'); |
165 | 165 | foreach ($result as $row) { |
166 | - $tables[] = $row['Tables_in_' . DB_NAME]; |
|
166 | + $tables[] = $row['Tables_in_'.DB_NAME]; |
|
167 | 167 | } |
168 | 168 | |
169 | 169 | $backupSuccess = true; |
@@ -173,9 +173,9 @@ discard block |
||
173 | 173 | if (empty($pre) || substr_count($table, $pre) > 0) { |
174 | 174 | $table = safeString($table); |
175 | 175 | // Write table drop and creation |
176 | - fwrite($handle, 'DROP TABLE IF EXISTS ' . $table . ";\n"); |
|
177 | - $row2 = DB::queryFirstRow('SHOW CREATE TABLE ' . $table); |
|
178 | - fwrite($handle, safeString($row2['Create Table']) . ";\n\n"); |
|
176 | + fwrite($handle, 'DROP TABLE IF EXISTS '.$table.";\n"); |
|
177 | + $row2 = DB::queryFirstRow('SHOW CREATE TABLE '.$table); |
|
178 | + fwrite($handle, safeString($row2['Create Table']).";\n\n"); |
|
179 | 179 | |
180 | 180 | // Get field information |
181 | 181 | DB::query( |
@@ -200,7 +200,7 @@ discard block |
||
200 | 200 | } |
201 | 201 | |
202 | 202 | foreach ($rows as $record) { |
203 | - $insertQuery = 'INSERT INTO ' . $table . ' VALUES('; |
|
203 | + $insertQuery = 'INSERT INTO '.$table.' VALUES('; |
|
204 | 204 | $values = array(); |
205 | 205 | |
206 | 206 | foreach ($record as $value) { |
@@ -208,11 +208,11 @@ discard block |
||
208 | 208 | if ($value === null) { |
209 | 209 | $values[] = 'NULL'; |
210 | 210 | } else { |
211 | - $values[] = '"' . addslashes(preg_replace("/\n/", '\\n', $value)) . '"'; |
|
211 | + $values[] = '"'.addslashes(preg_replace("/\n/", '\\n', $value)).'"'; |
|
212 | 212 | } |
213 | 213 | } |
214 | 214 | |
215 | - $insertQuery .= implode(',', $values) . ");\n"; |
|
215 | + $insertQuery .= implode(',', $values).");\n"; |
|
216 | 216 | fwrite($handle, $insertQuery); |
217 | 217 | |
218 | 218 | // Flush buffer periodically to free memory |
@@ -242,14 +242,14 @@ discard block |
||
242 | 242 | prepareFileWithDefuse( |
243 | 243 | 'encrypt', |
244 | 244 | $filepath, |
245 | - $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $filename, |
|
245 | + $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$filename, |
|
246 | 246 | $post_key |
247 | 247 | ); |
248 | 248 | |
249 | 249 | // Do clean |
250 | 250 | unlink($filepath); |
251 | 251 | rename( |
252 | - $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $filename, |
|
252 | + $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$filename, |
|
253 | 253 | $filepath |
254 | 254 | ); |
255 | 255 | } |
@@ -271,9 +271,9 @@ discard block |
||
271 | 271 | array( |
272 | 272 | 'error' => false, |
273 | 273 | 'message' => '', |
274 | - 'download' => 'sources/downloadFile.php?name=' . urlencode($filename) . |
|
275 | - '&action=backup&file=' . $filename . '&type=sql&key=' . $session->get('key') . '&key_tmp=' . |
|
276 | - $session->get('user-key_tmp') . '&pathIsFiles=1', |
|
274 | + 'download' => 'sources/downloadFile.php?name='.urlencode($filename). |
|
275 | + '&action=backup&file='.$filename.'&type=sql&key='.$session->get('key').'&key_tmp='. |
|
276 | + $session->get('user-key_tmp').'&pathIsFiles=1', |
|
277 | 277 | ), |
278 | 278 | 'encode' |
279 | 279 | ); |
@@ -334,13 +334,13 @@ discard block |
||
334 | 334 | error_log('DEBUG: Offset -> '.$post_offset.'/'.$post_totalSize.' | File -> '.$post_clearFilename.' | key -> '.$post_key); |
335 | 335 | } |
336 | 336 | |
337 | - include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
337 | + include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
338 | 338 | |
339 | 339 | if (empty($post_clearFilename) === true) { |
340 | 340 | // Get filename from database |
341 | 341 | $data = DB::queryFirstRow( |
342 | 342 | 'SELECT valeur |
343 | - FROM ' . prefixTable('misc') . ' |
|
343 | + FROM ' . prefixTable('misc').' |
|
344 | 344 | WHERE increment_id = %i', |
345 | 345 | $post_backupFile |
346 | 346 | ); |
@@ -367,7 +367,7 @@ discard block |
||
367 | 367 | $post_backupFile = safeString($data['valeur']); |
368 | 368 | |
369 | 369 | // Verify file exists |
370 | - if (!file_exists($SETTINGS['path_to_files_folder'] . '/' . $post_backupFile)) { |
|
370 | + if (!file_exists($SETTINGS['path_to_files_folder'].'/'.$post_backupFile)) { |
|
371 | 371 | echo prepareExchangedData( |
372 | 372 | array( |
373 | 373 | 'error' => true, |
@@ -384,8 +384,8 @@ discard block |
||
384 | 384 | // Decrypt the file |
385 | 385 | $ret = prepareFileWithDefuse( |
386 | 386 | 'decrypt', |
387 | - $SETTINGS['path_to_files_folder'] . '/' . $post_backupFile, |
|
388 | - $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $post_backupFile, |
|
387 | + $SETTINGS['path_to_files_folder'].'/'.$post_backupFile, |
|
388 | + $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$post_backupFile, |
|
389 | 389 | $post_key |
390 | 390 | ); |
391 | 391 | |
@@ -402,8 +402,8 @@ discard block |
||
402 | 402 | } |
403 | 403 | |
404 | 404 | // Do clean |
405 | - fileDelete($SETTINGS['path_to_files_folder'] . '/' . $post_backupFile, $SETTINGS); |
|
406 | - $post_backupFile = $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $post_backupFile; |
|
405 | + fileDelete($SETTINGS['path_to_files_folder'].'/'.$post_backupFile, $SETTINGS); |
|
406 | + $post_backupFile = $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$post_backupFile; |
|
407 | 407 | } else { |
408 | 408 | echo prepareExchangedData( |
409 | 409 | array( |
@@ -487,7 +487,7 @@ discard block |
||
487 | 487 | DB::query($query); |
488 | 488 | $executedQueries++; |
489 | 489 | } catch (Exception $e) { |
490 | - $errors[] = "Error executing query: " . $e->getMessage() . " - Query: " . substr($query, 0, 100) . "..."; |
|
490 | + $errors[] = "Error executing query: ".$e->getMessage()." - Query: ".substr($query, 0, 100)."..."; |
|
491 | 491 | } |
492 | 492 | $query = ''; |
493 | 493 | } |
@@ -513,7 +513,7 @@ discard block |
||
513 | 513 | } |
514 | 514 | // Rollback transaction on any exception |
515 | 515 | DB::rollback(); |
516 | - $errors[] = "Transaction failed: " . $e->getMessage(); |
|
516 | + $errors[] = "Transaction failed: ".$e->getMessage(); |
|
517 | 517 | } |
518 | 518 | |
519 | 519 | // Calculate the new offset |
@@ -528,7 +528,7 @@ discard block |
||
528 | 528 | echo prepareExchangedData( |
529 | 529 | array( |
530 | 530 | 'error' => true, |
531 | - 'message' => 'Errors occurred during import: ' . implode('; ', $errors), |
|
531 | + 'message' => 'Errors occurred during import: '.implode('; ', $errors), |
|
532 | 532 | 'newOffset' => $newOffset, |
533 | 533 | 'totalSize' => $post_totalSize, |
534 | 534 | 'clearFilename' => $post_backupFile, |
@@ -50,24 +50,24 @@ discard block |
||
50 | 50 | private function generateUserKeys($arguments) { |
51 | 51 | // Get all subtasks related to this task |
52 | 52 | $subtasks = DB::query( |
53 | - 'SELECT * FROM ' . prefixTable('background_subtasks') . ' WHERE task_id = %i AND is_in_progress = 0 ORDER BY `task` ASC', |
|
53 | + 'SELECT * FROM '.prefixTable('background_subtasks').' WHERE task_id = %i AND is_in_progress = 0 ORDER BY `task` ASC', |
|
54 | 54 | $this->taskId |
55 | 55 | ); |
56 | 56 | |
57 | 57 | if (empty($subtasks)) { |
58 | - if (LOG_TASKS=== true) $this->logger->log("No subtask was found for task {$this->taskId}"); |
|
58 | + if (LOG_TASKS === true) $this->logger->log("No subtask was found for task {$this->taskId}"); |
|
59 | 59 | return; |
60 | 60 | } |
61 | 61 | |
62 | 62 | // Process each subtask |
63 | 63 | foreach ($subtasks as $subtask) { |
64 | - if (LOG_TASKS=== true) $this->logger->log("Processing subtask {$subtask['increment_id']} for task {$this->taskId}"); |
|
64 | + if (LOG_TASKS === true) $this->logger->log("Processing subtask {$subtask['increment_id']} for task {$this->taskId}"); |
|
65 | 65 | $this->processGenerateUserKeysSubtask($subtask, $arguments); |
66 | 66 | } |
67 | 67 | |
68 | 68 | // Are all subtasks completed? |
69 | 69 | $remainingSubtasks = DB::queryFirstField( |
70 | - 'SELECT COUNT(*) FROM ' . prefixTable('background_subtasks') . ' WHERE task_id = %i AND is_in_progress = 0', |
|
70 | + 'SELECT COUNT(*) FROM '.prefixTable('background_subtasks').' WHERE task_id = %i AND is_in_progress = 0', |
|
71 | 71 | $this->taskId |
72 | 72 | ); |
73 | 73 | if ($remainingSubtasks == 0) { |
@@ -98,7 +98,7 @@ discard block |
||
98 | 98 | $subtask['increment_id'] |
99 | 99 | ); |
100 | 100 | |
101 | - if (LOG_TASKS=== true) $this->logger->log("Subtask is in progress: ".$taskData['step'], 'INFO'); |
|
101 | + if (LOG_TASKS === true) $this->logger->log("Subtask is in progress: ".$taskData['step'], 'INFO'); |
|
102 | 102 | switch ($taskData['step'] ?? '') { |
103 | 103 | case 'step0': |
104 | 104 | $this->generateNewUserStep0($arguments); |
@@ -152,7 +152,7 @@ discard block |
||
152 | 152 | $subtask['increment_id'] |
153 | 153 | ); |
154 | 154 | |
155 | - $this->logger->log("Subtask {$subtask['increment_id']} failure: " . $e->getMessage(), 'ERROR'); |
|
155 | + $this->logger->log("Subtask {$subtask['increment_id']} failure: ".$e->getMessage(), 'ERROR'); |
|
156 | 156 | } |
157 | 157 | } |
158 | 158 | |
@@ -193,7 +193,7 @@ discard block |
||
193 | 193 | // Loop on items |
194 | 194 | $rows = DB::query( |
195 | 195 | 'SELECT id, pw, perso |
196 | - FROM ' . prefixTable('items') . ' |
|
196 | + FROM ' . prefixTable('items').' |
|
197 | 197 | WHERE perso = %i |
198 | 198 | ORDER BY id ASC |
199 | 199 | LIMIT %i, %i', |
@@ -206,7 +206,7 @@ discard block |
||
206 | 206 | // Get itemKey from current user |
207 | 207 | $currentUserKey = DB::queryFirstRow( |
208 | 208 | 'SELECT share_key, increment_id |
209 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
209 | + FROM ' . prefixTable('sharekeys_items').' |
|
210 | 210 | WHERE object_id = %i AND user_id = %i', |
211 | 211 | $record['id'], |
212 | 212 | (int) $record['perso'] === 0 ? $arguments['owner_id'] : $arguments['new_user_id'] |
@@ -285,16 +285,16 @@ discard block |
||
285 | 285 | // Loop on logs |
286 | 286 | $rows = DB::query( |
287 | 287 | 'SELECT increment_id |
288 | - FROM ' . prefixTable('log_items') . ' |
|
288 | + FROM ' . prefixTable('log_items').' |
|
289 | 289 | WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes" |
290 | 290 | ORDER BY increment_id ASC |
291 | - LIMIT ' . $taskData['index'] . ', ' . $taskData['nb'] |
|
291 | + LIMIT ' . $taskData['index'].', '.$taskData['nb'] |
|
292 | 292 | ); |
293 | 293 | foreach ($rows as $record) { |
294 | 294 | // Get itemKey from current user |
295 | 295 | $currentUserKey = DB::queryFirstRow( |
296 | 296 | 'SELECT share_key |
297 | - FROM ' . prefixTable('sharekeys_logs') . ' |
|
297 | + FROM ' . prefixTable('sharekeys_logs').' |
|
298 | 298 | WHERE object_id = %i AND user_id = %i', |
299 | 299 | $record['increment_id'], |
300 | 300 | $arguments['owner_id'] |
@@ -326,7 +326,7 @@ discard block |
||
326 | 326 | if ((int) $arguments['new_user_id'] !== (int) $arguments['owner_id']) { |
327 | 327 | $currentUserKey = DB::queryFirstRow( |
328 | 328 | 'SELECT increment_id |
329 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
329 | + FROM ' . prefixTable('sharekeys_items').' |
|
330 | 330 | WHERE object_id = %i AND user_id = %i', |
331 | 331 | $record['id'], |
332 | 332 | $arguments['new_user_id'] |
@@ -374,7 +374,7 @@ discard block |
||
374 | 374 | // Loop on fields |
375 | 375 | $rows = DB::query( |
376 | 376 | 'SELECT id |
377 | - FROM ' . prefixTable('categories_items') . ' |
|
377 | + FROM ' . prefixTable('categories_items').' |
|
378 | 378 | WHERE encryption_type = "teampass_aes" |
379 | 379 | ORDER BY id ASC |
380 | 380 | LIMIT %i, %i', |
@@ -385,7 +385,7 @@ discard block |
||
385 | 385 | // Get itemKey from current user |
386 | 386 | $currentUserKey = DB::queryFirstRow( |
387 | 387 | 'SELECT share_key |
388 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
388 | + FROM ' . prefixTable('sharekeys_fields').' |
|
389 | 389 | WHERE object_id = %i AND user_id = %i', |
390 | 390 | $record['id'], |
391 | 391 | $arguments['owner_id'] |
@@ -413,7 +413,7 @@ discard block |
||
413 | 413 | if ((int) $arguments['new_user_id'] !== (int) $arguments['owner_id']) { |
414 | 414 | $currentUserKey = DB::queryFirstRow( |
415 | 415 | 'SELECT increment_id |
416 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
416 | + FROM ' . prefixTable('sharekeys_items').' |
|
417 | 417 | WHERE object_id = %i AND user_id = %i', |
418 | 418 | $record['id'], |
419 | 419 | $arguments['new_user_id'] |
@@ -462,7 +462,7 @@ discard block |
||
462 | 462 | // Loop on suggestions |
463 | 463 | $rows = DB::query( |
464 | 464 | 'SELECT id |
465 | - FROM ' . prefixTable('suggestion') . ' |
|
465 | + FROM ' . prefixTable('suggestion').' |
|
466 | 466 | ORDER BY id ASC |
467 | 467 | LIMIT %i, %i', |
468 | 468 | $taskData['index'], |
@@ -472,7 +472,7 @@ discard block |
||
472 | 472 | // Get itemKey from current user |
473 | 473 | $currentUserKey = DB::queryFirstRow( |
474 | 474 | 'SELECT share_key |
475 | - FROM ' . prefixTable('sharekeys_suggestions') . ' |
|
475 | + FROM ' . prefixTable('sharekeys_suggestions').' |
|
476 | 476 | WHERE object_id = %i AND user_id = %i', |
477 | 477 | $record['id'], |
478 | 478 | $arguments['owner_id'] |
@@ -504,7 +504,7 @@ discard block |
||
504 | 504 | if ((int) $arguments['new_user_id'] !== (int) $arguments['owner_id']) { |
505 | 505 | $currentUserKey = DB::queryFirstRow( |
506 | 506 | 'SELECT increment_id |
507 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
507 | + FROM ' . prefixTable('sharekeys_items').' |
|
508 | 508 | WHERE object_id = %i AND user_id = %i', |
509 | 509 | $record['id'], |
510 | 510 | $arguments['new_user_id'] |
@@ -552,9 +552,9 @@ discard block |
||
552 | 552 | // Loop on files |
553 | 553 | $rows = DB::query( |
554 | 554 | 'SELECT f.id AS id, i.perso AS perso |
555 | - FROM ' . prefixTable('files') . ' AS f |
|
556 | - INNER JOIN ' . prefixTable('items') . ' AS i ON i.id = f.id_item |
|
557 | - WHERE f.status = "' . TP_ENCRYPTION_NAME . '" |
|
555 | + FROM ' . prefixTable('files').' AS f |
|
556 | + INNER JOIN ' . prefixTable('items').' AS i ON i.id = f.id_item |
|
557 | + WHERE f.status = "' . TP_ENCRYPTION_NAME.'" |
|
558 | 558 | LIMIT %i, %i', |
559 | 559 | $taskData['index'], |
560 | 560 | $taskData['nb'] |
@@ -563,7 +563,7 @@ discard block |
||
563 | 563 | // Get itemKey from current user |
564 | 564 | $currentUserKey = DB::queryFirstRow( |
565 | 565 | 'SELECT share_key, increment_id |
566 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
566 | + FROM ' . prefixTable('sharekeys_files').' |
|
567 | 567 | WHERE object_id = %i AND user_id = %i', |
568 | 568 | $record['id'], |
569 | 569 | (int) $record['perso'] === 0 ? $arguments['owner_id'] : $arguments['new_user_id'] |
@@ -591,7 +591,7 @@ discard block |
||
591 | 591 | |
592 | 592 | $currentUserKey = DB::queryFirstRow( |
593 | 593 | 'SELECT increment_id |
594 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
594 | + FROM ' . prefixTable('sharekeys_files').' |
|
595 | 595 | WHERE object_id = %i AND user_id = %i', |
596 | 596 | $record['id'], |
597 | 597 | $arguments['new_user_id'] |
@@ -671,7 +671,7 @@ discard block |
||
671 | 671 | // get user info |
672 | 672 | $userInfo = DB::queryFirstRow( |
673 | 673 | 'SELECT u.email, u.login, u.auth_type, u.special, u.lastname, u.name |
674 | - FROM ' . prefixTable('users') . ' AS u |
|
674 | + FROM ' . prefixTable('users').' AS u |
|
675 | 675 | WHERE u.id = %i', |
676 | 676 | $arguments['new_user_id'] |
677 | 677 | ); |
@@ -686,10 +686,10 @@ discard block |
||
686 | 686 | filter_var($userInfo['email'], FILTER_SANITIZE_EMAIL), |
687 | 687 | // @scrutinizer ignore-type |
688 | 688 | empty($arguments['email_body']) === false ? $arguments['email_body'] : $lang->get('email_body_user_config_1'), |
689 | - 'TEAMPASS - ' . $lang->get('login_credentials'), |
|
689 | + 'TEAMPASS - '.$lang->get('login_credentials'), |
|
690 | 690 | (array) filter_var_array( |
691 | 691 | [ |
692 | - '#code#' => cryption($arguments['new_user_code'], '','decrypt', $this->settings)['string'], |
|
692 | + '#code#' => cryption($arguments['new_user_code'], '', 'decrypt', $this->settings)['string'], |
|
693 | 693 | '#lastname#' => isset($userInfo['name']) === true ? $userInfo['name'] : '', |
694 | 694 | '#login#' => isset($userInfo['login']) === true ? $userInfo['login'] : '', |
695 | 695 | ], |
@@ -703,8 +703,8 @@ discard block |
||
703 | 703 | // Does user has personal items? |
704 | 704 | $personalItemsCount = DB::queryFirstField( |
705 | 705 | 'SELECT COUNT(*) |
706 | - FROM ' . prefixTable('items') . ' |
|
707 | - WHERE perso = 1 AND id IN (SELECT object_id FROM ' . prefixTable('sharekeys_items') . ' WHERE user_id = %i)', |
|
706 | + FROM ' . prefixTable('items').' |
|
707 | + WHERE perso = 1 AND id IN (SELECT object_id FROM ' . prefixTable('sharekeys_items').' WHERE user_id = %i)', |
|
708 | 708 | $arguments['new_user_id'] |
709 | 709 | ); |
710 | 710 | |
@@ -735,24 +735,24 @@ discard block |
||
735 | 735 | private function getOwnerInfos(int $owner_id, string $owner_pwd, int $only_personal_items = 0, string $owner_private_key = ''): array { |
736 | 736 | $userInfo = DB::queryFirstRow( |
737 | 737 | 'SELECT pw, public_key, private_key, login, name |
738 | - FROM ' . prefixTable('users') . ' |
|
738 | + FROM ' . prefixTable('users').' |
|
739 | 739 | WHERE id = %i', |
740 | 740 | $owner_id |
741 | 741 | ); |
742 | 742 | |
743 | 743 | // decrypt owner password |
744 | - $pwd = cryption($owner_pwd, '','decrypt', $this->settings)['string']; |
|
744 | + $pwd = cryption($owner_pwd, '', 'decrypt', $this->settings)['string']; |
|
745 | 745 | |
746 | 746 | // decrypt private key and send back |
747 | 747 | if ((int) $only_personal_items === 1 && empty($owner_private_key) === false) { |
748 | 748 | // Explicitely case where we only want personal items and where user has provided his private key |
749 | 749 | return [ |
750 | - 'private_key' => cryption($owner_private_key, '','decrypt')['string'], |
|
750 | + 'private_key' => cryption($owner_private_key, '', 'decrypt')['string'], |
|
751 | 751 | 'public_key' => $userInfo['public_key'], |
752 | 752 | 'login' => $userInfo['login'], |
753 | 753 | 'name' => $userInfo['name'], |
754 | 754 | ]; |
755 | - }else { |
|
755 | + } else { |
|
756 | 756 | // Normal case |
757 | 757 | return [ |
758 | 758 | 'private_key' => decryptPrivateKey($pwd, $userInfo['private_key']), |
@@ -55,13 +55,17 @@ discard block |
||
55 | 55 | ); |
56 | 56 | |
57 | 57 | if (empty($subtasks)) { |
58 | - if (LOG_TASKS=== true) $this->logger->log("No subtask was found for task {$this->taskId}"); |
|
58 | + if (LOG_TASKS=== true) { |
|
59 | + $this->logger->log("No subtask was found for task {$this->taskId}"); |
|
60 | + } |
|
59 | 61 | return; |
60 | 62 | } |
61 | 63 | |
62 | 64 | // Process each subtask |
63 | 65 | foreach ($subtasks as $subtask) { |
64 | - if (LOG_TASKS=== true) $this->logger->log("Processing subtask {$subtask['increment_id']} for task {$this->taskId}"); |
|
66 | + if (LOG_TASKS=== true) { |
|
67 | + $this->logger->log("Processing subtask {$subtask['increment_id']} for task {$this->taskId}"); |
|
68 | + } |
|
65 | 69 | $this->processGenerateUserKeysSubtask($subtask, $arguments); |
66 | 70 | } |
67 | 71 | |
@@ -98,7 +102,9 @@ discard block |
||
98 | 102 | $subtask['increment_id'] |
99 | 103 | ); |
100 | 104 | |
101 | - if (LOG_TASKS=== true) $this->logger->log("Subtask is in progress: ".$taskData['step'], 'INFO'); |
|
105 | + if (LOG_TASKS=== true) { |
|
106 | + $this->logger->log("Subtask is in progress: ".$taskData['step'], 'INFO'); |
|
107 | + } |
|
102 | 108 | switch ($taskData['step'] ?? '') { |
103 | 109 | case 'step0': |
104 | 110 | $this->generateNewUserStep0($arguments); |
@@ -752,7 +758,7 @@ discard block |
||
752 | 758 | 'login' => $userInfo['login'], |
753 | 759 | 'name' => $userInfo['name'], |
754 | 760 | ]; |
755 | - }else { |
|
761 | + } else { |
|
756 | 762 | // Normal case |
757 | 763 | return [ |
758 | 764 | 'private_key' => decryptPrivateKey($pwd, $userInfo['private_key']), |