Passed
Push — master ( b61ff7...0d33c7 )
by Nils
05:51
created
sources/folders.queries.php 1 patch
Spacing   +33 added lines, -33 removed lines patch added patch discarded remove patch
@@ -137,14 +137,14 @@  discard block
 block discarded – undo
137 137
                     && $t->personal_folder == 0
138 138
                 ) {
139 139
                     // get $t->parent_id
140
-                    $data = DB::queryFirstRow('SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', $t->parent_id);
140
+                    $data = DB::queryFirstRow('SELECT title FROM '.prefixTable('nested_tree').' WHERE id = %i', $t->parent_id);
141 141
                     if ($t->nlevel == 1) {
142 142
                         $data['title'] = $lang->get('root');
143 143
                     }
144 144
 
145 145
                     // get rights on this folder
146 146
                     $arrayRights = array();
147
-                    $rows = DB::query('SELECT fonction_id  FROM ' . prefixTable('rights') . ' WHERE authorized=%i AND tree_id = %i', 1, $t->id);
147
+                    $rows = DB::query('SELECT fonction_id  FROM '.prefixTable('rights').' WHERE authorized=%i AND tree_id = %i', 1, $t->id);
148 148
                     foreach ($rows as $record) {
149 149
                         array_push($arrayRights, $record['fonction_id']);
150 150
                     }
@@ -162,8 +162,8 @@  discard block
 block discarded – undo
162 162
                         'SELECT m.valeur AS valeur, n.renewal_period AS renewal_period,
163 163
                         n.bloquer_creation AS bloquer_creation, n.bloquer_modification AS bloquer_modification,
164 164
                         n.fa_icon AS fa_icon, n.fa_icon_selected AS fa_icon_selected
165
-                        FROM ' . prefixTable('misc') . ' AS m,
166
-                        ' . prefixTable('nested_tree') . ' AS n
165
+                        FROM ' . prefixTable('misc').' AS m,
166
+                        ' . prefixTable('nested_tree').' AS n
167 167
                         WHERE m.type=%s AND m.intitule = n.id AND m.intitule = %i',
168 168
                         'complex',
169 169
                         $t->id
@@ -191,16 +191,16 @@  discard block
 block discarded – undo
191 191
                         $arrayColumns['folderComplexity'] = '';
192 192
                     }
193 193
 
194
-                    if (is_null($node_data)=== false) {
194
+                    if (is_null($node_data) === false) {
195 195
                         $arrayColumns['renewalPeriod'] = (int) $node_data['renewal_period'];
196 196
                     } else {
197
-                        $arrayColumns['renewalPeriod']=0;
197
+                        $arrayColumns['renewalPeriod'] = 0;
198 198
                     }
199 199
 
200 200
                     //col7
201 201
                     $data7 = DB::queryFirstRow(
202 202
                         'SELECT bloquer_creation,bloquer_modification
203
-                        FROM ' . prefixTable('nested_tree') . '
203
+                        FROM ' . prefixTable('nested_tree').'
204 204
                         WHERE id = %i',
205 205
                         intval($t->id)
206 206
                     );
@@ -358,7 +358,7 @@  discard block
 block discarded – undo
358 358
             // Get info about this folder
359 359
             $dataFolder = DB::queryFirstRow(
360 360
                 'SELECT *
361
-                FROM ' . prefixTable('nested_tree') . '
361
+                FROM ' . prefixTable('nested_tree').'
362 362
                 WHERE id = %i',
363 363
                 $inputData['id']
364 364
             );
@@ -394,7 +394,7 @@  discard block
 block discarded – undo
394 394
             //check if parent folder is personal
395 395
             $dataParent = DB::queryFirstRow(
396 396
                 'SELECT personal_folder, bloquer_creation, bloquer_modification
397
-                FROM ' . prefixTable('nested_tree') . '
397
+                FROM ' . prefixTable('nested_tree').'
398 398
                 WHERE id = %i',
399 399
                 $inputData['parentId']
400 400
             );
@@ -423,7 +423,7 @@  discard block
 block discarded – undo
423 423
                     // get complexity level for this folder
424 424
                     $data = DB::queryFirstRow(
425 425
                         'SELECT valeur
426
-                        FROM ' . prefixTable('misc') . '
426
+                        FROM ' . prefixTable('misc').'
427 427
                         WHERE intitule = %i AND type = %s',
428 428
                         $inputData['parentId'],
429 429
                         'complex'
@@ -434,7 +434,7 @@  discard block
 block discarded – undo
434 434
                             array(
435 435
                                 'error' => true,
436 436
                                 'message' => $lang->get('error_folder_complexity_lower_than_top_folder')
437
-                                    . ' [<b>' . TP_PW_COMPLEXITY[$data['valeur']][1] . '</b>]',
437
+                                    . ' [<b>'.TP_PW_COMPLEXITY[$data['valeur']][1].'</b>]',
438 438
                             ),
439 439
                             'encode'
440 440
                         );
@@ -594,7 +594,7 @@  discard block
 block discarded – undo
594 594
             // Check if parent folder is personal
595 595
             $dataParent = DB::queryFirstRow(
596 596
                 'SELECT personal_folder
597
-                FROM ' . prefixTable('nested_tree') . '
597
+                FROM ' . prefixTable('nested_tree').'
598 598
                 WHERE id = %i',
599 599
                 $inputData['parentId']
600 600
             );
@@ -634,7 +634,7 @@  discard block
 block discarded – undo
634 634
             echo prepareExchangedData(
635 635
                 array(
636 636
                     'error' => $creationStatus['error'],
637
-                    'message' => $creationStatus['error'] === true ? $lang->get('error_not_allowed_to') : $lang->get('folder_created') ,
637
+                    'message' => $creationStatus['error'] === true ? $lang->get('error_not_allowed_to') : $lang->get('folder_created'),
638 638
                     'newId' => $creationStatus['newId'],
639 639
                 ),
640 640
                 'encode'
@@ -682,7 +682,7 @@  discard block
 block discarded – undo
682 682
                 echo prepareExchangedData(
683 683
                     array(
684 684
                         'error' => true,
685
-                        'message' => $lang->get('error_not_allowed_to'). " (You can't delete the root folder)",
685
+                        'message' => $lang->get('error_not_allowed_to')." (You can't delete the root folder)",
686 686
                     ),
687 687
                     'encode'
688 688
                 );
@@ -692,7 +692,7 @@  discard block
 block discarded – undo
692 692
             // Ensure that user has access to all folders
693 693
             $foldersAccessible = DB::query(
694 694
                 'SELECT id
695
-                FROM ' . prefixTable('nested_tree') . '
695
+                FROM ' . prefixTable('nested_tree').'
696 696
                 WHERE id IN %li AND id IN %li',
697 697
                 $post_folders,
698 698
                 $session->get('user-accessible_folders')
@@ -706,7 +706,7 @@  discard block
 block discarded – undo
706 706
                 echo prepareExchangedData(
707 707
                     array(
708 708
                         'error' => true,
709
-                        'message' => $lang->get('error_not_allowed_to') . ' (The following folders are not accessible or do not exist: ' . implode(', ', $missingFolders) . ')',
709
+                        'message' => $lang->get('error_not_allowed_to').' (The following folders are not accessible or do not exist: '.implode(', ', $missingFolders).')',
710 710
                     ),
711 711
                     'encode'
712 712
                 );
@@ -723,7 +723,7 @@  discard block
 block discarded – undo
723 723
                 // Check if parent folder is personal
724 724
                 $dataParent = DB::queryFirstRow(
725 725
                     'SELECT personal_folder
726
-                    FROM ' . prefixTable('nested_tree') . '
726
+                    FROM ' . prefixTable('nested_tree').'
727 727
                     WHERE id = %i',
728 728
                     $folderId
729 729
                 );
@@ -769,10 +769,10 @@  discard block
 block discarded – undo
769 769
                                 prefixTable('misc'),
770 770
                                 array(
771 771
                                     'type' => 'folder_deleted',
772
-                                    'intitule' => 'f' . $thisSubFolders->id,
773
-                                    'valeur' => $thisSubFolders->id . ', ' . $thisSubFolders->parent_id . ', ' .
774
-                                        $thisSubFolders->title . ', ' . $thisSubFolders->nleft . ', ' . $thisSubFolders->nright . ', ' .
775
-                                        $thisSubFolders->nlevel . ', 0, 0, 0, 0',
772
+                                    'intitule' => 'f'.$thisSubFolders->id,
773
+                                    'valeur' => $thisSubFolders->id.', '.$thisSubFolders->parent_id.', '.
774
+                                        $thisSubFolders->title.', '.$thisSubFolders->nleft.', '.$thisSubFolders->nright.', '.
775
+                                        $thisSubFolders->nlevel.', 0, 0, 0, 0',
776 776
                                     'created_at' => time(),
777 777
                                 )
778 778
                             );
@@ -781,7 +781,7 @@  discard block
 block discarded – undo
781 781
 
782 782
                             //delete items & logs
783 783
                             $itemsInSubFolder = DB::query(
784
-                                'SELECT id FROM ' . prefixTable('items') . ' 
784
+                                'SELECT id FROM '.prefixTable('items').' 
785 785
                                 WHERE id_tree=%i', 
786 786
                                 $thisSubFolders->id
787 787
                             );
@@ -811,7 +811,7 @@  discard block
 block discarded – undo
811 811
                                 }
812 812
 
813 813
                                 //Update CACHE table
814
-                                updateCacheTable('delete_value',(int) $item['id']);
814
+                                updateCacheTable('delete_value', (int) $item['id']);
815 815
                             }
816 816
 
817 817
                             //Actualize the variable
@@ -921,7 +921,7 @@  discard block
 block discarded – undo
921 921
             // Check if target parent folder is personal
922 922
             $dataParent = DB::queryFirstRow(
923 923
                 'SELECT personal_folder
924
-                FROM ' . prefixTable('nested_tree') . '
924
+                FROM ' . prefixTable('nested_tree').'
925 925
                 WHERE id = %i',
926 926
                 $post_target_folder_id
927 927
             );
@@ -975,7 +975,7 @@  discard block
 block discarded – undo
975 975
                 // get complexity of current node
976 976
                 $nodeComplexity = DB::queryFirstRow(
977 977
                     'SELECT valeur
978
-                    FROM ' . prefixTable('misc') . '
978
+                    FROM ' . prefixTable('misc').'
979 979
                     WHERE intitule = %i AND type= %s',
980 980
                     $nodeInfo->id,
981 981
                     'complex'
@@ -1052,7 +1052,7 @@  discard block
 block discarded – undo
1052 1052
                 // If it is a subfolder, then give access to it for all roles that allows the parent folder
1053 1053
                 $rows = DB::query(
1054 1054
                     'SELECT role_id, type
1055
-                    FROM ' . prefixTable('roles_values') . '
1055
+                    FROM ' . prefixTable('roles_values').'
1056 1056
                     WHERE folder_id = %i',
1057 1057
                     $parentId
1058 1058
                 );
@@ -1071,7 +1071,7 @@  discard block
 block discarded – undo
1071 1071
                 // if parent folder has Custom Fields Categories then add to this child one too
1072 1072
                 $rows = DB::query(
1073 1073
                     'SELECT id_category
1074
-                    FROM ' . prefixTable('categories_folders') . '
1074
+                    FROM ' . prefixTable('categories_folders').'
1075 1075
                     WHERE id_folder = %i',
1076 1076
                     $nodeInfo->id
1077 1077
                 );
@@ -1090,7 +1090,7 @@  discard block
 block discarded – undo
1090 1090
 
1091 1091
                 $rows = DB::query(
1092 1092
                     'SELECT *
1093
-                    FROM ' . prefixTable('items') . '
1093
+                    FROM ' . prefixTable('items').'
1094 1094
                     WHERE id_tree = %i',
1095 1095
                     $nodeInfo->id
1096 1096
                 );
@@ -1099,7 +1099,7 @@  discard block
 block discarded – undo
1099 1099
                     // if it is then don't copy it
1100 1100
                     $item_deleted = DB::queryFirstRow(
1101 1101
                         'SELECT *
1102
-                        FROM ' . prefixTable('log_items') . '
1102
+                        FROM ' . prefixTable('log_items').'
1103 1103
                         WHERE id_item = %i AND action = %s
1104 1104
                         ORDER BY date DESC
1105 1105
                         LIMIT 0, 1',
@@ -1110,7 +1110,7 @@  discard block
 block discarded – undo
1110 1110
 
1111 1111
                     $item_restored = DB::queryFirstRow(
1112 1112
                         'SELECT *
1113
-                        FROM ' . prefixTable('log_items') . '
1113
+                        FROM ' . prefixTable('log_items').'
1114 1114
                         WHERE id_item = %i AND action = %s
1115 1115
                         ORDER BY date DESC
1116 1116
                         LIMIT 0, 1',
@@ -1125,7 +1125,7 @@  discard block
 block discarded – undo
1125 1125
                         // Get the ITEM object key for the user
1126 1126
                         $userKey = DB::queryFirstRow(
1127 1127
                             'SELECT share_key
1128
-                            FROM ' . prefixTable('sharekeys_items') . '
1128
+                            FROM ' . prefixTable('sharekeys_items').'
1129 1129
                             WHERE user_id = %i AND object_id = %i',
1130 1130
                             $session->get('user-id'),
1131 1131
                             $record['id']
@@ -1287,7 +1287,7 @@  discard block
 block discarded – undo
1287 1287
                     // Get path
1288 1288
                     $text = '';
1289 1289
                     foreach ($tree->getPath($folder->id, false) as $fld) {
1290
-                        $text .= empty($text) === true ? '     [<i>' . $fld->title : ' > ' . $fld->title;
1290
+                        $text .= empty($text) === true ? '     [<i>'.$fld->title : ' > '.$fld->title;
1291 1291
                     }
1292 1292
 
1293 1293
                     // Save array
@@ -1297,7 +1297,7 @@  discard block
 block discarded – undo
1297 1297
                             'id' => (int) $folder->id,
1298 1298
                             'label' => $folder->title,
1299 1299
                             'level' => $folder->nlevel,
1300
-                            'path' => empty($text) === true ? '' : $text . '</i>]'
1300
+                            'path' => empty($text) === true ? '' : $text.'</i>]'
1301 1301
                         )
1302 1302
                     );
1303 1303
                 }
Please login to merge, or discard this patch.
pages/users.js.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('users') === false) {
73 73
     // Not allowed page
74 74
     $session->set('system-error_code', ERR_NOT_ALLOWED);
75
-    include $SETTINGS['cpassman_dir'] . '/error.php';
75
+    include $SETTINGS['cpassman_dir'].'/error.php';
76 76
     exit;
77 77
 }
78 78
 ?>
@@ -325,8 +325,8 @@  discard block
 block discarded – undo
325 325
         if (store.get('teampassApplication').formUserAction === "add_new_user") {
326 326
             var data = {
327 327
                 'receipt': $('#form-email').val(),
328
-                'subject': 'TEAMPASS - <?php echo $lang->get('temporary_encryption_code');?>',
329
-                'body': '<?php echo $lang->get('email_body_new_user');?>',
328
+                'subject': 'TEAMPASS - <?php echo $lang->get('temporary_encryption_code'); ?>',
329
+                'body': '<?php echo $lang->get('email_body_new_user'); ?>',
330 330
                 'pre_replace' : {
331 331
                     '#code#' : store.get('teampassUser').admin_new_user_temporary_encryption_code,
332 332
                     '#login#' : store.get('teampassUser').admin_new_user_login,
@@ -336,8 +336,8 @@  discard block
 block discarded – undo
336 336
         } else {
337 337
             var data = {
338 338
                 'receipt': $('#form-email').val(),
339
-                'subject': 'TEAMPASS - <?php echo $lang->get('temporary_encryption_code');?>',
340
-                'body': '<?php echo $lang->get('email_body_temporary_encryption_code');?>',
339
+                'subject': 'TEAMPASS - <?php echo $lang->get('temporary_encryption_code'); ?>',
340
+                'body': '<?php echo $lang->get('email_body_temporary_encryption_code'); ?>',
341 341
                 'pre_replace' : {
342 342
                     '#enc_code#' : store.get('teampassUser').admin_new_user_temporary_encryption_code,
343 343
                 }
@@ -532,14 +532,14 @@  discard block
 block discarded – undo
532 532
             }
533 533
             // Inform user
534 534
             $("#warningModalBody").html('<b><?php echo $lang->get('encryption_keys'); ?> - ' +
535
-                stepText + '</b> [' + start + ' - ' + (parseInt(start) + <?php echo NUMBER_ITEMS_IN_BATCH;?>) + ']<span id="warningModalBody_extra">' + $nbItemsToConvert + '</span> ' +
535
+                stepText + '</b> [' + start + ' - ' + (parseInt(start) + <?php echo NUMBER_ITEMS_IN_BATCH; ?>) + ']<span id="warningModalBody_extra">' + $nbItemsToConvert + '</span> ' +
536 536
                 '... <?php echo $lang->get('please_wait'); ?><i class="fa-solid fa-spinner fa-pulse ml-3 text-primary"></i>');
537 537
 
538 538
             // If expected, show the OPT to the admin
539 539
             if (constVisibleOTP === true) {
540 540
                 toastr.info(
541
-                    '<?php echo $lang->get('show_encryption_code_to_admin');?> <div><input class="form-control form-item-control flex-nowrap" value="' + userTemporaryCode + '" readonly></div>'
542
-                    + '<br /><button type="button" class="btn clear"><?php echo $lang->get('close');?></button>',
541
+                    '<?php echo $lang->get('show_encryption_code_to_admin'); ?> <div><input class="form-control form-item-control flex-nowrap" value="' + userTemporaryCode + '" readonly></div>'
542
+                    + '<br /><button type="button" class="btn clear"><?php echo $lang->get('close'); ?></button>',
543 543
                     '<?php echo $lang->get('information'); ?>',
544 544
                     {
545 545
                         extendedTimeOut: 0,
@@ -558,7 +558,7 @@  discard block
 block discarded – undo
558 558
             var data = {
559 559
                 action: step,
560 560
                 start: start,
561
-                length: <?php echo NUMBER_ITEMS_IN_BATCH;?>,
561
+                length: <?php echo NUMBER_ITEMS_IN_BATCH; ?>,
562 562
                 user_id: userId,
563 563
             }
564 564
             if (debugJavascript === true) {
@@ -1395,7 +1395,7 @@  discard block
 block discarded – undo
1395 1395
                         } else {
1396 1396
                             // Show icon or not
1397 1397
                             if ($('#user-disabled').prop('checked') === true) {
1398
-                                $('#user-login-'+userID).before('<i class="fa-solid fa-user-slash infotip text-danger mr-2" title="<?php echo $lang->get('account_is_locked');?>" id="user-disable-'+userID+'"></i>');
1398
+                                $('#user-login-'+userID).before('<i class="fa-solid fa-user-slash infotip text-danger mr-2" title="<?php echo $lang->get('account_is_locked'); ?>" id="user-disable-'+userID+'"></i>');
1399 1399
                             } else {
1400 1400
                                 $('#user-disable-'+userID).remove();
1401 1401
                             }
Please login to merge, or discard this patch.
pages/users.php 1 patch
Spacing   +11 added lines, -11 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('users') === 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
 
@@ -92,24 +92,24 @@  discard block
 block discarded – undo
92 92
 // If administrator then all roles are shown
93 93
 // else only the Roles the users is associated to.
94 94
 if ((int) $session->get('user-admin') === 1) {
95
-    $optionsManagedBy .= '<option value="0">' . $lang->get('administrators_only') . '</option>';
95
+    $optionsManagedBy .= '<option value="0">'.$lang->get('administrators_only').'</option>';
96 96
 }
97 97
 
98 98
 $rows = DB::query(
99 99
     'SELECT id, title, creator_id
100
-    FROM ' . prefixTable('roles_title') . '
100
+    FROM ' . prefixTable('roles_title').'
101 101
     ORDER BY title ASC'
102 102
 );
103 103
 foreach ($rows as $record) {
104 104
     if ((int) $session->get('user-admin') === 1 || in_array($record['id'], $session->get('user-roles_array')) === true) {
105
-        $optionsManagedBy .= '<option value="' . $record['id'] . '">' . $lang->get('managers_of') . ' ' . addslashes($record['title']) . '</option>';
105
+        $optionsManagedBy .= '<option value="'.$record['id'].'">'.$lang->get('managers_of').' '.addslashes($record['title']).'</option>';
106 106
     }
107 107
     if (
108 108
         (int) $session->get('user-admin') === 1
109 109
         || (((int) $session->get('user-manager') === 1 || (int) $session->get('user-can_manage_all_users') === 1)
110 110
             && (in_array($record['id'], $userRoles) === true) || (int) $record['creator_id'] === (int) $session->get('user-id'))
111 111
     ) {
112
-        $optionsRoles .= '<option value="' . $record['id'] . '">' . addslashes($record['title']) . '</option>';
112
+        $optionsRoles .= '<option value="'.$record['id'].'">'.addslashes($record['title']).'</option>';
113 113
     }
114 114
 }
115 115
 
@@ -124,7 +124,7 @@  discard block
 block discarded – undo
124 124
         for ($y = 1; $y < $t->nlevel; ++$y) {
125 125
             $ident .= '&nbsp;&nbsp;';
126 126
         }
127
-        $foldersList .= '<option value="' . $t->id . '">' . $ident . htmlspecialchars($t->title, ENT_COMPAT, 'UTF-8') . '</option>';
127
+        $foldersList .= '<option value="'.$t->id.'">'.$ident.htmlspecialchars($t->title, ENT_COMPAT, 'UTF-8').'</option>';
128 128
     }
129 129
 }
130 130
 
@@ -161,13 +161,13 @@  discard block
 block discarded – undo
161 161
                         </button><?php
162 162
                                     echo isset($SETTINGS['ldap_mode']) === true && (int) $SETTINGS['ldap_mode'] === 1 && (int) $session->get('user-admin') === 1 ?
163 163
                                         '<button type="button" class="btn btn-primary btn-sm tp-action mr-2" data-action="ldap-sync">
164
-                            <i class="fa-solid fa-address-card mr-2"></i>' . $lang->get('ldap_synchronization') . '
164
+                            <i class="fa-solid fa-address-card mr-2"></i>' . $lang->get('ldap_synchronization').'
165 165
                         </button>' : '';
166 166
                                     ?>
167 167
                         </button><?php
168 168
                                     echo isset($SETTINGS['oauth2_enabled']) === true && (int) $SETTINGS['oauth2_enabled'] === 1 && (int) $session->get('user-admin') === 1 ?
169 169
                                         '<button type="button" class="btn btn-primary btn-sm tp-action mr-2" data-action="oauth2-sync">
170
-                            <i class="fa-solid fa-plug mr-2"></i>' . $lang->get('oauth2_synchronization') . '
170
+                            <i class="fa-solid fa-plug mr-2"></i>' . $lang->get('oauth2_synchronization').'
171 171
                         </button>' : '';
172 172
                                     ?>
173 173
                     </h3>
@@ -175,7 +175,7 @@  discard block
 block discarded – undo
175 175
 
176 176
                 <!-- /.card-header -->
177 177
                 <div class="card-body form" id="users-list">
178
-                    <label><input type="checkbox" id="warnings_display" class="tp-action pointer" data-action="refresh"><span class="ml-2 pointer"><?php echo $lang->get('display_warning_icons');?></span></label>
178
+                    <label><input type="checkbox" id="warnings_display" class="tp-action pointer" data-action="refresh"><span class="ml-2 pointer"><?php echo $lang->get('display_warning_icons'); ?></span></label>
179 179
                     <table id="table-users" class="table table-striped nowrap table-responsive-sm">
180 180
                         <thead>
181 181
                             <tr>
@@ -239,7 +239,7 @@  discard block
 block discarded – undo
239 239
                                             <?php
240 240
                                             foreach (TP_PW_COMPLEXITY as $entry) {
241 241
                                                 echo '
242
-                                            <option value="' . $entry[0] . '">' . addslashes($entry[1]) . '</option>';
242
+                                            <option value="' . $entry[0].'">'.addslashes($entry[1]).'</option>';
243 243
                                             }
244 244
                                             ?>
245 245
                                         </select>
@@ -316,7 +316,7 @@  discard block
 block discarded – undo
316 316
                                             <?php
317 317
                                             foreach (TP_PW_COMPLEXITY as $entry) {
318 318
                                                 echo '
319
-                                            <option value="' . $entry[0] . '">' . addslashes($entry[1]) . '</option>';
319
+                                            <option value="' . $entry[0].'">'.addslashes($entry[1]).'</option>';
320 320
                                             }
321 321
                                             ?>
322 322
                                         </select>
Please login to merge, or discard this patch.
sources/users.datatable.php 1 patch
Spacing   +15 added lines, -17 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
 
@@ -128,7 +128,7 @@  discard block
 block discarded – undo
128 128
     if (isset($order['column']) && preg_match('#^(asc|desc)$#i', $order['dir'])) {
129 129
         $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT);
130 130
         $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS);
131
-        $sOrder .= $aColumns[$columnIndex] . ' ' . $dir . ', ';
131
+        $sOrder .= $aColumns[$columnIndex].' '.$dir.', ';
132 132
     }
133 133
 
134 134
     $sOrder = substr_replace($sOrder, '', -2);
@@ -152,15 +152,15 @@  discard block
 block discarded – undo
152 152
 
153 153
 if ($letter !== '' && $letter !== 'None') {
154 154
     $sWhere .= ' AND (';
155
-    $sWhere .= $aColumns[1] . " LIKE '" . $letter . "%' OR ";
156
-    $sWhere .= $aColumns[2] . " LIKE '" . $letter . "%' OR ";
157
-    $sWhere .= $aColumns[3] . " LIKE '" . $letter . "%' ";
155
+    $sWhere .= $aColumns[1]." LIKE '".$letter."%' OR ";
156
+    $sWhere .= $aColumns[2]." LIKE '".$letter."%' OR ";
157
+    $sWhere .= $aColumns[3]." LIKE '".$letter."%' ";
158 158
     $sWhere .= ')';
159 159
 } elseif ($searchValue !== '') {
160 160
     $sWhere .= ' AND (';
161
-    $sWhere .= $aColumns[1] . " LIKE '" . $searchValue . "%' OR ";
162
-    $sWhere .= $aColumns[2] . " LIKE '" . $searchValue . "%' OR ";
163
-    $sWhere .= $aColumns[3] . " LIKE '" . $searchValue . "%' ";
161
+    $sWhere .= $aColumns[1]." LIKE '".$searchValue."%' OR ";
162
+    $sWhere .= $aColumns[2]." LIKE '".$searchValue."%' OR ";
163
+    $sWhere .= $aColumns[3]." LIKE '".$searchValue."%' ";
164 164
     $sWhere .= ')';
165 165
 }
166 166
 
@@ -246,7 +246,7 @@  discard block
 block discarded – undo
246 246
         // Check for existing lock
247 247
         $unlock_at = DB::queryFirstField(
248 248
             'SELECT MAX(unlock_at)
249
-             FROM ' . prefixTable('auth_failures') . '
249
+             FROM ' . prefixTable('auth_failures').'
250 250
              WHERE unlock_at > %s AND source = %s AND value = %s',
251 251
             date('Y-m-d H:i:s', time()),
252 252
             'login',
@@ -255,33 +255,31 @@  discard block
 block discarded – undo
255 255
 
256 256
         // Get some infos about user
257 257
         $userDisplayInfos = 
258
-            (isset($userDate['date']) ? '<i class=\"fas fa-calendar-day infotip text-info ml-2\" title=\"'.$lang->get('creation_date').': '.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $userDate['date']).'\"></i>' : '')
258
+            (isset($userDate['date']) ? '<i class=\"fas fa-calendar-day infotip text-info ml-2\" title=\"'.$lang->get('creation_date').': '.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $userDate['date']).'\"></i>' : '')
259 259
             .
260 260
             ((int) $record['last_connexion'] > 0 ? '<i class=\"far fa-clock infotip text-info ml-2\" title=\"'.$lang->get('index_last_seen').": ".
261
-            date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['last_connexion']).'\"></i>' : '')
261
+            date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['last_connexion']).'\"></i>' : '')
262 262
             .
