@@ -137,14 +137,14 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | } |
@@ -72,7 +72,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | } |
@@ -69,7 +69,7 @@ discard block |
||
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 |
||
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 |
||
124 | 124 | for ($y = 1; $y < $t->nlevel; ++$y) { |
125 | 125 | $ident .= ' '; |
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 |
||
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 |
||
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 |
||
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 |
||
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> |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | ) { |
78 | 78 | // Not allowed page |
79 | 79 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
80 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
80 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
81 | 81 | exit; |
82 | 82 | } |
83 | 83 | |
@@ -128,7 +128,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 .= '"'. |
@@ -72,7 +72,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 . ' ' . $session_lastname; ?> |
|
349 | + echo $session_name.' '.$session_lastname; ?> |
|
350 | 350 | </a> |
351 | 351 | |
352 | 352 | <div class="dropdown-menu dropdown-menu-right"> |
@@ -370,7 +370,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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'); ?> <?php echo TP_VERSION . '.' . TP_VERSION_MINOR; ?> |
|
1100 | + <?php echo $lang->get('version_alone'); ?> <?php echo TP_VERSION.'.'.TP_VERSION_MINOR; ?> |
|
1101 | 1101 | </div> |
1102 | 1102 | <!-- Default to the left --> |
1103 | 1103 | <strong>Copyright © <?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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | } |
@@ -80,8 +80,9 @@ discard block |
||
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 |
||
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> |
@@ -71,7 +71,7 @@ discard block |
||
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 |
||
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 |
||
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' |
@@ -72,7 +72,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | }); |
@@ -1836,7 +1836,7 @@ |
||
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 |
@@ -79,7 +79,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | |
@@ -1999,7 +1998,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 .= '→ ' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
3424 | + $path .= '→ '.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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
5026 | 5025 | [ |
5027 | 5026 | $inputData['itemId'] => [ |
5028 | 5027 | 'label' => $data['label'], |
5029 | - 'url' => 'index.php?page=items&group=' . $data['id_tree'] . '&id=' . $inputData['itemId'], |
|
5028 | + 'url' => 'index.php?page=items&group='.$data['id_tree'].'&id='.$inputData['itemId'], |
|
5030 | 5029 | ], |
5031 | 5030 | ], |
5032 | 5031 | 'add' |
@@ -5095,8 +5094,8 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | ); |
@@ -1228,7 +1228,9 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
@@ -69,7 +69,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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> |