Changeset 59923

Timestamp:

03/04/2025 05:53:27 AM (2 months ago)

Author:

audrasjb

Message:

Bookmarks: Update link_updated when a link is created or updated.

This changeset fixes an issue where the link_updated field was not updated in the old Link Manager. When a link was created or updated the link_updated field remained 0000-00-00 00:00:00.

Props lenasterg, audrasjb.
Fixes #56851.

File:

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

trunk/src/wp-admin/includes/bookmark.php

@@ -216 +216 @@
     $link_rel         = ( ! empty( $parsed_args['link_rel'] ) ) ? $parsed_args['link_rel'] : '';
     $link_category    = ( ! empty( $parsed_args['link_category'] ) ) ? $parsed_args['link_category'] : array();
+    $link_updated     = gmdate( 'Y-m-d H:i:s', current_time( 'timestamp', 0 ) );
 
     // Make sure we set a valid category.
@@ -223 +224 @@
 
     if ( $update ) {
-        if ( false === $wpdb->update( $wpdb->links, compact( 'link_url', 'link_name', 'link_image', 'link_target', 'link_description', 'link_visible', 'link_owner', 'link_rating', 'link_rel', 'link_notes', 'link_rss' ), compact( 'link_id' ) ) ) {
+        if ( false === $wpdb->update( $wpdb->links, compact( 'link_url', 'link_name', 'link_image', 'link_target', 'link_description', 'link_visible', 'link_owner', 'link_rating', 'link_rel', 'link_notes', 'link_rss', 'link_updated' ), compact( 'link_id' ) ) ) {
             if ( $wp_error ) {
                 return new WP_Error( 'db_update_error', __( 'Could not update link in the database.' ), $wpdb->last_error );
@@ -231 +232 @@
         }
     } else {
-        if ( false === $wpdb->insert( $wpdb->links, compact( 'link_url', 'link_name', 'link_image', 'link_target', 'link_description', 'link_visible', 'link_owner', 'link_rating', 'link_rel', 'link_notes', 'link_rss' ) ) ) {
+        if ( false === $wpdb->insert( $wpdb->links, compact( 'link_url', 'link_name', 'link_image', 'link_target', 'link_description', 'link_visible', 'link_owner', 'link_rating', 'link_rel', 'link_notes', 'link_rss', 'link_updated' ) ) ) {
             if ( $wp_error ) {
                 return new WP_Error( 'db_insert_error', __( 'Could not insert link into the database.' ), $wpdb->last_error );