Migrate posts from phpnuke to WordPress

• 

  eyesonsky · Member · Dec 22, 2009 at 2:26 pm

  • Copy link
  • Add topic to favorites

  I have migrate my old phpnuke website to wordpress using this script
  You can check the result on http://www.eyesonsky.com/

  
/*------------------------------------------
2009 Joel Brueziere
Migrate posts from phpnuke to WordPress
------------------------------------------*/

  <?php

  $sql="";

  $dbhost = "yourhost";
  $user = "youruser";
  $password = "thepass";

  $conn = mysql_connect($dbhost,$user,$password);
  //echo "[conn=$conn]
  ";

  $sql="select sid, catid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, ihome from stories";

  if($conn){
  $result = mysql_query($sql);
  echo "[result=$result]
  ";
  $nb = mysql_num_rows($result);
  echo "[nb=$nb]
  ";

  while(list($sid, $catid, $aid, $title, $time, $hometext, $bodytext, $comments, $counter, $topic, $informant, $notes, $ihome) = mysql_fetch_row($result)) {
  echo "----------------------------------------------------------------------
  ";

  $title = addslashes($title);
  echo "
  title=$title
  ";
  $hometext = addslashes($hometext);
  echo "
  hometext=$hometext
  ";
  $bodytext = addslashes($bodytext);

  $sqlinsert="INSERT INTO wp.wpfr_posts (
  ID ,post_author ,post_date ,post_date_gmt ,post_content ,post_title ,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 (
  $sid , 1, ‘$time’, ‘$time’, ‘$hometext <!–more–> $bodytext’, ‘$title’, ”, ‘publish’, ‘open’, ‘open’, ”, ”, ”, ”, ‘$time’, ‘$time’, ”, ‘0’, ”, ‘0’, ‘post’, ”, ‘0’
  );
  “;
  $insert = mysql_query($sqlinsert);
  echo “
  insert=[$insert]
  “;
  }

  if($result){
  }else{
  echo “
  sql=$sql

  “;
  echo “error mysql_query
  “;
  }
  }
  else{
  echo “
  conn=$conn
  “;
  echo “
  sql=$sql
  “;
  echo “error connect db”;
  }

  ?>

• 

  eyesonsky · Member · Dec 22, 2009 at 2:45 pm

  • Copy link

  you can also take the php script here:

  http://www.eyesonsky.com/php/migration-nuke-wordpress.txt

• 

  raincoaster · Member · Dec 22, 2009 at 3:47 pm

  • Copy link

  Afraid none of that applies and you’re in the wrong forum. You need to be at wordpress.ORG. We at WordPress.COM do not have access to the php.