Changeset 55857 for trunk/src/wp-includes/media.php

Timestamp:

05/25/2023 12:53:24 PM (3 years ago)

Author:

SergeyBiryukov

Message:

Coding Standards: Improve formatting of some SQL queries for better readability.

This corrects the placement of double quotes around the query and makes sure the alignment is consistent.

Props umeshmcakadi, mukesh27, krupalpanchal, dhrumilk, SergeyBiryukov.
Fixes #58372.

File:

• trunk/src/wp-includes/media.php (modified) (3 diffs)

trunk/src/wp-includes/media.php

@@ -4485 +4485 @@
         if ( null === $show_audio_playlist ) {
                 $show_audio_playlist = $wpdb->get_var(
-                        "
-                        SELECT ID
+                        "SELECT ID
                         FROM $wpdb->posts
                         WHERE post_type = 'attachment'
                         AND post_mime_type LIKE 'audio%'
-                        LIMIT 1
-                "
+                        LIMIT 1"
                 );
         }
@@ -4515 +4513 @@
         if ( null === $show_video_playlist ) {
                 $show_video_playlist = $wpdb->get_var(
-                        "
-                        SELECT ID
+                        "SELECT ID
                         FROM $wpdb->posts
                         WHERE post_type = 'attachment'
                         AND post_mime_type LIKE 'video%'
-                        LIMIT 1
-                "
+                        LIMIT 1"
                 );
         }
@@ -4544 +4540 @@
                 $months = $wpdb->get_results(
                         $wpdb->prepare(
-                                "
-                        SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month
-                        FROM $wpdb->posts
-                        WHERE post_type = %s
-                        ORDER BY post_date DESC
-                ",
+                                "SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month
+                                FROM $wpdb->posts
+                                WHERE post_type = %s
+                                ORDER BY post_date DESC",
                                 'attachment'
                         )