WordPress.org
Get WordPress

Make WordPress Core

Changeset 11968


Ignore:
Timestamp:
09/24/2009 05:10:28 PM (17 years ago)
Author:
ryan
Message:

Actions for postmeta updates. Props Demitrious Kelly. see #10750

Location:
trunk
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • trunk/wp-admin/includes/post.php

    r11930 r11968  
    589589
    590590                $wpdb->query( $wpdb->prepare("INSERT INTO $wpdb->postmeta (post_id,meta_key,meta_value ) VALUES (%s, %s, %s)", $post_ID, $metakey, $metavalue) );
     591                do_action( 'added_postmeta', $wpdb->insert_id, $post_ID, $metakey, $metavalue );
     592               
    591593                return $wpdb->insert_id;
    592594        }
    … …  
    609611        wp_cache_delete($post_id, 'post_meta');
    610612
    611         return $wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->postmeta WHERE meta_id = %d", $mid) );
     613        do_action( 'delete_postmeta', $mid );
     614        $rval = $wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->postmeta WHERE meta_id = %d", $mid) );
     615        do_action( 'deleted_postmeta', $mid );
     616
     617        return $rval;
    612618}
    613619
    … …  
    698704        $where = compact( 'meta_id' );
    699705
    700         return $wpdb->update( $wpdb->postmeta, $data, $where );
     706        do_action( 'update_postmeta', $meta_id, $post_id, $meta_key, $meta_value );
     707        $rval = $wpdb->update( $wpdb->postmeta, $data, $where );
     708        do_action( 'updated_postmeta', $meta_id, $post_id, $meta_key, $meta_value );
     709
     710        return $rval;
    701711}
    702712

  • trunk/wp-includes/comment.php

    r11945 r11968  
    14501450        // Do pingbacks
    14511451        while ($ping = $wpdb->get_row("SELECT * FROM {$wpdb->posts}, {$wpdb->postmeta} WHERE {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id AND {$wpdb->postmeta}.meta_key = '_pingme' LIMIT 1")) {
    1452                 $wpdb->query("DELETE FROM {$wpdb->postmeta} WHERE post_id = {$ping->ID} AND meta_key = '_pingme';");
     1452                $mid = $wpdb->get_var( "SELECT meta_id FROM {$wpdb->postmeta} WHERE post_id = {$ping->ID} AND meta_key = '_pingme' LIMIT 1");
     1453                do_action( 'delete_postmeta', $mid );
     1454                $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->postmeta} WHERE meta_id = %d", $mid ) );
     1455                do_action( 'deleted_postmeta', $mid );
    14531456                pingback($ping->post_content, $ping->ID);
    14541457        }
    … …  
    14561459        // Do Enclosures
    14571460        while ($enclosure = $wpdb->get_row("SELECT * FROM {$wpdb->posts}, {$wpdb->postmeta} WHERE {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id AND {$wpdb->postmeta}.meta_key = '_encloseme' LIMIT 1")) {
    1458                 $wpdb->query( $wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE post_id = %d AND meta_key = '_encloseme';", $enclosure->ID) );
     1461                $mid = $wpdb->get_var( $wpdb->prepare("SELECT meta_id FROM {$wpdb->postmeta} WHERE post_id = %d AND meta_key = '_encloseme'", $enclosure->ID) );
     1462                do_action( 'delete_postmeta', $mid );
     1463                $wpdb->query( $wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_id =  %d", $mid) );
     1464                do_action( 'deleted_postmeta', $mid );
    14591465                do_enclose($enclosure->post_content, $enclosure->ID);
    14601466        }

  • trunk/wp-includes/functions.php

    r11961 r11968  
    11641164        foreach ( $pung as $link_test ) {
    11651165                if ( !in_array( $link_test, $post_links_temp[0] ) ) { // link no longer in post
    1166                         $wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->postmeta WHERE post_id = %d AND meta_key = 'enclosure' AND meta_value LIKE (%s)", $post_ID, $link_test . '%') );
     1166                        $mid = $wpdb->get_col( $wpdb->prepare("SELECT meta_id FROM $wpdb->postmeta WHERE post_id = %d AND meta_key = 'enclosure' AND meta_value LIKE (%s)", $post_ID, $link_test . '%') );
     1167                        do_action( 'delete_postmeta', $mid );
     1168                        $wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->postmeta WHERE post_id IN(%s)", implode( ',', $mid ) ) );
     1169                        do_action( 'deleted_postmeta', $mid );
    11671170                }
    11681171        }
    … …  
    11871190                                        $meta_value = "$url\n$len\n$type\n";
    11881191                                        $wpdb->insert($wpdb->postmeta, array('post_id' => $post_ID, 'meta_key' => 'enclosure', 'meta_value' => $meta_value) );
     1192                                        do_action( 'added_postmeta', $wpdb->insert_id, $post_ID, 'enclosure', $meta_value );
    11891193                                }
    11901194                        }

  • trunk/wp-includes/meta.php

    r11948 r11968  
    5858        $meta_key = stripslashes($meta_key);
    5959
    60         if ( ! $wpdb->get_var( $wpdb->prepare( "SELECT meta_key FROM $table WHERE meta_key = %s AND $column = %d", $meta_key, $object_id ) ) )
     60        if ( ! $meta_id = $wpdb->get_var( $wpdb->prepare( "SELECT meta_id FROM $table WHERE meta_key = %s AND $column = %d", $meta_key, $object_id ) ) )
    6161                return add_metadata($meta_type, $object_id, $meta_key, $meta_value);
    6262
    … …  
    7171        }
    7272
    73         do_action( "update_{$meta_type}_meta", $object_id, $meta_key, $meta_value );
     73        do_action( "update_{$meta_type}_meta", $object_id, $meta_key, $meta_value, $meta_id );
    7474
    7575        $wpdb->update( $table, $data, $where );
    7676        wp_cache_delete($object_id, $meta_type . '_meta');
    7777
    78         do_action( "updated_{$meta_type}_meta", $object_id, $meta_key, $meta_value );
     78        do_action( "updated_{$meta_type}_meta", $object_id, $meta_key, $meta_value, $meta_id );
    7979
    8080        return true;
    … …  
    9696        $meta_value = maybe_serialize( stripslashes_deep($meta_value) );
    9797
    98         $query = $wpdb->prepare( "DELETE FROM $table WHERE meta_key = %s", $meta_key );
    99 
     98        $query = $wpdb->prepare( "SELECT meta_id FROM $table WHERE meta_key = %s", $meta_key );
     99       
    100100        if ( $meta_value )
    101101                $query .= $wpdb->prepare("AND meta_value = %s", $meta_value );
     102
     103        $meta_ids = $wpdb->get_col( $query );
     104        if ( !count( $meta_ids ) )
     105                return false;
     106
     107        $query = "DELETE FROM $table WHERE meta_id IN( " . implode( ',', $meta_ids ) . " )";
    102108       
    103109        $count = $wpdb->query($query);
    … …  
    108114        wp_cache_delete($object_id, $meta_type . '_meta');
    109115
    110         do_action( "deleted_{$meta_type}_meta", $object_id, $meta_key, $meta_value );
     116        do_action( "deleted_{$meta_type}_meta", $object_id, $meta_key, $meta_value, $meta_ids );
    111117
    112118        return true;

  • trunk/wp-includes/post.php

    r11965 r11968  
    602602        $post_ids = $wpdb->get_col($wpdb->prepare("SELECT DISTINCT post_id FROM $wpdb->postmeta WHERE meta_key = %s", $post_meta_key));
    603603        if ( $post_ids ) {
    604                 $wpdb->query($wpdb->prepare("DELETE FROM $wpdb->postmeta WHERE meta_key = %s", $post_meta_key));
     604                $postmetaids = $wpdb->get_col( $wpdb->prepare( "SELECT meta_id FROM $wpdb->postmeta WHERE meta_key = %s", $post_meta_key ) );
     605                do_action( 'delete_postmeta', $postmetaids );
     606                $wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->postmeta WHERE meta_id IN(%s)", implode( ',', $postmetaids) ) );
     607                do_action( 'deleted_postmeta', $postmetaids );
    605608                foreach ( $post_ids as $post_id )
    606609                        wp_cache_delete($post_id, 'post_meta');
    … …  
    11031106        $wpdb->update( $wpdb->posts, $parent_data, $parent_where + array( 'post_type' => 'attachment' ) );
    11041107
    1105         $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->comments WHERE comment_post_ID = %d", $postid ));
    1106 
    1107         $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->postmeta WHERE post_id = %d", $postid ));
    1108 
     1108        $commentids = $wpdb->get_col( $wpdb->prepare( "SELECT comment_ID FROM $wpdb->comments WHERE comment_post_ID = %d", $postid ));
     1109        do_action( 'delete_comment', $commentids );
     1110        $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->comments WHERE comment_ID IN(%s)", implode( ',', $commentids ) ));
     1111        do_action( 'deleted_comment', $commentids );
     1112
     1113        $postmetaids = $wpdb->get_col( $wpdb->prepare( "SELECT meta_id FROM $wpdb->postmeta WHERE post_id = %d ", $post_id ));
     1114        do_action( 'delete_postmeta', $postmetaids );
     1115        $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->postmeta WHERE meta_id IN(%s)", implode( ',', $postmetaids ) ));
     1116        do_action( 'deleted_postmeta', $postmetaids );
     1117
     1118        do_action( 'delete_post', $post_id );
    11091119        $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->posts WHERE ID = %d", $postid ));
     1120        do_action( 'deleted_post', $post_id );
    11101121
    11111122        if ( 'page' == $post->post_type ) {
    … …  
    25852596        wp_delete_object_term_relationships($post_id, array('category', 'post_tag'));
    25862597
    2587         $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->comments WHERE comment_post_ID = %d", $post_id ));
    2588 
    2589         $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->postmeta WHERE post_id = %d ", $post_id ));
    2590 
     2598        $commentids = $wpdb->get_col( $wpdb->prepare( "SELECT comment_ID FROM $wpdb->comments WHERE comment_post_ID = %d", $post_id ));
     2599        do_action( 'delete_comment', $commentids );
     2600        $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->comments WHERE comment_ID IN(%s)", implode( ',', $commentids ) ));
     2601        do_action( 'deleted_comment', $commentids );
     2602
     2603        $postmetaids = $wpdb->get_col( $wpdb->prepare( "SELECT meta_id FROM $wpdb->postmeta WHERE post_id = %d ", $post_id ));
     2604        do_action( 'delete_postmeta', $postmetaids );
     2605        $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->postmeta WHERE meta_id IN(%s)", implode( ',', $postmetaids ) ));
     2606        do_action( 'deleted_postmeta', $postmetaids );
     2607
     2608        do_action( 'delete_post', $post_id );
    25912609        $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->posts WHERE ID = %d", $post_id ));
     2610        do_action( 'deleted_post', $post_id );
    25922611
    25932612        $uploadpath = wp_upload_dir();
    … …  
    32713290
    32723291        $data = array( 'post_id' => $post_id, 'meta_value' => '1' );
    3273         if ( get_option('default_pingback_flag') )
     3292        if ( get_option('default_pingback_flag') ) {
    32743293                $wpdb->insert( $wpdb->postmeta, $data + array( 'meta_key' => '_pingme' ) );
     3294                do_action( 'added_postmeta', $wpdb->insert_id, $post_id, '_pingme', 1 );
     3295        }
    32753296        $wpdb->insert( $wpdb->postmeta, $data + array( 'meta_key' => '_encloseme' ) );
     3297        do_action( 'added_postmeta', $wpdb->insert_id, $post_id, '_encloseme', 1 );
     3298
    32763299        wp_schedule_single_event(time(), 'do_pings');
    32773300}
Note: See TracChangeset for help on using the changeset viewer.