Changeset 41628 for trunk/src/wp-admin/includes/nav-menu.php

Timestamp:

09/28/2017 04:31:05 AM (7 years ago)

Author:

pento

Message:

Database: Don't quote placeholders in queries going through $wpdb->prepare()

To bring Core into line with the changes to $wpdb->prepare() in WordPress 4.8.2, query placeholders shouldn't be quoted.

Props jrf, johnjamesjacoby.
Fixes #41983.

File:

• trunk/src/wp-admin/includes/nav-menu.php (modified) (1 diff)

trunk/src/wp-admin/includes/nav-menu.php

@@ -997 +997 @@
 
     // Delete orphaned draft menu items.
-    $menu_items_to_delete = $wpdb->get_col($wpdb->prepare("SELECT ID FROM $wpdb->posts AS p LEFT JOIN $wpdb->postmeta AS m ON p.ID = m.post_id WHERE post_type = 'nav_menu_item' AND post_status = 'draft' AND meta_key = '_menu_item_orphaned' AND meta_value < '%d'", $delete_timestamp ) );
+    $menu_items_to_delete = $wpdb->get_col($wpdb->prepare("SELECT ID FROM $wpdb->posts AS p LEFT JOIN $wpdb->postmeta AS m ON p.ID = m.post_id WHERE post_type = 'nav_menu_item' AND post_status = 'draft' AND meta_key = '_menu_item_orphaned' AND meta_value < %d", $delete_timestamp ) );
 
     foreach ( (array) $menu_items_to_delete as $menu_item_id )