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