Changeset 42401 for trunk/src/wp-includes/query.php

Timestamp:

12/15/2017 08:30:50 AM (8 years ago)

Author:

pento

Message:

Canonical URLs: Redirect to the correct URL when the post date changes.

When a post slug is changed, we store a copy of the old slug, so that we can redirect visitors visiting the old URL to the new URL.

In the same way, this stores a copy of the old date, when the post date changes, so we can redirect visitors to the new URL.

Props nickmomrik.
Fixes #15397 for trunk.

File:

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

trunk/src/wp-includes/query.php

@@ -846 +846 @@
  *
  * @since 2.1.0
- *
- * @global wpdb $wpdb WordPress database abstraction object.
  */
 function wp_old_slug_redirect() {
     if ( is_404() && '' !== get_query_var( 'name' ) ) {
-        global $wpdb;
-
         // Guess the current post_type based on the query vars.
         if ( get_query_var( 'post_type' ) ) {
@@ -876 +872 @@
         }
 
-        $query = $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta, $wpdb->posts WHERE ID = post_id AND post_type = %s AND meta_key = '_wp_old_slug' AND meta_value = %s", $post_type, get_query_var( 'name' ) );
-
-        // if year, monthnum, or day have been specified, make our query more precise
-        // just in case there are multiple identical _wp_old_slug values
-        if ( get_query_var( 'year' ) ) {
-            $query .= $wpdb->prepare( ' AND YEAR(post_date) = %d', get_query_var( 'year' ) );
+        $id = _find_post_by_old_slug( $post_type );
+
+        if ( ! $id ) {
+            $id = _find_post_by_old_date( $post_type );
         }
-        if ( get_query_var( 'monthnum' ) ) {
-            $query .= $wpdb->prepare( ' AND MONTH(post_date) = %d', get_query_var( 'monthnum' ) );
-        }
-        if ( get_query_var( 'day' ) ) {
-            $query .= $wpdb->prepare( ' AND DAYOFMONTH(post_date) = %d', get_query_var( 'day' ) );
-        }
-
-        $id = (int) $wpdb->get_var( $query );
+
+        /**
+         * Filters the old slug redirect post ID.
+         *
+         * @since 4.9.2
+         *
+         * @param string $id The redirect post ID.
+         */
+        $id = apply_filters( 'old_slug_redirect_post_id', $id );
 
         if ( ! $id ) {
@@ -923 +918 @@
 
 /**
+ * Find the post ID for redirecting an old slug.
+ *
+ * @see wp_old_slug_redirect()
+ *
+ * @since 4.9.2
+ * @access private
+ *
+ * @global wpdb $wpdb WordPress database abstraction object.
+ *
+ * @param string $post_type The current post type based on the query vars.
+ * @return int $id The Post ID.
+ */
+function _find_post_by_old_slug( $post_type ) {
+    global $wpdb;
+
+    $query = $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta, $wpdb->posts WHERE ID = post_id AND post_type = %s AND meta_key = '_wp_old_slug' AND meta_value = %s", $post_type, get_query_var( 'name' ) );
+
+    // if year, monthnum, or day have been specified, make our query more precise
+    // just in case there are multiple identical _wp_old_slug values
+    if ( get_query_var( 'year' ) ) {
+        $query .= $wpdb->prepare( " AND YEAR(post_date) = %d", get_query_var( 'year' ) );
+    }
+    if ( get_query_var( 'monthnum' ) ) {
+        $query .= $wpdb->prepare( " AND MONTH(post_date) = %d", get_query_var( 'monthnum' ) );
+    }
+    if ( get_query_var( 'day' ) ) {
+        $query .= $wpdb->prepare( " AND DAYOFMONTH(post_date) = %d", get_query_var( 'day' ) );
+    }
+
+    $id = (int) $wpdb->get_var( $query );
+
+    return $id;
+}
+
+/**
+ * Find the post ID for redirecting an old date.
+ *
+ * @see wp_old_slug_redirect()
+ *
+ * @since 4.9.2
+ * @access private
+ *
+ * @global wpdb $wpdb WordPress database abstraction object.
+ *
+ * @param string $post_type The current post type based on the query vars.
+ * @return int $id The Post ID.
+ */
+
+function _find_post_by_old_date( $post_type ) {
+    global $wpdb;
+
+    $date_query = '';
+    if ( get_query_var( 'year' ) ) {
+        $date_query .= $wpdb->prepare( " AND YEAR(pm_date.meta_value) = %d", get_query_var( 'year' ) );
+    }
+    if ( get_query_var( 'monthnum' ) ) {
+        $date_query .= $wpdb->prepare( " AND MONTH(pm_date.meta_value) = %d", get_query_var( 'monthnum' ) );
+    }
+    if ( get_query_var( 'day' ) ) {
+        $date_query .= $wpdb->prepare( " AND DAYOFMONTH(pm_date.meta_value) = %d", get_query_var( 'day' ) );
+    }
+
+    $id = 0;
+    if ( $date_query ) {
+        $id = (int) $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta AS pm_date, $wpdb->posts WHERE ID = post_id AND post_type = %s AND meta_key = '_wp_old_date' AND post_name = %s" . $date_query, $post_type, get_query_var( 'name' ) ) );
+
+        if ( ! $id ) {
+            // Check to see if an old slug matches the old date
+            $id = (int) $wpdb->get_var( $wpdb->prepare( "SELECT ID FROM $wpdb->posts, $wpdb->postmeta AS pm_slug, $wpdb->postmeta AS pm_date WHERE ID = pm_slug.post_id AND ID = pm_date.post_id AND post_type = %s AND pm_slug.meta_key = '_wp_old_slug' AND pm_slug.meta_value = %s AND pm_date.meta_key = '_wp_old_date'" . $date_query, $post_type, get_query_var( 'name' ) ) );
+        }
+    }
+
+    return $id;
+}
+
+/**
  * Set up global post data.
  *