<?php


### fill in the host, user name, and password
$host = 'localhost';
$user = 'XXX';
$pw = 'XXX';

### Name of the old Drupal database
$olddb = "drupalmigration";

### Name of the WordPress database
$newdb = 'wordpress';

$dbc = mysqli_connect($host, $user, $pw, $newdb);

function q($query='')
{
	global $dbc;
	mysqli_query($dbc,$query);
}

	q('delete from wp_terms;');
	q('delete from wp_term_taxonomy;');
	q('delete from wp_term_relationships;');
	q('delete from wp_posts;');
	q('delete from wp_postmeta;');
	q('delete from wp_comments;');

#categories
	q("INSERT INTO wp_terms (term_id, name, slug) "
		. "SELECT term_data.tid, name, REPLACE(name,' ','') "
		. "FROM $olddb.term_data "
		. "where term_data.vid = 2;");

	q("INSERT INTO wp_term_taxonomy (term_taxonomy_id, term_id, parent)"
		. "select term_data.tid, term_data.tid, parent"
		. "from $olddb.term_data, $olddb.term_hierarchy"
		. "where (term_data.tid = term_hierarchy.tid) AND (term_data.vid=2);");

	q("update wp_term_taxonomy set taxonomy='category';");

#posts
	q("INSERT INTO wp_posts (id, post_date, post_content, post_title, "
	    	. "post_excerpt, post_name, post_modified, post_author) "
			. "SELECT DISTINCT n.nid, FROM_UNIXTIME(created), body, n.title, teaser, "
	    	. "REPLACE(REPLACE(REPLACE(REPLACE(LOWER(n.title),' ', '_'),'.', '_'),',', '_'),'+', '_'),"
	    	. " FROM_UNIXTIME(changed),n.uid "
			. "FROM $olddb.node n, $olddb.node_revisions r WHERE n.vid = r.vid;");

#category -> post
	q("INSERT INTO wp_term_relationships (object_id,term_taxonomy_id) SELECT nid,tid FROM $olddb.term_node;");
	
#category count
	q("UPDATE wp_term_taxonomy SET count = (SELECT COUNT(object_id) "
				. "FROM wp_term_relationships "
				. "WHERE wp_term_taxonomy.term_id = wp_term_relationships.term_taxonomy_id);");

#comments
	q("INSERT INTO  wp_comments "
    	. "(comment_post_ID, comment_date, comment_content, comment_parent, "
 		. "comment_author, comment_author_email, comment_author_url) "
		. "SELECT  nid, FROM_UNIXTIME(timestamp), "
    	. "comment, thread, name, mail, homepage "
		. "FROM $olddb.comments ;");

	# update comments count on wp_posts table
	q("UPDATE `wp_posts` SET `comment_count` = (SELECT COUNT(`comment_post_id`) "
		. "FROM `wp_comments` WHERE `wp_posts`.`id` = `wp_comments`.`comment_post_id`);");

	# fix post slugs. first we have to remove the duplicate _____ chars, then replace that with a single - char
	q("UPDATE wp_posts set post_name = REPLACE(post_name, '__', '_');");
	q("UPDATE wp_posts set post_name = REPLACE(post_name, '__', '_');");
	q("UPDATE wp_posts set post_name = REPLACE(post_name, '__', '_');");
	q("UPDATE wp_posts set post_name = REPLACE(post_name, '__', '_');");
	q("UPDATE wp_posts set post_name = REPLACE(post_name, '_', '-');");

#users

	q("INSERT INTO wordpress.wp_users "
  		. "(ID, user_login, user_pass, user_nicename, user_email, user_registered, display_name) "
  		. "SELECT uid, name, pass, name, mail, FROM_UNIXTIME(created), name "
  		. "FROM $olddb.users WHERE uid>1;");

mysqli_close($dbc);

?>