263 263
             ((int) $record['user_ip'] > 0 ? '<i class=\"fas fa-street-view infotip text-info ml-1\" title=\"'.$lang->get('ip').": ".($record['user_ip']).'\"></i>' : '')
264 264
             .
265 265
             (($record['auth_type'] === 'ldap' || $record['auth_type'] === 'oauth2') ? '<i class=\"far fa-address-book infotip text-warning ml-1\" title=\"'.$lang->get('managed_through_ad').'\"></i>' : '')
266 266
             .
267 267
             ((in_array($record['id'], [OTV_USER_ID, TP_USER_ID, SSH_USER_ID, API_USER_ID]) === false && (int) $record['admin'] !== 1 && ((int) $SETTINGS['duo'] === 1 || (int) $SETTINGS['google_authentication'] === 1)) ?
268
-                ((int) $record['mfa_enabled'] === 1 ? '' : '<i class=\"fa-solid fa-fingerprint infotip ml-1\" style=\"color:Tomato\" title=\"'.$lang->get('mfa_disabled_for_user').'\"></i>') :
269
-                ''
268
+                ((int) $record['mfa_enabled'] === 1 ? '' : '<i class=\"fa-solid fa-fingerprint infotip ml-1\" style=\"color:Tomato\" title=\"'.$lang->get('mfa_disabled_for_user').'\"></i>') : ''
270 269
                 )
271 270
             .
272 271
             (($unlock_at) ? '<i class=\"fas fa-solid text-red fa-lock infotip text-info ml-1\" title=\"'.$lang->get('bruteforce_unlock_at').$unlock_at.'\"></i>' : '');
273 272
         if ($request->query->filter('display_warnings', '', FILTER_VALIDATE_BOOLEAN) === true) {
274 273
             $userDisplayInfos .= '<br>'.
275 274
                 ((in_array($record['id'], [OTV_USER_ID, TP_USER_ID, SSH_USER_ID, API_USER_ID]) === false && (int) $record['admin'] !== 1 && is_null($record['keys_recovery_time']) === true) ? 
276
-                    '<i class=\"fa-solid fa-download infotip ml-1\" style=\"color:Tomato\" title=\"'.$lang->get('recovery_keys_not_downloaded').'\"></i>' :
277
-                    ''
275
+                    '<i class=\"fa-solid fa-download infotip ml-1\" style=\"color:Tomato\" title=\"'.$lang->get('recovery_keys_not_downloaded').'\"></i>' : ''
278 276
                 ).
279 277
                 ((in_array($record['id'], [OTV_USER_ID, TP_USER_ID, SSH_USER_ID, API_USER_ID]) === false && (int) $record['pw_passwordlib'] === 1) ? '<i class=\"fa-solid fa-person-walking-luggage infotip ml-1\" style=\"color:Tomato\" title=\"Old password encryption. Shall login to initialize.\"></i>' : '');
280 278
         }
281 279
 
282 280
         $sOutput .= '["<span data-id=\"'.$record['id'].'\" data-fullname=\"'.
283
-            (empty($record['name']) === false ? htmlentities($record['name'], ENT_QUOTES|ENT_SUBSTITUTE|ENT_DISALLOWED) : '').' '.
284
-            (empty($record['lastname']) === false ? htmlentities($record['lastname'], ENT_QUOTES|ENT_SUBSTITUTE|ENT_DISALLOWED) : '').
281
+            (empty($record['name']) === false ? htmlentities($record['name'], ENT_QUOTES | ENT_SUBSTITUTE | ENT_DISALLOWED) : '').' '.
282
+            (empty($record['lastname']) === false ? htmlentities($record['lastname'], ENT_QUOTES | ENT_SUBSTITUTE | ENT_DISALLOWED) : '').
285 283
             '\" data-auth-type=\"'.$record['auth_type'].'\" data-special=\"'.$record['special'].'\" data-mfa-enabled=\"'.$record['mfa_enabled'].'\" data-otp-provided=\"'.(isset($record['otp_provided']) === true ? $record['otp_provided'] : '').'\"></span>", ';
286 284
         //col2
287 285
         $sOutput .= '"'.
Please login to merge, or discard this patch.
index.php 2 patches
Spacing   +181 added lines, -181 removed lines patch added patch discarded remove patch
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 csrfProtector::init();
73 73
 
74 74
 // Load functions
75
-require_once __DIR__. '/includes/config/include.php';
75
+require_once __DIR__.'/includes/config/include.php';
76 76
 require_once __DIR__.'/sources/main.functions.php';
77 77
 
78 78
 // init
@@ -106,7 +106,7 @@  discard block
 block discarded – undo
106 106
 $SETTINGS = $antiXss->xss_clean($SETTINGS);
107 107
 
108 108
 // Load Core library
109
-require_once $SETTINGS['cpassman_dir'] . '/sources/core.php';
109
+require_once $SETTINGS['cpassman_dir'].'/sources/core.php';
110 110
 // Prepare POST variables
111 111
 $post_language = filter_input(INPUT_POST, 'language', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
112 112
 $session_user_language = $session->get('user-language');
@@ -160,7 +160,7 @@  discard block
 block discarded – undo
160 160
 if ($hasSuperPrivilege > 0) {
161 161
     if (defined('MYSQL_LOG') && MYSQL_LOG === true) {
162 162
         DB::query("SET GLOBAL general_log = 'ON'");
163
-        DB::query("SET GLOBAL general_log_file = " . (defined('MYSQL_LOG_FILE') ? MYSQL_LOG_FILE : "'/var/log/teampass_mysql_query.log'"));
163
+        DB::query("SET GLOBAL general_log_file = ".(defined('MYSQL_LOG_FILE') ? MYSQL_LOG_FILE : "'/var/log/teampass_mysql_query.log'"));
164 164
     } else {
165 165
         DB::query("SET GLOBAL general_log = 'OFF'");
166 166
     }
@@ -171,8 +171,8 @@  discard block
 block discarded – undo
171 171
     //get default language
172 172
     $dataLanguage = DB::queryFirstRow(
173 173
         'SELECT m.valeur AS valeur, l.flag AS flag
174
-        FROM ' . prefixTable('misc') . ' AS m
175
-        INNER JOIN ' . prefixTable('languages') . ' AS l ON (m.valeur = l.name)
174
+        FROM ' . prefixTable('misc').' AS m
175
+        INNER JOIN ' . prefixTable('languages').' AS l ON (m.valeur = l.name)
176 176
         WHERE m.type=%s_type AND m.intitule=%s_intitule',
177 177
         [
178 178
             'type' => 'admin',
@@ -203,7 +203,7 @@  discard block
 block discarded – undo
203 203
         $session_user_language = $SETTINGS['default_language'];
204 204
     }
205 205
 }
206
-$lang = new Language($session_user_language, __DIR__. '/includes/language/'); 
206
+$lang = new Language($session_user_language, __DIR__.'/includes/language/'); 
207 207
 
208 208
 if (isset($SETTINGS['cpassman_dir']) === false || $SETTINGS['cpassman_dir'] === '') {
209 209
     $SETTINGS['cpassman_dir'] = __DIR__;
@@ -277,29 +277,29 @@  discard block
 block discarded – undo
277 277
     </script>
278 278
 
279 279
     <!-- IonIcons -->
280
-    <link rel="stylesheet" href="includes/css/ionicons.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
280
+    <link rel="stylesheet" href="includes/css/ionicons.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
281 281
     <!-- Theme style -->
282
-    <link rel="stylesheet" href="plugins/adminlte/css/adminlte.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
283
-    <link rel="stylesheet" href="plugins/pace-progress/themes/corner-indicator.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" type="text/css" />
284
-    <link rel="stylesheet" href="plugins/select2/css/select2.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" type="text/css" />
285
-    <link rel="stylesheet" href="plugins/select2/theme/select2-bootstrap4.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" type="text/css" />
282
+    <link rel="stylesheet" href="plugins/adminlte/css/adminlte.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
283
+    <link rel="stylesheet" href="plugins/pace-progress/themes/corner-indicator.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" type="text/css" />
284
+    <link rel="stylesheet" href="plugins/select2/css/select2.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" type="text/css" />
285
+    <link rel="stylesheet" href="plugins/select2/theme/select2-bootstrap4.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" type="text/css" />
286 286
     <!-- Theme style -->
287
-    <link rel="stylesheet" href="includes/css/teampass.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
287
+    <link rel="stylesheet" href="includes/css/teampass.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
288 288
     <!-- Google Font: Source Sans Pro -->
289
-    <link rel="stylesheet" type="text/css" href="includes/fonts/fonts.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
289
+    <link rel="stylesheet" type="text/css" href="includes/fonts/fonts.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
290 290
     <!-- Altertify -->
291
-    <link rel="stylesheet" href="plugins/alertifyjs/css/alertify.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" />
292
-    <link rel="stylesheet" href="plugins/alertifyjs/css/themes/bootstrap.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" />
291
+    <link rel="stylesheet" href="plugins/alertifyjs/css/alertify.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" />
292
+    <link rel="stylesheet" href="plugins/alertifyjs/css/themes/bootstrap.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" />
293 293
     <!-- Toastr -->
294
-    <link rel="stylesheet" href="plugins/toastr/toastr.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" />
294
+    <link rel="stylesheet" href="plugins/toastr/toastr.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" />
295 295
     <!-- favicon -->
296
-    <link rel="shortcut icon" type="image/png" href="<?php echo $favicon;?>"/>
296
+    <link rel="shortcut icon" type="image/png" href="<?php echo $favicon; ?>"/>
297 297
     <!-- manifest (PWA) -->
298
-    <link rel="manifest" href="manifest.json?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
298
+    <link rel="manifest" href="manifest.json?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
299 299
     <!-- Custom style -->
300 300
     <?php
301
-    if (file_exists(__DIR__ . '/includes/css/custom.css') === true) {?>
302
-        <link rel="stylesheet" href="includes/css/custom.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
301
+    if (file_exists(__DIR__.'/includes/css/custom.css') === true) {?>
302
+        <link rel="stylesheet" href="includes/css/custom.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
303 303
     <?php
304 304
     } ?>
305 305
 </head>
@@ -346,7 +346,7 @@  discard block
 block discarded – undo
346 346
                         <div class="dropdown show">
347 347
                             <a class="btn btn-primary dropdown-toggle" href="#" data-toggle="dropdown">
348 348
                                 <?php
349
-                                    echo $session_name . '&nbsp;' . $session_lastname; ?>
349
+                                    echo $session_name.'&nbsp;'.$session_lastname; ?>
350 350
                             </a>
351 351
 
352 352
                             <div class="dropdown-menu dropdown-menu-right">
@@ -370,7 +370,7 @@  discard block
 block discarded – undo
370 370
                                     </a>
371 371
                                 <?php
372 372
                                     } ?>
373
-                                <a class="dropdown-item user-menu<?php echo (int) $session_user_admin === 1 ? ' hidden' : '';?>" href="#" data-name="generate-new_keys">
373
+                                <a class="dropdown-item user-menu<?php echo (int) $session_user_admin === 1 ? ' hidden' : ''; ?>" href="#" data-name="generate-new_keys">
374 374
                                     <i class="fa-solid fa-spray-can-sparkles fa-fw mr-2"></i><?php echo $lang->get('generate_new_keys'); ?>
375 375
                                 </a>
376 376
 
@@ -404,7 +404,7 @@  discard block
 block discarded – undo
404 404
             <!-- Main Sidebar Container -->
405 405
             <aside class="main-sidebar sidebar-dark-primary elevation-4">
406 406
                 <!-- Brand Logo -->
407
-                <a href="<?php echo $cpassman_url . '/index.php?page=' . ((int) $session_user_admin === 1 ? 'admin' : 'items'); ?>" class="brand-link">
407
+                <a href="<?php echo $cpassman_url.'/index.php?page='.((int) $session_user_admin === 1 ? 'admin' : 'items'); ?>" class="brand-link">
408 408
                     <img src="includes/images/teampass-logo2-home.png" alt="Teampass Logo" class="brand-image">
409 409
                     <span class="brand-text font-weight-light"><?php echo TP_TOOL_NAME; ?></span>
410 410
                 </a>
@@ -422,7 +422,7 @@  discard block
 block discarded – undo
422 422
                         <a href="#" data-name="items" class="nav-link', $get['page'] === 'items' ? ' active' : '', '">
423 423
                         <i class="nav-icon fa-solid fa-key"></i>
424 424
                         <p>
425
-                            ' . $lang->get('pw') . '
425
+                            ' . $lang->get('pw').'
426 426
                         </p>
427 427
                         </a>
428 428
                     </li>';
@@ -435,7 +435,7 @@  discard block
 block discarded – undo
435 435
                         <a href="#" data-name="import" class="nav-link', $get['page'] === 'import' ? ' active' : '', '">
436 436
                         <i class="nav-icon fa-solid fa-file-import"></i>
437 437
                         <p>
438
-                            ' . $lang->get('import') . '
438
+                            ' . $lang->get('import').'
439 439
                         </p>
440 440
                         </a>
441 441
                     </li>';
@@ -456,7 +456,7 @@  discard block
 block discarded – undo
456 456
                         <a href="#" data-name="export" class="nav-link', $get['page'] === 'export' ? ' active' : '', '">
457 457
                         <i class="nav-icon fa-solid fa-file-export"></i>
458 458
                         <p>
459
-                            ' . $lang->get('export') . '
459
+                            ' . $lang->get('export').'
460 460
                         </p>
461 461
                         </a>
462 462
                     </li>';
@@ -483,7 +483,7 @@  discard block
 block discarded – undo
483 483
                         <a href="#" data-name="search" class="nav-link', $get['page'] === 'search' ? ' active' : '', '">
484 484
                         <i class="nav-icon fa-solid fa-search"></i>
485 485
                         <p>
486
-                            ' . $lang->get('find') . '
486
+                            ' . $lang->get('find').'
487 487
                         </p>
488 488
                         </a>
489 489
                     </li>';
@@ -499,7 +499,7 @@  discard block
 block discarded – undo
499 499
                         <a href="#" data-name="favourites" class="nav-link', $get['page'] === 'favourites' ? ' active' : '', '">
500 500
                         <i class="nav-icon fa-solid fa-star"></i>
501 501
                         <p>
502
-                            ' . $lang->get('favorites') . '
502
+                            ' . $lang->get('favorites').'
503 503
                         </p>
504 504
                         </a>
505 505
                     </li>';
@@ -529,7 +529,7 @@  discard block
 block discarded – undo
529 529
                         <a href="#" data-name="suggestion" class="nav-link', $get['page'] === 'suggestion' ? ' active' : '', '">
530 530
                         <i class="nav-icon fa-solid fa-lightbulb"></i>
531 531
                         <p>
532
-                            ' . $lang->get('suggestion_menu') . '
532
+                            ' . $lang->get('suggestion_menu').'
533 533
                         </p>
534 534
                         </a>
535 535
                     </li>';
@@ -542,7 +542,7 @@  discard block
 block discarded – undo
542 542
                         <a href="#" data-name="admin" class="nav-link', $get['page'] === 'admin' ? ' active' : '', '">
543 543
                         <i class="nav-icon fa-solid fa-info"></i>
544 544
                         <p>
545
-                            ' . $lang->get('admin_main') . '
545
+                            ' . $lang->get('admin_main').'
546 546
                         </p>
547 547
                         </a>
548 548
                     </li>
@@ -550,7 +550,7 @@  discard block
 block discarded – undo
550 550
                         <a href="#" class="nav-link">
551 551
                             <i class="nav-icon fa-solid fa-wrench"></i>
552 552
                             <p>
553
-                                ' . $lang->get('admin_settings') . '
553
+                                ' . $lang->get('admin_settings').'
554 554
                                 <i class="fa-solid fa-angle-left right"></i>
555 555
                             </p>
556 556
                         </a>
@@ -558,63 +558,63 @@  discard block
 block discarded – undo
558 558
                             <li class="nav-item">
559 559
                                 <a href="#" data-name="options" class="nav-link', $get['page'] === 'options' ? ' active' : '', '">
560 560
                                     <i class="fa-solid fa-check-double nav-icon"></i>
561
-                                    <p>' . $lang->get('options') . '</p>
561
+                                    <p>' . $lang->get('options').'</p>
562 562
                                 </a>
563 563
                             </li>
564 564
                             <li class="nav-item">
565 565
                                 <a href="#" data-name="2fa" class="nav-link', $get['page'] === '2fa' ? ' active' : '', '">
566 566
                                     <i class="fa-solid fa-qrcode nav-icon"></i>
567
-                                    <p>' . $lang->get('mfa_short') . '</p>
567
+                                    <p>' . $lang->get('mfa_short').'</p>
568 568
                                 </a>
569 569
                             </li>
570 570
                             <li class="nav-item">
571 571
                                 <a href="#" data-name="api" class="nav-link', $get['page'] === 'api' ? ' active' : '', '">
572 572
                                     <i class="fa-solid fa-cubes nav-icon"></i>
573
-                                    <p>' . $lang->get('api') . '</p>
573
+                                    <p>' . $lang->get('api').'</p>
574 574
                                 </a>
575 575
                             </li>
576 576
                             <li class="nav-item">
577 577
                                 <a href="#" data-name="backups" class="nav-link', $get['page'] === 'backups' ? ' active' : '', '">
578 578
                                     <i class="fa-solid fa-database nav-icon"></i>
579
-                                    <p>' . $lang->get('backups') . '</p>
579
+                                    <p>' . $lang->get('backups').'</p>
580 580
                                 </a>
581 581
                             </li>
582 582
                             <li class="nav-item">
583 583
                                 <a href="#" data-name="emails" class="nav-link', $get['page'] === 'emails' ? ' active' : '', '">
584 584
                                     <i class="fa-solid fa-envelope nav-icon"></i>
585
-                                    <p>' . $lang->get('emails') . '</p>
585
+                                    <p>' . $lang->get('emails').'</p>
586 586
                                 </a>
587 587
                             </li>
588 588
                             <li class="nav-item">
589 589
                                 <a href="#" data-name="fields" class="nav-link', $get['page'] === 'fields' ? ' active' : '', '">
590 590
                                     <i class="fa-solid fa-keyboard nav-icon"></i>
591
-                                    <p>' . $lang->get('fields') . '</p>
591
+                                    <p>' . $lang->get('fields').'</p>
592 592
                                 </a>
593 593
                             </li>
594 594
                             <li class="nav-item">
595 595
                                 <a href="#" data-name="ldap" class="nav-link', $get['page'] === 'ldap' ? ' active' : '', '">
596 596
                                     <i class="fa-solid fa-id-card nav-icon"></i>
597
-                                    <p>' . $lang->get('ldap') . '</p>
597
+                                    <p>' . $lang->get('ldap').'</p>
598 598
                                 </a>
599 599
                             </li>
600 600
 
601 601
                             <li class="nav-item">
602 602
                                 <a href="#" data-name="oauth" class="nav-link', $get['page'] === 'oauth' ? ' active' : '', '">
603 603
                                     <i class="fa-solid fa-plug nav-icon"></i>
604
-                                    <p>' . $lang->get('oauth') . '</p>
604
+                                    <p>' . $lang->get('oauth').'</p>
605 605
                                 </a>
606 606
                             </li>
607 607
                             
608 608
                             <li class="nav-item">
609 609
                                 <a href="#" data-name="uploads" class="nav-link', $get['page'] === 'uploads' ? ' active' : '', '">
610 610
                                     <i class="fa-solid fa-file-upload nav-icon"></i>
611
-                                    <p>' . $lang->get('uploads') . '</p>
611
+                                    <p>' . $lang->get('uploads').'</p>
612 612
                                 </a>
613 613
                             </li>
614 614
                             <li class="nav-item">
615 615
                                 <a href="#" data-name="statistics" class="nav-link', $get['page'] === 'statistics' ? ' active' : '', '">
616 616
                                     <i class="fa-solid fa-chart-bar nav-icon"></i>
617
-                                    <p>' . $lang->get('statistics') . '</p>
617
+                                    <p>' . $lang->get('statistics').'</p>
618 618
                                 </a>
619 619
                             </li>
620 620
                         </ul>
@@ -625,7 +625,7 @@  discard block
 block discarded – undo
625 625
                     <li class="nav-item">
626 626
                         <a href="#" data-name="tasks" class="nav-link', $get['page'] === 'tasks' ? ' active' : '', '">
627 627
                         <i class="fa-solid fa-tasks nav-icon"></i>
628
-                        <p>' . $lang->get('tasks') . '</p>
628
+                        <p>' . $lang->get('tasks').'</p>
629 629
                         </a>
630 630
                     </li>';
631 631
         }
@@ -636,7 +636,7 @@  discard block
 block discarded – undo
636 636
                         <a href="#" data-name="tools" class="nav-link', $get['page'] === 'tools' ? ' active' : '', '">
637 637
                         <i class="nav-icon fa-solid fa-person-drowning"></i>
638 638
                         <p>
639
-                            ' . $lang->get('tools') . '
639
+                            ' . $lang->get('tools').'
640 640
                         </p>
641 641
                         </a>
642 642
                     </li>';
@@ -646,7 +646,7 @@  discard block
 block discarded – undo
646 646
                         <a href="#" data-name="import" class="nav-link', $get['page'] === 'import' ? ' active' : '', '">
647 647
                         <i class="nav-icon fa-solid fa-file-import"></i>
648 648
                         <p>
649
-                            ' . $lang->get('import') . '
649
+                            ' . $lang->get('import').'
650 650
                         </p>
651 651
                         </a>
652 652
                     </li>';
@@ -662,7 +662,7 @@  discard block
 block discarded – undo
662 662
                         <a href="#" data-name="folders" class="nav-link', $get['page'] === 'folders' ? ' active' : '', '">
663 663
                         <i class="nav-icon fa-solid fa-folder-open"></i>
664 664
                         <p>
665
-                            ' . $lang->get('folders') . '
665
+                            ' . $lang->get('folders').'
666 666
                         </p>
667 667
                         </a>
668 668
                     </li>
@@ -670,7 +670,7 @@  discard block
 block discarded – undo
670 670
                         <a href="#" data-name="roles" class="nav-link', $get['page'] === 'roles' ? ' active' : '', '">
671 671
                         <i class="nav-icon fa-solid fa-graduation-cap"></i>
672 672
                         <p>
673
-                            ' . $lang->get('roles') . '
673
+                            ' . $lang->get('roles').'
674 674
                         </p>
675 675
                         </a>
676 676
                     </li>
@@ -678,38 +678,38 @@  discard block
 block discarded – undo
678 678
                         <a href="#" data-name="users" class="nav-link', $get['page'] === 'users' ? ' active' : '', '">
679 679
                         <i class="nav-icon fa-solid fa-users"></i>
680 680
                         <p>
681
-                            ' . $lang->get('users') . '
681
+                            ' . $lang->get('users').'
682 682
                         </p>
683 683
                         </a>
684 684
                     </li>
685 685
                     <li class="nav-item has-treeview', $menuUtilities === true ? ' menu-open' : '', '">
686 686
                         <a href="#" class="nav-link">
687 687
                         <i class="nav-icon fa-solid fa-cubes"></i>
688
-                        <p>' . $lang->get('admin_views') . '<i class="fa-solid fa-angle-left right"></i></p>
688
+                        <p>' . $lang->get('admin_views').'<i class="fa-solid fa-angle-left right"></i></p>
689 689
                         </a>
690 690
                         <ul class="nav nav-treeview">
691 691
                             <li class="nav-item">
692 692
                                 <a href="#" data-name="utilities.renewal" class="nav-link', $get['page'] === 'utilities.renewal' ? ' active' : '', '">
693 693
                                 <i class="far fa-calendar-alt nav-icon"></i>
694
-                                <p>' . $lang->get('renewal') . '</p>
694
+                                <p>' . $lang->get('renewal').'</p>
695 695
                                 </a>
696 696
                             </li>
697 697
                             <li class="nav-item">
698 698
                                 <a href="#" data-name="utilities.deletion" class="nav-link', $get['page'] === 'utilities.deletion' ? ' active' : '', '">
699 699
                                 <i class="fa-solid fa-trash-alt nav-icon"></i>
700
-                                <p>' . $lang->get('deletion') . '</p>
700
+                                <p>' . $lang->get('deletion').'</p>
701 701
                                 </a>
702 702
                             </li>
703 703
                             <li class="nav-item">
704 704
                                 <a href="#" data-name="utilities.logs" class="nav-link', $get['page'] === 'utilities.logs' ? ' active' : '', '">
705 705
                                 <i class="fa-solid fa-history nav-icon"></i>
706
-                                <p>' . $lang->get('logs') . '</p>
706
+                                <p>' . $lang->get('logs').'</p>
707 707
                                 </a>
708 708
                             </li>
709 709
                             <li class="nav-item">
710 710
                                 <a href="#" data-name="utilities.database" class="nav-link', $get['page'] === 'utilities.database' ? ' active' : '', '">
711 711
                                 <i class="fa-solid fa-database nav-icon"></i>
712
-                                <p>' . $lang->get('database') . '</p>
712
+                                <p>' . $lang->get('database').'</p>
713 713
                                 </a>
714 714
                             </li>
715 715
                         </ul>
@@ -720,10 +720,10 @@  discard block
 block discarded – undo
720 720
                     <!-- /.sidebar-menu -->
721 721
                 <div class="menu-footer">
722 722
                     <div class="" id="sidebar-footer">
723
-                        <i class="fa-solid fa-clock-o mr-2 infotip text-info pointer" title="<?php echo htmlspecialchars($lang->get('server_time') . ' ' .
724
-                            date($date_format, (int) $server['request_time']) . ' - ' .
723
+                        <i class="fa-solid fa-clock-o mr-2 infotip text-info pointer" title="<?php echo htmlspecialchars($lang->get('server_time').' '.
724
+                            date($date_format, (int) $server['request_time']).' - '.
725 725
                             date($time_format, (int) $server['request_time']), ENT_QUOTES, 'UTF-8'); ?>"></i>
726
-                        <i class="fa-solid fa-users mr-2 infotip text-info pointer" title="<?php echo $session_nb_users_online . ' ' . $lang->get('users_online'); ?>"></i>
726
+                        <i class="fa-solid fa-users mr-2 infotip text-info pointer" title="<?php echo $session_nb_users_online.' '.$lang->get('users_online'); ?>"></i>
727 727
                         <a href="<?php echo DOCUMENTATION_URL; ?>" target="_blank" class="text-info"><i class="fa-solid fa-book mr-2 infotip" title="<?php echo $lang->get('documentation_canal'); ?>"></i></a>
728 728
                         <a href="<?php echo HELP_URL; ?>" target="_blank" class="text-info"><i class="fa-solid fa-life-ring mr-2 infotip" title="<?php echo $lang->get('admin_help'); ?>"></i></a>
729 729
                         <?php if ($session_user_admin === 1) : ?><i class="fa-solid fa-bug infotip pointer text-info" title="<?php echo $lang->get('bugs_page'); ?>" onclick="generateBugReport()"></i><?php endif; ?>
@@ -874,7 +874,7 @@  discard block
 block discarded – undo
874 874
                                 </div>
875 875
                                 <div class="mt-3">                                    
876 876
                                     <label>
877
-                                        <span class="mr-2 pointer fw-normal"><i class="fa-solid fa-eye mr-2 text-orange"></i><?php echo $lang->get('show_user_password');?></span>
877
+                                        <span class="mr-2 pointer fw-normal"><i class="fa-solid fa-eye mr-2 text-orange"></i><?php echo $lang->get('show_user_password'); ?></span>
878 878
                                         <input type="checkbox" id="dialog-admin-change-user-password-do-show-password" class="pointer">
879 879
                                     </label>
880 880
                                 </div>
@@ -1041,34 +1041,34 @@  discard block
 block discarded – undo
1041 1041
                     if ($get['page'] === 'items') {
1042 1042
                         // SHow page with Items
1043 1043
                         if ((int) $session_user_admin !== 1) {
1044
-                            include $SETTINGS['cpassman_dir'] . '/pages/items.php';
1044
+                            include $SETTINGS['cpassman_dir'].'/pages/items.php';
1045 1045
                         } elseif ((int) $session_user_admin === 1) {
1046
-                            include $SETTINGS['cpassman_dir'] . '/pages/admin.php';
1046
+                            include $SETTINGS['cpassman_dir'].'/pages/admin.php';
1047 1047
                         } else {
1048 1048
                             $session->set('system-error_code', ERR_NOT_ALLOWED);
1049 1049
                             //not allowed page
1050
-                            include $SETTINGS['cpassman_dir'] . '/error.php';
1050
+                            include $SETTINGS['cpassman_dir'].'/error.php';
1051 1051
                         }
1052 1052
                     } elseif (in_array($get['page'], array_keys($mngPages)) === true) {
1053 1053
                         // Define if user is allowed to see management pages
1054 1054
                         if ($session_user_admin === 1) {
1055 1055
                             // deepcode ignore FileInclusion: $get['page'] is secured through usage of array_keys test bellow
1056
-                            include $SETTINGS['cpassman_dir'] . '/pages/' . basename($mngPages[$get['page']]);
1056
+                            include $SETTINGS['cpassman_dir'].'/pages/'.basename($mngPages[$get['page']]);
1057 1057
                         } elseif ($session_user_manager === 1 || $session_user_human_resources === 1) {
1058 1058
                             if ($get['page'] === 'manage_main' || $get['page'] === 'manage_settings'
1059 1059
                             ) {
1060 1060
                                 $session->set('system-error_code', ERR_NOT_ALLOWED);
1061 1061
                                 //not allowed page
1062
-                                include $SETTINGS['cpassman_dir'] . '/error.php';
1062
+                                include $SETTINGS['cpassman_dir'].'/error.php';
1063 1063
                             }
1064 1064
                         } else {
1065 1065
                             $session->set('system-error_code', ERR_NOT_ALLOWED);
1066 1066
                             //not allowed page
1067
-                            include $SETTINGS['cpassman_dir'] . '/error.php';
1067
+                            include $SETTINGS['cpassman_dir'].'/error.php';
1068 1068
                         }
1069
-                    } elseif (empty($get['page']) === false && file_exists($SETTINGS['cpassman_dir'] . '/pages/' . $get['page'] . '.php') === true) {
1069
+                    } elseif (empty($get['page']) === false && file_exists($SETTINGS['cpassman_dir'].'/pages/'.$get['page'].'.php') === true) {
1070 1070
                         // deepcode ignore FileInclusion: $get['page'] is tested against file_exists just below
1071
-                        include $SETTINGS['cpassman_dir'] . '/pages/' . basename($get['page'] . '.php');
1071
+                        include $SETTINGS['cpassman_dir'].'/pages/'.basename($get['page'].'.php');
1072 1072
                     } else {
1073 1073
                         $session->set('system-array_roles', ERR_NOT_EXIST);
1074 1074
                         //page doesn't exist
@@ -1097,7 +1097,7 @@  discard block
 block discarded – undo
1097 1097
             <footer class="main-footer">
1098 1098
                 <!-- To the right -->
1099 1099
                 <div class="float-right d-none d-sm-inline">
1100
-                    <?php echo $lang->get('version_alone'); ?>&nbsp;<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>
1100
+                    <?php echo $lang->get('version_alone'); ?>&nbsp;<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>
1101 1101
                 </div>
1102 1102
                 <!-- Default to the left -->
1103 1103
                 <strong>Copyright &copy; <?php echo TP_COPYRIGHT; ?> <a href="<?php echo TEAMPASS_URL; ?>"><?php echo TP_TOOL_NAME; ?></a>.</strong> All rights reserved.
@@ -1111,7 +1111,7 @@  discard block
 block discarded – undo
1111 1111
         echo '
1112 1112
 <input type="hidden" id="temps_restant" value="', $session->get('user-session_duration') ?? '', '" />';
1113 1113
 // display an item in the context of OTV link
1114
-} elseif ((null === $session->get('user-validite_pw')|| empty($session->get('user-validite_pw')) === true || empty($session->get('user-id')) === true)
1114
+} elseif ((null === $session->get('user-validite_pw') || empty($session->get('user-validite_pw')) === true || empty($session->get('user-id')) === true)
1115 1115
     && empty($get['otv']) === false
1116 1116
 ) {
1117 1117
     // case where one-shot viewer
@@ -1130,7 +1130,7 @@  discard block
 block discarded – undo
1130 1130
                 FILTER_SANITIZE_URL
1131 1131
             )
1132 1132
         );
