Changeset 1355 for trunk/xmlrpc.php

Timestamp:

05/24/2004 08:22:18 AM (21 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";