Changeset 1355 for trunk/xmlrpc.php

Timestamp:

05/24/2004 08:22:18 AM (22 years ago)

Author:

saxmatt

Message:

Giant commit, sorry mailing list people. Move all table names to new $wpdb versions. Works but the whole app needs thorough testing now.

File:

• trunk/xmlrpc.php (modified) (10 diffs)

trunk/xmlrpc.php

@@ -164 +164 @@
         function blogger_getRecentPosts($args) {
 
-          global $tableposts, $wpdb;
+          global $wpdb;
 
           $blog_ID    = $args[1]; /* though we don't use it yet */
@@ -181 +181 @@
           }
 
-          $sql = "SELECT * FROM $tableposts ORDER BY post_date DESC".$limit;
+          $sql = "SELECT * FROM $wpdb->posts ORDER BY post_date DESC".$limit;
           $result = $wpdb->get_results($sql);
 
@@ -323 +323 @@
         function blogger_newPost($args) {
 
-          global $tableposts, $wpdb;
+          global $wpdb;
 
           $blog_ID    = $args[1]; /* though we don't use it yet */
@@ -376 +376 @@
 
 function wp_insert_post($postarr = array()) {
-        global $wpdb, $tableposts, $post_default_category;
+        global $wpdb, $post_default_category;
         
         // export array as variables
@@ -401 +401 @@
                 $post_date_gmt = get_gmt_from_date($post_date);
         
-        $sql = "INSERT INTO $tableposts 
+        $sql = "INSERT INTO $wpdb->posts 
                 (post_author, post_date, post_date_gmt, post_modified, post_modified_gmt, post_content, post_title, post_excerpt, post_category, post_status, post_name) 
                 VALUES ('$post_author', '$post_date', '$post_date_gmt', '$post_date', '$post_date_gmt', '$post_content', '$post_title', '$post_excerpt', '$post_cat', '$post_status', '$post_name')";
@@ -417 +417 @@
 
 function wp_set_post_cats($blogid = '1', $post_ID = 0, $post_categories = array()) {
-        global $wpdb, $tablepost2cat;
+        global $wpdb;
         // If $post_categories isn't already an array, make it one:
         if (!is_array($post_categories)) {
@@ -431 +431 @@
         $old_categories = $wpdb->get_col("
                 SELECT category_id 
-                FROM $tablepost2cat 
+                FROM $wpdb->post2cat 
                 WHERE post_id = $post_ID");
         
@@ -454 +454 @@
                 foreach ($delete_cats as $del) {
                         $wpdb->query("
-                                DELETE FROM $tablepost2cat 
+                                DELETE FROM $wpdb->post2cat 
                                 WHERE category_id = $del 
                                         AND post_id = $post_ID 
@@ -471 +471 @@
                 foreach ($add_cats as $new_cat) {
                         $wpdb->query("
-                                INSERT INTO $tablepost2cat (post_id, category_id) 
+                                INSERT INTO $wpdb->post2cat (post_id, category_id) 
                                 VALUES ($post_ID, $new_cat)");
 
@@ -481 +481 @@
 
 function wp_get_post_cats($blogid = '1', $post_ID = 0) {
-        global $wpdb, $tablepost2cat;
+        global $wpdb;
         
         $sql = "SELECT category_id 
-                FROM $tablepost2cat 
+                FROM $wpdb->post2cat 
                 WHERE post_id = $post_ID 
                 ORDER BY category_id";