Changeset 41628
- Timestamp:
- 09/28/2017 04:31:05 AM (7 years ago)
- Location:
- trunk/src
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/wp-admin/includes/class-wp-importer.php
r41195 r41628 30 30 do { 31 31 $meta_key = $importer_name . '_' . $bid . '_permalink'; 32 $sql = $wpdb->prepare( "SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = '%s'LIMIT %d,%d", $meta_key, $offset, $limit );32 $sql = $wpdb->prepare( "SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = %s LIMIT %d,%d", $meta_key, $offset, $limit ); 33 33 $results = $wpdb->get_results( $sql ); 34 34 -
trunk/src/wp-admin/includes/nav-menu.php
r38981 r41628 997 997 998 998 // Delete orphaned draft menu items. 999 $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 ) );999 $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 ) ); 1000 1000 1001 1001 foreach ( (array) $menu_items_to_delete as $menu_item_id ) -
trunk/src/wp-includes/functions.php
r41614 r41628 4805 4805 $delete_timestamp = time() - ( DAY_IN_SECONDS * EMPTY_TRASH_DAYS ); 4806 4806 4807 $posts_to_delete = $wpdb->get_results($wpdb->prepare("SELECT post_id FROM $wpdb->postmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < '%d'", $delete_timestamp), ARRAY_A);4807 $posts_to_delete = $wpdb->get_results($wpdb->prepare("SELECT post_id FROM $wpdb->postmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < %d", $delete_timestamp), ARRAY_A); 4808 4808 4809 4809 foreach ( (array) $posts_to_delete as $post ) { … … 4822 4822 } 4823 4823 4824 $comments_to_delete = $wpdb->get_results($wpdb->prepare("SELECT comment_id FROM $wpdb->commentmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < '%d'", $delete_timestamp), ARRAY_A);4824 $comments_to_delete = $wpdb->get_results($wpdb->prepare("SELECT comment_id FROM $wpdb->commentmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < %d", $delete_timestamp), ARRAY_A); 4825 4825 4826 4826 foreach ( (array) $comments_to_delete as $comment ) { -
trunk/src/wp-includes/taxonomy.php
r41618 r41628 3789 3789 INNER JOIN {$wpdb->postmeta} AS m3 ON ( m3.post_id = m1.post_id ) 3790 3790 WHERE ( m1.meta_key = '_menu_item_type' AND m1.meta_value = 'taxonomy' ) 3791 AND ( m2.meta_key = '_menu_item_object' AND m2.meta_value = '%s')3791 AND ( m2.meta_key = '_menu_item_object' AND m2.meta_value = %s ) 3792 3792 AND ( m3.meta_key = '_menu_item_object_id' AND m3.meta_value = %d )", 3793 3793 $taxonomy, -
trunk/src/wp-includes/wp-db.php
r41496 r41628 1268 1268 * $find = 'only 43% of planets'; 1269 1269 * $like = $wild . $wpdb->esc_like( $find ) . $wild; 1270 * $sql = $wpdb->prepare( "SELECT * FROM $wpdb->posts WHERE post_content LIKE '%s'", $like );1270 * $sql = $wpdb->prepare( "SELECT * FROM $wpdb->posts WHERE post_content LIKE %s", $like ); 1271 1271 * 1272 1272 * Example Escape Chain:
Note: See TracChangeset
for help on using the changeset viewer.