This is a simple script which convert the stories and topics from a PHP-Nuke to a Wordpress database. This script not import the comments :P

The first and most important thing you have to do is install a Wordpress blog on your account/domain and empty the wp_post, wp_categories and the wp_post2cat tables, then complete this form and press the button "Start!" when you have all ready.

You have to use the same user and password for the 2 databases.
Server:
DB User:
DB Password:
PHP-Nuke DB Wordpress DB
DB Name:
  DB Name:

Once you press the button the migration starts, and you just have to make some coffee and let it do the dirty work :P

We assume that the name of the tables of the PHP-Nuke news are: nuke_topics and nuke_stories and the prefix for the Wordpress tables is wp_

One more thing, the database Collation type have to be the same for the 2 databases, if not, in some languages you will see some errors.

If you like this tool :), please put a link on your blog to my website: PHP en Español

categories convertion */ while ($myrow = mysql_fetch_array($srccatresult)) { $mytopictext = mysql_real_escape_string($myrow['topictext']); $mynicename = mysql_real_escape_string(sanitize($mytopictext)); $sql = "INSERT INTO `" . $wp_prefix . "categories` ( `cat_ID`, `cat_name`, `category_nicename`, `category_description` ) VALUES ( '$myrow[topicid]', '$myrow[topicname]', '$mynicename', '$mytopictext' );"; if($myrow[topicid] > 1) { mysql_select_db($db_wp, $db_connect); mysql_query($sql, $db_connect) or die("Fatal error: ".mysql_error()); } } /* Stories -> Posts convertion */ echo "Stories -> Posts convertion
"; while ($myrow = mysql_fetch_array($srcresult)) { $myhometext = mysql_real_escape_string($myrow['hometext']); if($myrow['bodytext']) { $mybodytext = mysql_real_escape_string($myrow['bodytext']); $myhometext = $myhometext.'\n\n'.$mybodytext; } $mytitle = mysql_real_escape_string($myrow['title']); $myname = mysql_escape_string(sanitize($mytitle)); $sql = "INSERT INTO `" . $wp_prefix . "posts` ( `ID` , `post_author` , `post_date` , `post_date_gmt` , `post_content` , `post_title` , `post_name` , `post_category` , `post_excerpt` , `post_status` , `comment_status` , `ping_status` , `post_password` , `to_ping` , `pinged` , `post_modified` , `post_modified_gmt` , `post_content_filtered` , `post_parent` ) VALUES ( '$myrow[sid]', '1', '$myrow[time]', '0000-00-00 00:00:00', '$myhometext', '$mytitle', '$myname', '$myrow[topic]', '', 'publish', 'open', 'open', '', '', '', '$myrow[time]', '0000-00-00 00:00:00', '', '0' );"; mysql_select_db($db_wp, $db_connect); mysql_query($sql, $db_connect); // now get the ID of the post we just added $sql = "select MAX(ID) from " . $wp_prefix . "posts"; $getID = mysql_query($sql, $db_connect); $currentID = mysql_fetch_array($getID); $currentID = $currentID['MAX(ID)']; echo "- Just inserted ID $currentID
\n"; // add post2cat map... why does he have this table? if ($myrow['topic'] == 0) $topicnum = 1; else $topicnum = $myrow['topic']; $sql = "insert into `" . $wp_prefix . "post2cat` (`post_id`, `category_id`) VALUES ('$currentID', '$topicnum');"; $result = mysql_query($sql, $db_connect) or die("Error: ".mysql_error()); } /* Updating Category Counts */ mysql_select_db($db_wp, $db_connect); $tidyresult = mysql_query("select * from $wp_prefix" . "categories", $db_connect) or die("Error: ".mysql_error()); echo "
Updating Category Counts
"; while ($myrow = mysql_fetch_array($tidyresult)) { $mypostid=$myrow['cat_ID']; $countsql="select COUNT(*) from $wp_prefix" . "post2cat" . " WHERE `category_id` = " . $mypostid; $countresult=mysql_query($countsql) or die("Fatal Error: ".mysql_error()); $catcount=mysql_result($countresult,0,0); $countsql="UPDATE `" . $wp_prefix . "categories` SET `category_count` = '" . $catcount . "' WHERE `cat_ID` = " . $mypostid . " LIMIT 1"; $countresult=mysql_query($countsql) or die("Fatal Error: ".mysql_error()); if($catcount > 0) { echo "- $mypostid : $catcount
\n"; } } echo "
Done!
"; } ?>