@@ -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 | |
@@ -130,7 +130,7 @@ discard block |
||
| 130 | 130 | } else { |
| 131 | 131 | // check if token is expired |
| 132 | 132 | $data = DB::queryFirstRow( |
| 133 | - 'SELECT end_timestamp FROM ' . prefixTable('tokens') . ' WHERE user_id = %i AND token = %s', |
|
| 133 | + 'SELECT end_timestamp FROM '.prefixTable('tokens').' WHERE user_id = %i AND token = %s', |
|
| 134 | 134 | $session->get('user-id'), |
| 135 | 135 | $post_user_token |
| 136 | 136 | ); |
@@ -154,7 +154,7 @@ discard block |
||
| 154 | 154 | |
| 155 | 155 | // HTTP headers for no cache etc |
| 156 | 156 | header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); |
| 157 | -header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); |
|
| 157 | +header('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); |
|
| 158 | 158 | header('Cache-Control: no-store, no-cache, must-revalidate'); |
| 159 | 159 | header('Cache-Control: post-check=0, pre-check=0', false); |
| 160 | 160 | |
@@ -166,7 +166,7 @@ discard block |
||
| 166 | 166 | } |
| 167 | 167 | |
| 168 | 168 | // Set directory used to store file |
| 169 | - $targetDir = realpath($SETTINGS['cpassman_dir'] . '/includes/avatars'); |
|
| 169 | + $targetDir = realpath($SETTINGS['cpassman_dir'].'/includes/avatars'); |
|
| 170 | 170 | } else { |
| 171 | 171 | $targetDir = realpath($SETTINGS['path_to_files_folder']); |
| 172 | 172 | } |
@@ -219,7 +219,7 @@ discard block |
||
| 219 | 219 | $file_name = preg_replace('/[^a-zA-Z0-9-_\.]/', '', strtolower(basename($file->getClientOriginalName()))); |
| 220 | 220 | |
| 221 | 221 | if (strlen($file_name) == 0 || strlen($file_name) > $MAX_FILENAME_LENGTH) { |
| 222 | - error_log('Invalid file name: ' . $file_name . '.'); |
|
| 222 | + error_log('Invalid file name: '.$file_name.'.'); |
|
| 223 | 223 | echo handleUploadError('Invalid file name provided.'); |
| 224 | 224 | return false; |
| 225 | 225 | } |
@@ -233,13 +233,13 @@ discard block |
||
| 233 | 233 | $ext = strtolower($ext); |
| 234 | 234 | } else { |
| 235 | 235 | // Case where the file extension is not a string |
| 236 | - error_log('Invalid file name: ' . $file_name . '.'); |
|
| 236 | + error_log('Invalid file name: '.$file_name.'.'); |
|
| 237 | 237 | echo handleUploadError('Invalid file extension.'); |
| 238 | 238 | return false; |
| 239 | 239 | } |
| 240 | 240 | } else { |
| 241 | 241 | // Case where the file name is not a string |
| 242 | - error_log('Invalid file name: ' . $file_name . '.'); |
|
| 242 | + error_log('Invalid file name: '.$file_name.'.'); |
|
| 243 | 243 | echo handleUploadError('Invalid file.'); |
| 244 | 244 | return false; |
| 245 | 245 | } |
@@ -247,8 +247,8 @@ discard block |
||
| 247 | 247 | // Validate against a list of allowed extensions |
| 248 | 248 | $allowed_extensions = explode( |
| 249 | 249 | ',', |
| 250 | - $SETTINGS['upload_docext'] . ',' . $SETTINGS['upload_imagesext'] . |
|
| 251 | - ',' . $SETTINGS['upload_pkgext'] . ',' . $SETTINGS['upload_otherext'] |
|
| 250 | + $SETTINGS['upload_docext'].','.$SETTINGS['upload_imagesext']. |
|
| 251 | + ','.$SETTINGS['upload_pkgext'].','.$SETTINGS['upload_otherext'] |
|
| 252 | 252 | ); |
| 253 | 253 | |
| 254 | 254 | // Check if we should enforce extensions |
@@ -271,25 +271,25 @@ discard block |
||
| 271 | 271 | |
| 272 | 272 | // is destination folder writable |
| 273 | 273 | if (is_writable($SETTINGS['path_to_files_folder']) === false) { |
| 274 | - echo handleUploadError('Not enough permissions on folder ' . $SETTINGS['path_to_files_folder'] . '.'); |
|
| 274 | + echo handleUploadError('Not enough permissions on folder '.$SETTINGS['path_to_files_folder'].'.'); |
|
| 275 | 275 | return false; |
| 276 | 276 | } |
| 277 | 277 | |
| 278 | 278 | // Make sure the fileName is unique but only if chunking is disabled |
| 279 | -if ($chunks < 2 && file_exists($targetDir . DIRECTORY_SEPARATOR . $fileName)) { |
|
| 279 | +if ($chunks < 2 && file_exists($targetDir.DIRECTORY_SEPARATOR.$fileName)) { |
|
| 280 | 280 | // $ext is guaranteed to be a string due to prior checks |
| 281 | 281 | $fileNameA = substr($fileName, 0, strlen(/** @scrutinizer ignore-type */$ext)); |
| 282 | 282 | $fileNameB = substr($fileName, strlen(/** @scrutinizer ignore-type */$ext)); |
| 283 | 283 | |
| 284 | 284 | $count = 1; |
| 285 | - while (file_exists($targetDir . DIRECTORY_SEPARATOR . $fileNameA . '_' . $count . $fileNameB)) { |
|
| 285 | + while (file_exists($targetDir.DIRECTORY_SEPARATOR.$fileNameA.'_'.$count.$fileNameB)) { |
|
| 286 | 286 | ++$count; |
| 287 | 287 | } |
| 288 | 288 | |
| 289 | - $fileName = $fileNameA . '_' . $count . $fileNameB; |
|
| 289 | + $fileName = $fileNameA.'_'.$count.$fileNameB; |
|
| 290 | 290 | } |
| 291 | 291 | |
| 292 | -$filePath = $targetDir . DIRECTORY_SEPARATOR . $fileName; |
|
| 292 | +$filePath = $targetDir.DIRECTORY_SEPARATOR.$fileName; |
|
| 293 | 293 | |
| 294 | 294 | // Create target dir |
| 295 | 295 | if (!file_exists($targetDir)) { |
@@ -303,7 +303,7 @@ discard block |
||
| 303 | 303 | // Remove old temp files |
| 304 | 304 | if ($cleanupTargetDir && is_dir($targetDir) && ($dir = opendir($targetDir))) { |
| 305 | 305 | while (($fileClean = readdir($dir)) !== false) { |
| 306 | - $tmpfilePath = $targetDir . DIRECTORY_SEPARATOR . $fileClean; |
|
| 306 | + $tmpfilePath = $targetDir.DIRECTORY_SEPARATOR.$fileClean; |
|
| 307 | 307 | |
| 308 | 308 | // Remove temp file if it is older than the max age and is not the current file |
| 309 | 309 | if ( |
@@ -317,7 +317,7 @@ discard block |
||
| 317 | 317 | |
| 318 | 318 | closedir($dir); |
| 319 | 319 | } else { |
| 320 | - echo handleUploadError('Not enough permissions on folder ' . $SETTINGS['path_to_files_folder'] . '.'); |
|
| 320 | + echo handleUploadError('Not enough permissions on folder '.$SETTINGS['path_to_files_folder'].'.'); |
|
| 321 | 321 | return false; |
| 322 | 322 | } |
| 323 | 323 | |
@@ -353,7 +353,7 @@ discard block |
||
| 353 | 353 | |
| 354 | 354 | // Safe destination folder |
| 355 | 355 | $uploadDir = realpath($SETTINGS['path_to_upload_folder']); |
| 356 | - $destinationPath = $uploadDir . DIRECTORY_SEPARATOR . $fileName; |
|
| 356 | + $destinationPath = $uploadDir.DIRECTORY_SEPARATOR.$fileName; |
|
| 357 | 357 | |
| 358 | 358 | if (move_uploaded_file($tmpFilePath, $destinationPath)) { |
| 359 | 359 | // Open the moved file in read mode |
@@ -394,7 +394,7 @@ discard block |
||
| 394 | 394 | return false; |
| 395 | 395 | } |
| 396 | 396 | } else { |
| 397 | - echo handleUploadError('Failed to move uploaded file to ' . $SETTINGS['path_to_files_folder'] . '.'); |
|
| 397 | + echo handleUploadError('Failed to move uploaded file to '.$SETTINGS['path_to_files_folder'].'.'); |
|
| 398 | 398 | return false; |
| 399 | 399 | } |
| 400 | 400 | } else { |
@@ -410,14 +410,14 @@ discard block |
||
| 410 | 410 | fwrite($out, $buff); |
| 411 | 411 | } |
| 412 | 412 | } else { |
| 413 | - echo handleUploadError('Failed to open input stream ' . $SETTINGS['path_to_files_folder'] . '.'); |
|
| 413 | + echo handleUploadError('Failed to open input stream '.$SETTINGS['path_to_files_folder'].'.'); |
|
| 414 | 414 | return false; |
| 415 | 415 | } |
| 416 | 416 | |
| 417 | 417 | fclose($in); |
| 418 | 418 | fclose($out); |
| 419 | 419 | } else { |
| 420 | - echo handleUploadError('Failed to open output stream ' . $SETTINGS['path_to_files_folder'] . '.'); |
|
| 420 | + echo handleUploadError('Failed to open output stream '.$SETTINGS['path_to_files_folder'].'.'); |
|
| 421 | 421 | return false; |
| 422 | 422 | } |
| 423 | 423 | } |
@@ -450,7 +450,7 @@ discard block |
||
| 450 | 450 | ) { |
| 451 | 451 | rename( |
| 452 | 452 | $filePath, |
| 453 | - $targetDir . DIRECTORY_SEPARATOR . $newFileName |
|
| 453 | + $targetDir.DIRECTORY_SEPARATOR.$newFileName |
|
| 454 | 454 | ); |
| 455 | 455 | |
| 456 | 456 | // Add in DB |
@@ -479,7 +479,7 @@ discard block |
||
| 479 | 479 | ) { |
| 480 | 480 | rename( |
| 481 | 481 | $filePath, |
| 482 | - $targetDir . DIRECTORY_SEPARATOR . $newFileName |
|
| 482 | + $targetDir.DIRECTORY_SEPARATOR.$newFileName |
|
| 483 | 483 | ); |
| 484 | 484 | |
| 485 | 485 | // Add in DB |
@@ -512,13 +512,13 @@ discard block |
||
| 512 | 512 | // rename the file |
| 513 | 513 | rename( |
| 514 | 514 | $filePath, |
| 515 | - $targetDir . DIRECTORY_SEPARATOR . $newFileName . '.' . $ext |
|
| 515 | + $targetDir.DIRECTORY_SEPARATOR.$newFileName.'.'.$ext |
|
| 516 | 516 | ); |
| 517 | 517 | |
| 518 | 518 | // make thumbnail |
| 519 | 519 | $ret = makeThumbnail( |
| 520 | - $targetDir . DIRECTORY_SEPARATOR . $newFileName . '.' . $ext, |
|
| 521 | - $targetDir . DIRECTORY_SEPARATOR . $newFileName . '_thumb' . '.' . $ext, |
|
| 520 | + $targetDir.DIRECTORY_SEPARATOR.$newFileName.'.'.$ext, |
|
| 521 | + $targetDir.DIRECTORY_SEPARATOR.$newFileName.'_thumb'.'.'.$ext, |
|
| 522 | 522 | 40 |
| 523 | 523 | ); |
| 524 | 524 | |
@@ -530,21 +530,21 @@ discard block |
||
| 530 | 530 | } |
| 531 | 531 | |
| 532 | 532 | // get current avatar and delete it |
| 533 | - $data = DB::queryFirstRow('SELECT avatar, avatar_thumb FROM ' . prefixTable('users') . ' WHERE id=%i', $session->get('user-id')); |
|
| 534 | - fileDelete($targetDir . DIRECTORY_SEPARATOR . $data['avatar'], $SETTINGS); |
|
| 535 | - fileDelete($targetDir . DIRECTORY_SEPARATOR . $data['avatar_thumb'], $SETTINGS); |
|
| 533 | + $data = DB::queryFirstRow('SELECT avatar, avatar_thumb FROM '.prefixTable('users').' WHERE id=%i', $session->get('user-id')); |
|
| 534 | + fileDelete($targetDir.DIRECTORY_SEPARATOR.$data['avatar'], $SETTINGS); |
|
| 535 | + fileDelete($targetDir.DIRECTORY_SEPARATOR.$data['avatar_thumb'], $SETTINGS); |
|
| 536 | 536 | |
| 537 | 537 | // store in DB the new avatar |
| 538 | 538 | DB::query( |
| 539 | - 'UPDATE ' . prefixTable('users') . " |
|
| 540 | - SET avatar='" . $newFileName . '.' . $ext . "', avatar_thumb='" . $newFileName . '_thumb' . '.' . $ext . "' |
|
| 539 | + 'UPDATE '.prefixTable('users')." |
|
| 540 | + SET avatar='" . $newFileName.'.'.$ext."', avatar_thumb='".$newFileName.'_thumb'.'.'.$ext."' |
|
| 541 | 541 | WHERE id=%i", |
| 542 | 542 | $session->get('user-id') |
| 543 | 543 | ); |
| 544 | 544 | |
| 545 | 545 | // store in session |
| 546 | - $session->set('user-avatar', $newFileName . '.' . $ext); |
|
| 547 | - $session->set('user-avatar_thumb', $newFileName . '_thumb' . '.' . $ext); |
|
| 546 | + $session->set('user-avatar', $newFileName.'.'.$ext); |
|
| 547 | + $session->set('user-avatar_thumb', $newFileName.'_thumb'.'.'.$ext); |
|
| 548 | 548 | |
| 549 | 549 | // return info |
| 550 | 550 | echo prepareExchangedData( |
@@ -563,7 +563,7 @@ discard block |
||
| 563 | 563 | ) { |
| 564 | 564 | rename( |
| 565 | 565 | $filePath, |
| 566 | - $targetDir . DIRECTORY_SEPARATOR . $newFileName |
|
| 566 | + $targetDir.DIRECTORY_SEPARATOR.$newFileName |
|
| 567 | 567 | ); |
| 568 | 568 | |
| 569 | 569 | // Add in DB |
@@ -70,7 +70,7 @@ discard block |
||
| 70 | 70 | || isset($SETTINGS['allow_import']) === false || (int) $SETTINGS['allow_import'] !== 1) { |
| 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 | |
@@ -85,9 +85,9 @@ discard block |
||
| 85 | 85 | |
| 86 | 86 | if ((int) $session->get('user-admin') === 1) { |
| 87 | 87 | $folderOptions = ''; |
| 88 | - $rows = DB::query('SELECT id, title FROM ' . prefixTable('nested_tree') . ' WHERE personal_folder = %i', 0); |
|
| 88 | + $rows = DB::query('SELECT id, title FROM '.prefixTable('nested_tree').' WHERE personal_folder = %i', 0); |
|
| 89 | 89 | foreach ($rows as $record) { |
| 90 | - $folderOptions .= '<option value="' . $record['id'] . '">' . htmlspecialchars($record['title'], ENT_QUOTES, 'UTF-8') . '</option>'; |
|
| 90 | + $folderOptions .= '<option value="'.$record['id'].'">'.htmlspecialchars($record['title'], ENT_QUOTES, 'UTF-8').'</option>'; |
|
| 91 | 91 | } |
| 92 | 92 | } |
| 93 | 93 | |
@@ -189,7 +189,7 @@ discard block |
||
| 189 | 189 | <?php |
| 190 | 190 | $complexitySelect = ''; |
| 191 | 191 | foreach (TP_PW_COMPLEXITY as $level) { |
| 192 | - $complexitySelect .= '<option value="' . $level[0] . '">' . $level[1] . '</option>'; |
|
| 192 | + $complexitySelect .= '<option value="'.$level[0].'">'.$level[1].'</option>'; |
|
| 193 | 193 | } |
| 194 | 194 | echo $complexitySelect; |
| 195 | 195 | ?> |
@@ -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 | ?> |
@@ -511,7 +511,7 @@ discard block |
||
| 511 | 511 | const errorMessages = JSON.parse(response.message); |
| 512 | 512 | let errorHtml = '<ul>'; |
| 513 | 513 | errorMessages.forEach(function(error) { |
| 514 | - errorHtml += '<li><?php echo $lang->get('import_error_folder_creation');?> "<b>'+error.errorPath+'</b>": '+error.errorMessage+'</li>'; |
|
| 514 | + errorHtml += '<li><?php echo $lang->get('import_error_folder_creation'); ?> "<b>'+error.errorPath+'</b>": '+error.errorMessage+'</li>'; |
|
| 515 | 515 | }); |
| 516 | 516 | |
| 517 | 517 | $('#import-feedback-progress-text').html( |
@@ -997,7 +997,7 @@ discard block |
||
| 997 | 997 | // Isolate first item |
| 998 | 998 | if (itemsList.length > 0) { |
| 999 | 999 | $('#import-feedback-progress-text') |
| 1000 | - .html('<i class="fa-solid fa-cog fa-spin ml-4 mr-2"></i><?php echo $lang->get('operation_progress');?> ('+((counter*100)/itemsNumber).toFixed(0)+'%)'); |
|
| 1000 | + .html('<i class="fa-solid fa-cog fa-spin ml-4 mr-2"></i><?php echo $lang->get('operation_progress'); ?> ('+((counter*100)/itemsNumber).toFixed(0)+'%)'); |
|
| 1001 | 1001 | |
| 1002 | 1002 | data = { |
| 1003 | 1003 | 'edit-all': $('#import-keepass-edit-all-checkbox').prop('checked') === true ? 1 : 0, |
@@ -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 | |
@@ -101,7 +101,7 @@ discard block |
||
| 101 | 101 | // Is a date sent? |
| 102 | 102 | $dateCriteria = $request->query->get('dateCriteria'); |
| 103 | 103 | if ($dateCriteria !== null && !empty($dateCriteria)) { |
| 104 | - $sWhere .= ' AND a.del_value < ' . round(filter_var($dateCriteria, FILTER_SANITIZE_NUMBER_INT) / 1000, 0); |
|
| 104 | + $sWhere .= ' AND a.del_value < '.round(filter_var($dateCriteria, FILTER_SANITIZE_NUMBER_INT) / 1000, 0); |
|
| 105 | 105 | } |
| 106 | 106 | //echo $sWhere; |
| 107 | 107 | /* BUILD QUERY */ |
@@ -110,7 +110,7 @@ discard block |
||
| 110 | 110 | $start = $request->query->getInt('start', 0); |
| 111 | 111 | $length = $request->query->getInt('length', -1); |
| 112 | 112 | if ($length !== -1) { |
| 113 | - $sLimit = ' LIMIT ' . $start . ', ' . $length; |
|
| 113 | + $sLimit = ' LIMIT '.$start.', '.$length; |
|
| 114 | 114 | } |
| 115 | 115 | |
| 116 | 116 | //Ordering |
@@ -123,7 +123,7 @@ discard block |
||
| 123 | 123 | $columnIndex = filter_var($order[0]['column'], FILTER_SANITIZE_NUMBER_INT); |
| 124 | 124 | |
| 125 | 125 | if (array_key_exists($columnIndex, $aColumns)) { |
| 126 | - $sOrder .= $aColumns[$columnIndex] . ' ' . $order[0]['dir']; |
|
| 126 | + $sOrder .= $aColumns[$columnIndex].' '.$order[0]['dir']; |
|
| 127 | 127 | } |
| 128 | 128 | |
| 129 | 129 | // Supprimez la virgule finale si elle existe |
@@ -147,9 +147,9 @@ discard block |
||
| 147 | 147 | |
| 148 | 148 | if ($letter !== '' && $letter !== 'None') { |
| 149 | 149 | $sWhere .= ' AND '; |
| 150 | - $sWhere .= $aColumns[1] . " LIKE '" . $letter . "%' OR "; |
|
| 151 | - $sWhere .= $aColumns[2] . " LIKE '" . $letter . "%' OR "; |
|
| 152 | - $sWhere .= $aColumns[3] . " LIKE '" . $letter . "%' "; |
|
| 150 | + $sWhere .= $aColumns[1]." LIKE '".$letter."%' OR "; |
|
| 151 | + $sWhere .= $aColumns[2]." LIKE '".$letter."%' OR "; |
|
| 152 | + $sWhere .= $aColumns[3]." LIKE '".$letter."%' "; |
|
| 153 | 153 | } |
| 154 | 154 | } |
| 155 | 155 | |
@@ -160,26 +160,26 @@ discard block |
||
| 160 | 160 | |
| 161 | 161 | if ($searchValue !== '') { |
| 162 | 162 | $sWhere = ' AND '; |
| 163 | - $sWhere .= $aColumns[1] . " LIKE '" . $searchValue . "%' OR "; |
|
| 164 | - $sWhere .= $aColumns[2] . " LIKE '" . $searchValue . "%' OR "; |
|
| 165 | - $sWhere .= $aColumns[3] . " LIKE '" . $searchValue . "%' "; |
|
| 163 | + $sWhere .= $aColumns[1]." LIKE '".$searchValue."%' OR "; |
|
| 164 | + $sWhere .= $aColumns[2]." LIKE '".$searchValue."%' OR "; |
|
| 165 | + $sWhere .= $aColumns[3]." LIKE '".$searchValue."%' "; |
|
| 166 | 166 | } |
| 167 | 167 | } |
| 168 | 168 | } |
| 169 | 169 | |
| 170 | 170 | $rows = DB::query( |
| 171 | 171 | 'SELECT a.item_id, i.label, a.del_value, i.id_tree |
| 172 | - FROM ' . prefixTable('automatic_del') . ' AS a |
|
| 173 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (i.id = a.item_id)' . |
|
| 172 | + FROM ' . prefixTable('automatic_del').' AS a |
|
| 173 | + INNER JOIN ' . prefixTable('items').' AS i ON (i.id = a.item_id)'. |
|
| 174 | 174 | $sWhere. |
| 175 | 175 | (string) $sOrder |
| 176 | 176 | ); |
| 177 | 177 | $iTotal = DB::count(); |
| 178 | 178 | $rows = DB::query( |
| 179 | 179 | 'SELECT a.item_id, i.label, a.del_value, i.id_tree |
| 180 | - FROM ' . prefixTable('automatic_del') . ' AS a |
|
| 181 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (i.id = a.item_id)' . |
|
| 182 | - $sWhere . |
|
| 180 | + FROM ' . prefixTable('automatic_del').' AS a |
|
| 181 | + INNER JOIN ' . prefixTable('items').' AS i ON (i.id = a.item_id)'. |
|
| 182 | + $sWhere. |
|
| 183 | 183 | $sLimit |
| 184 | 184 | ); |
| 185 | 185 | $iFilteredTotal = DB::count(); |
@@ -187,7 +187,7 @@ discard block |
||
| 187 | 187 | * Output |
| 188 | 188 | */ |
| 189 | 189 | $sOutput = '{'; |
| 190 | -$sOutput .= '"sEcho": '. (int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT) . ', '; |
|
| 190 | +$sOutput .= '"sEcho": '.(int) $request->query->filter('draw', FILTER_SANITIZE_NUMBER_INT).', '; |
|
| 191 | 191 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
| 192 | 192 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
| 193 | 193 | $sOutput .= '"aaData": '; |
@@ -201,18 +201,18 @@ discard block |
||
| 201 | 201 | // start the line |
| 202 | 202 | $sOutput .= '['; |
| 203 | 203 | // Column 1 |
| 204 | - $sOutput .= '"<i class=\"fas fa-external-link-alt pointer text-primary mr-2\" onclick=\"showItemCard($(this))\" data-item-id=\"' . $record['item_id'] . '\" data-item-tree-id=\"' . $record['id_tree'] . '\"></i>", '; |
|
| 204 | + $sOutput .= '"<i class=\"fas fa-external-link-alt pointer text-primary mr-2\" onclick=\"showItemCard($(this))\" data-item-id=\"'.$record['item_id'].'\" data-item-tree-id=\"'.$record['id_tree'].'\"></i>", '; |
|
| 205 | 205 | // Column 2 |
| 206 | - $sOutput .= '"' . $record['label'] . '", '; |
|
| 206 | + $sOutput .= '"'.$record['label'].'", '; |
|
| 207 | 207 | // Column 3 |
| 208 | - $sOutput .= '"' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['del_value']) . '", '; |
|
| 208 | + $sOutput .= '"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['del_value']).'", '; |
|
| 209 | 209 | // Column 4 |
| 210 | 210 | $path = []; |
| 211 | 211 | $treeDesc = $tree->getPath($record['id_tree'], true); |
| 212 | 212 | foreach ($treeDesc as $t) { |
| 213 | 213 | array_push($path, $t->title); |
| 214 | 214 | } |
| 215 | - $sOutput .= '"' . implode('<i class=\"fas fa-angle-right ml-1 mr-1\"></i>', $path) . '"],'; |
|
| 215 | + $sOutput .= '"'.implode('<i class=\"fas fa-angle-right ml-1 mr-1\"></i>', $path).'"],'; |
|
| 216 | 216 | } |
| 217 | 217 | |
| 218 | 218 | if (count($rows) > 0) { |
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | ) { |
| 78 | 78 | // Not allowed page |
| 79 | 79 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
| 80 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 80 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 81 | 81 | exit; |
| 82 | 82 | } |
| 83 | 83 | |
@@ -128,7 +128,7 @@ discard block |
||
| 128 | 128 | $arrFolders = array(); |
| 129 | 129 | $rows = DB::query( |
| 130 | 130 | 'SELECT valeur, intitule |
| 131 | - FROM ' . prefixTable('misc') . ' |
|
| 131 | + FROM ' . prefixTable('misc').' |
|
| 132 | 132 | WHERE type = %s', |
| 133 | 133 | 'folder_deleted' |
| 134 | 134 | ); |
@@ -151,11 +151,11 @@ discard block |
||
| 151 | 151 | i.id as id, i.label as label, |
| 152 | 152 | i.id_tree as id_tree, l.date as date, n.title as folder_title, |
| 153 | 153 | a.del_enabled as del_enabled, a.del_value as del_value, a.del_type as del_type |
| 154 | - FROM ' . prefixTable('log_items') . ' as l |
|
| 155 | - INNER JOIN ' . prefixTable('items') . ' as i ON (l.id_item=i.id) |
|
| 156 | - LEFT JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id) |
|
| 157 | - LEFT JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree=n.id) |
|
| 158 | - INNER JOIN ' . prefixTable('automatic_del') . ' as a ON (l.id_item = a.item_id) |
|
| 154 | + FROM ' . prefixTable('log_items').' as l |
|
| 155 | + INNER JOIN ' . prefixTable('items').' as i ON (l.id_item=i.id) |
|
| 156 | + LEFT JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id) |
|
| 157 | + LEFT JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree=n.id) |
|
| 158 | + INNER JOIN ' . prefixTable('automatic_del').' as a ON (l.id_item = a.item_id) |
|
| 159 | 159 | WHERE i.inactif = %i |
| 160 | 160 | AND l.action = %s', |
| 161 | 161 | 1, |
@@ -177,7 +177,7 @@ discard block |
||
| 177 | 177 | 'label' => $record['label'], |
| 178 | 178 | 'date' => date($SETTINGS['date_format'], (int) $record['date']), |
| 179 | 179 | 'login' => $record['login'], |
| 180 | - 'name' => $record['name'] . ' ' . $record['lastname'], |
|
| 180 | + 'name' => $record['name'].' '.$record['lastname'], |
|
| 181 | 181 | 'folder_label' => $record['folder_title'], |
| 182 | 182 | 'folder_deleted' => $thisFolder, |
| 183 | 183 | 'del_enabled' => (bool) $record['del_enabled'], |
@@ -238,10 +238,10 @@ discard block |
||
| 238 | 238 | foreach ($post_folders as $folderId) { |
| 239 | 239 | $data = DB::queryFirstRow( |
| 240 | 240 | 'SELECT valeur |
| 241 | - FROM ' . prefixTable('misc') . " |
|
| 241 | + FROM ' . prefixTable('misc')." |
|
| 242 | 242 | WHERE type = 'folder_deleted' |
| 243 | 243 | AND intitule = %s", |
| 244 | - 'f' . $folderId |
|
| 244 | + 'f'.$folderId |
|
| 245 | 245 | ); |
| 246 | 246 | if ((int) $data['valeur'] !== 0) { |
| 247 | 247 | $folderData = explode(', ', $data['valeur']); |
@@ -268,7 +268,7 @@ discard block |
||
| 268 | 268 | prefixTable('misc'), |
| 269 | 269 | 'type = %s AND intitule = %s', |
| 270 | 270 | 'folder_deleted', |
| 271 | - 'f' . $folderId |
|
| 271 | + 'f'.$folderId |
|
| 272 | 272 | ); |
| 273 | 273 | |
| 274 | 274 | // Restore all items in this folder |
@@ -284,7 +284,7 @@ discard block |
||
| 284 | 284 | // Get list of all items in thos folder |
| 285 | 285 | $items = DB::query( |
| 286 | 286 | 'SELECT id |
| 287 | - FROM ' . prefixTable('items') . ' |
|
| 287 | + FROM ' . prefixTable('items').' |
|
| 288 | 288 | WHERE id_tree = %i', |
| 289 | 289 | $folderId |
| 290 | 290 | ); |
@@ -373,10 +373,10 @@ discard block |
||
| 373 | 373 | foreach ($post_folders as $folderId) { |
| 374 | 374 | $data = DB::queryFirstRow( |
| 375 | 375 | 'SELECT valeur |
| 376 | - FROM ' . prefixTable('misc') . " |
|
| 376 | + FROM ' . prefixTable('misc')." |
|
| 377 | 377 | WHERE type = 'folder_deleted' |
| 378 | 378 | AND intitule = %s", |
| 379 | - 'f' . $folderId |
|
| 379 | + 'f'.$folderId |
|
| 380 | 380 | ); |
| 381 | 381 | if ((int) $data['valeur'] !== 0) { |
| 382 | 382 | $exploded = explode(',', $data['valeur']); |
@@ -387,7 +387,7 @@ discard block |
||
| 387 | 387 | prefixTable('misc'), |
| 388 | 388 | 'type = %s AND intitule = %s', |
| 389 | 389 | 'folder_deleted', |
| 390 | - 'f' . $folderData[0] |
|
| 390 | + 'f'.$folderData[0] |
|
| 391 | 391 | ); |
| 392 | 392 | |
| 393 | 393 | // Delete all items in this folder |
@@ -401,7 +401,7 @@ discard block |
||
| 401 | 401 | // Get list of all items in thos folder |
| 402 | 402 | $items = DB::query( |
| 403 | 403 | 'SELECT id |
| 404 | - FROM ' . prefixTable('items') . ' |
|
| 404 | + FROM ' . prefixTable('items').' |
|
| 405 | 405 | WHERE id_tree = %i', |
| 406 | 406 | $folderData[0] |
| 407 | 407 | ); |
@@ -418,7 +418,7 @@ discard block |
||
| 418 | 418 | // Delete all fields |
| 419 | 419 | $fields = DB::query( |
| 420 | 420 | 'SELECT id |
| 421 | - FROM ' . prefixTable('categories_items') . ' |
|
| 421 | + FROM ' . prefixTable('categories_items').' |
|
| 422 | 422 | WHERE item_id = %i', |
| 423 | 423 | $folderData[0] |
| 424 | 424 | ); |
@@ -438,7 +438,7 @@ discard block |
||
| 438 | 438 | // Delete all files |
| 439 | 439 | $files = DB::query( |
| 440 | 440 | 'SELECT id |
| 441 | - FROM ' . prefixTable('files') . ' |
|
| 441 | + FROM ' . prefixTable('files').' |
|
| 442 | 442 | WHERE id_item = %i', |
| 443 | 443 | $folderData[0] |
| 444 | 444 | ); |
@@ -495,7 +495,7 @@ discard block |
||
| 495 | 495 | // Delete sharekey fields |
| 496 | 496 | $itemFields = DB::query( |
| 497 | 497 | 'SELECT id |
| 498 | - FROM ' . prefixTable('categories_items') . ' |
|
| 498 | + FROM ' . prefixTable('categories_items').' |
|
| 499 | 499 | WHERE item_id = %i', |
| 500 | 500 | $itemId |
| 501 | 501 | ); |
@@ -510,7 +510,7 @@ discard block |
||
| 510 | 510 | // Delete sharekey files |
| 511 | 511 | $itemFiles = DB::query( |
| 512 | 512 | 'SELECT id |
| 513 | - FROM ' . prefixTable('files') . ' |
|
| 513 | + FROM ' . prefixTable('files').' |
|
| 514 | 514 | WHERE id_item = %i', |
| 515 | 515 | $itemId |
| 516 | 516 | ); |
@@ -587,7 +587,7 @@ discard block |
||
| 587 | 587 | ) { |
| 588 | 588 | if ($post_log_type === 'items') { |
| 589 | 589 | DB::query( |
| 590 | - 'SELECT * FROM ' . prefixTable('log_items') . ' |
|
| 590 | + 'SELECT * FROM '.prefixTable('log_items').' |
|
| 591 | 591 | WHERE (date BETWEEN %i AND %i)' |
| 592 | 592 | . ($post_filter_action === 'all' ? '' : ' AND action = "'.$post_filter_action.'"') |
| 593 | 593 | . ((int) $post_filter_user === -1 ? '' : ' AND id_user = '.(int) $post_filter_user), |
@@ -607,7 +607,7 @@ discard block |
||
| 607 | 607 | } elseif ($post_log_type === 'connections') { |
| 608 | 608 | //db::debugmode(true); |
| 609 | 609 | DB::query( |
| 610 | - 'SELECT * FROM ' . prefixTable('log_system') . ' |
|
| 610 | + 'SELECT * FROM '.prefixTable('log_system').' |
|
| 611 | 611 | WHERE type=%s ' |
| 612 | 612 | . 'AND (date BETWEEN %i AND %i)' |
| 613 | 613 | . ($post_filter_action === 'all' ? '' : ' AND action = '.$post_filter_action) |
@@ -630,7 +630,7 @@ discard block |
||
| 630 | 630 | ); |
| 631 | 631 | } elseif ($post_log_type === 'errors') { |
| 632 | 632 | DB::query( |
| 633 | - 'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' . |
|
| 633 | + 'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '. |
|
| 634 | 634 | 'AND (date BETWEEN %i AND %i)', |
| 635 | 635 | 'error', |
| 636 | 636 | $post_date_from, |
@@ -647,7 +647,7 @@ discard block |
||
| 647 | 647 | ); |
| 648 | 648 | } elseif ($post_log_type === 'copy') { |
| 649 | 649 | DB::query( |
| 650 | - 'SELECT * FROM ' . prefixTable('log_items') . ' WHERE action=%s ' . |
|
| 650 | + 'SELECT * FROM '.prefixTable('log_items').' WHERE action=%s '. |
|
| 651 | 651 | 'AND (date BETWEEN %i AND %i)', |
| 652 | 652 | 'at_copy', |
| 653 | 653 | $post_date_from, |
@@ -664,7 +664,7 @@ discard block |
||
| 664 | 664 | ); |
| 665 | 665 | } elseif ($post_log_type === 'admin') { |
| 666 | 666 | DB::query( |
| 667 | - 'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' . |
|
| 667 | + 'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '. |
|
| 668 | 668 | 'AND (date BETWEEN %i AND %i)', |
| 669 | 669 | 'admin_action', |
| 670 | 670 | $post_date_from, |
@@ -681,7 +681,7 @@ discard block |
||
| 681 | 681 | ); |
| 682 | 682 | } elseif ($post_log_type === 'failed') { |
| 683 | 683 | DB::query( |
| 684 | - 'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' . |
|
| 684 | + 'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '. |
|
| 685 | 685 | 'AND (date BETWEEN %i AND %i)', |
| 686 | 686 | 'failed_auth', |
| 687 | 687 | $post_date_from, |
@@ -752,19 +752,19 @@ discard block |
||
| 752 | 752 | // Get info about task |
| 753 | 753 | $taskInfo = DB::queryFirstRow( |
| 754 | 754 | 'SELECT p.process_type as process_type |
| 755 | - FROM ' . prefixTable('background_tasks') . ' as p |
|
| 755 | + FROM ' . prefixTable('background_tasks').' as p |
|
| 756 | 756 | WHERE p.increment_id = %i', |
| 757 | 757 | $post_id |
| 758 | 758 | ); |
| 759 | 759 | if ($taskInfo !== null) { |
| 760 | 760 | // delete task |
| 761 | 761 | DB::query( |
| 762 | - 'DELETE FROM ' . prefixTable('background_subtasks') . ' |
|
| 762 | + 'DELETE FROM '.prefixTable('background_subtasks').' |
|
| 763 | 763 | WHERE task_id = %i', |
| 764 | 764 | $post_id |
| 765 | 765 | ); |
| 766 | 766 | DB::query( |
| 767 | - 'DELETE FROM ' . prefixTable('background_tasks') . ' |
|
| 767 | + 'DELETE FROM '.prefixTable('background_tasks').' |
|
| 768 | 768 | WHERE increment_id = %i', |
| 769 | 769 | $post_id |
| 770 | 770 | ); |
@@ -831,7 +831,7 @@ discard block |
||
| 831 | 831 | ->setDayOfMonth('*') |
| 832 | 832 | ->setMonths('*') |
| 833 | 833 | ->setDayOfWeek('*') |
| 834 | - ->setTaskCommandLine($phpBinaryPath . ' ' . $SETTINGS['cpassman_dir'] . '/sources/scheduler.php') |
|
| 834 | + ->setTaskCommandLine($phpBinaryPath.' '.$SETTINGS['cpassman_dir'].'/sources/scheduler.php') |
|
| 835 | 835 | ->setComments('Teampass scheduler'); |
| 836 | 836 | |
| 837 | 837 | $crontabRepository->addJob($crontabJob); |
@@ -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", |
@@ -114,8 +114,8 @@ discard block |
||
| 114 | 114 | |
| 115 | 115 | // Remove very old failed tasks |
| 116 | 116 | DB::query( |
| 117 | - 'DELETE t, st FROM ' . prefixTable('background_tasks') . ' t |
|
| 118 | - INNER JOIN ' . prefixTable('background_subtasks') . ' st ON (t.increment_id = st.task_id) |
|
| 117 | + 'DELETE t, st FROM '.prefixTable('background_tasks').' t |
|
| 118 | + INNER JOIN ' . prefixTable('background_subtasks').' st ON (t.increment_id = st.task_id) |
|
| 119 | 119 | WHERE t.finished_at < %i |
| 120 | 120 | AND t.status = %s', |
| 121 | 121 | time() - $this->maxTimeBeforeRemoval, |
@@ -132,7 +132,7 @@ discard block |
||
| 132 | 132 | |
| 133 | 133 | // Check if the maximum number of parallel tasks is reached |
| 134 | 134 | if ($runningTasks >= $this->maxParallelTasks) { |
| 135 | - if (LOG_TASKS=== true) $this->logger->log('Wait ... '.$runningTasks.' out of '.$this->maxParallelTasks.' are already running ', 'INFO'); |
|
| 135 | + if (LOG_TASKS === true) $this->logger->log('Wait ... '.$runningTasks.' out of '.$this->maxParallelTasks.' are already running ', 'INFO'); |
|
| 136 | 136 | return; |
| 137 | 137 | } |
| 138 | 138 | |
@@ -141,7 +141,7 @@ discard block |
||
| 141 | 141 | // Fetch next batch of tasks |
| 142 | 142 | $tasks = DB::query( |
| 143 | 143 | 'SELECT increment_id, process_type, arguments |
| 144 | - FROM ' . prefixTable('background_tasks') . ' |
|
| 144 | + FROM ' . prefixTable('background_tasks').' |
|
| 145 | 145 | WHERE is_in_progress = 0 |
| 146 | 146 | AND (finished_at IS NULL OR finished_at = "") |
| 147 | 147 | ORDER BY increment_id ASC |
@@ -150,7 +150,7 @@ discard block |
||
| 150 | 150 | ); |
| 151 | 151 | |
| 152 | 152 | foreach ($tasks as $task) { |
| 153 | - if (LOG_TASKS=== true) $this->logger->log('Launching '.$task['increment_id'], 'INFO'); |
|
| 153 | + if (LOG_TASKS === true) $this->logger->log('Launching '.$task['increment_id'], 'INFO'); |
|
| 154 | 154 | $this->processIndividualTask($task); |
| 155 | 155 | } |
| 156 | 156 | } |
@@ -161,7 +161,7 @@ discard block |
||
| 161 | 161 | * @param array $task The task to process. |
| 162 | 162 | */ |
| 163 | 163 | private function processIndividualTask(array $task) { |
| 164 | - if (LOG_TASKS=== true) $this->logger->log('Starting task: ' . print_r($task, true), 'INFO'); |
|
| 164 | + if (LOG_TASKS === true) $this->logger->log('Starting task: '.print_r($task, true), 'INFO'); |
|
| 165 | 165 | |
| 166 | 166 | // Store progress in the database |
| 167 | 167 | DB::update( |
@@ -179,19 +179,19 @@ discard block |
||
| 179 | 179 | // Prepare process |
| 180 | 180 | $process = new Process([ |
| 181 | 181 | PHP_BINARY, |
| 182 | - __DIR__ . '/background_tasks___worker.php', |
|
| 182 | + __DIR__.'/background_tasks___worker.php', |
|
| 183 | 183 | $task['increment_id'], |
| 184 | 184 | $task['process_type'], |
| 185 | 185 | $task['arguments'] |
| 186 | 186 | ]); |
| 187 | 187 | |
| 188 | 188 | // Launch process |
| 189 | - try{ |
|
| 189 | + try { |
|
| 190 | 190 | $process->setTimeout($this->maxExecutionTime); |
| 191 | 191 | $process->mustRun(); |
| 192 | 192 | |
| 193 | 193 | } catch (Exception $e) { |
| 194 | - if (LOG_TASKS=== true) $this->logger->log('Error launching task: ' . $e->getMessage(), 'ERROR'); |
|
| 194 | + if (LOG_TASKS === true) $this->logger->log('Error launching task: '.$e->getMessage(), 'ERROR'); |
|
| 195 | 195 | DB::update( |
| 196 | 196 | prefixTable('background_tasks'), |
| 197 | 197 | [ |
@@ -213,7 +213,7 @@ discard block |
||
| 213 | 213 | private function countRunningTasks(): int { |
| 214 | 214 | return DB::queryFirstField( |
| 215 | 215 | 'SELECT COUNT(*) |
| 216 | - FROM ' . prefixTable('background_tasks') . ' |
|
| 216 | + FROM ' . prefixTable('background_tasks').' |
|
| 217 | 217 | WHERE is_in_progress = 1' |
| 218 | 218 | ); |
| 219 | 219 | } |
@@ -234,10 +234,10 @@ discard block |
||
| 234 | 234 | */ |
| 235 | 235 | private function cleanMultipleItemsEdition() { |
| 236 | 236 | DB::query( |
| 237 | - 'DELETE i1 FROM ' . prefixTable('items_edition') . ' i1 |
|
| 237 | + 'DELETE i1 FROM '.prefixTable('items_edition').' i1 |
|
| 238 | 238 | JOIN ( |
| 239 | 239 | SELECT user_id, item_id, MIN(timestamp) AS oldest_timestamp |
| 240 | - FROM ' . prefixTable('items_edition') . ' |
|
| 240 | + FROM ' . prefixTable('items_edition').' |
|
| 241 | 241 | GROUP BY user_id, item_id |
| 242 | 242 | ) i2 ON i1.user_id = i2.user_id AND i1.item_id = i2.item_id |
| 243 | 243 | WHERE i1.timestamp > i2.oldest_timestamp' |
@@ -250,7 +250,7 @@ discard block |
||
| 250 | 250 | */ |
| 251 | 251 | private function handleItemTokensExpiration() { |
| 252 | 252 | DB::query( |
| 253 | - 'DELETE FROM ' . prefixTable('items_edition') . ' |
|
| 253 | + 'DELETE FROM '.prefixTable('items_edition').' |
|
| 254 | 254 | WHERE timestamp < %i', |
| 255 | 255 | time() - ($this->settings['delay_item_edition'] * 60 ?: EDITION_LOCK_PERIOD) |
| 256 | 256 | ); |
@@ -267,7 +267,7 @@ discard block |
||
| 267 | 267 | // 1. Get all finished tasks older than the cutoff timestamp |
| 268 | 268 | // and that are not in progress |
| 269 | 269 | $tasks = DB::query( |
| 270 | - 'SELECT increment_id FROM ' . prefixTable('background_tasks') . ' |
|
| 270 | + 'SELECT increment_id FROM '.prefixTable('background_tasks').' |
|
| 271 | 271 | WHERE status = %s AND is_in_progress = %i AND finished_at < %s', |
| 272 | 272 | 'completed', |
| 273 | 273 | -1, |
@@ -282,19 +282,19 @@ discard block |
||
| 282 | 282 | |
| 283 | 283 | // 2. Delete all subtasks related to these tasks |
| 284 | 284 | DB::query( |
| 285 | - 'DELETE FROM ' . prefixTable('background_subtasks') . ' |
|
| 285 | + 'DELETE FROM '.prefixTable('background_subtasks').' |
|
| 286 | 286 | WHERE task_id IN %ls', |
| 287 | 287 | $taskIds |
| 288 | 288 | ); |
| 289 | 289 | |
| 290 | 290 | // 3. Delete the tasks themselves |
| 291 | 291 | DB::query( |
| 292 | - 'DELETE FROM ' . prefixTable('background_tasks') . ' |
|
| 292 | + 'DELETE FROM '.prefixTable('background_tasks').' |
|
| 293 | 293 | WHERE increment_id IN %ls', |
| 294 | 294 | $taskIds |
| 295 | 295 | ); |
| 296 | 296 | |
| 297 | - if (LOG_TASKS=== true) $this->logger->log('Old finished tasks cleaned: ' . count($taskIds), 'INFO'); |
|
| 297 | + if (LOG_TASKS === true) $this->logger->log('Old finished tasks cleaned: '.count($taskIds), 'INFO'); |
|
| 298 | 298 | } |
| 299 | 299 | } |
| 300 | 300 | |
@@ -308,5 +308,5 @@ discard block |
||
| 308 | 308 | $tasksHandler = new BackgroundTasksHandler($settings); |
| 309 | 309 | $tasksHandler->processBackgroundTasks(); |
| 310 | 310 | } catch (Exception $e) { |
| 311 | - error_log('Teampass Background Tasks Error: ' . $e->getMessage()); |
|
| 311 | + error_log('Teampass Background Tasks Error: '.$e->getMessage()); |
|
| 312 | 312 | } |
| 313 | 313 | \ No newline at end of file |
@@ -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 | // Mark subtask as in progress |
| 210 | 210 | DB::update( |
@@ -256,13 +256,13 @@ discard block |
||
| 256 | 256 | $subtask['increment_id'] |
| 257 | 257 | ); |
| 258 | 258 | |
| 259 | - $this->logger->log('processSubTasks : ' . $e->getMessage(), 'ERROR'); |
|
| 259 | + $this->logger->log('processSubTasks : '.$e->getMessage(), 'ERROR'); |
|
| 260 | 260 | } |
| 261 | 261 | } |
| 262 | 262 | |
| 263 | 263 | // Are all subtasks completed? |
| 264 | 264 | $remainingSubtasks = DB::queryFirstField( |
| 265 | - 'SELECT COUNT(*) FROM ' . prefixTable('background_subtasks') . ' WHERE task_id = %i AND is_in_progress = 0', |
|
| 265 | + 'SELECT COUNT(*) FROM '.prefixTable('background_subtasks').' WHERE task_id = %i AND is_in_progress = 0', |
|
| 266 | 266 | $this->taskId |
| 267 | 267 | ); |
| 268 | 268 | |
@@ -278,7 +278,7 @@ discard block |
||
| 278 | 278 | error_log("Usage: php background_tasks___worker.php <task_id> <process_type> [<task_data>]"); |
| 279 | 279 | exit(1); |
| 280 | 280 | } |
| 281 | -$taskId = (int)$argv[1]; |
|
| 281 | +$taskId = (int) $argv[1]; |
|
| 282 | 282 | $processType = $argv[2]; |
| 283 | 283 | $taskData = $argv[3] ?? null; |
| 284 | 284 | if ($taskData) { |
@@ -78,7 +78,7 @@ discard block |
||
| 78 | 78 | ) { |
| 79 | 79 | // Not allowed page |
| 80 | 80 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
| 81 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 81 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 82 | 82 | exit; |
| 83 | 83 | } |
| 84 | 84 | |
@@ -100,7 +100,7 @@ discard block |
||
| 100 | 100 | $antiXss = new AntiXSS(); |
| 101 | 101 | |
| 102 | 102 | // User's language loading |
| 103 | -require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $session->get('user-language') . '.php'; |
|
| 103 | +require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$session->get('user-language').'.php'; |
|
| 104 | 104 | |
| 105 | 105 | // Prepare POST variables |
| 106 | 106 | $id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT); |
@@ -151,9 +151,9 @@ discard block |
||
| 151 | 151 | 'SELECT i.id as id, i.id_tree as id_tree, i.restricted_to as restricted_to, i.perso as perso, |
| 152 | 152 | i.label as label, i.description as description, i.pw as pw, i.login as login, i.url as url, |
| 153 | 153 | i.email as email,l.date as date, i.pw_iv as pw_iv,n.renewal_period as renewal_period |
| 154 | - FROM ' . prefixTable('items') . ' as i |
|
| 155 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id) |
|
| 156 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item) |
|
| 154 | + FROM ' . prefixTable('items').' as i |
|
| 155 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id) |
|
| 156 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item) |
|
| 157 | 157 | WHERE i.inactif = %i |
| 158 | 158 | AND i.id_tree= %i |
| 159 | 159 | AND (l.action = %s OR (l.action = %s AND l.raison LIKE %s)) |
@@ -176,8 +176,8 @@ discard block |
||
| 176 | 176 | // Run query |
| 177 | 177 | $dataItem = DB::queryFirstRow( |
| 178 | 178 | 'SELECT i.pw AS pw, s.share_key AS share_key |
| 179 | - FROM ' . prefixTable('items') . ' AS i |
|
| 180 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id) |
|
| 179 | + FROM ' . prefixTable('items').' AS i |
|
| 180 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id) |
|
| 181 | 181 | WHERE user_id = %i AND i.id = %i', |
| 182 | 182 | $session->get('user-id'), |
| 183 | 183 | $record['id'] |
@@ -201,8 +201,8 @@ discard block |
||
| 201 | 201 | $arr_kbs = []; |
| 202 | 202 | $rows_kb = DB::query( |
| 203 | 203 | 'SELECT b.label, b.id |
| 204 | - FROM ' . prefixTable('kb_items') . ' AS a |
|
| 205 | - INNER JOIN ' . prefixTable('kb') . ' AS b ON (a.kb_id = b.id) |
|
| 204 | + FROM ' . prefixTable('kb_items').' AS a |
|
| 205 | + INNER JOIN ' . prefixTable('kb').' AS b ON (a.kb_id = b.id) |
|
| 206 | 206 | WHERE a.item_id = %i', |
| 207 | 207 | $record['id'] |
| 208 | 208 | ); |
@@ -214,7 +214,7 @@ discard block |
||
| 214 | 214 | $arr_tags = []; |
| 215 | 215 | $rows_tag = DB::query( |
| 216 | 216 | 'SELECT tag |
| 217 | - FROM ' . prefixTable('tags') . ' |
|
| 217 | + FROM ' . prefixTable('tags').' |
|
| 218 | 218 | WHERE item_id = %i', |
| 219 | 219 | $record['id'] |
| 220 | 220 | ); |
@@ -226,18 +226,18 @@ discard block |
||
| 226 | 226 | $arr_trees = []; |
| 227 | 227 | $rows_child_tree = DB::query( |
| 228 | 228 | 'SELECT t.id, t.title |
| 229 | - FROM ' . prefixTable('nested_tree') . ' AS t |
|
| 230 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (t.id = i.id_tree) |
|
| 229 | + FROM ' . prefixTable('nested_tree').' AS t |
|
| 230 | + INNER JOIN ' . prefixTable('items').' AS i ON (t.id = i.id_tree) |
|
| 231 | 231 | WHERE i.id = %i', |
| 232 | 232 | $record['id'] |
| 233 | 233 | ); |
| 234 | 234 | foreach ($rows_child_tree as $rec_child_tree) { |
| 235 | 235 | $stack = array(); |
| 236 | 236 | $parent = $rec_child_tree['id']; |
| 237 | - while($parent != 0){ |
|
| 237 | + while ($parent != 0) { |
|
| 238 | 238 | $rows_parent_tree = DB::query( |
| 239 | 239 | 'SELECT parent_id, title |
| 240 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 240 | + FROM ' . prefixTable('nested_tree').' |
|
| 241 | 241 | WHERE id = %i', |
| 242 | 242 | $parent |
| 243 | 243 | ); |
@@ -324,7 +324,7 @@ discard block |
||
| 324 | 324 | // Prepare variables |
| 325 | 325 | $post_export_tag = filter_var($dataReceived['export_tag'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
| 326 | 326 | if (empty($post_export_tag) === false) { |
| 327 | - DB::query('DELETE FROM ' . prefixTable('export') . ' WHERE export_tag = %s', $post_export_tag); |
|
| 327 | + DB::query('DELETE FROM '.prefixTable('export').' WHERE export_tag = %s', $post_export_tag); |
|
| 328 | 328 | } |
| 329 | 329 | break; |
| 330 | 330 | |
@@ -374,9 +374,9 @@ discard block |
||
| 374 | 374 | l.date as date, i.pw_iv as pw_iv, |
| 375 | 375 | n.renewal_period as renewal_period, |
| 376 | 376 | i.id_tree as tree_id |
| 377 | - FROM ' . prefixTable('items') . ' as i |
|
| 378 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id) |
|
| 379 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item) |
|
| 377 | + FROM ' . prefixTable('items').' as i |
|
| 378 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id) |
|
| 379 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item) |
|
| 380 | 380 | WHERE i.inactif = %i |
| 381 | 381 | AND i.id_tree= %i |
| 382 | 382 | AND (l.action = %s OR (l.action = %s AND l.raison LIKE %s)) |
@@ -402,8 +402,8 @@ discard block |
||
| 402 | 402 | // Run query |
| 403 | 403 | $dataItem = DB::queryFirstRow( |
| 404 | 404 | 'SELECT i.pw AS pw, s.share_key AS share_key |
| 405 | - FROM ' . prefixTable('items') . ' AS i |
|
| 406 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id) |
|
| 405 | + FROM ' . prefixTable('items').' AS i |
|
| 406 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id) |
|
| 407 | 407 | WHERE user_id = %i AND i.id = %i', |
| 408 | 408 | $session->get('user-id'), |
| 409 | 409 | $record['id'] |
@@ -427,8 +427,8 @@ discard block |
||
| 427 | 427 | $arr_kbs = ''; |
| 428 | 428 | $rows_kb = DB::query( |
| 429 | 429 | 'SELECT b.label, b.id |
| 430 | - FROM ' . prefixTable('kb_items') . ' AS a |
|
| 431 | - INNER JOIN ' . prefixTable('kb') . ' AS b ON (a.kb_id = b.id) |
|
| 430 | + FROM ' . prefixTable('kb_items').' AS a |
|
| 431 | + INNER JOIN ' . prefixTable('kb').' AS b ON (a.kb_id = b.id) |
|
| 432 | 432 | WHERE a.item_id = %i', |
| 433 | 433 | $record['id'] |
| 434 | 434 | ); |
@@ -436,7 +436,7 @@ discard block |
||
| 436 | 436 | if (empty($arr_kbs)) { |
| 437 | 437 | $arr_kbs = $rec_kb['label']; |
| 438 | 438 | } else { |
| 439 | - $arr_kbs .= ' | ' . $rec_kb['label']; |
|
| 439 | + $arr_kbs .= ' | '.$rec_kb['label']; |
|
| 440 | 440 | } |
| 441 | 441 | } |
| 442 | 442 | |
@@ -444,7 +444,7 @@ discard block |
||
| 444 | 444 | $arr_tags = ''; |
| 445 | 445 | $rows_tag = DB::query( |
| 446 | 446 | 'SELECT tag |
| 447 | - FROM ' . prefixTable('tags') . ' |
|
| 447 | + FROM ' . prefixTable('tags').' |
|
| 448 | 448 | WHERE item_id = %i', |
| 449 | 449 | $record['id'] |
| 450 | 450 | ); |
@@ -452,7 +452,7 @@ discard block |
||
| 452 | 452 | if (empty($arr_tags)) { |
| 453 | 453 | $arr_tags = $rec_tag['tag']; |
| 454 | 454 | } else { |
| 455 | - $arr_tags .= ' ' . $rec_tag['tag']; |
|
| 455 | + $arr_tags .= ' '.$rec_tag['tag']; |
|
| 456 | 456 | } |
| 457 | 457 | } |
| 458 | 458 | |
@@ -530,7 +530,7 @@ discard block |
||
| 530 | 530 | // query |
| 531 | 531 | $rows = DB::query( |
| 532 | 532 | 'SELECT * |
| 533 | - FROM ' . prefixTable('export') . ' |
|
| 533 | + FROM ' . prefixTable('export').' |
|
| 534 | 534 | WHERE export_tag = %s', |
| 535 | 535 | $dataReceived['export_tag'] |
| 536 | 536 | ); |
@@ -542,7 +542,7 @@ discard block |
||
| 542 | 542 | $prev_path = ''; |
| 543 | 543 | |
| 544 | 544 | //Prepare the PDF file |
| 545 | - require_once $SETTINGS['cpassman_dir'] . '/vendor/tecnickcom/tcpdf/tcpdf.php'; |
|
| 545 | + require_once $SETTINGS['cpassman_dir'].'/vendor/tecnickcom/tcpdf/tcpdf.php'; |
|
| 546 | 546 | |
| 547 | 547 | $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); |
| 548 | 548 | $pdf->SetProtection(array('print'), $dataReceived['pdf_password'], null); |
@@ -554,7 +554,7 @@ discard block |
||
| 554 | 554 | |
| 555 | 555 | // set default header data |
| 556 | 556 | $pdf->SetHeaderData( |
| 557 | - $SETTINGS['cpassman_dir'] . '/includes/images/teampass-logo2-home.png', |
|
| 557 | + $SETTINGS['cpassman_dir'].'/includes/images/teampass-logo2-home.png', |
|
| 558 | 558 | PDF_HEADER_LOGO_WIDTH, |
| 559 | 559 | 'Teampass export', |
| 560 | 560 | $session->get('user-lastname')." ".$session->get('user-name').' @ '.date($SETTINGS['date_format']." ".$SETTINGS['time_format'], (int) time()) |
@@ -664,7 +664,7 @@ discard block |
||
| 664 | 664 | logEvents($SETTINGS, 'pdf_export', '', (string) $session->get('user-id'), $session->get('user-login')); |
| 665 | 665 | |
| 666 | 666 | //clean table |
| 667 | - DB::query('TRUNCATE TABLE ' . prefixTable('export')); |
|
| 667 | + DB::query('TRUNCATE TABLE '.prefixTable('export')); |
|
| 668 | 668 | |
| 669 | 669 | // Clean any content of the output buffer |
| 670 | 670 | ob_end_clean(); |
@@ -702,13 +702,13 @@ discard block |
||
| 702 | 702 | // step 1: |
| 703 | 703 | // - prepare export file |
| 704 | 704 | // - get full list of objects id to export |
| 705 | - include $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 705 | + include $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 706 | 706 | $idsList = array(); |
| 707 | 707 | |
| 708 | 708 | // query |
| 709 | 709 | $rows = DB::query( |
| 710 | 710 | 'SELECT * |
| 711 | - FROM ' . prefixTable('export') . ' |
|
| 711 | + FROM ' . prefixTable('export').' |
|
| 712 | 712 | WHERE export_tag = %s', |
| 713 | 713 | $inputData['export_tag'] |
| 714 | 714 | ); |
@@ -745,13 +745,13 @@ discard block |
||
| 745 | 745 | } |
| 746 | 746 | // prepare export file |
| 747 | 747 | //save the file |
| 748 | - $outstream = fopen($SETTINGS['path_to_files_folder'] . (substr($SETTINGS['path_to_files_folder'] , -1) === '/' ? '' : '/') . $inputData['filename'], 'w'); |
|
| 748 | + $outstream = fopen($SETTINGS['path_to_files_folder'].(substr($SETTINGS['path_to_files_folder'], -1) === '/' ? '' : '/').$inputData['filename'], 'w'); |
|
| 749 | 749 | if ($outstream === false) { |
| 750 | 750 | echo (string) prepareExchangedData( |
| 751 | 751 | [ |
| 752 | 752 | 'error' => true, |
| 753 | 753 | 'message' => $lang->get('error_while_creating_file'), |
| 754 | - 'detail' => $SETTINGS['path_to_files_folder'] . $inputData['filename'], |
|
| 754 | + 'detail' => $SETTINGS['path_to_files_folder'].$inputData['filename'], |
|
| 755 | 755 | ], |
| 756 | 756 | 'encode' |
| 757 | 757 | ); |
@@ -777,12 +777,12 @@ discard block |
||
| 777 | 777 | </style> |
| 778 | 778 | </head> |
| 779 | 779 | <body> |
| 780 | - <input type="hidden" id="generation_date" value="' . GibberishAES::enc(/** @scrutinizer ignore-type */ (string) time(), $inputData['password']) . '" /> |
|
| 780 | + <input type="hidden" id="generation_date" value="' . GibberishAES::enc(/** @scrutinizer ignore-type */ (string) time(), $inputData['password']).'" /> |
|
| 781 | 781 | <div id="header"> |
| 782 | - ' . TP_TOOL_NAME . ' - Off Line mode |
|
| 782 | + ' . TP_TOOL_NAME.' - Off Line mode |
|
| 783 | 783 | </div> |
| 784 | 784 | <div style="margin:10px; font-size:9px;"> |
| 785 | - <i>This page was generated by <b>' . $session->get('user-name') . ' ' . $session->get('user-lastname') . '</b>, the ' . date('Y/m/d H:i:s') . '.</i> |
|
| 785 | + <i>This page was generated by <b>' . $session->get('user-name').' '.$session->get('user-lastname').'</b>, the '.date('Y/m/d H:i:s').'.</i> |
|
| 786 | 786 | <span id="info_page" style="margin-left:20px; font-weight:bold; font-size: 14px; color:red;"></span> |
| 787 | 787 | </div> |
| 788 | 788 | <div id="information"></div> |
@@ -793,11 +793,11 @@ discard block |
||
| 793 | 793 | <div> |
| 794 | 794 | <table id="itemsTable"> |
| 795 | 795 | <thead><tr> |
| 796 | - <th style="width:15%;">' . $lang->get('label') . '</th> |
|
| 797 | - <th style="width:10%;">' . $lang->get('pw') . '</th> |
|
| 798 | - <th style="width:30%;">' . $lang->get('description') . '</th> |
|
| 799 | - <th style="width:5%;">' . $lang->get('user_login') . '</th> |
|
| 800 | - <th style="width:20%;">' . $lang->get('url') . '</th> |
|
| 796 | + <th style="width:15%;">' . $lang->get('label').'</th> |
|
| 797 | + <th style="width:10%;">' . $lang->get('pw').'</th> |
|
| 798 | + <th style="width:30%;">' . $lang->get('description').'</th> |
|
| 799 | + <th style="width:5%;">' . $lang->get('user_login').'</th> |
|
| 800 | + <th style="width:20%;">' . $lang->get('url').'</th> |
|
| 801 | 801 | </tr></thead> |
| 802 | 802 | <tbody id="itemsTable_tbody">' |
| 803 | 803 | ); |
@@ -811,8 +811,8 @@ discard block |
||
| 811 | 811 | 'loop' => true, |
| 812 | 812 | 'ids_list' => json_encode($idsList), |
| 813 | 813 | 'ids_count' => count($idsList), |
| 814 | - 'file_path' => $SETTINGS['path_to_files_folder'] . (substr($SETTINGS['path_to_files_folder'] , -1) === '/' ? '' : '/') . $inputData['filename'], |
|
| 815 | - 'file_link' => $SETTINGS['url_to_files_folder'] . (substr($SETTINGS['path_to_files_folder'] , -1) === '/' ? '' : '/') . $inputData['filename'], |
|
| 814 | + 'file_path' => $SETTINGS['path_to_files_folder'].(substr($SETTINGS['path_to_files_folder'], -1) === '/' ? '' : '/').$inputData['filename'], |
|
| 815 | + 'file_link' => $SETTINGS['url_to_files_folder'].(substr($SETTINGS['path_to_files_folder'], -1) === '/' ? '' : '/').$inputData['filename'], |
|
| 816 | 816 | 'export_tag' => $inputData['export_tag'], |
| 817 | 817 | ], |
| 818 | 818 | 'encode' |
@@ -851,12 +851,12 @@ discard block |
||
| 851 | 851 | $full_listing = array(); |
| 852 | 852 | $items_id_list = array(); |
| 853 | 853 | $outstream = ''; |
| 854 | - include $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 854 | + include $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 855 | 855 | |
| 856 | 856 | // query |
| 857 | 857 | $rows = DB::query( |
| 858 | 858 | 'SELECT * |
| 859 | - FROM ' . prefixTable('export') . ' |
|
| 859 | + FROM ' . prefixTable('export').' |
|
| 860 | 860 | WHERE export_tag = %s AND item_id IN %ls', |
| 861 | 861 | $inputData['export_tag'], |
| 862 | 862 | $inputData['idsList'] |
@@ -870,7 +870,7 @@ discard block |
||
| 870 | 870 | [ |
| 871 | 871 | 'error' => true, |
| 872 | 872 | 'message' => $lang->get('error_while_creating_file'), |
| 873 | - 'detail' => $SETTINGS['path_to_files_folder'] . $inputData['filename'], |
|
| 873 | + 'detail' => $SETTINGS['path_to_files_folder'].$inputData['filename'], |
|
| 874 | 874 | ], |
| 875 | 875 | 'encode' |
| 876 | 876 | ); |
@@ -903,13 +903,13 @@ discard block |
||
| 903 | 903 | if (empty($arboHtml)) { |
| 904 | 904 | $arboHtml = $arboHtml_tmp; |
| 905 | 905 | } else { |
| 906 | - $arboHtml .= ' » ' . $arboHtml_tmp; |
|
| 906 | + $arboHtml .= ' » '.$arboHtml_tmp; |
|
| 907 | 907 | } |
| 908 | 908 | } |
| 909 | 909 | fputs( |
| 910 | 910 | $outstream, |
| 911 | 911 | ' |
| 912 | - <tr class="path"><td colspan="5">' . $arboHtml . '</td></tr>' |
|
| 912 | + <tr class="path"><td colspan="5">' . $arboHtml.'</td></tr>' |
|
| 913 | 913 | ); |
| 914 | 914 | $idTree = $record['folder_id']; |
| 915 | 915 | |
@@ -917,12 +917,12 @@ discard block |
||
| 917 | 917 | fputs( |
| 918 | 918 | $outstream, |
| 919 | 919 | ' |
| 920 | - <tr class="' . $lineType . '"> |
|
| 921 | - <td>' . addslashes($record['label']) . '</td> |
|
| 922 | - <td align="center"><span class="span_pw" id="span_' . $record['item_id'] . '"><a href="#" onclick="decryptme(' . $record['item_id'] . ', \'' . $encPw . '\');return false;">Decrypt </a></span><input type="hidden" id="hide_' . $record['item_id'] . '" value="' . $encPw . '" /></td> |
|
| 923 | - <td>' . (empty($record['description']) === true ? ' ' : addslashes(str_replace(array(';', '<br />'), array('|', "\n\r"), stripslashes(mb_convert_encoding($record['description'], 'ISO-8859-1', 'UTF-8'))))) . '</td> |
|
| 924 | - <td align="center">' . (empty($record['login']) === true ? ' ' : addslashes($record['login'])) . '</td> |
|
| 925 | - <td align="center">' . (empty($record['url']) === true ? ' ' : addslashes($record['url'])) . '</td> |
|
| 920 | + <tr class="' . $lineType.'"> |
|
| 921 | + <td>' . addslashes($record['label']).'</td> |
|
| 922 | + <td align="center"><span class="span_pw" id="span_' . $record['item_id'].'"><a href="#" onclick="decryptme('.$record['item_id'].', \''.$encPw.'\');return false;">Decrypt </a></span><input type="hidden" id="hide_'.$record['item_id'].'" value="'.$encPw.'" /></td> |
|
| 923 | + <td>' . (empty($record['description']) === true ? ' ' : addslashes(str_replace(array(';', '<br />'), array('|', "\n\r"), stripslashes(mb_convert_encoding($record['description'], 'ISO-8859-1', 'UTF-8'))))).'</td> |
|
| 924 | + <td align="center">' . (empty($record['login']) === true ? ' ' : addslashes($record['login'])).'</td> |
|
| 925 | + <td align="center">' . (empty($record['url']) === true ? ' ' : addslashes($record['url'])).'</td> |
|
| 926 | 926 | </tr>' |
| 927 | 927 | ); |
| 928 | 928 | } |
@@ -971,7 +971,7 @@ discard block |
||
| 971 | 971 | $inputData['password'] = (string) filter_var($dataReceived['password'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
| 972 | 972 | |
| 973 | 973 | // Load includes |
| 974 | - include $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 974 | + include $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 975 | 975 | |
| 976 | 976 | // read the content of the temporary file |
| 977 | 977 | $handle = fopen($inputData['filename'].'.txt', 'r'); |
@@ -980,7 +980,7 @@ discard block |
||
| 980 | 980 | [ |
| 981 | 981 | 'error' => true, |
| 982 | 982 | 'message' => $lang->get('error_while_creating_file'), |
| 983 | - 'detail' => $SETTINGS['path_to_files_folder'] . $inputData['filename'], |
|
| 983 | + 'detail' => $SETTINGS['path_to_files_folder'].$inputData['filename'], |
|
| 984 | 984 | ], |
| 985 | 985 | 'encode' |
| 986 | 986 | ); |
@@ -992,7 +992,7 @@ discard block |
||
| 992 | 992 | [ |
| 993 | 993 | 'error' => true, |
| 994 | 994 | 'message' => $lang->get('error_while_creating_file'), |
| 995 | - 'detail' => $SETTINGS['path_to_files_folder'] . $inputData['filename'], |
|
| 995 | + 'detail' => $SETTINGS['path_to_files_folder'].$inputData['filename'], |
|
| 996 | 996 | ], |
| 997 | 997 | 'encode' |
| 998 | 998 | ); |
@@ -1008,9 +1008,9 @@ discard block |
||
| 1008 | 1008 | $chunks = explode('|#|#|', chunk_split($contents, 10000, '|#|#|')); |
| 1009 | 1009 | foreach ($chunks as $chunk) { |
| 1010 | 1010 | if (empty($encrypted_text) === true) { |
| 1011 | - $encrypted_text = GibberishAES::enc(/** @scrutinizer ignore-type */ $chunk, $inputData['password'] ); |
|
| 1011 | + $encrypted_text = GibberishAES::enc(/** @scrutinizer ignore-type */ $chunk, $inputData['password']); |
|
| 1012 | 1012 | } else { |
| 1013 | - $encrypted_text .= '|#|#|' . GibberishAES::enc(/** @scrutinizer ignore-type */ $chunk, $inputData['password'] ); |
|
| 1013 | + $encrypted_text .= '|#|#|'.GibberishAES::enc(/** @scrutinizer ignore-type */ $chunk, $inputData['password']); |
|
| 1014 | 1014 | } |
| 1015 | 1015 | } |
| 1016 | 1016 | |
@@ -1021,7 +1021,7 @@ discard block |
||
| 1021 | 1021 | [ |
| 1022 | 1022 | 'error' => true, |
| 1023 | 1023 | 'message' => $lang->get('error_while_creating_file'), |
| 1024 | - 'detail' => $SETTINGS['path_to_files_folder'] . $inputData['filename'], |
|
| 1024 | + 'detail' => $SETTINGS['path_to_files_folder'].$inputData['filename'], |
|
| 1025 | 1025 | ], |
| 1026 | 1026 | 'encode' |
| 1027 | 1027 | ); |
@@ -1034,9 +1034,9 @@ discard block |
||
| 1034 | 1034 | </table></div> |
| 1035 | 1035 | <input type="button" value="Hide all" onclick="hideAll()" /> |
| 1036 | 1036 | <div id="footer" style="text-align:center;"> |
| 1037 | - <a href="https://teampass.net/about/" target="_blank">' . TP_TOOL_NAME . ' ' . TP_VERSION . ' ' . TP_COPYRIGHT . '</a> |
|
| 1037 | + <a href="https://teampass.net/about/" target="_blank">' . TP_TOOL_NAME.' '.TP_VERSION.' '.TP_COPYRIGHT.'</a> |
|
| 1038 | 1038 | </div> |
| 1039 | - <div id="enc_html" style="display:none;">' . $encrypted_text . '</div> |
|
| 1039 | + <div id="enc_html" style="display:none;">' . $encrypted_text.'</div> |
|
| 1040 | 1040 | </body> |
| 1041 | 1041 | </html> |
| 1042 | 1042 | <script type="text/javascript"> |
@@ -1139,12 +1139,12 @@ discard block |
||
| 1139 | 1139 | fclose($outstream); |
| 1140 | 1140 | |
| 1141 | 1141 | //clean table |
| 1142 | - DB::query('TRUNCATE TABLE ' . prefixTable('export')); |
|
| 1142 | + DB::query('TRUNCATE TABLE '.prefixTable('export')); |
|
| 1143 | 1143 | |
| 1144 | 1144 | echo (string) prepareExchangedData( |
| 1145 | 1145 | [ |
| 1146 | 1146 | 'error' => false, |
| 1147 | - 'filelink' => $inputData['file_link'] , |
|
| 1147 | + 'filelink' => $inputData['file_link'], |
|
| 1148 | 1148 | ], |
| 1149 | 1149 | 'encode' |
| 1150 | 1150 | ); |
@@ -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 | |
@@ -134,13 +134,13 @@ discard block |
||
| 134 | 134 | |
| 135 | 135 | header('Content-Description: File Transfer'); |
| 136 | 136 | header('Content-Type: application/octet-stream'); |
| 137 | - header('Content-Disposition: attachment; filename="' . $safeFilename . '"'); |
|
| 137 | + header('Content-Disposition: attachment; filename="'.$safeFilename.'"'); |
|
| 138 | 138 | header('Cache-Control: must-revalidate, no-cache, no-store'); |
| 139 | 139 | header('Pragma: public'); |
| 140 | 140 | header('Expires: 0'); |
| 141 | 141 | |
| 142 | 142 | if ($filesize !== null) { |
| 143 | - header('Content-Length: ' . $filesize); |
|
| 143 | + header('Content-Length: '.$filesize); |
|
| 144 | 144 | } |
| 145 | 145 | } |
| 146 | 146 | |
@@ -152,7 +152,7 @@ discard block |
||
| 152 | 152 | return false; |
| 153 | 153 | } |
| 154 | 154 | |
| 155 | - $filepath = $basePath . '/' . basename($filename); |
|
| 155 | + $filepath = $basePath.'/'.basename($filename); |
|
| 156 | 156 | |
| 157 | 157 | // Security: Verify the resolved path is within the allowed directory |
| 158 | 158 | $realBasePath = realpath($basePath); |
@@ -230,8 +230,8 @@ discard block |
||
| 230 | 230 | $file_info = DB::queryFirstRow( |
| 231 | 231 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, f.extension AS extension, |
| 232 | 232 | s.share_key AS share_key |
| 233 | - FROM ' . prefixTable('files') . ' AS f |
|
| 234 | - INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id) |
|
| 233 | + FROM ' . prefixTable('files').' AS f |
|
| 234 | + INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id) |
|
| 235 | 235 | WHERE s.user_id = %i AND s.object_id = %i', |
| 236 | 236 | $session->get('user-id'), |
| 237 | 237 | $get_fileid |
@@ -251,7 +251,7 @@ discard block |
||
| 251 | 251 | // Get unencrypted file info |
| 252 | 252 | $file_info = DB::queryFirstRow( |
| 253 | 253 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, f.extension AS extension |
| 254 | - FROM ' . prefixTable('files') . ' AS f |
|
| 254 | + FROM ' . prefixTable('files').' AS f |
|
| 255 | 255 | WHERE f.id = %i', |
| 256 | 256 | $get_fileid |
| 257 | 257 | ); |
@@ -263,13 +263,13 @@ discard block |
||
| 263 | 263 | |
| 264 | 264 | // Prepare filename for download |
| 265 | 265 | $filename = str_replace('b64:', '', $file_info['name']); |
| 266 | - $filename = basename($filename, '.' . $file_info['extension']); |
|
| 266 | + $filename = basename($filename, '.'.$file_info['extension']); |
|
| 267 | 267 | $filename = isBase64($filename) === true ? base64_decode($filename) : $filename; |
| 268 | - $filename = $filename . '.' . $file_info['extension']; |
|
| 268 | + $filename = $filename.'.'.$file_info['extension']; |
|
| 269 | 269 | |
| 270 | 270 | // Determine file path |
| 271 | - $candidatePath1 = $SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . $file_info['file']; |
|
| 272 | - $candidatePath2 = $SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($file_info['file']); |
|
| 271 | + $candidatePath1 = $SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.$file_info['file']; |
|
| 272 | + $candidatePath2 = $SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($file_info['file']); |
|
| 273 | 273 | |
| 274 | 274 | $filePath = false; |
| 275 | 275 | if (file_exists($candidatePath1)) { |
@@ -279,7 +279,7 @@ discard block |
||
| 279 | 279 | } |
| 280 | 280 | |
| 281 | 281 | if (WIP === true) { |
| 282 | - error_log('downloadFile.php: filePath: ' . $filePath . " - "); |
|
| 282 | + error_log('downloadFile.php: filePath: '.$filePath." - "); |
|
| 283 | 283 | } |
| 284 | 284 | |
| 285 | 285 | // Validate file path and security |