Passed
Push — wip_sessions ( 1d74a2...d4f5b4 )
by Nils
05:16
created
sources/main.functions.php 1 patch
Spacing   +149 added lines, -152 removed lines patch added patch discarded remove patch
@@ -50,7 +50,7 @@  discard block
 block discarded – undo
50 50
 
51 51
 // Load config if $SETTINGS not defined
52 52
 if (isset($SETTINGS['cpassman_dir']) === false || empty($SETTINGS['cpassman_dir']) === true) {
53
-    include_once __DIR__ . '/../includes/config/tp.config.php';
53
+    include_once __DIR__.'/../includes/config/tp.config.php';
54 54
 }
55 55
 
56 56
 header('Content-type: text/html; charset=utf-8');
@@ -219,7 +219,7 @@  discard block
 block discarded – undo
219 219
  */
220 220
 function trimElement($chaine, string $element): string
221 221
 {
222
-    if (! empty($chaine)) {
222
+    if (!empty($chaine)) {
223 223
         if (is_array($chaine) === true) {
224 224
             $chaine = implode(';', $chaine);
225 225
         }
@@ -267,8 +267,8 @@  discard block
 block discarded – undo
267 267
  */
268 268
 function db_error_handler(array $params): void
269 269
 {
270
-    echo 'Error: ' . $params['error'] . "<br>\n";
271
-    echo 'Query: ' . $params['query'] . "<br>\n";
270
+    echo 'Error: '.$params['error']."<br>\n";
271
+    echo 'Query: '.$params['query']."<br>\n";
272 272
     throw new Exception('Error - Query', 1);
273 273
 }
274 274
 
@@ -348,7 +348,7 @@  discard block
 block discarded – undo
348 348
     $globalsVisibleFolders = $session->get('user-accessible_folders');
349 349
     $globalsPersonalVisibleFolders = $session->get('user-personal_visible_folders');
350 350
     // Get list of Folders
351
-    $rows = DB::query('SELECT id FROM ' . prefixTable('nested_tree') . ' WHERE personal_folder = %i', 0);
351
+    $rows = DB::query('SELECT id FROM '.prefixTable('nested_tree').' WHERE personal_folder = %i', 0);
352 352
     foreach ($rows as $record) {
353 353
         array_push($groupesVisibles, $record['id']);
354 354
     }
@@ -367,7 +367,7 @@  discard block
 block discarded – undo
367 367
     }
368 368
     // Get ID of personal folder
369 369
     $persfld = DB::queryfirstrow(
370
-        'SELECT id FROM ' . prefixTable('nested_tree') . ' WHERE title = %s',
370
+        'SELECT id FROM '.prefixTable('nested_tree').' WHERE title = %s',
371 371
         $globalsUserId
372 372
     );
373 373
     if (empty($persfld['id']) === false) {
@@ -387,20 +387,20 @@  discard block
 block discarded – undo
387 387
     // get complete list of ROLES
388 388
     $tmp = explode(';', $idFonctions);
389 389
     $rows = DB::query(
390
-        'SELECT * FROM ' . prefixTable('roles_title') . '
390
+        'SELECT * FROM '.prefixTable('roles_title').'
391 391
         ORDER BY title ASC'
392 392
     );
393 393
     foreach ($rows as $record) {
394
-        if (! empty($record['id']) && ! in_array($record['id'], $tmp)) {
394
+        if (!empty($record['id']) && !in_array($record['id'], $tmp)) {
395 395
             array_push($tmp, $record['id']);
396 396
         }
397 397
     }
398 398
     $session->set('user-roles', implode(';', $tmp));
399 399
     $session->set('user-admin', 1);
400 400
     // Check if admin has created Folders and Roles
401
-    DB::query('SELECT * FROM ' . prefixTable('nested_tree') . '');
401
+    DB::query('SELECT * FROM '.prefixTable('nested_tree').'');
402 402
     $session->set('user-nb_folders', DB::count());
403
-    DB::query('SELECT * FROM ' . prefixTable('roles_title'));
403
+    DB::query('SELECT * FROM '.prefixTable('roles_title'));
404 404
     $session->set('user-nb_roles', DB::count());
405 405
 
406 406
     return true;
@@ -483,7 +483,7 @@  discard block
 block discarded – undo
483 483
     // Does this user is allowed to see other items
484 484
     $inc = 0;
485 485
     $rows = DB::query(
486
-        'SELECT id, id_tree FROM ' . prefixTable('items') . '
486
+        'SELECT id, id_tree FROM '.prefixTable('items').'
487 487
             WHERE restricted_to LIKE %ss AND inactif = %s'.
488 488
             (count($allowedFolders) > 0 ? ' AND id_tree NOT IN ('.implode(',', $allowedFolders).')' : ''),
489 489
         $globalsUserId,
@@ -500,8 +500,8 @@  discard block
 block discarded – undo
500 500
     // Check for the users roles if some specific rights exist on items
501 501
     $rows = DB::query(
502 502
         'SELECT i.id_tree, r.item_id
503
-        FROM ' . prefixTable('items') . ' as i
504
-        INNER JOIN ' . prefixTable('restriction_to_roles') . ' as r ON (r.item_id=i.id)
503
+        FROM ' . prefixTable('items').' as i
504
+        INNER JOIN ' . prefixTable('restriction_to_roles').' as r ON (r.item_id=i.id)
505 505
         WHERE i.id_tree <> "" '.
506 506
         (count($userRoles) > 0 ? 'AND r.role_id IN %li ' : '').
507 507
         'ORDER BY i.id_tree ASC',
@@ -555,16 +555,16 @@  discard block
 block discarded – undo
555 555
         ), SORT_NUMERIC)
556 556
     );
557 557
     // Folders and Roles numbers
558
-    DB::queryfirstrow('SELECT id FROM ' . prefixTable('nested_tree') . '');
558
+    DB::queryfirstrow('SELECT id FROM '.prefixTable('nested_tree').'');
559 559
     $session->set('user-nb_folders', DB::count());
560
-    DB::queryfirstrow('SELECT id FROM ' . prefixTable('roles_title'));
560
+    DB::queryfirstrow('SELECT id FROM '.prefixTable('roles_title'));
561 561
     $session->set('user-nb_roles', DB::count());
562 562
     // check if change proposals on User's items
563 563
     if (isset($SETTINGS['enable_suggestion']) === true && (int) $SETTINGS['enable_suggestion'] === 1) {
564 564
         $countNewItems = DB::query(
565 565
             'SELECT COUNT(*)
566
-            FROM ' . prefixTable('items_change') . ' AS c
567
-            LEFT JOIN ' . prefixTable('log_items') . ' AS i ON (c.item_id = i.id_item)
566
+            FROM ' . prefixTable('items_change').' AS c
567
+            LEFT JOIN ' . prefixTable('log_items').' AS i ON (c.item_id = i.id_item)
568 568
             WHERE i.action = %s AND i.id_user = %i',
569 569
             'at_creation',
570 570
             $globalsUserId
@@ -591,7 +591,7 @@  discard block
 block discarded – undo
591 591
 {
592 592
     $rows = DB::query(
593 593
         'SELECT *
594
-        FROM ' . prefixTable('roles_values') . '
594
+        FROM ' . prefixTable('roles_values').'
595 595
         WHERE type IN %ls'.(count($userRoles) > 0 ? ' AND role_id IN %li' : ''),
596 596
         ['W', 'ND', 'NE', 'NDNE', 'R'],
597 597
         $userRoles,
@@ -658,7 +658,7 @@  discard block
 block discarded – undo
658 658
     ) {
659 659
         $persoFld = DB::queryfirstrow(
660 660
             'SELECT id
661
-            FROM ' . prefixTable('nested_tree') . '
661
+            FROM ' . prefixTable('nested_tree').'
662 662
             WHERE title = %s AND personal_folder = %i'.
663 663
             (count($allowedFolders) > 0 ? ' AND id NOT IN ('.implode(',', $allowedFolders).')' : ''),
664 664
             $globalsUserId,
@@ -691,7 +691,7 @@  discard block
 block discarded – undo
691 691
     }
692 692
     $persoFlds = DB::query(
693 693
         'SELECT id
694
-        FROM ' . prefixTable('nested_tree') . '
694
+        FROM ' . prefixTable('nested_tree').'
695 695
         WHERE %l',
696 696
         $where
697 697
     );
@@ -759,12 +759,12 @@  discard block
 block discarded – undo
759 759
     //Load Tree
760 760
     $tree = new NestedTree(prefixTable('nested_tree'), 'id', 'parent_id', 'title');
761 761
     // truncate table
762
-    DB::query('TRUNCATE TABLE ' . prefixTable('cache'));
762
+    DB::query('TRUNCATE TABLE '.prefixTable('cache'));
763 763
     // reload date
764 764
     $rows = DB::query(
765 765
         'SELECT *
766
-        FROM ' . prefixTable('items') . ' as i
767
-        INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id)
766
+        FROM ' . prefixTable('items').' as i
767
+        INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id)
768 768
         AND l.action = %s
769 769
         AND i.inactif = %i',
770 770
         'at_creation',
@@ -776,18 +776,18 @@  discard block
 block discarded – undo
776 776
             $tags = '';
777 777
             $itemTags = DB::query(
778 778
                 'SELECT tag
779
-                FROM ' . prefixTable('tags') . '
779
+                FROM ' . prefixTable('tags').'
780 780
                 WHERE item_id = %i AND tag != ""',
781 781
                 $record['id']
782 782
             );
783 783
             foreach ($itemTags as $itemTag) {
784
-                $tags .= $itemTag['tag'] . ' ';
784
+                $tags .= $itemTag['tag'].' ';
785 785
             }
786 786
 
787 787
             // Get renewal period
788 788
             $resNT = DB::queryfirstrow(
789 789
                 'SELECT renewal_period
790
-                FROM ' . prefixTable('nested_tree') . '
790
+                FROM ' . prefixTable('nested_tree').'
791 791
                 WHERE id = %i',
792 792
                 $record['id_tree']
793 793
             );
@@ -800,7 +800,7 @@  discard block
 block discarded – undo
800 800
                     // Is this a User id?
801 801
                     $user = DB::queryfirstrow(
802 802
                         'SELECT id, login
803
-                        FROM ' . prefixTable('users') . '
803
+                        FROM ' . prefixTable('users').'
804 804
                         WHERE id = %i',
805 805
                         $elem->title
806 806
                     );
@@ -818,11 +818,11 @@  discard block
 block discarded – undo
818 818
                     'id' => $record['id'],
819 819
                     'label' => $record['label'],
820 820
                     'description' => $record['description'] ?? '',
821
-                    'url' => isset($record['url']) && ! empty($record['url']) ? $record['url'] : '0',
821
+                    'url' => isset($record['url']) && !empty($record['url']) ? $record['url'] : '0',
822 822
                     'tags' => $tags,
823 823
                     'id_tree' => $record['id_tree'],
824 824
                     'perso' => $record['perso'],
825
-                    'restricted_to' => isset($record['restricted_to']) && ! empty($record['restricted_to']) ? $record['restricted_to'] : '0',
825
+                    'restricted_to' => isset($record['restricted_to']) && !empty($record['restricted_to']) ? $record['restricted_to'] : '0',
826 826
                     'login' => $record['login'] ?? '',
827 827
                     'folder' => implode(' > ', $folder),
828 828
                     'author' => $record['id_user'],
@@ -851,7 +851,7 @@  discard block
 block discarded – undo
851 851
     // get new value from db
852 852
     $data = DB::queryfirstrow(
853 853
         'SELECT label, description, id_tree, perso, restricted_to, login, url
854
-        FROM ' . prefixTable('items') . '
854
+        FROM ' . prefixTable('items').'
855 855
         WHERE id=%i',
856 856
         $ident
857 857
     );
@@ -859,12 +859,12 @@  discard block
 block discarded – undo
859 859
     $tags = '';
860 860
     $itemTags = DB::query(
861 861
         'SELECT tag
862
-            FROM ' . prefixTable('tags') . '
862
+            FROM ' . prefixTable('tags').'
863 863
             WHERE item_id = %i AND tag != ""',
864 864
         $ident
865 865
     );
866 866
     foreach ($itemTags as $itemTag) {
867
-        $tags .= $itemTag['tag'] . ' ';
867
+        $tags .= $itemTag['tag'].' ';
868 868
     }
869 869
     // form id_tree to full foldername
870 870
     $folder = [];
@@ -875,7 +875,7 @@  discard block
 block discarded – undo
875 875
             // Is this a User id?
876 876
             $user = DB::queryfirstrow(
877 877
                 'SELECT id, login
878
-                FROM ' . prefixTable('users') . '
878
+                FROM ' . prefixTable('users').'
879 879
                 WHERE id = %i',
880 880
                 $elem->title
881 881
             );
@@ -893,10 +893,10 @@  discard block
 block discarded – undo
893 893
             'label' => $data['label'],
894 894
             'description' => $data['description'],
895 895
             'tags' => $tags,
896
-            'url' => isset($data['url']) && ! empty($data['url']) ? $data['url'] : '0',
896
+            'url' => isset($data['url']) && !empty($data['url']) ? $data['url'] : '0',
897 897
             'id_tree' => $data['id_tree'],
898 898
             'perso' => $data['perso'],
899
-            'restricted_to' => isset($data['restricted_to']) && ! empty($data['restricted_to']) ? $data['restricted_to'] : '0',
899
+            'restricted_to' => isset($data['restricted_to']) && !empty($data['restricted_to']) ? $data['restricted_to'] : '0',
900 900
             'login' => $data['login'] ?? '',
901 901
             'folder' => implode(' » ', $folder),
902 902
             'author' => $session->get('user-id'),
@@ -926,8 +926,8 @@  discard block
 block discarded – undo
926 926
     // get new value from db
927 927
     $data = DB::queryFirstRow(
928 928
         'SELECT i.label, i.description, i.id_tree as id_tree, i.perso, i.restricted_to, i.id, i.login, i.url, l.date
929
-        FROM ' . prefixTable('items') . ' as i
930
-        INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id)
929
+        FROM ' . prefixTable('items').' as i
930
+        INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id)
931 931
         WHERE i.id = %i
932 932
         AND l.action = %s',
933 933
         $ident,
@@ -937,12 +937,12 @@  discard block
 block discarded – undo
937 937
     $tags = '';
938 938
     $itemTags = DB::query(
939 939
         'SELECT tag
940
-            FROM ' . prefixTable('tags') . '
940
+            FROM ' . prefixTable('tags').'
941 941
             WHERE item_id = %i AND tag != ""',
942 942
         $ident
943 943
     );
944 944
     foreach ($itemTags as $itemTag) {
945
-        $tags .= $itemTag['tag'] . ' ';
945
+        $tags .= $itemTag['tag'].' ';
946 946
     }
947 947
     // form id_tree to full foldername
948 948
     $folder = [];
@@ -953,7 +953,7 @@  discard block
 block discarded – undo
953 953
             // Is this a User id?
954 954
             $user = DB::queryfirstrow(
955 955
                 'SELECT id, login
956
-                FROM ' . prefixTable('users') . '
956
+                FROM ' . prefixTable('users').'
957 957
                 WHERE id = %i',
958 958
                 $elem->title
959 959
             );
@@ -972,7 +972,7 @@  discard block
 block discarded – undo
972 972
             'label' => $data['label'],
973 973
             'description' => $data['description'],
974 974
             'tags' => isset($tags) && empty($tags) === false ? $tags : 'None',
975
-            'url' => isset($data['url']) && ! empty($data['url']) ? $data['url'] : '0',
975
+            'url' => isset($data['url']) && !empty($data['url']) ? $data['url'] : '0',
976 976
             'id_tree' => $data['id_tree'],
977 977
             'perso' => isset($data['perso']) && empty($data['perso']) === false && $data['perso'] !== 'None' ? $data['perso'] : '0',
978 978
             'restricted_to' => isset($data['restricted_to']) && empty($data['restricted_to']) === false ? $data['restricted_to'] : '0',
@@ -994,52 +994,52 @@  discard block
 block discarded – undo
994 994
 function getStatisticsData(array $SETTINGS): array
995 995
 {
996 996
     DB::query(
997
-        'SELECT id FROM ' . prefixTable('nested_tree') . ' WHERE personal_folder = %i',
997
+        'SELECT id FROM '.prefixTable('nested_tree').' WHERE personal_folder = %i',
998 998
         0
999 999
     );
1000 1000
     $counter_folders = DB::count();
1001 1001
     DB::query(
1002
-        'SELECT id FROM ' . prefixTable('nested_tree') . ' WHERE personal_folder = %i',
1002
+        'SELECT id FROM '.prefixTable('nested_tree').' WHERE personal_folder = %i',
1003 1003
         1
1004 1004
     );
1005 1005
     $counter_folders_perso = DB::count();
1006 1006
     DB::query(
1007
-        'SELECT id FROM ' . prefixTable('items') . ' WHERE perso = %i',
1007
+        'SELECT id FROM '.prefixTable('items').' WHERE perso = %i',
1008 1008
         0
1009 1009
     );
1010 1010
     $counter_items = DB::count();
1011 1011
         DB::query(
1012
-        'SELECT id FROM ' . prefixTable('items') . ' WHERE perso = %i',
1012
+        'SELECT id FROM '.prefixTable('items').' WHERE perso = %i',
1013 1013
         1
1014 1014
     );
1015 1015
     $counter_items_perso = DB::count();
1016 1016
         DB::query(
1017
-        'SELECT id FROM ' . prefixTable('users') . ''
1017
+        'SELECT id FROM '.prefixTable('users').''
1018 1018
     );
1019 1019
     $counter_users = DB::count();
1020 1020
         DB::query(
1021
-        'SELECT id FROM ' . prefixTable('users') . ' WHERE admin = %i',
1021
+        'SELECT id FROM '.prefixTable('users').' WHERE admin = %i',
1022 1022
         1
1023 1023
     );
1024 1024
     $admins = DB::count();
1025 1025
     DB::query(
1026
-        'SELECT id FROM ' . prefixTable('users') . ' WHERE gestionnaire = %i',
1026
+        'SELECT id FROM '.prefixTable('users').' WHERE gestionnaire = %i',
1027 1027
         1
1028 1028
     );
1029 1029
     $managers = DB::count();
1030 1030
     DB::query(
1031
-        'SELECT id FROM ' . prefixTable('users') . ' WHERE read_only = %i',
1031
+        'SELECT id FROM '.prefixTable('users').' WHERE read_only = %i',
1032 1032
         1
1033 1033
     );
1034 1034
     $readOnly = DB::count();
1035 1035
     // list the languages
1036 1036
     $usedLang = [];
1037 1037
     $tp_languages = DB::query(
1038
-        'SELECT name FROM ' . prefixTable('languages')
1038
+        'SELECT name FROM '.prefixTable('languages')
1039 1039
     );
1040 1040
     foreach ($tp_languages as $tp_language) {
1041 1041
         DB::query(
1042
-            'SELECT * FROM ' . prefixTable('users') . ' WHERE user_language = %s',
1042
+            'SELECT * FROM '.prefixTable('users').' WHERE user_language = %s',
1043 1043
             $tp_language['name']
1044 1044
         );
1045 1045
         $usedLang[$tp_language['name']] = round((DB::count() * 100 / $counter_users), 0);
@@ -1048,12 +1048,12 @@  discard block
 block discarded – undo
1048 1048
     // get list of ips
1049 1049
     $usedIp = [];
1050 1050
     $tp_ips = DB::query(
1051
-        'SELECT user_ip FROM ' . prefixTable('users')
1051
+        'SELECT user_ip FROM '.prefixTable('users')
1052 1052
     );
1053 1053
     foreach ($tp_ips as $ip) {
1054 1054
         if (array_key_exists($ip['user_ip'], $usedIp)) {
1055 1055
             $usedIp[$ip['user_ip']] += $usedIp[$ip['user_ip']];
1056
-        } elseif (! empty($ip['user_ip']) && $ip['user_ip'] !== 'none') {
1056
+        } elseif (!empty($ip['user_ip']) && $ip['user_ip'] !== 'none') {
1057 1057
             $usedIp[$ip['user_ip']] = 1;
1058 1058
         }
1059 1059
     }
@@ -1206,7 +1206,7 @@  discard block
 block discarded – undo
1206 1206
 {
1207 1207
     // Load PHPMailer
1208 1208
     $mail = new PHPMailer(true);
1209
-    $languageDir = $SETTINGS['cpassman_dir'] . '/vendor/phpmailer/phpmailer/language/';
1209
+    $languageDir = $SETTINGS['cpassman_dir'].'/vendor/phpmailer/phpmailer/language/';
1210 1210
 
1211 1211
     try {
1212 1212
         // Set language and SMTPDebug
@@ -1297,7 +1297,7 @@  discard block
 block discarded – undo
1297 1297
         <table width="600" cellpadding="0" cellspacing="0" border="0" class="container" bgcolor="#ffffff" style="border-spacing: 0; border-bottom: 1px solid #e0e0e0; box-shadow: 0 0 3px #ddd; color: #434343; font-family: Helvetica, Verdana, sans-serif;">
1298 1298
         <tr><td class="container-padding" bgcolor="#ffffff" style="border-collapse: collapse; border-left: 1px solid #e0e0e0; background-color: #ffffff; padding-left: 30px; padding-right: 30px;">
1299 1299
         <br><div style="float:right;">' .
1300
-        $textMail .
1300
+        $textMail.
1301 1301
         '<br><br></td></tr></table>
1302 1302
     </td></tr></table>
1303 1303
     <br></body></html>';
@@ -1310,7 +1310,7 @@  discard block
 block discarded – undo
1310 1310
  */
1311 1311
 function generateKey(): string
1312 1312
 {
1313
-    return substr(md5(rand() . rand()), 0, 15);
1313
+    return substr(md5(rand().rand()), 0, 15);
1314 1314
 }
1315 1315
 
1316 1316
 /**
@@ -1388,7 +1388,7 @@  discard block
 block discarded – undo
1388 1388
 {
1389 1389
     array_walk_recursive(
1390 1390
         $array,
1391
-        static function (&$item): void {
1391
+        static function(&$item): void {
1392 1392
             if (mb_detect_encoding((string) $item, 'utf-8', true) === false) {
1393 1393
                 $item = mb_convert_encoding($item, 'ISO-8859-1', 'UTF-8');
1394 1394
             }
@@ -1481,7 +1481,7 @@  discard block
 block discarded – undo
1481 1481
  */
1482 1482
 function prefixTable(string $table): string
1483 1483
 {
1484
-    $safeTable = htmlspecialchars(DB_PREFIX . $table);
1484
+    $safeTable = htmlspecialchars(DB_PREFIX.$table);
1485 1485
     if (empty($safeTable) === false) {
1486 1486
         // sanitize string
1487 1487
         return $safeTable;
@@ -1545,7 +1545,7 @@  discard block
 block discarded – undo
1545 1545
 function send_syslog($message, $host, $port, $component = 'teampass'): void
1546 1546
 {
1547 1547
     $sock = socket_create(AF_INET, SOCK_DGRAM, SOL_UDP);
1548
-    $syslog_message = '<123>' . date('M d H:i:s ') . $component . ': ' . $message;
1548
+    $syslog_message = '<123>'.date('M d H:i:s ').$component.': '.$message;
1549 1549
     socket_sendto($sock, (string) $syslog_message, strlen($syslog_message), 0, (string) $host, (int) $port);
1550 1550
     socket_close($sock);
1551 1551
 }
@@ -1592,14 +1592,14 @@  discard block
 block discarded – undo
1592 1592
     if (isset($SETTINGS['syslog_enable']) === true && (int) $SETTINGS['syslog_enable'] === 1) {
1593 1593
         if ($type === 'user_mngt') {
1594 1594
             send_syslog(
1595
-                'action=' . str_replace('at_', '', $label) . ' attribute=user user=' . $who . ' userid="' . $login . '" change="' . $field_1 . '" ',
1595
+                'action='.str_replace('at_', '', $label).' attribute=user user='.$who.' userid="'.$login.'" change="'.$field_1.'" ',
1596 1596
                 $SETTINGS['syslog_host'],
1597 1597
                 $SETTINGS['syslog_port'],
1598 1598
                 'teampass'
1599 1599
             );
1600 1600
         } else {
1601 1601
             send_syslog(
1602
-                'action=' . $type . ' attribute=' . $label . ' user=' . $who . ' userid="' . $login . '" ',
1602
+                'action='.$type.' attribute='.$label.' user='.$who.' userid="'.$login.'" ',
1603 1603
                 $SETTINGS['syslog_host'],
1604 1604
                 $SETTINGS['syslog_port'],
1605 1605
                 'teampass'
@@ -1673,7 +1673,7 @@  discard block
 block discarded – undo
1673 1673
         if (empty($item_label) === true) {
1674 1674
             $dataItem = DB::queryfirstrow(
1675 1675
                 'SELECT id, id_tree, label
1676
-                FROM ' . prefixTable('items') . '
1676
+                FROM ' . prefixTable('items').'
1677 1677
                 WHERE id = %i',
1678 1678
                 $item_id
1679 1679
             );
@@ -1681,11 +1681,11 @@  discard block
 block discarded – undo
1681 1681
         }
1682 1682
 
1683 1683
         send_syslog(
1684
-            'action=' . str_replace('at_', '', $action) .
1685
-                ' attribute=' . str_replace('at_', '', $attribute[0]) .
1686
-                ' itemno=' . $item_id .
1687
-                ' user=' . is_null($login) === true ? '' : addslashes((string) $login) .
1688
-                ' itemname="' . addslashes($item_label) . '"',
1684
+            'action='.str_replace('at_', '', $action).
1685
+                ' attribute='.str_replace('at_', '', $attribute[0]).
1686
+                ' itemno='.$item_id.
1687
+                ' user='.is_null($login) === true ? '' : addslashes((string) $login).
1688
+                ' itemname="'.addslashes($item_label).'"',
1689 1689
             $SETTINGS['syslog_host'],
1690 1690
             $SETTINGS['syslog_port'],
1691 1691
             'teampass'
@@ -1717,8 +1717,8 @@  discard block
 block discarded – undo
1717 1717
     $notification = DB::queryOneColumn(
1718 1718
         'email',
1719 1719
         'SELECT *
1720
-        FROM ' . prefixTable('notification') . ' AS n
1721
-        INNER JOIN ' . prefixTable('users') . ' AS u ON (n.user_id = u.id)
1720
+        FROM ' . prefixTable('notification').' AS n
1721
+        INNER JOIN ' . prefixTable('users').' AS u ON (n.user_id = u.id)
1722 1722
         WHERE n.item_id = %i AND n.user_id != %i',
1723 1723
         $item_id,
1724 1724
         $globalsUserId
@@ -1729,7 +1729,7 @@  discard block
 block discarded – undo
1729 1729
         // Get list of changes
1730 1730
         $htmlChanges = '<ul>';
1731 1731
         foreach ($changes as $change) {
1732
-            $htmlChanges .= '<li>' . $change . '</li>';
1732
+            $htmlChanges .= '<li>'.$change.'</li>';
1733 1733
         }
1734 1734
         $htmlChanges .= '</ul>';
1735 1735
         // send email
@@ -1766,15 +1766,15 @@  discard block
 block discarded – undo
1766 1766
     $path = '';
1767 1767
     foreach ($arbo as $elem) {
1768 1768
         if (empty($path) === true) {
1769
-            $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES) . ' ';
1769
+            $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES).' ';
1770 1770
         } else {
1771
-            $path .= '&#8594; ' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES);
1771
+            $path .= '&#8594; '.htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES);
1772 1772
         }
1773 1773
     }
1774 1774
 
1775 1775
     // Build text to show user
1776 1776
     if (empty($label) === false) {
1777
-        return empty($path) === true ? addslashes($label) : addslashes($label) . ' (' . $path . ')';
1777
+        return empty($path) === true ? addslashes($label) : addslashes($label).' ('.$path.')';
1778 1778
     }
1779 1779
     return empty($path) === true ? '' : $path;
1780 1780
 }
@@ -1831,7 +1831,7 @@  discard block
 block discarded – undo
1831 1831
  */
1832 1832
 function handleConfigFile($action, $SETTINGS, $field = null, $value = null)
1833 1833
 {
1834
-    $tp_config_file = $SETTINGS['cpassman_dir'] . '/includes/config/tp.config.php';
1834
+    $tp_config_file = $SETTINGS['cpassman_dir'].'/includes/config/tp.config.php';
1835 1835
 
1836 1836
     // Load class DB
1837 1837
     loadClasses('DB');
@@ -1839,8 +1839,8 @@  discard block
 block discarded – undo
1839 1839
     if (file_exists($tp_config_file) === false || $action === 'rebuild') {
1840 1840
         // perform a copy
1841 1841
         if (file_exists($tp_config_file)) {
1842
-            if (! copy($tp_config_file, $tp_config_file . '.' . date('Y_m_d_His', time()))) {
1843
-                return "ERROR: Could not copy file '" . $tp_config_file . "'";
1842
+            if (!copy($tp_config_file, $tp_config_file.'.'.date('Y_m_d_His', time()))) {
1843
+                return "ERROR: Could not copy file '".$tp_config_file."'";
1844 1844
             }
1845 1845
         }
1846 1846
 
@@ -1850,11 +1850,11 @@  discard block
 block discarded – undo
1850 1850
         $data[1] = "global \$SETTINGS;\n";
1851 1851
         $data[2] = "\$SETTINGS = array (\n";
1852 1852
         $rows = DB::query(
1853
-            'SELECT * FROM ' . prefixTable('misc') . ' WHERE type=%s',
1853
+            'SELECT * FROM '.prefixTable('misc').' WHERE type=%s',
1854 1854
             'admin'
1855 1855
         );
1856 1856
         foreach ($rows as $record) {
1857
-            array_push($data, "    '" . $record['intitule'] . "' => '" . htmlspecialchars_decode($record['valeur'], ENT_COMPAT) . "',\n");
1857
+            array_push($data, "    '".$record['intitule']."' => '".htmlspecialchars_decode($record['valeur'], ENT_COMPAT)."',\n");
1858 1858
         }
1859 1859
         array_push($data, ");\n");
1860 1860
         $data = array_unique($data);
@@ -1868,15 +1868,15 @@  discard block
 block discarded – undo
1868 1868
                 break;
1869 1869
             }
1870 1870
 
1871
-            if (stristr($line, "'" . $field . "' => '")) {
1872
-                $data[$inc] = "    '" . $field . "' => '" . htmlspecialchars_decode($value ?? '', ENT_COMPAT) . "',\n";
1871
+            if (stristr($line, "'".$field."' => '")) {
1872
+                $data[$inc] = "    '".$field."' => '".htmlspecialchars_decode($value ?? '', ENT_COMPAT)."',\n";
1873 1873
                 $bFound = true;
1874 1874
                 break;
1875 1875
             }
1876 1876
             ++$inc;
1877 1877
         }
1878 1878
         if ($bFound === false) {
1879
-            $data[$inc] = "    '" . $field . "' => '" . htmlspecialchars_decode($value ?? '', ENT_COMPAT). "',\n);\n";
1879
+            $data[$inc] = "    '".$field."' => '".htmlspecialchars_decode($value ?? '', ENT_COMPAT)."',\n);\n";
1880 1880
         }
1881 1881
     }
1882 1882
 
@@ -1906,7 +1906,7 @@  discard block
 block discarded – undo
1906 1906
 {
1907 1907
     global $SETTINGS;
1908 1908
     /* LOAD CPASSMAN SETTINGS */
1909
-    if (! isset($SETTINGS['loaded']) || $SETTINGS['loaded'] !== 1) {
1909
+    if (!isset($SETTINGS['loaded']) || $SETTINGS['loaded'] !== 1) {
1910 1910
         $SETTINGS = [];
1911 1911
         $SETTINGS['duplicate_folder'] = 0;
1912 1912
         //by default, this is set to 0;
@@ -1916,7 +1916,7 @@  discard block
 block discarded – undo
1916 1916
         //by default, this value is set to 5;
1917 1917
         $settings = [];
1918 1918
         $rows = DB::query(
1919
-            'SELECT * FROM ' . prefixTable('misc') . ' WHERE type=%s_type OR type=%s_type2',
1919
+            'SELECT * FROM '.prefixTable('misc').' WHERE type=%s_type OR type=%s_type2',
1920 1920
             [
1921 1921
                 'type' => 'admin',
1922 1922
                 'type2' => 'settings',
@@ -1948,7 +1948,7 @@  discard block
 block discarded – undo
1948 1948
     $source_cf = [];
1949 1949
     $rows = DB::QUERY(
1950 1950
         'SELECT id_category
1951
-            FROM ' . prefixTable('categories_folders') . '
1951
+            FROM ' . prefixTable('categories_folders').'
1952 1952
             WHERE id_folder = %i',
1953 1953
         $source_id
1954 1954
     );
@@ -1959,7 +1959,7 @@  discard block
 block discarded – undo
1959 1959
     $target_cf = [];
1960 1960
     $rows = DB::QUERY(
1961 1961
         'SELECT id_category
1962
-            FROM ' . prefixTable('categories_folders') . '
1962
+            FROM ' . prefixTable('categories_folders').'
1963 1963
             WHERE id_folder = %i',
1964 1964
         $target_id
1965 1965
     );
@@ -2177,7 +2177,7 @@  discard block
 block discarded – undo
2177 2177
     int  $dirPerm = 0755
2178 2178
 ) {
2179 2179
     // Check if the path exists
2180
-    if (! file_exists($path)) {
2180
+    if (!file_exists($path)) {
2181 2181
         return false;
2182 2182
     }
2183 2183
 
@@ -2230,7 +2230,7 @@  discard block
 block discarded – undo
2230 2230
     // Load item data
2231 2231
     $data = DB::queryFirstRow(
2232 2232
         'SELECT id_tree
2233
-        FROM ' . prefixTable('items') . '
2233
+        FROM ' . prefixTable('items').'
2234 2234
         WHERE id = %i',
2235 2235
         $item_id
2236 2236
     );
@@ -2293,7 +2293,7 @@  discard block
 block discarded – undo
2293 2293
         }
2294 2294
         $host .= substr(explode(".", $email[1])[0], -1, 1);
2295 2295
     }
2296
-    $email = $name . "@" . $host . "." . explode(".", $email[1])[1];
2296
+    $email = $name."@".$host.".".explode(".", $email[1])[1];
2297 2297
     return $email;
2298 2298
 }
2299 2299
 
@@ -2316,7 +2316,7 @@  discard block
 block discarded – undo
2316 2316
     
2317 2317
     // Insert log in DB
2318 2318
     return DB::query(
2319
-        'SELECT ' . $fields . '
2319
+        'SELECT '.$fields.'
2320 2320
         FROM ' . prefixTable($table)
2321 2321
     );
2322 2322
 }
@@ -2331,11 +2331,11 @@  discard block
 block discarded – undo
2331 2331
 function formatSizeUnits(int $bytes): string
2332 2332
 {
2333 2333
     if ($bytes >= 1073741824) {
2334
-        $bytes = number_format($bytes / 1073741824, 2) . ' GB';
2334
+        $bytes = number_format($bytes / 1073741824, 2).' GB';
2335 2335
     } elseif ($bytes >= 1048576) {
2336
-        $bytes = number_format($bytes / 1048576, 2) . ' MB';
2336
+        $bytes = number_format($bytes / 1048576, 2).' MB';
2337 2337
     } elseif ($bytes >= 1024) {
2338
-        $bytes = number_format($bytes / 1024, 2) . ' KB';
2338
+        $bytes = number_format($bytes / 1024, 2).' KB';
2339 2339
     } elseif ($bytes > 1) {
2340 2340
         $bytes .= ' bytes';
2341 2341
     } elseif ($bytes === 1) {
@@ -2548,7 +2548,7 @@  discard block
 block discarded – undo
2548 2548
             return '';
2549 2549
         }
2550 2550
     } catch (Exception $e) {
2551
-        return 'Exception: ' . $e->getMessage();
2551
+        return 'Exception: '.$e->getMessage();
2552 2552
     }
2553 2553
 }
2554 2554
 
@@ -2578,16 +2578,16 @@  discard block
 block discarded – undo
2578 2578
     $cipher->enableContinuousBuffer();
2579 2579
 
2580 2580
     // Encrypt the file content
2581
-    $filePath = filter_var($fileInPath . '/' . $fileInName, FILTER_SANITIZE_URL);
2581
+    $filePath = filter_var($fileInPath.'/'.$fileInName, FILTER_SANITIZE_URL);
2582 2582
     $fileContent = file_get_contents($filePath);
2583 2583
     $plaintext = $antiXSS->xss_clean($fileContent);
2584 2584
     $ciphertext = $cipher->encrypt($plaintext);
2585 2585
 
2586 2586
     // Save new file
2587 2587
     $hash = md5($plaintext);
2588
-    $fileOut = $fileInPath . '/' . TP_FILE_PREFIX . $hash;
2588
+    $fileOut = $fileInPath.'/'.TP_FILE_PREFIX.$hash;
2589 2589
     file_put_contents($fileOut, $ciphertext);
2590
-    unlink($fileInPath . '/' . $fileInName);
2590
+    unlink($fileInPath.'/'.$fileInName);
2591 2591
     return [
2592 2592
         'fileHash' => base64_encode($hash),
2593 2593
         'objectKey' => base64_encode($objectKey),
@@ -2605,7 +2605,7 @@  discard block
 block discarded – undo
2605 2605
  */
2606 2606
 function decryptFile(string $fileName, string $filePath, string $key): string
2607 2607
 {
2608
-    if (! defined('FILE_BUFFER_SIZE')) {
2608
+    if (!defined('FILE_BUFFER_SIZE')) {
2609 2609
         define('FILE_BUFFER_SIZE', 128 * 1024);
2610 2610
     }
2611 2611
     
@@ -2622,7 +2622,7 @@  discard block
 block discarded – undo
2622 2622
     $cipher->enableContinuousBuffer();
2623 2623
     $cipher->disablePadding();
2624 2624
     // Get file content
2625
-    $safeFilePath = $filePath . '/' . TP_FILE_PREFIX . $safeFileName;
2625
+    $safeFilePath = $filePath.'/'.TP_FILE_PREFIX.$safeFileName;
2626 2626
     $ciphertext = file_get_contents(filter_var($safeFilePath, FILTER_SANITIZE_URL));
2627 2627
 
2628 2628
     // Decrypt file content and return
@@ -2703,8 +2703,8 @@  discard block
 block discarded – undo
2703 2703
         // Only create the sharekey for a user
2704 2704
         $user = DB::queryFirstRow(
2705 2705
             'SELECT public_key
2706
-            FROM ' . prefixTable('users') . '
2707
-            WHERE id = ' . (int) $session->get('user-id') . '
2706
+            FROM ' . prefixTable('users').'
2707
+            WHERE id = ' . (int) $session->get('user-id').'
2708 2708
             AND public_key != ""'
2709 2709
         );
2710 2710
 
@@ -2740,10 +2740,9 @@  discard block
 block discarded – undo
2740 2740
         //DB::debugmode(true);
2741 2741
         $users = DB::query(
2742 2742
             'SELECT id, public_key
2743
-            FROM ' . prefixTable('users') . '
2743
+            FROM ' . prefixTable('users').'
2744 2744
             WHERE ' . ($onlyForUser === true ? 
2745
-                'id IN ("' . TP_USER_ID . '","' . $session->get('user-id') . '") ' : 
2746
-                'id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '") ') . '
2745
+                'id IN ("'.TP_USER_ID.'","'.$session->get('user-id').'") ' : 'id NOT IN ("'.OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'") ').'
2747 2746
             AND public_key != ""'
2748 2747
         );
2749 2748
         //DB::debugmode(false);
@@ -2790,7 +2789,7 @@  discard block
 block discarded – undo
2790 2789
 function isBase64(string $str): bool
2791 2790
 {
2792 2791
     $str = (string) trim($str);
2793
-    if (! isset($str[0])) {
2792
+    if (!isset($str[0])) {
2794 2793
         return false;
2795 2794
     }
2796 2795
 
@@ -2863,7 +2862,7 @@  discard block
 block discarded – undo
2863 2862
         $connection->connect();
2864 2863
     } catch (\LdapRecord\Auth\BindException $e) {
2865 2864
         $error = $e->getDetailedError();
2866
-        echo 'Error : '.$error->getErrorCode().' - '.$error->getErrorMessage(). '<br>'.$error->getDiagnosticMessage();
2865
+        echo 'Error : '.$error->getErrorCode().' - '.$error->getErrorMessage().'<br>'.$error->getDiagnosticMessage();
2867 2866
         return false;
2868 2867
     }
2869 2868
 
@@ -2876,7 +2875,7 @@  discard block
 block discarded – undo
2876 2875
         }
2877 2876
     } catch (\LdapRecord\Auth\BindException $e) {
2878 2877
         $error = $e->getDetailedError();
2879
-        echo 'Error : '.$error->getErrorCode().' - '.$error->getErrorMessage(). '<br>'.$error->getDiagnosticMessage();
2878
+        echo 'Error : '.$error->getErrorCode().' - '.$error->getErrorMessage().'<br>'.$error->getDiagnosticMessage();
2880 2879
         return false;
2881 2880
     }
2882 2881
 
@@ -2900,7 +2899,7 @@  discard block
 block discarded – undo
2900 2899
     // expect if personal item
2901 2900
     DB::delete(
2902 2901
         prefixTable('sharekeys_items'),
2903
-        'user_id = %i AND object_id NOT IN (SELECT i.id FROM ' . prefixTable('items') . ' AS i WHERE i.perso = 1)',
2902
+        'user_id = %i AND object_id NOT IN (SELECT i.id FROM '.prefixTable('items').' AS i WHERE i.perso = 1)',
2904 2903
         $userId
2905 2904
     );
2906 2905
     // Remove all item sharekeys files
@@ -2908,8 +2907,8 @@  discard block
 block discarded – undo
2908 2907
         prefixTable('sharekeys_files'),
2909 2908
         'user_id = %i AND object_id NOT IN (
2910 2909
             SELECT f.id 
2911
-            FROM ' . prefixTable('items') . ' AS i 
2912
-            INNER JOIN ' . prefixTable('files') . ' AS f ON f.id_item = i.id
2910
+            FROM ' . prefixTable('items').' AS i 
2911
+            INNER JOIN ' . prefixTable('files').' AS f ON f.id_item = i.id
2913 2912
             WHERE i.perso = 1
2914 2913
         )',
2915 2914
         $userId
@@ -2919,8 +2918,8 @@  discard block
 block discarded – undo
2919 2918
         prefixTable('sharekeys_fields'),
2920 2919
         'user_id = %i AND object_id NOT IN (
2921 2920
             SELECT c.id 
2922
-            FROM ' . prefixTable('items') . ' AS i 
2923
-            INNER JOIN ' . prefixTable('categories_items') . ' AS c ON c.item_id = i.id
2921
+            FROM ' . prefixTable('items').' AS i 
2922
+            INNER JOIN ' . prefixTable('categories_items').' AS c ON c.item_id = i.id
2924 2923
             WHERE i.perso = 1
2925 2924
         )',
2926 2925
         $userId
@@ -2928,13 +2927,13 @@  discard block
 block discarded – undo
2928 2927
     // Remove all item sharekeys logs
2929 2928
     DB::delete(
2930 2929
         prefixTable('sharekeys_logs'),
2931
-        'user_id = %i AND object_id NOT IN (SELECT i.id FROM ' . prefixTable('items') . ' AS i WHERE i.perso = 1)',
2930
+        'user_id = %i AND object_id NOT IN (SELECT i.id FROM '.prefixTable('items').' AS i WHERE i.perso = 1)',
2932 2931
         $userId
2933 2932
     );
2934 2933
     // Remove all item sharekeys suggestions
2935 2934
     DB::delete(
2936 2935
         prefixTable('sharekeys_suggestions'),
2937
-        'user_id = %i AND object_id NOT IN (SELECT i.id FROM ' . prefixTable('items') . ' AS i WHERE i.perso = 1)',
2936
+        'user_id = %i AND object_id NOT IN (SELECT i.id FROM '.prefixTable('items').' AS i WHERE i.perso = 1)',
2938 2937
         $userId
2939 2938
     );
2940 2939
     return false;
@@ -2955,7 +2954,7 @@  discard block
 block discarded – undo
2955 2954
         foreach (DateTimeZone::listIdentifiers() as $timezone) {
2956 2955
             $now->setTimezone(new DateTimeZone($timezone));
2957 2956
             $offsets[] = $offset = $now->getOffset();
2958
-            $timezones[$timezone] = '(' . format_GMT_offset($offset) . ') ' . format_timezone_name($timezone);
2957
+            $timezones[$timezone] = '('.format_GMT_offset($offset).') '.format_timezone_name($timezone);
2959 2958
         }
2960 2959
 
2961 2960
         array_multisort($offsets, $timezones);
@@ -2975,7 +2974,7 @@  discard block
 block discarded – undo
2975 2974
 {
2976 2975
     $hours = intval($offset / 3600);
2977 2976
     $minutes = abs(intval($offset % 3600 / 60));
2978
-    return 'GMT' . ($offset ? sprintf('%+03d:%02d', $hours, $minutes) : '');
2977
+    return 'GMT'.($offset ? sprintf('%+03d:%02d', $hours, $minutes) : '');
2979 2978
 }
2980 2979
 
2981 2980
 /**
@@ -3075,8 +3074,7 @@  discard block
 block discarded – undo
3075 3074
 {
3076 3075
     if (isset($array[$key]) === true
3077 3076
         && (is_int($value) === true ?
3078
-            (int) $array[$key] === $value :
3079
-            (string) $array[$key] === $value)
3077
+            (int) $array[$key] === $value : (string) $array[$key] === $value)
3080 3078
     ) {
3081 3079
         return true;
3082 3080
     }
@@ -3098,8 +3096,7 @@  discard block
 block discarded – undo
3098 3096
 {
3099 3097
     if (isset($var) === false
3100 3098
         || (is_int($value) === true ?
3101
-            (int) $var === $value :
3102
-            (string) $var === $value)
3099
+            (int) $var === $value : (string) $var === $value)
3103 3100
     ) {
3104 3101
         return true;
3105 3102
     }
@@ -3150,7 +3147,7 @@  discard block
 block discarded – undo
3150 3147
  */
3151 3148
 function isSetArrayOfValues(array $arrayOfValues): bool
3152 3149
 {
3153
-    foreach($arrayOfValues as $value) {
3150
+    foreach ($arrayOfValues as $value) {
3154 3151
         if (isset($value) === false) {
3155 3152
             return false;
3156 3153
         }
@@ -3172,7 +3169,7 @@  discard block
 block discarded – undo
3172 3169
     /*PHP8 - integer|string*/$value
3173 3170
 ) : bool
3174 3171
 {
3175
-    foreach($arrayOfVars as $variable) {
3172
+    foreach ($arrayOfVars as $variable) {
3176 3173
         if ($variable !== $value) {
3177 3174
             return false;
3178 3175
         }
@@ -3192,7 +3189,7 @@  discard block
 block discarded – undo
3192 3189
     /*PHP8 - integer|string*/$value
3193 3190
 ) : bool
3194 3191
 {
3195
-    foreach($arrayOfVars as $variable) {
3192
+    foreach ($arrayOfVars as $variable) {
3196 3193
         if ($variable === $value) {
3197 3194
             return true;
3198 3195
         }
@@ -3260,7 +3257,7 @@  discard block
 block discarded – undo
3260 3257
  * @param array     $filters
3261 3258
  * @return array|string
3262 3259
  */
3263
-function dataSanitizer(array $data, array $filters): array|string
3260
+function dataSanitizer(array $data, array $filters): array | string
3264 3261
 {
3265 3262
     // Load Sanitizer library
3266 3263
     $sanitizer = new Sanitizer($data, $filters);
@@ -3289,7 +3286,7 @@  discard block
 block discarded – undo
3289 3286
     // Exists ?
3290 3287
     $userCacheId = DB::queryfirstrow(
3291 3288
         'SELECT increment_id
3292
-        FROM ' . prefixTable('cache_tree') . '
3289
+        FROM ' . prefixTable('cache_tree').'
3293 3290
         WHERE user_id = %i',
3294 3291
         $user_id
3295 3292
     );
@@ -3340,7 +3337,7 @@  discard block
 block discarded – undo
3340 3337
  */
3341 3338
 function pourcentage(float $nombre, float $total, float $pourcentage): float
3342 3339
 { 
3343
-    $resultat = ($nombre/$total) * $pourcentage;
3340
+    $resultat = ($nombre / $total) * $pourcentage;
3344 3341
     return round($resultat);
3345 3342
 }
3346 3343
 
@@ -3370,7 +3367,7 @@  discard block
 block discarded – undo
3370 3367
 
3371 3368
     // Get last folder update
3372 3369
     $lastFolderChange = DB::queryfirstrow(
3373
-        'SELECT valeur FROM ' . prefixTable('misc') . '
3370
+        'SELECT valeur FROM '.prefixTable('misc').'
3374 3371
         WHERE type = %s AND intitule = %s',
3375 3372
         'timestamp',
3376 3373
         'last_folder_change'
@@ -3400,7 +3397,7 @@  discard block
 block discarded – undo
3400 3397
     // Does this user has a tree cache
3401 3398
     $userCacheTree = DB::queryfirstrow(
3402 3399
         'SELECT '.$fieldName.'
3403
-        FROM ' . prefixTable('cache_tree') . '
3400
+        FROM ' . prefixTable('cache_tree').'
3404 3401
         WHERE user_id = %i',
3405 3402
         $session->get('user-id')
3406 3403
     );
@@ -3442,7 +3439,7 @@  discard block
 block discarded – undo
3442 3439
     if (count($folderIds) === 0) {
3443 3440
         $folderIds = DB::queryFirstColumn(
3444 3441
             'SELECT id
3445
-            FROM ' . prefixTable('nested_tree') . '
3442
+            FROM ' . prefixTable('nested_tree').'
3446 3443
             WHERE personal_folder=%i',
3447 3444
             0
3448 3445
         );
@@ -3459,8 +3456,8 @@  discard block
 block discarded – undo
3459 3456
         $rows_tmp = DB::query(
3460 3457
             'SELECT c.id, c.title, c.level, c.type, c.masked, c.order, c.encrypted_data, c.role_visibility, c.is_mandatory,
3461 3458
             f.id_category AS category_id
3462
-            FROM ' . prefixTable('categories_folders') . ' AS f
3463
-            INNER JOIN ' . prefixTable('categories') . ' AS c ON (f.id_category = c.parent_id)
3459
+            FROM ' . prefixTable('categories_folders').' AS f
3460
+            INNER JOIN ' . prefixTable('categories').' AS c ON (f.id_category = c.parent_id)
3464 3461
             WHERE id_folder=%i',
3465 3462
             $folder
3466 3463
         );
@@ -3486,7 +3483,7 @@  discard block
 block discarded – undo
3486 3483
         $valTemp = '';
3487 3484
         $data = DB::queryFirstRow(
3488 3485
             'SELECT valeur
3489
-            FROM ' . prefixTable('misc') . '
3486
+            FROM ' . prefixTable('misc').'
3490 3487
             WHERE type = %s AND intitule=%i',
3491 3488
             'complex',
3492 3489
             $folder
@@ -3503,14 +3500,14 @@  discard block
 block discarded – undo
3503 3500
         $valTemp = '';
3504 3501
         $rows_tmp = DB::query(
3505 3502
             'SELECT t.title
3506
-            FROM ' . prefixTable('roles_values') . ' as v
3507
-            INNER JOIN ' . prefixTable('roles_title') . ' as t ON (v.role_id = t.id)
3503
+            FROM ' . prefixTable('roles_values').' as v
3504
+            INNER JOIN ' . prefixTable('roles_title').' as t ON (v.role_id = t.id)
3508 3505
             WHERE v.folder_id = %i
3509 3506
             GROUP BY title',
3510 3507
             $folder
3511 3508
         );
3512 3509
         foreach ($rows_tmp as $record) {
3513
-            $valTemp .= (empty($valTemp) === true ? '' : ' - ') . $record['title'];
3510
+            $valTemp .= (empty($valTemp) === true ? '' : ' - ').$record['title'];
3514 3511
         }
3515 3512
         $arr_data['visibilityRoles'] = $valTemp;
3516 3513
 
@@ -3543,7 +3540,7 @@  discard block
 block discarded – undo
3543 3540
         // loop on users and check if user has this role
3544 3541
         $rows = DB::query(
3545 3542
             'SELECT id, fonction_id
3546
-            FROM ' . prefixTable('users') . '
3543
+            FROM ' . prefixTable('users').'
3547 3544
             WHERE id != %i AND admin = 0 AND fonction_id IS NOT NULL AND fonction_id != ""',
3548 3545
             $session->get('user-id')
3549 3546
         );
@@ -3575,7 +3572,7 @@  discard block
 block discarded – undo
3575 3572
 
3576 3573
     $val = DB::queryfirstrow(
3577 3574
         'SELECT *
3578
-        FROM ' . prefixTable('users') . '
3575
+        FROM ' . prefixTable('users').'
3579 3576
         WHERE id = %i',
3580 3577
         $userId
3581 3578
     );
@@ -3591,12 +3588,12 @@  discard block
 block discarded – undo
3591 3588
 function upgradeRequired(): bool
3592 3589
 {
3593 3590
     // Get settings.php
3594
-    include_once __DIR__. '/../includes/config/settings.php';
3591
+    include_once __DIR__.'/../includes/config/settings.php';
3595 3592
 
3596 3593
     // Get timestamp in DB
3597 3594
     $val = DB::queryfirstrow(
3598 3595
         'SELECT valeur
3599
-        FROM ' . prefixTable('misc') . '
3596
+        FROM ' . prefixTable('misc').'
3600 3597
         WHERE type = %s AND intitule = %s',
3601 3598
         'admin',
3602 3599
         'upgrade_timestamp'
@@ -3651,7 +3648,7 @@  discard block
 block discarded – undo
3651 3648
     // prepapre background tasks for item keys generation        
3652 3649
     $userTP = DB::queryFirstRow(
3653 3650
         'SELECT pw, public_key, private_key
3654
-        FROM ' . prefixTable('users') . '
3651
+        FROM ' . prefixTable('users').'
3655 3652
         WHERE id = %i',
3656 3653
         TP_USER_ID
3657 3654
     );
@@ -3685,7 +3682,7 @@  discard block
 block discarded – undo
3685 3682
     }
3686 3683
 
3687 3684
     // Generate new keys
3688
-    if ($user_self_change === true && empty($recovery_public_key) === false && empty($recovery_private_key) === false){
3685
+    if ($user_self_change === true && empty($recovery_public_key) === false && empty($recovery_private_key) === false) {
3689 3686
         $userKeys = [
3690 3687
             'public_key' => $recovery_public_key,
3691 3688
             'private_key_clear' => $recovery_private_key,
@@ -3725,8 +3722,8 @@  discard block
 block discarded – undo
3725 3722
             'process_type' => 'create_user_keys',
3726 3723
             'arguments' => json_encode([
3727 3724
                 'new_user_id' => (int) $userId,
3728
-                'new_user_pwd' => cryption($passwordClear, '','encrypt')['string'],
3729
-                'new_user_code' => cryption(empty($encryptionKey) === true ? uniqidReal(20) : $encryptionKey, '','encrypt')['string'],
3725
+                'new_user_pwd' => cryption($passwordClear, '', 'encrypt')['string'],
3726
+                'new_user_code' => cryption(empty($encryptionKey) === true ? uniqidReal(20) : $encryptionKey, '', 'encrypt')['string'],
3730 3727
                 'owner_id' => (int) TP_USER_ID,
3731 3728
                 'creator_pwd' => $userTP['pw'],
3732 3729
                 'send_email' => $sendEmailToUser === true ? 1 : 0,
@@ -4034,7 +4031,7 @@  discard block
 block discarded – undo
4034 4031
  * @param integer $user_id
4035 4032
  * @return void
4036 4033
  */
4037
-function purgeUnnecessaryKeys(bool $allUsers = true, int $user_id=0)
4034
+function purgeUnnecessaryKeys(bool $allUsers = true, int $user_id = 0)
4038 4035
 {
4039 4036
     if ($allUsers === true) {
4040 4037
         // Load class DB
@@ -4044,7 +4041,7 @@  discard block
 block discarded – undo
4044 4041
 
4045 4042
         $users = DB::query(
4046 4043
             'SELECT id
4047
-            FROM ' . prefixTable('users') . '
4044
+            FROM ' . prefixTable('users').'
4048 4045
             WHERE id NOT IN ('.OTV_USER_ID.', '.TP_USER_ID.', '.SSH_USER_ID.', '.API_USER_ID.')
4049 4046
             ORDER BY login ASC'
4050 4047
         );
@@ -4062,7 +4059,7 @@  discard block
 block discarded – undo
4062 4059
  * @param integer $user_id
4063 4060
  * @return void
4064 4061
  */
4065
-function purgeUnnecessaryKeysForUser(int $user_id=0)
4062
+function purgeUnnecessaryKeysForUser(int $user_id = 0)
4066 4063
 {
4067 4064
     if ($user_id === 0) {
4068 4065
         return;
@@ -4073,8 +4070,8 @@  discard block
 block discarded – undo
4073 4070
 
4074 4071
     $personalItems = DB::queryFirstColumn(
4075 4072
         'SELECT id
4076
-        FROM ' . prefixTable('items') . ' AS i
4077
-        INNER JOIN ' . prefixTable('log_items') . ' AS li ON li.id_item = i.id
4073
+        FROM ' . prefixTable('items').' AS i
4074
+        INNER JOIN ' . prefixTable('log_items').' AS li ON li.id_item = i.id
4078 4075
         WHERE i.perso = 1 AND li.action = "at_creation" AND li.id_user IN (%i, '.TP_USER_ID.')',
4079 4076
         $user_id
4080 4077
     );
@@ -4123,7 +4120,7 @@  discard block
 block discarded – undo
4123 4120
     // Check if user exists
4124 4121
     $userInfo = DB::queryFirstRow(
4125 4122
         'SELECT pw, public_key, private_key, login, name
4126
-        FROM ' . prefixTable('users') . '
4123
+        FROM ' . prefixTable('users').'
4127 4124
         WHERE id = %i',
4128 4125
         $userId
4129 4126
     );
@@ -4133,7 +4130,7 @@  discard block
 block discarded – undo
4133 4130
 
4134 4131
         // Prepare file content
4135 4132
         $export_value = file_get_contents(__DIR__."/../includes/core/teampass_ascii.txt")."\n".
4136
-            "Generation date: ".date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], $now)."\n\n".
4133
+            "Generation date: ".date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], $now)."\n\n".
4137 4134
             "RECOVERY KEYS - Not to be shared - To be store safely\n\n".
4138 4135
             "Public Key:\n".$userInfo['public_key']."\n\n".
4139 4136
             "Private Key:\n".decryptPrivateKey($session->get('user-password'), $userInfo['private_key'])."\n\n";
@@ -4156,7 +4153,7 @@  discard block
 block discarded – undo
4156 4153
         return prepareExchangedData(
4157 4154
             array(
4158 4155
                 'error' => false,
4159
-                'datetime' => date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], $now),
4156
+                'datetime' => date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], $now),
4160 4157
                 'timestamp' => $now,
4161 4158
                 'content' => base64_encode($export_value),
4162 4159
                 'login' => $userInfo['login'],
@@ -4182,8 +4179,8 @@  discard block
 block discarded – undo
4182 4179
  */
4183 4180
 function loadClasses(string $className = ''): void
4184 4181
 {
4185
-    require_once __DIR__. '/../includes/config/include.php';
4186
-    require_once __DIR__. '/../includes/config/settings.php';
4182
+    require_once __DIR__.'/../includes/config/include.php';
4183
+    require_once __DIR__.'/../includes/config/settings.php';
4187 4184
     require_once __DIR__.'/../vendor/autoload.php';
4188 4185
 
4189 4186
     if (defined('DB_PASSWD_CLEAR') === false) {
Please login to merge, or discard this patch.