1133
-        include $SETTINGS['cpassman_dir'] . '/error.php';
1133
+        include $SETTINGS['cpassman_dir'].'/error.php';
1134 1134
     }
1135 1135
 } elseif (//(empty($session->get('user-id')) === false && $session->get('user-id') !== null) ||
1136 1136
         empty($session->get('user-id')) === true
@@ -1155,7 +1155,7 @@  discard block
 block discarded – undo
1155 1155
     }
1156 1156
     
1157 1157
     // LOGIN form  
1158
-    include $SETTINGS['cpassman_dir'] . '/includes/core/login.php';
1158
+    include $SETTINGS['cpassman_dir'].'/includes/core/login.php';
1159 1159
     
1160 1160
 } else {
1161 1161
     // Clear session
@@ -1188,153 +1188,153 @@  discard block
 block discarded – undo
1188 1188
     <!-- REQUIRED SCRIPTS -->
1189 1189
 
1190 1190
     <!-- Font Awesome Icons -->
1191
-    <link href="plugins/fontawesome-free-6/css/fontawesome.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" rel="stylesheet">
1192
-    <link href="plugins/fontawesome-free-6/css/solid.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" rel="stylesheet">
1193
-    <link href="plugins/fontawesome-free-6/css/regular.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" rel="stylesheet">
1194
-    <link href="plugins/fontawesome-free-6/css/brands.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" rel="stylesheet">
1195
-    <link href="plugins/fontawesome-free-6/css/v5-font-face.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" rel="stylesheet" /> 
1191
+    <link href="plugins/fontawesome-free-6/css/fontawesome.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" rel="stylesheet">
1192
+    <link href="plugins/fontawesome-free-6/css/solid.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" rel="stylesheet">
1193
+    <link href="plugins/fontawesome-free-6/css/regular.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" rel="stylesheet">
1194
+    <link href="plugins/fontawesome-free-6/css/brands.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" rel="stylesheet">
1195
+    <link href="plugins/fontawesome-free-6/css/v5-font-face.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" rel="stylesheet" /> 
1196 1196
     <!-- jQuery -->
1197
-    <script src="plugins/jquery/jquery.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1198
-    <script src="plugins/jquery/jquery.cookie.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" type="text/javascript"></script>
1197
+    <script src="plugins/jquery/jquery.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1198
+    <script src="plugins/jquery/jquery.cookie.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" type="text/javascript"></script>
1199 1199
     <!-- jQuery UI -->
1200
-    <script src="plugins/jqueryUI/jquery-ui.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1201
-    <link rel="stylesheet" href="plugins/jqueryUI/jquery-ui.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1200
+    <script src="plugins/jqueryUI/jquery-ui.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1201
+    <link rel="stylesheet" href="plugins/jqueryUI/jquery-ui.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1202 1202
     <!-- Popper -->
1203
-    <script src="plugins/popper/umd/popper.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1203
+    <script src="plugins/popper/umd/popper.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1204 1204
     <!-- Bootstrap -->
1205
-    <script src="plugins/bootstrap/js/bootstrap.bundle.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1205
+    <script src="plugins/bootstrap/js/bootstrap.bundle.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1206 1206
     <!-- AdminLTE -->
1207
-    <script src="plugins/adminlte/js/adminlte.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1207
+    <script src="plugins/adminlte/js/adminlte.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1208 1208
     <!-- Altertify -->
1209 1209
     <!--<script type="text/javascript" src="plugins/alertifyjs/alertify.min.js"></script>-->
1210 1210
     <!-- Toastr -->
1211
-    <script type="text/javascript" src="plugins/toastr/toastr.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1211
+    <script type="text/javascript" src="plugins/toastr/toastr.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1212 1212
     <!-- STORE.JS -->
1213
-    <script type="text/javascript" src="plugins/store.js/dist/store.everything.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1213
+    <script type="text/javascript" src="plugins/store.js/dist/store.everything.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1214 1214
     <!-- cryptojs-aesphp -->
1215
-    <script type="text/javascript" src="includes/libraries/cryptojs/crypto-js.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1216
-    <script type="text/javascript" src="includes/libraries/cryptojs/encryption.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1215
+    <script type="text/javascript" src="includes/libraries/cryptojs/crypto-js.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1216
+    <script type="text/javascript" src="includes/libraries/cryptojs/encryption.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1217 1217
     <!-- pace -->
1218
-    <script type="text/javascript" data-pace-options='{ "ajax": true, "eventLag": false }' src="plugins/pace-progress/pace.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1218
+    <script type="text/javascript" data-pace-options='{ "ajax": true, "eventLag": false }' src="plugins/pace-progress/pace.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1219 1219
     <!-- select2 -->
1220
-    <script type="text/javascript" src="plugins/select2/js/select2.full.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1220
+    <script type="text/javascript" src="plugins/select2/js/select2.full.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1221 1221
     <!-- simplePassMeter -->
1222
-    <link rel="stylesheet" href="plugins/simplePassMeter/simplePassMeter.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" type="text/css" />
1223
-    <script type="text/javascript" src="plugins/simplePassMeter/simplePassMeter.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1222
+    <link rel="stylesheet" href="plugins/simplePassMeter/simplePassMeter.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" type="text/css" />
1223
+    <script type="text/javascript" src="plugins/simplePassMeter/simplePassMeter.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1224 1224
     <!-- platform -->
1225
-    <script type="text/javascript" src="plugins/platform/platform.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1225
+    <script type="text/javascript" src="plugins/platform/platform.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1226 1226
     <!-- radiobuttons -->
1227
-    <link rel="stylesheet" href="plugins/radioforbuttons/bootstrap-buttons.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" type="text/css" />
1228
-    <script type="text/javascript" src="plugins/radioforbuttons/jquery.radiosforbuttons.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1227
+    <link rel="stylesheet" href="plugins/radioforbuttons/bootstrap-buttons.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" type="text/css" />
1228
+    <script type="text/javascript" src="plugins/radioforbuttons/jquery.radiosforbuttons.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1229 1229
     <!-- ICHECK -->
1230 1230
     <!--<link rel="stylesheet" href="./plugins/icheck-material/icheck-material.min.css">-->
1231
-    <link rel="stylesheet" href="./plugins/icheck/skins/all.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1232
-    <script type="text/javascript" src="./plugins/icheck/icheck.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1231
+    <link rel="stylesheet" href="./plugins/icheck/skins/all.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1232
+    <script type="text/javascript" src="./plugins/icheck/icheck.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1233 1233
     <!-- bootstrap-add-clear -->
1234
-    <script type="text/javascript" src="plugins/bootstrap-add-clear/bootstrap-add-clear.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1234
+    <script type="text/javascript" src="plugins/bootstrap-add-clear/bootstrap-add-clear.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1235 1235
     <!-- DOMPurify -->
1236
-    <script type="text/javascript" src="plugins/DOMPurify/purify.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1236
+    <script type="text/javascript" src="plugins/DOMPurify/purify.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1237 1237
 
1238 1238
     <?php
1239 1239
     $get['page'] = $request->query->filter('page', null, FILTER_SANITIZE_SPECIAL_CHARS);
1240 1240
     if ($menuAdmin === true) {
1241 1241
         ?>
1242
-        <link rel="stylesheet" href="./plugins/toggles/css/toggles.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" />
1243
-        <link rel="stylesheet" href="./plugins/toggles/css/toggles-modern.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" />
1244
-        <script src="./plugins/toggles/toggles.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" type="text/javascript"></script>
1242
+        <link rel="stylesheet" href="./plugins/toggles/css/toggles.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" />
1243
+        <link rel="stylesheet" href="./plugins/toggles/css/toggles-modern.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" />
1244
+        <script src="./plugins/toggles/toggles.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" type="text/javascript"></script>
1245 1245
         <!-- InputMask -->
1246
-        <script src="./plugins/inputmask/jquery.inputmask.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1246
+        <script src="./plugins/inputmask/jquery.inputmask.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1247 1247
         <!-- Sortable -->
1248 1248
         <!--<script src="./plugins/sortable/jquery.sortable.js"></script>-->
1249 1249
         <!-- PLUPLOAD -->
1250
-        <script type="text/javascript" src="plugins/plupload/js/plupload.full.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1250
+        <script type="text/javascript" src="plugins/plupload/js/plupload.full.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1251 1251
         <!-- DataTables -->
1252
-        <link rel="stylesheet" src="./plugins/datatables/css/jquery.dataTables.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1253
-        <link rel="stylesheet" src="./plugins/datatables/css/dataTables.bootstrap4.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1254
-        <script type="text/javascript" src="./plugins/datatables/js/jquery.dataTables.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1255
-        <script type="text/javascript" src="./plugins/datatables/js/dataTables.bootstrap4.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1256
-        <link rel="stylesheet" src="./plugins/datatables/extensions/Responsive-2.2.2/css/responsive.bootstrap4.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1257
-        <script type="text/javascript" src="./plugins/datatables/extensions/Responsive-2.2.2/js/dataTables.responsive.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1258
-        <script type="text/javascript" src="./plugins/datatables/extensions/Responsive-2.2.2/js/responsive.bootstrap4.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1259
-        <script type="text/javascript" src="./plugins/datatables/plugins/select.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1260
-        <link rel="stylesheet" src="./plugins/datatables/extensions/Scroller-1.5.0/css/scroller.bootstrap4.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1261
-        <script type="text/javascript" src="./plugins/datatables/extensions/Scroller-1.5.0/js/dataTables.scroller.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1252
+        <link rel="stylesheet" src="./plugins/datatables/css/jquery.dataTables.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1253
+        <link rel="stylesheet" src="./plugins/datatables/css/dataTables.bootstrap4.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1254
+        <script type="text/javascript" src="./plugins/datatables/js/jquery.dataTables.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1255
+        <script type="text/javascript" src="./plugins/datatables/js/dataTables.bootstrap4.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1256
+        <link rel="stylesheet" src="./plugins/datatables/extensions/Responsive-2.2.2/css/responsive.bootstrap4.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1257
+        <script type="text/javascript" src="./plugins/datatables/extensions/Responsive-2.2.2/js/dataTables.responsive.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1258
+        <script type="text/javascript" src="./plugins/datatables/extensions/Responsive-2.2.2/js/responsive.bootstrap4.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1259
+        <script type="text/javascript" src="./plugins/datatables/plugins/select.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1260
+        <link rel="stylesheet" src="./plugins/datatables/extensions/Scroller-1.5.0/css/scroller.bootstrap4.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1261
+        <script type="text/javascript" src="./plugins/datatables/extensions/Scroller-1.5.0/js/dataTables.scroller.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1262 1262
     <?php
1263 1263
     } elseif (isset($get['page']) === true) {
1264 1264
         if (in_array($get['page'], ['items', 'import']) === true) {
1265 1265
             ?>
1266
-            <link rel="stylesheet" href="./plugins/jstree/themes/default/style.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" />
1267
-            <link rel="stylesheet" href="./plugins/jstree/themes/default-dark/style.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" />
1268
-            <script src="./plugins/jstree/jstree.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" type="text/javascript"></script>
1266
+            <link rel="stylesheet" href="./plugins/jstree/themes/default/style.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" />
1267
+            <link rel="stylesheet" href="./plugins/jstree/themes/default-dark/style.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" />
1268
+            <script src="./plugins/jstree/jstree.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" type="text/javascript"></script>
1269 1269
             <!-- countdownTimer -->
1270
-            <script src="./plugins/jquery.countdown360/jquery.countdown360.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1270
+            <script src="./plugins/jquery.countdown360/jquery.countdown360.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1271 1271
             <!-- SUMMERNOTE -->
1272
-            <link rel="stylesheet" href="./plugins/summernote/summernote-bs4.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1273
-            <script src="./plugins/summernote/summernote-bs4.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1272
+            <link rel="stylesheet" href="./plugins/summernote/summernote-bs4.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1273
+            <script src="./plugins/summernote/summernote-bs4.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1274 1274
             <!-- date-picker -->
1275
-            <link rel="stylesheet" href="./plugins/bootstrap-datepicker/css/bootstrap-datepicker3.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1276
-            <script src="./plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1275
+            <link rel="stylesheet" href="./plugins/bootstrap-datepicker/css/bootstrap-datepicker3.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1276
+            <script src="./plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1277 1277
             <!-- time-picker -->
1278
-            <link rel="stylesheet" href="./plugins/timepicker/bootstrap-timepicker.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1279
-            <script src="./plugins/timepicker/bootstrap-timepicker.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1278
+            <link rel="stylesheet" href="./plugins/timepicker/bootstrap-timepicker.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1279
+            <script src="./plugins/timepicker/bootstrap-timepicker.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1280 1280
             <!-- PLUPLOAD -->
1281
-            <script type="text/javascript" src="plugins/plupload/js/plupload.full.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1281
+            <script type="text/javascript" src="plugins/plupload/js/plupload.full.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1282 1282
             <!-- VALIDATE -->
1283
-            <script type="text/javascript" src="plugins/jquery-validation/jquery.validate.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1283
+            <script type="text/javascript" src="plugins/jquery-validation/jquery.validate.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1284 1284
             <!-- PWSTRENGHT -->
1285
-            <script type="text/javascript" src="plugins/zxcvbn/zxcvbn.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1286
-            <script type="text/javascript" src="plugins/jquery.pwstrength/pwstrength-bootstrap.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1285
+            <script type="text/javascript" src="plugins/zxcvbn/zxcvbn.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1286
+            <script type="text/javascript" src="plugins/jquery.pwstrength/pwstrength-bootstrap.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1287 1287
             <!-- TOGGLE -->
1288
-            <link rel="stylesheet" href="./plugins/toggles/css/toggles.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" />
1289
-            <link rel="stylesheet" href="./plugins/toggles/css/toggles-modern.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" />
1290
-            <script src="./plugins/toggles/toggles.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>" type="text/javascript"></script>
1288
+            <link rel="stylesheet" href="./plugins/toggles/css/toggles.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" />
1289
+            <link rel="stylesheet" href="./plugins/toggles/css/toggles-modern.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" />
1290
+            <script src="./plugins/toggles/toggles.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>" type="text/javascript"></script>
1291 1291
         <?php
1292 1292
         } elseif (in_array($get['page'], ['search', 'folders', 'users', 'roles', 'utilities.deletion', 'utilities.logs', 'utilities.database', 'utilities.renewal', 'tasks']) === true) {
1293 1293
             ?>
1294 1294
             <!-- DataTables -->
1295
-            <link rel="stylesheet" src="./plugins/datatables/css/jquery.dataTables.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1296
-            <link rel="stylesheet" src="./plugins/datatables/css/dataTables.bootstrap4.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1297
-            <script type="text/javascript" src="./plugins/datatables/js/jquery.dataTables.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1298
-            <script type="text/javascript" src="./plugins/datatables/js/dataTables.bootstrap4.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1299
-            <link rel="stylesheet" src="./plugins/datatables/extensions/Responsive-2.2.2/css/responsive.bootstrap4.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1300
-            <script type="text/javascript" src="./plugins/datatables/extensions/Responsive-2.2.2/js/dataTables.responsive.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1301
-            <script type="text/javascript" src="./plugins/datatables/extensions/Responsive-2.2.2/js/responsive.bootstrap4.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1302
-            <script type="text/javascript" src="./plugins/datatables/plugins/select.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1303
-            <link rel="stylesheet" src="./plugins/datatables/extensions/Scroller-1.5.0/css/scroller.bootstrap4.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1304
-            <script type="text/javascript" src="./plugins/datatables/extensions/Scroller-1.5.0/js/dataTables.scroller.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1295
+            <link rel="stylesheet" src="./plugins/datatables/css/jquery.dataTables.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1296
+            <link rel="stylesheet" src="./plugins/datatables/css/dataTables.bootstrap4.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1297
+            <script type="text/javascript" src="./plugins/datatables/js/jquery.dataTables.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1298
+            <script type="text/javascript" src="./plugins/datatables/js/dataTables.bootstrap4.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1299
+            <link rel="stylesheet" src="./plugins/datatables/extensions/Responsive-2.2.2/css/responsive.bootstrap4.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1300
+            <script type="text/javascript" src="./plugins/datatables/extensions/Responsive-2.2.2/js/dataTables.responsive.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1301
+            <script type="text/javascript" src="./plugins/datatables/extensions/Responsive-2.2.2/js/responsive.bootstrap4.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1302
+            <script type="text/javascript" src="./plugins/datatables/plugins/select.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1303
+            <link rel="stylesheet" src="./plugins/datatables/extensions/Scroller-1.5.0/css/scroller.bootstrap4.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1304
+            <script type="text/javascript" src="./plugins/datatables/extensions/Scroller-1.5.0/js/dataTables.scroller.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1305 1305
             <!-- dater picker -->
1306
-            <link rel="stylesheet" href="./plugins/bootstrap-datepicker/css/bootstrap-datepicker3.min.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1307
-            <script src="./plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1306
+            <link rel="stylesheet" href="./plugins/bootstrap-datepicker/css/bootstrap-datepicker3.min.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1307
+            <script src="./plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1308 1308
             <!-- daterange picker -->
1309
-            <link rel="stylesheet" href="./plugins/daterangepicker/daterangepicker.css?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>">
1310
-            <script src="./plugins/moment/moment.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1311
-            <script src="./plugins/daterangepicker/daterangepicker.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1309
+            <link rel="stylesheet" href="./plugins/daterangepicker/daterangepicker.css?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>">
1310
+            <script src="./plugins/moment/moment.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1311
+            <script src="./plugins/daterangepicker/daterangepicker.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1312 1312
             <!-- SlimScroll -->
1313
-            <script src="./plugins/slimScroll/jquery.slimscroll.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1313
+            <script src="./plugins/slimScroll/jquery.slimscroll.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1314 1314
             <!-- FastClick -->
1315
-            <script src="./plugins/fastclick/fastclick.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1315
+            <script src="./plugins/fastclick/fastclick.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1316 1316
         <?php
1317 1317
         } elseif ($get['page'] === 'profile') {
1318 1318
             ?>
1319 1319
             <!-- FILESAVER -->
1320
-            <script type="text/javascript" src="plugins/downloadjs/download.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1320
+            <script type="text/javascript" src="plugins/downloadjs/download.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1321 1321
             <!-- PLUPLOAD -->
1322
-            <script type="text/javascript" src="plugins/plupload/js/plupload.full.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1322
+            <script type="text/javascript" src="plugins/plupload/js/plupload.full.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1323 1323
         <?php
1324 1324
         } elseif ($get['page'] === 'export') {
1325 1325
             ?>
1326 1326
             <!-- FILESAVER -->
1327
-            <script type="text/javascript" src="plugins/downloadjs/download.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1327
+            <script type="text/javascript" src="plugins/downloadjs/download.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1328 1328
             <!-- PWSTRENGHT -->
1329
-            <script type="text/javascript" src="plugins/zxcvbn/zxcvbn.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1330
-            <script type="text/javascript" src="plugins/jquery.pwstrength/pwstrength-bootstrap.min.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1329
+            <script type="text/javascript" src="plugins/zxcvbn/zxcvbn.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1330
+            <script type="text/javascript" src="plugins/jquery.pwstrength/pwstrength-bootstrap.min.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1331 1331
         <?php
1332 1332
         }
1333 1333
     }
1334 1334
     ?>
1335 1335
     <!-- functions -->
1336
-    <script type="text/javascript" src="includes/js/functions.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1337
-    <script type="text/javascript" src="includes/js/CreateRandomString.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1336
+    <script type="text/javascript" src="includes/js/functions.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1337
+    <script type="text/javascript" src="includes/js/CreateRandomString.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1338 1338
     <input type="hidden" id="encryptClientServerStatus" value="<?php echo $SETTINGS['encryptClientServer'] ?? 1; ?>" />
1339 1339
 
1340 1340
     </body>
@@ -1376,7 +1376,7 @@  discard block
 block discarded – undo
1376 1376
     };
1377 1377
 </script>
1378 1378
 
1379
-<script type="text/javascript" src="includes/js/secure-clipboard-cleaner.js?v=<?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?>"></script>
1379
+<script type="text/javascript" src="includes/js/secure-clipboard-cleaner.js?v=<?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?>"></script>
1380 1380
 
1381 1381
 <script>
