Changeset 54553

Timestamp:

10/17/2022 05:53:05 PM (22 months ago)

Author:

audrasjb

Message:

Grouped backports to the 5.7 branch.

• Editor: Bump @wordpress packages for the branch,
• Media: Refactor search by filename within the admin,
• REST API: Lockdown post parameter of the terms endpoint,
• Customize: Escape blogname option in underscores templates,
• Query: Validate relation in WP_Date_Query,
• Posts, Post types: Apply KSES to post-by-email content,
• General: Validate host on "Are you sure?" screen,
• Posts, Post types: Remove emails from post-by-email logs,
• Pings/trackbacks: Apply KSES to all trackbacks,
• Mail: Reset PHPMailer properties between use,
• Comments: Apply kses when editing comments,
• Widgets: Escape RSS error messages for display.

Merges [54521-54530] to the 5.7 branch.
Props audrasjb, costdev, cu121, dd32, davidbaumwald, ehtis, johnbillion, johnjamesjacoby, martinkrcho, matveb, oztaser, paulkevan, peterwilsoncc, ravipatel, SergeyBiryukov, talldanwp, timothyblynjacobs, tykoted, voldemortensen, vortfu, xknown.

Location:

branches/5.7

Files:

• . (modified) (1 prop)
• src/wp-admin/includes/ajax-actions.php (modified) (1 diff)
• src/wp-admin/includes/post.php (modified) (1 diff)
• src/wp-includes/class-wp-date-query.php (modified) (3 diffs)
• src/wp-includes/class-wp-query.php (modified) (5 diffs)
• src/wp-includes/comment.php (modified) (2 diffs)
• src/wp-includes/customize/class-wp-customize-header-image-control.php (modified) (2 diffs)
• src/wp-includes/customize/class-wp-customize-site-icon-control.php (modified) (1 diff)
• src/wp-includes/deprecated.php (modified) (1 diff)
• src/wp-includes/functions.php (modified) (1 diff)
• src/wp-includes/media-template.php (modified) (1 diff)
• src/wp-includes/pluggable.php (modified) (1 diff)
• src/wp-includes/post.php (modified) (1 diff)
• src/wp-includes/rest-api/endpoints/class-wp-rest-attachments-controller.php (modified) (1 diff)
• src/wp-includes/rest-api/endpoints/class-wp-rest-terms-controller.php (modified) (2 diffs)
• src/wp-includes/widgets.php (modified) (2 diffs)
• src/wp-mail.php (modified) (2 diffs)
• src/wp-trackback.php (modified) (1 diff)
• tests/phpunit/tests/query/search.php (modified) (5 diffs)
• tests/phpunit/tests/rest-api/rest-comments-controller.php (modified) (8 diffs)

branches/5.7/src/wp-admin/includes/ajax-actions.php

@@ -2975 +2975 @@
     // Filter query clauses to include filenames.
     if ( isset( $query['s'] ) ) {
-        add_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
+        add_filter( '' );
     }
 

branches/5.7/src/wp-admin/includes/post.php

@@ -1270 +1270 @@
     // Filter query clauses to include filenames.
     if ( isset( $q['s'] ) ) {
-        add_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
+        add_filter( '' );
     }
 

branches/5.7/src/wp-includes/class-wp-date-query.php

@@ -150 +150 @@
         }
 
-        if ( isset( $date_query['relation'] ) && 'OR' === strtoupper( $date_query['relation'] ) ) {
-            $this->relation = 'OR';
+        if ( isset( $date_query['relation'] ) ) {
+            $this->relation = ;
         } else {
             $this->relation = 'AND';
@@ -219 +219 @@
             $this->validate_date_values( $queries );
         }
+
+
+
 
         foreach ( $queries as $key => $q ) {
@@ -1040 +1043 @@
         return $wpdb->prepare( "DATE_FORMAT( $column, %s ) $compare %f", $format, $time );
     }
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
 }

branches/5.7/src/wp-includes/class-wp-query.php

@@ -445 +445 @@
     public $thumbnails_cached = false;
 
