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

trunk/wp-admin/import-greymatter.php

@@ -88 +88 @@
         $user_joindate=addslashes($user_joindate);
 
-        $loginthere = $wpdb->get_var("SELECT user_login FROM $tableusers WHERE user_login = '$user_login'");
+        $loginthere = $wpdb->get_var("SELECT user_login FROM $wpdb->users WHERE user_login = '$user_login'");
         if ($loginthere) {
             echo "<li>user <i>$user_login</i>... <b>Already exists</b></li>";
@@ -94 +94 @@
         }
 
-        $query = "INSERT INTO $tableusers (user_login,user_pass,user_nickname,user_email,user_url,user_ip,user_domain,user_browser,dateYMDhour,user_level,user_idmode) VALUES ('$user_login','$pass1','$user_nickname','$user_email','$user_url','$user_ip','$user_domain','$user_browser','$user_joindate','1','nickname')";
+        $query = "INSERT INTO $wpdb->users (user_login,user_pass,user_nickname,user_email,user_url,user_ip,user_domain,user_browser,dateYMDhour,user_level,user_idmode) VALUES ('$user_login','$pass1','$user_nickname','$user_email','$user_url','$user_ip','$user_domain','$user_browser','$user_joindate','1','nickname')";
         $result = mysql_query($query);
         if ($result==false) {
@@ -140 +140 @@
             $post_author=trim(addslashes($postinfo[1]));
             // we'll check the author is registered, or if it's a deleted author
-            $sql = "SELECT * FROM $tableusers WHERE user_login = '$post_author'";
+            $sql = "SELECT * FROM $wpdb->users WHERE user_login = '$post_author'";
             $result = mysql_query($sql);
             if (!mysql_num_rows($result)) { // if deleted from GM, we register the author as a level 0 user in b2
@@ -153 +153 @@
                 $user_url=addslashes("");
                 $user_joindate=addslashes($user_joindate);
-                $query = "INSERT INTO $tableusers (user_login,user_pass,user_nickname,user_email,user_url,user_ip,user_domain,user_browser,dateYMDhour,user_level,user_idmode) VALUES ('$user_login','$pass1','$user_nickname','$user_email','$user_url','$user_ip','$user_domain','$user_browser','$user_joindate','0','nickname')";
+                $query = "INSERT INTO $wpdb->users (user_login,user_pass,user_nickname,user_email,user_url,user_ip,user_domain,user_browser,dateYMDhour,user_level,user_idmode) VALUES ('$user_login','$pass1','$user_nickname','$user_email','$user_url','$user_ip','$user_domain','$user_browser','$user_joindate','0','nickname')";
                 $result = mysql_query($query);
                 if ($result==false) {
@@ -161 +161 @@
             }
 
-            $sql = "SELECT * FROM $tableusers WHERE user_login = '$post_author'";
+            $sql = "SELECT * FROM $wpdb->users WHERE user_login = '$post_author'";
             $result = mysql_query($sql);
             $myrow = mysql_fetch_array($result);
@@ -188 +188 @@
             $post_karma=$postinfo[12];
 
-            $query = "INSERT INTO $tableposts (post_author,post_date,post_content,post_title) VALUES ('$post_author_ID','$post_date','$post_content','$post_title')";
+            $query = "INSERT INTO $wpdb->posts (post_author,post_date,post_content,post_title) VALUES ('$post_author_ID','$post_date','$post_content','$post_title')";
             $result = mysql_query($query) or die(mysql_error());
 
@@ -194 +194 @@
                 die ("Error in posting...");
             
-            $sql2 = "SELECT * FROM $tableposts WHERE 1=1 ORDER BY ID DESC LIMIT 1";
+            $sql2 = "SELECT * FROM $wpdb->posts WHERE 1=1 ORDER BY ID DESC LIMIT 1";
             $result2 = mysql_query($sql2);
             $myrow2 = mysql_fetch_array($result2);
@@ -200 +200 @@
 
             // Grab a default category.
-            $post_category = $wpdb->get_var("SELECT cat_ID FROM $tablecategories LIMIT 1");
+            $post_category = $wpdb->get_var("SELECT cat_ID FROM $wpdb->categories LIMIT 1");
 
             // Update the post2cat table.
-            $exists = $wpdb->get_row("SELECT * FROM $tablepost2cat WHERE post_id = $post_ID AND category_id = $post_category");
+            $exists = $wpdb->get_row("SELECT * FROM $wpdb->post2cat WHERE post_id = $post_ID AND category_id = $post_category");
               
             if (!$exists) {
               $wpdb->query("
-                    INSERT INTO $tablepost2cat
+                    INSERT INTO $wpdb->post2cat
                     (post_id, category_id)
                     VALUES
@@ -237 +237 @@
                     $comment_content=addslashes($commentinfo[12]);
 
-                    $sql3 = "INSERT INTO $tablecomments (comment_post_ID,comment_author,comment_author_email,comment_author_url,comment_author_IP,comment_date,comment_content) VALUES ('$comment_post_ID','$comment_author','$comment_author_email','$comment_author_url','$comment_author_IP','$comment_date','$comment_content')";
+                    $sql3 = "INSERT INTO $wpdb->comments (comment_post_ID,comment_author,comment_author_email,comment_author_url,comment_author_IP,comment_date,comment_content) VALUES ('$comment_post_ID','$comment_author','$comment_author_email','$comment_author_url','$comment_author_IP','$comment_date','$comment_content')";
                     $result3 = mysql_query($sql3);
                     if (!$result3)