Completed
Push — master ( 8da2eb...bc09ea )
by Nils
01:25 queued 59s
created
sources/users.logs.datatable.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -75,7 +75,7 @@  discard block
 block discarded – undo
75 75
 ) {
76 76
     // Not allowed page
77 77
     $session->set('system-error_code', ERR_NOT_ALLOWED);
78
-    include $SETTINGS['cpassman_dir'] . '/error.php';
78
+    include $SETTINGS['cpassman_dir'].'/error.php';
79 79
     exit;
80 80
 }
81 81
 
@@ -145,7 +145,7 @@  discard block
 block discarded – undo
145 145
     if (isset($order['column']) && preg_match('#^(asc|desc)$#i', $order['dir'])) {
146 146
         $columnIndex = $order['column'];
147 147
         $dir = $inputData['dir'];
148
-        $sOrder .= $aColumns[$columnIndex] . ' ' . $dir . ', ';
148
+        $sOrder .= $aColumns[$columnIndex].' '.$dir.', ';
149 149
     }
150 150
 
151 151
     $sOrder = substr_replace($sOrder, '', -2);
Please login to merge, or discard this patch.
sources/folders.class.php 3 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -113,7 +113,7 @@
 block discarded – undo
113 113
     private function isParentFolderAllowed($parent_id, $user_accessible_folders, $user_is_admin, $user_can_create_root_folder)
