POWERED BY http://lidan.info

ITEMS	FROM Serendipity 1.1 beta	TO Wordpress 2.0.4
mysql server
mysql username
mysql password
mysql database
mysql database prefix
mysql database charset (usually use latin1) (utf8 without "-")
time difference

$val) { $sql .= '`'.$val.'`,'; $value .= '"'.addslashes($arr2[$key]).'",'; } $res = substr($sql,0,-1).") values ".substr($value,0,-1).")"; return $res; } $link = mysql_connect($s9host, $s9user, $s9pass) or die('Could not connect: ' . mysql_error()); $link2 = mysql_connect($wphost, $wpuser, $wppass) or die('Could not connect: ' . mysql_error()); mysql_select_db($wpdb,$link2) or die('Could not select database'); mysql_query('TRUNCATE TABLE `'.$wppre.'posts`',$link2); mysql_query('TRUNCATE TABLE `'.$wppre.'post2cat`',$link2); mysql_query('TRUNCATE TABLE `'.$wppre.'categories`',$link2); mysql_query('TRUNCATE TABLE `'.$wppre.'comments`',$link2); //---------------transfer posts $arr1 = array( 'ID', 'post_author', 'post_date', 'post_date_gmt', 'post_content', 'post_title', 'post_category', 'post_status', 'comment_status', 'ping_status', 'comment_count' ); print <<transfer posts

EOF; $query = 'SELECT * FROM '.$s9pre.'entries'; mysql_select_db($s9db,$link) or die('Could not select database'); mysql_query("set names ".$s9char,$link); $result = mysql_query($query,$link) or die('Query failed: ' . mysql_error()); $num_rows = mysql_num_rows($result); $i=1; while ($value = mysql_fetch_array($result, MYSQL_ASSOC)) { mysql_select_db($wpdb,$link2) or die('Could not select database'); $arr2 = array($value[id], 1, date("Y-m-d H:i:s",($value[timestamp]+intval($offset)*3600)), date("Y-m-d H:i:s",$value[timestamp]), $value[body].($value[extended]==""?"":"".$value[extended]), $value[title], 1, 'publish', 'open', 'open', $value[comments] ); $sql = sql_insert($arr1,$arr2,$wppre.'posts'); mysql_query("set names ".$wpchar,$link2); mysql_query($sql,$link2) or die(mysql_error()); print << EOF; $i++; } mysql_free_result($result); //-------------------transfer post2cat mysql_select_db($s9db,$link) or die('Could not select database'); $arr1 = array( 'post_id', 'category_id' ); print <<transfer post2cat

EOF; $query = 'SELECT * FROM '.$s9pre.'entrycat'; mysql_query("set names ".$s9char,$link); $result = mysql_query($query,$link) or die('Query failed: ' . mysql_error()); $num_rows = mysql_num_rows($result); $i=1; while ($value = mysql_fetch_array($result, MYSQL_ASSOC)) { mysql_select_db($wpdb,$link2) or die('Could not select database'); $arr2 = array($value[entryid], $value[categoryid] ); $sql = sql_insert($arr1,$arr2,$wppre.'post2cat'); mysql_query("set names ".$wpchar,$link2); mysql_query($sql,$link2) or die(mysql_error()); print << EOF; $i++; } mysql_free_result($result); //-------------------transfer category mysql_select_db($s9db,$link) or die('Could not select database'); $arr1 = array( 'cat_ID', 'cat_name', 'category_parent', 'category_count' ); print <<transfer categories

EOF; $query = 'SELECT * FROM '.$s9pre.'category'; mysql_query("set names ".$s9char,$link); $result = mysql_query($query,$link) or die('Query failed: ' . mysql_error()); $num_rows = mysql_num_rows($result); $i=1; while ($value = mysql_fetch_array($result, MYSQL_ASSOC)) { mysql_select_db($wpdb,$link2) or die('Could not select database'); $arr2 = array($value[categoryid], $value[category_name], $value[parentid], 20 ); $sql = sql_insert($arr1,$arr2,$wppre.'categories'); mysql_query("set names ".$wpchar,$link2); mysql_query($sql,$link2) or die(mysql_error()); print << EOF; $i++; } mysql_free_result($result); //-------------------transfer comments mysql_select_db($s9db,$link) or die('Could not select database'); $arr1 = array( 'comment_ID', 'comment_post_ID', 'comment_author', 'comment_author_email', 'comment_author_url', 'comment_author_IP', 'comment_date', 'comment_date_gmt', 'comment_content', 'comment_approved', 'comment_parent' ); print <<transfer comments

EOF; $query = 'SELECT * FROM '.$s9pre.'comments'; mysql_query("set names ".$s9char,$link); $result = mysql_query($query,$link) or die('Query failed: ' . mysql_error()); $num_rows = mysql_num_rows($result); $i=1; while ($value = mysql_fetch_array($result, MYSQL_ASSOC)) { mysql_select_db($wpdb,$link2) or die('Could not select database'); $arr2 = array($value[id], $value[entry_id], $value[author], $value[email], $value[url], $value[ip], date("Y-m-d H:i:s",($value[timestamp]+intval($offset)*3600)), date("Y-m-d H:i:s",$value[timestamp]), $value[body], "1", $value[parent_id] ); $sql = sql_insert($arr1,$arr2,$wppre.'comments'); mysql_query("set names ".$wpchar,$link2); mysql_query($sql,$link2) or die(mysql_error()); print << EOF; $i++; } echo "done!"; mysql_free_result($result); mysql_close($link); mysql_close($link2); ?>