<?php
//Wordpress的URL路径
$wpURL = ‘http://www.litrin.net/’;
//目标数据库(mysql)设置
$mysqlServer = ‘localhost’;
$mysqlUser = ”;
$mysqlPasswd = ”;
$mysqlDB = ”;
//源数据库(pgsql)设置
$pgsqlServer = ‘localhost’;
$pgsqlUser = ”;
$pgsqlPasswd = ”;
$pgsqlDB = ”;
$mysql = mysql_connect($mysqlServer, $mysqlUser, $mysqlPasswd);
mysql_select_db($mysqlDB);
$pgsql = pg_connect(“host=”.$pgsqlServer.” port=5432 dbname=”.$pgsqlDB.” user=”.$pgsqlUser.” password=”.$pgsqlPasswd);
//先期准备
echo ‘Start import…n’;
mysql_query(‘SET NAME UTF8′);
mysql_query(‘TRUNCATE `wp_posts`’);
mysql_query(‘TRUNCATE `wp_comments`’);
//文章导入
echo ‘Start import node…n’;
$SQL = “SELECT nid, title, body, created, changed FROM node ORDER BY nid “;
$result = pg_query($pgsql, $SQL);
while ( $arr = pg_fetch_array($result, NULL, PGSQL_ASSOC) ){
 $title = $arr[title];
 $body = $arr[body];
 $createDate = date(DATE_ATOM, $arr[created]);
 $createDate_gmt = date(DATE_ATOM, $arr[created] – 8 * 3600);
 $changedDate = date(DATE_ATOM, $arr[changed]);
 $changedDate_gmt = date(DATE_ATOM, $arr[changed] – 8 * 3600);
 $id = $arr[nid];
 $postType = $wpURL . “?p=” . $id ;
 
 $sqlIns = “INSERT INTO `wp_posts`
    (`ID`,`post_author`, `post_date`, `post_date_gmt`, `post_content`,
    `post_title`, `post_category`, `post_excerpt`, `post_status`, `comment_status`,
    `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`,
    `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`,
    `post_type`, `post_mime_type`, `comment_count`)
   VALUES (
         ”.$id.”,1, ‘”.$createDate.”‘, ‘”.$createDate_gmt.”‘, ‘”.$body.”‘,
    ’”.$title.”‘, 0, ”, ‘publish’, ‘open’, ‘open’,
    ”, ‘”.$title.”‘, ”, ”, ‘”.$changedDate.”‘, ‘”.$changedDate_gmt.”‘,
    ”, 0, ‘”.$postType.”‘, 0, ‘post’, ”, 0)”;
 
 $query = mysql_query($sqlIns);
 
}
//评论导入
echo ‘Start import comment… n ‘;
$SQL= “SELECT cid, nid, name, homepage, timestamp, comment FROM comments ORDER BY cid”;
$result = pg_query($pgsql, $SQL);
while ( $arr = pg_fetch_array($result, NULL, PGSQL_ASSOC) ){
 $sqlIns= “INSERT INTO `wp_comments`
    (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`,
    `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`,
    `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`,
    `comment_type`, `comment_parent`, `user_id`)
   VALUES (“.$arr[cid].”, “.$arr[nid].”, ‘”.$arr[name].”‘, ”, ‘”.$arr[homepage].”‘,
    ”, ‘”.date(DATE_ATOM, $arr[timestamp]).”‘, ‘”.date(DATE_ATOM, $arr[timestamp] – 8 * 3600).”‘,
    ’”.$arr[comment].”‘, 0, ‘1′, ”, ”, 0, “.$arr[uid].”)”;
 
 $query = mysql_query($sqlIns); 
 
}
//评论整理
echo ‘Start arrage comment… n’;
$SQL= “SELECT comment_post_ID, count( `comment_ID` ) AS count FROM `wp_comments` GROUP BY `comment_post_ID` “;
$query = mysql_query($SQL);
while ($arr = mysql_fetch_array($query)){
 $sqlUp = “update wp_posts set comment_count = “.$arr[count].” where ID =”.$arr[comment_post_ID].”";
 mysql_query ($sqlUp);
}
mysql_close($mysql);
pg_close($pgsql);
echo ‘All finished! n’;
?>