Changeset 10730 for trunk/wp-includes/comment.php

Timestamp:

03/06/2009 04:27:51 AM (17 years ago)

Author:

ryan

Message:

Use wpdb::insert() and update(). Props DD32. see #6836

File:

• trunk/wp-includes/comment.php (modified) (4 diffs)

trunk/wp-includes/comment.php

@@ -1021 +1021 @@
     global $wpdb;
 
+    $status = '0';
     switch ( $comment_status ) {
         case 'hold':
-            $query = $wpdb->prepare("UPDATE $wpdb->comments SET comment_approved='0' WHERE comment_ID = %d LIMIT 1", $comment_id);
+            $status = '0';
             break;
         case 'approve':
-            $query = $wpdb->prepare("UPDATE $wpdb->comments SET comment_approved='1' WHERE comment_ID = %d LIMIT 1", $comment_id);
+            $status = '1';
             if ( get_option('comments_notify') ) {
                 $comment = get_comment($comment_id);
@@ -1033 +1034 @@
             break;
         case 'spam':
-            $query = $wpdb->prepare("UPDATE $wpdb->comments SET comment_approved='spam' WHERE comment_ID = %d LIMIT 1", $comment_id);
+            $status = 'spam';
             break;
         case 'delete':
@@ -1042 +1043 @@
     }
 
-    if ( !$wpdb->query($query) ) {
+    if ( !$wpdb->update( $wpdb->comments, array('comment_approved' => $status), array('comment_ID' => $comment_id) ) ) {
         if ( $wp_error )
             return new WP_Error('db_update_error', __('Could not update comment status'), $wpdb->last_error);
@@ -1351 +1352 @@
     $pinged  = get_pung($post_id);
     if ( empty($to_ping) ) {
-        $wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET to_ping = '' WHERE ID = %d", $post_id) );
+        $wpdb->update($wpdb->posts, array('to_ping' => ''), array('ID' => $post_id) ); 
         return;
     }