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

trunk/wp-admin/import-blogger.php

@@ -64 +64 @@
             $post_author = trim(addslashes($postinfo[1]));
             // we'll check the author is registered already
-            $user = $wpdb->get_row("SELECT * FROM $tableusers WHERE user_login = '$post_author'");
+            $user = $wpdb->get_row("SELECT * FROM $wpdb->users WHERE user_login = '$post_author'");
             if (!$user) { // seems s/he's not, so let's register
                 $user_ip = '127.0.0.1';
@@ -77 +77 @@
                 $user_joindate = addslashes($user_joindate);
                 $result = $wpdb->query("
-                INSERT INTO $tableusers (
+                INSERT INTO $wpdb->users (
                     user_login,
                     user_pass,
@@ -106 +106 @@
             }
 
-            $post_author_ID = $wpdb->get_var("SELECT ID FROM $tableusers WHERE user_login = '$post_author'");
+            $post_author_ID = $wpdb->get_var("SELECT ID FROM $wpdb->users WHERE user_login = '$post_author'");
 
             $post_date = explode(' ', $post_date);
@@ -129 +129 @@
             
             // Quick-n-dirty check for dups:
-            $dupcheck = $wpdb->get_results("SELECT ID,post_date,post_title FROM $tableposts WHERE post_date='$post_date' AND post_title='$post_title' LIMIT 1",ARRAY_A);
+            $dupcheck = $wpdb->get_results("SELECT ID,post_date,post_title FROM $wpdb->posts WHERE post_date='$post_date' AND post_title='$post_title' LIMIT 1",ARRAY_A);
             if ($dupcheck[0]['ID']) {
                 print "<br />\nSkipping duplicate post, ID = '" . $dupcheck[0]['ID'] . "'<br />\n";
@@ -138 +138 @@
 
             $result = $wpdb->query("
-            INSERT INTO $tableposts 
+            INSERT INTO $wpdb->posts 
                 (post_author,post_date,post_content,post_title,post_category)
             VALUES 
@@ -152 +152 @@
     /* we've still got a bug that adds some empty posts with the date 0000-00-00 00:00:00
        here's the bugfix: */
-    $result = $wpdb->query("DELETE FROM $tableposts WHERE post_date=\"0000-00-00 00:00:00\"");
+    $result = $wpdb->query("DELETE FROM $wpdb->posts WHERE post_date=\"0000-00-00 00:00:00\"");
 
     upgrade_all();