<?php
define('XMLFILE', 'lj_backup.xml');
// Example:
// define('XMLFILE', '/home/example/public_html/rss.xml');
// or if it's in the same directory as import-rss.php
// define('XMLFILE', 'rss.xml');
$total_posts = 0; // Change by Vinit Bhansali
$total_comments = 0; // Change by Vinit Bhansali
$comments_per_post = 0; // Change by Vinit Bhansali
$post_author = 2; // Author to import posts as author ID
$timezone_offset = -5; // GMT offset of posts your importing
$add_hours = intval($timezone_offset);
$add_minutes = intval(60 * ($timezone_offset - $add_hours));
if (!file_exists('../wp-config.php')) die("There doesn't seem to be a wp-config.php file. You must install WordPress before you import any entries.");
require('../wp-config.php');
$step = $_GET['step'];
if (!$step) $step = 0;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<title>WordPress › Import from RSS</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<style media="screen" type="text/css">
body {
font-family: Georgia, "Times New Roman", Times, serif;
margin-left: 20%;
margin-right: 20%;
}
#logo {
margin: 0;
padding: 0;
background-image: url(http://wordpress.org/images/logo.png);
background-repeat: no-repeat;
height: 60px;
border-bottom: 4px solid #333;
}
#logo a {
display: block;
text-decoration: none;
text-indent: -100em;
height: 60px;
}
p {
line-height: 140%;
}
</style>
</head><body>
<h1 id="logo"><a href="http://wordpress.org/">WordPress</a></h1>
<?php
switch($step) {
case 0:
?>
<p>Howdy!
This importer allows you to extract posts from a LiveJournal XML export
file. To get started you must edit the following line in this file
(<code>import-livejournal.php</code>) </p>
<p><code>define('XMLFILE', '');</code></p>
<p>You want to define where the XML file we'll be working with is, for example: </p>
<p><code>define('XMLFILE', '2002-04.xml');</code></p>
<p>You have to do this manually for security reasons.</p>
<p>If
you've done that and you’re all ready, <a
href="import-livejournal.php?step=1">let's go</a>!</p>
<?php
break;
case 1:
if ('' != XMLFILE && !file_exists(XMLFILE)) die("The file you specified does not seem to exist. Please check the path you've given.");
if ('' == XMLFILE) die("You must edit the XMLFILE line as described on the <a href='import-rss.php'>previous page</a> to continue.");
// Bring in the data
set_magic_quotes_runtime(0);
$datalines = file(XMLFILE); // Read the file into an array
$importdata = implode('', $datalines); // squish it
$importdata = str_replace(array("\r\n", "\r"), "\n", $importdata);
preg_match_all('|<entry>(.*?)</entry>|is', $importdata, $posts);
$posts = $posts[1];
echo '<ol>';
foreach ($posts as $post) :
$title = $date = $categories = $content = $post_id = '';
echo "<li>Importing post... ";
preg_match('|<subject>(.*?)</subject>|is', $post, $title);
$title = addslashes( trim($title[1]) );
$post_name = sanitize_title($title);
preg_match('|<eventtime>(.*?)</eventtime>|is', $post, $date);
$date = strtotime($date[1]);
$post_date = date('Y-m-d H:i:s', $date);
preg_match('|<event>(.*?)</event>|is', $post, $content);
// Changed by Vinit Bhansali (http://www.logic2go.com) on 28th Dec, to allow HTML safe imports from LJ
//OLD Code = // $content = str_replace( array('<![CDATA[', ']]>'), '', addslashes( trim($content[1]) ) );
$content = str_replace(array('<![CDATA[',']]>'), '', html_entity_decode(addslashes(trim($content[1]))));
// Now lets put it in the DB
if ($wpdb->get_var("SELECT ID FROM $tableposts WHERE post_title = '$title' AND post_date = '$post_date'")) :
{
echo 'Post already imported';
$total_posts--;
}
else :
$wpdb->query("INSERT
INTO $tableposts (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'");
if (!$post_id) die("couldn't get post ID");
$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) ");
// --------------------------------------------------------------------
// --------------------------------------------------------------------
// Code below added by Vinit Bhansali (http://www.logic2go.com)
// Export the comments from LiveJournal into WordPress
// the comment_author_url in the MySQL database will include a link to
// their blog on LiveJournal
preg_match_all('|<comment>(.*?)</comment>|is', $post, $comments);
$comments = $comments[1];
$comments_per_post = 0;
foreach ($comments as $comment) :
$comment_date = $comment_date_gmt = $comment_content = $comment_id = $comment_author = $comment_auth_url = '';
preg_match('|<eventtime>(.*?)</eventtime>|is', $comment, $tempdate);
$tempdate = strtotime($tempdate[1]);
$comment_date = date('Y-m-d H:i:s', $tempdate);
$comment_date_gmt = gmdate('Y-m-d H:i:s', $tempdate);
preg_match('|<event>(.*?)</event>|is', $comment, $comment_content);
// Changed by Vinit on 28th Dec, to allow HTML safe imports from LJ
//$content = str_replace( array('<![CDATA[', ']]>'), '', addslashes( trim($content[1]) ) );
$comment_content = str_replace(array('<![CDATA[',']]>'), '', html_entity_decode(addslashes(trim($comment_content[1]))));
preg_match('|<name>(.*?)</name>|is', $comment, $comment_author_name);
$comment_author_name = $comment_author_name[1];
if (strtolower($comment_author_name) != "anonymous")
$comment_author_url = "http://www.livejournal.com/users/" . $comment_author_name;
else
$comment_author_url = "";
preg_match('|<email>(.*?)</email>|is', $comment, $comment_author_email);
$comment_author_email = $comment_author_email[1];
$user_ip = "127.0.0.1";
// ---- Now insert this into the comments table
$wpdb->query("INSERT
INTO $tablecomments (comment_post_ID, comment_author,
comment_author_email, comment_author_url, comment_author_IP,
comment_date, comment_date_gmt, comment_content, comment_approved)
VALUES ('$post_id', '$comment_author_name', '$comment_author_email',
'$comment_author_url', '$user_ip', '$comment_date',
'$comment_date_gmt', '$comment_content', '1')");
$comments_per_post++;
endforeach;
$total_comments = $total_comments + $comments_per_post;
// ----------- End edit by Vinit Bhansali
//
// --------------------------------------------------------------------
// --------------------------------------------------------------------
echo 'Done with ' . $comments_per_post . ' comment(s)!</li>';
endif;
$total_posts++;
endforeach;
echo '<br><br>Total Posts imported: ' . $total_posts;
echo '<br>Total Comments imported: ' . $total_comments;
?>
</ol>
<h3>All done. <a href="../">Have fun!</a></h3>
<font size="-2">Modifications by <a href="http://www.logic2go.com">Vinit Bhansali</a></font>
<?php
break;
}
?>
</body>
</html>