Passed
Pull Request — master (#4622)
by Nils
11:13 queued 05:15
created
sources/oauth.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -2,7 +2,7 @@
 block discarded – undo
2 2
 use TeampassClasses\OAuth2Controller\OAuth2Controller;
3 3
 use TeampassClasses\SessionManager\SessionManager;
4 4
 
5
-require_once __DIR__. '/../includes/config/include.php';
5
+require_once __DIR__.'/../includes/config/include.php';
6 6
 require_once __DIR__.'/../sources/main.functions.php';
7 7
 
8 8
 // init
Please login to merge, or discard this patch.
includes/core/login.oauth2.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -32,7 +32,7 @@
 block discarded – undo
32 32
 use TeampassClasses\OAuth2Controller\OAuth2Controller;
33 33
 use TeampassClasses\SessionManager\SessionManager;
34 34
 
35
-require_once __DIR__. '/../../includes/config/include.php';
35
+require_once __DIR__.'/../../includes/config/include.php';
36 36
 require_once __DIR__.'/../../sources/main.functions.php';
37 37
 
38 38
 // init
Please login to merge, or discard this patch.
scripts/task_maintenance_purge_old_files.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -71,7 +71,7 @@  discard block
 block discarded – undo
71 71
 function purgeTemporaryFiles(): void
72 72
 {
73 73
     // Load expected files
74
-    require_once __DIR__. '/../sources/main.functions.php';
74
+    require_once __DIR__.'/../sources/main.functions.php';
75 75
 
76 76
     // $SETTINGS is set then read folder
77 77
     if (is_dir($SETTINGS['path_to_files_folder']) === true) {
@@ -80,7 +80,7 @@  discard block
 block discarded – undo
80 80
             //delete file FILES
81 81
             while (false !== ($f = readdir($dir))) {
82 82
                 if ($f !== '.' && $f !== '..' && $f !== '.htaccess') {
83
-                    $filePath = $SETTINGS['path_to_files_folder'] . '/' . $f;
83
+                    $filePath = $SETTINGS['path_to_files_folder'].'/'.$f;
84 84
                     if (file_exists($filePath) && ((time() - filectime($filePath)) > 604800)) {
85 85
                         fileDelete($filePath, $SETTINGS);
86 86
                     }
@@ -101,7 +101,7 @@  discard block
 block discarded – undo
101 101
             while (false !== ($f = readdir($dir))) {
102 102
                 if ($f !== '.' && $f !== '..') {
103 103
                     if (strpos($f, '_delete.') > 0) {
104
-                        fileDelete($SETTINGS['path_to_upload_folder'] . '/' . $f, $SETTINGS);
104
+                        fileDelete($SETTINGS['path_to_upload_folder'].'/'.$f, $SETTINGS);
105 105
                     }
106 106
                 }
107 107
             }
Please login to merge, or discard this patch.
sources/tree.php 1 patch
Spacing   +19 added lines, -19 removed lines patch added patch discarded remove patch
@@ -64,7 +64,7 @@  discard block
 block discarded – undo
64 64
 ) {
65 65
     // Not allowed page
66 66
     $session->set('system-error_code', ERR_NOT_ALLOWED);
67
-    include $SETTINGS['cpassman_dir'] . '/error.php';
67
+    include $SETTINGS['cpassman_dir'].'/error.php';
68 68
     exit;
69 69
 }
70 70
 
@@ -125,7 +125,7 @@  discard block
 block discarded – undo
125 125
 );
126 126
 
127 127
 $lastFolderChange = DB::queryfirstrow(
128
-    'SELECT valeur FROM ' . prefixTable('misc') . '
128
+    'SELECT valeur FROM '.prefixTable('misc').'
129 129
     WHERE type = %s AND intitule = %s',
130 130
     'timestamp',
131 131
     'last_folder_change'
@@ -346,7 +346,7 @@  discard block
 block discarded – undo
346 346
         $nbItemsInSubfolders = (int) $node->nb_items_in_subfolders;
347 347
         $nbItemsInFolder = (int) $node->nb_items_in_folder;
348 348
         $nbSubfolders = (int) $node->nb_subfolders;
349
-        break;  // Get out as soon as we find a valid node.
349
+        break; // Get out as soon as we find a valid node.
350 350
     }
351 351
     
352 352
     if ($displayThisNode === true) {
@@ -458,7 +458,7 @@  discard block
 block discarded – undo
458 458
         foreach ($currentNode->children as $child) {
459 459
             recursiveTree(
460 460
                 (int) $child,
461
-                $tree->getNode($child),// get node info for this child
461
+                $tree->getNode($child), // get node info for this child
462 462
                 /** @scrutinizer ignore-type */ $tree,
463 463
                 $listFoldersLimitedKeys,
464 464
                 $listRestrictedFoldersForItemsKeys,
@@ -505,7 +505,7 @@  discard block
 block discarded – undo
505 505
     $lang = new Language($session->get('user-language') ?? 'english');
506 506
 
507 507
     // prepare json return for current node
508
-    $parent = $currentNode->parent_id === '0' ? '#' : 'li_' . $currentNode->parent_id;
508
+    $parent = $currentNode->parent_id === '0' ? '#' : 'li_'.$currentNode->parent_id;
509 509
 
510 510
     // handle displaying
511 511
     if (isKeyExistingAndEqual('show_only_accessible_folders', 1, $SETTINGS) === true) {
@@ -522,17 +522,17 @@  discard block
 block discarded – undo
522 522
         array_push(
523 523
             $ret_json,
524 524
             array(
525
-                'id' => 'li_' . $nodeId,
525
+                'id' => 'li_'.$nodeId,
526 526
                 'parent' => $last_visible_parent === -1 ? $parent : $last_visible_parent,
527 527
                 'text' => '<i class="'.$currentNode->fa_icon.' tree-folder mr-2" data-folder="'.$currentNode->fa_icon.'"  data-folder-selected="'.$currentNode->fa_icon_selected.'"></i>'.$text.htmlspecialchars($currentNode->title).$nodeData['html'],
528 528
                 'li_attr' => array(
529 529
                     'class' => 'jstreeopen',
530
-                    'title' => 'ID [' . $nodeId . '] ' . $nodeData['title'],
530
+                    'title' => 'ID ['.$nodeId.'] '.$nodeData['title'],
531 531
                 ),
532 532
                 'a_attr' => array(
533
-                    'id' => 'fld_' . $nodeId,
533
+                    'id' => 'fld_'.$nodeId,
534 534
                     'class' => $nodeData['folderClass'],
535
-                    'onclick' => 'ListerItems(' . $nodeId . ', ' . $nodeData['restricted'] . ', 0, 1)',
535
+                    'onclick' => 'ListerItems('.$nodeId.', '.$nodeData['restricted'].', 0, 1)',
536 536
                     'data-title' => htmlspecialchars($currentNode->title),
537 537
                 ),
538 538
                 'is_pf' => in_array($nodeId, $inputData['personalFolders']) === true ? 1 : 0,
@@ -548,12 +548,12 @@  discard block
 block discarded – undo
548 548
         array_push(
549 549
             $ret_json,
550 550
             array(
551
-                'id' => 'li_' . $nodeId,
551
+                'id' => 'li_'.$nodeId,
552 552
                 'parent' => $last_visible_parent === -1 ? $parent : $last_visible_parent,
553 553
                 'text' => '<i class="'.$currentNode->fa_icon.' tree-folder mr-2" data-folder="'.$currentNode->fa_icon.'"  data-folder-selected="'.$currentNode->fa_icon_selected.'"></i>'.'<i class="fas fa-times fa-xs text-danger mr-1 ml-1"></i>'.$text.htmlspecialchars($currentNode->title).$nodeData['html'],
554 554
                 'li_attr' => array(
555 555
                     'class' => '',
556
-                    'title' => 'ID [' . $nodeId . '] ' . $lang->get('no_access'),
556
+                    'title' => 'ID ['.$nodeId.'] '.$lang->get('no_access'),
557 557
                 ),
558 558
             )
559 559
         );
@@ -613,7 +613,7 @@  discard block
 block discarded – undo
613 613
         if (in_array($nodeId, $session_read_only_folders) === true) {
614 614
             return [
615 615
                 'html' => '<i class="far fa-eye fa-xs mr-1 ml-1"></i>'.
616
-                    ($tree_counters === 1 ? '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . $nbItemsInFolder .'/'.$nbItemsInSubfolders .'/'.$nbSubfolders. '</span>'  : ''),
616
+                    ($tree_counters === 1 ? '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.$nbItemsInFolder.'/'.$nbItemsInSubfolders.'/'.$nbSubfolders.'</span>' : ''),
617 617
                 'title' => $lang->get('read_only_account'),
618 618
                 'restricted' => 1,
619 619
                 'folderClass' => 'folder_not_droppable',
@@ -628,7 +628,7 @@  discard block
 block discarded – undo
628 628
         ) {
629 629
             return [
630 630
                 'html' => '<i class="far fa-eye fa-xs mr-1"></i>'.
631
-                    ($tree_counters === 1 ? '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . $nbItemsInFolder .'/'.$nbItemsInSubfolders .'/'.$nbSubfolders. '</span>'  : ''),
631
+                    ($tree_counters === 1 ? '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.$nbItemsInFolder.'/'.$nbItemsInSubfolders.'/'.$nbSubfolders.'</span>' : ''),
632 632
                 'title' => $lang->get('read_only_account'),
633 633
                 'restricted' => 0,
634 634
                 'folderClass' => 'folder',
@@ -639,7 +639,7 @@  discard block
 block discarded – undo
639 639
         }
640 640
         
641 641
         return [
642
-            'html' => ($tree_counters === 1 ? '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . $nbItemsInFolder .'/'.$nbItemsInSubfolders .'/'.$nbSubfolders. '</span>'  : ''),
642
+            'html' => ($tree_counters === 1 ? '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.$nbItemsInFolder.'/'.$nbItemsInSubfolders.'/'.$nbSubfolders.'</span>' : ''),
643 643
             'title' => '',
644 644
             'restricted' => 0,
645 645
             'folderClass' => 'folder',
@@ -650,8 +650,8 @@  discard block
 block discarded – undo
650 650
 
651 651
     } elseif (in_array($nodeId, $listFoldersLimitedKeys) === true) {
652 652
         return [
653
-            'html' => ($session_user_read_only === true ? '<i class="far fa-eye fa-xs mr-1"></i>' : '') .
654
-                ($tree_counters === 1 ? '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . count($session_list_folders_limited[$nodeId]) . '</span>' : ''),
653
+            'html' => ($session_user_read_only === true ? '<i class="far fa-eye fa-xs mr-1"></i>' : '').
654
+                ($tree_counters === 1 ? '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.count($session_list_folders_limited[$nodeId]).'</span>' : ''),
655 655
             'title' => '',
656 656
             'restricted' => 1,
657 657
             'folderClass' => 'folder',
@@ -662,8 +662,8 @@  discard block
 block discarded – undo
662 662
 
663 663
     } elseif (in_array($nodeId, $listRestrictedFoldersForItemsKeys) === true) {
664 664
         return [
665
-            'html' => $session_user_read_only === true ? '<i class="far fa-eye fa-xs mr-1"></i>' : '' .
666
-                '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . count($session_list_restricted_folders_for_items[$nodeId]) . '</span>',
665
+            'html' => $session_user_read_only === true ? '<i class="far fa-eye fa-xs mr-1"></i>' : ''.
666
+                '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.count($session_list_restricted_folders_for_items[$nodeId]).'</span>',
667 667
             'title' => '',
668 668
             'restricted' => 1,
669 669
             'folderClass' => 'folder',
@@ -773,7 +773,7 @@  discard block
 block discarded – undo
773 773
     // Does this user has a tree cache
774 774
     $userCacheTree = DB::queryfirstrow(
775 775
         'SELECT data
776
-        FROM ' . prefixTable('cache_tree') . '
776
+        FROM ' . prefixTable('cache_tree').'
777 777
         WHERE user_id = %i',
778 778
         $userId
779 779
     );
Please login to merge, or discard this patch.
sources/main.queries.php 2 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -830,7 +830,7 @@
 block discarded – undo
830 830
                 'encode'
831 831
             );
832 832
 
833
-         /*
833
+            /*
834 834
          * Generate BUG report
835 835
          */
836 836
         case 'generate_bug_report'://action_system
Please login to merge, or discard this patch.
Spacing   +105 added lines, -105 removed lines patch added patch discarded remove patch
@@ -81,7 +81,7 @@  discard block
 block discarded – undo
81 81
 ) {
82 82
     // Not allowed page
83 83
     $session->set('system-error_code', ERR_NOT_ALLOWED);
84
-    include $SETTINGS['cpassman_dir'] . '/error.php';
84
+    include $SETTINGS['cpassman_dir'].'/error.php';
85 85
     exit;
86 86
 }
87 87
 
@@ -269,7 +269,7 @@  discard block
 block discarded – undo
269 269
 
270 270
             // Get current user hash
271 271
             $userHash = DB::queryFirstRow(
272
-                "SELECT pw FROM " . prefixtable('users') . " WHERE id = %d;",
272
+                "SELECT pw FROM ".prefixtable('users')." WHERE id = %d;",
273 273
                 $session->get('user-id')
274 274
             )['pw'];
275 275
 
@@ -325,7 +325,7 @@  discard block
 block discarded – undo
325 325
  * @param string $post_key
326 326
  * @return string
327 327
  */
328
-function userHandler(string $post_type, array|null|string $dataReceived, array $SETTINGS, string $post_key): string
328
+function userHandler(string $post_type, array | null | string $dataReceived, array $SETTINGS, string $post_key): string
329 329
 {
330 330
     $session = SessionManager::getSession();
331 331
 
@@ -360,7 +360,7 @@  discard block
 block discarded – undo
360 360
     if (isset($dataReceived['user_id'])) {
361 361
         // Get info about user to modify
362 362
         $targetUserInfos = DB::queryfirstrow(
363
-            'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM ' . prefixTable('users') . '
363
+            'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM '.prefixTable('users').'
364 364
             WHERE id = %i',
365 365
             $dataReceived['user_id']
366 366
         );
@@ -509,7 +509,7 @@  discard block
 block discarded – undo
509 509
         case 'mail_me'://action_mail
510 510
             // Get info about user to send email
511 511
             $data_user = DB::queryfirstrow(
512
-                'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM ' . prefixTable('users') . '
512
+                'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM '.prefixTable('users').'
513 513
                 WHERE email = %s',
514 514
                 filter_var($dataReceived['receipt'], FILTER_SANITIZE_FULL_SPECIAL_CHARS)
515 515
             );
@@ -622,7 +622,7 @@  discard block
 block discarded – undo
622 622
     if (isset($dataReceived['user_id'])) {
623 623
         // Get info about user to modify
624 624
         $targetUserInfos = DB::queryfirstrow(
625
-            'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM ' . prefixTable('users') . '
625
+            'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM '.prefixTable('users').'
626 626
             WHERE id = %i',
627 627
             $dataReceived['user_id']
628 628
         );
@@ -701,7 +701,7 @@  discard block
 block discarded – undo
701 701
 
702 702
             // Get current user hash
703 703
             $userHash = DB::queryFirstRow(
704
-                "SELECT pw FROM " . prefixtable('users') . " WHERE id = %d;",
704
+                "SELECT pw FROM ".prefixtable('users')." WHERE id = %d;",
705 705
                 $session->get('user-id')
706 706
             )['pw'];
707 707
 
@@ -739,7 +739,7 @@  discard block
 block discarded – undo
739 739
 
740 740
                 // Get current user hash
741 741
                 $userHash = DB::queryFirstRow(
742
-                    "SELECT pw FROM " . prefixtable('users') . " WHERE id = %d;",
742
+                    "SELECT pw FROM ".prefixtable('users')." WHERE id = %d;",
743 743
                     $session->get('user-id')
744 744
                 )['pw'];
745 745
 
@@ -783,7 +783,7 @@  discard block
 block discarded – undo
783 783
 
784 784
                 // Get current user hash
785 785
                 $userHash = DB::queryFirstRow(
786
-                    "SELECT pw FROM " . prefixtable('users') . " WHERE id = %i;",
786
+                    "SELECT pw FROM ".prefixtable('users')." WHERE id = %i;",
787 787
                     $session->get('user-id')
788 788
                 )['pw'];
789 789
 
@@ -827,7 +827,7 @@  discard block
 block discarded – undo
827 827
  * @param array $SETTINGS
828 828
  * @return string
829 829
  */
830
-function systemHandler(string $post_type, array|null|string $dataReceived, array $SETTINGS): string
830
+function systemHandler(string $post_type, array | null | string $dataReceived, array $SETTINGS): string
831 831
 {
832 832
     $session = SessionManager::getSession();
833 833
     switch ($post_type) {
@@ -928,7 +928,7 @@  discard block
 block discarded – undo
928 928
                 )
929 929
             );
930 930
 
931
-            return '[{"token" : "' . $token . '"}]';
931
+            return '[{"token" : "'.$token.'"}]';
932 932
 
933 933
         /*
934 934
         * Default case
@@ -944,7 +944,7 @@  discard block
 block discarded – undo
944 944
 }
945 945
 
946 946
 
947
-function utilsHandler(string $post_type, array|null|string $dataReceived, array $SETTINGS): string
947
+function utilsHandler(string $post_type, array | null | string $dataReceived, array $SETTINGS): string
948 948
 {
949 949
     switch ($post_type) {
950 950
         /*
@@ -1013,7 +1013,7 @@  discard block
 block discarded – undo
1013 1013
         array(
1014 1014
             'error' => false,
1015 1015
             'timestamp' => $session->get('user-session_duration'),
1016
-            'max_time_to_add' => intdiv((($maximum_session_expiration_time*60) - ((int) $session->get('user-session_duration') - time())), 60),
1016
+            'max_time_to_add' => intdiv((($maximum_session_expiration_time * 60) - ((int) $session->get('user-session_duration') - time())), 60),
1017 1017
             'max_session_duration' => $maximum_session_expiration_time,
1018 1018
         ),
1019 1019
         'encode'
@@ -1065,7 +1065,7 @@  discard block
 block discarded – undo
1065 1065
     // get number of items
1066 1066
     DB::queryFirstRow(
1067 1067
         'SELECT increment_id
1068
-        FROM ' . prefixTable('sharekeys_items') .
1068
+        FROM ' . prefixTable('sharekeys_items').
1069 1069
         ' WHERE user_id = %i',
1070 1070
         $userId
1071 1071
     );
@@ -1120,7 +1120,7 @@  discard block
 block discarded – undo
1120 1120
         // check if expected security level is reached
1121 1121
         $dataUser = DB::queryfirstrow(
1122 1122
             'SELECT *
1123
-            FROM ' . prefixTable('users') . ' WHERE id = %i',
1123
+            FROM ' . prefixTable('users').' WHERE id = %i',
1124 1124
             $post_user_id
1125 1125
         );
1126 1126
 
@@ -1141,8 +1141,8 @@  discard block
 block discarded – undo
1141 1141
         if (empty($dataUser['fonction_id']) === false) {
1142 1142
             $data = DB::queryFirstRow(
1143 1143
                 'SELECT complexity
1144
-                FROM ' . prefixTable('roles_title') . '
1145
-                WHERE id IN (' . $dataUser['fonction_id'] . ')
1144
+                FROM ' . prefixTable('roles_title').'
1145
+                WHERE id IN (' . $dataUser['fonction_id'].')
1146 1146
                 ORDER BY complexity DESC'
1147 1147
             );
1148 1148
         } else {
@@ -1155,8 +1155,8 @@  discard block
 block discarded – undo
1155 1155
             return prepareExchangedData(
1156 1156
                 array(
1157 1157
                     'error' => true,
1158
-                    'message' => '<div style="margin:10px 0 10px 15px;">' . $lang->get('complexity_level_not_reached') . '.<br>' .
1159
-                        $lang->get('expected_complexity_level') . ': <b>' . TP_PW_COMPLEXITY[$data['complexity']][1] . '</b></div>',
1158
+                    'message' => '<div style="margin:10px 0 10px 15px;">'.$lang->get('complexity_level_not_reached').'.<br>'.
1159
+                        $lang->get('expected_complexity_level').': <b>'.TP_PW_COMPLEXITY[$data['complexity']][1].'</b></div>',
1160 1160
                 ),
1161 1161
                 'encode'
1162 1162
             );
@@ -1260,14 +1260,14 @@  discard block
 block discarded – undo
1260 1260
         // Get data about user
1261 1261
         $dataUser = DB::queryfirstrow(
1262 1262
             'SELECT id, email, pw
1263
-            FROM ' . prefixTable('users') . '
1263
+            FROM ' . prefixTable('users').'
1264 1264
             WHERE login = %s',
1265 1265
             $post_login
1266 1266
         );
1267 1267
     } else {
1268 1268
         $dataUser = DB::queryfirstrow(
1269 1269
             'SELECT id, login, email, pw
1270
-            FROM ' . prefixTable('users') . '
1270
+            FROM ' . prefixTable('users').'
1271 1271
             WHERE id = %i',
1272 1272
             $post_id
1273 1273
         );
@@ -1321,7 +1321,7 @@  discard block
 block discarded – undo
1321 1321
     // Check if token already used
1322 1322
     $dataToken = DB::queryfirstrow(
1323 1323
         'SELECT end_timestamp, reason
1324
-        FROM ' . prefixTable('tokens') . '
1324
+        FROM ' . prefixTable('tokens').'
1325 1325
         WHERE token = %s AND user_id = %i',
1326 1326
         $post_token,
1327 1327
         $dataUser['id']
@@ -1332,11 +1332,11 @@  discard block
 block discarded – undo
1332 1332
         return prepareExchangedData(
1333 1333
             array(
1334 1334
                 'error' => true,
1335
-                'message' => 'TOKEN already used',//$lang->get('no_email_set'),
1335
+                'message' => 'TOKEN already used', //$lang->get('no_email_set'),
1336 1336
             ),
1337 1337
             'encode'
1338 1338
         );
1339
-    } elseif(DB::count() === 0) {
1339
+    } elseif (DB::count() === 0) {
1340 1340
         // Store token for this action
1341 1341
         DB::insert(
1342 1342
             prefixTable('tokens'),
@@ -1398,7 +1398,7 @@  discard block
 block discarded – undo
1398 1398
                 'email' => $dataUser['email'],
1399 1399
                 'email_result' => str_replace(
1400 1400
                     '#email#',
1401
-                    '<b>' . obfuscateEmail($dataUser['email']) . '</b>',
1401
+                    '<b>'.obfuscateEmail($dataUser['email']).'</b>',
1402 1402
                     addslashes($lang->get('admin_email_result_ok'))
1403 1403
                 ),
1404 1404
             ),
@@ -1414,7 +1414,7 @@  discard block
 block discarded – undo
1414 1414
             'email' => $dataUser['email'],
1415 1415
             'email_result' => str_replace(
1416 1416
                 '#email#',
1417
-                '<b>' . obfuscateEmail($dataUser['email']) . '</b>',
1417
+                '<b>'.obfuscateEmail($dataUser['email']).'</b>',
1418 1418
                 addslashes($lang->get('admin_email_result_ok'))
1419 1419
             ),
1420 1420
         ),
@@ -1431,7 +1431,7 @@  discard block
 block discarded – undo
1431 1431
 
1432 1432
     if (isKeyExistingAndEqual('enable_send_email_on_user_login', 1, $SETTINGS) === true) {
1433 1433
         $row = DB::queryFirstRow(
1434
-            'SELECT valeur FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s',
1434
+            'SELECT valeur FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s',
1435 1435
             'cron',
1436 1436
             'sending_emails'
1437 1437
         );
@@ -1439,7 +1439,7 @@  discard block
 block discarded – undo
1439 1439
         if ((int) (time() - $row['valeur']) >= 300 || (int) $row['valeur'] === 0) {
1440 1440
             $rows = DB::query(
1441 1441
                 'SELECT *
1442
-                FROM ' . prefixTable('emails') .
1442
+                FROM ' . prefixTable('emails').
1443 1443
                 ' WHERE status != %s',
1444 1444
                 'sent'
1445 1445
             );
@@ -1491,8 +1491,8 @@  discard block
 block discarded – undo
1491 1491
     $arr_html = array();
1492 1492
     $rows = DB::query(
1493 1493
         'SELECT i.id AS id, i.label AS label, i.id_tree AS id_tree, l.date, i.perso AS perso, i.restricted_to AS restricted
1494
-        FROM ' . prefixTable('log_items') . ' AS l
1495
-        RIGHT JOIN ' . prefixTable('items') . ' AS i ON (l.id_item = i.id)
1494
+        FROM ' . prefixTable('log_items').' AS l
1495
+        RIGHT JOIN ' . prefixTable('items').' AS i ON (l.id_item = i.id)
1496 1496
         WHERE l.action = %s AND l.id_user = %i
1497 1497
         ORDER BY l.date DESC
1498 1498
         LIMIT 0, 100',
@@ -1524,7 +1524,7 @@  discard block
 block discarded – undo
1524 1524
     if (isKeyExistingAndEqual('enable_suggestion', 1, $SETTINGS) === true
1525 1525
         && ((int) $session->get('user-admin') === 1 || (int) $session->get('user-manager') === 1)
1526 1526
     ) {
1527
-        DB::query('SELECT * FROM ' . prefixTable('suggestion'));
1527
+        DB::query('SELECT * FROM '.prefixTable('suggestion'));
1528 1528
         $nb_suggestions_waiting = DB::count();
1529 1529
     }
1530 1530
 
@@ -1559,13 +1559,13 @@  discard block
 block discarded – undo
1559 1559
             if ($data === 'stat_languages') {
1560 1560
                 $tmp = '';
1561 1561
                 foreach ($stats_data[$data] as $key => $value) {
1562
-                    $tmp .= $tmp === '' ? $key . '-' . $value : ',' . $key . '-' . $value;
1562
+                    $tmp .= $tmp === '' ? $key.'-'.$value : ','.$key.'-'.$value;
1563 1563
                 }
1564 1564
                 $statsToSend[$data] = $tmp;
1565 1565
             } elseif ($data === 'stat_country') {
1566 1566
                 $tmp = '';
1567 1567
                 foreach ($stats_data[$data] as $key => $value) {
1568
-                    $tmp .= $tmp === '' ? $key . '-' . $value : ',' . $key . '-' . $value;
1568
+                    $tmp .= $tmp === '' ? $key.'-'.$value : ','.$key.'-'.$value;
1569 1569
                 }
1570 1570
                 $statsToSend[$data] = $tmp;
1571 1571
             } else {
@@ -1652,7 +1652,7 @@  discard block
 block discarded – undo
1652 1652
             $url_found = $value;
1653 1653
             if (empty($url_found) === false) {
1654 1654
                 $tmp = parse_url($url_found);
1655
-                $anonym_url = $tmp['scheme'] . '://<anonym_url>' . (isset($tmp['path']) === true ? $tmp['path'] : '');
1655
+                $anonym_url = $tmp['scheme'].'://<anonym_url>'.(isset($tmp['path']) === true ? $tmp['path'] : '');
1656 1656
                 $value = $anonym_url;
1657 1657
             } else {
1658 1658
                 $value = '';
@@ -1682,7 +1682,7 @@  discard block
 block discarded – undo
1682 1682
     $teampass_errors = '';
1683 1683
     $rows = DB::query(
1684 1684
         'SELECT label, date AS error_date
1685
-        FROM ' . prefixTable('log_system') . "
1685
+        FROM ' . prefixTable('log_system')."
1686 1686
         WHERE `type` LIKE 'error'
1687 1687
         ORDER BY `date` DESC
1688 1688
         LIMIT 0, 10"
@@ -1690,9 +1690,9 @@  discard block
 block discarded – undo
1690 1690
     if (DB::count() > 0) {
1691 1691
         foreach ($rows as $record) {
1692 1692
             if (empty($teampass_errors) === true) {
1693
-                $teampass_errors = ' * ' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['error_date']) . ' - ' . $record['label'];
1693
+                $teampass_errors = ' * '.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['error_date']).' - '.$record['label'];
1694 1694
             } else {
1695
-                $teampass_errors .= ' * ' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['error_date']) . ' - ' . $record['label'];
1695
+                $teampass_errors .= ' * '.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['error_date']).' - '.$record['label'];
1696 1696
             }
1697 1697
         }
1698 1698
     }
@@ -1701,7 +1701,7 @@  discard block
 block discarded – undo
1701 1701
 
1702 1702
     // Now prepare text
1703 1703
     $txt = '### Page on which it happened
1704
-' . $data['current_page'] . '
1704
+' . $data['current_page'].'
1705 1705
 
1706 1706
 ### Steps to reproduce
1707 1707
 1.
@@ -1716,39 +1716,39 @@  discard block
 block discarded – undo
1716 1716
 Tell us what happens instead
1717 1717
 
1718 1718
 ### Server configuration
1719
-**Operating system**: ' . php_uname() . '
1719
+**Operating system**: ' . php_uname().'
1720 1720
 
1721
-**Web server:** ' . $_SERVER['SERVER_SOFTWARE'] . '
1721
+**Web server:** ' . $_SERVER['SERVER_SOFTWARE'].'
1722 1722
 
1723
-**Database:** ' . ($link === false ? $lang->get('undefined') : mysqli_get_server_info($link)) . '
1723
+**Database:** ' . ($link === false ? $lang->get('undefined') : mysqli_get_server_info($link)).'
1724 1724
 
1725
-**PHP version:** ' . PHP_VERSION . '
1725
+**PHP version:** ' . PHP_VERSION.'
1726 1726
 
1727
-**Teampass version:** ' . TP_VERSION . '.' . TP_VERSION_MINOR . '
1727
+**Teampass version:** ' . TP_VERSION.'.'.TP_VERSION_MINOR.'
1728 1728
 
1729 1729
 **Teampass configuration variables:**
1730 1730
 ```
1731
-' . $list_of_options . '
1731
+' . $list_of_options.'
1732 1732
 ```
1733 1733
 
1734 1734
 **Updated from an older Teampass or fresh install:**
1735 1735
 
1736 1736
 ### Client configuration
1737 1737
 
1738
-**Browser:** ' . $data['browser_name'] . ' - ' . $data['browser_version'] . '
1738
+**Browser:** ' . $data['browser_name'].' - '.$data['browser_version'].'
1739 1739
 
1740
-**Operating system:** ' . $data['os'] . ' - ' . $data['os_archi'] . 'bits
1740
+**Operating system:** ' . $data['os'].' - '.$data['os_archi'].'bits
1741 1741
 
1742 1742
 ### Logs
1743 1743
 
1744 1744
 #### Web server error log
1745 1745
 ```
1746
-' . $err['message'] . ' - ' . $err['file'] . ' (' . $err['line'] . ')
1746
+' . $err['message'].' - '.$err['file'].' ('.$err['line'].')
1747 1747
 ```
1748 1748
 
1749 1749
 #### Teampass 10 last system errors
1750 1750
 ```
1751
-' . $teampass_errors . '
1751
+' . $teampass_errors.'
1752 1752
 ```
1753 1753
 
1754 1754
 #### Log from the web-browser developer console (CTRL + SHIFT + i)
@@ -1788,7 +1788,7 @@  discard block
 block discarded – undo
1788 1788
         // Check if user exists
1789 1789
         $userInfo = DB::queryFirstRow(
1790 1790
             'SELECT public_key, private_key, pw, auth_type
1791
-            FROM ' . prefixTable('users') . '
1791
+            FROM ' . prefixTable('users').'
1792 1792
             WHERE id = %i',
1793 1793
             $post_user_id
1794 1794
         );
@@ -1797,9 +1797,9 @@  discard block
 block discarded – undo
1797 1797
             // Get one item
1798 1798
             $currentUserKey = DB::queryFirstRow(
1799 1799
                 'SELECT object_id, share_key, increment_id
1800
-                FROM ' . prefixTable('sharekeys_items') . ' AS si
1801
-                INNER JOIN ' . prefixTable('items') . ' AS i ON  (i.id = si.object_id)
1802
-                INNER JOIN ' . prefixTable('nested_tree') . ' AS nt ON  (i.id_tree = nt.id)
1800
+                FROM ' . prefixTable('sharekeys_items').' AS si
1801
+                INNER JOIN ' . prefixTable('items').' AS i ON  (i.id = si.object_id)
1802
+                INNER JOIN ' . prefixTable('nested_tree').' AS nt ON  (i.id_tree = nt.id)
1803 1803
                 WHERE user_id = %i AND nt.personal_folder = %i',
1804 1804
                 $post_user_id,
1805 1805
                 0
@@ -1893,7 +1893,7 @@  discard block
 block discarded – undo
1893 1893
         // Get user info
1894 1894
         $userData = DB::queryFirstRow(
1895 1895
             'SELECT private_key
1896
-            FROM ' . prefixTable('users') . '
1896
+            FROM ' . prefixTable('users').'
1897 1897
             WHERE id = %i',
1898 1898
             $post_user_id
1899 1899
         );
@@ -1974,7 +1974,7 @@  discard block
 block discarded – undo
1974 1974
         // Get user info
1975 1975
         $userData = DB::queryFirstRow(
1976 1976
             'SELECT email, auth_type, login
1977
-            FROM ' . prefixTable('users') . '
1977
+            FROM ' . prefixTable('users').'
1978 1978
             WHERE id = %i',
1979 1979
             $post_user_id
1980 1980
         );
@@ -2072,7 +2072,7 @@  discard block
 block discarded – undo
2072 2072
         // Get user info
2073 2073
         $userData = DB::queryFirstRow(
2074 2074
             'SELECT email, auth_type, login
2075
-            FROM ' . prefixTable('users') . '
2075
+            FROM ' . prefixTable('users').'
2076 2076
             WHERE id = %i',
2077 2077
             $post_user_id
2078 2078
         );
@@ -2138,7 +2138,7 @@  discard block
 block discarded – undo
2138 2138
         // Check if user exists
2139 2139
         DB::queryFirstRow(
2140 2140
             'SELECT *
2141
-            FROM ' . prefixTable('users') . '
2141
+            FROM ' . prefixTable('users').'
2142 2142
             WHERE id = %i',
2143 2143
             $post_user_id
2144 2144
         );
@@ -2208,7 +2208,7 @@  discard block
 block discarded – undo
2208 2208
         // Check if user exists
2209 2209
         $userInfo = DB::queryFirstRow(
2210 2210
             'SELECT public_key
2211
-            FROM ' . prefixTable('users') . '
2211
+            FROM ' . prefixTable('users').'
2212 2212
             WHERE id = %i',
2213 2213
             $post_user_id
2214 2214
         );
@@ -2356,15 +2356,15 @@  discard block
 block discarded – undo
2356 2356
     // Loop on items
2357 2357
     $rows = DB::query(
2358 2358
         'SELECT id, pw
2359
-        FROM ' . prefixTable('items') . '
2359
+        FROM ' . prefixTable('items').'
2360 2360
         WHERE perso = 0
2361
-        LIMIT ' . $post_start . ', ' . $post_length
2361
+        LIMIT ' . $post_start.', '.$post_length
2362 2362
     );
2363 2363
     foreach ($rows as $record) {
2364 2364
         // Get itemKey from current user
2365 2365
         $currentUserKey = DB::queryFirstRow(
2366 2366
             'SELECT share_key, increment_id
2367
-            FROM ' . prefixTable('sharekeys_items') . '
2367
+            FROM ' . prefixTable('sharekeys_items').'
2368 2368
             WHERE object_id = %i AND user_id = %i',
2369 2369
             $record['id'],
2370 2370
             $session->get('user-id')
@@ -2396,7 +2396,7 @@  discard block
 block discarded – undo
2396 2396
             if ((int) $post_user_id !== (int) $session->get('user-id')) {
2397 2397
                 $currentUserKey = DB::queryFirstRow(
2398 2398
                     'SELECT increment_id
2399
-                    FROM ' . prefixTable('sharekeys_items') . '
2399
+                    FROM ' . prefixTable('sharekeys_items').'
2400 2400
                     WHERE object_id = %i AND user_id = %i',
2401 2401
                     $record['id'],
2402 2402
                     $post_user_id
@@ -2429,7 +2429,7 @@  discard block
 block discarded – undo
2429 2429
     // SHould we change step?
2430 2430
     DB::query(
2431 2431
         'SELECT *
2432
-        FROM ' . prefixTable('items') . '
2432
+        FROM ' . prefixTable('items').'
2433 2433
         WHERE perso = 0'
2434 2434
     );
2435 2435
 
@@ -2454,15 +2454,15 @@  discard block
 block discarded – undo
2454 2454
     // Loop on logs
2455 2455
     $rows = DB::query(
2456 2456
         'SELECT increment_id
2457
-        FROM ' . prefixTable('log_items') . '
2457
+        FROM ' . prefixTable('log_items').'
2458 2458
         WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes"
2459
-        LIMIT ' . $post_start . ', ' . $post_length
2459
+        LIMIT ' . $post_start.', '.$post_length
2460 2460
     );
2461 2461
     foreach ($rows as $record) {
2462 2462
         // Get itemKey from current user
2463 2463
         $currentUserKey = DB::queryFirstRow(
2464 2464
             'SELECT share_key
2465
-            FROM ' . prefixTable('sharekeys_logs') . '
2465
+            FROM ' . prefixTable('sharekeys_logs').'
2466 2466
             WHERE object_id = %i AND user_id = %i',
2467 2467
             $record['increment_id'],
2468 2468
             $session->get('user-id')
@@ -2494,7 +2494,7 @@  discard block
 block discarded – undo
2494 2494
             if ((int) $post_user_id !== (int) $session->get('user-id')) {
2495 2495
                 $currentUserKey = DB::queryFirstRow(
2496 2496
                     'SELECT increment_id
2497
-                    FROM ' . prefixTable('sharekeys_items') . '
2497
+                    FROM ' . prefixTable('sharekeys_items').'
2498 2498
                     WHERE object_id = %i AND user_id = %i',
2499 2499
                     $record['id'],
2500 2500
                     $post_user_id
@@ -2516,7 +2516,7 @@  discard block
 block discarded – undo
2516 2516
     // SHould we change step?
2517 2517
     DB::query(
2518 2518
         'SELECT increment_id
2519
-        FROM ' . prefixTable('log_items') . '
2519
+        FROM ' . prefixTable('log_items').'
2520 2520
         WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes"'
2521 2521
     );
2522 2522
 
@@ -2541,15 +2541,15 @@  discard block
 block discarded – undo
2541 2541
     // Loop on fields
2542 2542
     $rows = DB::query(
2543 2543
         'SELECT id
2544
-        FROM ' . prefixTable('categories_items') . '
2544
+        FROM ' . prefixTable('categories_items').'
2545 2545
         WHERE encryption_type = "teampass_aes"
2546
-        LIMIT ' . $post_start . ', ' . $post_length
2546
+        LIMIT ' . $post_start.', '.$post_length
2547 2547
     );
2548 2548
     foreach ($rows as $record) {
2549 2549
         // Get itemKey from current user
2550 2550
         $currentUserKey = DB::queryFirstRow(
2551 2551
             'SELECT share_key
2552
-            FROM ' . prefixTable('sharekeys_fields') . '
2552
+            FROM ' . prefixTable('sharekeys_fields').'
2553 2553
             WHERE object_id = %i AND user_id = %i',
2554 2554
             $record['id'],
2555 2555
             $session->get('user-id')
@@ -2581,7 +2581,7 @@  discard block
 block discarded – undo
2581 2581
             if ((int) $post_user_id !== (int) $session->get('user-id')) {
2582 2582
                 $currentUserKey = DB::queryFirstRow(
2583 2583
                     'SELECT increment_id
2584
-                    FROM ' . prefixTable('sharekeys_items') . '
2584
+                    FROM ' . prefixTable('sharekeys_items').'
2585 2585
                     WHERE object_id = %i AND user_id = %i',
2586 2586
                     $record['id'],
2587 2587
                     $post_user_id
@@ -2603,7 +2603,7 @@  discard block
 block discarded – undo
2603 2603
     // SHould we change step?
2604 2604
     DB::query(
2605 2605
         'SELECT *
2606
-        FROM ' . prefixTable('categories_items') . '
2606
+        FROM ' . prefixTable('categories_items').'
2607 2607
         WHERE encryption_type = "teampass_aes"'
2608 2608
     );
2609 2609
 
@@ -2628,14 +2628,14 @@  discard block
 block discarded – undo
2628 2628
     // Loop on suggestions
2629 2629
     $rows = DB::query(
2630 2630
         'SELECT id
2631
-        FROM ' . prefixTable('suggestion') . '
2632
-        LIMIT ' . $post_start . ', ' . $post_length
2631
+        FROM ' . prefixTable('suggestion').'
2632
+        LIMIT ' . $post_start.', '.$post_length
2633 2633
     );
2634 2634
     foreach ($rows as $record) {
2635 2635
         // Get itemKey from current user
2636 2636
         $currentUserKey = DB::queryFirstRow(
2637 2637
             'SELECT share_key
2638
-            FROM ' . prefixTable('sharekeys_suggestions') . '
2638
+            FROM ' . prefixTable('sharekeys_suggestions').'
2639 2639
             WHERE object_id = %i AND user_id = %i',
2640 2640
             $record['id'],
2641 2641
             $session->get('user-id')
@@ -2667,7 +2667,7 @@  discard block
 block discarded – undo
2667 2667
             if ((int) $post_user_id !== (int) $session->get('user-id')) {
2668 2668
                 $currentUserKey = DB::queryFirstRow(
2669 2669
                     'SELECT increment_id
2670
-                    FROM ' . prefixTable('sharekeys_items') . '
2670
+                    FROM ' . prefixTable('sharekeys_items').'
2671 2671
                     WHERE object_id = %i AND user_id = %i',
2672 2672
                     $record['id'],
2673 2673
                     $post_user_id
@@ -2713,15 +2713,15 @@  discard block
 block discarded – undo
2713 2713
     // Loop on files
2714 2714
     $rows = DB::query(
2715 2715
         'SELECT id
2716
-        FROM ' . prefixTable('files') . '
2717
-        WHERE status = "' . TP_ENCRYPTION_NAME . '"
2718
-        LIMIT ' . $post_start . ', ' . $post_length
2716
+        FROM ' . prefixTable('files').'
2717
+        WHERE status = "' . TP_ENCRYPTION_NAME.'"
2718
+        LIMIT ' . $post_start.', '.$post_length
2719 2719
     ); //aes_encryption
2720 2720
     foreach ($rows as $record) {
2721 2721
         // Get itemKey from current user
2722 2722
         $currentUserKey = DB::queryFirstRow(
2723 2723
             'SELECT share_key
2724
-            FROM ' . prefixTable('sharekeys_files') . '
2724
+            FROM ' . prefixTable('sharekeys_files').'
2725 2725
             WHERE object_id = %i AND user_id = %i',
2726 2726
             $record['id'],
2727 2727
             $session->get('user-id')
@@ -2753,7 +2753,7 @@  discard block
 block discarded – undo
2753 2753
             if ((int) $post_user_id !== (int) $session->get('user-id')) {
2754 2754
                 $currentUserKey = DB::queryFirstRow(
2755 2755
                     'SELECT increment_id
2756
-                    FROM ' . prefixTable('sharekeys_items') . '
2756
+                    FROM ' . prefixTable('sharekeys_items').'
2757 2757
                     WHERE object_id = %i AND user_id = %i',
2758 2758
                     $record['id'],
2759 2759
                     $post_user_id
@@ -2775,8 +2775,8 @@  discard block
 block discarded – undo
2775 2775
     // SHould we change step?
2776 2776
     DB::query(
2777 2777
         'SELECT *
2778
-        FROM ' . prefixTable('files') . '
2779
-        WHERE status = "' . TP_ENCRYPTION_NAME . '"'
2778
+        FROM ' . prefixTable('files').'
2779
+        WHERE status = "' . TP_ENCRYPTION_NAME.'"'
2780 2780
     );
2781 2781
 
2782 2782
     $next_start = (int) $post_start + (int) $post_length;
@@ -2809,9 +2809,9 @@  discard block
 block discarded – undo
2809 2809
     if (count($session->get('user-personal_folders')) > 0) {
2810 2810
         $rows = DB::query(
2811 2811
             'SELECT id, pw
2812
-            FROM ' . prefixTable('items') . '
2812
+            FROM ' . prefixTable('items').'
2813 2813
             WHERE perso = 1 AND id_tree IN %ls AND encryption_type = %s
2814
-            LIMIT ' . $post_start . ', ' . $post_length,
2814
+            LIMIT ' . $post_start.', '.$post_length,
2815 2815
             $session->get('user-personal_folders'),
2816 2816
             "defuse"
2817 2817
         );
@@ -2819,7 +2819,7 @@  discard block
 block discarded – undo
2819 2819
             // Get itemKey from current user
2820 2820
             $currentUserKey = DB::queryFirstRow(
2821 2821
                 'SELECT share_key, increment_id
2822
-                FROM ' . prefixTable('sharekeys_items') . '
2822
+                FROM ' . prefixTable('sharekeys_items').'
2823 2823
                 WHERE object_id = %i AND user_id = %i',
2824 2824
                 $record['id'],
2825 2825
                 $session->get('user-id')
@@ -2846,7 +2846,7 @@  discard block
 block discarded – undo
2846 2846
                 if ((int) $post_user_id !== (int) $session->get('user-id')) {
2847 2847
                     $currentUserKey = DB::queryFirstRow(
2848 2848
                         'SELECT increment_id
2849
-                        FROM ' . prefixTable('sharekeys_items') . '
2849
+                        FROM ' . prefixTable('sharekeys_items').'
2850 2850
                         WHERE object_id = %i AND user_id = %i',
2851 2851
                         $record['id'],
2852 2852
                         $post_user_id
@@ -2869,7 +2869,7 @@  discard block
 block discarded – undo
2869 2869
     // SHould we change step?
2870 2870
     DB::query(
2871 2871
         'SELECT *
2872
-        FROM ' . prefixTable('items') . '
2872
+        FROM ' . prefixTable('items').'
2873 2873
         WHERE perso = 0'
2874 2874
     );
2875 2875
 
@@ -2897,7 +2897,7 @@  discard block
 block discarded – undo
2897 2897
         // Check if user exists
2898 2898
         $userInfo = DB::queryFirstRow(
2899 2899
             'SELECT public_key, encrypted_psk
2900
-            FROM ' . prefixTable('users') . '
2900
+            FROM ' . prefixTable('users').'
2901 2901
             WHERE id = %i',
2902 2902
             $post_user_id
2903 2903
         );
@@ -2923,7 +2923,7 @@  discard block
 block discarded – undo
2923 2923
                 if ($post_counterItemsToTreat === -1) {
2924 2924
                     DB::query(
2925 2925
                         'SELECT id
2926
-                        FROM ' . prefixTable('items') . '
2926
+                        FROM ' . prefixTable('items').'
2927 2927
                         WHERE perso = 1 AND id_tree IN %ls AND encryption_type != %s',
2928 2928
                         $session->get('user-personal_folders'),
2929 2929
                         'teampass_aes'
@@ -2936,7 +2936,7 @@  discard block
 block discarded – undo
2936 2936
                 // Loop on persoanl items
2937 2937
                 $rows = DB::query(
2938 2938
                     'SELECT id, pw
2939
-                    FROM ' . prefixTable('items') . '
2939
+                    FROM ' . prefixTable('items').'
2940 2940
                     WHERE perso = 1 AND id_tree IN %ls AND encryption_type != %s
2941 2941
                     LIMIT ' . $post_length,
2942 2942
                     $session->get('user-personal_folders'),
@@ -2980,7 +2980,7 @@  discard block
 block discarded – undo
2980 2980
                     // Loop on files
2981 2981
                     $rows = DB::query(
2982 2982
                         'SELECT id, file
2983
-                        FROM ' . prefixTable('files') . '
2983
+                        FROM ' . prefixTable('files').'
2984 2984
                         WHERE status != %s
2985 2985
                         AND id_item = %i',
2986 2986
                         TP_ENCRYPTION_NAME,
@@ -2991,13 +2991,13 @@  discard block
 block discarded – undo
2991 2991
                         // Now decrypt the file
2992 2992
                         prepareFileWithDefuse(
2993 2993
                             'decrypt',
2994
-                            $SETTINGS['path_to_upload_folder'] . '/' . $record2['file'],
2995
-                            $SETTINGS['path_to_upload_folder'] . '/' . $record2['file'] . '.delete',
2994
+                            $SETTINGS['path_to_upload_folder'].'/'.$record2['file'],
2995
+                            $SETTINGS['path_to_upload_folder'].'/'.$record2['file'].'.delete',
2996 2996
                             $post_user_psk
2997 2997
                         );
2998 2998
 
2999 2999
                         // Encrypt the file
3000
-                        $encryptedFile = encryptFile($record2['file'] . '.delete', $SETTINGS['path_to_upload_folder']);
3000
+                        $encryptedFile = encryptFile($record2['file'].'.delete', $SETTINGS['path_to_upload_folder']);
3001 3001
 
3002 3002
                         DB::update(
3003 3003
                             prefixTable('files'),
@@ -3020,7 +3020,7 @@  discard block
 block discarded – undo
3020 3020
                         );
3021 3021
 
3022 3022
                         // Unlink original file
3023
-                        unlink($SETTINGS['path_to_upload_folder'] . '/' . $record2['file']);
3023
+                        unlink($SETTINGS['path_to_upload_folder'].'/'.$record2['file']);
3024 3024
                     }
3025 3025
                 }
3026 3026
 
@@ -3028,7 +3028,7 @@  discard block
 block discarded – undo
3028 3028
                 $next_start = (int) $post_start + (int) $post_length;
3029 3029
                 DB::query(
3030 3030
                     'SELECT id
3031
-                    FROM ' . prefixTable('items') . '
3031
+                    FROM ' . prefixTable('items').'
3032 3032
                     WHERE perso = 1 AND id_tree IN %ls AND encryption_type != %s',
3033 3033
                     $session->get('user-personal_folders'),
3034 3034
                     'teampass_aes'
@@ -3098,7 +3098,7 @@  discard block
 block discarded – undo
3098 3098
         // Get user info
3099 3099
         $userData = DB::queryFirstRow(
3100 3100
             'SELECT special, auth_type, is_ready_for_usage, ongoing_process_id, otp_provided, keys_recovery_time
3101
-            FROM ' . prefixTable('users') . '
3101
+            FROM ' . prefixTable('users').'
3102 3102
             WHERE id = %i',
3103 3103
             $post_user_id
3104 3104
         );
@@ -3145,7 +3145,7 @@  discard block
 block discarded – undo
3145 3145
         // Get user info
3146 3146
         $userData = DB::queryFirstRow(
3147 3147
             'SELECT auth_type, login, private_key
3148
-            FROM ' . prefixTable('users') . '
3148
+            FROM ' . prefixTable('users').'
3149 3149
             WHERE id = %i',
3150 3150
             $post_user_id
3151 3151
         );
@@ -3195,7 +3195,7 @@  discard block
 block discarded – undo
3195 3195
                 return prepareExchangedData(
3196 3196
                     array(
3197 3197
                         'error' => false,
3198
-                        'message' => $lang->get('done'),'',
3198
+                        'message' => $lang->get('done'), '',
3199 3199
                     ),
3200 3200
                     'encode'
3201 3201
                 );
@@ -3243,7 +3243,7 @@  discard block
 block discarded – undo
3243 3243
         // Get user info
3244 3244
         $userData = DB::queryFirstRow(
3245 3245
             'SELECT auth_type, login, private_key, special
3246
-            FROM ' . prefixTable('users') . '
3246
+            FROM ' . prefixTable('users').'
3247 3247
             WHERE id = %i',
3248 3248
             $post_user_id
3249 3249
         );
@@ -3277,7 +3277,7 @@  discard block
 block discarded – undo
3277 3277
                 return prepareExchangedData(
3278 3278
                     array(
3279 3279
                         'error' => false,
3280
-                        'message' => $lang->get('done'),'',
3280
+                        'message' => $lang->get('done'), '',
3281 3281
                     ),
3282 3282
                     'encode'
3283 3283
                 );
@@ -3299,8 +3299,8 @@  discard block
 block discarded – undo
3299 3299
             // Get one itemKey from current user
3300 3300
             $currentUserKey = DB::queryFirstRow(
3301 3301
                 'SELECT ski.share_key, ski.increment_id, l.id_user
3302
-                FROM ' . prefixTable('sharekeys_items') . ' AS ski
3303
-                INNER JOIN ' . prefixTable('log_items') . ' AS l ON ski.object_id = l.id_item
3302
+                FROM ' . prefixTable('sharekeys_items').' AS ski
3303
+                INNER JOIN ' . prefixTable('log_items').' AS l ON ski.object_id = l.id_item
3304 3304
                 WHERE ski.user_id = %i
3305 3305
                 ORDER BY RAND()
3306 3306
                 LIMIT 1',
@@ -3390,7 +3390,7 @@  discard block
 block discarded – undo
3390 3390
             $session->get('user-id')
3391 3391
         );
3392 3392
         // Return data
3393
-        return '[{"new_value":"' . $session->get('user-session_duration') . '"}]';
3393
+        return '[{"new_value":"'.$session->get('user-session_duration').'"}]';
3394 3394
     }
3395 3395
     
3396 3396
     return '[{"new_value":"expired"}]';
Please login to merge, or discard this patch.
sources/identify.php 3 patches
Spacing   +48 added lines, -48 removed lines patch added patch discarded remove patch
@@ -147,7 +147,7 @@  discard block
 block discarded – undo
147 147
     $sessionPwdAttempts = $session->get('pwd_attempts');
148 148
     $sessionUrl = $session->get('user-initial_url');
149 149
     $server = [];
150
-    $server['PHP_AUTH_USER'] =  $request->getUser();
150
+    $server['PHP_AUTH_USER'] = $request->getUser();
151 151
     $server['PHP_AUTH_PW'] = $request->getPassword();
152 152
     
153 153
     // decrypt and retreive data in JSON format
@@ -162,18 +162,18 @@  discard block
 block discarded – undo
162 162
     }
163 163
 
164 164
     // Check if Duo auth is in progress and pass the pw and login back to the standard login process
165
-    if(
165
+    if (
166 166
         isKeyExistingAndEqual('duo', 1, $SETTINGS) === true
167 167
         && $dataReceived['user_2fa_selection'] === 'duo'
168 168
         && $session->get('user-duo_status') === 'IN_PROGRESS'
169 169
         && !empty($dataReceived['duo_state'])
170
-    ){
170
+    ) {
171 171
         $key = hash('sha256', $dataReceived['duo_state']);
172 172
         $iv = substr(hash('sha256', $dataReceived['duo_state']), 0, 16);
173 173
         $duo_data_dec = openssl_decrypt(base64_decode($session->get('user-duo_data')), 'AES-256-CBC', $key, 0, $iv);
174 174
         // Clear the data from the Duo process to continue clean with the standard login process
175
-        $session->set('user-duo_data','');
176
-        if($duo_data_dec === false) {
175
+        $session->set('user-duo_data', '');
176
+        if ($duo_data_dec === false) {
177 177
             // Add failed authentication log
178 178
             addFailedAuthentication($username, getClientIpServer());
179 179
 
@@ -191,7 +191,7 @@  discard block
 block discarded – undo
191 191
         $dataReceived['login'] = $duo_data['duo_login'];
192 192
     }
193 193
 
194
-    if(isset($dataReceived['pw']) === false || isset($dataReceived['login']) === false) {
194
+    if (isset($dataReceived['pw']) === false || isset($dataReceived['login']) === false) {
195 195
         echo json_encode([
196 196
             'data' => prepareExchangedData(
197 197
                 [
@@ -538,7 +538,7 @@  discard block
 block discarded – undo
538 538
         }
539 539
         // Append with roles from AD groups
540 540
         if (is_null($userInfo['roles_from_ad_groups']) === false) {
541
-            $userInfo['fonction_id'] = empty($userInfo['fonction_id'])  === true ? $userInfo['roles_from_ad_groups'] : $userInfo['fonction_id']. ';' . $userInfo['roles_from_ad_groups'];
541
+            $userInfo['fonction_id'] = empty($userInfo['fonction_id']) === true ? $userInfo['roles_from_ad_groups'] : $userInfo['fonction_id'].';'.$userInfo['roles_from_ad_groups'];
542 542
         }
543 543
         // store
544 544
         $session->set('user-roles', $userInfo['fonction_id']);
@@ -550,7 +550,7 @@  discard block
 block discarded – undo
550 550
         if (count($session->get('user-roles_array')) > 0) {
551 551
             $rolesList = DB::query(
552 552
                 'SELECT id, title, complexity
553
-                FROM ' . prefixTable('roles_title') . '
553
+                FROM ' . prefixTable('roles_title').'
554 554
                 WHERE id IN %li',
555 555
                 $session->get('user-roles_array')
556 556
             );
@@ -596,7 +596,7 @@  discard block
 block discarded – undo
596 596
             if ($adjustPermissions) {
597 597
                 $session->set('user-admin', (int) $userInfo['admin']);
598 598
                 $session->set('user-manager', (int) $userInfo['gestionnaire']);
599
-                $session->set('user-can_manage_all_users',(int)  $userInfo['can_manage_all_users']);
599
+                $session->set('user-can_manage_all_users', (int) $userInfo['can_manage_all_users']);
600 600
                 $session->set('user-read_only', (int) $userInfo['read_only']);
601 601
                 DB::update(
602 602
                     prefixTable('users'),
@@ -667,10 +667,10 @@  discard block
 block discarded – undo
667 667
         $session->set('user-latest_items_tab', []);
668 668
         $session->set('user-nb_roles', 0);
669 669
         foreach ($session->get('user-latest_items') as $item) {
670
-            if (! empty($item)) {
670
+            if (!empty($item)) {
671 671
                 $dataLastItems = DB::queryFirstRow(
672 672
                     'SELECT id,label,id_tree
673
-                    FROM ' . prefixTable('items') . '
673
+                    FROM ' . prefixTable('items').'
674 674
                     WHERE id=%i',
675 675
                     $item
676 676
                 );
@@ -679,7 +679,7 @@  discard block
 block discarded – undo
679 679
                     [
680 680
                         'id' => $item,
681 681
                         'label' => $dataLastItems['label'],
682
-                        'url' => 'index.php?page=items&amp;group=' . $dataLastItems['id_tree'] . '&amp;id=' . $item,
682
+                        'url' => 'index.php?page=items&amp;group='.$dataLastItems['id_tree'].'&amp;id='.$item,
683 683
                     ],
684 684
                     'add'
685 685
                 );
@@ -689,7 +689,7 @@  discard block
 block discarded – undo
689 689
         // Get cahce tree info
690 690
         $cacheTreeData = DB::queryFirstRow(
691 691
             'SELECT visible_folders
692
-            FROM ' . prefixTable('cache_tree') . '
692
+            FROM ' . prefixTable('cache_tree').'
693 693
             WHERE user_id=%i',
694 694
             (int) $session->get('user-id')
695 695
         );
@@ -721,7 +721,7 @@  discard block
 block discarded – undo
721 721
             && (int) $sessionAdmin !== 1
722 722
         ) {
723 723
             // get all Admin users
724
-            $val = DB::queryfirstrow('SELECT email FROM ' . prefixTable('users') . " WHERE admin = %i and email != ''", 1);
724
+            $val = DB::queryfirstrow('SELECT email FROM '.prefixTable('users')." WHERE admin = %i and email != ''", 1);
725 725
             if (DB::count() > 0) {
726 726
                 // Add email to table
727 727
                 prepareSendingEmail(
@@ -733,7 +733,7 @@  discard block
 block discarded – undo
733 733
                             '#tp_time#',
734 734
                         ],
735 735
                         [
736
-                            ' ' . $session->get('user-login') . ' (IP: ' . getClientIpServer() . ')',
736
+                            ' '.$session->get('user-login').' (IP: '.getClientIpServer().')',
737 737
                             date($SETTINGS['date_format'], (int) $session->get('user-last_connection')),
738 738
                             date($SETTINGS['time_format'], (int) $session->get('user-last_connection')),
739 739
                         ],
@@ -844,7 +844,7 @@  discard block
 block discarded – undo
844 844
 {
845 845
     $rows = DB::query(
846 846
         'SELECT date
847
-        FROM ' . prefixTable('log_system') . "
847
+        FROM ' . prefixTable('log_system')."
848 848
         WHERE field_1 = %s
849 849
         AND type = 'failed_auth'
850 850
         AND label = 'password_is_not_correct'
@@ -858,7 +858,7 @@  discard block
 block discarded – undo
858 858
         foreach ($rows as $record) {
859 859
             array_push(
860 860
                 $arrAttempts,
861
-                date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date'])
861
+                date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date'])
862 862
             );
863 863
         }
864 864
     }
@@ -893,7 +893,7 @@  discard block
 block discarded – undo
893 893
     $ldapConnection
894 894
 ) : bool
895 895
 {
896
-    include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php';
896
+    include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php';
897 897
 
898 898
     if ((int) $userInfoDisabled === 1) {
899 899
         return false;
@@ -1088,7 +1088,7 @@  discard block
 block discarded – undo
1088 1088
     } catch (Exception $e) {
1089 1089
         return [
1090 1090
             'error' => true,
1091
-            'message' => "Error: " . $e->getMessage(),
1091
+            'message' => "Error: ".$e->getMessage(),
1092 1092
         ];
1093 1093
     }
1094 1094
 }
@@ -1119,7 +1119,7 @@  discard block
 block discarded – undo
1119 1119
                 'type' => 'OpenLDAP'
1120 1120
             ];
1121 1121
         default:
1122
-            throw new Exception("Unsupported LDAP type: " . $SETTINGS['ldap_type']);
1122
+            throw new Exception("Unsupported LDAP type: ".$SETTINGS['ldap_type']);
1123 1123
     }
1124 1124
 }
1125 1125
 
@@ -1256,7 +1256,7 @@  discard block
 block discarded – undo
1256 1256
         );
1257 1257
     }
1258 1258
     
1259
-    throw new Exception("Unsupported LDAP type: " . $ldapHandler['type']);
1259
+    throw new Exception("Unsupported LDAP type: ".$ldapHandler['type']);
1260 1260
 }
1261 1261
 
1262 1262
 /**
@@ -1273,12 +1273,12 @@  discard block
 block discarded – undo
1273 1273
     if (isset($SETTINGS['enable_ad_users_with_ad_groups']) === true && (int) $SETTINGS['enable_ad_users_with_ad_groups'] === 1) {
1274 1274
         // Get user groups from AD
1275 1275
         $user_ad_groups = [];
1276
-        foreach($groups as $group) {
1276
+        foreach ($groups as $group) {
1277 1277
             //print_r($group);
1278 1278
             // get relation role id for AD group
1279 1279
             $role = DB::queryFirstRow(
1280 1280
                 'SELECT lgr.role_id
1281
-                FROM ' . prefixTable('ldap_groups_roles') . ' AS lgr
1281
+                FROM ' . prefixTable('ldap_groups_roles').' AS lgr
1282 1282
                 WHERE lgr.ldap_group_id = %s',
1283 1283
                 $group
1284 1284
             );
@@ -1423,7 +1423,7 @@  discard block
 block discarded – undo
1423 1423
     }
1424 1424
 
1425 1425
     // Now check yubico validity
1426
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Authentication/Yubico/Yubico.php';
1426
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Authentication/Yubico/Yubico.php';
1427 1427
     $yubi = new Auth_Yubico($yubico_user_id, $yubico_user_key);
1428 1428
     $auth = $yubi->verify($yubico_key);
1429 1429
     //, null, null, null, 60
@@ -1482,7 +1482,7 @@  discard block
 block discarded – undo
1482 1482
             // Check if exists in DB
1483 1483
             $groupData = DB::queryFirstRow(
1484 1484
                 'SELECT id
1485
-                FROM ' . prefixTable('roles_title') . '
1485
+                FROM ' . prefixTable('roles_title').'
1486 1486
                 WHERE title = %s',
1487 1487
                 $group["displayName"]
1488 1488
             );
@@ -1611,7 +1611,7 @@  discard block
 block discarded – undo
1611 1611
             
1612 1612
             // generate new QR
1613 1613
             $new_2fa_qr = $tfa->getQRCodeImageAsDataUri(
1614
-                'Teampass - ' . $username,
1614
+                'Teampass - '.$username,
1615 1615
                 $userInfo['ga']
1616 1616
             );
1617 1617
             // clear temporary code from DB
@@ -1624,7 +1624,7 @@  discard block
 block discarded – undo
1624 1624
                 $userInfo['id']
1625 1625
             );
1626 1626
             $firstTime = [
1627
-                'value' => '<img src="' . $new_2fa_qr . '">',
1627
+                'value' => '<img src="'.$new_2fa_qr.'">',
1628 1628
                 'user_admin' => isset($sessionAdmin) ? (int) $sessionAdmin : '',
1629 1629
                 'initial_url' => isset($sessionUrl) === true ? $sessionUrl : '',
1630 1630
                 'pwd_attempts' => (int) $sessionPwdAttempts,
@@ -1780,7 +1780,7 @@  discard block
 block discarded – undo
1780 1780
         }*/
1781 1781
         return [
1782 1782
             'error' => true,
1783
-            'message' => $duo_error . $lang->get('duo_error_check_config'),
1783
+            'message' => $duo_error.$lang->get('duo_error_check_config'),
1784 1784
             'pwd_attempts' => (int) $sessionPwdAttempts,
1785 1785
             'debug_message' => $e->getMessage(),
1786 1786
             'proceedIdentification' => false,
@@ -1796,7 +1796,7 @@  discard block
 block discarded – undo
1796 1796
         } catch (DuoException $e) {
1797 1797
             return [
1798 1798
                 'error' => true,
1799
-                'message' => $duo_error . $lang->get('duo_error_url'),
1799
+                'message' => $duo_error.$lang->get('duo_error_url'),
1800 1800
                 'pwd_attempts' => (int) $sessionPwdAttempts,
1801 1801
                 'debug_message' => $e->getMessage(),
1802 1802
                 'proceedIdentification' => false,
@@ -1804,7 +1804,7 @@  discard block
 block discarded – undo
1804 1804
         }
1805 1805
         
1806 1806
         // Somethimes Duo return success but fail to return a URL, double check if the URL has been created
1807
-        if (!empty($duo_redirect_url) && isset($duo_redirect_url) && filter_var($duo_redirect_url,FILTER_SANITIZE_URL)) {
1807
+        if (!empty($duo_redirect_url) && isset($duo_redirect_url) && filter_var($duo_redirect_url, FILTER_SANITIZE_URL)) {
1808 1808
             // Since Duo Universal requires a redirect, let's store some info when the user get's back after completing the Duo prompt
1809 1809
             $key = hash('sha256', $duo_state);
1810 1810
             $iv = substr(hash('sha256', $duo_state), 0, 16);
@@ -1832,7 +1832,7 @@  discard block
 block discarded – undo
1832 1832
         } else {
1833 1833
             return [
1834 1834
                 'error' => true,
1835
-                'message' => $duo_error . $lang->get('duo_error_url'),
1835
+                'message' => $duo_error.$lang->get('duo_error_url'),
1836 1836
                 'pwd_attempts' => (int) $sessionPwdAttempts,
1837 1837
                 'proceedIdentification' => false,
1838 1838
             ];
@@ -1853,8 +1853,8 @@  discard block
 block discarded – undo
1853 1853
         // return the response (which should be the user name)
1854 1854
         if ($decoded_token['preferred_username'] === $username) {
1855 1855
             $session->set('user-duo_status', 'COMPLET');
1856
-            $session->set('user-duo_state','');
1857
-            $session->set('user-duo_data','');
1856
+            $session->set('user-duo_state', '');
1857
+            $session->set('user-duo_data', '');
1858 1858
             $session->set('user-login', $username);
1859 1859
 
1860 1860
             return [
@@ -1865,9 +1865,9 @@  discard block
 block discarded – undo
1865 1865
             ];
1866 1866
         } else {
1867 1867
             // Something wrong, username from the original Duo request is different than the one received now
1868
-            $session->set('user-duo_status','');
1869
-            $session->set('user-duo_state','');
1870
-            $session->set('user-duo_data','');
1868
+            $session->set('user-duo_status', '');
1869
+            $session->set('user-duo_state', '');
1870
+            $session->set('user-duo_data', '');
1871 1871
 
1872 1872
             return [
1873 1873
                 'error' => true,
@@ -1878,9 +1878,9 @@  discard block
 block discarded – undo
1878 1878
         }
1879 1879
     }
1880 1880
     // If we are here something wrong
1881
-    $session->set('user-duo_status','');
1882
-    $session->set('user-duo_state','');
1883
-    $session->set('user-duo_data','');
1881
+    $session->set('user-duo_status', '');
1882
+    $session->set('user-duo_state', '');
1883
+    $session->set('user-duo_data', '');
1884 1884
     return [
1885 1885
         'error' => true,
1886 1886
         'message' => $lang->get('duo_login_mismatch'),
@@ -1992,7 +1992,7 @@  discard block
 block discarded – undo
1992 1992
         // Check for existing lock
1993 1993
         $unlock_at = DB::queryFirstField(
1994 1994
             'SELECT MAX(unlock_at)
1995
-             FROM ' . prefixTable('auth_failures') . '
1995
+             FROM ' . prefixTable('auth_failures').'
1996 1996
              WHERE unlock_at > %s
1997 1997
              AND ((source = %s AND value = %s) OR (source = %s AND value = %s))',
1998 1998
             date('Y-m-d H:i:s', time()),
@@ -2014,8 +2014,8 @@  discard block
 block discarded – undo
2014 2014
         // Get user info from DB
2015 2015
         $data = DB::queryFirstRow(
2016 2016
             'SELECT u.*, a.value AS api_key
2017
-            FROM ' . prefixTable('users') . ' AS u
2018
-            LEFT JOIN ' . prefixTable('api') . ' AS a ON (u.id = a.user_id)
2017
+            FROM ' . prefixTable('users').' AS u
2018
+            LEFT JOIN ' . prefixTable('api').' AS a ON (u.id = a.user_id)
2019 2019
             WHERE login = %s AND deleted_at IS NULL',
2020 2020
             $login
2021 2021
         );
@@ -2140,7 +2140,7 @@  discard block
 block discarded – undo
2140 2140
             'array' => [
2141 2141
                 'value' => 'bruteforce_wait',
2142 2142
                 'error' => true,
2143
-                'message' => $lang->get('bruteforce_wait') . (string) $e->getMessage(),
2143
+                'message' => $lang->get('bruteforce_wait').(string) $e->getMessage(),
2144 2144
             ]
2145 2145
         ];
2146 2146
     }
@@ -2551,15 +2551,15 @@  discard block
 block discarded – undo
2551 2551
 
2552 2552
             if ($ret['error'] !== false) {
2553 2553
                 logEvents($SETTINGS, 'failed_auth', 'bad_duo_mfa', '', stripslashes($username), stripslashes($username));
2554
-                $session->set('user-duo_status','');
2555
-                $session->set('user-duo_state','');
2556
-                $session->set('user-duo_data','');
2554
+                $session->set('user-duo_status', '');
2555
+                $session->set('user-duo_state', '');
2556
+                $session->set('user-duo_data', '');
2557 2557
                 return [
2558 2558
                     'error' => true,
2559 2559
                     'mfaData' => $ret,
2560 2560
                     'mfaQRCodeInfos' => false,
2561 2561
                 ];
2562
-            } else if ($ret['duo_url_ready'] === true){
2562
+            } else if ($ret['duo_url_ready'] === true) {
2563 2563
                 return [
2564 2564
                     'error' => false,
2565 2565
                     'mfaData' => $ret,
@@ -2623,7 +2623,7 @@  discard block
 block discarded – undo
2623 2623
     // Count failed attempts from this source
2624 2624
     $count = DB::queryFirstField(
2625 2625
         'SELECT COUNT(*)
2626
-        FROM ' . prefixTable('auth_failures') . '
2626
+        FROM ' . prefixTable('auth_failures').'
2627 2627
         WHERE source = %s AND value = %s',
2628 2628
         $source,
2629 2629
         $value
Please login to merge, or discard this patch.
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -2663,7 +2663,7 @@
 block discarded – undo
2663 2663
             'SELECT email, name
2664 2664
              FROM '.prefixTable('users').'
2665 2665
              WHERE login = %s',
2666
-             $value
2666
+                $value
2667 2667
         );
2668 2668
 
2669 2669
         // No valid email address for user
Please login to merge, or discard this patch.
Braces   +9 added lines, -4 removed lines patch added patch discarded remove patch
@@ -2401,7 +2401,9 @@  discard block
 block discarded – undo
2401 2401
         // Complete $userInfo
2402 2402
         $userInfo['has_been_created'] = 1;
2403 2403
 
2404
-        if (WIP === true) error_log("--- USER CREATED ---");
2404
+        if (WIP === true) {
2405
+            error_log("--- USER CREATED ---");
2406
+        }
2405 2407
 
2406 2408
         return [
2407 2409
             'error' => false,
@@ -2437,7 +2439,9 @@  discard block
 block discarded – undo
2437 2439
         }
2438 2440
 
2439 2441
         // Oauth2 user already exists and authenticated
2440
-        if (WIP === true) error_log("--- USER AUTHENTICATED ---");
2442
+        if (WIP === true) {
2443
+            error_log("--- USER AUTHENTICATED ---");
2444
+        }
2441 2445
         $userInfo['has_been_created'] = 0;
2442 2446
 
2443 2447
         $passwordManager = new PasswordManager();
@@ -2667,8 +2671,9 @@  discard block
 block discarded – undo
2667 2671
         );
2668 2672
 
2669 2673
         // No valid email address for user
2670
-        if (!$userInfos || !filter_var($userInfos['email'], FILTER_VALIDATE_EMAIL))
2671
-            return;
2674
+        if (!$userInfos || !filter_var($userInfos['email'], FILTER_VALIDATE_EMAIL)) {
2675
+                    return;
2676
+        }
2672 2677
 
2673 2678
         $unlock_url = $SETTINGS['cpassman_url'].'/self-unlock.php?login='.$value.'&otp='.$unlock_code;
2674 2679
 
Please login to merge, or discard this patch.
pages/2fa.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -69,7 +69,7 @@  discard block
 block discarded – undo
69 69
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('mfa') === false) {
70 70
     // Not allowed page
71 71
     $session->set('system-error_code', ERR_NOT_ALLOWED);
72
-    include $SETTINGS['cpassman_dir'] . '/error.php';
72
+    include $SETTINGS['cpassman_dir'].'/error.php';
73 73
     exit;
74 74
 }
75 75
 
@@ -141,7 +141,7 @@  discard block
 block discarded – undo
141 141
                                     $roles = getRolesTitles();
142 142
                                     foreach ($roles as $role) {
143 143
                                         echo '
144
-                                    <option value="' . $role['id'] . '"', in_array($role['id'], $arrRolesMFA) === true ? ' selected' : '', '>' . addslashes($role['title']) . '</option>';
144
+                                    <option value="' . $role['id'].'"', in_array($role['id'], $arrRolesMFA) === true ? ' selected' : '', '>'.addslashes($role['title']).'</option>';
145 145
                                     }
146 146
                                     ?>
147 147
                                 </select>
Please login to merge, or discard this patch.
pages/options.php 1 patch
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -69,7 +69,7 @@  discard block
 block discarded – undo
69 69
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('options') === false) {
70 70
     // Not allowed page
71 71
     $session->set('system-error_code', ERR_NOT_ALLOWED);
72
-    include $SETTINGS['cpassman_dir'] . '/error.php';
72
+    include $SETTINGS['cpassman_dir'].'/error.php';
73 73
     exit;
74 74
 }
75 75
 
@@ -322,7 +322,7 @@  discard block
 block discarded – undo
322 322
                                     // get list of all timezones
323 323
                                     foreach ($zones as $key => $zone) {
324 324
                                         echo '
325
-                                <option value="' . $key . '"', isset($SETTINGS['timezone']) === true && $SETTINGS['timezone'] === $key ? ' selected' : '', '>' . $zone . '</option>';
325
+                                <option value="' . $key.'"', isset($SETTINGS['timezone']) === true && $SETTINGS['timezone'] === $key ? ' selected' : '', '>'.$zone.'</option>';
326 326
                                     }
327 327
                                     ?>
328 328
                                 </select>
@@ -373,7 +373,7 @@  discard block
 block discarded – undo
373 373
                                     <?php
374 374
                                     foreach ($languagesList as $teampassLang) {
375 375
                                         echo '
376
-                                <option value="' . $teampassLang . '"', isset($SETTINGS['default_language']) === true && $SETTINGS['default_language'] === $teampassLang ? ' selected' : '', '>' . $teampassLang . '</option>';
376
+                                <option value="' . $teampassLang.'"', isset($SETTINGS['default_language']) === true && $SETTINGS['default_language'] === $teampassLang ? ' selected' : '', '>'.$teampassLang.'</option>';
377 377
                                     }
378 378
                                     ?>
379 379
                                 </select>
@@ -470,7 +470,7 @@  discard block
 block discarded – undo
470 470
                                 <?php
471 471
                                 foreach (TP_PW_COMPLEXITY as $complex) {
472 472
                                     echo '
473
-                                <option value="' . $complex[0] . '"', isset($SETTINGS['personal_saltkey_security_level']) === true && $SETTINGS['personal_saltkey_security_level'] === $complex[0] ? ' selected' : '', '>' . $complex[1] . '</option>';
473
+                                <option value="' . $complex[0].'"', isset($SETTINGS['personal_saltkey_security_level']) === true && $SETTINGS['personal_saltkey_security_level'] === $complex[0] ? ' selected' : '', '>'.$complex[1].'</option>';
474 474
                                 }
475 475
                                 ?>
476 476
                             </select>
@@ -802,7 +802,7 @@  discard block
 block discarded – undo
802 802
                                         $roles = getRolesTitles();
803 803
                                         foreach ($roles as $role) {
804 804
                                             echo '
805
-                                    <option value="' . htmlspecialchars($role['id']) . '"', in_array($role['id'], $arrRolesToPrint) === true ? ' selected' : '', '>' . htmlspecialchars(addslashes($role['title'])) . '</option>';
805
+                                    <option value="' . htmlspecialchars($role['id']).'"', in_array($role['id'], $arrRolesToPrint) === true ? ' selected' : '', '>'.htmlspecialchars(addslashes($role['title'])).'</option>';
806 806
                                         }
807 807
                                     }
808 808
                                     ?>
@@ -1029,7 +1029,7 @@  discard block
 block discarded – undo
1029 1029
                                     <?php
1030 1030
                                     foreach (TP_PW_COMPLEXITY as $complex) {
1031 1031
                                         echo '
1032
-                                <option value="' . $complex[0] . '"', isset($SETTINGS['offline_key_level']) === true && $SETTINGS['offline_key_level'] === $complex[0] ? ' selected' : '', '>' . $complex[1] . '</option>';
1032
+                                <option value="' . $complex[0].'"', isset($SETTINGS['offline_key_level']) === true && $SETTINGS['offline_key_level'] === $complex[0] ? ' selected' : '', '>'.$complex[1].'</option>';
1033 1033
                                     }
1034 1034
                                     ?>
1035 1035
                                 </select>
Please login to merge, or discard this patch.
sources/backups.queries.php 2 patches
Spacing   +25 added lines, -25 removed lines patch added patch discarded remove patch
@@ -77,7 +77,7 @@  discard block
 block discarded – undo
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,21 +138,21 @@  discard block
 block discarded – undo
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
             $return = '';
143 143
 
144 144
             //Get all tables
145 145
             $tables = array();
146 146
             $result = DB::query('SHOW TABLES');
147 147
             foreach ($result as $row) {
148
-                $tables[] = $row['Tables_in_' . DB_NAME];
148
+                $tables[] = $row['Tables_in_'.DB_NAME];
149 149
             }
150 150
 
151 151
             //cycle through
152 152
             foreach ($tables as $table) {
153 153
                 if (empty($pre) || substr_count($table, $pre) > 0) {
154 154
                     // Do query
155
-                    $result = DB::queryRaw('SELECT * FROM ' . $table);
155
+                    $result = DB::queryRaw('SELECT * FROM '.$table);
156 156
                     DB::queryRaw(
157 157
                         'SELECT *
158 158
                         FROM INFORMATION_SCHEMA.COLUMNS
@@ -164,17 +164,17 @@  discard block
 block discarded – undo
164 164
                     $numFields = DB::count();
165 165
 
166 166
                     // prepare a drop table
167
-                    $return .= 'DROP TABLE ' . $table . ';';
168
-                    $row2 = DB::queryfirstrow('SHOW CREATE TABLE ' . $table);
169
-                    $return .= "\n\n" . $row2['Create Table'] . ";\n\n";
167
+                    $return .= 'DROP TABLE '.$table.';';
168
+                    $row2 = DB::queryfirstrow('SHOW CREATE TABLE '.$table);
169
+                    $return .= "\n\n".$row2['Create Table'].";\n\n";
170 170
 
171 171
                     //prepare all fields and datas
172 172
                     for ($i = 0; $i < $numFields; ++$i) {
173 173
                         while ($row = $result->fetch_row()) {
174
-                            $return .= 'INSERT INTO ' . $table . ' VALUES(';
174
+                            $return .= 'INSERT INTO '.$table.' VALUES(';
175 175
                             for ($j = 0; $j < $numFields; ++$j) {
176 176
                                 // Manage NULL values
177
-                                $value = $row[$j] === null ? 'NULL' : '"' . addslashes(preg_replace("/\n/", '\\n', $row[$j])) . '"';                    
177
+                                $value = $row[$j] === null ? 'NULL' : '"'.addslashes(preg_replace("/\n/", '\\n', $row[$j])).'"';                    
178 178
                                 $return .= $value;
179 179
                                 if ($j < ($numFields - 1)) {
180 180
                                     $return .= ',';
@@ -192,8 +192,8 @@  discard block
 block discarded – undo
192 192
                 $token = GenerateCryptKey(20, false, true, true, false, true);
193 193
 
194 194
                 //save file
195
-                $filename = time() . '-' . $token . '.sql';
196
-                $handle = fopen($SETTINGS['path_to_files_folder'] . '/' . $filename, 'w+');
195
+                $filename = time().'-'.$token.'.sql';
196
+                $handle = fopen($SETTINGS['path_to_files_folder'].'/'.$filename, 'w+');
197 197
                 if ($handle !== false) {
198 198
                     //write file
199 199
                     fwrite($handle, $return);
@@ -205,16 +205,16 @@  discard block
 block discarded – undo
205 205
                     // Encrypt the file
206 206
                     prepareFileWithDefuse(
207 207
                         'encrypt',
208
-                        $SETTINGS['path_to_files_folder'] . '/' . $filename,
209
-                        $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $filename,
208
+                        $SETTINGS['path_to_files_folder'].'/'.$filename,
209
+                        $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$filename,
210 210
                         $post_key
211 211
                     );
212 212
 
213 213
                     // Do clean
214
-                    unlink($SETTINGS['path_to_files_folder'] . '/' . $filename);
214
+                    unlink($SETTINGS['path_to_files_folder'].'/'.$filename);
215 215
                     rename(
216
-                        $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $filename,
217
-                        $SETTINGS['path_to_files_folder'] . '/' . $filename
216
+                        $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$filename,
217
+                        $SETTINGS['path_to_files_folder'].'/'.$filename
218 218
                     );
219 219
                 }
220 220
 
@@ -234,9 +234,9 @@  discard block
 block discarded – undo
234 234
                     array(
235 235
                         'error' => false,
236 236
                         'message' => '',
237
-                        'download' => 'sources/downloadFile.php?name=' . urlencode($filename) .
238
-                            '&sub=files&file=' . $filename . '&type=sql&key=' . $session->get('key') . '&key_tmp=' .
239
-                            $session->get('user-key_tmp') . '&pathIsFiles=1',
237
+                        'download' => 'sources/downloadFile.php?name='.urlencode($filename).
238
+                            '&sub=files&file='.$filename.'&type=sql&key='.$session->get('key').'&key_tmp='.
239
+                            $session->get('user-key_tmp').'&pathIsFiles=1',
240 240
                     ),
241 241
                     'encode'
242 242
                 );
@@ -303,13 +303,13 @@  discard block
 block discarded – undo
303 303
             
304 304
             if (WIP === true) error_log('DEBUG: Offset -> '.$post_offset.'/'.$post_totalSize.' | File -> '.$post_clearFilename.' | key -> '.$post_key);
305 305
 
306
-            include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php';
306
+            include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php';
307 307
 
308 308
             if (empty($post_clearFilename) === true) {
309 309
                 // Get filename from database
310 310
                 $data = DB::queryFirstRow(
311 311
                     'SELECT valeur
312
-                    FROM ' . prefixTable('misc') . '
312
+                    FROM ' . prefixTable('misc').'
313 313
                     WHERE increment_id = %i',
314 314
                     $post_backupFile
315 315
                 );
@@ -329,8 +329,8 @@  discard block
 block discarded – undo
329 329
                     
330 330
                     $ret = prepareFileWithDefuse(
331 331
                         'decrypt',
332
-                        $SETTINGS['path_to_files_folder'] . '/' . $post_backupFile,
333
-                        $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $post_backupFile,
332
+                        $SETTINGS['path_to_files_folder'].'/'.$post_backupFile,
333
+                        $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$post_backupFile,
334 334
                         $post_key
335 335
                     );
336 336
                     
@@ -346,8 +346,8 @@  discard block
 block discarded – undo
346 346
                     }
347 347
 
348 348
                     // Do clean
349
-                    fileDelete($SETTINGS['path_to_files_folder'] . '/' . $post_backupFile, $SETTINGS);
350
-                    $post_backupFile = $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $post_backupFile;
349
+                    fileDelete($SETTINGS['path_to_files_folder'].'/'.$post_backupFile, $SETTINGS);
350
+                    $post_backupFile = $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$post_backupFile;
351 351
                 } else {
352 352
                     echo prepareExchangedData(
353 353
                         array(
Please login to merge, or discard this patch.
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -301,7 +301,9 @@
 block discarded – undo
301 301
                 break;
302 302
             }
303 303
             
304
-            if (WIP === true) error_log('DEBUG: Offset -> '.$post_offset.'/'.$post_totalSize.' | File -> '.$post_clearFilename.' | key -> '.$post_key);
304
+            if (WIP === true) {
305
+                error_log('DEBUG: Offset -> '.$post_offset.'/'.$post_totalSize.' | File -> '.$post_clearFilename.' | key -> '.$post_key);
306
+            }
305 307
 
306 308
             include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php';
307 309
 
Please login to merge, or discard this patch.