Changeset 1355 for trunk/wp-admin/import-rss.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/wp-admin/import-rss.php (modified) (4 diffs)

trunk/wp-admin/import-rss.php

@@ -125 +125 @@
 // So we do it as a last resort
 if ('' == $title) : 
-    $dupe = $wpdb->get_var("SELECT ID FROM $tableposts WHERE post_content = '$content' AND post_date = '$post_date'");
+    $dupe = $wpdb->get_var("SELECT ID FROM $wpdb->posts WHERE post_content = '$content' AND post_date = '$post_date'");
 else :
-    $dupe = $wpdb->get_var("SELECT ID FROM $tableposts WHERE post_title = '$title' AND post_date = '$post_date'");
+    $dupe = $wpdb->get_var("SELECT ID FROM $wpdb->posts WHERE post_title = '$title' AND post_date = '$post_date'");
 endif;
 
@@ -135 +135 @@
 else : 
     
-    $wpdb->query("INSERT INTO $tableposts 
+    $wpdb->query("INSERT INTO $wpdb->posts 
         (post_author, post_date, post_date_gmt, post_content, post_title,post_status, comment_status, ping_status, post_name)
         VALUES 
         ('$post_author', '$post_date', DATE_ADD('$post_date', INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE), '$content', '$title', 'publish', '$comment_status', '$ping_status', '$post_name')");
-    $post_id = $wpdb->get_var("SELECT ID FROM $tableposts WHERE post_title = '$title' AND post_date = '$post_date'");
+    $post_id = $wpdb->get_var("SELECT ID FROM $wpdb->posts WHERE post_title = '$title' AND post_date = '$post_date'");
     if (!$post_id) die("couldn't get post ID");
     if (0 != count($categories)) :
@@ -145 +145 @@
         $post_category = unhtmlentities($post_category);
         // See if the category exists yet
-        $cat_id = $wpdb->get_var("SELECT cat_ID from $tablecategories WHERE cat_name = '$post_category'");
+        $cat_id = $wpdb->get_var("SELECT cat_ID from $wpdb->categories WHERE cat_name = '$post_category'");
         if (!$cat_id && '' != trim($post_category)) {
             $cat_nicename = sanitize_title($post_category);
-            $wpdb->query("INSERT INTO $tablecategories (cat_name, category_nicename) VALUES ('$post_category', '$cat_nicename')");
-            $cat_id = $wpdb->get_var("SELECT cat_ID from $tablecategories WHERE cat_name = '$post_category'");
+            $wpdb->query("INSERT INTO $wpdb->categories (cat_name, category_nicename) VALUES ('$post_category', '$cat_nicename')");
+            $cat_id = $wpdb->get_var("SELECT cat_ID from $wpdb->categories WHERE cat_name = '$post_category'");
         }
         if ('' == trim($post_category)) $cat_id = 1;
         // Double check it's not there already
-        $exists = $wpdb->get_row("SELECT * FROM $tablepost2cat WHERE post_id = $post_id AND category_id = $cat_id");
+        $exists = $wpdb->get_row("SELECT * FROM $wpdb->post2cat WHERE post_id = $post_id AND category_id = $cat_id");
     
          if (!$exists) { 
             $wpdb->query("
-            INSERT INTO $tablepost2cat
+            INSERT INTO $wpdb->post2cat
             (post_id, category_id)
             VALUES
@@ -165 +165 @@
     endforeach;
     else:
-        $exists = $wpdb->get_row("SELECT * FROM $tablepost2cat WHERE post_id = $post_id AND category_id = 1");
-        if (!$exists) $wpdb->query("INSERT INTO $tablepost2cat (post_id, category_id) VALUES ($post_id, 1) ");
+        $exists = $wpdb->get_row("SELECT * FROM $wpdb->post2cat WHERE post_id = $post_id AND category_id = 1");
+        if (!$exists) $wpdb->query("INSERT INTO $wpdb->post2cat (post_id, category_id) VALUES ($post_id, 1) ");
     endif;
     echo 'Done!</li>';