@@ -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 | if ( |
254 | 254 | !in_array($ext, $allowed_extensions) |
@@ -267,25 +267,25 @@ discard block |
||
267 | 267 | |
268 | 268 | // is destination folder writable |
269 | 269 | if (is_writable($SETTINGS['path_to_files_folder']) === false) { |
270 | - echo handleUploadError('Not enough permissions on folder ' . $SETTINGS['path_to_files_folder'] . '.'); |
|
270 | + echo handleUploadError('Not enough permissions on folder '.$SETTINGS['path_to_files_folder'].'.'); |
|
271 | 271 | return false; |
272 | 272 | } |
273 | 273 | |
274 | 274 | // Make sure the fileName is unique but only if chunking is disabled |
275 | -if ($chunks < 2 && file_exists($targetDir . DIRECTORY_SEPARATOR . $fileName)) { |
|
275 | +if ($chunks < 2 && file_exists($targetDir.DIRECTORY_SEPARATOR.$fileName)) { |
|
276 | 276 | // $ext is guaranteed to be a string due to prior checks |
277 | 277 | $fileNameA = substr($fileName, 0, strlen(/** @scrutinizer ignore-type */$ext)); |
278 | 278 | $fileNameB = substr($fileName, strlen(/** @scrutinizer ignore-type */$ext)); |
279 | 279 | |
280 | 280 | $count = 1; |
281 | - while (file_exists($targetDir . DIRECTORY_SEPARATOR . $fileNameA . '_' . $count . $fileNameB)) { |
|
281 | + while (file_exists($targetDir.DIRECTORY_SEPARATOR.$fileNameA.'_'.$count.$fileNameB)) { |
|
282 | 282 | ++$count; |
283 | 283 | } |
284 | 284 | |
285 | - $fileName = $fileNameA . '_' . $count . $fileNameB; |
|
285 | + $fileName = $fileNameA.'_'.$count.$fileNameB; |
|
286 | 286 | } |
287 | 287 | |
288 | -$filePath = $targetDir . DIRECTORY_SEPARATOR . $fileName; |
|
288 | +$filePath = $targetDir.DIRECTORY_SEPARATOR.$fileName; |
|
289 | 289 | |
290 | 290 | // Create target dir |
291 | 291 | if (!file_exists($targetDir)) { |
@@ -299,7 +299,7 @@ discard block |
||
299 | 299 | // Remove old temp files |
300 | 300 | if ($cleanupTargetDir && is_dir($targetDir) && ($dir = opendir($targetDir))) { |
301 | 301 | while (($fileClean = readdir($dir)) !== false) { |
302 | - $tmpfilePath = $targetDir . DIRECTORY_SEPARATOR . $fileClean; |
|
302 | + $tmpfilePath = $targetDir.DIRECTORY_SEPARATOR.$fileClean; |
|
303 | 303 | |
304 | 304 | // Remove temp file if it is older than the max age and is not the current file |
305 | 305 | if ( |
@@ -313,7 +313,7 @@ discard block |
||
313 | 313 | |
314 | 314 | closedir($dir); |
315 | 315 | } else { |
316 | - echo handleUploadError('Not enough permissions on folder ' . $SETTINGS['path_to_files_folder'] . '.'); |
|
316 | + echo handleUploadError('Not enough permissions on folder '.$SETTINGS['path_to_files_folder'].'.'); |
|
317 | 317 | return false; |
318 | 318 | } |
319 | 319 | |
@@ -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 |
@@ -73,7 +73,7 @@ discard block |
||
73 | 73 | if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('profile') === false) { |
74 | 74 | // Not allowed page |
75 | 75 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
76 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
76 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
77 | 77 | exit; |
78 | 78 | } |
79 | 79 | ?> |
@@ -97,7 +97,7 @@ discard block |
||
97 | 97 | }) |
98 | 98 | |
99 | 99 | // Select user properties |
100 | - $('#profile-user-language option[value=<?php echo $session->get('user-language');?>').attr('selected','selected'); |
|
100 | + $('#profile-user-language option[value=<?php echo $session->get('user-language'); ?>').attr('selected','selected'); |
|
101 | 101 | |
102 | 102 | |
103 | 103 | // AVATAR IMPORT |
@@ -295,7 +295,7 @@ discard block |
||
295 | 295 | |
296 | 296 | // reload page in case of language change |
297 | 297 | if ($('#profile-user-language').val() |
298 | - && $('#profile-user-language').val().toLowerCase() !== '<?php echo $session->get('user-language');?>') { |
|
298 | + && $('#profile-user-language').val().toLowerCase() !== '<?php echo $session->get('user-language'); ?>') { |
|
299 | 299 | // prepare reload |
300 | 300 | $(this).delay(3000).queue(function() { |
301 | 301 | document.location.href = "index.php?page=profile"; |
@@ -306,7 +306,7 @@ discard block |
||
306 | 306 | // Inform user |
307 | 307 | toastr.remove(); |
308 | 308 | toastr.info( |
309 | - '<?php echo $lang->get('alert_page_will_reload') . ' ... ' . $lang->get('please_wait'); ?>', |
|
309 | + '<?php echo $lang->get('alert_page_will_reload').' ... '.$lang->get('please_wait'); ?>', |
|
310 | 310 | '', { |
311 | 311 | timeOut: 3000, |
312 | 312 | progressBar: true |
@@ -410,27 +410,27 @@ discard block |
||
410 | 410 | "defaultText": "<?php echo $lang->get('index_pw_level_txt'); ?>", |
411 | 411 | "ratings": [ |
412 | 412 | { |
413 | - "minScore": <?php echo TP_PW_STRENGTH_1;?>, |
|
413 | + "minScore": <?php echo TP_PW_STRENGTH_1; ?>, |
|
414 | 414 | "className": "meterWarn", |
415 | 415 | "text": "<?php echo $lang->get('complex_level1'); ?>" |
416 | 416 | }, |
417 | 417 | { |
418 | - "minScore": <?php echo TP_PW_STRENGTH_2;?>, |
|
418 | + "minScore": <?php echo TP_PW_STRENGTH_2; ?>, |
|
419 | 419 | "className": "meterWarn", |
420 | 420 | "text": "<?php echo $lang->get('complex_level2'); ?>" |
421 | 421 | }, |
422 | 422 | { |
423 | - "minScore": <?php echo TP_PW_STRENGTH_3;?>, |
|
423 | + "minScore": <?php echo TP_PW_STRENGTH_3; ?>, |
|
424 | 424 | "className": "meterGood", |
425 | 425 | "text": "<?php echo $lang->get('complex_level3'); ?>" |
426 | 426 | }, |
427 | 427 | { |
428 | - "minScore": <?php echo TP_PW_STRENGTH_4;?>, |
|
428 | + "minScore": <?php echo TP_PW_STRENGTH_4; ?>, |
|
429 | 429 | "className": "meterGood", |
430 | 430 | "text": "<?php echo $lang->get('complex_level4'); ?>" |
431 | 431 | }, |
432 | 432 | { |
433 | - "minScore": <?php echo TP_PW_STRENGTH_5;?>, |
|
433 | + "minScore": <?php echo TP_PW_STRENGTH_5; ?>, |
|
434 | 434 | "className": "meterExcel", |
435 | 435 | "text": "<?php echo $lang->get('complex_level5'); ?>" |
436 | 436 | } |
@@ -523,27 +523,27 @@ discard block |
||
523 | 523 | "defaultText": "<?php echo $lang->get('index_pw_level_txt'); ?>", |
524 | 524 | "ratings": [ |
525 | 525 | { |
526 | - "minScore": <?php echo TP_PW_STRENGTH_1;?>, |
|
526 | + "minScore": <?php echo TP_PW_STRENGTH_1; ?>, |
|
527 | 527 | "className": "meterWarn", |
528 | 528 | "text": "<?php echo $lang->get('complex_level1'); ?>" |
529 | 529 | }, |
530 | 530 | { |
531 | - "minScore": <?php echo TP_PW_STRENGTH_2;?>, |
|
531 | + "minScore": <?php echo TP_PW_STRENGTH_2; ?>, |
|
532 | 532 | "className": "meterWarn", |
533 | 533 | "text": "<?php echo $lang->get('complex_level2'); ?>" |
534 | 534 | }, |
535 | 535 | { |
536 | - "minScore": <?php echo TP_PW_STRENGTH_3;?>, |
|
536 | + "minScore": <?php echo TP_PW_STRENGTH_3; ?>, |
|
537 | 537 | "className": "meterGood", |
538 | 538 | "text": "<?php echo $lang->get('complex_level3'); ?>" |
539 | 539 | }, |
540 | 540 | { |
541 | - "minScore": <?php echo TP_PW_STRENGTH_4;?>, |
|
541 | + "minScore": <?php echo TP_PW_STRENGTH_4; ?>, |
|
542 | 542 | "className": "meterGood", |
543 | 543 | "text": "<?php echo $lang->get('complex_level4'); ?>" |
544 | 544 | }, |
545 | 545 | { |
546 | - "minScore": <?php echo TP_PW_STRENGTH_5;?>, |
|
546 | + "minScore": <?php echo TP_PW_STRENGTH_5; ?>, |
|
547 | 547 | "className": "meterExcel", |
548 | 548 | "text": "<?php echo $lang->get('complex_level5'); ?>" |
549 | 549 | } |
@@ -559,7 +559,7 @@ discard block |
||
559 | 559 | } |
560 | 560 | }); |
561 | 561 | |
562 | - $('#profile-keys_download-date').text('<?php echo null === $session->get('user-keys_recovery_time') ? $lang->get('none') : date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $session->get('user-keys_recovery_time')); ?>'); |
|
562 | + $('#profile-keys_download-date').text('<?php echo null === $session->get('user-keys_recovery_time') ? $lang->get('none') : date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $session->get('user-keys_recovery_time')); ?>'); |
|
563 | 563 | |
564 | 564 | $("#open-dialog-keys-download").on('click', function(event) { |
565 | 565 | event.preventDefault(); |
@@ -126,64 +126,64 @@ |
||
126 | 126 | |
127 | 127 | // Delete all item keys for which no user exist |
128 | 128 | DB::query( |
129 | - 'DELETE k FROM ' . prefixTable('sharekeys_items') . ' k |
|
130 | - LEFT JOIN ' . prefixTable('users') . ' u ON k.user_id = u.id |
|
129 | + 'DELETE k FROM '.prefixTable('sharekeys_items').' k |
|
130 | + LEFT JOIN ' . prefixTable('users').' u ON k.user_id = u.id |
|
131 | 131 | WHERE u.id IS NULL OR u.deleted_at IS NOT NULL' |
132 | 132 | ); |
133 | 133 | |
134 | 134 | // Delete all files keys for which no user exist |
135 | 135 | DB::query( |
136 | - 'DELETE k FROM ' . prefixTable('sharekeys_files') . ' k |
|
137 | - LEFT JOIN ' . prefixTable('users') . ' u ON k.user_id = u.id |
|
136 | + 'DELETE k FROM '.prefixTable('sharekeys_files').' k |
|
137 | + LEFT JOIN ' . prefixTable('users').' u ON k.user_id = u.id |
|
138 | 138 | WHERE u.id IS NULL OR u.deleted_at IS NOT NULL' |
139 | 139 | ); |
140 | 140 | |
141 | 141 | // Delete all fields keys for which no user exist |
142 | 142 | DB::query( |
143 | - 'DELETE k FROM ' . prefixTable('sharekeys_fields') . ' k |
|
144 | - LEFT JOIN ' . prefixTable('users') . ' u ON k.user_id = u.id |
|
143 | + 'DELETE k FROM '.prefixTable('sharekeys_fields').' k |
|
144 | + LEFT JOIN ' . prefixTable('users').' u ON k.user_id = u.id |
|
145 | 145 | WHERE u.id IS NULL OR u.deleted_at IS NOT NULL' |
146 | 146 | ); |
147 | 147 | |
148 | 148 | // Delete all item logs for which no user exist |
149 | 149 | DB::query( |
150 | - 'DELETE l FROM ' . prefixTable('log_items') . ' l |
|
151 | - LEFT JOIN ' . prefixTable('users') . ' u ON l.id_user = u.id |
|
150 | + 'DELETE l FROM '.prefixTable('log_items').' l |
|
151 | + LEFT JOIN ' . prefixTable('users').' u ON l.id_user = u.id |
|
152 | 152 | WHERE u.id IS NULL OR u.deleted_at IS NOT NULL' |
153 | 153 | ); |
154 | 154 | |
155 | 155 | // Delete all system logs for which no user exist |
156 | 156 | DB::query( |
157 | - 'DELETE l FROM ' . prefixTable('log_system') . ' l |
|
158 | - LEFT JOIN ' . prefixTable('users') . ' u ON l.qui = u.id |
|
157 | + 'DELETE l FROM '.prefixTable('log_system').' l |
|
158 | + LEFT JOIN ' . prefixTable('users').' u ON l.qui = u.id |
|
159 | 159 | WHERE u.id IS NULL OR u.deleted_at IS NOT NULL' |
160 | 160 | ); |
161 | 161 | |
162 | 162 | // Delete all item keys for which no object exist |
163 | 163 | DB::query( |
164 | - 'DELETE k FROM ' . prefixTable('sharekeys_items') . ' k |
|
165 | - LEFT JOIN ' . prefixTable('items') . ' i ON k.object_id = i.id |
|
164 | + 'DELETE k FROM '.prefixTable('sharekeys_items').' k |
|
165 | + LEFT JOIN ' . prefixTable('items').' i ON k.object_id = i.id |
|
166 | 166 | WHERE i.id IS NULL' |
167 | 167 | ); |
168 | 168 | |
169 | 169 | // Delete all files keys for which no object exist |
170 | 170 | DB::query( |
171 | - 'DELETE k FROM ' . prefixTable('sharekeys_files') . ' k |
|
172 | - LEFT JOIN ' . prefixTable('items') . ' i ON k.object_id = i.id |
|
171 | + 'DELETE k FROM '.prefixTable('sharekeys_files').' k |
|
172 | + LEFT JOIN ' . prefixTable('items').' i ON k.object_id = i.id |
|
173 | 173 | WHERE i.id IS NULL' |
174 | 174 | ); |
175 | 175 | |
176 | 176 | // Delete all fields keys for which no object exist |
177 | 177 | DB::query( |
178 | - 'DELETE k FROM ' . prefixTable('sharekeys_fields') . ' k |
|
179 | - LEFT JOIN ' . prefixTable('items') . ' i ON k.object_id = i.id |
|
178 | + 'DELETE k FROM '.prefixTable('sharekeys_fields').' k |
|
179 | + LEFT JOIN ' . prefixTable('items').' i ON k.object_id = i.id |
|
180 | 180 | WHERE i.id IS NULL' |
181 | 181 | ); |
182 | 182 | |
183 | 183 | // Delete all item logs for which no object exist |
184 | 184 | DB::query( |
185 | - 'DELETE l FROM ' . prefixTable('log_items') . ' l |
|
186 | - LEFT JOIN ' . prefixTable('items') . ' i ON l.id_item = i.id |
|
185 | + 'DELETE l FROM '.prefixTable('log_items').' l |
|
186 | + LEFT JOIN ' . prefixTable('items').' i ON l.id_item = i.id |
|
187 | 187 | WHERE i.id IS NULL' |
188 | 188 | ); |
189 | 189 |