+
+
+
+
+
+
+
     /**
      * Cached list of search stopwords.
@@ -1395 +1402 @@
 
             $like      = $n . $wpdb->esc_like( $term ) . $n;
-            $search   .= $wpdb->prepare( "{$searchand}(({$wpdb->posts}.post_title $like_op %s) $andor_op ({$wpdb->posts}.post_excerpt $like_op %s) $andor_op ({$wpdb->posts}.post_content $like_op %s))", $like, $like, $like );
+
+            if ( ! empty( $this->allow_query_attachment_by_filename ) ) {
+                $search .= $wpdb->prepare( "{$searchand}(({$wpdb->posts}.post_title $like_op %s) $andor_op ({$wpdb->posts}.post_excerpt $like_op %s) $andor_op ({$wpdb->posts}.post_content $like_op %s) $andor_op (sq1.meta_value $like_op %s))", $like, $like, $like, $like );
+            } else {
+                $search .= $wpdb->prepare( "{$searchand}(({$wpdb->posts}.post_title $like_op %s) $andor_op ({$wpdb->posts}.post_excerpt $like_op %s) $andor_op ({$wpdb->posts}.post_content $like_op %s))", $like, $like, $like );
+            }
             $searchand = ' AND ';
         }
@@ -1790 +1802 @@
         $q = $this->fill_query_vars( $q );
 
+
+
+
+
+
+
+
+
+
+
         // Parse meta query.
         $this->meta_query = new WP_Meta_Query();
@@ -2221 +2243 @@
         }
 
-        if ( ! empty( $this->tax_query->queries ) || ! empty( $this->meta_query->queries ) ) {
+        if ( ! empty( $this->tax_query->queries ) || ! empty( $this->meta_query->queries ) ) {
             $groupby = "{$wpdb->posts}.ID";
         }
@@ -2297 +2319 @@
         }
         $where .= $search . $whichauthor . $whichmimetype;
+
+
+
+
 
         if ( ! empty( $this->meta_query->queries ) ) {

branches/5.7/src/wp-includes/comment.php

@@ -2462 +2462 @@
     }
 
+
+
+
+
+
+
+
+
+
     // Escape data pulled from DB.
     $comment = wp_slash( $comment );
@@ -2471 +2480 @@
 
     $commentarr = wp_filter_comment( $commentarr );
+
+
+
+
 
     // Now extract the merged array.

branches/5.7/src/wp-includes/customize/class-wp-customize-header-image-control.php

@@ -131 +131 @@
 
             <button type="button" class="choice thumbnail"
-                data-customize-image-value="{{{data.header.url}}}"
+                data-customize-image-value="{{}}"
                 data-customize-header-image-data="{{JSON.stringify(data.header)}}">
                 <span class="screen-reader-text"><?php _e( 'Set image' ); ?></span>
-                <img src="{{{data.header.thumbnail_url}}}" alt="{{{data.header.alt_text || data.header.description}}}" />
+                <img src="{{}}" />
             </button>
 
@@ -159 +159 @@
                 <# } else { #>
 
-            <img src="{{{data.header.thumbnail_url}}}" alt="{{{data.header.alt_text || data.header.description}}}" />
+            <img src="{{}}" />
 
                 <# } #>

branches/5.7/src/wp-includes/customize/class-wp-customize-site-icon-control.php

@@ -69 +69 @@
                                 <img src="{{ data.attachment.sizes.full ? data.attachment.sizes.full.url : data.attachment.url }}" alt="<?php esc_attr_e( 'Preview as a browser icon' ); ?>"/>
                             </div>
-                            <span class="browser-title" aria-hidden="true"><# print( '<?php bloginfo( 'name' ); ?>' ) #></span>
+                            <span class="browser-title" aria-hidden="true"><# print( '<?php  ); ?>' ) #></span>
                         </div>
                         <img class="app-icon-preview" src="{{ data.attachment.sizes.full ? data.attachment.sizes.full.url : data.attachment.url }}" alt="<?php esc_attr_e( 'Preview as an app icon' ); ?>"/>

branches/5.7/src/wp-includes/deprecated.php

@@ -4204 +4204 @@
     wp_strict_cross_origin_referrer();
 }
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+

branches/5.7/src/wp-includes/functions.php

@@ -3289 +3289 @@
         $html = __( 'The link you followed has expired.' );
         if ( wp_get_referer() ) {
+
+
             $html .= '</p><p>';
             $html .= sprintf(
                 '<a href="%s">%s</a>',
-                esc_url( remove_query_arg( 'updated', wp_get_referer() ) ),
+                esc_url(  ),
                 __( 'Please try again.' )
             );

branches/5.7/src/wp-includes/media-template.php

@@ -1494 +1494 @@
                 <img id="preview-favicon" src="{{ data.url }}" alt="<?php esc_attr_e( 'Preview as a browser icon' ); ?>"/>
             </div>
-            <span class="browser-title" aria-hidden="true"><# print( '<?php bloginfo( 'name' ); ?>' ) #></span>
+            <span class="browser-title" aria-hidden="true"><# print( '<?php  ); ?>' ) #></span>
         </div>
 

branches/5.7/src/wp-includes/pluggable.php

@@ -351 +351 @@
         $phpmailer->clearCustomHeaders();
         $phpmailer->clearReplyTos();
+
+
 
         // Set "From" name and email.

branches/5.7/src/wp-includes/post.php

@@ -7591 +7591 @@
 
 /**
- * Filters the SQL clauses of an attachment query to include filenames.
- *
- * @since 4.7.0
- * @access private
- *
- * @global wpdb $wpdb WordPress database abstraction object.
- *
- * @param string[] $clauses An array including WHERE, GROUP BY, JOIN, ORDER BY,
- *                          DISTINCT, fields (SELECT), and LIMITS clauses.
- * @return string[] The modified array of clauses.
- */
-function _filter_query_attachment_filenames( $clauses ) {
-    global $wpdb;
-    remove_filter( 'posts_clauses', __FUNCTION__ );
-
-    // Add a LEFT JOIN of the postmeta table so we don't trample existing JOINs.
-    $clauses['join'] .= " LEFT JOIN {$wpdb->postmeta} AS sq1 ON ( {$wpdb->posts}.ID = sq1.post_id AND sq1.meta_key = '_wp_attached_file' )";
-
-    $clauses['groupby'] = "{$wpdb->posts}.ID";
-
-    $clauses['where'] = preg_replace(
-        "/\({$wpdb->posts}.post_content (NOT LIKE|LIKE) (\'[^']+\')\)/",
-        '$0 OR ( sq1.meta_value $1 $2 )',
-        $clauses['where']
-    );
-
-    return $clauses;
-}
-
-/**
  * Sets the last changed time for the 'posts' cache group.
  *

branches/5.7/src/wp-includes/rest-api/endpoints/class-wp-rest-attachments-controller.php

@@ -90 +90 @@
         // Filter query clauses to include filenames.
         if ( isset( $query_args['s'] ) ) {
-            add_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
+            add_filter( '' );
         }
 

branches/5.7/src/wp-includes/rest-api/endpoints/class-wp-rest-terms-controller.php

@@ -136 +136 @@
 
     /**
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
      * Checks if a request has access to read terms in the specified taxonomy.
      *
@@ -156 +185 @@
                 array( 'status' => rest_authorization_required_code() )
             );
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
         }
 

branches/5.7/src/wp-includes/widgets.php

@@ -1527 +1527 @@
     if ( is_wp_error( $rss ) ) {
         if ( is_admin() || current_user_can( 'manage_options' ) ) {
-            echo '<p><strong>' . __( 'RSS Error:' ) . '</strong> ' . $rss->get_error_message() . '</p>';
+            echo '<p><strong>' . __( 'RSS Error:' ) . '</strong> ' . ) . '</p>';
         }
         return;
@@ -1650 +1650 @@
 
     if ( ! empty( $args['error'] ) ) {
-        echo '<p class="widget-error"><strong>' . __( 'RSS Error:' ) . '</strong> ' . $args['error'] . '</p>';
+        echo '<p class="widget-error"><strong>' . __( 'RSS Error:' ) . '</strong> ' .  . '</p>';
     }
 

branches/5.7/src/wp-mail.php

@@ -65 +65 @@
     wp_die( __( 'There doesn’t seem to be any new mail.' ) );
 }
+
+
+
 
 for ( $i = 1; $i <= $count; $i++ ) {
@@ -132 +135 @@
                 $author = sanitize_email( $author );
                 if ( is_email( $author ) ) {
-                    /* translators: %s: Post author email address. */
-                    echo '<p>' . sprintf( __( 'Author is %s' ), $author ) . '</p>';
                     $userdata = get_user_by( 'email', $author );
                     if ( ! empty( $userdata ) ) {

branches/5.7/src/wp-trackback.php

@@ -13 +13 @@
     wp( array( 'tb' => '1' ) );
 }