1382 1382
     $(document).ready(function() {
@@ -1435,65 +1435,65 @@  discard block
 block discarded – undo
1435 1435
 
1436 1436
 // Load links, css and javascripts
1437 1437
 if (isset($SETTINGS['cpassman_dir']) === true) {
1438
-    include_once $SETTINGS['cpassman_dir'] . '/includes/core/load.js.php';
1438
+    include_once $SETTINGS['cpassman_dir'].'/includes/core/load.js.php';
1439 1439
     if ($menuAdmin === true) {
1440
-        include_once $SETTINGS['cpassman_dir'] . '/pages/admin.js.php';
1440
+        include_once $SETTINGS['cpassman_dir'].'/pages/admin.js.php';
1441 1441
         if ($get['page'] === '2fa') {
1442
-            include_once $SETTINGS['cpassman_dir'] . '/pages/2fa.js.php';
1442
+            include_once $SETTINGS['cpassman_dir'].'/pages/2fa.js.php';
1443 1443
         } elseif ($get['page'] === 'api') {
1444
-            include_once $SETTINGS['cpassman_dir'] . '/pages/api.js.php';
1444
+            include_once $SETTINGS['cpassman_dir'].'/pages/api.js.php';
1445 1445
         } elseif ($get['page'] === 'backups') {
1446
-            include_once $SETTINGS['cpassman_dir'] . '/pages/backups.js.php';
1446
+            include_once $SETTINGS['cpassman_dir'].'/pages/backups.js.php';
1447 1447
         } elseif ($get['page'] === 'emails') {
1448
-            include_once $SETTINGS['cpassman_dir'] . '/pages/emails.js.php';
1448
+            include_once $SETTINGS['cpassman_dir'].'/pages/emails.js.php';
1449 1449
         } elseif ($get['page'] === 'ldap') {
1450
-            include_once $SETTINGS['cpassman_dir'] . '/pages/ldap.js.php';
1450
+            include_once $SETTINGS['cpassman_dir'].'/pages/ldap.js.php';
1451 1451
         } elseif ($get['page'] === 'uploads') {
1452
-            include_once $SETTINGS['cpassman_dir'] . '/pages/uploads.js.php';
1452
+            include_once $SETTINGS['cpassman_dir'].'/pages/uploads.js.php';
1453 1453
         } elseif ($get['page'] === 'fields') {
1454
-            include_once $SETTINGS['cpassman_dir'] . '/pages/fields.js.php';
1454
+            include_once $SETTINGS['cpassman_dir'].'/pages/fields.js.php';
1455 1455
         } elseif ($get['page'] === 'options') {
1456
-            include_once $SETTINGS['cpassman_dir'] . '/pages/options.js.php';
1456
+            include_once $SETTINGS['cpassman_dir'].'/pages/options.js.php';
1457 1457
         } elseif ($get['page'] === 'statistics') {
1458
-            include_once $SETTINGS['cpassman_dir'] . '/pages/statistics.js.php';
1458
+            include_once $SETTINGS['cpassman_dir'].'/pages/statistics.js.php';
1459 1459
         } elseif ($get['page'] === 'tasks') {
1460
-            include_once $SETTINGS['cpassman_dir'] . '/pages/tasks.js.php';
1460
+            include_once $SETTINGS['cpassman_dir'].'/pages/tasks.js.php';
1461 1461
         } elseif ($get['page'] === 'oauth') {
1462
-            include_once $SETTINGS['cpassman_dir'] . '/pages/oauth.js.php';        
1462
+            include_once $SETTINGS['cpassman_dir'].'/pages/oauth.js.php';        
1463 1463
         } elseif ($get['page'] === 'tools') {
1464
-            include_once $SETTINGS['cpassman_dir'] . '/pages/tools.js.php';
1464
+            include_once $SETTINGS['cpassman_dir'].'/pages/tools.js.php';
1465 1465
         }
1466 1466
     } elseif (isset($get['page']) === true && $get['page'] !== '') {
1467 1467
         if ($get['page'] === 'items') {
1468
-            include_once $SETTINGS['cpassman_dir'] . '/pages/items.js.php';
1468
+            include_once $SETTINGS['cpassman_dir'].'/pages/items.js.php';
1469 1469
         } elseif ($get['page'] === 'import') {
1470
-            include_once $SETTINGS['cpassman_dir'] . '/pages/import.js.php';
1470
+            include_once $SETTINGS['cpassman_dir'].'/pages/import.js.php';
1471 1471
         } elseif ($get['page'] === 'export') {
1472
-            include_once $SETTINGS['cpassman_dir'] . '/pages/export.js.php';
1472
+            include_once $SETTINGS['cpassman_dir'].'/pages/export.js.php';
1473 1473
         } elseif ($get['page'] === 'offline') {
1474
-            include_once $SETTINGS['cpassman_dir'] . '/pages/offline.js.php';
1474
+            include_once $SETTINGS['cpassman_dir'].'/pages/offline.js.php';
1475 1475
         } elseif ($get['page'] === 'search') {
1476
-            include_once $SETTINGS['cpassman_dir'] . '/pages/search.js.php';
1476
+            include_once $SETTINGS['cpassman_dir'].'/pages/search.js.php';
1477 1477
         } elseif ($get['page'] === 'profile') {
1478
-            include_once $SETTINGS['cpassman_dir'] . '/pages/profile.js.php';
1478
+            include_once $SETTINGS['cpassman_dir'].'/pages/profile.js.php';
1479 1479
         } elseif ($get['page'] === 'favourites') {
1480
-            include_once $SETTINGS['cpassman_dir'] . '/pages/favorites.js.php';
1480
+            include_once $SETTINGS['cpassman_dir'].'/pages/favorites.js.php';
1481 1481
         } elseif ($get['page'] === 'folders') {
1482
-            include_once $SETTINGS['cpassman_dir'] . '/pages/folders.js.php';
1482
+            include_once $SETTINGS['cpassman_dir'].'/pages/folders.js.php';
1483 1483
         } elseif ($get['page'] === 'users') {
1484
-            include_once $SETTINGS['cpassman_dir'] . '/pages/users.js.php';
1484
+            include_once $SETTINGS['cpassman_dir'].'/pages/users.js.php';
1485 1485
         } elseif ($get['page'] === 'roles') {
1486
-            include_once $SETTINGS['cpassman_dir'] . '/pages/roles.js.php';
1486
+            include_once $SETTINGS['cpassman_dir'].'/pages/roles.js.php';
1487 1487
         } elseif ($get['page'] === 'utilities.deletion') {
1488
-            include_once $SETTINGS['cpassman_dir'] . '/pages/utilities.deletion.js.php';
1488
+            include_once $SETTINGS['cpassman_dir'].'/pages/utilities.deletion.js.php';
1489 1489
         } elseif ($get['page'] === 'utilities.logs') {
1490
-            include_once $SETTINGS['cpassman_dir'] . '/pages/utilities.logs.js.php';
1490
+            include_once $SETTINGS['cpassman_dir'].'/pages/utilities.logs.js.php';
1491 1491
         } elseif ($get['page'] === 'utilities.database') {
1492
-            include_once $SETTINGS['cpassman_dir'] . '/pages/utilities.database.js.php';
1492
+            include_once $SETTINGS['cpassman_dir'].'/pages/utilities.database.js.php';
1493 1493
         } elseif ($get['page'] === 'utilities.renewal') {
1494
-            include_once $SETTINGS['cpassman_dir'] . '/pages/utilities.renewal.js.php';
1494
+            include_once $SETTINGS['cpassman_dir'].'/pages/utilities.renewal.js.php';
1495 1495
         }
1496 1496
     } else {
1497
-        include_once $SETTINGS['cpassman_dir'] . '/includes/core/login.js.php';
1497
+        include_once $SETTINGS['cpassman_dir'].'/includes/core/login.js.php';
1498 1498
     }
1499 1499
 }
Please login to merge, or discard this patch.
Braces   +6 added lines, -2 removed lines patch added patch discarded remove patch
@@ -80,8 +80,9 @@  discard block
 block discarded – undo
80 80
 $session = SessionManager::getSession();
81 81
 
82 82
 // Random encryption key
83
-if ($session->get('key') === null)
83
+if ($session->get('key') === null) {
84 84
     $session->set('key', generateQuickPassword(30, false));
85
+}
85 86
 
86 87
 $request = SymfonyRequest::createFromGlobals();
87 88
 $configManager = new ConfigManager();
@@ -980,7 +981,10 @@  discard block
 block discarded – undo
980 981
                                     <input type="password" class="form-control" id="dialog-ldap-user-build-keys-database-code">
981 982
                                     <br/>
982 983
                                 </div>
983
-                                <div class="input-group mb-3<?php if ($session_auth_type === 'oauth2') echo ' hidden'; ?>">
984
+                                <div class="input-group mb-3<?php if ($session_auth_type === 'oauth2') {
985
+    echo ' hidden';
986
+}
987
+?>">
984 988
                                     <div class="input-group-prepend">
985 989
                                         <span class="input-group-text"><?php echo $lang->get('provide_your_current_password'); ?></span>
986 990
                                     </div>
Please login to merge, or discard this patch.
pages/oauth.js.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
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('oauth') === false) {
72 72
     // Not allowed page
73 73
     $session->set('system-error_code', ERR_NOT_ALLOWED);
74
-    include $SETTINGS['cpassman_dir'] . '/error.php';
74
+    include $SETTINGS['cpassman_dir'].'/error.php';
75 75
     exit;
76 76
 }
77 77
 ?>
@@ -226,7 +226,7 @@  discard block
 block discarded – undo
226 226
                     if (data[i].selected_role === 1) {
227 227
                         selected_role = data[i].id;
228 228
                     }
229
-                    html_admin_by += '<option value="' + data[i].id + '"><?php echo $lang->get('managers_of') . ' '; ?>' + data[i].title + '</option>';
229
+                    html_admin_by += '<option value="' + data[i].id + '"><?php echo $lang->get('managers_of').' '; ?>' + data[i].title + '</option>';
230 230
                     html_roles += '<option value="' + data[i].id + '">' + data[i].title + '</option>';
231 231
                 }
232 232
                 $('#oauth_new_user_is_administrated_by')
@@ -255,7 +255,7 @@  discard block
 block discarded – undo
255 255
             }).fail(function(error) {
256 256
                 toastr.remove();
257 257
                 toastr.error(
258
-                    '<?php echo $lang->get('server_answer_error') . '<br />' . $lang->get('server_returned_data') . ':<br />'; ?>' + error,
258
+                    '<?php echo $lang->get('server_answer_error').'<br />'.$lang->get('server_returned_data').':<br />'; ?>' + error,
259 259
                     '', {
260 260
                         closeButton: true,
261 261
                         positionClass: 'toast-bottom-right'
Please login to merge, or discard this patch.
pages/items.js.php 1 patch
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('items') === false) {
73 73
     // Not allowed page
74 74
     $session->set('system-error_code', ERR_NOT_ALLOWED);
75
-    include $SETTINGS['cpassman_dir'] . '/error.php';
75
+    include $SETTINGS['cpassman_dir'].'/error.php';
76 76
     exit;
77 77
 }
78 78
 
@@ -1056,7 +1056,7 @@  discard block
 block discarded – undo
1056 1056
             //
1057 1057
         } else if ($(this).data('item-action') === 'link') {
1058 1058
             // Add link to clipboard.
1059
-            navigator.clipboard.writeText("<?php echo $SETTINGS['cpassman_url'];?>/index.php?page=items&group="+store.get('teampassItem').folderId+"&id="+store.get('teampassItem').id);
1059
+            navigator.clipboard.writeText("<?php echo $SETTINGS['cpassman_url']; ?>/index.php?page=items&group="+store.get('teampassItem').folderId+"&id="+store.get('teampassItem').id);
1060 1060
 
1061 1061
             // Display message.
1062 1062
             toastr.remove();
@@ -2698,7 +2698,7 @@  discard block
 block discarded – undo
2698 2698
                 progress: "#form-item-password-strength",
2699 2699
                 score: "#form-item-password-strength"
2700 2700
             },
2701
-            scores: [<?php echo TP_PW_STRENGTH_1;?>, <?php echo TP_PW_STRENGTH_2;?>, <?php echo TP_PW_STRENGTH_3;?>, <?php echo TP_PW_STRENGTH_4;?>, <?php echo TP_PW_STRENGTH_5;?>],
2701
+            scores: [<?php echo TP_PW_STRENGTH_1; ?>, <?php echo TP_PW_STRENGTH_2; ?>, <?php echo TP_PW_STRENGTH_3; ?>, <?php echo TP_PW_STRENGTH_4; ?>, <?php echo TP_PW_STRENGTH_5; ?>],
2702 2702
         },
2703 2703
         i18n : {
2704 2704
             t: function (key) {
@@ -2725,7 +2725,7 @@  discard block
 block discarded – undo
2725 2725
     <?php
2726 2726
     $max_file_size = '';
2727 2727
     if (strrpos($SETTINGS['upload_maxfilesize'], 'mb') === false) {
2728
-        $max_file_size = $SETTINGS['upload_maxfilesize'] . 'mb';
2728
+        $max_file_size = $SETTINGS['upload_maxfilesize'].'mb';
2729 2729
     } else {
2730 2730
         $max_file_size = $SETTINGS['upload_maxfilesize'];
2731 2731
     }
@@ -4647,7 +4647,7 @@  discard block
 block discarded – undo
4647 4647
                         (retData.edition_locked_delay === null ? 
4648 4648
                         '' 
4649 4649
                         :
4650
-                        ' : ' + retData.edition_locked_delay + ' <?php echo $lang->get('seconds');?>'),
4650
+                        ' : ' + retData.edition_locked_delay + ' <?php echo $lang->get('seconds'); ?>'),
4651 4651
                     '', {
4652 4652
                         timeOut: 5000,
4653 4653
                         progressBar: true
@@ -4804,7 +4804,7 @@  discard block
 block discarded – undo
4804 4804
 
4805 4805
                             // Show passwords inputs and form
4806 4806
                             $('#dialog-ldap-user-change-password-info')
4807
-                                .html('<i class="icon fa-solid fa-info mr-2"></i><?php echo $lang->get('ldap_user_has_changed_his_password');?>')
4807
+                                .html('<i class="icon fa-solid fa-info mr-2"></i><?php echo $lang->get('ldap_user_has_changed_his_password'); ?>')
4808 4808
                                 .removeClass('hidden');
4809 4809
                             $('#dialog-ldap-user-change-password').removeClass('hidden');
4810 4810
                         } else if (data.error_type !== 'undefined') {
@@ -4823,7 +4823,7 @@  discard block
 block discarded – undo
4823 4823
 
4824 4824
                                 // Show passwords inputs and form
4825 4825
                                 $('#dialog-ldap-user-change-password-info')
4826
-                                    .html('<i class="icon fa-solid fa-info mr-2"></i><?php echo $lang->get('ldap_user_has_changed_his_password');?>')
4826
+                                    .html('<i class="icon fa-solid fa-info mr-2"></i><?php echo $lang->get('ldap_user_has_changed_his_password'); ?>')
4827 4827
                                     .removeClass('hidden');
4828 4828
                                 $('#dialog-ldap-user-change-password').removeClass('hidden');
4829 4829
                             });
Please login to merge, or discard this patch.
sources/items.queries.php 3 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -1836,7 +1836,7 @@
 block discarded – undo
1836 1836
                     '',
1837 1837
                     'encrypt'
1838 1838
                 );
1839
-           }
1839
+            }
1840 1840
 
1841 1841
             // Check if status or secret or phone number has changed
1842 1842
             if (DB::count() > 0
Please login to merge, or discard this patch.
Spacing   +281 added lines, -282 removed lines patch added patch discarded remove patch
@@ -79,7 +79,7 @@  discard block
 block discarded – undo
79 79
 ) {
80 80
     // Not allowed page
81 81
     $session->set('system-error_code', ERR_NOT_ALLOWED);
82
-    include $SETTINGS['cpassman_dir'] . '/error.php';
82
+    include $SETTINGS['cpassman_dir'].'/error.php';
83 83
     exit;
84 84
 }
85 85
 
@@ -104,7 +104,7 @@  discard block
 block discarded – undo
104 104
     date_default_timezone_set('UTC');
105 105
 }
106 106
 
107
-require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $session->get('user-language') . '.php';
107
+require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$session->get('user-language').'.php';
108 108
 header('Content-type: text/html; charset=utf-8');
109 109
 header('Cache-Control: no-cache, must-revalidate');
110 110
 
@@ -365,7 +365,7 @@  discard block
 block discarded – undo
365 365
             // About special settings
366 366
             $dataFolderSettings = DB::queryFirstRow(
367 367
                 'SELECT bloquer_creation, bloquer_modification, personal_folder
368
-                FROM ' . prefixTable('nested_tree') . ' 
368
+                FROM ' . prefixTable('nested_tree').' 
369 369
                 WHERE id = %i',
370 370
                 $inputData['folderId']
371 371
             );
@@ -382,7 +382,7 @@  discard block
 block discarded – undo
382 382
             // Get folder complexity
383 383
             $folderComplexity = DB::queryFirstRow(
384 384
                 'SELECT valeur
385
-                FROM ' . prefixTable('misc') . '
385
+                FROM ' . prefixTable('misc').'
386 386
                 WHERE type = %s AND intitule = %i',
387 387
                 'complex',
388 388
                 $inputData['folderId']
@@ -407,7 +407,7 @@  discard block
 block discarded – undo
407 407
             $itemExists = 0;
408 408
             $newID = '';
409 409
             $data = DB::queryFirstRow(
410
-                'SELECT * FROM ' . prefixTable('items') . '
410
+                'SELECT * FROM '.prefixTable('items').'
411 411
                 WHERE label = %s AND inactif = %i',
412 412
                 $inputData['label'],
413 413
                 0
@@ -488,8 +488,8 @@  discard block
 block discarded – undo
488 488
                     (int) $post_folder_is_personal,
489 489
                     (int) $newID,
490 490
                     $cryptedStuff['objectKey'],
491
-                    true,   // only for the item creator
492
-                    false,  // no delete all
491
+                    true, // only for the item creator
492
+                    false, // no delete all
493 493
                 );
494 494
 
495 495
                 // update fields
@@ -502,7 +502,7 @@  discard block
 block discarded – undo
502 502
                             // should we encrypt the data
503 503
                             $dataTmp = DB::queryFirstRow(
504 504
                                 'SELECT encrypted_data
505
-                                FROM ' . prefixTable('categories') . '
505
+                                FROM ' . prefixTable('categories').'
506 506
                                 WHERE id = %i',
507 507
                                 $field['id']
508 508
                             );
@@ -531,8 +531,8 @@  discard block
 block discarded – undo
531 531
                                     (int) $post_folder_is_personal,
532 532
                                     (int) $newObjectId,
533 533
                                     $cryptedStuff['objectKey'],
534
-                                    true,   // only for the item creator
535
-                                    false,  // no delete all
534
+                                    true, // only for the item creator
535
+                                    false, // no delete all
536 536
                                 );
537 537
 
538 538
                                 array_push(
@@ -568,7 +568,7 @@  discard block
 block discarded – undo
568 568
                 ) {
569 569
                     DB::queryFirstRow(
570 570
                         'SELECT *
571
-                        FROM ' . prefixTable('templates') . '
571
+                        FROM ' . prefixTable('templates').'
572 572
                         WHERE item_id = %i',
573 573
                         $newID
574 574
                     );
@@ -637,11 +637,11 @@  discard block
 block discarded – undo
637 637
                 ) {
638 638
                     foreach ($post_restricted_to as $userRest) {
639 639
                         if (empty($userRest) === false) {
640
-                            $dataTmp = DB::queryFirstRow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= %i', $userRest);
640
+                            $dataTmp = DB::queryFirstRow('SELECT login FROM '.prefixTable('users').' WHERE id= %i', $userRest);
641 641
                             if (empty($listOfRestricted)) {
642 642
                                 $listOfRestricted = $dataTmp['login'];
643 643
                             } else {
644
-                                $listOfRestricted .= ';' . $dataTmp['login'];
644
+                                $listOfRestricted .= ';'.$dataTmp['login'];
645 645
                             }
646 646
                         }
647 647
                     }
@@ -657,7 +657,7 @@  discard block
 block discarded – undo
657 657
                             if (empty($userRest) === false) {
658 658
                                 $dataTmp = DB::queryFirstRow(
659 659
                                     'SELECT login
660
-                                    FROM ' . prefixTable('users') . '
660
+                                    FROM ' . prefixTable('users').'
661 661
                                     WHERE id= %i',
662 662
                                     $userRest
663 663
                                 );
@@ -665,7 +665,7 @@  discard block
 block discarded – undo
665 665
                                 if (empty($oldRestrictionList) === true) {
666 666
                                     $oldRestrictionList = $dataTmp['login'];
667 667
                                 } else {
668
-                                    $oldRestrictionList .= ';' . $dataTmp['login'];
668
+                                    $oldRestrictionList .= ';'.$dataTmp['login'];
669 669
                                 }
670 670
                             }
671 671
                         }
@@ -728,7 +728,7 @@  discard block
 block discarded – undo
728 728
                 if (empty($post_uploaded_file_id) === false) {
729 729
                     $rows = DB::query(
730 730
                         'SELECT id
731
-                        FROM ' . prefixTable('files') . '
731
+                        FROM ' . prefixTable('files').'
732 732
                         WHERE id_item = %s',
733 733
                         $post_uploaded_file_id
734 734
                     );
@@ -784,7 +784,7 @@  discard block
 block discarded – undo
784 784
                                     $lang->get('email_subject_item_updated'),
785 785
                                     str_replace(
786 786
                                         array('#label', '#link'),
787
-                                            array($path, $SETTINGS['email_server_url'] . '/index.php?page=items&group=' . $inputData['folderId'] . '&id=' . $newID . $lang['email_body3']),
787
+                                            array($path, $SETTINGS['email_server_url'].'/index.php?page=items&group='.$inputData['folderId'].'&id='.$newID.$lang['email_body3']),
788 788
                                             $lang->get('new_item_email_body')
789 789
                                     ),
790 790
                                     $emailAddress,
@@ -888,11 +888,11 @@  discard block
 block discarded – undo
888 888
         // Prepare variables
889 889
         $itemInfos = array();
890 890
         $inputData['label'] = isset($dataReceived['label']) && is_string($dataReceived['label']) ? filter_var($dataReceived['label'], FILTER_SANITIZE_FULL_SPECIAL_CHARS) : '';
891
-        $post_url = isset($dataReceived['url'])=== true ? filter_var(htmlspecialchars_decode($dataReceived['url']), FILTER_SANITIZE_URL) : '';
891
+        $post_url = isset($dataReceived['url']) === true ? filter_var(htmlspecialchars_decode($dataReceived['url']), FILTER_SANITIZE_URL) : '';
892 892
         $post_password = $original_pw = isset($dataReceived['pw']) && is_string($dataReceived['pw']) ? htmlspecialchars_decode($dataReceived['pw']) : '';
893 893
         $post_login = isset($dataReceived['login']) && is_string($dataReceived['login']) ? filter_var(htmlspecialchars_decode($dataReceived['login']), FILTER_SANITIZE_FULL_SPECIAL_CHARS) : '';
894
-        $post_tags = isset($dataReceived['tags'])=== true ? htmlspecialchars($dataReceived['tags']) : '';
895
-        $post_email = isset($dataReceived['email'])=== true ? filter_var(htmlspecialchars_decode($dataReceived['email']), FILTER_SANITIZE_EMAIL) : '';
894
+        $post_tags = isset($dataReceived['tags']) === true ? htmlspecialchars($dataReceived['tags']) : '';
895
+        $post_email = isset($dataReceived['email']) === true ? filter_var(htmlspecialchars_decode($dataReceived['email']), FILTER_SANITIZE_EMAIL) : '';
896 896
         $post_template_id = (int) filter_var($dataReceived['template_id'], FILTER_SANITIZE_NUMBER_INT);
897 897
         $inputData['itemId'] = (int) filter_var($dataReceived['id'], FILTER_SANITIZE_NUMBER_INT);
898 898
         $post_anyone_can_modify = (int) filter_var($dataReceived['anyone_can_modify'], FILTER_SANITIZE_NUMBER_INT);
@@ -923,8 +923,7 @@  discard block
 block discarded – undo
923 923
         $post_to_be_deleted_after_date = isset($dataReceived['to_be_deleted_after_date']) === true ? filter_var(
924 924
                 $dataReceived['to_be_deleted_after_date'],
925 925
                 FILTER_SANITIZE_FULL_SPECIAL_CHARS
926
-            ) :
927
-            '';
926
+            ) : '';
928 927
         $post_fields = (filter_var_array(
929 928
             $dataReceived['fields'],
930 929
             FILTER_SANITIZE_FULL_SPECIAL_CHARS
@@ -984,7 +983,7 @@  discard block
 block discarded – undo
984 983
         // About special settings
985 984
         $dataFolderSettings = DB::queryFirstRow(
986 985
             'SELECT bloquer_creation, bloquer_modification, personal_folder, title
987
-            FROM ' . prefixTable('nested_tree') . ' 
986
+            FROM ' . prefixTable('nested_tree').' 
988 987
             WHERE id = %i',
989 988
             $inputData['folderId']
990 989
         );
@@ -1000,7 +999,7 @@  discard block
 block discarded – undo
1000 999
         // Get folder complexity
1001 1000
         $folderComplexity = DB::queryFirstRow(
1002 1001
             'SELECT valeur
1003
-            FROM ' . prefixTable('misc') . '
1002
+            FROM ' . prefixTable('misc').'
1004 1003
             WHERE type = %s AND intitule = %i',
1005 1004
             'complex',
1006 1005
             $inputData['folderId']
@@ -1045,8 +1044,8 @@  discard block
 block discarded – undo
1045 1044
         // Get all informations for this item
1046 1045
         $dataItem = DB::queryFirstRow(
1047 1046
             'SELECT *
1048
-            FROM ' . prefixTable('items') . ' as i
1049
-            INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id)
1047
+            FROM ' . prefixTable('items').' as i
1048
+            INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id)
1050 1049
             WHERE i.id=%i AND l.action = %s',
1051 1050
             $inputData['itemId'],
1052 1051
             'at_creation'
@@ -1088,7 +1087,7 @@  discard block
 block discarded – undo
1088 1087
         // Does the user has the sharekey for this item?
1089 1088
         DB::query(
1090 1089
             'SELECT *
1091
-            FROM ' . prefixTable('sharekeys_items') . '
1090
+            FROM ' . prefixTable('sharekeys_items').'
1092 1091
             WHERE object_id = %i AND user_id = %s',
1093 1092
             $inputData['itemId'],
1094 1093
             $session->get('user-id')
@@ -1149,9 +1148,9 @@  discard block
 block discarded – undo
1149 1148
                 'SELECT i.id as id, i.label as label, i.description as description, i.pw as pw, i.url as url, i.id_tree as id_tree, i.perso as perso, i.login as login, 
1150 1149
                 i.inactif as inactif, i.restricted_to as restricted_to, i.anyone_can_modify as anyone_can_modify, i.email as email, i.notification as notification,
1151 1150
                 u.login as user_login, u.email as user_email
1152
-                FROM ' . prefixTable('items') . ' as i
1153
-                INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id=l.id_item)
1154
-                INNER JOIN ' . prefixTable('users') . ' as u ON (u.id=l.id_user)
1151
+                FROM ' . prefixTable('items').' as i
1152
+                INNER JOIN ' . prefixTable('log_items').' as l ON (i.id=l.id_item)
1153
+                INNER JOIN ' . prefixTable('users').' as u ON (u.id=l.id_user)
1155 1154
                 WHERE i.id=%i',
1156 1155
                 $inputData['itemId']
1157 1156
             );
@@ -1159,7 +1158,7 @@  discard block
 block discarded – undo
1159 1158
             // Should we log a password change?
1160 1159
             $userKey = DB::queryFirstRow(
1161 1160
                 'SELECT share_key
1162
-                FROM ' . prefixTable('sharekeys_items') . '
1161
+                FROM ' . prefixTable('sharekeys_items').'
1163 1162
                 WHERE user_id = %i AND object_id = %i',
1164 1163
                 $session->get('user-id'),
1165 1164
                 $inputData['itemId']
@@ -1223,12 +1222,12 @@  discard block
 block discarded – undo
1223 1222
                     (int) $post_folder_is_personal,
1224 1223
                     (int) $inputData['itemId'],
1225 1224
                     $encrypted_password_key,
1226
-                    true,   // only for the item creator
1227
-                    true,   // delete all
1225
+                    true, // only for the item creator
1226
+                    true, // delete all
1228 1227
                 );
1229 1228
 
1230 1229
                 // Create a task to create sharekeys for users
1231
-                if (WIP=== true) error_log('createTaskForItem - new password for this item - '.$post_password ." -- ". $pw);
1230
+                if (WIP === true) error_log('createTaskForItem - new password for this item - '.$post_password." -- ".$pw);
1232 1231
                 $tasksToBePerformed = ['item_password'];
1233 1232
                 $encryptionTaskIsRequested = true;
1234 1233
             } else {
@@ -1239,7 +1238,7 @@  discard block
 block discarded – undo
1239 1238
             // Get list of tags
1240 1239
             $itemTags = DB::queryFirstColumn(
1241 1240
                 'SELECT tag
1242
-                FROM ' . prefixTable('tags') . '
1241
+                FROM ' . prefixTable('tags').'
1243 1242
                 WHERE item_id = %i',
1244 1243
                 $inputData['itemId']
1245 1244
             );
@@ -1285,7 +1284,7 @@  discard block
 block discarded – undo
1285 1284
                     $session->get('user-id'),
1286 1285
                     'at_modification',
1287 1286
                     $session->get('user-login'),
1288
-                    'at_tag : ' . implode(' ', $itemTags) . ' => ' . $post_tags
1287
+                    'at_tag : '.implode(' ', $itemTags).' => '.$post_tags
1289 1288
                 );
