@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | require_once __DIR__.'/traits/ItemHandlerTrait.php'; |
33 | 33 | require_once __DIR__.'/traits/UserHandlerTrait.php'; |
34 | 34 | require_once __DIR__.'/traits/EmailTrait.php'; |
35 | -require_once __DIR__ . '/taskLogger.php'; |
|
35 | +require_once __DIR__.'/taskLogger.php'; |
|
36 | 36 | |
37 | 37 | class TaskWorker { |
38 | 38 | use ItemHandlerTrait; |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | */ |
65 | 65 | public function execute() { |
66 | 66 | try { |
67 | - if (LOG_TASKS=== true) $this->logger->log('Processing task: ' . print_r($this->taskData, true), 'DEBUG'); |
|
67 | + if (LOG_TASKS === true) $this->logger->log('Processing task: '.print_r($this->taskData, true), 'DEBUG'); |
|
68 | 68 | // Dispatch selon le type de processus |
69 | 69 | switch ($this->processType) { |
70 | 70 | case 'item_copy': |
@@ -136,7 +136,7 @@ discard block |
||
136 | 136 | $arguments = ''; |
137 | 137 | } |
138 | 138 | |
139 | - if (LOG_TASKS=== true) $this->logger->log('Process: '.$this->processType.' -- '.print_r($arguments, true), 'DEBUG'); |
|
139 | + if (LOG_TASKS === true) $this->logger->log('Process: '.$this->processType.' -- '.print_r($arguments, true), 'DEBUG'); |
|
140 | 140 | |
141 | 141 | // Add 'arguments' only if not empty |
142 | 142 | if (!empty($arguments)) { |
@@ -150,7 +150,7 @@ discard block |
||
150 | 150 | 'increment_id = %i', |
151 | 151 | $this->taskId |
152 | 152 | ); |
153 | - if (LOG_TASKS=== true) $this->logger->log('Finishing task: ' . $this->taskId, 'DEBUG'); |
|
153 | + if (LOG_TASKS === true) $this->logger->log('Finishing task: '.$this->taskId, 'DEBUG'); |
|
154 | 154 | } |
155 | 155 | |
156 | 156 | /** |
@@ -173,7 +173,7 @@ discard block |
||
173 | 173 | 'increment_id = %i', |
174 | 174 | $this->taskId |
175 | 175 | ); |
176 | - $this->logger->log('Task failure: ' . $e->getMessage(), 'ERROR'); |
|
176 | + $this->logger->log('Task failure: '.$e->getMessage(), 'ERROR'); |
|
177 | 177 | } |
178 | 178 | |
179 | 179 | /** |
@@ -185,16 +185,16 @@ discard block |
||
185 | 185 | * @return void |
186 | 186 | */ |
187 | 187 | private function processSubTasks($arguments) { |
188 | - if (LOG_TASKS=== true) $this->logger->log('processSubTasks: '.print_r($arguments, true), 'DEBUG'); |
|
188 | + if (LOG_TASKS === true) $this->logger->log('processSubTasks: '.print_r($arguments, true), 'DEBUG'); |
|
189 | 189 | // Get all subtasks related to this task |
190 | 190 | $subtasks = DB::query( |
191 | - 'SELECT * FROM ' . prefixTable('background_subtasks') . ' WHERE task_id = %i AND is_in_progress = 0 ORDER BY `task` ASC', |
|
191 | + 'SELECT * FROM '.prefixTable('background_subtasks').' WHERE task_id = %i AND is_in_progress = 0 ORDER BY `task` ASC', |
|
192 | 192 | $this->taskId |
193 | 193 | ); |
194 | 194 | |
195 | 195 | // Check if there are any subtasks to process |
196 | 196 | if (empty($subtasks)) { |
197 | - if (LOG_TASKS=== true) $this->logger->log('No subtask was found for task: ' . $this->taskId, 'DEBUG'); |
|
197 | + if (LOG_TASKS === true) $this->logger->log('No subtask was found for task: '.$this->taskId, 'DEBUG'); |
|
198 | 198 | return; |
199 | 199 | } |
200 | 200 | |
@@ -204,7 +204,7 @@ discard block |
||
204 | 204 | // Get the subtask data |
205 | 205 | $subtaskData = json_decode($subtask['task'], true); |
206 | 206 | |
207 | - if (LOG_TASKS=== true) $this->logger->log('Processing subtask: ' . $subtaskData['step'], 'DEBUG'); |
|
207 | + if (LOG_TASKS === true) $this->logger->log('Processing subtask: '.$subtaskData['step'], 'DEBUG'); |
|
208 | 208 | |
209 | 209 | // Process the subtask based on its type |
210 | 210 | switch ($subtaskData['step'] ?? '') { |
@@ -248,13 +248,13 @@ discard block |
||
248 | 248 | $subtask['increment_id'] |
249 | 249 | ); |
250 | 250 | |
251 | - $this->logger->log('processSubTasks : ' . $e->getMessage(), 'ERROR'); |
|
251 | + $this->logger->log('processSubTasks : '.$e->getMessage(), 'ERROR'); |
|
252 | 252 | } |
253 | 253 | } |
254 | 254 | |
255 | 255 | // Are all subtasks completed? |
256 | 256 | $remainingSubtasks = DB::queryFirstField( |
257 | - 'SELECT COUNT(*) FROM ' . prefixTable('background_subtasks') . ' WHERE task_id = %i AND is_in_progress = 0', |
|
257 | + 'SELECT COUNT(*) FROM '.prefixTable('background_subtasks').' WHERE task_id = %i AND is_in_progress = 0', |
|
258 | 258 | $this->taskId |
259 | 259 | ); |
260 | 260 | |
@@ -270,7 +270,7 @@ discard block |
||
270 | 270 | error_log("Usage: php background_tasks___worker.php <task_id> <process_type> [<task_data>]"); |
271 | 271 | exit(1); |
272 | 272 | } |
273 | -$taskId = (int)$argv[1]; |
|
273 | +$taskId = (int) $argv[1]; |
|
274 | 274 | $processType = $argv[2]; |
275 | 275 | $taskData = $argv[3] ?? null; |
276 | 276 | if ($taskData) { |
@@ -30,7 +30,7 @@ discard block |
||
30 | 30 | use TeampassClasses\ConfigManager\ConfigManager; |
31 | 31 | |
32 | 32 | require_once __DIR__.'/../sources/main.functions.php'; |
33 | -require_once __DIR__ . '/taskLogger.php'; |
|
33 | +require_once __DIR__.'/taskLogger.php'; |
|
34 | 34 | |
35 | 35 | class BackgroundTasksHandler { |
36 | 36 | private $settings; |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | public function processBackgroundTasks() { |
56 | 56 | // Prevent multiple concurrent executions |
57 | 57 | if (!$this->acquireProcessLock()) { |
58 | - if (LOG_TASKS=== true) $this->logger->log('Process already running', 'INFO'); |
|
58 | + if (LOG_TASKS === true) $this->logger->log('Process already running', 'INFO'); |
|
59 | 59 | return false; |
60 | 60 | } |
61 | 61 | |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | $this->processTaskBatches(); |
65 | 65 | $this->performMaintenanceTasks(); |
66 | 66 | } catch (Exception $e) { |
67 | - if (LOG_TASKS=== true) $this->logger->log('Task processing error: ' . $e->getMessage(), 'ERROR'); |
|
67 | + if (LOG_TASKS === true) $this->logger->log('Task processing error: '.$e->getMessage(), 'ERROR'); |
|
68 | 68 | } finally { |
69 | 69 | $this->releaseProcessLock(); |
70 | 70 | } |
@@ -83,7 +83,7 @@ discard block |
||
83 | 83 | return false; |
84 | 84 | } |
85 | 85 | |
86 | - fwrite($fp, (string)getmypid()); |
|
86 | + fwrite($fp, (string) getmypid()); |
|
87 | 87 | return true; |
88 | 88 | } |
89 | 89 | |
@@ -101,7 +101,7 @@ discard block |
||
101 | 101 | private function cleanupStaleTasks() { |
102 | 102 | // Mark tasks as failed if they've been running too long |
103 | 103 | DB::query( |
104 | - 'UPDATE ' . prefixTable('background_tasks') . ' |
|
104 | + 'UPDATE '.prefixTable('background_tasks').' |
|
105 | 105 | SET is_in_progress = -1, |
106 | 106 | finished_at = %i, |
107 | 107 | status = "failed" |
@@ -113,8 +113,8 @@ discard block |
||
113 | 113 | |
114 | 114 | // Remove very old failed tasks |
115 | 115 | DB::query( |
116 | - 'DELETE t, st FROM ' . prefixTable('background_tasks') . ' t |
|
117 | - INNER JOIN ' . prefixTable('background_subtasks') . ' st ON (t.increment_id = st.task_id) |
|
116 | + 'DELETE t, st FROM '.prefixTable('background_tasks').' t |
|
117 | + INNER JOIN ' . prefixTable('background_subtasks').' st ON (t.increment_id = st.task_id) |
|
118 | 118 | WHERE t.finished_at > %i |
119 | 119 | AND t.status = %s', |
120 | 120 | time() - $this->maxTimeBeforeRemoval, |
@@ -131,7 +131,7 @@ discard block |
||
131 | 131 | |
132 | 132 | // Check if the maximum number of parallel tasks is reached |
133 | 133 | if ($runningTasks >= $this->maxParallelTasks) { |
134 | - if (LOG_TASKS=== true) $this->logger->log('Wait ... '.$runningTasks.' out of '.$this->maxParallelTasks.' are already running ', 'INFO'); |
|
134 | + if (LOG_TASKS === true) $this->logger->log('Wait ... '.$runningTasks.' out of '.$this->maxParallelTasks.' are already running ', 'INFO'); |
|
135 | 135 | return; |
136 | 136 | } |
137 | 137 | |
@@ -140,7 +140,7 @@ discard block |
||
140 | 140 | // Fetch next batch of tasks |
141 | 141 | $tasks = DB::query( |
142 | 142 | 'SELECT increment_id, process_type, arguments |
143 | - FROM ' . prefixTable('background_tasks') . ' |
|
143 | + FROM ' . prefixTable('background_tasks').' |
|
144 | 144 | WHERE is_in_progress = 0 |
145 | 145 | AND (finished_at IS NULL OR finished_at = "") |
146 | 146 | ORDER BY increment_id ASC |
@@ -149,7 +149,7 @@ discard block |
||
149 | 149 | ); |
150 | 150 | |
151 | 151 | foreach ($tasks as $task) { |
152 | - if (LOG_TASKS=== true) $this->logger->log('Launching '.$task['increment_id'], 'INFO'); |
|
152 | + if (LOG_TASKS === true) $this->logger->log('Launching '.$task['increment_id'], 'INFO'); |
|
153 | 153 | $this->processIndividualTask($task); |
154 | 154 | } |
155 | 155 | } |
@@ -160,7 +160,7 @@ discard block |
||
160 | 160 | * @param array $task The task to process. |
161 | 161 | */ |
162 | 162 | private function processIndividualTask(array $task) { |
163 | - if (LOG_TASKS=== true) $this->logger->log('Starting task: ' . print_r($task, true), 'INFO'); |
|
163 | + if (LOG_TASKS === true) $this->logger->log('Starting task: '.print_r($task, true), 'INFO'); |
|
164 | 164 | |
165 | 165 | // Store progress in the database |
166 | 166 | DB::update( |
@@ -177,18 +177,18 @@ discard block |
||
177 | 177 | // Prepare process |
178 | 178 | $process = new Process([ |
179 | 179 | PHP_BINARY, |
180 | - __DIR__ . '/background_tasks___worker.php', |
|
180 | + __DIR__.'/background_tasks___worker.php', |
|
181 | 181 | $task['increment_id'], |
182 | 182 | $task['process_type'], |
183 | 183 | $task['arguments'] |
184 | 184 | ]); |
185 | 185 | |
186 | 186 | // Launch process |
187 | - try{ |
|
187 | + try { |
|
188 | 188 | $process->mustRun(); |
189 | 189 | |
190 | 190 | } catch (Exception $e) { |
191 | - if (LOG_TASKS=== true) $this->logger->log('Error launching task: ' . $e->getMessage(), 'ERROR'); |
|
191 | + if (LOG_TASKS === true) $this->logger->log('Error launching task: '.$e->getMessage(), 'ERROR'); |
|
192 | 192 | DB::update( |
193 | 193 | prefixTable('background_tasks'), |
194 | 194 | [ |
@@ -209,7 +209,7 @@ discard block |
||
209 | 209 | private function countRunningTasks(): int { |
210 | 210 | return DB::queryFirstField( |
211 | 211 | 'SELECT COUNT(*) |
212 | - FROM ' . prefixTable('background_tasks') . ' |
|
212 | + FROM ' . prefixTable('background_tasks').' |
|
213 | 213 | WHERE is_in_progress = 1' |
214 | 214 | ); |
215 | 215 | } |
@@ -230,10 +230,10 @@ discard block |
||
230 | 230 | */ |
231 | 231 | private function cleanMultipleItemsEdition() { |
232 | 232 | DB::query( |
233 | - 'DELETE i1 FROM ' . prefixTable('items_edition') . ' i1 |
|
233 | + 'DELETE i1 FROM '.prefixTable('items_edition').' i1 |
|
234 | 234 | JOIN ( |
235 | 235 | SELECT user_id, item_id, MIN(timestamp) AS oldest_timestamp |
236 | - FROM ' . prefixTable('items_edition') . ' |
|
236 | + FROM ' . prefixTable('items_edition').' |
|
237 | 237 | GROUP BY user_id, item_id |
238 | 238 | ) i2 ON i1.user_id = i2.user_id AND i1.item_id = i2.item_id |
239 | 239 | WHERE i1.timestamp > i2.oldest_timestamp' |
@@ -246,7 +246,7 @@ discard block |
||
246 | 246 | */ |
247 | 247 | private function handleItemTokensExpiration() { |
248 | 248 | DB::query( |
249 | - 'DELETE FROM ' . prefixTable('items_edition') . ' |
|
249 | + 'DELETE FROM '.prefixTable('items_edition').' |
|
250 | 250 | WHERE timestamp < %i', |
251 | 251 | time() - ($this->settings['delay_item_edition'] * 60 ?: EDITION_LOCK_PERIOD) |
252 | 252 | ); |
@@ -263,7 +263,7 @@ discard block |
||
263 | 263 | // 1. Get all finished tasks older than the cutoff timestamp |
264 | 264 | // and that are not in progress |
265 | 265 | $tasks = DB::query( |
266 | - 'SELECT increment_id FROM ' . prefixTable('background_tasks') . ' |
|
266 | + 'SELECT increment_id FROM '.prefixTable('background_tasks').' |
|
267 | 267 | WHERE status = %s AND is_in_progress = %i AND finished_at < %s', |
268 | 268 | 'completed', |
269 | 269 | -1, |
@@ -278,19 +278,19 @@ discard block |
||
278 | 278 | |
279 | 279 | // 2. Delete all subtasks related to these tasks |
280 | 280 | DB::query( |
281 | - 'DELETE FROM ' . prefixTable('background_subtasks') . ' |
|
281 | + 'DELETE FROM '.prefixTable('background_subtasks').' |
|
282 | 282 | WHERE task_id IN %ls', |
283 | 283 | $taskIds |
284 | 284 | ); |
285 | 285 | |
286 | 286 | // 3. Delete the tasks themselves |
287 | 287 | DB::query( |
288 | - 'DELETE FROM ' . prefixTable('background_tasks') . ' |
|
288 | + 'DELETE FROM '.prefixTable('background_tasks').' |
|
289 | 289 | WHERE increment_id IN %ls', |
290 | 290 | $taskIds |
291 | 291 | ); |
292 | 292 | |
293 | - if (LOG_TASKS=== true) $this->logger->log('Old finished tasks cleaned: ' . count($taskIds), 'INFO'); |
|
293 | + if (LOG_TASKS === true) $this->logger->log('Old finished tasks cleaned: '.count($taskIds), 'INFO'); |
|
294 | 294 | } |
295 | 295 | } |
296 | 296 | |
@@ -304,5 +304,5 @@ discard block |
||
304 | 304 | $tasksHandler = new BackgroundTasksHandler($settings); |
305 | 305 | $tasksHandler->processBackgroundTasks(); |
306 | 306 | } catch (Exception $e) { |
307 | - error_log('Teampass Background Tasks Error: ' . $e->getMessage()); |
|
307 | + error_log('Teampass Background Tasks Error: '.$e->getMessage()); |
|
308 | 308 | } |
309 | 309 | \ No newline at end of file |
@@ -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 | |
@@ -324,7 +324,7 @@ discard block |
||
324 | 324 | * @param string $post_key |
325 | 325 | * @return string |
326 | 326 | */ |
327 | -function userHandler(string $post_type, array|null|string $dataReceived, array $SETTINGS, string $post_key): string |
|
327 | +function userHandler(string $post_type, array | null | string $dataReceived, array $SETTINGS, string $post_key): string |
|
328 | 328 | { |
329 | 329 | $session = SessionManager::getSession(); |
330 | 330 | |
@@ -359,7 +359,7 @@ discard block |
||
359 | 359 | if (isset($dataReceived['user_id'])) { |
360 | 360 | // Get info about user to modify |
361 | 361 | $targetUserInfos = DB::queryFirstRow( |
362 | - 'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM ' . prefixTable('users') . ' |
|
362 | + 'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM '.prefixTable('users').' |
|
363 | 363 | WHERE id = %i', |
364 | 364 | $dataReceived['user_id'] |
365 | 365 | ); |
@@ -508,7 +508,7 @@ discard block |
||
508 | 508 | case 'mail_me'://action_mail |
509 | 509 | // Get info about user to send email |
510 | 510 | $data_user = DB::queryFirstRow( |
511 | - 'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM ' . prefixTable('users') . ' |
|
511 | + 'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM '.prefixTable('users').' |
|
512 | 512 | WHERE email = %s', |
513 | 513 | filter_var($dataReceived['receipt'], FILTER_SANITIZE_FULL_SPECIAL_CHARS) |
514 | 514 | ); |
@@ -621,7 +621,7 @@ discard block |
||
621 | 621 | if (isset($dataReceived['user_id'])) { |
622 | 622 | // Get info about user to modify |
623 | 623 | $targetUserInfos = DB::queryFirstRow( |
624 | - 'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM ' . prefixTable('users') . ' |
|
624 | + 'SELECT admin, gestionnaire, can_manage_all_users, isAdministratedByRole FROM '.prefixTable('users').' |
|
625 | 625 | WHERE id = %i', |
626 | 626 | $dataReceived['user_id'] |
627 | 627 | ); |
@@ -700,7 +700,7 @@ discard block |
||
700 | 700 | |
701 | 701 | // Get current user hash |
702 | 702 | $userHash = DB::queryFirstRow( |
703 | - "SELECT pw FROM " . prefixtable('users') . " WHERE id = %d;", |
|
703 | + "SELECT pw FROM ".prefixtable('users')." WHERE id = %d;", |
|
704 | 704 | $session->get('user-id') |
705 | 705 | )['pw']; |
706 | 706 | |
@@ -738,7 +738,7 @@ discard block |
||
738 | 738 | |
739 | 739 | // Get current user hash |
740 | 740 | $userHash = DB::queryFirstRow( |
741 | - "SELECT pw FROM " . prefixtable('users') . " WHERE id = %d;", |
|
741 | + "SELECT pw FROM ".prefixtable('users')." WHERE id = %d;", |
|
742 | 742 | $session->get('user-id') |
743 | 743 | )['pw']; |
744 | 744 | |
@@ -782,7 +782,7 @@ discard block |
||
782 | 782 | |
783 | 783 | // Get current user hash |
784 | 784 | $userHash = DB::queryFirstRow( |
785 | - "SELECT pw FROM " . prefixtable('users') . " WHERE id = %i;", |
|
785 | + "SELECT pw FROM ".prefixtable('users')." WHERE id = %i;", |
|
786 | 786 | $session->get('user-id') |
787 | 787 | )['pw']; |
788 | 788 | |
@@ -826,7 +826,7 @@ discard block |
||
826 | 826 | * @param array $SETTINGS |
827 | 827 | * @return string |
828 | 828 | */ |
829 | -function systemHandler(string $post_type, array|null|string $dataReceived, array $SETTINGS): string |
|
829 | +function systemHandler(string $post_type, array | null | string $dataReceived, array $SETTINGS): string |
|
830 | 830 | { |
831 | 831 | $session = SessionManager::getSession(); |
832 | 832 | switch ($post_type) { |
@@ -927,7 +927,7 @@ discard block |
||
927 | 927 | ) |
928 | 928 | ); |
929 | 929 | |
930 | - return '[{"token" : "' . $token . '"}]'; |
|
930 | + return '[{"token" : "'.$token.'"}]'; |
|
931 | 931 | |
932 | 932 | /* |
933 | 933 | * Default case |
@@ -943,7 +943,7 @@ discard block |
||
943 | 943 | } |
944 | 944 | |
945 | 945 | |
946 | -function utilsHandler(string $post_type, array|null|string $dataReceived, array $SETTINGS): string |
|
946 | +function utilsHandler(string $post_type, array | null | string $dataReceived, array $SETTINGS): string |
|
947 | 947 | { |
948 | 948 | switch ($post_type) { |
949 | 949 | /* |
@@ -1012,7 +1012,7 @@ discard block |
||
1012 | 1012 | array( |
1013 | 1013 | 'error' => false, |
1014 | 1014 | 'timestamp' => $session->get('user-session_duration'), |
1015 | - 'max_time_to_add' => intdiv((($maximum_session_expiration_time*60) - ((int) $session->get('user-session_duration') - time())), 60), |
|
1015 | + 'max_time_to_add' => intdiv((($maximum_session_expiration_time * 60) - ((int) $session->get('user-session_duration') - time())), 60), |
|
1016 | 1016 | 'max_session_duration' => $maximum_session_expiration_time, |
1017 | 1017 | ), |
1018 | 1018 | 'encode' |
@@ -1064,7 +1064,7 @@ discard block |
||
1064 | 1064 | // get number of items |
1065 | 1065 | DB::queryFirstRow( |
1066 | 1066 | 'SELECT increment_id |
1067 | - FROM ' . prefixTable('sharekeys_items') . |
|
1067 | + FROM ' . prefixTable('sharekeys_items'). |
|
1068 | 1068 | ' WHERE user_id = %i', |
1069 | 1069 | $userId |
1070 | 1070 | ); |
@@ -1119,7 +1119,7 @@ discard block |
||
1119 | 1119 | // check if expected security level is reached |
1120 | 1120 | $dataUser = DB::queryFirstRow( |
1121 | 1121 | 'SELECT * |
1122 | - FROM ' . prefixTable('users') . ' WHERE id = %i', |
|
1122 | + FROM ' . prefixTable('users').' WHERE id = %i', |
|
1123 | 1123 | $post_user_id |
1124 | 1124 | ); |
1125 | 1125 | |
@@ -1140,8 +1140,8 @@ discard block |
||
1140 | 1140 | if (empty($dataUser['fonction_id']) === false) { |
1141 | 1141 | $data = DB::queryFirstRow( |
1142 | 1142 | 'SELECT complexity |
1143 | - FROM ' . prefixTable('roles_title') . ' |
|
1144 | - WHERE id IN (' . $dataUser['fonction_id'] . ') |
|
1143 | + FROM ' . prefixTable('roles_title').' |
|
1144 | + WHERE id IN (' . $dataUser['fonction_id'].') |
|
1145 | 1145 | ORDER BY complexity DESC' |
1146 | 1146 | ); |
1147 | 1147 | } else { |
@@ -1154,8 +1154,8 @@ discard block |
||
1154 | 1154 | return prepareExchangedData( |
1155 | 1155 | array( |
1156 | 1156 | 'error' => true, |
1157 | - 'message' => '<div style="margin:10px 0 10px 15px;">' . $lang->get('complexity_level_not_reached') . '.<br>' . |
|
1158 | - $lang->get('expected_complexity_level') . ': <b>' . TP_PW_COMPLEXITY[$data['complexity']][1] . '</b></div>', |
|
1157 | + 'message' => '<div style="margin:10px 0 10px 15px;">'.$lang->get('complexity_level_not_reached').'.<br>'. |
|
1158 | + $lang->get('expected_complexity_level').': <b>'.TP_PW_COMPLEXITY[$data['complexity']][1].'</b></div>', |
|
1159 | 1159 | ), |
1160 | 1160 | 'encode' |
1161 | 1161 | ); |
@@ -1259,14 +1259,14 @@ discard block |
||
1259 | 1259 | // Get data about user |
1260 | 1260 | $dataUser = DB::queryFirstRow( |
1261 | 1261 | 'SELECT id, email, pw |
1262 | - FROM ' . prefixTable('users') . ' |
|
1262 | + FROM ' . prefixTable('users').' |
|
1263 | 1263 | WHERE login = %s', |
1264 | 1264 | $post_login |
1265 | 1265 | ); |
1266 | 1266 | } else { |
1267 | 1267 | $dataUser = DB::queryFirstRow( |
1268 | 1268 | 'SELECT id, login, email, pw |
1269 | - FROM ' . prefixTable('users') . ' |
|
1269 | + FROM ' . prefixTable('users').' |
|
1270 | 1270 | WHERE id = %i', |
1271 | 1271 | $post_id |
1272 | 1272 | ); |
@@ -1320,7 +1320,7 @@ discard block |
||
1320 | 1320 | // Check if token already used |
1321 | 1321 | $dataToken = DB::queryFirstRow( |
1322 | 1322 | 'SELECT end_timestamp, reason |
1323 | - FROM ' . prefixTable('tokens') . ' |
|
1323 | + FROM ' . prefixTable('tokens').' |
|
1324 | 1324 | WHERE token = %s AND user_id = %i', |
1325 | 1325 | $post_token, |
1326 | 1326 | $dataUser['id'] |
@@ -1331,11 +1331,11 @@ discard block |
||
1331 | 1331 | return prepareExchangedData( |
1332 | 1332 | array( |
1333 | 1333 | 'error' => true, |
1334 | - 'message' => 'TOKEN already used',//$lang->get('no_email_set'), |
|
1334 | + 'message' => 'TOKEN already used', //$lang->get('no_email_set'), |
|
1335 | 1335 | ), |
1336 | 1336 | 'encode' |
1337 | 1337 | ); |
1338 | - } elseif(DB::count() === 0) { |
|
1338 | + } elseif (DB::count() === 0) { |
|
1339 | 1339 | // Store token for this action |
1340 | 1340 | DB::insert( |
1341 | 1341 | prefixTable('tokens'), |
@@ -1397,7 +1397,7 @@ discard block |
||
1397 | 1397 | 'email' => $dataUser['email'], |
1398 | 1398 | 'email_result' => str_replace( |
1399 | 1399 | '#email#', |
1400 | - '<b>' . obfuscateEmail($dataUser['email']) . '</b>', |
|
1400 | + '<b>'.obfuscateEmail($dataUser['email']).'</b>', |
|
1401 | 1401 | addslashes($lang->get('admin_email_result_ok')) |
1402 | 1402 | ), |
1403 | 1403 | ), |
@@ -1413,7 +1413,7 @@ discard block |
||
1413 | 1413 | 'email' => $dataUser['email'], |
1414 | 1414 | 'email_result' => str_replace( |
1415 | 1415 | '#email#', |
1416 | - '<b>' . obfuscateEmail($dataUser['email']) . '</b>', |
|
1416 | + '<b>'.obfuscateEmail($dataUser['email']).'</b>', |
|
1417 | 1417 | addslashes($lang->get('admin_email_result_ok')) |
1418 | 1418 | ), |
1419 | 1419 | ), |
@@ -1430,7 +1430,7 @@ discard block |
||
1430 | 1430 | |
1431 | 1431 | if (isKeyExistingAndEqual('enable_send_email_on_user_login', 1, $SETTINGS) === true) { |
1432 | 1432 | $row = DB::queryFirstRow( |
1433 | - 'SELECT valeur FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', |
|
1433 | + 'SELECT valeur FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', |
|
1434 | 1434 | 'cron', |
1435 | 1435 | 'sending_emails' |
1436 | 1436 | ); |
@@ -1438,7 +1438,7 @@ discard block |
||
1438 | 1438 | if ((int) (time() - $row['valeur']) >= 300 || (int) $row['valeur'] === 0) { |
1439 | 1439 | $rows = DB::query( |
1440 | 1440 | 'SELECT * |
1441 | - FROM ' . prefixTable('emails') . |
|
1441 | + FROM ' . prefixTable('emails'). |
|
1442 | 1442 | ' WHERE status != %s', |
1443 | 1443 | 'sent' |
1444 | 1444 | ); |
@@ -1490,8 +1490,8 @@ discard block |
||
1490 | 1490 | $arr_html = array(); |
1491 | 1491 | $rows = DB::query( |
1492 | 1492 | '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 |
1493 | - FROM ' . prefixTable('log_items') . ' AS l |
|
1494 | - RIGHT JOIN ' . prefixTable('items') . ' AS i ON (l.id_item = i.id) |
|
1493 | + FROM ' . prefixTable('log_items').' AS l |
|
1494 | + RIGHT JOIN ' . prefixTable('items').' AS i ON (l.id_item = i.id) |
|
1495 | 1495 | WHERE l.action = %s AND l.id_user = %i |
1496 | 1496 | ORDER BY l.date DESC |
1497 | 1497 | LIMIT 0, 100', |
@@ -1523,7 +1523,7 @@ discard block |
||
1523 | 1523 | if (isKeyExistingAndEqual('enable_suggestion', 1, $SETTINGS) === true |
1524 | 1524 | && ((int) $session->get('user-admin') === 1 || (int) $session->get('user-manager') === 1) |
1525 | 1525 | ) { |
1526 | - DB::query('SELECT * FROM ' . prefixTable('suggestion')); |
|
1526 | + DB::query('SELECT * FROM '.prefixTable('suggestion')); |
|
1527 | 1527 | $nb_suggestions_waiting = DB::count(); |
1528 | 1528 | } |
1529 | 1529 | |
@@ -1558,13 +1558,13 @@ discard block |
||
1558 | 1558 | if ($data === 'stat_languages') { |
1559 | 1559 | $tmp = ''; |
1560 | 1560 | foreach ($stats_data[$data] as $key => $value) { |
1561 | - $tmp .= $tmp === '' ? $key . '-' . $value : ',' . $key . '-' . $value; |
|
1561 | + $tmp .= $tmp === '' ? $key.'-'.$value : ','.$key.'-'.$value; |
|
1562 | 1562 | } |
1563 | 1563 | $statsToSend[$data] = $tmp; |
1564 | 1564 | } elseif ($data === 'stat_country') { |
1565 | 1565 | $tmp = ''; |
1566 | 1566 | foreach ($stats_data[$data] as $key => $value) { |
1567 | - $tmp .= $tmp === '' ? $key . '-' . $value : ',' . $key . '-' . $value; |
|
1567 | + $tmp .= $tmp === '' ? $key.'-'.$value : ','.$key.'-'.$value; |
|
1568 | 1568 | } |
1569 | 1569 | $statsToSend[$data] = $tmp; |
1570 | 1570 | } else { |
@@ -1651,7 +1651,7 @@ discard block |
||
1651 | 1651 | $url_found = $value; |
1652 | 1652 | if (empty($url_found) === false) { |
1653 | 1653 | $tmp = parse_url($url_found); |
1654 | - $anonym_url = $tmp['scheme'] . '://<anonym_url>' . (isset($tmp['path']) === true ? $tmp['path'] : ''); |
|
1654 | + $anonym_url = $tmp['scheme'].'://<anonym_url>'.(isset($tmp['path']) === true ? $tmp['path'] : ''); |
|
1655 | 1655 | $value = $anonym_url; |
1656 | 1656 | } else { |
1657 | 1657 | $value = ''; |
@@ -1681,7 +1681,7 @@ discard block |
||
1681 | 1681 | $teampass_errors = ''; |
1682 | 1682 | $rows = DB::query( |
1683 | 1683 | 'SELECT label, date AS error_date |
1684 | - FROM ' . prefixTable('log_system') . " |
|
1684 | + FROM ' . prefixTable('log_system')." |
|
1685 | 1685 | WHERE `type` LIKE 'error' |
1686 | 1686 | ORDER BY `date` DESC |
1687 | 1687 | LIMIT 0, 10" |
@@ -1689,9 +1689,9 @@ discard block |
||
1689 | 1689 | if (DB::count() > 0) { |
1690 | 1690 | foreach ($rows as $record) { |
1691 | 1691 | if (empty($teampass_errors) === true) { |
1692 | - $teampass_errors = ' * ' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['error_date']) . ' - ' . $record['label']; |
|
1692 | + $teampass_errors = ' * '.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['error_date']).' - '.$record['label']; |
|
1693 | 1693 | } else { |
1694 | - $teampass_errors .= ' * ' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['error_date']) . ' - ' . $record['label']; |
|
1694 | + $teampass_errors .= ' * '.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['error_date']).' - '.$record['label']; |
|
1695 | 1695 | } |
1696 | 1696 | } |
1697 | 1697 | } |
@@ -1703,7 +1703,7 @@ discard block |
||
1703 | 1703 | |
1704 | 1704 | // Now prepare text |
1705 | 1705 | $txt = '### Page on which it happened |
1706 | -' . $data['current_page'] . ' |
|
1706 | +' . $data['current_page'].' |
|
1707 | 1707 | |
1708 | 1708 | ### Steps to reproduce |
1709 | 1709 | 1. |
@@ -1718,39 +1718,39 @@ discard block |
||
1718 | 1718 | Tell us what happens instead |
1719 | 1719 | |
1720 | 1720 | ### Server configuration |
1721 | -**Operating system**: ' . php_uname() . ' |
|
1721 | +**Operating system**: ' . php_uname().' |
|
1722 | 1722 | |
1723 | -**Web server:** ' . $_SERVER['SERVER_SOFTWARE'] . ' |
|
1723 | +**Web server:** ' . $_SERVER['SERVER_SOFTWARE'].' |
|
1724 | 1724 | |
1725 | -**Database:** ' . ($link === false ? $lang->get('undefined') : mysqli_get_server_info($link)) . ' |
|
1725 | +**Database:** ' . ($link === false ? $lang->get('undefined') : mysqli_get_server_info($link)).' |
|
1726 | 1726 | |
1727 | -**PHP version:** ' . PHP_VERSION . ' |
|
1727 | +**PHP version:** ' . PHP_VERSION.' |
|
1728 | 1728 | |
1729 | -**Teampass version:** ' . TP_VERSION . '.' . TP_VERSION_MINOR . ' |
|
1729 | +**Teampass version:** ' . TP_VERSION.'.'.TP_VERSION_MINOR.' |
|
1730 | 1730 | |
1731 | 1731 | **Teampass configuration variables:** |
1732 | 1732 | ``` |
1733 | -' . $list_of_options . ' |
|
1733 | +' . $list_of_options.' |
|
1734 | 1734 | ``` |
1735 | 1735 | |
1736 | 1736 | **Updated from an older Teampass or fresh install:** |
1737 | 1737 | |
1738 | 1738 | ### Client configuration |
1739 | 1739 | |
1740 | -**Browser:** ' . $data['browser_name'] . ' - ' . $data['browser_version'] . ' |
|
1740 | +**Browser:** ' . $data['browser_name'].' - '.$data['browser_version'].' |
|
1741 | 1741 | |
1742 | -**Operating system:** ' . $data['os'] . ' - ' . $data['os_archi'] . 'bits |
|
1742 | +**Operating system:** ' . $data['os'].' - '.$data['os_archi'].'bits |
|
1743 | 1743 | |
1744 | 1744 | ### Logs |
1745 | 1745 | |
1746 | 1746 | #### Web server error log |
1747 | 1747 | ``` |
1748 | -' . $err['message'] . ' - ' . $err['file'] . ' (' . $err['line'] . ') |
|
1748 | +' . $err['message'].' - '.$err['file'].' ('.$err['line'].') |
|
1749 | 1749 | ``` |
1750 | 1750 | |
1751 | 1751 | #### Teampass 10 last system errors |
1752 | 1752 | ``` |
1753 | -' . $teampass_errors . ' |
|
1753 | +' . $teampass_errors.' |
|
1754 | 1754 | ``` |
1755 | 1755 | |
1756 | 1756 | #### Log from the web-browser developer console (CTRL + SHIFT + i) |
@@ -1790,7 +1790,7 @@ discard block |
||
1790 | 1790 | // Check if user exists |
1791 | 1791 | $userInfo = DB::queryFirstRow( |
1792 | 1792 | 'SELECT public_key, private_key, pw, auth_type |
1793 | - FROM ' . prefixTable('users') . ' |
|
1793 | + FROM ' . prefixTable('users').' |
|
1794 | 1794 | WHERE id = %i', |
1795 | 1795 | $post_user_id |
1796 | 1796 | ); |
@@ -1799,9 +1799,9 @@ discard block |
||
1799 | 1799 | // Get one item |
1800 | 1800 | $currentUserKey = DB::queryFirstRow( |
1801 | 1801 | 'SELECT object_id, share_key, increment_id |
1802 | - FROM ' . prefixTable('sharekeys_items') . ' AS si |
|
1803 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (i.id = si.object_id) |
|
1804 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS nt ON (i.id_tree = nt.id) |
|
1802 | + FROM ' . prefixTable('sharekeys_items').' AS si |
|
1803 | + INNER JOIN ' . prefixTable('items').' AS i ON (i.id = si.object_id) |
|
1804 | + INNER JOIN ' . prefixTable('nested_tree').' AS nt ON (i.id_tree = nt.id) |
|
1805 | 1805 | WHERE user_id = %i AND nt.personal_folder = %i', |
1806 | 1806 | $post_user_id, |
1807 | 1807 | 0 |
@@ -1895,7 +1895,7 @@ discard block |
||
1895 | 1895 | // Get user info |
1896 | 1896 | $userData = DB::queryFirstRow( |
1897 | 1897 | 'SELECT private_key |
1898 | - FROM ' . prefixTable('users') . ' |
|
1898 | + FROM ' . prefixTable('users').' |
|
1899 | 1899 | WHERE id = %i', |
1900 | 1900 | $post_user_id |
1901 | 1901 | ); |
@@ -1976,7 +1976,7 @@ discard block |
||
1976 | 1976 | // Get user info |
1977 | 1977 | $userData = DB::queryFirstRow( |
1978 | 1978 | 'SELECT email, auth_type, login |
1979 | - FROM ' . prefixTable('users') . ' |
|
1979 | + FROM ' . prefixTable('users').' |
|
1980 | 1980 | WHERE id = %i', |
1981 | 1981 | $post_user_id |
1982 | 1982 | ); |
@@ -2074,7 +2074,7 @@ discard block |
||
2074 | 2074 | // Get user info |
2075 | 2075 | $userData = DB::queryFirstRow( |
2076 | 2076 | 'SELECT email, auth_type, login |
2077 | - FROM ' . prefixTable('users') . ' |
|
2077 | + FROM ' . prefixTable('users').' |
|
2078 | 2078 | WHERE id = %i', |
2079 | 2079 | $post_user_id |
2080 | 2080 | ); |
@@ -2140,7 +2140,7 @@ discard block |
||
2140 | 2140 | // Check if user exists |
2141 | 2141 | DB::queryFirstRow( |
2142 | 2142 | 'SELECT * |
2143 | - FROM ' . prefixTable('users') . ' |
|
2143 | + FROM ' . prefixTable('users').' |
|
2144 | 2144 | WHERE id = %i', |
2145 | 2145 | $post_user_id |
2146 | 2146 | ); |
@@ -2210,7 +2210,7 @@ discard block |
||
2210 | 2210 | // Check if user exists |
2211 | 2211 | $userInfo = DB::queryFirstRow( |
2212 | 2212 | 'SELECT public_key |
2213 | - FROM ' . prefixTable('users') . ' |
|
2213 | + FROM ' . prefixTable('users').' |
|
2214 | 2214 | WHERE id = %i', |
2215 | 2215 | $post_user_id |
2216 | 2216 | ); |
@@ -2358,15 +2358,15 @@ discard block |
||
2358 | 2358 | // Loop on items |
2359 | 2359 | $rows = DB::query( |
2360 | 2360 | 'SELECT id, pw |
2361 | - FROM ' . prefixTable('items') . ' |
|
2361 | + FROM ' . prefixTable('items').' |
|
2362 | 2362 | WHERE perso = 0 |
2363 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2363 | + LIMIT ' . $post_start.', '.$post_length |
|
2364 | 2364 | ); |
2365 | 2365 | foreach ($rows as $record) { |
2366 | 2366 | // Get itemKey from current user |
2367 | 2367 | $currentUserKey = DB::queryFirstRow( |
2368 | 2368 | 'SELECT share_key, increment_id |
2369 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2369 | + FROM ' . prefixTable('sharekeys_items').' |
|
2370 | 2370 | WHERE object_id = %i AND user_id = %i', |
2371 | 2371 | $record['id'], |
2372 | 2372 | $session->get('user-id') |
@@ -2398,7 +2398,7 @@ discard block |
||
2398 | 2398 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2399 | 2399 | $currentUserKey = DB::queryFirstRow( |
2400 | 2400 | 'SELECT increment_id |
2401 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2401 | + FROM ' . prefixTable('sharekeys_items').' |
|
2402 | 2402 | WHERE object_id = %i AND user_id = %i', |
2403 | 2403 | $record['id'], |
2404 | 2404 | $post_user_id |
@@ -2431,7 +2431,7 @@ discard block |
||
2431 | 2431 | // SHould we change step? |
2432 | 2432 | DB::query( |
2433 | 2433 | 'SELECT * |
2434 | - FROM ' . prefixTable('items') . ' |
|
2434 | + FROM ' . prefixTable('items').' |
|
2435 | 2435 | WHERE perso = 0' |
2436 | 2436 | ); |
2437 | 2437 | |
@@ -2456,15 +2456,15 @@ discard block |
||
2456 | 2456 | // Loop on logs |
2457 | 2457 | $rows = DB::query( |
2458 | 2458 | 'SELECT increment_id |
2459 | - FROM ' . prefixTable('log_items') . ' |
|
2459 | + FROM ' . prefixTable('log_items').' |
|
2460 | 2460 | WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes" |
2461 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2461 | + LIMIT ' . $post_start.', '.$post_length |
|
2462 | 2462 | ); |
2463 | 2463 | foreach ($rows as $record) { |
2464 | 2464 | // Get itemKey from current user |
2465 | 2465 | $currentUserKey = DB::queryFirstRow( |
2466 | 2466 | 'SELECT share_key |
2467 | - FROM ' . prefixTable('sharekeys_logs') . ' |
|
2467 | + FROM ' . prefixTable('sharekeys_logs').' |
|
2468 | 2468 | WHERE object_id = %i AND user_id = %i', |
2469 | 2469 | $record['increment_id'], |
2470 | 2470 | $session->get('user-id') |
@@ -2496,7 +2496,7 @@ discard block |
||
2496 | 2496 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2497 | 2497 | $currentUserKey = DB::queryFirstRow( |
2498 | 2498 | 'SELECT increment_id |
2499 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2499 | + FROM ' . prefixTable('sharekeys_items').' |
|
2500 | 2500 | WHERE object_id = %i AND user_id = %i', |
2501 | 2501 | $record['id'], |
2502 | 2502 | $post_user_id |
@@ -2518,7 +2518,7 @@ discard block |
||
2518 | 2518 | // SHould we change step? |
2519 | 2519 | DB::query( |
2520 | 2520 | 'SELECT increment_id |
2521 | - FROM ' . prefixTable('log_items') . ' |
|
2521 | + FROM ' . prefixTable('log_items').' |
|
2522 | 2522 | WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes"' |
2523 | 2523 | ); |
2524 | 2524 | |
@@ -2543,15 +2543,15 @@ discard block |
||
2543 | 2543 | // Loop on fields |
2544 | 2544 | $rows = DB::query( |
2545 | 2545 | 'SELECT id |
2546 | - FROM ' . prefixTable('categories_items') . ' |
|
2546 | + FROM ' . prefixTable('categories_items').' |
|
2547 | 2547 | WHERE encryption_type = "teampass_aes" |
2548 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2548 | + LIMIT ' . $post_start.', '.$post_length |
|
2549 | 2549 | ); |
2550 | 2550 | foreach ($rows as $record) { |
2551 | 2551 | // Get itemKey from current user |
2552 | 2552 | $currentUserKey = DB::queryFirstRow( |
2553 | 2553 | 'SELECT share_key |
2554 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
2554 | + FROM ' . prefixTable('sharekeys_fields').' |
|
2555 | 2555 | WHERE object_id = %i AND user_id = %i', |
2556 | 2556 | $record['id'], |
2557 | 2557 | $session->get('user-id') |
@@ -2583,7 +2583,7 @@ discard block |
||
2583 | 2583 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2584 | 2584 | $currentUserKey = DB::queryFirstRow( |
2585 | 2585 | 'SELECT increment_id |
2586 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2586 | + FROM ' . prefixTable('sharekeys_items').' |
|
2587 | 2587 | WHERE object_id = %i AND user_id = %i', |
2588 | 2588 | $record['id'], |
2589 | 2589 | $post_user_id |
@@ -2605,7 +2605,7 @@ discard block |
||
2605 | 2605 | // SHould we change step? |
2606 | 2606 | DB::query( |
2607 | 2607 | 'SELECT * |
2608 | - FROM ' . prefixTable('categories_items') . ' |
|
2608 | + FROM ' . prefixTable('categories_items').' |
|
2609 | 2609 | WHERE encryption_type = "teampass_aes"' |
2610 | 2610 | ); |
2611 | 2611 | |
@@ -2630,14 +2630,14 @@ discard block |
||
2630 | 2630 | // Loop on suggestions |
2631 | 2631 | $rows = DB::query( |
2632 | 2632 | 'SELECT id |
2633 | - FROM ' . prefixTable('suggestion') . ' |
|
2634 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2633 | + FROM ' . prefixTable('suggestion').' |
|
2634 | + LIMIT ' . $post_start.', '.$post_length |
|
2635 | 2635 | ); |
2636 | 2636 | foreach ($rows as $record) { |
2637 | 2637 | // Get itemKey from current user |
2638 | 2638 | $currentUserKey = DB::queryFirstRow( |
2639 | 2639 | 'SELECT share_key |
2640 | - FROM ' . prefixTable('sharekeys_suggestions') . ' |
|
2640 | + FROM ' . prefixTable('sharekeys_suggestions').' |
|
2641 | 2641 | WHERE object_id = %i AND user_id = %i', |
2642 | 2642 | $record['id'], |
2643 | 2643 | $session->get('user-id') |
@@ -2669,7 +2669,7 @@ discard block |
||
2669 | 2669 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2670 | 2670 | $currentUserKey = DB::queryFirstRow( |
2671 | 2671 | 'SELECT increment_id |
2672 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2672 | + FROM ' . prefixTable('sharekeys_items').' |
|
2673 | 2673 | WHERE object_id = %i AND user_id = %i', |
2674 | 2674 | $record['id'], |
2675 | 2675 | $post_user_id |
@@ -2715,15 +2715,15 @@ discard block |
||
2715 | 2715 | // Loop on files |
2716 | 2716 | $rows = DB::query( |
2717 | 2717 | 'SELECT id |
2718 | - FROM ' . prefixTable('files') . ' |
|
2719 | - WHERE status = "' . TP_ENCRYPTION_NAME . '" |
|
2720 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2718 | + FROM ' . prefixTable('files').' |
|
2719 | + WHERE status = "' . TP_ENCRYPTION_NAME.'" |
|
2720 | + LIMIT ' . $post_start.', '.$post_length |
|
2721 | 2721 | ); //aes_encryption |
2722 | 2722 | foreach ($rows as $record) { |
2723 | 2723 | // Get itemKey from current user |
2724 | 2724 | $currentUserKey = DB::queryFirstRow( |
2725 | 2725 | 'SELECT share_key |
2726 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
2726 | + FROM ' . prefixTable('sharekeys_files').' |
|
2727 | 2727 | WHERE object_id = %i AND user_id = %i', |
2728 | 2728 | $record['id'], |
2729 | 2729 | $session->get('user-id') |
@@ -2755,7 +2755,7 @@ discard block |
||
2755 | 2755 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2756 | 2756 | $currentUserKey = DB::queryFirstRow( |
2757 | 2757 | 'SELECT increment_id |
2758 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2758 | + FROM ' . prefixTable('sharekeys_items').' |
|
2759 | 2759 | WHERE object_id = %i AND user_id = %i', |
2760 | 2760 | $record['id'], |
2761 | 2761 | $post_user_id |
@@ -2777,8 +2777,8 @@ discard block |
||
2777 | 2777 | // SHould we change step? |
2778 | 2778 | DB::query( |
2779 | 2779 | 'SELECT * |
2780 | - FROM ' . prefixTable('files') . ' |
|
2781 | - WHERE status = "' . TP_ENCRYPTION_NAME . '"' |
|
2780 | + FROM ' . prefixTable('files').' |
|
2781 | + WHERE status = "' . TP_ENCRYPTION_NAME.'"' |
|
2782 | 2782 | ); |
2783 | 2783 | |
2784 | 2784 | $next_start = (int) $post_start + (int) $post_length; |
@@ -2811,9 +2811,9 @@ discard block |
||
2811 | 2811 | if (count($session->get('user-personal_folders')) > 0) { |
2812 | 2812 | $rows = DB::query( |
2813 | 2813 | 'SELECT id, pw |
2814 | - FROM ' . prefixTable('items') . ' |
|
2814 | + FROM ' . prefixTable('items').' |
|
2815 | 2815 | WHERE perso = 1 AND id_tree IN %ls AND encryption_type = %s |
2816 | - LIMIT ' . $post_start . ', ' . $post_length, |
|
2816 | + LIMIT ' . $post_start.', '.$post_length, |
|
2817 | 2817 | $session->get('user-personal_folders'), |
2818 | 2818 | "defuse" |
2819 | 2819 | ); |
@@ -2821,7 +2821,7 @@ discard block |
||
2821 | 2821 | // Get itemKey from current user |
2822 | 2822 | $currentUserKey = DB::queryFirstRow( |
2823 | 2823 | 'SELECT share_key, increment_id |
2824 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2824 | + FROM ' . prefixTable('sharekeys_items').' |
|
2825 | 2825 | WHERE object_id = %i AND user_id = %i', |
2826 | 2826 | $record['id'], |
2827 | 2827 | $session->get('user-id') |
@@ -2848,7 +2848,7 @@ discard block |
||
2848 | 2848 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2849 | 2849 | $currentUserKey = DB::queryFirstRow( |
2850 | 2850 | 'SELECT increment_id |
2851 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2851 | + FROM ' . prefixTable('sharekeys_items').' |
|
2852 | 2852 | WHERE object_id = %i AND user_id = %i', |
2853 | 2853 | $record['id'], |
2854 | 2854 | $post_user_id |
@@ -2871,7 +2871,7 @@ discard block |
||
2871 | 2871 | // SHould we change step? |
2872 | 2872 | DB::query( |
2873 | 2873 | 'SELECT * |
2874 | - FROM ' . prefixTable('items') . ' |
|
2874 | + FROM ' . prefixTable('items').' |
|
2875 | 2875 | WHERE perso = 0' |
2876 | 2876 | ); |
2877 | 2877 | |
@@ -2899,7 +2899,7 @@ discard block |
||
2899 | 2899 | // Check if user exists |
2900 | 2900 | $userInfo = DB::queryFirstRow( |
2901 | 2901 | 'SELECT public_key, encrypted_psk |
2902 | - FROM ' . prefixTable('users') . ' |
|
2902 | + FROM ' . prefixTable('users').' |
|
2903 | 2903 | WHERE id = %i', |
2904 | 2904 | $post_user_id |
2905 | 2905 | ); |
@@ -2925,7 +2925,7 @@ discard block |
||
2925 | 2925 | if ($post_counterItemsToTreat === -1) { |
2926 | 2926 | DB::query( |
2927 | 2927 | 'SELECT id |
2928 | - FROM ' . prefixTable('items') . ' |
|
2928 | + FROM ' . prefixTable('items').' |
|
2929 | 2929 | WHERE perso = 1 AND id_tree IN %ls AND encryption_type != %s', |
2930 | 2930 | $session->get('user-personal_folders'), |
2931 | 2931 | 'teampass_aes' |
@@ -2938,7 +2938,7 @@ discard block |
||
2938 | 2938 | // Loop on persoanl items |
2939 | 2939 | $rows = DB::query( |
2940 | 2940 | 'SELECT id, pw |
2941 | - FROM ' . prefixTable('items') . ' |
|
2941 | + FROM ' . prefixTable('items').' |
|
2942 | 2942 | WHERE perso = 1 AND id_tree IN %ls AND encryption_type != %s |
2943 | 2943 | LIMIT ' . $post_length, |
2944 | 2944 | $session->get('user-personal_folders'), |
@@ -2982,7 +2982,7 @@ discard block |
||
2982 | 2982 | // Loop on files |
2983 | 2983 | $rows = DB::query( |
2984 | 2984 | 'SELECT id, file |
2985 | - FROM ' . prefixTable('files') . ' |
|
2985 | + FROM ' . prefixTable('files').' |
|
2986 | 2986 | WHERE status != %s |
2987 | 2987 | AND id_item = %i', |
2988 | 2988 | TP_ENCRYPTION_NAME, |
@@ -2993,13 +2993,13 @@ discard block |
||
2993 | 2993 | // Now decrypt the file |
2994 | 2994 | prepareFileWithDefuse( |
2995 | 2995 | 'decrypt', |
2996 | - $SETTINGS['path_to_upload_folder'] . '/' . $record2['file'], |
|
2997 | - $SETTINGS['path_to_upload_folder'] . '/' . $record2['file'] . '.delete', |
|
2996 | + $SETTINGS['path_to_upload_folder'].'/'.$record2['file'], |
|
2997 | + $SETTINGS['path_to_upload_folder'].'/'.$record2['file'].'.delete', |
|
2998 | 2998 | $post_user_psk |
2999 | 2999 | ); |
3000 | 3000 | |
3001 | 3001 | // Encrypt the file |
3002 | - $encryptedFile = encryptFile($record2['file'] . '.delete', $SETTINGS['path_to_upload_folder']); |
|
3002 | + $encryptedFile = encryptFile($record2['file'].'.delete', $SETTINGS['path_to_upload_folder']); |
|
3003 | 3003 | |
3004 | 3004 | DB::update( |
3005 | 3005 | prefixTable('files'), |
@@ -3022,7 +3022,7 @@ discard block |
||
3022 | 3022 | ); |
3023 | 3023 | |
3024 | 3024 | // Unlink original file |
3025 | - unlink($SETTINGS['path_to_upload_folder'] . '/' . $record2['file']); |
|
3025 | + unlink($SETTINGS['path_to_upload_folder'].'/'.$record2['file']); |
|
3026 | 3026 | } |
3027 | 3027 | } |
3028 | 3028 | |
@@ -3030,7 +3030,7 @@ discard block |
||
3030 | 3030 | $next_start = (int) $post_start + (int) $post_length; |
3031 | 3031 | DB::query( |
3032 | 3032 | 'SELECT id |
3033 | - FROM ' . prefixTable('items') . ' |
|
3033 | + FROM ' . prefixTable('items').' |
|
3034 | 3034 | WHERE perso = 1 AND id_tree IN %ls AND encryption_type != %s', |
3035 | 3035 | $session->get('user-personal_folders'), |
3036 | 3036 | 'teampass_aes' |
@@ -3100,7 +3100,7 @@ discard block |
||
3100 | 3100 | // Get user info |
3101 | 3101 | $userData = DB::queryFirstRow( |
3102 | 3102 | 'SELECT special, auth_type, is_ready_for_usage, ongoing_process_id, otp_provided, keys_recovery_time |
3103 | - FROM ' . prefixTable('users') . ' |
|
3103 | + FROM ' . prefixTable('users').' |
|
3104 | 3104 | WHERE id = %i', |
3105 | 3105 | $post_user_id |
3106 | 3106 | ); |
@@ -3147,7 +3147,7 @@ discard block |
||
3147 | 3147 | // Get user info |
3148 | 3148 | $userData = DB::queryFirstRow( |
3149 | 3149 | 'SELECT auth_type, login, private_key |
3150 | - FROM ' . prefixTable('users') . ' |
|
3150 | + FROM ' . prefixTable('users').' |
|
3151 | 3151 | WHERE id = %i', |
3152 | 3152 | $post_user_id |
3153 | 3153 | ); |
@@ -3197,7 +3197,7 @@ discard block |
||
3197 | 3197 | return prepareExchangedData( |
3198 | 3198 | array( |
3199 | 3199 | 'error' => false, |
3200 | - 'message' => $lang->get('done'),'', |
|
3200 | + 'message' => $lang->get('done'), '', |
|
3201 | 3201 | ), |
3202 | 3202 | 'encode' |
3203 | 3203 | ); |
@@ -3245,7 +3245,7 @@ discard block |
||
3245 | 3245 | // Get user info |
3246 | 3246 | $userData = DB::queryFirstRow( |
3247 | 3247 | 'SELECT auth_type, login, private_key, special |
3248 | - FROM ' . prefixTable('users') . ' |
|
3248 | + FROM ' . prefixTable('users').' |
|
3249 | 3249 | WHERE id = %i', |
3250 | 3250 | $post_user_id |
3251 | 3251 | ); |
@@ -3279,7 +3279,7 @@ discard block |
||
3279 | 3279 | return prepareExchangedData( |
3280 | 3280 | array( |
3281 | 3281 | 'error' => false, |
3282 | - 'message' => $lang->get('done'),'', |
|
3282 | + 'message' => $lang->get('done'), '', |
|
3283 | 3283 | ), |
3284 | 3284 | 'encode' |
3285 | 3285 | ); |
@@ -3301,8 +3301,8 @@ discard block |
||
3301 | 3301 | // Get one itemKey from current user |
3302 | 3302 | $currentUserKey = DB::queryFirstRow( |
3303 | 3303 | 'SELECT ski.share_key, ski.increment_id, l.id_user |
3304 | - FROM ' . prefixTable('sharekeys_items') . ' AS ski |
|
3305 | - INNER JOIN ' . prefixTable('log_items') . ' AS l ON ski.object_id = l.id_item |
|
3304 | + FROM ' . prefixTable('sharekeys_items').' AS ski |
|
3305 | + INNER JOIN ' . prefixTable('log_items').' AS l ON ski.object_id = l.id_item |
|
3306 | 3306 | WHERE ski.user_id = %i |
3307 | 3307 | ORDER BY RAND() |
3308 | 3308 | LIMIT 1', |
@@ -3392,7 +3392,7 @@ discard block |
||
3392 | 3392 | $session->get('user-id') |
3393 | 3393 | ); |
3394 | 3394 | // Return data |
3395 | - return '[{"new_value":"' . $session->get('user-session_duration') . '"}]'; |
|
3395 | + return '[{"new_value":"'.$session->get('user-session_duration').'"}]'; |
|
3396 | 3396 | } |
3397 | 3397 | |
3398 | 3398 | return '[{"new_value":"expired"}]'; |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('profile') === false) { |
69 | 69 | // Not allowed page |
70 | 70 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
71 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
71 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
72 | 72 | exit; |
73 | 73 | } |
74 | 74 | |
@@ -101,49 +101,49 @@ discard block |
||
101 | 101 | $zones = timezone_list(); |
102 | 102 | // prepare list of languages |
103 | 103 | $languages = DB::query( |
104 | - 'SELECT label, name FROM ' . prefixTable('languages') . ' ORDER BY label ASC' |
|
104 | + 'SELECT label, name FROM '.prefixTable('languages').' ORDER BY label ASC' |
|
105 | 105 | ); |
106 | 106 | |
107 | 107 | // Do some stats |
108 | 108 | $userItemsNumber = DB::queryFirstField( |
109 | 109 | 'SELECT COUNT(id_item) as count |
110 | - FROM ' . prefixTable('log_items') . ' |
|
110 | + FROM ' . prefixTable('log_items').' |
|
111 | 111 | WHERE action = "at_creation" AND id_user = %i', |
112 | 112 | $session->get('user-id') |
113 | 113 | ); |
114 | 114 | |
115 | 115 | $userModificationNumber = DB::queryFirstField( |
116 | 116 | 'SELECT COUNT(id_item) as count |
117 | - FROM ' . prefixTable('log_items') . ' |
|
117 | + FROM ' . prefixTable('log_items').' |
|
118 | 118 | WHERE action = "at_modification" AND id_user = %i', |
119 | 119 | $session->get('user-id') |
120 | 120 | ); |
121 | 121 | |
122 | 122 | $userSeenItemsNumber = DB::queryFirstField( |
123 | 123 | 'SELECT COUNT(id_item) as count |
124 | - FROM ' . prefixTable('log_items') . ' |
|
124 | + FROM ' . prefixTable('log_items').' |
|
125 | 125 | WHERE action = "at_shown" AND id_user = %i', |
126 | 126 | $session->get('user-id') |
127 | 127 | ); |
128 | 128 | |
129 | 129 | $userSeenPasswordsNumber = DB::queryFirstField( |
130 | 130 | 'SELECT COUNT(id_item) |
131 | - FROM ' . prefixTable('log_items') . ' |
|
131 | + FROM ' . prefixTable('log_items').' |
|
132 | 132 | WHERE action = "at_password_shown" AND id_user = %i', |
133 | 133 | $session->get('user-id') |
134 | 134 | ); |
135 | 135 | |
136 | 136 | $userInfo = DB::queryFirstRow( |
137 | 137 | 'SELECT avatar, last_pw_change |
138 | - FROM ' . prefixTable('users') . ' |
|
138 | + FROM ' . prefixTable('users').' |
|
139 | 139 | WHERE id = %i', |
140 | 140 | $session->get('user-id') |
141 | 141 | ); |
142 | 142 | |
143 | 143 | if (empty($userInfo['avatar']) === true) { |
144 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg'; |
|
144 | + $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg'; |
|
145 | 145 | } else { |
146 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/avatars/' . $userInfo['avatar']; |
|
146 | + $avatar = $SETTINGS['cpassman_url'].'/includes/avatars/'.$userInfo['avatar']; |
|
147 | 147 | } |
148 | 148 | |
149 | 149 | // Get Groups name |
@@ -151,7 +151,7 @@ discard block |
||
151 | 151 | foreach ($session->get('user-roles_array') as $role) { |
152 | 152 | $tmp = DB::queryFirstRow( |
153 | 153 | 'SELECT title |
154 | - FROM ' . prefixTable('roles_title') . ' |
|
154 | + FROM ' . prefixTable('roles_title').' |
|
155 | 155 | WHERE id = %i', |
156 | 156 | $role |
157 | 157 | ); |
@@ -197,7 +197,7 @@ discard block |
||
197 | 197 | <h3 id="profile-username" class="text-center"> |
198 | 198 | <?php |
199 | 199 | if (null !== $session->get('user-name') && empty($session->get('user-name')) === false) { |
200 | - echo $session->get('user-name') . ' ' . $session->get('user-lastname'); |
|
200 | + echo $session->get('user-name').' '.$session->get('user-lastname'); |
|
201 | 201 | } else { |
202 | 202 | echo $session->get('user-login'); |
203 | 203 | } |
@@ -265,7 +265,7 @@ discard block |
||
265 | 265 | } else { |
266 | 266 | echo date('d/m/Y', (int) $session->get('user-last_connection')); |
267 | 267 | } |
268 | - echo ' ' . $lang->get('at') . ' '; |
|
268 | + echo ' '.$lang->get('at').' '; |
|
269 | 269 | if (isset($SETTINGS['time_format']) === true) { |
270 | 270 | echo date($SETTINGS['time_format'], (int) $session->get('user-last_connection')); |
271 | 271 | } else { |
@@ -275,7 +275,7 @@ discard block |
||
275 | 275 | </a> |
276 | 276 | </li> |
277 | 277 | <?php |
278 | - if (null !== $session->get('user-last_pw_change') && ! empty($session->get('user-last_pw_change') === true)) { |
|
278 | + if (null !== $session->get('user-last_pw_change') && !empty($session->get('user-last_pw_change') === true)) { |
|
279 | 279 | // Handle last password change string |
280 | 280 | if ($session->has('user-last_pw_change') && null !== $session->get('user-last_pw_change')) { |
281 | 281 | if (isset($SETTINGS['date_format']) === true) { |
@@ -295,12 +295,12 @@ discard block |
||
295 | 295 | ) { |
296 | 296 | $numDaysBeforePwExpiration = ''; |
297 | 297 | } else { |
298 | - $numDaysBeforePwExpiration = $lang['index_pw_expiration'] . ' ' . $session->get('user-num_days_before_exp') . ' ' . $lang['days'] . '.'; |
|
298 | + $numDaysBeforePwExpiration = $lang['index_pw_expiration'].' '.$session->get('user-num_days_before_exp').' '.$lang['days'].'.'; |
|
299 | 299 | } |
300 | 300 | echo ' |
301 | 301 | <li class="list-group-item"> |
302 | - <b><i class="fas fa-calendar-alt fa-fw fa-lg mr-2"></i>' . $lang->get('index_last_pw_change') . '</b> |
|
303 | - <a class="float-right">' . $last_pw_change . ' ' . $numDaysBeforePwExpiration . '</a> |
|
302 | + <b><i class="fas fa-calendar-alt fa-fw fa-lg mr-2"></i>' . $lang->get('index_last_pw_change').'</b> |
|
303 | + <a class="float-right">' . $last_pw_change.' '.$numDaysBeforePwExpiration.'</a> |
|
304 | 304 | </li>'; |
305 | 305 | } |
306 | 306 | ?> |
@@ -320,7 +320,7 @@ discard block |
||
320 | 320 | if (isset($SETTINGS['api']) === true && (int) $SETTINGS['api'] === 1) { |
321 | 321 | echo ' |
322 | 322 | <li class="list-group-item"> |
323 | - <b><i class="fas fa-paper-plane fa-fw fa-lg mr-2"></i>' . $lang->get('user_profile_api_key') . '</b> |
|
323 | + <b><i class="fas fa-paper-plane fa-fw fa-lg mr-2"></i>' . $lang->get('user_profile_api_key').'</b> |
|
324 | 324 | <button class="btn btn-sm btn-primary float-right" id="copy-api-key"><i class="fa-regular fa-copy pointer"></i></button> |
325 | 325 | <a class="float-right mr-2" id="profile-user-api-token">', |
326 | 326 | null !== $session->get('user-api_key') ? $session->get('user-api_key') : '', |
@@ -338,12 +338,12 @@ discard block |
||
338 | 338 | <?php |
339 | 339 | $rows = DB::query( |
340 | 340 | 'SELECT label AS labelAction, date, null |
341 | - FROM ' . prefixTable('log_system') . ' |
|
341 | + FROM ' . prefixTable('log_system').' |
|
342 | 342 | WHERE qui = %i |
343 | 343 | UNION |
344 | 344 | SELECT l.action, l.date, i.label AS itemLabel |
345 | - FROM ' . prefixTable('log_items') . ' AS l |
|
346 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (l.id_item = i.id) |
|
345 | + FROM ' . prefixTable('log_items').' AS l |
|
346 | + INNER JOIN ' . prefixTable('items').' AS i ON (l.id_item = i.id) |
|
347 | 347 | WHERE l.id_user = %i AND l.action IN ("at_access") |
348 | 348 | ORDER BY date DESC |
349 | 349 | LIMIT 0, 40', |
@@ -357,9 +357,9 @@ discard block |
||
357 | 357 | $text = $lang->get($record['labelAction']); |
358 | 358 | } |
359 | 359 | if (empty($record['NULL']) === false) { |
360 | - $text .= ' ' . $lang->get('for') . ' <span class="font-weight-light">' . addslashes($record['NULL']) . '</span>'; |
|
360 | + $text .= ' '.$lang->get('for').' <span class="font-weight-light">'.addslashes($record['NULL']).'</span>'; |
|
361 | 361 | } |
362 | - echo '<li class="list-group-item">' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']) . ' - ' . $text . '</li>'; |
|
362 | + echo '<li class="list-group-item">'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']).' - '.$text.'</li>'; |
|
363 | 363 | } |
364 | 364 | ?> |
365 | 365 | </ul> |
@@ -393,13 +393,13 @@ discard block |
||
393 | 393 | <?php endif; /* disable_user_edit_profile */ |
394 | 394 | if (($SETTINGS['disable_user_edit_timezone'] ?? '0') === '0') : ?> |
395 | 395 | <div class="form-group"> |
396 | - <label class="col-sm-10 control-label"><?php echo $lang->get('timezone_selection');?></label> |
|
396 | + <label class="col-sm-10 control-label"><?php echo $lang->get('timezone_selection'); ?></label> |
|
397 | 397 | <div class="col-sm-10"> |
398 | 398 | <select class="form-control" id="profile-user-timezone"> |
399 | 399 | <?php foreach ($zones as $key => $zone): ?> |
400 | 400 | <option value="<?php echo $key; ?>"<?php |
401 | 401 | if ($session->has('user-timezone')) |
402 | - if($session->get('user-timezone') === $key) |
|
402 | + if ($session->get('user-timezone') === $key) |
|
403 | 403 | echo ' selected'; |
404 | 404 | elseif ($session->get('user-timezone') === 'not_defined') |
405 | 405 | if (isset($SETTINGS['timezone']) && $SETTINGS['timezone'] === $key) |
@@ -417,10 +417,10 @@ discard block |
||
417 | 417 | <select class="form-control" id="profile-user-language"> |
418 | 418 | <?php |
419 | 419 | foreach ($languages as $language) { |
420 | - echo '<option value="' . $language['name'] . '"', |
|
420 | + echo '<option value="'.$language['name'].'"', |
|
421 | 421 | strtolower($session->get('user-language')) === strtolower($language['name']) ? |
422 | 422 | ' selected="selected"' : '', |
423 | - '>' . $language['label'] . '</option>'; |
|
423 | + '>'.$language['label'].'</option>'; |
|
424 | 424 | } |
425 | 425 | ?> |
426 | 426 | </select> |
@@ -433,11 +433,11 @@ discard block |
||
433 | 433 | <div class="col-sm-10"> |
434 | 434 | <select class="form-control" id="profile-user-treeloadstrategy"> |
435 | 435 | |
436 | - <option value="sequential" <?php echo $session->has('user-tree_load_strategy') && $session->get('user-tree_load_strategy') && null !== $session->get('user-tree_load_strategy') && $session->get('user-tree_load_strategy') === 'sequential' ? ' selected' : '';?>> |
|
436 | + <option value="sequential" <?php echo $session->has('user-tree_load_strategy') && $session->get('user-tree_load_strategy') && null !== $session->get('user-tree_load_strategy') && $session->get('user-tree_load_strategy') === 'sequential' ? ' selected' : ''; ?>> |
|
437 | 437 | <?php echo $lang->get('sequential'); ?> |
438 | 438 | </option> |
439 | 439 | |
440 | - <option value="full" <?php echo $session->has('user-tree_load_strategy') && $session->get('user-tree_load_strategy') && null !== $session->get('user-tree_load_strategy') && $session->get('user-tree_load_strategy') === 'full' ? ' selected' : '';?>> |
|
440 | + <option value="full" <?php echo $session->has('user-tree_load_strategy') && $session->get('user-tree_load_strategy') && null !== $session->get('user-tree_load_strategy') && $session->get('user-tree_load_strategy') === 'full' ? ' selected' : ''; ?>> |
|
441 | 441 | <?php echo $lang->get('full'); ?> |
442 | 442 | </option> |
443 | 443 | </select> |
@@ -450,11 +450,11 @@ discard block |
||
450 | 450 | <div class="col-sm-10"> |
451 | 451 | <select class="form-control" id="profile-user-split_view_mode"> |
452 | 452 | |
453 | - <option value="0" <?php echo $session->has('user-split_view_mode') && $session->get('user-split_view_mode') && null !== $session->get('user-split_view_mode') && $session->get('user-split_view_mode') === 0 ? 'selected' : '';?>> |
|
453 | + <option value="0" <?php echo $session->has('user-split_view_mode') && $session->get('user-split_view_mode') && null !== $session->get('user-split_view_mode') && $session->get('user-split_view_mode') === 0 ? 'selected' : ''; ?>> |
|
454 | 454 | <?php echo $lang->get('no'); ?> |
455 | 455 | </option> |
456 | 456 | |
457 | - <option value="1" <?php echo $session->has('user-split_view_mode') && $session->get('user-split_view_mode') && null !== $session->get('user-split_view_mode') && (int) $session->get('user-split_view_mode') === 1 ? 'selected' : '';?>> |
|
457 | + <option value="1" <?php echo $session->has('user-split_view_mode') && $session->get('user-split_view_mode') && null !== $session->get('user-split_view_mode') && (int) $session->get('user-split_view_mode') === 1 ? 'selected' : ''; ?>> |
|
458 | 458 | <?php echo $lang->get('yes'); ?> |
459 | 459 | </option> |
460 | 460 | </select> |
@@ -472,7 +472,7 @@ discard block |
||
472 | 472 | <?php |
473 | 473 | } |
474 | 474 | if (isset($SETTINGS['api']) === true && (int) $SETTINGS['api'] === 1) { |
475 | - echo '<button type="button" class="btn btn-warning float-right" id="profile-button-api_token">' . $lang->get('generate_api_token') . '</button>'; |
|
475 | + echo '<button type="button" class="btn btn-warning float-right" id="profile-button-api_token">'.$lang->get('generate_api_token').'</button>'; |
|
476 | 476 | } |
477 | 477 | ?> |
478 | 478 | <div id="profile-avatar-file-container" class="hidden"></div> |
@@ -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> |
@@ -374,7 +374,7 @@ discard block |
||
374 | 374 | $languagesList = $languagesList ?? []; |
375 | 375 | foreach ($languagesList as $teampassLang) { |
376 | 376 | echo ' |
377 | - <option value="' . $teampassLang . '"', isset($SETTINGS['default_language']) === true && $SETTINGS['default_language'] === $teampassLang ? ' selected' : '', '>' . $teampassLang . '</option>'; |
|
377 | + <option value="' . $teampassLang.'"', isset($SETTINGS['default_language']) === true && $SETTINGS['default_language'] === $teampassLang ? ' selected' : '', '>'.$teampassLang.'</option>'; |
|
378 | 378 | } |
379 | 379 | ?> |
380 | 380 | </select> |
@@ -471,7 +471,7 @@ discard block |
||
471 | 471 | <?php |
472 | 472 | foreach (TP_PW_COMPLEXITY as $complex) { |
473 | 473 | echo ' |
474 | - <option value="' . $complex[0] . '"', isset($SETTINGS['personal_saltkey_security_level']) === true && $SETTINGS['personal_saltkey_security_level'] === $complex[0] ? ' selected' : '', '>' . $complex[1] . '</option>'; |
|
474 | + <option value="' . $complex[0].'"', isset($SETTINGS['personal_saltkey_security_level']) === true && $SETTINGS['personal_saltkey_security_level'] === $complex[0] ? ' selected' : '', '>'.$complex[1].'</option>'; |
|
475 | 475 | } |
476 | 476 | ?> |
477 | 477 | </select> |
@@ -848,7 +848,7 @@ discard block |
||
848 | 848 | $roles = getRolesTitles(); |
849 | 849 | foreach ($roles as $role) { |
850 | 850 | echo ' |
851 | - <option value="' . htmlspecialchars($role['id']) . '"', in_array($role['id'], $arrRolesToPrint) === true ? ' selected' : '', '>' . htmlspecialchars(addslashes($role['title'])) . '</option>'; |
|
851 | + <option value="' . htmlspecialchars($role['id']).'"', in_array($role['id'], $arrRolesToPrint) === true ? ' selected' : '', '>'.htmlspecialchars(addslashes($role['title'])).'</option>'; |
|
852 | 852 | } |
853 | 853 | } |
854 | 854 | ?> |
@@ -1075,7 +1075,7 @@ discard block |
||
1075 | 1075 | <?php |
1076 | 1076 | foreach (TP_PW_COMPLEXITY as $complex) { |
1077 | 1077 | echo ' |
1078 | - <option value="' . $complex[0] . '"', isset($SETTINGS['offline_key_level']) === true && $SETTINGS['offline_key_level'] === $complex[0] ? ' selected' : '', '>' . $complex[1] . '</option>'; |
|
1078 | + <option value="' . $complex[0].'"', isset($SETTINGS['offline_key_level']) === true && $SETTINGS['offline_key_level'] === $complex[0] ? ' selected' : '', '>'.$complex[1].'</option>'; |
|
1079 | 1079 | } |
1080 | 1080 | ?> |
1081 | 1081 | </select> |
@@ -72,7 +72,7 @@ discard block |
||
72 | 72 | || (isset($session_user_admin) && (int) $session_user_admin === 1)) { |
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 | |
@@ -125,12 +125,12 @@ discard block |
||
125 | 125 | if (empty($fav) === false) { |
126 | 126 | $data = DB::queryFirstRow( |
127 | 127 | 'SELECT i.label, i.description, i.id, i.id_tree, t.title |
128 | - FROM ' . prefixTable('items') . ' as i |
|
129 | - INNER JOIN ' . prefixTable('nested_tree') . ' as t ON (t.id = i.id_tree) |
|
128 | + FROM ' . prefixTable('items').' as i |
|
129 | + INNER JOIN ' . prefixTable('nested_tree').' as t ON (t.id = i.id_tree) |
|
130 | 130 | WHERE i.id = %i', |
131 | 131 | $fav |
132 | 132 | ); |
133 | - if (! empty($data['label'])) { |
|
133 | + if (!empty($data['label'])) { |
|
134 | 134 | ?> |
135 | 135 | <tr> |
136 | 136 | <td> |
@@ -33,7 +33,7 @@ |
||
33 | 33 | use TeampassClasses\SessionManager\SessionManager; |
34 | 34 | use TeampassClasses\ConfigManager\ConfigManager; |
35 | 35 | |
36 | -require_once __DIR__. '/../../includes/config/include.php'; |
|
36 | +require_once __DIR__.'/../../includes/config/include.php'; |
|
37 | 37 | require_once __DIR__.'/../../sources/main.functions.php'; |
38 | 38 | |
39 | 39 | // init |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | ) { |
75 | 75 | // Not allowed page |
76 | 76 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
77 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
77 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
78 | 78 | exit; |
79 | 79 | } |
80 | 80 | |
@@ -107,7 +107,7 @@ discard block |
||
107 | 107 | $post_isNewItem = $request->request->filter('isNewItem', null, FILTER_SANITIZE_NUMBER_INT); |
108 | 108 | $post_randomId = $request->request->filter('randomId', null, FILTER_SANITIZE_NUMBER_INT); |
109 | 109 | $post_isPersonal = $request->request->filter('isPersonal', null, FILTER_SANITIZE_NUMBER_INT); |
110 | -$post_fileSize= $request->request->filter('file_size', null, FILTER_SANITIZE_NUMBER_INT); |
|
110 | +$post_fileSize = $request->request->filter('file_size', null, FILTER_SANITIZE_NUMBER_INT); |
|
111 | 111 | $chunk = $request->request->filter('chunk', 0, FILTER_SANITIZE_NUMBER_INT); |
112 | 112 | $chunks = $request->request->filter('chunks', 0, FILTER_SANITIZE_NUMBER_INT); |
113 | 113 | $fileName = $request->request->filter('name', '', FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
@@ -122,10 +122,10 @@ discard block |
||
122 | 122 | $unit = strtoupper(substr(trim($POST_MAX_SIZE), -1)); // Assurez-vous de bien gérer les espaces éventuels |
123 | 123 | $units = ['G' => 1073741824, 'M' => 1048576, 'K' => 1024]; |
124 | 124 | $multiplier = $units[$unit] ?? 1; // Vérifie si l'unité est dans le tableau, sinon 1 |
125 | - $maxSize = (int)$POST_MAX_SIZE * $multiplier; |
|
125 | + $maxSize = (int) $POST_MAX_SIZE * $multiplier; |
|
126 | 126 | |
127 | 127 | // CHeck if the POST is too big |
128 | - if (!empty($_SERVER['CONTENT_LENGTH']) && (int)$_SERVER['CONTENT_LENGTH'] > $maxSize && $maxSize > 0) { |
|
128 | + if (!empty($_SERVER['CONTENT_LENGTH']) && (int) $_SERVER['CONTENT_LENGTH'] > $maxSize && $maxSize > 0) { |
|
129 | 129 | handleAttachmentError('POST exceeded maximum allowed size.', 111, 413); |
130 | 130 | } |
131 | 131 | |
@@ -134,7 +134,7 @@ discard block |
||
134 | 134 | handleAttachmentError('File exceeds the maximum allowed size', 120, 413); |
135 | 135 | die(); |
136 | 136 | } |
137 | - if (WIP === true) error_log('POST_MAX_SIZE: ' . $POST_MAX_SIZE." - CONTENT_LENGTH: ".$_SERVER['CONTENT_LENGTH']." - UNIT: ".$unit." - MAX: ".$maxSize." - MULTIPLIER: ".$multiplier." - FILE_SIZE: ".$post_fileSize); |
|
137 | + if (WIP === true) error_log('POST_MAX_SIZE: '.$POST_MAX_SIZE." - CONTENT_LENGTH: ".$_SERVER['CONTENT_LENGTH']." - UNIT: ".$unit." - MAX: ".$maxSize." - MULTIPLIER: ".$multiplier." - FILE_SIZE: ".$post_fileSize); |
|
138 | 138 | |
139 | 139 | // delete expired tokens |
140 | 140 | DB::delete(prefixTable('tokens'), 'end_timestamp < %i', time()); |
@@ -185,7 +185,7 @@ discard block |
||
185 | 185 | // check if token is expired |
186 | 186 | $data = DB::queryFirstRow( |
187 | 187 | 'SELECT end_timestamp |
188 | - FROM ' . prefixTable('tokens') . ' |
|
188 | + FROM ' . prefixTable('tokens').' |
|
189 | 189 | WHERE user_id = %i AND token = %s', |
190 | 190 | $session->get('user-id'), |
191 | 191 | $post_user_token |
@@ -218,7 +218,7 @@ discard block |
||
218 | 218 | |
219 | 219 | // HTTP headers for no cache etc |
220 | 220 | header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); |
221 | -header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); |
|
221 | +header('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); |
|
222 | 222 | header('Cache-Control: no-store, no-cache, must-revalidate'); |
223 | 223 | header('Cache-Control: post-check=0, pre-check=0', false); |
224 | 224 | |
@@ -256,7 +256,7 @@ discard block |
||
256 | 256 | // Validate file name (for our purposes we'll just remove invalid characters) |
257 | 257 | $file_name = preg_replace('[^A-Za-z0-9]', '', strtolower(basename($_FILES['file']['name']))); |
258 | 258 | if (strlen($file_name) == 0 || strlen($file_name) > $MAX_FILENAME_LENGTH) { |
259 | - handleAttachmentError('Invalid file name: ' . $file_name . '.', 114); |
|
259 | + handleAttachmentError('Invalid file name: '.$file_name.'.', 114); |
|
260 | 260 | } |
261 | 261 | |
262 | 262 | // Validate file extension |
@@ -266,8 +266,8 @@ discard block |
||
266 | 266 | $ext, |
267 | 267 | explode( |
268 | 268 | ',', |
269 | - $SETTINGS['upload_docext'] . ',' . $SETTINGS['upload_imagesext'] . |
|
270 | - ',' . $SETTINGS['upload_pkgext'] . ',' . $SETTINGS['upload_otherext'] |
|
269 | + $SETTINGS['upload_docext'].','.$SETTINGS['upload_imagesext']. |
|
270 | + ','.$SETTINGS['upload_pkgext'].','.$SETTINGS['upload_otherext'] |
|
271 | 271 | ) |
272 | 272 | ) === false |
273 | 273 | ) { |
@@ -279,24 +279,24 @@ discard block |
||
279 | 279 | |
280 | 280 | // Clean the fileName for security reasons |
281 | 281 | $fileInfo = pathinfo($fileName); |
282 | -$fileName = base64_encode($fileInfo['filename']) . '.' . $fileInfo['extension']; |
|
282 | +$fileName = base64_encode($fileInfo['filename']).'.'.$fileInfo['extension']; |
|
283 | 283 | $fileFullSize = 0; |
284 | 284 | |
285 | 285 | // Make sure the fileName is unique but only if chunking is disabled |
286 | -if ($chunks < 2 && file_exists($targetDir . DIRECTORY_SEPARATOR . $fileName)) { |
|
286 | +if ($chunks < 2 && file_exists($targetDir.DIRECTORY_SEPARATOR.$fileName)) { |
|
287 | 287 | $ext = strrpos($fileName, '.'); |
288 | 288 | $fileNameA = substr($fileName, 0, $ext); |
289 | 289 | $fileNameB = substr($fileName, $ext); |
290 | 290 | |
291 | 291 | $count = 1; |
292 | - while (file_exists($targetDir . DIRECTORY_SEPARATOR . $fileNameA . '_' . $count . $fileNameB)) { |
|
292 | + while (file_exists($targetDir.DIRECTORY_SEPARATOR.$fileNameA.'_'.$count.$fileNameB)) { |
|
293 | 293 | ++$count; |
294 | 294 | } |
295 | 295 | |
296 | - $fileName = $fileNameA . '_' . $count . $fileNameB; |
|
296 | + $fileName = $fileNameA.'_'.$count.$fileNameB; |
|
297 | 297 | } |
298 | 298 | |
299 | -$filePath = $targetDir . DIRECTORY_SEPARATOR . $fileName; |
|
299 | +$filePath = $targetDir.DIRECTORY_SEPARATOR.$fileName; |
|
300 | 300 | |
301 | 301 | // Create target dir |
302 | 302 | if (file_exists($targetDir) === false) { |
@@ -310,7 +310,7 @@ discard block |
||
310 | 310 | // Remove old temp files |
311 | 311 | if ($cleanupTargetDir && is_dir($targetDir) && ($dir = opendir($targetDir))) { |
312 | 312 | while (($file = readdir($dir)) !== false) { |
313 | - $tmpfilePath = $targetDir . DIRECTORY_SEPARATOR . $file; |
|
313 | + $tmpfilePath = $targetDir.DIRECTORY_SEPARATOR.$file; |
|
314 | 314 | |
315 | 315 | // Remove temp file if it is older than the max age and is not the current file |
316 | 316 | if ( |
@@ -429,8 +429,8 @@ discard block |
||
429 | 429 | // This is a public object |
430 | 430 | $users = DB::query( |
431 | 431 | 'SELECT id, public_key |
432 | - FROM ' . prefixTable('users') . ' |
|
433 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '") |
|
432 | + FROM ' . prefixTable('users').' |
|
433 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'") |
|
434 | 434 | AND public_key != ""' |
435 | 435 | ); |
436 | 436 | foreach ($users as $user) { |
@@ -464,14 +464,14 @@ discard block |
||
464 | 464 | 'date' => time(), |
465 | 465 | 'id_user' => $session->get('user-id'), |
466 | 466 | 'action' => 'at_modification', |
467 | - 'raison' => 'at_add_file : ' . $fileName . ':' . $newID, |
|
467 | + 'raison' => 'at_add_file : '.$fileName.':'.$newID, |
|
468 | 468 | ) |
469 | 469 | ); |
470 | 470 | } |
471 | 471 | } |
472 | 472 | |
473 | 473 | // Return JSON-RPC response |
474 | -die('{"jsonrpc" : "2.0", "result" : null, "id" : "' . $newID . '"}'); |
|
474 | +die('{"jsonrpc" : "2.0", "result" : null, "id" : "'.$newID.'"}'); |
|
475 | 475 | |
476 | 476 | /** |
477 | 477 | * Handle errors and kill script. |
@@ -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 | |
@@ -461,7 +461,7 @@ discard block |
||
461 | 461 | ); |
462 | 462 | |
463 | 463 | // add new role to user |
464 | - $tmp = $data_tmp['fonction_id'] . (substr($data_tmp['fonction_id'], -1) == ';' ? $role_id : ';' . $role_id); |
|
464 | + $tmp = $data_tmp['fonction_id'].(substr($data_tmp['fonction_id'], -1) == ';' ? $role_id : ';'.$role_id); |
|
465 | 465 | $session->set('user-roles', str_replace(';;', ';', $tmp)); |
466 | 466 | |
467 | 467 | // store in DB |
@@ -649,7 +649,7 @@ discard block |
||
649 | 649 | $groupsData = $openLdapExtra->getADGroups($ldapConnection, $SETTINGS); |
650 | 650 | break; |
651 | 651 | default: |
652 | - throw new Exception("Unsupported LDAP type: " . $SETTINGS['ldap_type']); |
|
652 | + throw new Exception("Unsupported LDAP type: ".$SETTINGS['ldap_type']); |
|
653 | 653 | } |
654 | 654 | } catch (Exception $e) { |
655 | 655 | if (defined('LOG_TO_SERVER') && LOG_TO_SERVER === true) { |
@@ -669,7 +669,7 @@ discard block |
||
669 | 669 | } else { |
670 | 670 | // Handle successful retrieval of groups |
671 | 671 | // exists in Teampass |
672 | - foreach($groupsData['userGroups'] as $key => $group) { |
|
672 | + foreach ($groupsData['userGroups'] as $key => $group) { |
|
673 | 673 | $role_detail = DB::queryFirstRow( |
674 | 674 | 'SELECT a.increment_id as increment_id, a.role_id as role_id, r.title as title |
675 | 675 | FROM '.prefixTable('ldap_groups_roles').' AS a |
@@ -694,7 +694,7 @@ discard block |
||
694 | 694 | |
695 | 695 | // Get all groups in Teampass |
696 | 696 | $teampassRoles = array(); |
697 | - $rows = DB::query('SELECT id,title FROM ' . prefixTable('roles_title')); |
|
697 | + $rows = DB::query('SELECT id,title FROM '.prefixTable('roles_title')); |
|
698 | 698 | foreach ($rows as $record) { |
699 | 699 | array_push( |
700 | 700 | $teampassRoles, |