+
+
+
 
 /**

branches/5.7/tests/phpunit/tests/query/search.php

@@ -456 +456 @@
 
         add_post_meta( $attachment, '_wp_attached_file', 'some-image1.png', true );
-        add_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
+        add_filter( '' );
 
         // Pass post_type a string value.
@@ -486 +486 @@
 
         add_post_meta( $attachment, '_wp_attached_file', 'some-image2.png', true );
-        add_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
+        add_filter( '' );
 
         // Pass post_type an array value.
@@ -545 +545 @@
         add_post_meta( $attachment, '_wp_attached_file', 'some-image4.png', true );
         add_post_meta( $attachment, '_test_meta_key', 'value', true );
-        add_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
+        add_filter( '' );
 
         // Pass post_type a string value.
@@ -585 +585 @@
 
         add_post_meta( $attachment, '_wp_attached_file', 'some-image5.png', true );
-        add_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
+        add_filter( '' );
 
         // Pass post_type a string value.
@@ -610 +610 @@
      * @ticket 22744
      */
-    public function test_filter_query_attachment_filenames_unhooks_itself() {
-        add_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
-
-        apply_filters(
-            'posts_clauses',
-            array(
-                'where'    => '',
-                'groupby'  => '',
-                'join'     => '',
-                'orderby'  => '',
-                'distinct' => '',
-                'fields'   => '',
-                'limit'    => '',
-            )
-        );
-
-        $result = has_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
-
-        $this->assertFalse( $result );
+    public function test_wp_query_removes_filter_wp_allow_query_attachment_by_filename() {
+        $attachment = self::factory()->post->create(
+            array(
+                'post_type'    => 'attachment',
+                'post_status'  => 'publish',
+                'post_title'   => 'bar foo',
+                'post_content' => 'foo bar',
+                'post_excerpt' => 'This post has foo',
+            )
+        );
+
+        add_post_meta( $attachment, '_wp_attached_file', 'some-image1.png', true );
+        add_filter( 'wp_allow_query_attachment_by_filename', '__return_true' );
+
+        $q = new WP_Query(
+            array(
+                's'           => 'image1',
+                'fields'      => 'ids',
+                'post_type'   => 'attachment',
+                'post_status' => 'inherit',
+            )
+        );
+
+        $this->assertSame( array( $attachment ), $q->posts );
+
+        /*
+         * WP_Query should have removed the wp_allow_query_attachment_by_filename filter
+         * and thus not match the attachment created above
+         */
+        $q->get_posts();
+        $this->assertEmpty( $q->posts );
     }
 

branches/5.7/tests/phpunit/tests/rest-api/rest-comments-controller.php

@@ -2973 +2973 @@
                     'author_name'       => '<div>div</div> <strong>strong</strong> <script>oh noes</script>',
                     'author_user_agent' => '<div>div</div> <strong>strong</strong> <script>oh noes</script>',
+
                 ),
                 array(
@@ -2981 +2982 @@
                     'author_name'       => 'div strong',
                     'author_user_agent' => 'div strong',
+
                 )
             );