1290 1289
             }
1291 1290
 
@@ -1330,8 +1329,8 @@  discard block
 block discarded – undo
1330 1329
                             'SELECT c.id AS id, c.title AS title, i.data AS data, i.data_iv AS data_iv,
1331 1330
                             i.encryption_type AS encryption_type, c.encrypted_data AS encrypted_data,
1332 1331
                             c.masked AS masked, i.id AS field_item_id
1333
-                            FROM ' . prefixTable('categories_items') . ' AS i
1334
-                            INNER JOIN ' . prefixTable('categories') . ' AS c ON (i.field_id=c.id)
1332
+                            FROM ' . prefixTable('categories_items').' AS i
1333
+                            INNER JOIN ' . prefixTable('categories').' AS c ON (i.field_id=c.id)
1335 1334
                             WHERE i.field_id = %i AND i.item_id = %i',
1336 1335
                             $field['id'],
1337 1336
                             $inputData['itemId']
@@ -1347,7 +1346,7 @@  discard block
 block discarded – undo
1347 1346
                             // Perform new query
1348 1347
                             $dataTmpCat = DB::queryFirstRow(
1349 1348
                                 'SELECT id, title, encrypted_data, masked
1350
-                                FROM ' . prefixTable('categories') . '
1349
+                                FROM ' . prefixTable('categories').'
1351 1350
                                 WHERE id = %i',
1352 1351
                                 $field['id']
1353 1352
                             );
@@ -1377,8 +1376,8 @@  discard block
 block discarded – undo
1377 1376
                                     (int) $post_folder_is_personal,
1378 1377
                                     (int) $newId,
1379 1378
                                     $cryptedStuff['objectKey'],
1380
-                                    true,   // only for the item creator
1381
-                                    true,   // delete all
1379
+                                    true, // only for the item creator
1380
+                                    true, // delete all
1382 1381
                                 );
1383 1382
 
1384 1383
                                 // update value
@@ -1428,7 +1427,7 @@  discard block
 block discarded – undo
1428 1427
                                 $session->get('user-id'),
1429 1428
                                 'at_modification',
1430 1429
                                 $session->get('user-login'),
1431
-                                'at_field : ' . $dataTmpCat['title'] . ' : ' . $field['value']
1430
+                                'at_field : '.$dataTmpCat['title'].' : '.$field['value']
1432 1431
                             );
1433 1432
                         } else {
1434 1433
                             // Case where the field already exists
@@ -1437,7 +1436,7 @@  discard block
 block discarded – undo
1437 1436
                                 // Get user sharekey for this field
1438 1437
                                 $userKey = DB::queryFirstRow(
1439 1438
                                     'SELECT share_key
1440
-                                    FROM ' . prefixTable('sharekeys_fields') . '
1439
+                                    FROM ' . prefixTable('sharekeys_fields').'
1441 1440
                                     WHERE user_id = %i AND object_id = %i',
1442 1441
                                     $session->get('user-id'),
1443 1442
                                     $dataTmpCat['field_item_id']
@@ -1476,8 +1475,8 @@  discard block
 block discarded – undo
1476 1475
                                         (int) $post_folder_is_personal,
1477 1476
                                         (int) $dataTmpCat['field_item_id'],
1478 1477
                                         $cryptedStuff['objectKey'],
1479
-                                        true,   // only for the item creator
1480
-                                        true,   // delete all
1478
+                                        true, // only for the item creator
1479
+                                        true, // delete all
1481 1480
                                     );
1482 1481
 
1483 1482
                                     if ($encryptedFieldIsChanged === false) {
@@ -1519,7 +1518,7 @@  discard block
 block discarded – undo
1519 1518
                                     $session->get('user-id'),
1520 1519
                                     'at_modification',
1521 1520
                                     $session->get('user-login'),
1522
-                                    'at_field : ' . $dataTmpCat['title'] . ' => ' . $oldVal
1521
+                                    'at_field : '.$dataTmpCat['title'].' => '.$oldVal
1523 1522
                                 );
1524 1523
                             }
1525 1524
                         }
@@ -1573,7 +1572,7 @@  discard block
 block discarded – undo
1573 1572
             ) {
1574 1573
                 DB::queryFirstRow(
1575 1574
                     'SELECT *
1576
-                    FROM ' . prefixTable('templates') . '
1575
+                    FROM ' . prefixTable('templates').'
1577 1576
                     WHERE item_id = %i',
1578 1577
                     $inputData['itemId']
1579 1578
                 );
@@ -1616,7 +1615,7 @@  discard block
 block discarded – undo
1616 1615
                 // check if elem exists in Table. If not add it or update it.
1617 1616
                 DB::query(
1618 1617
                     'SELECT *
1619
-                    FROM ' . prefixTable('automatic_del') . '
1618
+                    FROM ' . prefixTable('automatic_del').'
1620 1619
                     WHERE item_id = %i',
1621 1620
                     $inputData['itemId']
1622 1621
                 );
@@ -1643,7 +1642,7 @@  discard block
 block discarded – undo
1643 1642
                         // Store updates performed
1644 1643
                         array_push(
1645 1644
                             $arrayOfChanges,
1646
-                            $lang->get('automatic_deletion_engaged') . ': ' . $lang->get('enabled')
1645
+                            $lang->get('automatic_deletion_engaged').': '.$lang->get('enabled')
1647 1646
                         );
1648 1647
 
1649 1648
                         // update LOG
@@ -1686,7 +1685,7 @@  discard block
 block discarded – undo
1686 1685
                         // Store updates performed
1687 1686
                         array_push(
1688 1687
                             $arrayOfChanges,
1689
-                            $lang->get('automatic_deletion_engaged') . ': ' . $lang->get('disabled')
1688
+                            $lang->get('automatic_deletion_engaged').': '.$lang->get('disabled')
1690 1689
                         );
1691 1690
 
1692 1691
                         // update LOG
@@ -1714,7 +1713,7 @@  discard block
 block discarded – undo
1714 1713
                     if (empty($userId) === false) {
1715 1714
                         $dataTmp = DB::queryFirstRow(
1716 1715
                             'SELECT id, name, lastname
1717
-                            FROM ' . prefixTable('users') . '
1716
+                            FROM ' . prefixTable('users').'
1718 1717
                             WHERE id= %i',
1719 1718
                             $userId
1720 1719
                         );
@@ -1722,7 +1721,7 @@  discard block
 block discarded – undo
1722 1721
                         // Add to array
1723 1722
                         array_push(
1724 1723
                             $arrayOfUsersRestriction,
1725
-                            $dataTmp['name'] . ' ' . $dataTmp['lastname']
1724
+                            $dataTmp['name'].' '.$dataTmp['lastname']
1726 1725
                         );
1727 1726
                         array_push(
1728 1727
                             $arrayOfUsersIdRestriction,
@@ -1753,8 +1752,8 @@  discard block
 block discarded – undo
1753 1752
                 // get values before deleting them
1754 1753
                 $rows = DB::query(
1755 1754
                     'SELECT t.title, t.id AS id
1756
-                    FROM ' . prefixTable('roles_title') . ' as t
1757
-                    INNER JOIN ' . prefixTable('restriction_to_roles') . ' as r ON (t.id=r.role_id)
1755
+                    FROM ' . prefixTable('roles_title').' as t
1756
+                    INNER JOIN ' . prefixTable('restriction_to_roles').' as r ON (t.id=r.role_id)
1758 1757
                     WHERE r.item_id = %i
1759 1758
                     ORDER BY t.title ASC',
1760 1759
                     $inputData['itemId']
@@ -1788,7 +1787,7 @@  discard block
 block discarded – undo
1788 1787
                         );
1789 1788
                         $dataTmp = DB::queryFirstRow(
1790 1789
                             'SELECT title
1791
-                            FROM ' . prefixTable('roles_title') . '
1790
+                            FROM ' . prefixTable('roles_title').'
1792 1791
                             WHERE id = %i',
1793 1792
                             $role
1794 1793
                         );
@@ -1816,7 +1815,7 @@  discard block
 block discarded – undo
1816 1815
             // Get current status
1817 1816
             $otpStatus = DB::queryFirstRow(
1818 1817
                 'SELECT enabled as otp_is_enabled, phone_number, secret
1819
-                FROM ' . prefixTable('items_otp') . '
1818
+                FROM ' . prefixTable('items_otp').'
1820 1819
                 WHERE item_id = %i',
1821 1820
                 $inputData['itemId']
1822 1821
             );
@@ -1830,7 +1829,7 @@  discard block
 block discarded – undo
1830 1829
                     'decrypt'
1831 1830
                 )['string'];
1832 1831
             } else {
1833
-                $currentsecret='';
1832
+                $currentsecret = '';
1834 1833
             }
1835 1834
 
1836 1835
             // If OTP secret provided then encrypt it
@@ -1880,7 +1879,7 @@  discard block
 block discarded – undo
1880 1879
                         $session->get('user-id'),
1881 1880
                         'at_modification',
1882 1881
                         $session->get('user-login'),
1883
-                        'at_otp_status:' . ((int) $post_otp_is_enabled === 0 ? 'disabled' : 'enabled')
1882
+                        'at_otp_status:'.((int) $post_otp_is_enabled === 0 ? 'disabled' : 'enabled')
1884 1883
                     );
1885 1884
                 }
1886 1885
                 if ($otpStatus['phone_number'] !== $post_otp_phone_number) {
@@ -1891,7 +1890,7 @@  discard block
 block discarded – undo
1891 1890
                         $session->get('user-id'),
1892 1891
                         'at_modification',
1893 1892
                         $session->get('user-login'),
1894
-                        'at_phone_number:' . $otpStatus['phone_number'] . ' => ' . $post_otp_phone_number
1893
+                        'at_phone_number:'.$otpStatus['phone_number'].' => '.$post_otp_phone_number
1895 1894
                     );
1896 1895
                 }
1897 1896
                 if ($currentsecret !== $post_otp_secret) {
@@ -1940,8 +1939,8 @@  discard block
 block discarded – undo
1940 1939
                     $session->get('user-id'),
1941 1940
                     'at_modification',
1942 1941
                     $session->get('user-login'),
1943
-                    'at_restriction : ' . (count($diffUsersRestiction) > 0 ?
1944
-                        implode(', ', $arrayOfUsersRestriction) . (count($diffRolesRestiction) > 0 ? ', ' : '') : '') . (count($diffRolesRestiction) > 0 ? implode(', ', $arrayOfRestrictionRoles) : '')
1942
+                    'at_restriction : '.(count($diffUsersRestiction) > 0 ?
1943
+                        implode(', ', $arrayOfUsersRestriction).(count($diffRolesRestiction) > 0 ? ', ' : '') : '').(count($diffRolesRestiction) > 0 ? implode(', ', $arrayOfRestrictionRoles) : '')
1945 1944
                 );
1946 1945
             }
1947 1946
 
@@ -1961,7 +1960,7 @@  discard block
 block discarded – undo
1961 1960
                     $session->get('user-id'),
1962 1961
                     'at_modification',
1963 1962
                     $session->get('user-login'),
1964
-                    'at_label : ' . $data['label'] . ' => ' . $inputData['label']
1963
+                    'at_label : '.$data['label'].' => '.$inputData['label']
1965 1964
                 );
1966 1965
             }
1967 1966
             // LOGIN
@@ -1980,7 +1979,7 @@  discard block
 block discarded – undo
1980 1979
                     $session->get('user-id'),
1981 1980
                     'at_modification',
1982 1981
                     $session->get('user-login'),
1983
-                    'at_login : ' . $data['login'] . ' => ' . $post_login
1982
+                    'at_login : '.$data['login'].' => '.$post_login
1984 1983
                 );
1985 1984
             }
1986 1985
             // EMAIL
@@ -1999,7 +1998,7 @@  discard block
 block discarded – undo
1999 1998
                     $session->get('user-id'),
2000 1999
                     'at_modification',
2001 2000
                     $session->get('user-login'),
2002
-                    'at_email : ' . $data['email'] . ' => ' . $post_email
2001
+                    'at_email : '.$data['email'].' => '.$post_email
2003 2002
                 );
2004 2003
             }
2005 2004
             // URL
@@ -2018,7 +2017,7 @@  discard block
 block discarded – undo
2018 2017
                     $session->get('user-id'),
2019 2018
                     'at_modification',
2020 2019
                     $session->get('user-login'),
2021
-                    'at_url : ' . $data['url'] . ' => ' . $post_url
2020
+                    'at_url : '.$data['url'].' => '.$post_url
2022 2021
                 );
2023 2022
             }
2024 2023
             // DESCRIPTION
@@ -2044,7 +2043,7 @@  discard block
 block discarded – undo
2044 2043
             // FOLDER
2045 2044
             if ((int) $data['id_tree'] !== (int) $inputData['folderId']) {
2046 2045
                 // Get name of folders
2047
-                $dataTmp = DB::query('SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id IN %li', array($data['id_tree'], $inputData['folderId']));
2046
+                $dataTmp = DB::query('SELECT title FROM '.prefixTable('nested_tree').' WHERE id IN %li', array($data['id_tree'], $inputData['folderId']));
2048 2047
 
2049 2048
                 // Store updates performed
2050 2049
                 array_push(
@@ -2060,7 +2059,7 @@  discard block
 block discarded – undo
2060 2059
                     $session->get('user-id'),
2061 2060
                     'at_modification',
2062 2061
                     $session->get('user-login'),
2063
-                    'at_category : ' . $dataTmp[0]['title'] . ' => ' . $dataTmp[1]['title']
2062
+                    'at_category : '.$dataTmp[0]['title'].' => '.$dataTmp[1]['title']
2064 2063
                 );
2065 2064
             }
2066 2065
             // ANYONE_CAN_MODIFY
@@ -2068,7 +2067,7 @@  discard block
 block discarded – undo
2068 2067
                 // Store updates performed
2069 2068
                 array_push(
2070 2069
                     $arrayOfChanges,
2071
-                    $lang->get('at_anyoneconmodify') . ': ' . ((int) $post_anyone_can_modify === 0 ? $lang->get('disabled') : $lang->get('enabled'))
2070
+                    $lang->get('at_anyoneconmodify').': '.((int) $post_anyone_can_modify === 0 ? $lang->get('disabled') : $lang->get('enabled'))
2072 2071
                 );
2073 2072
 
2074 2073
                 // Log
@@ -2079,15 +2078,15 @@  discard block
 block discarded – undo
2079 2078
                     $session->get('user-id'),
2080 2079
                     'at_modification',
2081 2080
                     $session->get('user-login'),
2082
-                    'at_anyoneconmodify : ' . ((int) $post_anyone_can_modify === 0 ? 'disabled' : 'enabled')
2081
+                    'at_anyoneconmodify : '.((int) $post_anyone_can_modify === 0 ? 'disabled' : 'enabled')
2083 2082
                 );
2084 2083
             }
2085 2084
 
2086 2085
             // Reload new values
2087 2086
             $dataItem = DB::queryFirstRow(
2088 2087
                 'SELECT *
2089
-                FROM ' . prefixTable('items') . ' as i
2090
-                INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id)
2088
+                FROM ' . prefixTable('items').' as i
2089
+                INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id)
2091 2090
                 WHERE i.id = %i AND l.action = %s',
2092 2091
                 $inputData['itemId'],
2093 2092
                 'at_creation'
@@ -2096,8 +2095,8 @@  discard block
 block discarded – undo
2096 2095
             $history = '';
2097 2096
             $rows = DB::query(
2098 2097
                 'SELECT l.date as date, l.action as action, l.raison as raison, u.login as login
2099
-                FROM ' . prefixTable('log_items') . ' as l
2100
-                LEFT JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id)
2098
+                FROM ' . prefixTable('log_items').' as l
2099
+                LEFT JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id)
2101 2100
                 WHERE l.action <> %s AND id_item=%s',
2102 2101
                 'at_shown',
2103 2102
                 $inputData['itemId']
@@ -2106,14 +2105,14 @@  discard block
 block discarded – undo
2106 2105
                 if ($record['raison'] === NULL) continue;
2107 2106
                 $reason = explode(':', $record['raison']);
