@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('tools') === false) { |
71 | 71 | // Not allowed page |
72 | 72 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
73 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
73 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
74 | 74 | exit; |
75 | 75 | } |
76 | 76 | |
@@ -335,7 +335,7 @@ discard block |
||
335 | 335 | // Get PT_USER info |
336 | 336 | $userInfo = DB::queryFirstRow( |
337 | 337 | 'SELECT pw, public_key, private_key, login, name |
338 | - FROM ' . prefixTable('users') . ' |
|
338 | + FROM ' . prefixTable('users').' |
|
339 | 339 | WHERE id = %i', |
340 | 340 | TP_USER_ID |
341 | 341 | ); |
@@ -372,8 +372,8 @@ discard block |
||
372 | 372 | // Get one itemKey from current user |
373 | 373 | $currentUserKey = DB::queryFirstRow( |
374 | 374 | 'SELECT ski.share_key, ski.increment_id AS increment_id, l.id_user |
375 | - FROM ' . prefixTable('sharekeys_items') . ' AS ski |
|
376 | - INNER JOIN ' . prefixTable('log_items') . ' AS l ON ski.object_id = l.id_item |
|
375 | + FROM ' . prefixTable('sharekeys_items').' AS ski |
|
376 | + INNER JOIN ' . prefixTable('log_items').' AS l ON ski.object_id = l.id_item |
|
377 | 377 | WHERE ski.user_id = %i |
378 | 378 | ORDER BY RAND() |
379 | 379 | LIMIT 1', |
@@ -392,7 +392,7 @@ discard block |
||
392 | 392 | echo prepareExchangedData( |
393 | 393 | array( |
394 | 394 | 'error' => true, |
395 | - 'message' => 'No issue found, normal process should work. This process is now finished. (item id : ' . $currentUserKey['increment_id'] . ')', |
|
395 | + 'message' => 'No issue found, normal process should work. This process is now finished. (item id : '.$currentUserKey['increment_id'].')', |
|
396 | 396 | ), |
397 | 397 | 'encode' |
398 | 398 | ); |
@@ -452,7 +452,7 @@ discard block |
||
452 | 452 | // Get user info |
453 | 453 | $userInfo = DB::queryFirstRow( |
454 | 454 | 'SELECT public_key, private_key |
455 | - FROM ' . prefixTable('users') . ' |
|
455 | + FROM ' . prefixTable('users').' |
|
456 | 456 | WHERE id = %i', |
457 | 457 | $userId |
458 | 458 | ); |
@@ -475,8 +475,8 @@ discard block |
||
475 | 475 | // Get one itemKey from current user |
476 | 476 | $currentUserKey = DB::queryFirstRow( |
477 | 477 | 'SELECT ski.share_key, ski.increment_id AS increment_id, l.id_user |
478 | - FROM ' . prefixTable('sharekeys_items') . ' AS ski |
|
479 | - INNER JOIN ' . prefixTable('log_items') . ' AS l ON ski.object_id = l.id_item |
|
478 | + FROM ' . prefixTable('sharekeys_items').' AS ski |
|
479 | + INNER JOIN ' . prefixTable('log_items').' AS l ON ski.object_id = l.id_item |
|
480 | 480 | WHERE ski.user_id = %i |
481 | 481 | ORDER BY RAND() |
482 | 482 | LIMIT 1', |
@@ -514,8 +514,8 @@ discard block |
||
514 | 514 | // Get number of users to treat |
515 | 515 | DB::query( |
516 | 516 | 'SELECT i.id |
517 | - FROM ' . prefixTable('items') . ' AS i |
|
518 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS si ON i.id = si.object_id |
|
517 | + FROM ' . prefixTable('items').' AS i |
|
518 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS si ON i.id = si.object_id |
|
519 | 519 | WHERE i.perso = %i AND si.user_id = %i;', |
520 | 520 | 0, |
521 | 521 | $userId |
@@ -597,11 +597,11 @@ discard block |
||
597 | 597 | // Loop on items |
598 | 598 | $rows = DB::query( |
599 | 599 | 'SELECT si.object_id AS object_id, si.share_key AS share_key, i.pw AS pw, si.increment_id as increment_id |
600 | - FROM ' . prefixTable('sharekeys_items') . ' AS si |
|
601 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (i.id = si.object_id) |
|
600 | + FROM ' . prefixTable('sharekeys_items').' AS si |
|
601 | + INNER JOIN ' . prefixTable('items').' AS i ON (i.id = si.object_id) |
|
602 | 602 | WHERE si.user_id = %i |
603 | 603 | ORDER BY si.increment_id ASC |
604 | - LIMIT ' . $startIndex . ', ' . $limit, |
|
604 | + LIMIT ' . $startIndex.', '.$limit, |
|
605 | 605 | $userId |
606 | 606 | ); |
607 | 607 | |
@@ -625,7 +625,7 @@ discard block |
||
625 | 625 | // It will be updated if already exists |
626 | 626 | $currentTPUserKey = DB::queryFirstRow( |
627 | 627 | 'SELECT increment_id, user_id, share_key |
628 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
628 | + FROM ' . prefixTable('sharekeys_items').' |
|
629 | 629 | WHERE object_id = %i AND user_id = %i', |
630 | 630 | $record['object_id'], |
631 | 631 | TP_USER_ID |
@@ -661,7 +661,7 @@ discard block |
||
661 | 661 | DB::commit(); |
662 | 662 | } catch (Exception $e) { |
663 | 663 | DB::rollback(); |
664 | - error_log("Teampass - Error: Keys treatment: " . $e->getMessage()); |
|
664 | + error_log("Teampass - Error: Keys treatment: ".$e->getMessage()); |
|
665 | 665 | } |
666 | 666 | |
667 | 667 | $nextIndex = (int) $startIndex + (int) $limit; |
@@ -717,7 +717,7 @@ discard block |
||
717 | 717 | // Get PT_USER info |
718 | 718 | DB::queryFirstRow( |
719 | 719 | 'SELECT operation_code |
720 | - FROM ' . prefixTable('sharekeys_backup') . ' |
|
720 | + FROM ' . prefixTable('sharekeys_backup').' |
|
721 | 721 | WHERE operation_code = %s', |
722 | 722 | $operationCode |
723 | 723 | ); |
@@ -727,7 +727,7 @@ discard block |
||
727 | 727 | // using increment_id_value in order to update the correct record |
728 | 728 | $rows = DB::query( |
729 | 729 | 'SELECT * |
730 | - FROM ' . prefixTable('sharekeys_backup') . ' |
|
730 | + FROM ' . prefixTable('sharekeys_backup').' |
|
731 | 731 | WHERE operation_code = %s', |
732 | 732 | $operationCode |
733 | 733 | ); |
@@ -746,7 +746,7 @@ discard block |
||
746 | 746 | |
747 | 747 | // Delete all sharekeys for this operation |
748 | 748 | DB::query( |
749 | - 'DELETE FROM ' . prefixTable('sharekeys_backup') . ' |
|
749 | + 'DELETE FROM '.prefixTable('sharekeys_backup').' |
|
750 | 750 | WHERE operation_code = %i', |
751 | 751 | $operationCode |
752 | 752 | ); |
@@ -809,7 +809,7 @@ discard block |
||
809 | 809 | // Get operation info |
810 | 810 | DB::query( |
811 | 811 | 'SELECT operation_code |
812 | - FROM ' . prefixTable('sharekeys_backup') . ' |
|
812 | + FROM ' . prefixTable('sharekeys_backup').' |
|
813 | 813 | WHERE operation_code = %s', |
814 | 814 | $operationCode |
815 | 815 | ); |
@@ -818,7 +818,7 @@ discard block |
||
818 | 818 | if ($nbKeys > 0) { |
819 | 819 | // Delete all sharekeys for this operation |
820 | 820 | DB::query( |
821 | - 'DELETE FROM ' . prefixTable('sharekeys_backup') . ' |
|
821 | + 'DELETE FROM '.prefixTable('sharekeys_backup').' |
|
822 | 822 | WHERE operation_code = %s', |
823 | 823 | $operationCode |
824 | 824 | ); |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | ) { |
76 | 76 | // Not allowed page |
77 | 77 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
78 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
78 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
79 | 79 | exit; |
80 | 80 | } |
81 | 81 | |
@@ -145,7 +145,7 @@ discard block |
||
145 | 145 | if (isset($order['column']) && preg_match('#^(asc|desc)$#i', $order['dir'])) { |
146 | 146 | $columnIndex = $order['column']; |
147 | 147 | $dir = $inputData['dir']; |
148 | - $sOrder .= $aColumns[$columnIndex] . ' ' . $dir . ', '; |
|
148 | + $sOrder .= $aColumns[$columnIndex].' '.$dir.', '; |
|
149 | 149 | } |
150 | 150 | |
151 | 151 | $sOrder = substr_replace($sOrder, '', -2); |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('tasks') === false) { |
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 | |
@@ -126,7 +126,7 @@ discard block |
||
126 | 126 | // Get last cron execution timestamp |
127 | 127 | $queryResults = DB::query( |
128 | 128 | 'SELECT valeur |
129 | - FROM ' . prefixTable('misc') . ' |
|
129 | + FROM ' . prefixTable('misc').' |
|
130 | 130 | WHERE type = %s AND intitule = %s and valeur >= %d', |
131 | 131 | 'admin', |
132 | 132 | 'last_cron_exec', |
@@ -234,7 +234,7 @@ discard block |
||
234 | 234 | $task = isset($SETTINGS['users_personal_folder_task']) === true ? explode(";", $SETTINGS['users_personal_folder_task']) : []; |
235 | 235 | ?> |
236 | 236 | <input type='text' disabled class='form-control form-control-sm' id='users_personal_folder_task_parameter' value='<?php echo isset($task[0]) === true && empty($task[0]) === false ? $lang->get($task[0])." ".(isset($task[2]) === true ? strtolower($lang->get('day')).' '.$task[2].' ' : '').$lang->get('at')." ".(isset($task[1]) === true ? $task[1] : '') : $lang->get('not_defined') ?>'> |
237 | - <input type='hidden' disabled class='form-control form-control-sm' id='users_personal_folder_task_parameter_value' value='<?php echo isset($task[0]) === true ? $task[0].";".(isset($task[1]) === true ? $task[1] : '').(isset($task[2]) === true ? $task[2] : '') : '';?>'> |
|
237 | + <input type='hidden' disabled class='form-control form-control-sm' id='users_personal_folder_task_parameter_value' value='<?php echo isset($task[0]) === true ? $task[0].";".(isset($task[1]) === true ? $task[1] : '').(isset($task[2]) === true ? $task[2] : '') : ''; ?>'> |
|
238 | 238 | </div> |
239 | 239 | <div class='col-2'> |
240 | 240 | <button class="btn btn-primary task-define" data-task="users_personal_folder_task"> |
@@ -256,7 +256,7 @@ discard block |
||
256 | 256 | $task = isset($SETTINGS['clean_orphan_objects_task']) === true ? explode(";", $SETTINGS['clean_orphan_objects_task']) : []; |
257 | 257 | ?> |
258 | 258 | <input type='text' disabled class='form-control form-control-sm' id='clean_orphan_objects_task_parameter' value='<?php echo isset($task[0]) === true && empty($task[0]) === false ? $lang->get($task[0])." ".(isset($task[2]) === true ? strtolower($lang->get('day')).' '.$task[2].' ' : '').$lang->get('at')." ".(isset($task[1]) === true ? $task[1] : '') : $lang->get('not_defined') ?>'> |
259 | - <input type='hidden' disabled class='form-control form-control-sm' id='clean_orphan_objects_task_parameter_value' value='<?php echo isset($task[0]) === true ? $task[0].";".(isset($task[1]) === true ? $task[1] : '').(isset($task[2]) === true ? $task[2] : '') : '';?>'> |
|
259 | + <input type='hidden' disabled class='form-control form-control-sm' id='clean_orphan_objects_task_parameter_value' value='<?php echo isset($task[0]) === true ? $task[0].";".(isset($task[1]) === true ? $task[1] : '').(isset($task[2]) === true ? $task[2] : '') : ''; ?>'> |
|
260 | 260 | </div> |
261 | 261 | <div class='col-2'> |
262 | 262 | <button class="btn btn-primary task-define" data-task="clean_orphan_objects_task"> |
@@ -278,7 +278,7 @@ discard block |
||
278 | 278 | $task = isset($SETTINGS['purge_temporary_files_task']) === true ? explode(";", $SETTINGS['purge_temporary_files_task']) : []; |
279 | 279 | ?> |
280 | 280 | <input type='text' disabled class='form-control form-control-sm' id='purge_temporary_files_task_parameter' value='<?php echo isset($task[0]) === true && empty($task[0]) === false ? $lang->get($task[0])." ".(isset($task[2]) === true ? strtolower($lang->get('day')).' '.$task[2].' ' : '').$lang->get('at')." ".(isset($task[1]) === true ? $task[1] : '') : $lang->get('not_defined') ?>'> |
281 | - <input type='hidden' disabled class='form-control form-control-sm' id='purge_temporary_files_task_parameter_value' value='<?php echo isset($task[0]) === true ? $task[0].";".(isset($task[1]) === true ? $task[1] : '').(isset($task[2]) === true ? $task[2] : '') : '';?>'> |
|
281 | + <input type='hidden' disabled class='form-control form-control-sm' id='purge_temporary_files_task_parameter_value' value='<?php echo isset($task[0]) === true ? $task[0].";".(isset($task[1]) === true ? $task[1] : '').(isset($task[2]) === true ? $task[2] : '') : ''; ?>'> |
|
282 | 282 | </div> |
283 | 283 | <div class='col-2'> |
284 | 284 | <button class="btn btn-primary task-define" data-task="purge_temporary_files_task"> |
@@ -300,7 +300,7 @@ discard block |
||
300 | 300 | $task = isset($SETTINGS['reload_cache_table_task']) === true ? explode(";", $SETTINGS['reload_cache_table_task']) : []; |
301 | 301 | ?> |
302 | 302 | <input type='text' disabled class='form-control form-control-sm' id='reload_cache_table_task_parameter' value='<?php echo isset($task[0]) === true && empty($task[0]) === false ? $lang->get($task[0])." ".(isset($task[2]) === true ? strtolower($lang->get('day')).' '.$task[2].' ' : '').$lang->get('at')." ".(isset($task[1]) === true ? $task[1] : '') : $lang->get('not_defined') ?>'> |
303 | - <input type='hidden' disabled class='form-control form-control-sm' id='reload_cache_table_task_parameter_value' value='<?php echo isset($task[0]) === true ? $task[0].";".(isset($task[1]) === true ? $task[1] : '').(isset($task[2]) === true ? $task[2] : '') : '';?>'> |
|
303 | + <input type='hidden' disabled class='form-control form-control-sm' id='reload_cache_table_task_parameter_value' value='<?php echo isset($task[0]) === true ? $task[0].";".(isset($task[1]) === true ? $task[1] : '').(isset($task[2]) === true ? $task[2] : '') : ''; ?>'> |
|
304 | 304 | </div> |
305 | 305 | <div class='col-2'> |
306 | 306 | <button class="btn btn-primary task-define" data-task="reload_cache_table_task"> |
@@ -517,7 +517,7 @@ discard block |
||
517 | 517 | <h5><?php echo $lang->get('day_of_month'); ?></h5> |
518 | 518 | <select class='form-control form-control-sm no-save' id='task-define-modal-parameter-monthly-value' style="width:100%;"> |
519 | 519 | <?php |
520 | - for ($i=1; $i<=31; $i++) { |
|
520 | + for ($i = 1; $i <= 31; $i++) { |
|
521 | 521 | echo '<option value="'.$i.'">'.$lang->get('day').' '.$i.'</option>'; |
522 | 522 | } |
523 | 523 | ?> |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | || isset($SETTINGS['allow_import']) === false || (int) $SETTINGS['allow_import'] !== 1) { |
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 | |
@@ -183,7 +183,7 @@ discard block |
||
183 | 183 | <?php |
184 | 184 | $complexitySelect = ''; |
185 | 185 | foreach (TP_PW_COMPLEXITY as $level) { |
186 | - $complexitySelect .= '<option value="' . $level[0] . '">' . $level[1] . '</option>'; |
|
186 | + $complexitySelect .= '<option value="'.$level[0].'">'.$level[1].'</option>'; |
|
187 | 187 | } |
188 | 188 | echo $complexitySelect; |
189 | 189 | ?> |
@@ -72,7 +72,7 @@ discard block |
||
72 | 72 | if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('import') === 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 | ?> |
@@ -1043,7 +1043,7 @@ discard block |
||
1043 | 1043 | // Isolate first item |
1044 | 1044 | if (itemsList.length > 0) { |
1045 | 1045 | $('#import-feedback-progress-text') |
1046 | - .html('<i class="fa-solid fa-cog fa-spin ml-4 mr-2"></i><?php echo $lang->get('operation_progress');?> ('+((counter*100)/itemsNumber).toFixed(2)+'%) - <i id="item-title"></i>'); |
|
1046 | + .html('<i class="fa-solid fa-cog fa-spin ml-4 mr-2"></i><?php echo $lang->get('operation_progress'); ?> ('+((counter*100)/itemsNumber).toFixed(2)+'%) - <i id="item-title"></i>'); |
|
1047 | 1047 | |
1048 | 1048 | // XSS Filtering : |
1049 | 1049 | $('#import-feedback-progress-text').text(itemsList[0].Title); |
@@ -29,7 +29,7 @@ discard block |
||
29 | 29 | trait ItemHandlerTrait { |
30 | 30 | |
31 | 31 | private function generateUserPasswordKeys($arguments) { |
32 | - if (LOG_TASKS=== true) $this->logger->log('Processing generateUserPasswordKeys : '.print_r($arguments, true), 'DEBUG'); |
|
32 | + if (LOG_TASKS === true) $this->logger->log('Processing generateUserPasswordKeys : '.print_r($arguments, true), 'DEBUG'); |
|
33 | 33 | // Generate keys for user passwords |
34 | 34 | storeUsersShareKey( |
35 | 35 | prefixTable('sharekeys_items'), |
@@ -49,8 +49,8 @@ discard block |
||
49 | 49 | * @param array $taskData |
50 | 50 | */ |
51 | 51 | private function generateUserFileKeys($taskData) { |
52 | - if (LOG_TASKS=== true) $this->logger->log('Processing generateUserFileKeys : '.print_r($taskData, true), 'DEBUG'); |
|
53 | - foreach($taskData['files_keys'] as $file) { |
|
52 | + if (LOG_TASKS === true) $this->logger->log('Processing generateUserFileKeys : '.print_r($taskData, true), 'DEBUG'); |
|
53 | + foreach ($taskData['files_keys'] as $file) { |
|
54 | 54 | storeUsersShareKey( |
55 | 55 | prefixTable('sharekeys_files'), |
56 | 56 | 0, |
@@ -70,9 +70,9 @@ discard block |
||
70 | 70 | * @param array $arguments |
71 | 71 | */ |
72 | 72 | private function generateUserFieldKeys($arguments) { |
73 | - if (LOG_TASKS=== true) $this->logger->log('Processing generateUserFieldKeys : '.print_r($arguments, true), 'DEBUG'); |
|
74 | - foreach($arguments['fields_keys'] as $field) { |
|
75 | - $this->logger->log('Processing generateUserFieldKeys for: ' . $field['object_id'], 'DEBUG'); |
|
73 | + if (LOG_TASKS === true) $this->logger->log('Processing generateUserFieldKeys : '.print_r($arguments, true), 'DEBUG'); |
|
74 | + foreach ($arguments['fields_keys'] as $field) { |
|
75 | + $this->logger->log('Processing generateUserFieldKeys for: '.$field['object_id'], 'DEBUG'); |
|
76 | 76 | storeUsersShareKey( |
77 | 77 | prefixTable('sharekeys_fields'), |
78 | 78 | 0, |
@@ -80,7 +80,7 @@ discard block |
||
80 | 80 | //get through all users with enabled personnal folder. |
81 | 81 | $users = DB::query( |
82 | 82 | 'SELECT id, login, email |
83 | - FROM ' . prefixTable('users') . ' |
|
83 | + FROM ' . prefixTable('users').' |
|
84 | 84 | WHERE id NOT IN ('.OTV_USER_ID.', '.TP_USER_ID.', '.SSH_USER_ID.', '.API_USER_ID.') |
85 | 85 | AND personal_folder = 1 |
86 | 86 | ORDER BY login ASC' |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | //if folder doesn't exist then create it |
90 | 90 | $data = DB::queryFirstRow( |
91 | 91 | 'SELECT id |
92 | - FROM ' . prefixTable('nested_tree') . ' |
|
92 | + FROM ' . prefixTable('nested_tree').' |
|
93 | 93 | WHERE title = %s AND parent_id = %i', |
94 | 94 | $user['id'], |
95 | 95 | 0 |
@@ -72,7 +72,7 @@ discard block |
||
72 | 72 | // get count of Items in this folder |
73 | 73 | $get = DB::queryFirstRow( |
74 | 74 | 'SELECT count(*) as num_results |
75 | - FROM ' . prefixTable('items') . ' |
|
75 | + FROM ' . prefixTable('items').' |
|
76 | 76 | WHERE inactif = %i AND id_tree = %i', |
77 | 77 | 0, |
78 | 78 | $child->id |
@@ -81,14 +81,14 @@ discard block |
||
81 | 81 | $ret[$child->id]['id'] = $child->id; |
82 | 82 | |
83 | 83 | // get number of subfolders |
84 | - $nodeDescendants =$tree->getDescendants($child->id, false, false, true); |
|
84 | + $nodeDescendants = $tree->getDescendants($child->id, false, false, true); |
|
85 | 85 | $ret[$child->id]['subfoldersCount'] = count($nodeDescendants); |
86 | 86 | |
87 | 87 | // get items number in subfolders |
88 | 88 | if (count($nodeDescendants) > 0) { |
89 | 89 | $get = DB::queryFirstRow( |
90 | 90 | 'SELECT count(*) as num_results |
91 | - FROM ' . prefixTable('items') . ' |
|
91 | + FROM ' . prefixTable('items').' |
|
92 | 92 | WHERE inactif = %i AND id_tree IN (%l)', |
93 | 93 | 0, |
94 | 94 | implode(',', $nodeDescendants) |
@@ -139,7 +139,7 @@ discard block |
||
139 | 139 | // Get item key |
140 | 140 | $itemKey = DB::queryFirstRow( |
141 | 141 | 'SELECT share_key |
142 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
142 | + FROM ' . prefixTable('sharekeys_items').' |
|
143 | 143 | WHERE user_id = %i AND object_id = %i', |
144 | 144 | TP_USER_ID, |
145 | 145 | $item['itemId'] |
@@ -76,7 +76,7 @@ discard block |
||
76 | 76 | ) { |
77 | 77 | // Not allowed page |
78 | 78 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
79 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
79 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
80 | 80 | exit; |
81 | 81 | } |
82 | 82 | |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | |
169 | 169 | // Output |
170 | 170 | $sOutput = '{'; |
171 | - $sOutput .= '"sEcho": '. $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
171 | + $sOutput .= '"sEcho": '.$request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
172 | 172 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
173 | 173 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
174 | 174 | $sOutput .= '"aaData": '; |
@@ -241,7 +241,7 @@ discard block |
||
241 | 241 | |
242 | 242 | // Output |
243 | 243 | $sOutput = '{'; |
244 | - $sOutput .= '"sEcho": '. $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
244 | + $sOutput .= '"sEcho": '.$request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
245 | 245 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
246 | 246 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
247 | 247 | $sOutput .= '"aaData": '; |
@@ -314,7 +314,7 @@ discard block |
||
314 | 314 | |
315 | 315 | // Output |
316 | 316 | $sOutput = '{'; |
317 | - $sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
317 | + $sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
318 | 318 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
319 | 319 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
320 | 320 | $sOutput .= '"aaData": '; |
@@ -387,7 +387,7 @@ discard block |
||
387 | 387 | |
388 | 388 | // Output |
389 | 389 | $sOutput = '{'; |
390 | - $sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
390 | + $sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
391 | 391 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
392 | 392 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
393 | 393 | $sOutput .= '"aaData": [ '; |
@@ -490,7 +490,7 @@ discard block |
||
490 | 490 | |
491 | 491 | // Output |
492 | 492 | $sOutput = '{'; |
493 | - $sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
493 | + $sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
494 | 494 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
495 | 495 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
496 | 496 | $sOutput .= '"aaData": [ '; |
@@ -572,7 +572,7 @@ discard block |
||
572 | 572 | $iTotal = 0; |
573 | 573 | } |
574 | 574 | $sOutput = '{'; |
575 | - $sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
575 | + $sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
576 | 576 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
577 | 577 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
578 | 578 | $sOutput .= '"aaData": '; |
@@ -648,7 +648,7 @@ discard block |
||
648 | 648 | |
649 | 649 | // Output |
650 | 650 | $sOutput = '{'; |
651 | - $sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
651 | + $sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
652 | 652 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
653 | 653 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
654 | 654 | $sOutput .= '"aaData": '; |
@@ -717,7 +717,7 @@ discard block |
||
717 | 717 | |
718 | 718 | // Output |
719 | 719 | $sOutput = '{'; |
720 | - $sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
720 | + $sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
721 | 721 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
722 | 722 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
723 | 723 | $sOutput .= '"aaData": '; |
@@ -790,7 +790,7 @@ discard block |
||
790 | 790 | |
791 | 791 | // Output |
792 | 792 | $sOutput = '{'; |
793 | - $sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
793 | + $sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
794 | 794 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
795 | 795 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
796 | 796 | $sOutput .= '"aaData": '; |
@@ -867,7 +867,7 @@ discard block |
||
867 | 867 | FROM '.prefixTable('background_tasks').' AS p |
868 | 868 | LEFT JOIN '.prefixTable('users').' AS u ON %l |
869 | 869 | WHERE %l ORDER BY %l %l LIMIT %i, %i'; |
870 | - $params = ['u.id = json_extract(p.arguments, "$[0]")',$sWhere, $orderColumn, $orderDirection, $sLimitStart, $sLimitLength]; |
|
870 | + $params = ['u.id = json_extract(p.arguments, "$[0]")', $sWhere, $orderColumn, $orderDirection, $sLimitStart, $sLimitLength]; |
|
871 | 871 | |
872 | 872 | // Get the records |
873 | 873 | $rows = DB::query($sql, ...$params); |
@@ -875,7 +875,7 @@ discard block |
||
875 | 875 | |
876 | 876 | // Output |
877 | 877 | $sOutput = '{'; |
878 | - $sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
878 | + $sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
879 | 879 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
880 | 880 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
881 | 881 | $sOutput .= '"aaData": '; |
@@ -890,7 +890,7 @@ discard block |
||
890 | 890 | //col1 |
891 | 891 | $sOutput .= '"<span data-done=\"'.$record['is_in_progress'].'\" data-type=\"'.$record['process_type'].'\" data-process-id=\"'.$record['increment_id'].'\"></span>", '; |
892 | 892 | //col2 |
893 | - $sOutput .= '"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['created_at']).'", '; |
|
893 | + $sOutput .= '"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['created_at']).'", '; |
|
894 | 894 | //col3 |
895 | 895 | //$sOutput .= '"'.($record['updated_at'] === '' ? '-' : date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['updated_at'])).'", '; |
896 | 896 | $sOutput .= '"<div class=\"progress mt-2\"><div class=\"progress-bar\" style=\"width: '.$subtaskProgress.'\">'.$subtaskProgress.'</div></div>", '; |
@@ -900,7 +900,7 @@ discard block |
||
900 | 900 | // col5 |
901 | 901 | if (in_array($record['process_type'], array('create_user_keys', 'item_copy')) === true) { |
902 | 902 | $data_user = DB::queryFirstRow( |
903 | - 'SELECT name, lastname FROM ' . prefixTable('users') . ' |
|
903 | + 'SELECT name, lastname FROM '.prefixTable('users').' |
|
904 | 904 | WHERE id = %i', |
905 | 905 | json_decode($record['arguments'], true)['new_user_id'] |
906 | 906 | ); |
@@ -956,7 +956,7 @@ discard block |
||
956 | 956 | FROM '.prefixTable('background_tasks').' AS p |
957 | 957 | LEFT JOIN '.prefixTable('users').' AS u ON %l |
958 | 958 | WHERE %l ORDER BY %l %l LIMIT %i, %i'; |
959 | - $params = ['u.id = json_extract(p.arguments, "$[0]")',$sWhere, $orderColumn, $orderDirection, $sLimitStart, $sLimitLength]; |
|
959 | + $params = ['u.id = json_extract(p.arguments, "$[0]")', $sWhere, $orderColumn, $orderDirection, $sLimitStart, $sLimitLength]; |
|
960 | 960 | |
961 | 961 | // Get the records |
962 | 962 | $rows = DB::query($sql, ...$params); |
@@ -964,7 +964,7 @@ discard block |
||
964 | 964 | |
965 | 965 | // Output |
966 | 966 | $sOutput = '{'; |
967 | - $sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
967 | + $sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
968 | 968 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
969 | 969 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
970 | 970 | $sOutput .= '"aaData": '; |
@@ -980,13 +980,12 @@ discard block |
||
980 | 980 | //col1 |
981 | 981 | $sOutput .= '"'.(is_null($record['error_message']) ? '' : addslashes($record['error_message'])).'", '; |
982 | 982 | //col2 |
983 | - $sOutput .= '"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['created_at']).'", '; |
|
983 | + $sOutput .= '"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['created_at']).'", '; |
|
984 | 984 | //col3 |
985 | 985 | $sOutput .= is_null($record['started_at']) === false ? |
986 | - ('"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['started_at']).'", ') : |
|
987 | - ('"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['created_at']).'", '); |
|
986 | + ('"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['started_at']).'", ') : ('"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['created_at']).'", '); |
|
988 | 987 | //col4 |
989 | - $sOutput .= '"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['finished_at']).'", '; |
|
988 | + $sOutput .= '"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['finished_at']).'", '; |
|
990 | 989 | // col7 |
991 | 990 | $sOutput .= '"'.gmdate('H:i:s', (int) $record['finished_at'] - (is_null($record['started_at']) === false ? (int) $record['started_at'] : (int) $record['created_at'])).'",'; |
992 | 991 | //col5 |
@@ -1009,11 +1008,10 @@ discard block |
||
1009 | 1008 | // col6 |
1010 | 1009 | $arguments = json_decode($record['arguments'], true); |
1011 | 1010 | $newUserId = array_key_exists('new_user_id', $arguments) ? |
1012 | - $arguments['new_user_id'] : |
|
1013 | - (array_key_exists('user_id', $arguments) ? $arguments['user_id'] : null); |
|
1011 | + $arguments['new_user_id'] : (array_key_exists('user_id', $arguments) ? $arguments['user_id'] : null); |
|
1014 | 1012 | if ($record['process_type'] === 'create_user_keys' && is_null($newUserId) === false && empty($newUserId) === false) { |
1015 | 1013 | $data_user = DB::queryFirstRow( |
1016 | - 'SELECT name, lastname, login FROM ' . prefixTable('users') . ' |
|
1014 | + 'SELECT name, lastname, login FROM '.prefixTable('users').' |
|
1017 | 1015 | WHERE id = %i', |
1018 | 1016 | $newUserId |
1019 | 1017 | ); |
@@ -1029,7 +1027,7 @@ discard block |
||
1029 | 1027 | } elseif ($record['process_type'] === 'user_build_cache_tree') { |
1030 | 1028 | $user = json_decode($record['arguments'], true)['user_id']; |
1031 | 1029 | $data_user = DB::queryFirstRow( |
1032 | - 'SELECT name, lastname, login FROM ' . prefixTable('users') . ' |
|
1030 | + 'SELECT name, lastname, login FROM '.prefixTable('users').' |
|
1033 | 1031 | WHERE id = %i', |
1034 | 1032 | $user |
1035 | 1033 | ); |
@@ -1063,7 +1061,7 @@ discard block |
||
1063 | 1061 | { |
1064 | 1062 | $subtasks = DB::query( |
1065 | 1063 | 'SELECT * |
1066 | - FROM ' . prefixTable('background_subtasks') . ' |
|
1064 | + FROM ' . prefixTable('background_subtasks').' |
|
1067 | 1065 | WHERE task_id = %i', |
1068 | 1066 | $id |
1069 | 1067 | ); |
@@ -1079,5 +1077,5 @@ discard block |
||
1079 | 1077 | $i++; |
1080 | 1078 | } |
1081 | 1079 | |
1082 | - return ($finished_nb !== 0 ? pourcentage($finished_nb, $nb, 100) : 0) .'%'; |
|
1080 | + return ($finished_nb !== 0 ? pourcentage($finished_nb, $nb, 100) : 0).'%'; |
|
1083 | 1081 | } |
1084 | 1082 | \ No newline at end of file |