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