2108 2107
                 if (count($reason) > 0) {
2109
-                    $sentence = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']) . ' - '
2110
-                        . $record['login'] . ' - ' . $lang->get($record['action']) . ' - '
2111
-                        . (empty($record['raison']) === false ? (count($reason) > 1 ? $lang->get(trim($reason[0])) . ' : ' . $reason[1]
2108
+                    $sentence = date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']).' - '
2109
+                        . $record['login'].' - '.$lang->get($record['action']).' - '
2110
+                        . (empty($record['raison']) === false ? (count($reason) > 1 ? $lang->get(trim($reason[0])).' : '.$reason[1]
2112 2111
                             : $lang->get(trim($reason[0]))) : '');
2113 2112
                     if (empty($history)) {
2114 2113
                         $history = $sentence;
2115 2114
                     } else {
2116
-                        $history .= '<br />' . $sentence;
2115
+                        $history .= '<br />'.$sentence;
2117 2116
                     }
2118 2117
                 }
2119 2118
             }
@@ -2251,7 +2250,7 @@  discard block
 block discarded – undo
2251 2250
         ) {
2252 2251
             // load the original record into an array
2253 2252
             $originalRecord = DB::queryFirstRow(
2254
-                'SELECT * FROM ' . prefixTable('items') . '
2253
+                'SELECT * FROM '.prefixTable('items').'
2255 2254
                 WHERE id = %i',
2256 2255
                 $inputData['itemId']
2257 2256
             );
@@ -2270,7 +2269,7 @@  discard block
 block discarded – undo
2270 2269
 
2271 2270
             // Load the destination folder record into an array
2272 2271
             $dataDestination = DB::queryFirstRow(
2273
-                'SELECT personal_folder FROM ' . prefixTable('nested_tree') . '
2272
+                'SELECT personal_folder FROM '.prefixTable('nested_tree').'
2274 2273
                 WHERE id = %i',
2275 2274
                 $post_dest_id
2276 2275
             );
@@ -2278,7 +2277,7 @@  discard block
 block discarded – undo
2278 2277
             // Get the ITEM object key for the user
2279 2278
             $userKey = DB::queryFirstRow(
2280 2279
                 'SELECT share_key
2281
-                FROM ' . prefixTable('sharekeys_items') . '
2280
+                FROM ' . prefixTable('sharekeys_items').'
2282 2281
                 WHERE user_id = %i AND object_id = %i',
2283 2282
                 $session->get('user-id'),
2284 2283
                 $inputData['itemId']
@@ -2355,8 +2354,8 @@  discard block
 block discarded – undo
2355 2354
             // Manage Custom Fields
2356 2355
             $rows = DB::query(
2357 2356
                 'SELECT ci.id AS id, ci.data AS data, ci.field_id AS field_id, c.encrypted_data AS encrypted_data
2358
-                FROM ' . prefixTable('categories_items') . ' AS ci
2359
-                INNER JOIN ' . prefixTable('categories') . ' AS c ON (c.id = ci.field_id)
2357
+                FROM ' . prefixTable('categories_items').' AS ci
2358
+                INNER JOIN ' . prefixTable('categories').' AS c ON (c.id = ci.field_id)
2360 2359
                 WHERE ci.item_id = %i',
2361 2360
                 $inputData['itemId']
2362 2361
             );
@@ -2368,7 +2367,7 @@  discard block
 block discarded – undo
2368 2367
                     // Get user key
2369 2368
                     $userKey = DB::queryFirstRow(
2370 2369
                         'SELECT share_key
2371
-                        FROM ' . prefixTable('sharekeys_fields') . '
2370
+                        FROM ' . prefixTable('sharekeys_fields').'
2372 2371
                         WHERE user_id = %i AND object_id = %i',
2373 2372
                         $session->get('user-id'),
2374 2373
                         $field['id']
@@ -2435,15 +2434,15 @@  discard block
 block discarded – undo
2435 2434
             $rows = DB::query(
2436 2435
                 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, f.extension AS extension,
2437 2436
                 f.size AS size, f.type AS type, s.share_key AS share_key
2438
-                FROM ' . prefixTable('files') . ' AS f
2439
-                INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id)
2437
+                FROM ' . prefixTable('files').' AS f
2438
+                INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id)
2440 2439
                 WHERE s.user_id = %i AND f.id_item = %i',
2441 2440
                 $session->get('user-id'),
2442 2441
                 $inputData['itemId']
2443 2442
             );
2444 2443
             foreach ($rows as $record) {
2445 2444
                 // Check if file still exists
2446
-                if (file_exists($SETTINGS['path_to_upload_folder'] . DIRECTORY_SEPARATOR . TP_FILE_PREFIX . base64_decode($record['file'])) === true) {
2445
+                if (file_exists($SETTINGS['path_to_upload_folder'].DIRECTORY_SEPARATOR.TP_FILE_PREFIX.base64_decode($record['file'])) === true) {
2447 2446
                     // Step1 - decrypt the file
2448 2447
                     // deepcode ignore PT: path is sanitized inside decryptFile()
2449 2448
                     $fileContent = decryptFile(
@@ -2454,8 +2453,8 @@  discard block
 block discarded – undo
2454 2453
 
2455 2454
                     // Step2 - create file
2456 2455
                     // deepcode ignore InsecureHash: md5 is used jonly for file name in order to get a hashed value in database
2457
-                    $newFileName = md5(time() . '_' . $record['id']) . '.' . $record['extension'];
2458
-                    $outstream = fopen($SETTINGS['path_to_upload_folder'] . DIRECTORY_SEPARATOR . $newFileName, 'ab');
2456
+                    $newFileName = md5(time().'_'.$record['id']).'.'.$record['extension'];
2457
+                    $outstream = fopen($SETTINGS['path_to_upload_folder'].DIRECTORY_SEPARATOR.$newFileName, 'ab');
2459 2458
                     if ($outstream === false) {
2460 2459
                         echo prepareExchangedData(
2461 2460
                             array(
@@ -2528,7 +2527,7 @@  discard block
 block discarded – undo
2528 2527
 
2529 2528
             // -------------------------
2530 2529
             // Add specific restrictions
2531
-            $rows = DB::query('SELECT * FROM ' . prefixTable('restriction_to_roles') . ' WHERE item_id = %i', $inputData['itemId']);
2530
+            $rows = DB::query('SELECT * FROM '.prefixTable('restriction_to_roles').' WHERE item_id = %i', $inputData['itemId']);
2532 2531
             foreach ($rows as $record) {
2533 2532
                 DB::insert(
2534 2533
                     prefixTable('restriction_to_roles'),
@@ -2540,7 +2539,7 @@  discard block
 block discarded – undo
2540 2539
             }
2541 2540
 
2542 2541
             // Add Tags
2543
-            $rows = DB::query('SELECT * FROM ' . prefixTable('tags') . ' WHERE item_id = %i', $inputData['itemId']);
2542
+            $rows = DB::query('SELECT * FROM '.prefixTable('tags').' WHERE item_id = %i', $inputData['itemId']);
2544 2543
             foreach ($rows as $record) {
2545 2544
                 DB::insert(
2546 2545
                     prefixTable('tags'),
@@ -2642,7 +2641,7 @@  discard block
 block discarded – undo
2642 2641
         // then we can show it
2643 2642
         $item_deleted = DB::queryFirstRow(
2644 2643
             'SELECT *
2645
-            FROM ' . prefixTable('log_items') . '
2644
+            FROM ' . prefixTable('log_items').'
2646 2645
             WHERE id_item = %i AND action = %s
2647 2646
             ORDER BY date DESC
2648 2647
             LIMIT 0, 1',
@@ -2653,7 +2652,7 @@  discard block
 block discarded – undo
2653 2652
 
2654 2653
         $item_restored = DB::queryFirstRow(
2655 2654
             'SELECT *
2656
-            FROM ' . prefixTable('log_items') . '
2655
+            FROM ' . prefixTable('log_items').'
2657 2656
             WHERE id_item = %i AND action = %s
2658 2657
             ORDER BY date DESC
2659 2658
             LIMIT 0, 1',
@@ -2677,8 +2676,8 @@  discard block
 block discarded – undo
2677 2676
         // Get all informations for this item
2678 2677
         $dataItem = DB::queryFirstRow(
2679 2678
             'SELECT *
2680
-            FROM ' . prefixTable('items') . ' as i
2681
-            INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id)
2679
+            FROM ' . prefixTable('items').' as i
2680
+            INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id)
2682 2681
             WHERE i.id = %i AND l.action = %s',
2683 2682
             $inputData['id'],
2684 2683
             'at_creation'
@@ -2687,7 +2686,7 @@  discard block
 block discarded – undo
2687 2686
         // Notification
2688 2687
         DB::queryFirstRow(
2689 2688
             'SELECT *
2690
-            FROM ' . prefixTable('notification') . '
2689
+            FROM ' . prefixTable('notification').'
2691 2690
             WHERE item_id = %i AND user_id = %i',
2692 2691
             $inputData['id'],
2693 2692
             $session->get('user-id')
@@ -2706,7 +2705,7 @@  discard block
 block discarded – undo
2706 2705
 
2707 2706
         // manage case of API user
2708 2707
         if ($dataItem['id_user'] === API_USER_ID) {
2709
-            $arrData['author'] = 'API [' . $dataItem['description'] . ']';
2708
+            $arrData['author'] = 'API ['.$dataItem['description'].']';
2710 2709
             $arrData['id_user'] = API_USER_ID;
2711 2710
             $arrData['author_email'] = '';
2712 2711
             $arrData['notification_status'] = false;
@@ -2716,7 +2715,7 @@  discard block
 block discarded – undo
2716 2715
         $tags = array();
2717 2716
         $rows = DB::query(
2718 2717
             'SELECT tag
2719
-            FROM ' . prefixTable('tags') . '
2718
+            FROM ' . prefixTable('tags').'
2720 2719
             WHERE item_id = %i',
2721 2720
             $inputData['id']
2722 2721
         );
@@ -2740,7 +2739,7 @@  discard block
 block discarded – undo
2740 2739
         // Check if user has a role that is accepted
2741 2740
         $rows_tmp = DB::query(
2742 2741
             'SELECT role_id
2743
-            FROM ' . prefixTable('restriction_to_roles') . '
2742
+            FROM ' . prefixTable('restriction_to_roles').'
2744 2743
             WHERE item_id=%i',
2745 2744
             $inputData['id']
2746 2745
         );
@@ -2754,7 +2753,7 @@  discard block
 block discarded – undo
2754 2753
         // Get the object key for the user
2755 2754
         $userKeys = DB::query(
2756 2755
             'SELECT share_key
2757
-            FROM ' . prefixTable('sharekeys_items') . '
2756
+            FROM ' . prefixTable('sharekeys_items').'
2758 2757
             WHERE user_id = %i AND object_id = %i',
2759 2758
             $session->get('user-id'),
2760 2759
             $inputData['id']
@@ -2863,8 +2862,8 @@  discard block
 block discarded – undo
2863 2862
                 // Add restriction if item is restricted to roles
2864 2863
                 $rows = DB::query(
2865 2864
                     'SELECT t.title, t.id
2866
-                    FROM ' . prefixTable('roles_title') . ' AS t
2867
-                    INNER JOIN ' . prefixTable('restriction_to_roles') . ' AS r ON (t.id=r.role_id)
2865
+                    FROM ' . prefixTable('roles_title').' AS t
2866
+                    INNER JOIN ' . prefixTable('restriction_to_roles').' AS r ON (t.id=r.role_id)
2868 2867
                     WHERE r.item_id = %i
2869 2868
                     ORDER BY t.title ASC',
2870 2869
                     $inputData['id']
@@ -2880,8 +2879,8 @@  discard block
 block discarded – undo
2880 2879
                 $tmp = array();
2881 2880
                 $rows = DB::query(
2882 2881
                     'SELECT k.label, k.id
2883
-                    FROM ' . prefixTable('kb_items') . ' as i
2884
-                    INNER JOIN ' . prefixTable('kb') . ' as k ON (i.kb_id=k.id)
2882
+                    FROM ' . prefixTable('kb_items').' as i
2883
+                    INNER JOIN ' . prefixTable('kb').' as k ON (i.kb_id=k.id)
2885 2884
                     WHERE i.item_id = %i
2886 2885
                     ORDER BY k.label ASC',
2887 2886
                     $inputData['id']
@@ -2964,7 +2963,7 @@  discard block
 block discarded – undo
2964 2963
                 $arrCatList = array();
2965 2964
                 $rows_tmp = DB::query(
2966 2965
                     'SELECT id_category
2967
-                    FROM ' . prefixTable('categories_folders') . '
2966
+                    FROM ' . prefixTable('categories_folders').'
2968 2967
                     WHERE id_folder=%i',
2969 2968
                     $inputData['folderId']
2970 2969
                 );
@@ -2979,8 +2978,8 @@  discard block
 block discarded – undo
2979 2978
                         'SELECT i.id AS id, i.field_id AS field_id, i.data AS data, i.item_id AS item_id,
2980 2979
                         i.encryption_type AS encryption_type, c.encrypted_data AS encrypted_data, c.parent_id AS parent_id,
2981 2980
                         c.type as field_type, c.masked AS field_masked, c.role_visibility AS role_visibility
2982
-                        FROM ' . prefixTable('categories_items') . ' AS i
2983
-                        INNER JOIN ' . prefixTable('categories') . ' AS c ON (i.field_id=c.id)
2981
+                        FROM ' . prefixTable('categories_items').' AS i
2982
+                        INNER JOIN ' . prefixTable('categories').' AS c ON (i.field_id=c.id)
2984 2983
                         WHERE i.item_id=%i AND c.parent_id IN %ls',
2985 2984
                         $inputData['id'],
2986 2985
                         $arrCatList
@@ -2991,7 +2990,7 @@  discard block
 block discarded – undo
2991 2990
                         //db::debugmode(true);
2992 2991
                         $userKey = DB::queryFirstRow(
2993 2992
                             'SELECT share_key
2994
-                            FROM ' . prefixTable('sharekeys_fields') . '
2993
+                            FROM ' . prefixTable('sharekeys_fields').'
2995 2994
                             WHERE user_id = %i AND object_id = %i',
2996 2995
                             $session->get('user-id'),
2997 2996
                             $row['id']
@@ -3009,7 +3008,7 @@  discard block
 block discarded – undo
3009 3008
                         } else if (DB::count() === 0 && (int) $row['encrypted_data'] === 0) {
3010 3009
                             // Data is not encrypted in DB
3011 3010
                             $fieldText = [
3012
-                                'string' => $row['data'],//#3945 - isBase64($row['data']) === true ? base64_decode($row['data']) : 
3011
+                                'string' => $row['data'], //#3945 - isBase64($row['data']) === true ? base64_decode($row['data']) : 
3013 3012
                                 'encrypted' => false,
3014 3013
                                 'error' => false,
3015 3014
                             ];
@@ -3054,7 +3053,7 @@  discard block
 block discarded – undo
3054 3053
             if (isset($SETTINGS['item_creation_templates']) && (int) $SETTINGS['item_creation_templates'] === 1) {
3055 3054
                 $rows_tmp = DB::queryFirstRow(
3056 3055
                     'SELECT category_id
3057
-                    FROM ' . prefixTable('templates') . '
3056
+                    FROM ' . prefixTable('templates').'
3058 3057
                     WHERE item_id = %i',
3059 3058
                     $inputData['id']
3060 3059
                 );
@@ -3071,7 +3070,7 @@  discard block
 block discarded – undo
3071 3070
             // Evaluate if item is ready for all users
3072 3071
             $rows_tmp = DB::queryFirstRow(
3073 3072
                 'SELECT finished_at
3074
-                FROM ' . prefixTable('background_tasks') . '
3073
+                FROM ' . prefixTable('background_tasks').'
3075 3074
                 WHERE item_id = %i',
3076 3075
                 $inputData['id']
3077 3076
             );
@@ -3088,7 +3087,7 @@  discard block
 block discarded – undo
3088 3087
                 // Is the Item to be deleted?
3089 3088
                 $dataDelete = DB::queryFirstRow(
3090 3089
                     'SELECT * 
3091
-                    FROM ' . prefixTable('automatic_del') . '
3090
+                    FROM ' . prefixTable('automatic_del').'
3092 3091
                     WHERE item_id = %i',
3093 3092
                     $inputData['id']
3094 3093
                 );
@@ -3169,14 +3168,14 @@  discard block
 block discarded – undo
3169 3168
                     if (empty($userRest) === false) {
3170 3169
                         $dataTmp = DB::queryFirstRow(
3171 3170
                             'SELECT login
3172
-                            FROM ' . prefixTable('users') . '
3171
+                            FROM ' . prefixTable('users').'
3173 3172
                             WHERE id= %i',
3174 3173
                             $userRest
3175 3174
                         );
3176 3175
                         if (empty($listOfRestricted)) {
3177 3176
                             $listOfRestricted = $dataTmp['login'];
3178 3177
                         } else {
3179
-                            $listOfRestricted .= ';' . $dataTmp['login'];
3178
+                            $listOfRestricted .= ';'.$dataTmp['login'];
3180 3179
                         }
3181 3180
                     }
3182 3181
                 }
@@ -3250,9 +3249,9 @@  discard block
 block discarded – undo
3250 3249
         // Load item data
3251 3250
         $dataItem = DB::queryFirstRow(
3252 3251
             'SELECT i.*, n.title AS folder_title, o.enabled AS otp_for_item_enabled, o.phone_number AS otp_phone_number, o.secret AS otp_secret
3253
-            FROM ' . prefixTable('items') . ' AS i
3254
-            INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id)
3255
-            LEFT JOIN ' . prefixTable('items_otp') . ' AS o ON (o.item_id = i.id)
3252
+            FROM ' . prefixTable('items').' AS i
3253
+            INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id)
3254
+            LEFT JOIN ' . prefixTable('items_otp').' AS o ON (o.item_id = i.id)
3256 3255
             WHERE i.id = %i',
3257 3256
             $inputData['id']
3258 3257
         );
@@ -3274,7 +3273,7 @@  discard block
 block discarded – undo
3274 3273
         // Check if user has a role that is accepted
3275 3274
         $rows_tmp = DB::query(
3276 3275
             'SELECT role_id
3277
-            FROM ' . prefixTable('restriction_to_roles') . '
3276
+            FROM ' . prefixTable('restriction_to_roles').'
3278 3277
             WHERE item_id=%i',
3279 3278
             $inputData['id']
3280 3279
         );
@@ -3306,12 +3305,12 @@  discard block
 block discarded – undo
3306 3305
             // launch query
3307 3306
             $rows = DB::query(
3308 3307
                 'SELECT id, name, file, extension, size
3309
-                FROM ' . prefixTable('files') . '
3308
+                FROM ' . prefixTable('files').'
3310 3309
                 WHERE id_item = %i AND confirmed = 1',
3311 3310
                 $inputData['id']
3312 3311
             );
3313 3312
             foreach ($rows as $record) {
3314
-                $filename = basename($record['name'], '.' . $record['extension']);
3313
+                $filename = basename($record['name'], '.'.$record['extension']);
3315 3314
                 $filename = isBase64($filename) === true ? base64_decode($filename) : $filename;
3316 3315
 
3317 3316
                 array_push(
@@ -3324,7 +3323,7 @@  discard block
 block discarded – undo
3324 3323
                         'is_image' => in_array(strtolower($record['extension']), TP_IMAGE_FILE_EXT) === true ? 1 : 0,
3325 3324
                         'id' => $record['id'],
3326 3325
                         'key' => $session->get('user-key_tmp'),
3327
-                        'internalFilename' => basename($record['name'], '.' . $record['extension']),
3326
+                        'internalFilename' => basename($record['name'], '.'.$record['extension']),
3328 3327
                     )
3329 3328
                 );
3330 3329
             }
@@ -3362,7 +3361,7 @@  discard block
 block discarded – undo
3362 3361
                     array(
3363 3362
                         'latest_items' => implode(';', $session->get('user-latest_items')),
3364 3363
                     ),
3365
-                    'id=' . $session->get('user-id')
3364
+                    'id='.$session->get('user-id')
3366 3365
                 );
3367 3366
             }
3368 3367
 
@@ -3371,8 +3370,8 @@  discard block
 block discarded – undo
3371 3370
             $listOptionsForRoles = array();
3372 3371
             $rows = DB::query(
3373 3372
                 'SELECT r.role_id AS role_id, t.title AS title
3374
-                FROM ' . prefixTable('roles_values') . ' AS r
3375
-                INNER JOIN ' . prefixTable('roles_title') . ' AS t ON (r.role_id = t.id)
3373
+                FROM ' . prefixTable('roles_values').' AS r
3374
+                INNER JOIN ' . prefixTable('roles_title').' AS t ON (r.role_id = t.id)
3376 3375
                 WHERE r.folder_id = %i',
3377 3376
                 $dataItem['id_tree']
3378 3377
             );
@@ -3386,9 +3385,9 @@  discard block
 block discarded – undo
3386 3385
                 );
3387 3386
                 $rows2 = DB::query(
3388 3387
                     'SELECT id, login, fonction_id, email, name, lastname
3389
-                    FROM ' . prefixTable('users') . '
3388
+                    FROM ' . prefixTable('users').'
3390 3389
                     WHERE fonction_id LIKE %s',
3391
-                    '%' . $record['role_id'] . '%'
3390
+                    '%'.$record['role_id'].'%'
3392 3391
                 );
3393 3392
                 foreach ($rows2 as $record2) {
3394 3393
                     foreach (explode(';', $record2['fonction_id']) as $role) {
@@ -3401,7 +3400,7 @@  discard block
 block discarded – undo
3401 3400
                                 array(
3402 3401
                                     'id' => (int) $record2['id'],
3403 3402
                                     'login' => $record2['login'],
3404
-                                    'name' => $record2['name'] . ' ' . $record2['lastname'],
3403
+                                    'name' => $record2['name'].' '.$record2['lastname'],
3405 3404
                                     'email' => $record2['email'],
3406 3405
                                 )
3407 3406
                             );
@@ -3420,16 +3419,16 @@  discard block
 block discarded – undo
3420 3419
                 $path = '';
3421 3420
                 foreach ($arbo as $elem) {
3422 3421
                     if (empty($path) === true) {
3423
-                        $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES) . ' ';
3422
+                        $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES).' ';
3424 3423
                     } else {
3425
-                        $path .= '&#8594; ' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES);
3424
+                        $path .= '&#8594; '.htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES);
3426 3425
                     }
3427 3426
                 }
3428 3427
                 // Build text to show user
3429 3428
                 if (empty($path) === true) {
3430 3429
                     $path = addslashes($dataItem['label']);
3431 3430
                 } else {
3432
-                    $path = addslashes($dataItem['label']) . ' (' . $path . ')';
3431
+                    $path = addslashes($dataItem['label']).' ('.$path.')';
3433 3432
                 }
3434 3433
 
3435 3434
                 // Add Admins to notification list if expected
@@ -3452,7 +3451,7 @@  discard block
 block discarded – undo
3452 3451
                         array(
3453 3452
                             addslashes($session->get('user-login')),
3454 3453
                             $path,
3455
-                            $SETTINGS['cpassman_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $dataItem['id'],
3454
+                            $SETTINGS['cpassman_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$dataItem['id'],
3456 3455
                         ),
3457 3456
                         $lang->get('email_on_open_notification_mail')
3458 3457
                     ),
@@ -3462,7 +3461,7 @@  discard block
 block discarded – undo
3462 3461
             }
3463 3462
 
3464 3463
             // has this item a change proposal
3465
-            DB::query('SELECT * FROM ' . prefixTable('items_change') . ' WHERE item_id = %i', $inputData['id']);
3464
+            DB::query('SELECT * FROM '.prefixTable('items_change').' WHERE item_id = %i', $inputData['id']);
3466 3465
             $returnArray['has_change_proposal'] = DB::count();
3467 3466
 
3468 3467
             // Setting
@@ -3473,7 +3472,7 @@  discard block
 block discarded – undo
3473 3472
             if (isset($SETTINGS['otv_is_enabled']) === true && (int) $SETTINGS['otv_is_enabled'] === 1) {
3474 3473
                 DB::query(
3475 3474
                     'SELECT *
3476
-                    FROM ' . prefixTable('otv') . '
3475
+                    FROM ' . prefixTable('otv').'
3477 3476
                     WHERE item_id = %i
3478 3477
                     AND time_limit > %i',
3479 3478
                     $inputData['id'],
@@ -3572,7 +3571,7 @@  discard block
 block discarded – undo
3572 3571
         // Load item data
3573 3572
         $data = DB::queryFirstRow(
3574 3573
             'SELECT id_tree, id, label
3575
-            FROM ' . prefixTable('items') . '
3574
+            FROM ' . prefixTable('items').'
3576 3575
             WHERE id = %i OR item_key = %s',
3577 3576
             $inputData['itemId'],
3578 3577
             $inputData['itemKey']
@@ -3663,7 +3662,7 @@  discard block
 block discarded – undo
3663 3662
         // Load item data
3664 3663
         $dataItem = DB::queryFirstRow(
3665 3664
             'SELECT secret, enabled
3666
-            FROM ' . prefixTable('items_otp') . '
3665
+            FROM ' . prefixTable('items_otp').'
3667 3666
             WHERE item_id = %i',
3668 3667
             $inputData['id']
3669 3668
         );
@@ -3745,13 +3744,13 @@  discard block
 block discarded – undo
3745 3744
 
3746 3745
         // Check if user is allowed to access this folder
3747 3746
         if (!in_array($inputData['folderId'], $session->get('user-accessible_folders'))) {
3748
-            echo '[{"error" : "' . $lang->get('error_not_allowed_to') . '"}]';
3747
+            echo '[{"error" : "'.$lang->get('error_not_allowed_to').'"}]';
3749 3748
             break;
3750 3749
         }
3751 3750
 
3752 3751
         // Check if title doesn't contains html codes
3753 3752
         if (preg_match_all('|<[^>]+>(.*)</[^>]+>|U', $title, $out)) {
3754
-            echo '[ { "error" : "' . $lang->get('error_html_codes') . '" } ]';
3753
+            echo '[ { "error" : "'.$lang->get('error_html_codes').'" } ]';
3755 3754
             break;
3756 3755
         }
3757 3756
         // check that title is not numeric
@@ -3762,9 +3761,9 @@  discard block
 block discarded – undo
3762 3761
 
3763 3762
         // Check if duplicate folders name are allowed
3764 3763
         if (isset($SETTINGS['duplicate_folder']) && $SETTINGS['duplicate_folder'] === '0') {
3765
-            $data = DB::queryFirstRow('SELECT id, title FROM ' . prefixTable('nested_tree') . ' WHERE title = %s', $title);
3764
+            $data = DB::queryFirstRow('SELECT id, title FROM '.prefixTable('nested_tree').' WHERE title = %s', $title);
3766 3765
             if (empty($data['id']) === false && $dataReceived['folder'] !== $data['id']) {
3767
-                echo '[ { "error" : "' . $lang->get('error_group_exist') . '" } ]';
3766
+                echo '[ { "error" : "'.$lang->get('error_group_exist').'" } ]';
3768 3767
                 break;
3769 3768
             }
3770 3769
         }
@@ -3772,7 +3771,7 @@  discard block
 block discarded – undo
3772 3771
         // query on folder
3773 3772
         $data = DB::queryFirstRow(
3774 3773
             'SELECT parent_id, personal_folder
3775
-            FROM ' . prefixTable('nested_tree') . '
3774
+            FROM ' . prefixTable('nested_tree').'
3776 3775
             WHERE id = %i',
3777 3776
             $inputData['folderId']
3778 3777
         );
@@ -3782,20 +3781,20 @@  discard block
 block discarded – undo
3782 3781
         if ($session->get('user-admin') !== 1 && $session->get('user-manager') !== 1 && $data['personal_folder'] === '0') {
3783 3782
             $data = DB::queryFirstRow(
3784 3783
                 'SELECT valeur
3785
-                FROM ' . prefixTable('misc') . '
3784
+                FROM ' . prefixTable('misc').'
3786 3785
                 WHERE intitule = %i AND type = %s',
3787 3786
                 $data['parent_id'],
3788 3787
                 'complex'
3789 3788
             );
3790 3789
             if (intval($dataReceived['complexity']) < intval($data['valeur'])) {
3791
-                echo '[ { "error" : "' . $lang->get('error_folder_complexity_lower_than_top_folder') . ' [<b>' . TP_PW_COMPLEXITY[$data['valeur']][1] . '</b>]"} ]';
3790
+                echo '[ { "error" : "'.$lang->get('error_folder_complexity_lower_than_top_folder').' [<b>'.TP_PW_COMPLEXITY[$data['valeur']][1].'</b>]"} ]';
3792 3791
                 break;
3793 3792
             }
3794 3793
         }
3795 3794
 
3796 3795
         // update Folders table
3797 3796
         $tmp = DB::queryFirstRow(
3798
-            'SELECT title, parent_id, personal_folder FROM ' . prefixTable('nested_tree') . ' WHERE id = %i',
3797
+            'SELECT title, parent_id, personal_folder FROM '.prefixTable('nested_tree').' WHERE id = %i',
3799 3798
             $dataReceived['folder']
3800 3799
         );
3801 3800
         if ($tmp['parent_id'] !== 0 || $tmp['title'] !== $session->get('user-id') || $tmp['personal_folder'] !== 1) {
@@ -3909,7 +3908,7 @@  discard block
 block discarded – undo
3909 3908
             $uniqueLoadData['path'] = $arr_arbo;
3910 3909
 
3911 3910
             // store last folder accessed in cookie
3912
-            $arr_cookie_options = array (
3911
+            $arr_cookie_options = array(
3913 3912
                 'expires' => time() + TP_ONE_DAY_SECONDS * 5,
3914 3913
                 'path' => '/', 
3915 3914
                 'secure' => true,
@@ -3924,7 +3923,7 @@  discard block
 block discarded – undo
3924 3923
             foreach ($session->get('user-roles_array') as $role) {
3925 3924
                 $roleQ = DB::queryFirstRow(
3926 3925
                     'SELECT allow_pw_change
3927
-                    FROM ' . prefixTable('roles_title') . '
3926
+                    FROM ' . prefixTable('roles_title').'
3928 3927
                     WHERE id = %i',
3929 3928
                     $role
3930 3929
                 );
@@ -3955,11 +3954,11 @@  discard block
 block discarded – undo
3955 3954
                 
3956 3955
                 foreach ($session->get('user-roles_array') as $role) {
3957 3956
                     $access = DB::queryFirstRow(
3958
-                        'SELECT type FROM ' . prefixTable('roles_values') . ' WHERE role_id = %i AND folder_id = %i',
3957
+                        'SELECT type FROM '.prefixTable('roles_values').' WHERE role_id = %i AND folder_id = %i',
3959 3958
                         $role,
3960 3959
                         $inputData['id']
3961 3960
                     );
3962
-                    if (DB::count()>0) {
3961
+                    if (DB::count() > 0) {
3963 3962
                         if ($access['type'] === 'R') {
3964 3963
                             array_push($arrTmp, 10);
3965 3964
                         } elseif ($access['type'] === 'W') {
@@ -4024,7 +4023,7 @@  discard block
 block discarded – undo
4024 4023
             } else {
4025 4024
                 DB::query(
4026 4025
                     'SELECT *
4027
-                    FROM ' . prefixTable('items') . '
4026
+                    FROM ' . prefixTable('items').'
4028 4027
                     WHERE inactif = %i',
4029 4028
                     0
4030 4029
                 );
@@ -4034,7 +4033,7 @@  discard block
 block discarded – undo
4034 4033
 
4035 4034
             // Get folder complexity
4036 4035
             $folderComplexity = DB::queryFirstRow(
4037
-                'SELECT valeur FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %i',
4036
+                'SELECT valeur FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %i',
4038 4037
                 'complex',
4039 4038
                 $inputData['id']
4040 4039
             );
@@ -4046,7 +4045,7 @@  discard block
 block discarded – undo
4046 4045
             if (isset($SETTINGS['item_extra_fields']) && (int) $SETTINGS['item_extra_fields'] === 1) {
4047 4046
                 $folderRow = DB::query(
4048 4047
                     'SELECT id_category
4049
-                    FROM ' . prefixTable('categories_folders') . '
4048
+                    FROM ' . prefixTable('categories_folders').'
4050 4049
                     WHERE id_folder = %i',
4051 4050
                     $inputData['id']
4052 4051
                 );
@@ -4161,15 +4160,15 @@  discard block
 block discarded – undo
4161 4160
             // List all ITEMS
4162 4161
             if ($folderIsPf === false) {
4163 4162
                 $where->add('i.inactif=%i', 0);
4164
-                $sql_e='(SELECT date FROM ' . prefixTable('log_items') 
4163
+                $sql_e = '(SELECT date FROM '.prefixTable('log_items') 
4165 4164
                     . " WHERE action = 'at_creation' AND id_item=i.id " 
4166
-                    . 'union all SELECT date FROM '. prefixTable('log_items') 
4165
+                    . 'union all SELECT date FROM '.prefixTable('log_items') 
4167 4166
                     . " WHERE action = 'at_modification' AND raison = 'at_pw'
4168 4167
                     AND id_item=i.id ORDER BY date DESC LIMIT 1)";
4169 4168
                 $where->add('l.date=%l', $sql_e);
4170 4169
 
4171
-                $query_limit = ' LIMIT ' .
4172
-                    $start . ',' .
4170
+                $query_limit = ' LIMIT '.
4171
+                    $start.','.
4173 4172
                     $post_nb_items_to_display_once;
4174 4173
                 //db::debugmode(true);
4175 4174
                 $rows = DB::query(
@@ -4181,9 +4180,9 @@  discard block
 block discarded – undo
4181 4180
                     l.id_user AS log_user,
4182 4181
                     i.url AS link,
4183 4182
                     i.email AS email
4184
-                    FROM ' . prefixTable('items') . ' AS i
4185
-                    INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id)
4186
-                    INNER JOIN ' . prefixTable('log_items') . ' AS l ON (i.id = l.id_item)
4183
+                    FROM ' . prefixTable('items').' AS i
4184
+                    INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id)
4185
+                    INNER JOIN ' . prefixTable('log_items').' AS l ON (i.id = l.id_item)
4187 4186
                     WHERE %l
4188 4187
                     GROUP BY i.id, l.date, l.id_user, l.action
4189 4188
                     ORDER BY i.label ASC, l.date DESC' . $query_limit,
@@ -4203,9 +4202,9 @@  discard block
 block discarded – undo
4203 4202
                     l.id_user AS log_user,
4204 4203
                     i.url AS link,
4205 4204
                     i.email AS email
4206
-                    FROM ' . prefixTable('items') . ' AS i
4207
-                    INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id)
4208
-                    INNER JOIN ' . prefixTable('log_items') . ' AS l ON (i.id = l.id_item)
4205
+                    FROM ' . prefixTable('items').' AS i
4206
+                    INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id)
4207
+                    INNER JOIN ' . prefixTable('log_items').' AS l ON (i.id = l.id_item)
4209 4208
                     WHERE %l
4210 4209
                     GROUP BY i.id, l.date, l.id_user, l.action
4211 4210
                     ORDER BY i.label ASC, l.date DESC',
@@ -4236,7 +4235,7 @@  discard block
 block discarded – undo
4236 4235
                     $item_is_restricted_to_role = false;
4237 4236
                     DB::queryFirstRow(
4238 4237
                         'SELECT role_id
4239
-                        FROM ' . prefixTable('restriction_to_roles') . '
4238
+                        FROM ' . prefixTable('restriction_to_roles').'
4240 4239
                         WHERE item_id = %i',
4241 4240
                         $record['id']
4242 4241
                     );
@@ -4248,7 +4247,7 @@  discard block
 block discarded – undo
4248 4247
                     $user_is_included_in_role = false;
4249 4248
                     DB::query(
4250 4249
                         'SELECT role_id
4251
-                        FROM ' . prefixTable('restriction_to_roles') . '
4250
+                        FROM ' . prefixTable('restriction_to_roles').'
4252 4251
                         WHERE item_id = %i AND role_id IN %ls',
4253 4252
                         $record['id'],
4254 4253
                         $session->get('user-roles_array')
@@ -4459,9 +4458,9 @@  discard block
 block discarded – undo
4459 4458
         if ((int) $start === 0) {
4460 4459
             DB::query(
4461 4460
                 'SELECT i.id
4462
-                FROM ' . prefixTable('items') . ' as i
4463
-                INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id)
4464
-                INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item)
4461
+                FROM ' . prefixTable('items').' as i
4462
+                INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id)
4463
+                INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item)
4465 4464
                 WHERE %l
4466 4465
                 ORDER BY i.label ASC, l.date DESC',
4467 4466
                 $where
@@ -4526,8 +4525,8 @@  discard block
 block discarded – undo
4526 4525
         $dataItem = DB::queryFirstRow(
4527 4526
             'SELECT i.pw AS pw, s.share_key AS share_key, i.id AS id,
4528 4527
                     i.label AS label, i.id_tree AS id_tree
4529
-            FROM ' . prefixTable('items') . ' AS i
4530
-            INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id)
4528
+            FROM ' . prefixTable('items').' AS i
4529
+            INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id)
4531 4530
             WHERE user_id = %i AND (i.item_key = %s OR i.id = %i)',
4532 4531
             $session->get('user-id'),
4533 4532
             $inputData['itemKey'] ?? '',
@@ -4639,7 +4638,7 @@  discard block
 block discarded – undo
4639 4638
         // do query on this folder
4640 4639
         $data_this_folder = DB::queryFirstRow(
4641 4640
             'SELECT id, personal_folder, title
4642
-            FROM ' . prefixTable('nested_tree') . '
4641
+            FROM ' . prefixTable('nested_tree').'
4643 4642
             WHERE id = %s',
4644 4643
             $inputData['folderId']
4645 4644
         );
@@ -4679,8 +4678,8 @@  discard block
 block discarded – undo
4679 4678
         $visibilite = '';
4680 4679
         $data = DB::queryFirstRow(
4681 4680
             'SELECT m.valeur, n.personal_folder
4682
-            FROM ' . prefixTable('misc') . ' AS m
4683
-            INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (m.intitule = n.id)
4681
+            FROM ' . prefixTable('misc').' AS m
4682
+            INNER JOIN ' . prefixTable('nested_tree').' AS n ON (m.intitule = n.id)
4684 4683
             WHERE type=%s AND intitule = %s',
4685 4684
             'complex',
4686 4685
             $inputData['folderId']
@@ -4693,8 +4692,8 @@  discard block
 block discarded – undo
4693 4692
             // Prepare Item actual visibility (what Users/Roles can see it)
4694 4693
             $rows = DB::query(
4695 4694
                 'SELECT t.title
4696
-                FROM ' . prefixTable('roles_values') . ' as v
4697
-                INNER JOIN ' . prefixTable('roles_title') . ' as t ON (v.role_id = t.id)
4695
+                FROM ' . prefixTable('roles_values').' as v
4696
+                INNER JOIN ' . prefixTable('roles_title').' as t ON (v.role_id = t.id)
4698 4697
                 WHERE v.folder_id = %i
4699 4698
                 GROUP BY title',
4700 4699
                 $inputData['folderId']
@@ -4703,7 +4702,7 @@  discard block
 block discarded – undo
4703 4702
                 if (empty($visibilite)) {
4704 4703
                     $visibilite = $record['title'];
4705 4704
                 } else {
4706
-                    $visibilite .= ' - ' . $record['title'];
4705
+                    $visibilite .= ' - '.$record['title'];
4707 4706
                 }
4708 4707
             }
4709 4708
         } else {
@@ -4713,14 +4712,14 @@  discard block
 block discarded – undo
4713 4712
             // do new query to know if current folder is pf
4714 4713
             $data_pf = DB::queryFirstRow(
4715 4714
                 'SELECT personal_folder
4716
-                FROM ' . prefixTable('nested_tree') . '
4715
+                FROM ' . prefixTable('nested_tree').'
4717 4716
                 WHERE id = %s',
4718 4717
                 $inputData['folderId']
4719 4718
             );
4720 4719
             
4721 4720
             $folder_is_personal = $data_pf !== null ? (int) $data_pf['personal_folder'] : 0;
4722 4721
             
4723
-            $visibilite = $session->get('user-name') . ' ' . $session->get('user-lastname') . ' (' . $session->get('user-login') . ')';
4722
+            $visibilite = $session->get('user-name').' '.$session->get('user-lastname').' ('.$session->get('user-login').')';
4724 4723
         }
4725 4724
 
4726 4725
         recupDroitCreationSansComplexite($inputData['folderId']);
@@ -4730,8 +4729,8 @@  discard block
 block discarded – undo
4730 4729
         $listOptionsForRoles = array();
4731 4730
         $rows = DB::query(
4732 4731
             'SELECT r.role_id AS role_id, t.title AS title
4733
-            FROM ' . prefixTable('roles_values') . ' AS r
4734
-            INNER JOIN ' . prefixTable('roles_title') . ' AS t ON (r.role_id = t.id)
4732
+            FROM ' . prefixTable('roles_values').' AS r
4733
+            INNER JOIN ' . prefixTable('roles_title').' AS t ON (r.role_id = t.id)
4735 4734
             WHERE r.folder_id = %i',
4736 4735
             $inputData['folderId']
4737 4736
         );
@@ -4745,7 +4744,7 @@  discard block
 block discarded – undo
4745 4744
             );
4746 4745
             $rows2 = DB::query(
4747 4746
                 'SELECT id, login, fonction_id, email, name, lastname
4748
-                FROM ' . prefixTable('users') . '
4747
+                FROM ' . prefixTable('users').'
4749 4748
                 WHERE admin = 0 AND fonction_id is not null'
4750 4749
             );
4751 4750
             foreach ($rows2 as $record2) {
@@ -4759,7 +4758,7 @@  discard block
 block discarded – undo
4759 4758
                             array(
4760 4759
                                 'id' => $record2['id'],
4761 4760
                                 'login' => $record2['login'],
4762
-                                'name' => $record2['name'] . ' ' . $record2['lastname'],
4761
+                                'name' => $record2['name'].' '.$record2['lastname'],
4763 4762
                                 'email' => $record2['email'],
4764 4763
                             )
4765 4764
                         );
@@ -4776,12 +4775,12 @@  discard block
 block discarded – undo
4776 4775
             foreach ($session->get('user-roles_array') as $role) {
4777 4776
                 $access = DB::queryFirstRow(
4778 4777
                     'SELECT type
4779
-                    FROM ' . prefixTable('roles_values') . '
4778
+                    FROM ' . prefixTable('roles_values').'
4780 4779
                     WHERE role_id = %i AND folder_id = %i',
4781 4780
                     $role,
4782 4781
                     $inputData['folderId']
4783 4782
                 );
4784
-                if (DB::count()>0) {
4783
+                if (DB::count() > 0) {
4785 4784
                     if ($access['type'] === 'R') {
4786 4785
                         array_push($arrTmp, 10);
4787 4786
                     } elseif ($access['type'] === 'W') {
@@ -4809,7 +4808,7 @@  discard block
 block discarded – undo
4809 4808
             // Check if personal folder is owned by user
4810 4809
             $folder = DB::queryFirstRow(
4811 4810
                 'SELECT id
4812
-                FROM ' . prefixTable('nested_tree') . '
4811
+                FROM ' . prefixTable('nested_tree').'
4813 4812
                 WHERE title = %s',
4814 4813
                 $session->get('user-id'),
4815 4814
             );
@@ -4914,7 +4913,7 @@  discard block
 block discarded – undo
4914 4913
         // Get some info before deleting
4915 4914
         $data = DB::queryFirstRow(
4916 4915
             'SELECT name, id_item, file
4917
-            FROM ' . prefixTable('files') . '
4916
+            FROM ' . prefixTable('files').'
4918 4917
             WHERE id = %i',
4919 4918
             $fileId
4920 4919
         );
@@ -4922,7 +4921,7 @@  discard block
 block discarded – undo
4922 4921
         // Load item data
4923 4922
         $data_item = DB::queryFirstRow(
4924 4923
             'SELECT id_tree
4925
-            FROM ' . prefixTable('items') . '
4924
+            FROM ' . prefixTable('items').'
4926 4925
             WHERE id = %i',
4927 4926
             $data['id_item']
4928 4927
         );
@@ -4952,7 +4951,7 @@  discard block
 block discarded – undo
4952 4951
                 $session->get('user-id'),
4953 4952
                 'at_modification',
4954 4953
                 $session->get('user-login'),
4955
-                'at_del_file : ' . $data['name']
4954
+                'at_del_file : '.$data['name']
4956 4955
             );
4957 4956
 
4958 4957
             // DElete sharekeys
@@ -4963,7 +4962,7 @@  discard block
 block discarded – undo
4963 4962
             );
4964 4963
 
4965 4964
             // Delete file from server
4966
-            $fileToDelete = $SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($data['file']);
4965
+            $fileToDelete = $SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($data['file']);
4967 4966
             $fileToDelete = realpath($fileToDelete);
4968 4967
             if ($fileToDelete && strpos($fileToDelete, $SETTINGS['path_to_upload_folder']) === 0) {
4969 4968
                 fileDelete($fileToDelete, $SETTINGS);
@@ -5017,7 +5016,7 @@  discard block
 block discarded – undo
5017 5016
             // Update SESSION with this new favourite
5018 5017
             $data = DB::queryFirstRow(
5019 5018
                 'SELECT label,id_tree
5020
-                FROM ' . prefixTable('items') . '
5019
+                FROM ' . prefixTable('items').'
5021 5020
                 WHERE id = %i',
5022 5021
                 $inputData['itemId']
5023 5022
             );
@@ -5026,7 +5025,7 @@  discard block
 block discarded – undo
5026 5025
                 [
5027 5026
                     $inputData['itemId'] => [
5028 5027
                         'label' => $data['label'],
5029
-                        'url' => 'index.php?page=items&amp;group=' . $data['id_tree'] . '&amp;id=' . $inputData['itemId'],
5028
+                        'url' => 'index.php?page=items&amp;group='.$data['id_tree'].'&amp;id='.$inputData['itemId'],
5030 5029
                     ],
5031 5030
                 ],
5032 5031
                 'add'
@@ -5095,8 +5094,8 @@  discard block
 block discarded – undo
5095 5094
         // get data about item
5096 5095
         $dataSource = DB::queryFirstRow(
5097 5096
             'SELECT i.pw, f.personal_folder,i.id_tree, f.title,i.label
5098
-            FROM ' . prefixTable('items') . ' as i
5099
-            INNER JOIN ' . prefixTable('nested_tree') . ' as f ON (i.id_tree=f.id)
5097
+            FROM ' . prefixTable('items').' as i
5098
+            INNER JOIN ' . prefixTable('nested_tree').' as f ON (i.id_tree=f.id)
5100 5099
             WHERE i.id=%i',
5101 5100
             $inputData['itemId']
5102 5101
         );
@@ -5140,7 +5139,7 @@  discard block
 block discarded – undo
5140 5139
         // get data about new folder
5141 5140
         $dataDestination = DB::queryFirstRow(
5142 5141
             'SELECT personal_folder, title
5143
-            FROM ' . prefixTable('nested_tree') . '
5142
+            FROM ' . prefixTable('nested_tree').'
5144 5143
             WHERE id = %i',
5145 5144
             $inputData['folderId']
5146 5145
         );
@@ -5193,7 +5192,7 @@  discard block
 block discarded – undo
5193 5192
             // Get fields for this Item
5194 5193
             $rows = DB::query(
5195 5194
                 'SELECT id
5196
-                FROM ' . prefixTable('categories_items') . '
5195
+                FROM ' . prefixTable('categories_items').'
5197 5196
                 WHERE item_id = %i',
5198 5197
                 $inputData['itemId']
5199 5198
             );
@@ -5210,7 +5209,7 @@  discard block
 block discarded – undo
5210 5209
             // Get FILES for this Item
5211 5210
             $rows = DB::query(
5212 5211
                 'SELECT id
5213
-                FROM ' . prefixTable('files') . '
5212
+                FROM ' . prefixTable('files').'
5214 5213
                 WHERE id_item = %i',
5215 5214
                 $inputData['itemId']
5216 5215
             );
@@ -5257,7 +5256,7 @@  discard block
 block discarded – undo
5257 5256
             // Get the ITEM object key for the user
5258 5257
             $userKey = DB::queryFirstRow(
5259 5258
                 'SELECT share_key
5260
-                FROM ' . prefixTable('sharekeys_items') . '
5259
+                FROM ' . prefixTable('sharekeys_items').'
5261 5260
                 WHERE user_id = %i AND object_id = %i',
5262 5261
                 $session->get('user-id'),
5263 5262
                 $inputData['itemId']
@@ -5268,7 +5267,7 @@  discard block
 block discarded – undo
5268 5267
                 // This is a public object
5269 5268
                 $users = DB::query(
5270 5269
                     'SELECT id, public_key
5271
-                    FROM ' . prefixTable('users') . '
5270
+                    FROM ' . prefixTable('users').'
5272 5271
                     WHERE id NOT IN %li
5273 5272
                     AND public_key != ""',
5274 5273
                     $tpUsersIDs
@@ -5291,14 +5290,14 @@  discard block
 block discarded – undo
5291 5290
             // Get fields for this Item
5292 5291
             $rows = DB::query(
5293 5292
                 'SELECT id
5294
-                FROM ' . prefixTable('categories_items') . '
5293
+                FROM ' . prefixTable('categories_items').'
5295 5294
                 WHERE item_id = %i',
5296 5295
                 $inputData['itemId']
5297 5296
             );
5298 5297
             foreach ($rows as $field) {
5299 5298
                 $userKey = DB::queryFirstRow(
5300 5299
                     'SELECT share_key
5301
-                    FROM ' . prefixTable('sharekeys_fields') . '
5300
+                    FROM ' . prefixTable('sharekeys_fields').'
5302 5301
                     WHERE user_id = %i AND object_id = %i',
5303 5302
                     $session->get('user-id'),
5304 5303
                     $field['id']
@@ -5309,7 +5308,7 @@  discard block
 block discarded – undo
5309 5308
                     // This is a public object
5310 5309
                     $users = DB::query(
5311 5310
                         'SELECT id, public_key
5312
-                        FROM ' . prefixTable('users') . '
5311
+                        FROM ' . prefixTable('users').'
5313 5312
                         WHERE id NOT IN %li
5314 5313
                         AND public_key != ""',
5315 5314
                         $tpUsersIDs
@@ -5332,14 +5331,14 @@  discard block
 block discarded – undo
5332 5331
             // Get FILES for this Item
5333 5332
             $rows = DB::query(
5334 5333
                 'SELECT id
5335
-                FROM ' . prefixTable('files') . '
5334
+                FROM ' . prefixTable('files').'
5336 5335
                 WHERE id_item = %i',
5337 5336
                 $inputData['itemId']
5338 5337
             );
5339 5338
             foreach ($rows as $attachment) {
5340 5339
                 $userKey = DB::queryFirstRow(
5341 5340
                     'SELECT share_key
5342
-                    FROM ' . prefixTable('sharekeys_files') . '
5341
+                    FROM ' . prefixTable('sharekeys_files').'
5343 5342
                     WHERE user_id = %i AND object_id = %i',
5344 5343
                     $session->get('user-id'),
5345 5344
                     $attachment['id']
@@ -5350,7 +5349,7 @@  discard block
 block discarded – undo
5350 5349
                     // This is a public object
5351 5350
                     $users = DB::query(
5352 5351
                         'SELECT id, public_key
5353
-                        FROM ' . prefixTable('users') . '
5352
+                        FROM ' . prefixTable('users').'
5354 5353
                         WHERE id NOT IN %li
5355 5354
                         AND public_key != ""',
5356 5355
                         $tpUsersIDs
@@ -5391,7 +5390,7 @@  discard block
 block discarded – undo
5391 5390
             $session->get('user-id'),
5392 5391
             'at_modification',
5393 5392
             $session->get('user-login'),
5394
-            'at_moved : ' . $dataSource['title'] . ' -> ' . $dataDestination['title']
5393
+            'at_moved : '.$dataSource['title'].' -> '.$dataDestination['title']
5395 5394
         );
5396 5395
 
5397 5396
         // Update cache table
@@ -5450,8 +5449,8 @@  discard block
 block discarded – undo
5450 5449
                 // get data about item
5451 5450
                 $dataSource = DB::queryFirstRow(
5452 5451
                     'SELECT i.pw, f.personal_folder,i.id_tree, f.title,i.label
5453
-                    FROM ' . prefixTable('items') . ' as i
5454
-                    INNER JOIN ' . prefixTable('nested_tree') . ' as f ON (i.id_tree=f.id)
5452
+                    FROM ' . prefixTable('items').' as i
5453
+                    INNER JOIN ' . prefixTable('nested_tree').' as f ON (i.id_tree=f.id)
5455 5454
                     WHERE i.id=%i',
5456 5455
                     $item_id
5457 5456
                 );
@@ -5473,7 +5472,7 @@  discard block
 block discarded – undo
5473 5472
 
5474 5473
                 // get data about new folder
5475 5474
                 $dataDestination = DB::queryFirstRow(
5476
-                    'SELECT personal_folder, title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i',
5475
+                    'SELECT personal_folder, title FROM '.prefixTable('nested_tree').' WHERE id = %i',
5477 5476
                     $inputData['folderId']
5478 5477
                 );
5479 5478
 
@@ -5515,7 +5514,7 @@  discard block
 block discarded – undo
5515 5514
                     // Get fields for this Item
5516 5515
                     $rows = DB::query(
5517 5516
                         'SELECT id
5518
-                        FROM ' . prefixTable('categories_items') . '
5517
+                        FROM ' . prefixTable('categories_items').'
5519 5518
                         WHERE item_id = %i',
5520 5519
                         $item_id
5521 5520
                     );
@@ -5532,7 +5531,7 @@  discard block
 block discarded – undo
5532 5531
                     // Get FILES for this Item
5533 5532
                     $rows = DB::query(
5534 5533
                         'SELECT id
5535
-                        FROM ' . prefixTable('files') . '
5534
+                        FROM ' . prefixTable('files').'
5536 5535
                         WHERE id_item = %i',
5537 5536
                         $item_id
5538 5537
                     );
@@ -5587,7 +5586,7 @@  discard block
 block discarded – undo
5587 5586
                     // Get the ITEM object key for the user
5588 5587
                     $userKey = DB::queryFirstRow(
5589 5588
                         'SELECT share_key
5590
-                        FROM ' . prefixTable('sharekeys_items') . '
5589
+                        FROM ' . prefixTable('sharekeys_items').'
5591 5590
                         WHERE user_id = %i AND object_id = %i',
5592 5591
                         $session->get('user-id'),
5593 5592
                         $item_id
@@ -5598,7 +5597,7 @@  discard block
 block discarded – undo
5598 5597
                         // This is a public object
5599 5598
                         $users = DB::query(
5600 5599
                             'SELECT id, public_key
5601
-                            FROM ' . prefixTable('users') . '
5600
+                            FROM ' . prefixTable('users').'
5602 5601
                             WHERE id NOT IN %li
5603 5602
                             AND public_key != ""',
5604 5603
                             $tpUsersIDs
@@ -5621,14 +5620,14 @@  discard block
 block discarded – undo
5621 5620
                     // Get fields for this Item
5622 5621
                     $rows = DB::query(
5623 5622
                         'SELECT id
5624
-                        FROM ' . prefixTable('categories_items') . '
5623
+                        FROM ' . prefixTable('categories_items').'
5625 5624
                         WHERE item_id = %i',
5626 5625
                         $item_id
5627 5626
                     );
5628 5627
                     foreach ($rows as $field) {
5629 5628
                         $userKey = DB::queryFirstRow(
5630 5629
                             'SELECT share_key
5631
-                            FROM ' . prefixTable('sharekeys_fields') . '
5630
+                            FROM ' . prefixTable('sharekeys_fields').'
5632 5631
                             WHERE user_id = %i AND object_id = %i',
5633 5632
                             $session->get('user-id'),
5634 5633
                             $field['id']
@@ -5639,7 +5638,7 @@  discard block
 block discarded – undo
5639 5638
                             // This is a public object
5640 5639
                             $users = DB::query(
5641 5640
                                 'SELECT id, public_key
5642
-                                FROM ' . prefixTable('users') . '
5641
+                                FROM ' . prefixTable('users').'
5643 5642
                                 WHERE id NOT IN %li
5644 5643
                                 AND public_key != ""',
5645 5644
                                 $tpUsersIDs
@@ -5663,14 +5662,14 @@  discard block
 block discarded – undo
5663 5662
                     // Get FILES for this Item
5664 5663
                     $rows = DB::query(
5665 5664
                         'SELECT id
5666
-                        FROM ' . prefixTable('files') . '
5665
+                        FROM ' . prefixTable('files').'
5667 5666
                         WHERE id_item = %i',
5668 5667
                         $item_id
5669 5668
                     );
5670 5669
                     foreach ($rows as $attachment) {
5671 5670
                         $userKey = DB::queryFirstRow(
5672 5671
                             'SELECT share_key
5673
-                            FROM ' . prefixTable('sharekeys_files') . '
5672
+                            FROM ' . prefixTable('sharekeys_files').'
5674 5673
                             WHERE user_id = %i AND object_id = %i',
5675 5674
                             $session->get('user-id'),
5676 5675
                             $attachment['id']
@@ -5681,7 +5680,7 @@  discard block
 block discarded – undo
5681 5680
                             // This is a public object
5682 5681
                             $users = DB::query(
5683 5682
                                 'SELECT id, public_key
5684
-                                FROM ' . prefixTable('users') . '
5683
+                                FROM ' . prefixTable('users').'
5685 5684
                                 WHERE id NOT IN %li
5686 5685
                                 AND public_key != ""',
5687 5686
                                 $tpUsersIDs
@@ -5721,13 +5720,13 @@  discard block
 block discarded – undo
5721 5720
                     $session->get('user-id'),
5722 5721
                     'at_modification',
5723 5722
                     $session->get('user-login'),
5724
-                    'at_moved : ' . $dataSource['title'] . ' -> ' . $dataDestination['title']
5723
+                    'at_moved : '.$dataSource['title'].' -> '.$dataDestination['title']
5725 5724
                 );
5726 5725
             }
5727 5726
         }
5728 5727
 
5729 5728
         // reload cache table
5730
-        require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php';
5729
+        require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php';
5731 5730
         updateCacheTable('reload', null);
5732 5731
 
5733 5732
         echo (string) prepareExchangedData(
@@ -5791,7 +5790,7 @@  discard block
 block discarded – undo
5791 5790
                 // get info
5792 5791
                 $dataSource = DB::queryFirstRow(
5793 5792
                     'SELECT label, id_tree
5794
-                    FROM ' . prefixTable('items') . '
5793
+                    FROM ' . prefixTable('items').'
5795 5794
                     WHERE id=%i',
5796 5795
                     $item_id
5797 5796
                 );
@@ -5892,14 +5891,14 @@  discard block
 block discarded – undo
5892 5891
             // Variables
5893 5892
             $dataAuthor = DB::queryFirstRow(
5894 5893
                 'SELECT email,login
5895
-                FROM ' . prefixTable('users') . '
5894
+                FROM ' . prefixTable('users').'
5896 5895
                 WHERE id = %i',
5897 5896
                 $post_content[1]
5898 5897
             );
5899 5898
 
5900 5899
             $dataItem = DB::queryFirstRow(
5901 5900
                 'SELECT label, id_tree
5902
-                FROM ' . prefixTable('items') . '
5901
+                FROM ' . prefixTable('items').'
5903 5902
                 WHERE id = %i',
5904 5903
                 $post_content[0]
5905 5904
             );
@@ -5916,7 +5915,7 @@  discard block
 block discarded – undo
5916 5915
                 $lang->get('email_request_access_subject'),
5917 5916
                 str_replace(
5918 5917
                     array('#tp_item_author#', '#tp_user#', '#tp_item#'),
5919
-                    array(' ' . addslashes($dataAuthor['login']), addslashes($session->get('user-login')), $path),
5918
+                    array(' '.addslashes($dataAuthor['login']), addslashes($session->get('user-login')), $path),
5920 5919
                     $lang->get('email_request_access_mail')
5921 5920
                 ),
5922 5921
                 $dataAuthor['email'],
@@ -5925,7 +5924,7 @@  discard block
 block discarded – undo
5925 5924
         } elseif ($inputData['cat'] === 'share_this_item') {
5926 5925
             $dataItem = DB::queryFirstRow(
5927 5926
                 'SELECT label,id_tree
5928
-                FROM ' . prefixTable('items') . '
5927
+                FROM ' . prefixTable('items').'
5929 5928
                 WHERE id= %i',
5930 5929
                 $inputData['id']
5931 5930
             );
@@ -5948,7 +5947,7 @@  discard block
 block discarded – undo
5948 5947
                     ),
5949 5948
                     array(
5950 5949
                         empty($SETTINGS['email_server_url']) === false ?
5951
-                            $SETTINGS['email_server_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $inputData['id'] : $SETTINGS['cpassman_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $inputData['id'],
5950
+                            $SETTINGS['email_server_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$inputData['id'] : $SETTINGS['cpassman_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$inputData['id'],
5952 5951
                         addslashes($session->get('user-login')),
5953 5952
                         addslashes($path),
5954 5953
                     ),
@@ -5997,8 +5996,8 @@  discard block
 block discarded – undo
5997 5996
         // Get all informations for this item
5998 5997
         $dataItem = DB::queryFirstRow(
5999 5998
             'SELECT *
6000
-            FROM ' . prefixTable('items') . ' as i
6001
-            INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id)
5999
+            FROM ' . prefixTable('items').' as i
6000
+            INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id)
6002 6001
             WHERE i.id=%i AND l.action = %s',
6003 6002
             $item_id,
6004 6003
             'at_creation'
@@ -6027,18 +6026,18 @@  discard block
 block discarded – undo
6027 6026
                 $session->get('user-login'),
6028 6027
                 htmlspecialchars_decode($label, ENT_QUOTES),
6029 6028
                 null,
6030
-                (string) dateToStamp($date.' '.$time, $SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'])
6029
+                (string) dateToStamp($date.' '.$time, $SETTINGS['date_format'].' '.$SETTINGS['time_format'])
6031 6030
             );
6032 6031
             // Prepare new line
6033 6032
             $data = DB::queryFirstRow(
6034
-                'SELECT * FROM ' . prefixTable('log_items') . ' WHERE id_item = %i ORDER BY date DESC',
6033
+                'SELECT * FROM '.prefixTable('log_items').' WHERE id_item = %i ORDER BY date DESC',
6035 6034
                 $item_id
6036 6035
             );
6037
-            $historic = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']) . ' - ' . $session->get('user-login') . ' - ' . $lang->get($data['action']) . ' - ' . $data['raison'];
6036
+            $historic = date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']).' - '.$session->get('user-login').' - '.$lang->get($data['action']).' - '.$data['raison'];
6038 6037
             // send back
6039 6038
             $data = array(
6040 6039
                 'error' => '',
6041
-                'new_line' => '<br>' . addslashes($historic),
6040
+                'new_line' => '<br>'.addslashes($historic),
6042 6041
             );
6043 6042
             echo (string) prepareExchangedData(
6044 6043
                 $data,
@@ -6113,8 +6112,8 @@  discard block
 block discarded – undo
6113 6112
         // Should we log a password change?
6114 6113
         $itemQ = DB::queryFirstRow(
6115 6114
             'SELECT s.share_key, i.pw
6116
-            FROM ' . prefixTable('items') . ' AS i
6117
-            INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (i.id = s.object_id)
6115
+            FROM ' . prefixTable('items').' AS i
6116
+            INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (i.id = s.object_id)
6118 6117
             WHERE s.user_id = %i AND s.object_id = %i',
6119 6118
             $session->get('user-id'),
6120 6119
             $dataReceived['id']
@@ -6169,7 +6168,7 @@  discard block
 block discarded – undo
6169 6168
         if (isset($SETTINGS['otv_expiration_period']) === false) {
6170 6169
             $SETTINGS['otv_expiration_period'] = 7;
6171 6170
         }
6172
-        $url = $SETTINGS['cpassman_url'] . '/index.php?' . http_build_query($otv_session);
6171
+        $url = $SETTINGS['cpassman_url'].'/index.php?'.http_build_query($otv_session);
6173 6172
 
6174 6173
         echo json_encode(
6175 6174
             array(
@@ -6200,7 +6199,7 @@  discard block
 block discarded – undo
6200 6199
         // get parameters from original link
6201 6200
         $url = $dataReceived['original_link'];
6202 6201
         $parts = parse_url($url);
6203
-        if(isset($parts['query'])){
6202
+        if (isset($parts['query'])) {
6204 6203
             parse_str($parts['query'], $orignal_link_parameters);
6205 6204
         } else {
6206 6205
             $orignal_link_parameters = array();
@@ -6231,13 +6230,13 @@  discard block
 block discarded – undo
6231 6230
             $domain_scheme = parse_url($SETTINGS['cpassman_url'], PHP_URL_SCHEME);
6232 6231
             $domain_host = parse_url($SETTINGS['cpassman_url'], PHP_URL_HOST);
6233 6232
             if (str_contains($domain_host, 'www.') === true) {
6234
-                $domain_host = (string) $SETTINGS['otv_subdomain'] . '.' . substr($domain_host, 4);
6233
+                $domain_host = (string) $SETTINGS['otv_subdomain'].'.'.substr($domain_host, 4);
6235 6234
             } else {
6236
-                $domain_host = (string) $SETTINGS['otv_subdomain'] . '.' . $domain_host;
6235
+                $domain_host = (string) $SETTINGS['otv_subdomain'].'.'.$domain_host;
6237 6236
             }
6238
-            $url = $domain_scheme.'://'.$domain_host . '/index.php?'.http_build_query($otv_session);
6237
+            $url = $domain_scheme.'://'.$domain_host.'/index.php?'.http_build_query($otv_session);
6239 6238
         } else {
6240
-            $url = $SETTINGS['cpassman_url'] . '/index.php?'.http_build_query($otv_session);
6239
+            $url = $SETTINGS['cpassman_url'].'/index.php?'.http_build_query($otv_session);
6241 6240
         }
6242 6241
 
6243 6242
         echo (string) prepareExchangedData(
@@ -6272,8 +6271,8 @@  discard block
 block discarded – undo
6272 6271
             'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status,
6273 6272
             f.extension AS extension, f.type AS type,
6274 6273
             s.share_key AS share_key
6275
-            FROM ' . prefixTable('files') . ' AS f
6276
-            INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id)
6274
+            FROM ' . prefixTable('files').' AS f
6275
+            INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id)
6277 6276
             WHERE s.user_id = %i AND s.object_id = %i',
6278 6277
             $session->get('user-id'),
6279 6278
             $inputData['id']
@@ -6294,7 +6293,7 @@  discard block
 block discarded – undo
6294 6293
         //$fileName = basename($file_info['name'], '.'.$file_info['extension']);
6295 6294
 
6296 6295
         // prepare image info
6297
-        $post_title = basename($file_info['name'], '.' . $file_info['extension']);
6296
+        $post_title = basename($file_info['name'], '.'.$file_info['extension']);
6298 6297
         $post_title = isBase64($post_title) === true ? base64_decode($post_title) : $post_title;
6299 6298
         
6300 6299
         // Get image content
@@ -6321,7 +6320,7 @@  discard block
 block discarded – undo
6321 6320
         echo (string) prepareExchangedData(
6322 6321
             array(
6323 6322
                 'error' => false,
6324
-                'filename' => $post_title . '.' . $file_info['extension'],
6323
+                'filename' => $post_title.'.'.$file_info['extension'],
6325 6324
                 'file_type' => $file_info['type'],
6326 6325
                 'file_content' => $fileContent,
6327 6326
             ),
@@ -6435,7 +6434,7 @@  discard block
 block discarded – undo
6435 6434
                     $arbo = $tree->getPath($folder->id, false);
6436 6435
                     $path = '';
6437 6436
                     foreach ($arbo as $elem) {
6438
-                        $path = (empty($path) ? '' : $path . ' / ') . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES);
6437
+                        $path = (empty($path) ? '' : $path.' / ').htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES);
6439 6438
                     }
6440 6439
 
6441 6440
                     // Build array
@@ -6501,7 +6500,7 @@  discard block
 block discarded – undo
6501 6500
         if (is_array($foldersArray) === true && $inputData['data'] !== '[null]') {
6502 6501
             $rows = DB::query(
6503 6502
                 'SELECT id, categories
6504
-                FROM ' . prefixTable('nested_tree') . '
6503
+                FROM ' . prefixTable('nested_tree').'
6505 6504
                 WHERE id IN (%l)',
6506 6505
                 implode(',', $foldersArray)
6507 6506
             );
@@ -6543,7 +6542,7 @@  discard block
 block discarded – undo
6543 6542
         // get item info
6544 6543
         $dataItem = DB::queryFirstRow(
6545 6544
             'SELECT *
6546
-            FROM ' . prefixTable('items') . '
6545
+            FROM ' . prefixTable('items').'
6547 6546
             WHERE id=%i',
6548 6547
             $inputData['itemId']
6549 6548
         );
@@ -6555,8 +6554,8 @@  discard block
 block discarded – undo
6555 6554
             'SELECT l.date as date, l.action as action, l.raison as raison,
6556 6555
                 u.login as login, u.avatar_thumb as avatar_thumb, u.name as name, u.lastname as lastname,
6557 6556
                 l.old_value as old_value
6558
-            FROM ' . prefixTable('log_items') . ' as l
6559
-            INNER JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id)
6557
+            FROM ' . prefixTable('log_items').' as l
6558
+            INNER JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id)
6560 6559
             WHERE id_item=%i AND l.action NOT IN (%l)
6561 6560
             ORDER BY date DESC',
6562 6561
             $inputData['itemId'],
@@ -6571,18 +6570,18 @@  discard block
 block discarded – undo
6571 6570
             
6572 6571
             // imported via API
6573 6572
             if (empty($record['login']) === true) {
6574
-                $record['login'] = $lang->get('imported_via_api') . ' [' . $record['raison'] . ']';
6573
+                $record['login'] = $lang->get('imported_via_api').' ['.$record['raison'].']';
6575 6574
             }
6576 6575
             
6577 6576
             // Prepare avatar
6578 6577
             if (isset($record['avatar_thumb']) && empty($record['avatar_thumb']) === false) {
6579
-                if (file_exists($SETTINGS['cpassman_dir'] . '/includes/avatars/' . $record['avatar_thumb'])) {
6580
-                    $avatar = $SETTINGS['cpassman_url'] . '/includes/avatars/' . $record['avatar_thumb'];
6578
+                if (file_exists($SETTINGS['cpassman_dir'].'/includes/avatars/'.$record['avatar_thumb'])) {
6579
+                    $avatar = $SETTINGS['cpassman_url'].'/includes/avatars/'.$record['avatar_thumb'];
6581 6580
                 } else {
6582
-                    $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg';
6581
+                    $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg';
6583 6582
                 }
6584 6583
             } else {
6585
-                $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg';
6584
+                $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg';
6586 6585
             }
6587 6586
 
6588 6587
             // Prepare action
@@ -6602,7 +6601,7 @@  discard block
 block discarded – undo
6602 6601
                         $previous_passwords, 
6603 6602
                         [
6604 6603
                             'password' => htmlentities($previous_pwd['string']),
6605
-                            'date' => date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']),
6604
+                            'date' => date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']),
6606 6605
                         ]
6607 6606
                     );
6608 6607
                 }
@@ -6615,19 +6614,19 @@  discard block
 block discarded – undo
6615 6614
                 $action = $lang->get($reason[0]);
6616 6615
                 if ($reason[0] === 'at_moved') {
6617 6616
                     $tmp = explode(' -> ', $reason[1]);
6618
-                    $detail = $lang->get('from') . ' <span class="font-weight-light">' . $tmp[0] . '</span> ' . $lang->get('to') . ' <span class="font-weight-light">' . $tmp[1] . ' </span>';
6617
+                    $detail = $lang->get('from').' <span class="font-weight-light">'.$tmp[0].'</span> '.$lang->get('to').' <span class="font-weight-light">'.$tmp[1].' </span>';
6619 6618
                 } elseif ($reason[0] === 'at_field') {
6620 6619
                     $tmp = explode(' => ', $reason[1]);
6621 6620
                     if (count($tmp) > 1) {
6622
-                        $detail = '<b>' . trim($tmp[0]) . '</b> | ' . $lang->get('previous_value') .
6623
-                            ': <span class="font-weight-light">' . trim($tmp[1]) . '</span>';
6621
+                        $detail = '<b>'.trim($tmp[0]).'</b> | '.$lang->get('previous_value').
6622
+                            ': <span class="font-weight-light">'.trim($tmp[1]).'</span>';
6624 6623
                     } else {
6625 6624
                         $detail = trim($reason[1]);
6626 6625
                     }
6627 6626
                 } elseif (in_array($reason[0], array('at_restriction', 'at_email', 'at_login', 'at_label', 'at_url', 'at_tag')) === true) {
6628 6627
                     $tmp = explode(' => ', $reason[1]);
6629 6628
                     $detail = empty(trim($tmp[0])) === true ?
6630
-                        $lang->get('no_previous_value') : $lang->get('previous_value') . ': <span class="font-weight-light">' . $tmp[0] . ' </span>';
6629
+                        $lang->get('no_previous_value') : $lang->get('previous_value').': <span class="font-weight-light">'.$tmp[0].' </span>';
6631 6630
                 } elseif ($reason[0] === 'at_automatic_del') {
6632 6631
                     $detail = $lang->get($reason[1]);
6633 6632
                 } elseif ($reason[0] === 'at_anyoneconmodify' || $reason[0] === 'at_otp_status' || $reason[0] === 'at_otp_secret' || $reason[0] === 'at_phone_number') {
@@ -6636,7 +6635,7 @@  discard block
 block discarded – undo
6636 6635
                     $tmp = explode(':', $reason[1]);
6637 6636
                     $tmp = explode('.', $tmp[0]);
6638 6637
                     $detail = isBase64($tmp[0]) === true ?
6639
-                        base64_decode($tmp[0]) . '.' . $tmp[1] : $tmp[0];
6638
+                        base64_decode($tmp[0]).'.'.$tmp[1] : $tmp[0];
6640 6639
                 } elseif ($reason[0] === 'at_import') {
6641 6640
                     $detail = '';
6642 6641
                 } elseif (in_array($reason[0], array('csv', 'pdf')) === true) {
@@ -6655,8 +6654,8 @@  discard block
 block discarded – undo
6655 6654
                 array(
6656 6655
                     'avatar' => $avatar,
6657 6656
                     'login' => $record['login'],
6658
-                    'name' => $record['name'] . ' ' . $record['lastname'],
6659
-                    'date' => date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']),
6657
+                    'name' => $record['name'].' '.$record['lastname'],
6658
+                    'date' => date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']),
6660 6659
                     'action' => $action,
6661 6660
                     'detail' => $detail,
6662 6661
                 )
@@ -6744,11 +6743,11 @@  discard block
 block discarded – undo
6744 6743
 
6745 6744
         // get some info to add to the notification email
6746 6745
         $resp_user = DB::queryFirstRow(
6747
-            'SELECT login FROM ' . prefixTable('users') . ' WHERE id = %i',
6746
+            'SELECT login FROM '.prefixTable('users').' WHERE id = %i',
6748 6747
             $session->get('user-id')
6749 6748
         );
6750 6749
         $resp_folder = DB::queryFirstRow(
6751
-            'SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i',
6750
+            'SELECT title FROM '.prefixTable('nested_tree').' WHERE id = %i',
6752 6751
             $folder
6753 6752
         );
6754 6753
 
@@ -6757,7 +6756,7 @@  discard block
 block discarded – undo
6757 6756
         $emailService = new EmailService();
6758 6757
         $rows = DB::query(
6759 6758
             'SELECT email
6760
-            FROM ' . prefixTable('users') . '
6759
+            FROM ' . prefixTable('users').'
6761 6760
             WHERE `gestionnaire` = %i AND `email` IS NOT NULL',
6762 6761
             1
6763 6762
         );
@@ -6803,7 +6802,7 @@  discard block
 block discarded – undo
6803 6802
         // Send email
6804 6803
         $dataItem = DB::queryFirstRow(
6805 6804
             'SELECT label, id_tree
6806
-            FROM ' . prefixTable('items') . '
6805
+            FROM ' . prefixTable('items').'
6807 6806
             WHERE id = %i',
6808 6807
             $inputData['itemId']
6809 6808
         );
@@ -6857,7 +6856,7 @@  discard block
 block discarded – undo
6857 6856
 
6858 6857
         DB::query(
6859 6858
             'SELECT *
6860
-            FROM ' . prefixTable('notification') . '
6859
+            FROM ' . prefixTable('notification').'
6861 6860
             WHERE item_id = %i AND user_id = %i',
6862 6861
             $inputData['itemId'],
6863 6862
             $session->get('user-id')
@@ -6929,7 +6928,7 @@  discard block
 block discarded – undo
6929 6928
         // And related logs
6930 6929
         $rows = DB::query(
6931 6930
             'SELECT id, file AS filename
6932
-            FROM ' . prefixTable('files') . '
6931
+            FROM ' . prefixTable('files').'
6933 6932
             WHERE id_item = %i AND confirmed = %i',
6934 6933
             $inputData['itemId'],
6935 6934
             0
@@ -6943,12 +6942,12 @@  discard block
 block discarded – undo
6943 6942
             );
6944 6943
 
6945 6944
             // Delete file on server
6946
-            unlink($SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($file['filename']));
6945
+            unlink($SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($file['filename']));
6947 6946
 
6948 6947
             // Delete related logs
6949 6948
             $logFile = DB::query(
6950 6949
                 'SELECT increment_id, raison
6951
-                FROM ' . prefixTable('log_items') . '
6950
+                FROM ' . prefixTable('log_items').'
6952 6951
                 WHERE id_item = %i AND id_user = %i AND action = %s AND raison LIKE "at_add_file :%"',
6953 6952
                 $inputData['itemId'],
6954 6953
                 $session->get('user-id'),
@@ -7007,7 +7006,7 @@  discard block
 block discarded – undo
7007 7006
         // Confirm attachments
7008 7007
         $rows = DB::query(
7009 7008
             'SELECT id, file AS filename
7010
-            FROM ' . prefixTable('files') . '
7009
+            FROM ' . prefixTable('files').'
7011 7010
             WHERE id_item = %i AND confirmed = %i',
7012 7011
             $inputData['itemId'],
7013 7012
             0
@@ -7123,7 +7122,7 @@  discard block
 block discarded – undo
7123 7122
             $successfulDeletions = array();
7124 7123
             $failedDeletions = array();
7125 7124
 
7126
-            foreach( $selectedItemIds as $itemId) {
7125
+            foreach ($selectedItemIds as $itemId) {
7127 7126
                 // Check that user can access this item
7128 7127
                 $granted = accessToItemIsGranted((int) $itemId, $SETTINGS);
7129 7128
                 if ($granted !== true) {
@@ -7134,7 +7133,7 @@  discard block
 block discarded – undo
7134 7133
                 // Load item data
7135 7134
                 $data = DB::queryFirstRow(
7136 7135
                     'SELECT id_tree, id, label
7137
-                    FROM ' . prefixTable('items') . '
7136
+                    FROM ' . prefixTable('items').'
7138 7137
                     WHERE id = %i',
7139 7138
                     $itemId
7140 7139
                 );
@@ -7217,15 +7216,15 @@  discard block
 block discarded – undo
7217 7216
         case 'autocomplete_tags':
7218 7217
             // Get a list off all existing TAGS
7219 7218
             $listOfTags = '';
7220
-            $rows = DB::query('SELECT tag FROM ' . prefixTable('tags') . ' WHERE tag LIKE %ss GROUP BY tag', $inputData['getTerm']);
7219
+            $rows = DB::query('SELECT tag FROM '.prefixTable('tags').' WHERE tag LIKE %ss GROUP BY tag', $inputData['getTerm']);
7221 7220
             foreach ($rows as $record) {
7222 7221
                 if (empty($listOfTags)) {
7223
-                    $listOfTags = '"' . $record['tag'] . '"';
7222
+                    $listOfTags = '"'.$record['tag'].'"';
7224 7223
                 } else {
7225
-                    $listOfTags .= ', "' . $record['tag'] . '"';
7224
+                    $listOfTags .= ', "'.$record['tag'].'"';
7226 7225
                 }
7227 7226
             }
7228
-            echo '[' . $listOfTags . ']';
7227
+            echo '['.$listOfTags.']';
7229 7228
             break;
7230 7229
     }
7231 7230
 }
@@ -7241,7 +7240,7 @@  discard block
 block discarded – undo
7241 7240
 {
7242 7241
     $data = DB::queryFirstRow(
7243 7242
         'SELECT bloquer_creation, bloquer_modification, personal_folder
7244
-        FROM ' . prefixTable('nested_tree') . ' WHERE id = %i',
7243
+        FROM ' . prefixTable('nested_tree').' WHERE id = %i',
7245 7244
         $groupe
7246 7245
     );
7247 7246
     // Check if it's in a personal folder. If yes, then force complexity overhead.
@@ -7361,7 +7360,7 @@  discard block
 block discarded – undo
7361 7360
     // Get item date
7362 7361
     $itemRestrictedUsersList = DB::queryFirstRow(
7363 7362
         'SELECT restricted_to
7364
-         FROM ' . prefixTable('items') . '
7363
+         FROM ' . prefixTable('items').'
7365 7364
          WHERE id = %i',
7366 7365
         $itemId
7367 7366
     );
@@ -7394,7 +7393,7 @@  discard block
 block discarded – undo
7394 7393
     $now = time();
7395 7394
     $editionLocks = DB::query(
7396 7395
         'SELECT timestamp, user_id, increment_id
7397
-         FROM ' . prefixTable('items_edition') . '
7396
+         FROM ' . prefixTable('items_edition').'
7398 7397
          WHERE item_id = %i 
7399 7398
          ORDER BY increment_id DESC',
7400 7399
         $itemId
@@ -7440,7 +7439,7 @@  discard block
 block discarded – undo
7440 7439
 
7441 7440
         // Delete related background tasks if any
7442 7441
         $task = DB::queryFirstRow(
7443
-            'SELECT increment_id FROM ' . prefixTable('background_tasks') . '
7442
+            'SELECT increment_id FROM '.prefixTable('background_tasks').'
7444 7443
              WHERE item_id = %i AND finished_at = ""',
7445 7444
             $itemId
7446 7445
         );
@@ -7453,7 +7452,7 @@  discard block
 block discarded – undo
7453 7452
         // Check if encryption process is still running
7454 7453
         DB::queryFirstRow(
7455 7454
             'SELECT JSON_EXTRACT(arguments, "$.all_users_except_id") AS all_users_except_id
7456
-             FROM ' . prefixTable('background_tasks') . '
7455
+             FROM ' . prefixTable('background_tasks').'
7457 7456
              WHERE item_id = %i AND finished_at = ""
7458 7457
              ORDER BY increment_id DESC',
7459 7458
             $itemId
@@ -7474,7 +7473,7 @@  discard block
 block discarded – undo
7474 7473
         }
7475 7474
 
7476 7475
         return [
7477
-            'status' => true,   // Encryption in progress
7476
+            'status' => true, // Encryption in progress
7478 7477
             'delay' => $delay - $elapsed, // Time remaining before the lock expires
7479 7478
         ];
7480 7479
     }
@@ -7519,7 +7518,7 @@  discard block
 block discarded – undo
7519 7518
 {
7520 7519
     // Check if there's an ongoing background encryption process for the item
7521 7520
     $ongoingProcess = DB::queryFirstRow(
7522
-        'SELECT 1 FROM ' . prefixTable('background_tasks') . ' WHERE item_id = %i AND finished_at = "" LIMIT 1', 
7521
+        'SELECT 1 FROM '.prefixTable('background_tasks').' WHERE item_id = %i AND finished_at = "" LIMIT 1', 
7523 7522
         $itemId
7524 7523
     );
7525 7524
 
@@ -7537,7 +7536,7 @@  discard block
 block discarded – undo
7537 7536
 function getUserVisibleFolders(int $userId): array
7538 7537
 {
7539 7538
     // Query to retrieve visible folders for the user
7540
-    $data = DB::queryFirstRow('SELECT visible_folders FROM ' . prefixTable('cache_tree') . ' WHERE user_id = %i', $userId);
7539
+    $data = DB::queryFirstRow('SELECT visible_folders FROM '.prefixTable('cache_tree').' WHERE user_id = %i', $userId);
7541 7540
     
7542 7541
     // Decode JSON data into an array; return an empty array if the data is invalid
7543 7542
     return json_decode($data['visible_folders'], true) ?? [];
@@ -7561,7 +7560,7 @@  discard block
 block discarded – undo
7561 7560
 
7562 7561
     // Query the access rights for the given roles and folder
7563 7562
     $accessTypes = DB::queryFirstColumn(
7564
-        'SELECT DISTINCT type FROM ' . prefixTable('roles_values') . ' WHERE role_id IN %ls AND folder_id = %i', 
7563
+        'SELECT DISTINCT type FROM '.prefixTable('roles_values').' WHERE role_id IN %ls AND folder_id = %i', 
7565 7564
         $roles, 
7566 7565
         $treeId
7567 7566
     );
Please login to merge, or discard this patch.
Braces   +12 added lines, -5 removed lines patch added patch discarded remove patch
@@ -1228,7 +1228,9 @@  discard block
 block discarded – undo
1228 1228
                 );
1229 1229
 
1230 1230
                 // Create a task to create sharekeys for users
1231
-                if (WIP=== true) error_log('createTaskForItem - new password for this item - '.$post_password ." -- ". $pw);
1231
+                if (WIP=== true) {
1232
+                    error_log('createTaskForItem - new password for this item - '.$post_password ." -- ". $pw);
1233
+                }
1232 1234
                 $tasksToBePerformed = ['item_password'];
1233 1235
                 $encryptionTaskIsRequested = true;
1234 1236
             } else {
@@ -1553,7 +1555,9 @@  discard block
 block discarded – undo
1553 1555
 
1554 1556
             // create a task for all fields updated
1555 1557
             if ($encryptionTaskIsRequested === true && (int) $dataItem['perso'] !== 1) {
1556
-                if (WIP === true) error_log('createTaskForItem - '.print_r($tasksToBePerformed, true));
1558
+                if (WIP === true) {
1559
+                    error_log('createTaskForItem - '.print_r($tasksToBePerformed, true));
1560
+                }
1557 1561
                 createTaskForItem(
1558 1562
                     'item_update_create_keys',
1559 1563
                     array_unique($tasksToBePerformed),
@@ -2103,7 +2107,9 @@  discard block
 block discarded – undo
2103 2107
                 $inputData['itemId']
2104 2108
             );
2105 2109
             foreach ($rows as $record) {
2106
-                if ($record['raison'] === NULL) continue;
2110
+                if ($record['raison'] === NULL) {
2111
+                    continue;
2112
+                }
2107 2113
                 $reason = explode(':', $record['raison']);
2108 2114
                 if (count($reason) > 0) {
2109 2115
                     $sentence = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']) . ' - '
@@ -4819,8 +4825,9 @@  discard block
 block discarded – undo
4819 4825
                 $ids = $tree->getDescendants($folder['id'], true, false, true);
4820 4826
 
4821 4827
                 // This folder is owned by user
4822
-                if (in_array($inputData['folderId'], $ids))
4823
-                    $accessLevel = 30;
4828
+                if (in_array($inputData['folderId'], $ids)) {
4829
+                                    $accessLevel = 30;
4830
+                }
4824 4831
             }
4825 4832
         }
4826 4833
 
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 && (int) $SETTINGS['timezone'] === $key ? ' selected' : '', '>' . $zone . '</option>';
325
+                                <option value="' . $key.'"', isset($SETTINGS['timezone']) === true && (int) $SETTINGS['timezone'] === $key ? ' selected' : '', '>'.$zone.'</option>';
326 326
                                     }
327 327
                                     ?>
328 328
                                 </select>
@@ -374,7 +374,7 @@  discard block
 block discarded – undo
374 374
                                     $languagesList = $languagesList ?? [];
375 375
                                     foreach ($languagesList as $teampassLang) {
376 376
                                         echo '
377
-                                <option value="' . $teampassLang . '"', isset($SETTINGS['default_language']) === true && (int) $SETTINGS['default_language'] === $teampassLang ? ' selected' : '', '>' . $teampassLang . '</option>';
377
+                                <option value="' . $teampassLang.'"', isset($SETTINGS['default_language']) === true && (int) $SETTINGS['default_language'] === $teampassLang ? ' selected' : '', '>'.$teampassLang.'</option>';
378 378
                                     }
379 379
                                     ?>
380 380
                                 </select>
@@ -471,7 +471,7 @@  discard block
 block discarded – undo
471 471
                                 <?php
472 472
                                 foreach (TP_PW_COMPLEXITY as $complex) {
473 473
                                     echo '
474
-                                <option value="' . $complex[0] . '"', isset($SETTINGS['personal_saltkey_security_level']) === true && (int) $SETTINGS['personal_saltkey_security_level'] === $complex[0] ? ' selected' : '', '>' . $complex[1] . '</option>';
474
+                                <option value="' . $complex[0].'"', isset($SETTINGS['personal_saltkey_security_level']) === true && (int) $SETTINGS['personal_saltkey_security_level'] === $complex[0] ? ' selected' : '', '>'.$complex[1].'</option>';
475 475
                                 }
476 476
                                 ?>
477 477
                             </select>
@@ -848,7 +848,7 @@  discard block
 block discarded – undo
848 848
                                         $roles = getRolesTitles();
849 849
                                         foreach ($roles as $role) {
850 850
                                             echo '
851
-                                    <option value="' . htmlspecialchars($role['id']) . '"', in_array($role['id'], $arrRolesToPrint) === true ? ' selected' : '', '>' . htmlspecialchars(addslashes($role['title'])) . '</option>';
851
+                                    <option value="' . htmlspecialchars($role['id']).'"', in_array($role['id'], $arrRolesToPrint) === true ? ' selected' : '', '>'.htmlspecialchars(addslashes($role['title'])).'</option>';
852 852
                                         }
853 853
                                     }
854 854
                                     ?>
@@ -1075,7 +1075,7 @@  discard block
 block discarded – undo
1075 1075
                                     <?php
1076 1076
                                     foreach (TP_PW_COMPLEXITY as $complex) {
1077 1077
                                         echo '
1078
-                                <option value="' . $complex[0] . '"', isset($SETTINGS['offline_key_level']) === true && (int) $SETTINGS['offline_key_level'] === $complex[0] ? ' selected' : '', '>' . $complex[1] . '</option>';
1078
+                                <option value="' . $complex[0].'"', isset($SETTINGS['offline_key_level']) === true && (int) $SETTINGS['offline_key_level'] === $complex[0] ? ' selected' : '', '>'.$complex[1].'</option>';
1079 1079
                                     }
1080 1080
                                     ?>
1081 1081
                                 </select>
Please login to merge, or discard this patch.