Changeset 10730 for trunk/wp-includes/functions.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/functions.php (modified) (3 diffs)

trunk/wp-includes/functions.php

@@ -518 +518 @@
     }
 
-    $wpdb->query( $wpdb->prepare( "UPDATE $wpdb->options SET option_value = %s WHERE option_name = %s", $newvalue, $option_name ) );
+    $wpdb->update($wpdb->options, array('option_value' => $newvalue), array('option_name' => $option_name) );
+
     if ( $wpdb->rows_affected == 1 ) {
         do_action( "update_option_{$option_name}", $oldvalue, $_newvalue );
@@ -585 +586 @@
     }
 
-    $wpdb->query( $wpdb->prepare( "INSERT INTO $wpdb->options (option_name, option_value, autoload) VALUES (%s, %s, %s)", $name, $value, $autoload ) );
+    $wpdb->insert($wpdb->options, array('option_name' => $name, 'option_value' => $value, 'autoload' => $autoload) );
 
     do_action( "add_option_{$name}", $name, $value );
@@ -1091 +1092 @@
             if ( $headers = wp_get_http_headers( $url) ) {
                 $len = (int) $headers['content-length'];
-                $type = $wpdb->escape( $headers['content-type'] );
+                $type = $headers['content-type'];
                 $allowed_types = array( 'video', 'audio' );
                 if ( in_array( substr( $type, 0, strpos( $type, "/" ) ), $allowed_types ) ) {
                     $meta_value = "$url\n$len\n$type\n";
-                    $wpdb->query( $wpdb->prepare( "INSERT INTO `$wpdb->postmeta` ( `post_id` , `meta_key` , `meta_value` )
-                    VALUES ( %d, 'enclosure' , %s)", $post_ID, $meta_value ) );
+                    $wpdb->insert($wpdb->postmeta, array('post_id' => $post_ID, 'meta_key' => 'enclosure', 'meta_value' => $meta_value) );
                 }
             }