@@ -2990 +2992 @@
                     'author_name'       => '<div>div</div> <strong>strong</strong> <script>oh noes</script>',
                     'author_user_agent' => '<div>div</div> <strong>strong</strong> <script>oh noes</script>',
+
                 ),
                 array(
@@ -2998 +3001 @@
                     'author_name'       => 'div strong',
                     'author_user_agent' => 'div strong',
+
                 )
             );
@@ -3012 +3016 @@
                 'author_name'       => '\\\&\\\ &amp; &invalid; < &lt; &amp;lt;',
                 'author_user_agent' => '\\\&\\\ &amp; &invalid; < &lt; &amp;lt;',
+
             ),
             array(
@@ -3020 +3025 @@
                 'author_name'       => '\\\&amp;\\\ &amp; &amp;invalid; &lt; &lt; &amp;lt;',
                 'author_user_agent' => '\\\&\\\ &amp; &invalid; &lt; &lt; &amp;lt;',
+
             )
         );
@@ -3033 +3039 @@
                 'author_name'       => '<div>div</div> <strong>strong</strong> <script>oh noes</script>',
                 'author_user_agent' => '<div>div</div> <strong>strong</strong> <script>oh noes</script>',
+
             ),
             array(
@@ -3041 +3048 @@
                 'author_name'       => 'div strong',
                 'author_user_agent' => 'div strong',
+
             )
         );