| @@ -1,6 +1,6 @@ | ||
| 1 | 1 | <?php |
| 2 | -defined( 'ABSPATH' ) || die( 'Cheatin’ uh?' ); | |
| 2 | +defined( 'ABSPATH' ) || exit; | |
| 3 | 3 | |
| 4 | 4 | /** |
| 5 | 5 | * Class handling stats related to "custom folders optimization". |
| 6 | 6 | * |
| @@ -199,9 +199,9 @@ | ||
| 199 | 199 | * @return int The number of images. |
| 200 | 200 | */ |
| 201 | 201 | public static function count_files( $status = 'all' ) { |
| 202 | 202 | global $wpdb; |
| 203 | - static $count = array(); | |
| 203 | + static $count = []; | |
| 204 | 204 | |
| 205 | 205 | $status = self::validate_status( $status ); |
| 206 | 206 | |
| 207 | 207 | if ( isset( $count[ $status ] ) ) { |
| @@ -232,9 +232,9 @@ | ||
| 232 | 232 | $status = "( status = 'error' OR status IS NULL )"; |
| 233 | 233 | break; |
| 234 | 234 | |
| 235 | 235 | default: |
| 236 | - // "success", "already_optimized", "error". | |
| 236 | + // success, already_optimized or error. | |
| 237 | 237 | $status = "status = '$status'"; |
| 238 | 238 | } |
| 239 | 239 | |
| 240 | 240 | $table_name = $files_db->get_table_name(); |
| @@ -356,9 +356,9 @@ | ||
| 356 | 356 | * @return int The sizes sum in bytes. |
| 357 | 357 | */ |
| 358 | 358 | public static function get_size( $type = null ) { |
| 359 | 359 | global $wpdb; |
| 360 | - static $sizes = array(); | |
| 360 | + static $sizes = []; | |
| 361 | 361 | |
| 362 | 362 | $type = 'optimized' === $type ? 'optimized_size' : 'original_size'; |
| 363 | 363 | |
| 364 | 364 | if ( isset( $sizes[ $type ] ) ) { |
| @@ -404,9 +404,10 @@ | ||
| 404 | 404 | return $size; |
| 405 | 405 | } |
| 406 | 406 | |
| 407 | 407 | $table_name = $files_db->get_table_name(); |
| 408 | - $size = round( $wpdb->get_var( "SELECT SUM( original_size ) FROM $table_name" ) ); // WPCS: unprepared SQL ok. | |
| 408 | + $sql = $wpdb->get_var( "SELECT SUM( original_size ) FROM $table_name" ); // WPCS: unprepared SQL ok. | |
| 409 | + $size = is_null( $sql ) ? 0 : round( $sql ); | |
| 409 | 410 | |
| 410 | 411 | return $size; |
| 411 | 412 | } |
| 412 | 413 | |
| @@ -434,9 +435,10 @@ | ||
| 434 | 435 | return $average; |
| 435 | 436 | } |
| 436 | 437 | |
| 437 | 438 | $table_name = $files_db->get_table_name(); |
| 438 | - $average = round( $wpdb->get_var( "SELECT AVG( size ) AS average_size_per_month FROM ( SELECT SUM( original_size ) AS size FROM $table_name GROUP BY YEAR( file_date ), MONTH( file_date ) ) AS size_per_month" ) ); // WPCS: unprepared SQL ok. | |
| 439 | + $sql = $wpdb->get_var( "SELECT AVG( size ) AS average_size_per_month FROM ( SELECT SUM( original_size ) AS size FROM $table_name GROUP BY YEAR( file_date ), MONTH( file_date ) ) AS size_per_month" ); // WPCS: unprepared SQL ok. | |
| 440 | + $average = is_null( $sql ) ? 0 : round( $sql ); | |
| 439 | 441 | |
| 440 | 442 | return $average; |
| 441 | 443 | } |
| 442 | 444 | |
| @@ -458,9 +460,9 @@ | ||
| 458 | 460 | * "unoptimized" regroups "error" and "none". |
| 459 | 461 | * @return string Fallback to 'all' if the status is not valid. |
| 460 | 462 | */ |
| 461 | 463 | public static function validate_status( $status = 'all' ) { |
| 462 | - $statuses = array( | |
| 464 | + $statuses = [ | |
| 463 | 465 | 'all' => 1, |
| 464 | 466 | 'success' => 1, |
| 465 | 467 | 'already_optimized' => 1, |
| 466 | 468 | 'error' => 1, |
| @@ -466,9 +468,9 @@ | ||
| 466 | 468 | 'error' => 1, |
| 467 | 469 | 'none' => 1, |
| 468 | 470 | 'optimized' => 1, |
| 469 | 471 | 'unoptimized' => 1, |
| 470 | - ); | |
| 472 | + ]; | |
| 471 | 473 | |
| 472 | 474 | return isset( $statuses[ $status ] ) ? $status : 'all'; |
| 473 | 475 | } |
| 474 | 476 | } |