114 114
     {
115 115
         if ($parent_id == 0 && $user_can_create_root_folder == true)
116
-	    return true;
116
+        return true;
117 117
 
118 118
         if (in_array($parent_id, $user_accessible_folders) === false
119 119
             && (int) $user_is_admin !== 1
Please login to merge, or discard this patch.
Braces   +6 added lines, -4 removed lines patch added patch discarded remove patch
@@ -112,8 +112,9 @@  discard block
 block discarded – undo
112 112
      */
113 113
     private function isParentFolderAllowed($parent_id, $user_accessible_folders, $user_is_admin, $user_can_create_root_folder)
114 114
     {
115
-        if ($parent_id == 0 && $user_can_create_root_folder == true)
116
-	    return true;
115
+        if ($parent_id == 0 && $user_can_create_root_folder == true) {
116
+        	    return true;
117
+        }
117 118
 
118 119
         if (in_array($parent_id, $user_accessible_folders) === false
119 120
             && (int) $user_is_admin !== 1
@@ -438,8 +439,9 @@  discard block
 block discarded – undo
438 439
             )['count'];
439 440
 
440 441
             // Don't insert duplicates
441
-            if ($count > 0)
442
-                continue;
442
+            if ($count > 0) {
443
+                            continue;
444
+            }
443 445
 
444 446
             // Insert new background task
445 447
             DB::insert(
Please login to merge, or discard this patch.
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch
@@ -91,7 +91,7 @@  discard block
 block discarded – undo
91 91
 
92 92
         $parentComplexity = $this->checkComplexityLevel($parentFolderData, $complexity, $parent_id);
93 93
         if (isset($parentComplexity['error']) && $parentComplexity['error'] === true) {
94
-            return $this->errorResponse($this->lang->get('error_folder_complexity_lower_than_top_folder') . " [<b>{$this->settings['TP_PW_COMPLEXITY'][$parentComplexity['valeur']][1]}</b>]");
94
+            return $this->errorResponse($this->lang->get('error_folder_complexity_lower_than_top_folder')." [<b>{$this->settings['TP_PW_COMPLEXITY'][$parentComplexity['valeur']][1]}</b>]");
95 95
         }
96 96
 
97 97
         return $this->createFolder($params, array_merge($parentFolderData, $parentComplexity), $options);
@@ -144,7 +144,7 @@  discard block
 block discarded – undo
144 144
         ) {
145 145
             DB::query(
146 146
                 'SELECT *
147
-                FROM ' . prefixTable('nested_tree') . '
147
+                FROM ' . prefixTable('nested_tree').'
148 148
                 WHERE title = %s AND personal_folder = 0',
149 149
                 $title
150 150
             );
@@ -168,7 +168,7 @@  discard block
 block discarded – undo
168 168
         //check if parent folder is personal
169 169
         $data = DB::queryFirstRow(
170 170
             'SELECT personal_folder, bloquer_creation, bloquer_modification
171
-            FROM ' . prefixTable('nested_tree') . '
171
+            FROM ' . prefixTable('nested_tree').'
172 172
             WHERE id = %i',
173 173
             $parent_id
174 174
         );
@@ -207,7 +207,7 @@  discard block
 block discarded – undo
207 207
             // get complexity level for this folder
208 208
             $data = DB::queryFirstRow(
209 209
                 'SELECT valeur
210
-                FROM ' . prefixTable('misc') . '
210
+                FROM ' . prefixTable('misc').'
211 211
                 WHERE intitule = %i AND type = %s',
212 212
                 $parent_id,
213 213
                 'complex'
@@ -278,11 +278,11 @@  discard block
 block discarded – undo
278 278
      */
279 279
     private function canCreateFolder($isPersonal, $user_is_admin, $user_is_manager, $user_can_manage_all_users, $user_can_create_root_folder)
280 280
     {
281
-        return (int)$isPersonal === 1 ||
282
-            (int)$user_is_admin === 1 ||
283
-            ((int)$user_is_manager === 1 || (int)$user_can_manage_all_users === 1) ||
281
+        return (int) $isPersonal === 1 ||
282
+            (int) $user_is_admin === 1 ||
283
+            ((int) $user_is_manager === 1 || (int) $user_can_manage_all_users === 1) ||
284 284
             ($this->settings['enable_user_can_create_folders'] ?? false) ||
285
-            ((int)$user_can_create_root_folder === 1);
285
+            ((int) $user_can_create_root_folder === 1);
286 286
     }
287 287
 
288 288
     /**
@@ -362,7 +362,7 @@  discard block
 block discarded – undo
362 362
         $path = '';
363 363
         $tree_path = $tree->getPath(0, false);
364 364
         foreach ($tree_path as $fld) {
365
-            $path .= empty($path) ? $fld->title : '/' . $fld->title;
365
+            $path .= empty($path) ? $fld->title : '/'.$fld->title;
366 366
         }
367 367
 
368 368
         $new_json = [
@@ -376,7 +376,7 @@  discard block
 block discarded – undo
376 376
             "is_visible_active" => 0,
377 377
         ];
378 378
 
379
-        $cache_tree = DB::queryFirstRow('SELECT increment_id, folders, visible_folders FROM ' . prefixTable('cache_tree') . ' WHERE user_id = %i', (int)$user_id);
379
+        $cache_tree = DB::queryFirstRow('SELECT increment_id, folders, visible_folders FROM '.prefixTable('cache_tree').' WHERE user_id = %i', (int) $user_id);
380 380
 
381 381
         if (empty($cache_tree)) {
382 382
             DB::insert(prefixTable('cache_tree'), [
@@ -396,7 +396,7 @@  discard block
 block discarded – undo
396 396
                 'folders' => json_encode($folders),
397 397
                 'visible_folders' => json_encode($visible_folders),
398 398
                 'timestamp' => time(),
399
-            ], 'increment_id = %i', (int)$cache_tree['increment_id']);
399
+            ], 'increment_id = %i', (int) $cache_tree['increment_id']);
400 400
         }
401 401
     }
402 402
 
@@ -406,7 +406,7 @@  discard block
 block discarded – undo
406 406
     private function manageFolderPermissions($parent_id, $newId, $user_roles, $access_rights, $user_is_admin)
407 407
     {
408 408
         if ($parent_id !== 0 && $this->settings['subfolder_rights_as_parent'] ?? false) {
409
-            $rows = DB::query('SELECT role_id, type FROM ' . prefixTable('roles_values') . ' WHERE folder_id = %i', $parent_id);
409
+            $rows = DB::query('SELECT role_id, type FROM '.prefixTable('roles_values').' WHERE folder_id = %i', $parent_id);
410 410
             foreach ($rows as $record) {
411 411
                 DB::insert(prefixTable('roles_values'), [
412 412
                     'role_id' => $record['role_id'],
@@ -414,7 +414,7 @@  discard block
 block discarded – undo
414 414
                     'type' => $record['type'],
415 415
                 ]);
416 416
             }
417
-        } elseif ((int)$user_is_admin !== 1) {
417
+        } elseif ((int) $user_is_admin !== 1) {
418 418
             foreach (array_unique(explode(';', $user_roles)) as $role) {
419 419
                 if (!empty($role)) {
420 420
                     DB::insert(prefixTable('roles_values'), [
@@ -432,7 +432,7 @@  discard block
 block discarded – undo
432 432
      */
433 433
     private function copyCustomFieldsCategories($parent_id, $newId)
434 434
     {
435
-        $rows = DB::query('SELECT id_category FROM ' . prefixTable('categories_folders') . ' WHERE id_folder = %i', $parent_id);
435
+        $rows = DB::query('SELECT id_category FROM '.prefixTable('categories_folders').' WHERE id_folder = %i', $parent_id);
436 436
         foreach ($rows as $record) {
437 437
             DB::insert(prefixTable('categories_folders'), [
438 438
                 'id_category' => $record['id_category'],
@@ -457,7 +457,7 @@  discard block
 block discarded – undo
457 457
             // Search for existing job
458 458
             $count = DB::queryFirstRow(
459 459
                 'SELECT COUNT(*) AS count
460
-                FROM ' . prefixTable('background_tasks') . '
460
+                FROM ' . prefixTable('background_tasks').'
461 461
                 WHERE is_in_progress = %i AND process_type = %s AND arguments = %s',
462 462
                 0,
463 463
                 'user_build_cache_tree',
@@ -491,7 +491,7 @@  discard block
 block discarded – undo
491 491
         return [
492 492
             'error' => true,
493 493
             'message' => $message,
494
-            'newId' => '' . $newIdSuffix,
494
+            'newId' => ''.$newIdSuffix,
495 495
         ];
496 496
     }
497 497
 }
Please login to merge, or discard this patch.
sources/import.queries.php 2 patches
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -79,7 +79,7 @@  discard block
 block discarded – undo
79 79
 ) {
80 80
     // Not allowed page
81 81
     $session->set('system-error_code', ERR_NOT_ALLOWED);
82
-    include $SETTINGS['cpassman_dir'] . '/error.php';
82
+    include $SETTINGS['cpassman_dir'].'/error.php';
83 83
     exit;
84 84
 }
85 85
 
@@ -167,7 +167,7 @@  discard block
 block discarded – undo
167 167
         );
168 168
 
169 169
         // Initialisation
170
-        $file = $SETTINGS['path_to_files_folder'] . '/' . $data['valeur'];
170
+        $file = $SETTINGS['path_to_files_folder'].'/'.$data['valeur'];
171 171
         $importation_possible = true;
172 172
         $valuesToImport = [];
173 173
         $items_number = 0;
@@ -209,7 +209,7 @@  discard block
 block discarded – undo
209 209
 
210 210
         // Observer pour récupérer les données et respecter l'ordre des colonnes
211 211
         $interpreter = new Interpreter();
212
-        $interpreter->addObserver(function (array $row) use (&$valuesToImport, $header) {
212
+        $interpreter->addObserver(function(array $row) use (&$valuesToImport, $header) {
213 213
             $rowData = array_combine($header, $row);
214 214
 
215 215
             if ($rowData !== false) {
@@ -260,7 +260,7 @@  discard block
 block discarded – undo
260 260
             // Handle multiple lignes description
261 261
             if (strpos($comments, '<br>') !== false || strpos($label, '<br>') !== false) {
262 262
                 $continue_on_next_line = true;
263
-                $comment .= " " . $label;
263
+                $comment .= " ".$label;
264 264
             } else {
265 265
                 // Insert previous line if changing line
266 266
                 if (!empty($account)) {
@@ -324,10 +324,10 @@  discard block
 block discarded – undo
324 324
             $values = [];
325 325
         
326 326
             foreach ($batchInsert as $data) {
327
-                $values[] = "('" . implode("','", array_map('addslashes', $data)) . "')";
327
+                $values[] = "('".implode("','", array_map('addslashes', $data))."')";
328 328
             }
329 329
         
330
-            $sql = "INSERT INTO `$tableName` (`label`, `description`, `pwd`, `url`, `folder`, `login`, `operation_id`) VALUES " . implode(',', $values);
330
+            $sql = "INSERT INTO `$tableName` (`label`, `description`, `pwd`, `url`, `folder`, `login`, `operation_id`) VALUES ".implode(',', $values);
331 331
             
332 332
             DB::query($sql);
333 333
         }
@@ -410,7 +410,7 @@  discard block
 block discarded – undo
410 410
             $parentId = $dataReceived['folderId']; // Strating with provided folder
411 411
 
412 412
             foreach ($parts as $part) {
413
-                $currentPath = trim($currentPath . "/" . $part, "/");
413
+                $currentPath = trim($currentPath."/".$part, "/");
414 414
                 $currentFolder = $part;
415 415
 
416 416
                 // Check if this folder has already been created
@@ -471,7 +471,7 @@  discard block
 block discarded – undo
471 471
                         // Get ID of existing folder
472 472
                         $ret = DB::queryFirstRow(
473 473
                             'SELECT *
474
-                            FROM ' . prefixTable('nested_tree') . '
474
+                            FROM ' . prefixTable('nested_tree').'
475 475
                             WHERE title = %s',
476 476
                             $currentFolder
477 477
                         );
@@ -963,7 +963,7 @@  discard block
 block discarded – undo
963 963
         ];
964 964
         $startPathLevel = 1;
965 965
 
966
-        foreach($post_folders as $folder) {
966
+        foreach ($post_folders as $folder) {
967 967
             // get parent id
968 968
             $parentId = $arrFolders[$folder['parentFolderId']];
969 969
 
@@ -1034,7 +1034,7 @@  discard block
 block discarded – undo
1034 1034
         DB::startTransaction();
1035 1035
 
1036 1036
         // Import all items
1037
-        foreach($post_items as $item) {
1037
+        foreach ($post_items as $item) {
1038 1038
             // get info about this folder
1039 1039
             $destinationFolderMore = DB::queryFirstRow(
1040 1040
                 'SELECT title FROM '.prefixTable('nested_tree').' WHERE id = %i',
@@ -1276,7 +1276,7 @@  discard block
 block discarded – undo
1276 1276
     ];
1277 1277
 }
1278 1278
 
1279
-spl_autoload_register(function ($class) {
1279
+spl_autoload_register(function($class) {
1280 1280
     $prefix = 'League\\Csv\\';
1281 1281
     $base_dir = __DIR__.'/src/';
1282 1282
     $len = strlen($prefix);
Please login to merge, or discard this patch.
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -1364,4 +1364,4 @@
 block discarded – undo
1364 1364
     $string = str_replace("{%}", "?", $string);
1365 1365
     // Trim and return.
1366 1366
     return trim($string);
1367
-  }
1367
+    }
Please login to merge, or discard this patch.
pages/import.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -71,7 +71,7 @@  discard block
 block discarded – undo
71 71
     || isset($SETTINGS['allow_import']) === false || (int) $SETTINGS['allow_import'] !== 1) {
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
 
@@ -183,7 +183,7 @@  discard block
 block discarded – undo
183 183
                                         <?php
184 184
 $complexitySelect = '';
185 185
 foreach (TP_PW_COMPLEXITY as $level) {
186
-    $complexitySelect .= '<option value="' . $level[0] . '">' . $level[1] . '</option>';
186
+    $complexitySelect .= '<option value="'.$level[0].'">'.$level[1].'</option>';
187 187
 }
188 188
 echo $complexitySelect;
189 189
                                         ?>
Please login to merge, or discard this patch.
pages/import.js.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('import') === false) {
73 73
     // Not allowed page
74 74
     $session->set('system-error_code', ERR_NOT_ALLOWED);
75
-    include $SETTINGS['cpassman_dir'] . '/error.php';
75
+    include $SETTINGS['cpassman_dir'].'/error.php';
76 76
     exit;
77 77
 }
78 78
 ?>
@@ -1043,7 +1043,7 @@  discard block
 block discarded – undo
1043 1043
                                     // Isolate first item
1044 1044
                                     if (itemsList.length > 0) {
1045 1045
                                         $('#import-feedback-progress-text')
1046
-                                            .html('<i class="fa-solid fa-cog fa-spin ml-4 mr-2"></i><?php echo $lang->get('operation_progress');?> ('+((counter*100)/itemsNumber).toFixed(2)+'%) - <i id="item-title"></i>');
1046
+                                            .html('<i class="fa-solid fa-cog fa-spin ml-4 mr-2"></i><?php echo $lang->get('operation_progress'); ?> ('+((counter*100)/itemsNumber).toFixed(2)+'%) - <i id="item-title"></i>');
1047 1047
 
1048 1048
                                         // XSS Filtering :
1049 1049
                                         $('#import-feedback-progress-text').text(itemsList[0].Title);
Please login to merge, or discard this patch.
includes/language/english.php 1 patch
Indentation   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -28,8 +28,8 @@
 block discarded – undo
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
     'import_csv_keys_generation_strategy' => 'Keys generation strategy',
Please login to merge, or discard this patch.
_things/delete_background_tasks___sending_emails.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -70,7 +70,7 @@  discard block
 block discarded – undo
70 70
 $emailService = new EmailService();
71 71
 $rows = DB::query(
72 72
     'SELECT *
73
-    FROM ' . prefixTable('background_tasks') . '
73
+    FROM ' . prefixTable('background_tasks').'
74 74
     WHERE is_in_progress = %i AND process_type = %s
75 75
     ORDER BY increment_id ASC LIMIT 0,10',
76 76
     0,
@@ -138,7 +138,7 @@  discard block
 block discarded – undo
138 138
     
139 139
     //if ((int) $SETTINGS['enable_backlog_mail'] === 1) {
140 140
         $row = DB::queryFirstRow(
141
-            'SELECT valeur FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s',
141
+            'SELECT valeur FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s',
142 142
             'cron',
143 143
             'sending_emails'
144 144
         );
@@ -146,7 +146,7 @@  discard block
 block discarded – undo
146 146
         if ((int) (time() - $row['valeur']) >= 300 || (int) $row['valeur'] === 0) {
147 147
             $rows = DB::query(
148 148
                 'SELECT *
149
-                FROM ' . prefixTable('emails') .
149
+                FROM ' . prefixTable('emails').
150 150
                 ' WHERE status != %s',
151 151
                 'sent'
152 152
             );
Please login to merge, or discard this patch.
_things/delete_background_tasks___userKeysCreation_subtaskHdl.php 1 patch
Spacing   +33 added lines, -33 removed lines patch added patch discarded remove patch
@@ -122,7 +122,7 @@  discard block
 block discarded – undo
122 122
 DB::update(
123 123
     prefixTable('background_subtasks'),
124 124
     array(
125
-        'sub_task_in_progress' => 0,    // flag sub task is no more in prgoress
125
+        'sub_task_in_progress' => 0, // flag sub task is no more in prgoress
126 126
         'is_in_progress' => 0,
127 127
         'finished_at' => time(),
128 128
         'updated_at' => time(),
@@ -158,7 +158,7 @@  discard block
 block discarded – undo
158 158
         // Check if user exists
159 159
         $userInfo = DB::queryFirstRow(
160 160
             'SELECT public_key, private_key
161
-            FROM ' . prefixTable('users') . '
161
+            FROM ' . prefixTable('users').'
162 162
             WHERE id = %i',
163 163
             $post_user_id
164 164
         );
@@ -271,13 +271,13 @@  discard block
 block discarded – undo
271 271
 {
272 272
     $userInfo = DB::queryFirstRow(
273 273
         'SELECT pw, public_key, private_key, login, name
274
-        FROM ' . prefixTable('users') . '
274
+        FROM ' . prefixTable('users').'
275 275
         WHERE id = %i',
276 276
         $owner_id
277 277
     );
278 278
     
279 279
     // decrypt owner password
280
-    $pwd = cryption($owner_pwd, '','decrypt', $SETTINGS)['string'];
280
+    $pwd = cryption($owner_pwd, '', 'decrypt', $SETTINGS)['string'];
281 281
     // decrypt private key and send back
282 282
     return [
283 283
         'private_key' => decryptPrivateKey($pwd, $userInfo['private_key']),
@@ -317,10 +317,10 @@  discard block
 block discarded – undo
317 317
     // Loop on items
318 318
     $rows = DB::query(
319 319
         'SELECT id, pw, perso
320
-        FROM ' . prefixTable('items') . '
320
+        FROM ' . prefixTable('items').'
321 321
         WHERE perso =  %i
322 322
         ORDER BY id ASC
323
-        LIMIT ' . $post_start . ', ' . $post_length,
323
+        LIMIT ' . $post_start.', '.$post_length,
324 324
         ($extra_arguments['only_personal_items'] ?? 0) === 1 ? 1 : 0
325 325
     );
326 326
 
@@ -328,7 +328,7 @@  discard block
 block discarded – undo
328 328
         // Get itemKey from current user
329 329
         $currentUserKey = DB::queryFirstRow(
330 330
             'SELECT share_key, increment_id
331
-            FROM ' . prefixTable('sharekeys_items') . '
331
+            FROM ' . prefixTable('sharekeys_items').'
332 332
             WHERE object_id = %i AND user_id = %i',
333 333
             $record['id'],
334 334
             (int) $record['perso'] === 0 ? $extra_arguments['owner_id'] : $extra_arguments['new_user_id']
@@ -355,7 +355,7 @@  discard block
 block discarded – undo
355 355
         
356 356
         $currentUserKey = DB::queryFirstRow(
357 357
             'SELECT increment_id
358
-            FROM ' . prefixTable('sharekeys_items') . '
358
+            FROM ' . prefixTable('sharekeys_items').'
359 359
             WHERE object_id = %i AND user_id = %i',
360 360
             $record['id'],
361 361
             $post_user_id
@@ -429,15 +429,15 @@  discard block
 block discarded – undo
429 429
     // Loop on logs
430 430
     $rows = DB::query(
431 431
         'SELECT increment_id
432
-        FROM ' . prefixTable('log_items') . '
432
+        FROM ' . prefixTable('log_items').'
433 433
         WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes"
434
-        LIMIT ' . $post_start . ', ' . $post_length
434
+        LIMIT ' . $post_start.', '.$post_length
435 435
     );
436 436
     foreach ($rows as $record) {
437 437
         // Get itemKey from current user
438 438
         $currentUserKey = DB::queryFirstRow(
439 439
             'SELECT share_key
440
-            FROM ' . prefixTable('sharekeys_logs') . '
440
+            FROM ' . prefixTable('sharekeys_logs').'
441 441
             WHERE object_id = %i AND user_id = %i',
442 442
             $record['increment_id'],
443 443
             $extra_arguments['owner_id']
@@ -469,7 +469,7 @@  discard block
 block discarded – undo
469 469
             if ((int) $post_user_id !== (int) $extra_arguments['owner_id']) {
470 470
                 $currentUserKey = DB::queryFirstRow(
471 471
                     'SELECT increment_id
472
-                    FROM ' . prefixTable('sharekeys_items') . '
472
+                    FROM ' . prefixTable('sharekeys_items').'
473 473
                     WHERE object_id = %i AND user_id = %i',
474 474
                     $record['id'],
475 475
                     $post_user_id
@@ -491,7 +491,7 @@  discard block
 block discarded – undo
491 491
     // SHould we change step?
492 492
     DB::query(
493 493
         'SELECT increment_id
494
-        FROM ' . prefixTable('log_items') . '
494
+        FROM ' . prefixTable('log_items').'
495 495
         WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes"'
496 496
     );
497 497
 
@@ -531,15 +531,15 @@  discard block
 block discarded – undo
531 531
     // Loop on fields
532 532
     $rows = DB::query(
533 533
         'SELECT id
534
-        FROM ' . prefixTable('categories_items') . '
534
+        FROM ' . prefixTable('categories_items').'
535 535
         WHERE encryption_type = "teampass_aes"
536
-        LIMIT ' . $post_start . ', ' . $post_length
536
+        LIMIT ' . $post_start.', '.$post_length
537 537
     );
538 538
     foreach ($rows as $record) {
539 539
         // Get itemKey from current user
540 540
         $currentUserKey = DB::queryFirstRow(
541 541
             'SELECT share_key
542
-            FROM ' . prefixTable('sharekeys_fields') . '
542
+            FROM ' . prefixTable('sharekeys_fields').'
543 543
             WHERE object_id = %i AND user_id = %i',
544 544
             $record['id'],
545 545
             $extra_arguments['owner_id']
@@ -567,7 +567,7 @@  discard block
 block discarded – undo
567 567
                 if ((int) $post_user_id !== (int) $extra_arguments['owner_id']) {
568 568
                     $currentUserKey = DB::queryFirstRow(
569 569
                         'SELECT increment_id
570
-                        FROM ' . prefixTable('sharekeys_items') . '
570
+                        FROM ' . prefixTable('sharekeys_items').'
571 571
                         WHERE object_id = %i AND user_id = %i',
572 572
                         $record['id'],
573 573
                         $post_user_id
@@ -590,7 +590,7 @@  discard block
 block discarded – undo
590 590
     // SHould we change step?
591 591
     DB::query(
592 592
         'SELECT *
593
-        FROM ' . prefixTable('categories_items') . '
593
+        FROM ' . prefixTable('categories_items').'
594 594
         WHERE encryption_type = "teampass_aes"'
595 595
     );
596 596
 
@@ -630,14 +630,14 @@  discard block
 block discarded – undo
630 630
     // Loop on suggestions
631 631
     $rows = DB::query(
632 632
         'SELECT id
633
-        FROM ' . prefixTable('suggestion') . '
634
-        LIMIT ' . $post_start . ', ' . $post_length
633
+        FROM ' . prefixTable('suggestion').'
634
+        LIMIT ' . $post_start.', '.$post_length
635 635
     );
636 636
     foreach ($rows as $record) {
637 637
         // Get itemKey from current user
638 638
         $currentUserKey = DB::queryFirstRow(
639 639
             'SELECT share_key
640
-            FROM ' . prefixTable('sharekeys_suggestions') . '
640
+            FROM ' . prefixTable('sharekeys_suggestions').'
641 641
             WHERE object_id = %i AND user_id = %i',
642 642
             $record['id'],
643 643
             $extra_arguments['owner_id']
@@ -669,7 +669,7 @@  discard block
 block discarded – undo
669 669
             if ((int) $post_user_id !== (int) $extra_arguments['owner_id']) {
670 670
                 $currentUserKey = DB::queryFirstRow(
671 671
                     'SELECT increment_id
672
-                    FROM ' . prefixTable('sharekeys_items') . '
672
+                    FROM ' . prefixTable('sharekeys_items').'
673 673
                     WHERE object_id = %i AND user_id = %i',
674 674
                     $record['id'],
675 675
                     $post_user_id
@@ -729,16 +729,16 @@  discard block
 block discarded – undo
729 729
     // Loop on files
730 730
     $rows = DB::query(
731 731
         'SELECT f.id AS id, i.perso AS perso
732
-        FROM ' . prefixTable('files') . ' AS f
733
-        INNER JOIN ' . prefixTable('items') . ' AS i ON i.id = f.id_item
734
-        WHERE f.status = "' . TP_ENCRYPTION_NAME . '"
735
-        LIMIT ' . $post_start . ', ' . $post_length
732
+        FROM ' . prefixTable('files').' AS f
733
+        INNER JOIN ' . prefixTable('items').' AS i ON i.id = f.id_item
734
+        WHERE f.status = "' . TP_ENCRYPTION_NAME.'"
735
+        LIMIT ' . $post_start.', '.$post_length
736 736
     ); //aes_encryption
737 737
     foreach ($rows as $record) {
738 738
         // Get itemKey from current user
739 739
         $currentUserKey = DB::queryFirstRow(
740 740
             'SELECT share_key, increment_id
741
-            FROM ' . prefixTable('sharekeys_files') . '
741
+            FROM ' . prefixTable('sharekeys_files').'
742 742
             WHERE object_id = %i AND user_id = %i',
743 743
             $record['id'],
744 744
             (int) $record['perso'] === 0 ? $extra_arguments['owner_id'] : $extra_arguments['new_user_id']
@@ -766,7 +766,7 @@  discard block
 block discarded – undo
766 766
 
767 767
         $currentUserKey = DB::queryFirstRow(
768 768
             'SELECT increment_id
769
-            FROM ' . prefixTable('sharekeys_files') . '
769
+            FROM ' . prefixTable('sharekeys_files').'
770 770
             WHERE object_id = %i AND user_id = %i',
771 771
             $record['id'],
772 772
             $post_user_id
@@ -797,8 +797,8 @@  discard block
 block discarded – undo
797 797
     // SHould we change step? Finished ?
798 798
     DB::query(
799 799
         'SELECT *
800
-        FROM ' . prefixTable('files') . '
801
-        WHERE status = "' . TP_ENCRYPTION_NAME . '"'
800
+        FROM ' . prefixTable('files').'
801
+        WHERE status = "' . TP_ENCRYPTION_NAME.'"'
802 802
     );
803 803
     $counter = DB::count();
804 804
     $next_start = (int) $post_start + (int) $post_length;
@@ -864,7 +864,7 @@  discard block
 block discarded – undo
864 864
     // get user info
865 865
     $userInfo = DB::queryFirstRow(
866 866
         'SELECT email, login, auth_type, special, lastname, name
867
-        FROM ' . prefixTable('users') . '
867
+        FROM ' . prefixTable('users').'
868 868
         WHERE id = %i',
869 869
         $extra_arguments['new_user_id']
870 870
     );
@@ -879,10 +879,10 @@  discard block
 block discarded – undo
879 879
             filter_var($userInfo['email'], FILTER_SANITIZE_FULL_SPECIAL_CHARS),
880 880
             // @scrutinizer ignore-type
881 881
             empty($extra_arguments['email_body']) === false ? $extra_arguments['email_body'] : $lang->get('email_body_user_config_1'),
882
-            'TEAMPASS - ' . $lang->get('login_credentials'),
882
+            'TEAMPASS - '.$lang->get('login_credentials'),
883 883
             (array) filter_var_array(
884 884
                 [
885
-                    '#code#' => cryption($extra_arguments['new_user_code'], '','decrypt', $SETTINGS)['string'],
885
+                    '#code#' => cryption($extra_arguments['new_user_code'], '', 'decrypt', $SETTINGS)['string'],
886 886
                     '#lastname#' => isset($userInfo['name']) === true ? $userInfo['name'] : '',
887 887
                     '#login#' => isset($userInfo['login']) === true ? $userInfo['login'] : '',
888 888
                 ],
Please login to merge, or discard this patch.
_things/delete_background_tasks___items_handler.php 2 patches
Spacing   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -75,7 +75,7 @@  discard block
 block discarded – undo
75 75
 DB::debugmode(false);
76 76
 $process_to_perform = DB::queryFirstRow(
77 77
     'SELECT *
78
-    FROM ' . prefixTable('background_tasks') . '
78
+    FROM ' . prefixTable('background_tasks').'
79 79
     WHERE is_in_progress = %i AND process_type IN ("item_copy", "new_item", "update_item", "item_update_create_keys")
80 80
     ORDER BY increment_id ASC',
81 81
     1
@@ -93,7 +93,7 @@  discard block
 block discarded – undo
93 93
     // search for next process to handle
94 94
     $process_to_perform = DB::queryFirstRow(
95 95
         'SELECT *
96
-        FROM ' . prefixTable('background_tasks') . '
96
+        FROM ' . prefixTable('background_tasks').'
97 97
         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")
98 98
         ORDER BY increment_id ASC',
99 99
         0
@@ -111,7 +111,7 @@  discard block
 block discarded – undo
111 111
             $process_to_perform['increment_id']
112 112
         );
113 113
 
114
-        provideLog('[PROCESS][#'. $process_to_perform['increment_id'].'][START]', $SETTINGS);
114
+        provideLog('[PROCESS][#'.$process_to_perform['increment_id'].'][START]', $SETTINGS);
115 115
         handleTask(
116 116
             $process_to_perform['increment_id'],
117 117
             json_decode($process_to_perform['arguments'], true),
@@ -146,7 +146,7 @@  discard block
 block discarded – undo
146 146
         // Search if there are remaining tasks
147 147
         $process_to_perform = DB::queryFirstField(
148 148
             'SELECT 1
149
-            FROM ' . prefixTable('background_tasks') . '
149
+            FROM ' . prefixTable('background_tasks').'
150 150
             WHERE is_in_progress = %i AND process_type IN (
151 151
                 "item_copy",
152 152
                 "new_item",
@@ -185,10 +185,10 @@  discard block
 block discarded – undo
185 185
  */
186 186
 function handleTask(int $processId, array $ProcessArguments, array $SETTINGS, int $itemId = null): bool
187 187
 {
188
-    provideLog('[PROCESS][#'. $processId.'][START]', $SETTINGS);
188
+    provideLog('[PROCESS][#'.$processId.'][START]', $SETTINGS);
189 189
     $task_to_perform = DB::queryFirstRow(
190 190
         'SELECT *
191
-        FROM ' . prefixTable('background_subtasks') . '
191
+        FROM ' . prefixTable('background_subtasks').'
192 192
         WHERE task_id = %i AND finished_at IS NULL
193 193
         ORDER BY increment_id ASC',
194 194
         $processId
@@ -202,13 +202,13 @@  discard block
 block discarded – undo
202 202
         // if sub_task_in_progress === 1 then exit
203 203
         if ((int) $task_to_perform['sub_task_in_progress'] !== 0) {
204 204
             // Task is currently being in progress by another server process
205
-            provideLog('[TASK][#'. $task_to_perform['increment_id'].'][WARNING] Similar task already being processes', $SETTINGS);
205
+            provideLog('[TASK][#'.$task_to_perform['increment_id'].'][WARNING] Similar task already being processes', $SETTINGS);
206 206
             return false;
207 207
         }
208 208
 
209 209
         // handle next task
210 210
         $args = json_decode($task_to_perform['task'], true);
211
-        provideLog('[TASK][#'. $task_to_perform['increment_id'].'][START]Task '.$args['step'], $SETTINGS);
211
+        provideLog('[TASK][#'.$task_to_perform['increment_id'].'][START]Task '.$args['step'], $SETTINGS);
212 212
 
213 213
         // flag as in progress
214 214
         DB::update(
@@ -250,7 +250,7 @@  discard block
 block discarded – undo
250 250
         DB::update(
251 251
             prefixTable('background_subtasks'),
252 252
             array(
253
-                'sub_task_in_progress' => 0,    // flag sub task is no more in prgoress
253
+                'sub_task_in_progress' => 0, // flag sub task is no more in prgoress
254 254
                 'task' => json_encode(["status" => "Done"]),
255 255
                 'is_in_progress' => -1,
256 256
                 'finished_at' => time(),
@@ -265,7 +265,7 @@  discard block
 block discarded – undo
265 265
         // are all tasks done?
266 266
         DB::query(
267 267
             'SELECT *
268
-            FROM ' . prefixTable('background_subtasks') . '
268
+            FROM ' . prefixTable('background_subtasks').'
269 269
             WHERE task_id = %i AND finished_at IS NULL',
270 270
             $processId
271 271
         );
@@ -337,7 +337,7 @@  discard block
 block discarded – undo
337 337
         // Loop on all files for this item
338 338
         // and encrypt them for each user
339 339
         if (WIP === true) provideLog('[DEBUG] '.print_r($args['files_keys'], true), $SETTINGS);
340
-        foreach($args['files_keys'] as $file) {
340
+        foreach ($args['files_keys'] as $file) {
341 341
             storeUsersShareKey(
342 342
                 prefixTable('sharekeys_items'),
343 343
                 0,
@@ -353,7 +353,7 @@  discard block
 block discarded – undo
353 353
         // Loop on all encrypted fields for this item
354 354
         // and encrypt them for each user
355 355
         if (WIP === true) provideLog('[DEBUG] '.print_r($args, true), $SETTINGS);
356
-        foreach($args['fields_keys'] as $field) {
356
+        foreach ($args['fields_keys'] as $field) {
357 357
             storeUsersShareKey(
358 358
                 prefixTable('sharekeys_fields'),
359 359
                 0,
@@ -405,6 +405,6 @@  discard block
 block discarded – undo
405 405
     DB::query(
406 406
         'DELETE FROM '.prefixTable('items_edition').'
407 407
         WHERE timestamp < %i',
408
-        ($SETTINGS['delay_item_edition'] > 0) ? time() - ($SETTINGS['delay_item_edition']*60) : time() - EDITION_LOCK_PERIOD
408
+        ($SETTINGS['delay_item_edition'] > 0) ? time() - ($SETTINGS['delay_item_edition'] * 60) : time() - EDITION_LOCK_PERIOD
409 409
     );
410 410
 }
Please login to merge, or discard this patch.
Braces   +15 added lines, -6 removed lines patch added patch discarded remove patch
@@ -83,7 +83,9 @@  discard block
 block discarded – undo
83 83
 
84 84
 if (DB::count() > 0) {
85 85
     // handle tasks inside this process
86
-    if (WIP === true) error_log("Process in progress: ".$process_to_perform['increment_id']);
86
+    if (WIP === true) {
87
+        error_log("Process in progress: ".$process_to_perform['increment_id']);
88
+    }
87 89
     handleTask(
88 90
         $process_to_perform['increment_id'],
89 91
         json_decode($process_to_perform['arguments'], true),
@@ -100,7 +102,9 @@  discard block
 block discarded – undo
100 102
     );
101 103
     
102 104
     if (DB::count() > 0) {
103
-        if (WIP === true) error_log("New process ta start: ".$process_to_perform['increment_id']);
105
+        if (WIP === true) {
106
+            error_log("New process ta start: ".$process_to_perform['increment_id']);
107
+        }
104 108
         // update DB - started_at
105 109
         DB::update(
106 110
             prefixTable('background_tasks'),
@@ -153,8 +157,9 @@  discard block
 block discarded – undo
153 157
         );
154 158
 
155 159
         // No more tasks, exit
156
-        if ($process_to_perform !== 1)
157
-            break;
160
+        if ($process_to_perform !== 1) {
161
+                    break;
162
+        }
158 163
 
159 164
         // Run next task
160 165
         $process = new Symfony\Component\Process\Process([
@@ -331,7 +336,9 @@  discard block
 block discarded – undo
331 336
     if ($args['step'] === 'create_users_files_key') {
332 337
         // Loop on all files for this item
333 338
         // and encrypt them for each user
334
-        if (WIP === true) provideLog('[DEBUG] '.print_r($args['files_keys'], true), $SETTINGS);
339
+        if (WIP === true) {
340
+            provideLog('[DEBUG] '.print_r($args['files_keys'], true), $SETTINGS);
341
+        }
335 342
         foreach($args['files_keys'] as $file) {
336 343
             storeUsersShareKey(
337 344
                 prefixTable('sharekeys_items'),
@@ -347,7 +354,9 @@  discard block
 block discarded – undo
347 354
     } elseif ($args['step'] === 'create_users_fields_key') {
348 355
         // Loop on all encrypted fields for this item
349 356
         // and encrypt them for each user
350
-        if (WIP === true) provideLog('[DEBUG] '.print_r($args, true), $SETTINGS);
357
+        if (WIP === true) {
358
+            provideLog('[DEBUG] '.print_r($args, true), $SETTINGS);
359
+        }
351 360
         foreach($args['fields_keys'] as $field) {
352 361
             storeUsersShareKey(
353 362
                 prefixTable('sharekeys_fields'),
Please login to merge, or discard this patch.