Changeset 2867

Timestamp:

09/10/05 22:45:32 (3 years ago)

Author:

ryan

Message:

Make RSS importer actually kinda work.

Files:

• trunk/wp-admin/import/rss.php (modified) (6 diffs)

trunk/wp-admin/import/rss.php

@@ -1 +1 @@
-<?php
+
+// Example:
+// define('RSSFILE', '/home/example/public_html/rss.xml');
+define('RSSFILE', 'rss.xml');
+
-class RSS_Import {
-
-    var $authors = array ();
-    var $posts = array ();
-
@@ -14 +18 @@
-    }
-
+    function unhtmlentities($string) { // From php.net for < 4.3 compat
+        $trans_tbl = get_html_translation_table(HTML_ENTITIES);
+        $trans_tbl = array_flip($trans_tbl);
+        return strtr($string, $trans_tbl);
+    }
+    
-    function greet() {
-        $this->header();
@@ -25 +35 @@
-<a href="admin.php?import=rss&amp;step=1">Begin RSS Import &raquo;</a>
-<?php
-
-        endif;
-        $this->footer();
@@ -31 +40 @@
-
-    function get_posts() {
+        global $wpdb;
+        
-        set_magic_quotes_runtime(0);
-        $datalines = file(RSSFILE); // Read the file into an array
@@ -36 +47 @@
-        $importdata = str_replace(array ("\r\n", "\r"), "\n", $importdata);
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-    }
-
-    function import_posts() {
-        echo '<ol>';
-        foreach ($this->posts as $post)
-            : $title = $date = $categories = $content = $post_id = '';
-        echo "<li>Importing post... ";
-
-
-
-
+
+
-
-preg_match('|<pubdate>(.*?)</pubdate>|is', $post, $date
+   extract($post
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-        $post_date = gmdate('Y-m-d H:i:s', $date);
-
-        preg_match_all('|<category>(.*?)</category>|is', $post, $categories);
-        $categories = $categories[1];
-
-        if (!$categories)
-            : preg_match_all('|<dc:subject>(.*?)</dc:subject>|is', $post, $categories);
-        $categories = $categories[1];
-        endif;
-
-        preg_match('|<guid.+?>(.*?)</guid>|is', $post, $guid);
-        if ($guid)
-            $guid = $wpdb->escape(trim($guid[1]));
-        else
-            $guid = '';
-
-        preg_match('|<content:encoded>(.*?)</content:encoded>|is', $post, $content);
-        $content = str_replace(array ('<![CDATA[', ']]>'), '', $wpdb->escape(trim($content[1])));
-
-        if (!$content)
-            : // This is for feeds that put content in description
-            preg_match('|<description>(.*?)</description>|is', $post, $content);
-        $content = $wpdb->escape(unhtmlentities(trim($content[1])));
-        endif;
-
-        // Clean up content
-        $content = preg_replace('|<(/?[A-Z]+)|e', "'<' . strtolower('$1')", $content);
-        $content = str_replace('<br>', '<br />', $content);
-        $content = str_replace('<hr>', '<hr />', $content);
-
-        // This can mess up on posts with no titles, but checking content is much slower
-        // So we do it as a last resort
-        if ('' == $title)
-            : $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 $wpdb->posts WHERE post_title = '$title' AND post_date = '$post_date'");
-        endif;
-
-        // Now lets put it in the DB
-        if ($dupe)
-            : echo 'Post already imported';
-        else
-            : $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, guid)
-                    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', '$guid')");
-        $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))
-            : foreach ($categories as $post_category)
-                : $post_category = unhtmlentities($post_category);
-        // See if the category exists yet
-        $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 $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 $wpdb->post2cat WHERE post_id = $post_id AND category_id = $cat_id");
-
-        if (!$exists) {
-            $wpdb->query("
-                        INSERT INTO $wpdb->post2cat
-                        (post_id, category_id)
-                        VALUES
-                        ($post_id, $cat_id)
-                        ");
-        }
-        endforeach;
-        else
-            : $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>';
-        endif;
-
-        endforeach;
-        echo '</ol>';
-
-    }
-
-
+
-    function import() {
-
-
-
-
+
+
+
+
+
+
+
-        $this->get_posts();
-        $this->import_posts();
-../
+' . get_option('home') . '
-    }
-
+
-    function dispatch() {
-
+ 
-            $step = 0;
-        else
-            $step = (int) $_GET['step'];
-
+
-        switch ($step) {
-
+ 
-                $this->greet();
-                break;
-
+ 
-                $this->import();
-                break;
-        }
-    }
-
+
-    function RSS_Import() {
-        // Nothing. 
@@ -182 +172 @@
-$rss_import = new RSS_Import();
-
-
-
+
-?>