<?php

/**

 * DotClear Importer

 *

 * @package WordPress

 * @subpackage Importer

 * @author Thomas Quinot

 * @link http://thomas.quinot.org/

 */

/**

	Add These Functions to make our lives easier

**/

if(!function_exists('get_comment_count'))

{

	/**

	 * Get the comment count for posts.

	 *

	 * @package WordPress

	 * @subpackage Dotclear_Import

	 *

	 * @param int $post_ID Post ID

	 * @return int

	 */

	function get_comment_count($post_ID)

	{

		global $wpdb;

		return $wpdb->get_var( $wpdb->prepare("SELECT count(*) FROM $wpdb->comments WHERE comment_post_ID = %d", $post_ID) );

	}

}

if(!function_exists('link_exists'))

{

	/**

	 * Check whether link already exists.

	 *

	 * @package WordPress

	 * @subpackage Dotclear_Import

	 *

	 * @param string $linkname

	 * @return int

	 */

	function link_exists($linkname)

	{

		global $wpdb;

		return $wpdb->get_var( $wpdb->prepare("SELECT link_id FROM $wpdb->links WHERE link_name = %s", $linkname) );

	}

}

/**

 * Convert from dotclear charset to utf8 if required

 *

 * @package WordPress

 * @subpackage Dotclear_Import

 *

 * @param string $s

 * @return string

 */

function csc ($s) {

	if (seems_utf8 ($s)) {

		return $s;

	} else {

		return iconv(get_option ("dccharset"),"UTF-8",$s);

	}

}

/**

 * @package WordPress

 * @subpackage Dotclear_Import

 *

 * @param string $s

 * @return string

 */

function textconv ($s) {

	return csc (preg_replace ('|(?<!<br />)\s*\n|', ' ', $s));

}

/**

 * Dotclear Importer class

 *

 * Will process the WordPress eXtended RSS files that you upload from the export

 * file.

 *

 * @package WordPress

 * @subpackage Importer

 *

 * @since unknown

 */

class Dotclear_Import {

	function header()

	{

		echo '<div class="wrap">';

		screen_icon();

		echo '<h2>'.__('Import DotClear').'</h2>';

		echo '<p>'.__('Steps may take a few minutes depending on the size of your database. Please be patient.').'</p>';

	}

	function footer()

	{

		echo '</div>';

	}

	function greet()

	{

		echo '<div class="narrow"><p>'.__('Howdy! This importer allows you to extract posts from a DotClear database into your blog.  Mileage may vary.').'</p>';

		echo '<p>'.__('Your DotClear Configuration settings are as follows:').'</p>';

		echo '<form action="admin.php?import=dotclear&amp;step=1" method="post">';

		wp_nonce_field('import-dotclear');

		$this->db_form();

		echo '<p class="submit"><input type="submit" name="submit" class="button" value="'.esc_attr__('Import Categories').'" /></p>';

		echo '</form></div>';

	}

	function get_dc_cats()

	{

		global $wpdb;

		// General Housekeeping

		$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));

		set_magic_quotes_runtime(0);

		$dbprefix = get_option('dcdbprefix');

		// Get Categories

		return $dcdb->get_results('SELECT * FROM '.$dbprefix.'categorie', ARRAY_A);

	}

	function get_dc_users()

	{

		global $wpdb;

		// General Housekeeping

		$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));

		set_magic_quotes_runtime(0);

		$dbprefix = get_option('dcdbprefix');

		// Get Users

		return $dcdb->get_results('SELECT * FROM '.$dbprefix.'user', ARRAY_A);

	}

	function get_dc_posts()

	{

		// General Housekeeping

		$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));

		set_magic_quotes_runtime(0);

		$dbprefix = get_option('dcdbprefix');

		// Get Posts

		return $dcdb->get_results('SELECT '.$dbprefix.'post.*, '.$dbprefix.'categorie.cat_libelle_url AS post_cat_name

						FROM '.$dbprefix.'post INNER JOIN '.$dbprefix.'categorie

						ON '.$dbprefix.'post.cat_id = '.$dbprefix.'categorie.cat_id', ARRAY_A);

	}

	function get_dc_comments()

	{

		global $wpdb;

		// General Housekeeping

		$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));

		set_magic_quotes_runtime(0);

		$dbprefix = get_option('dcdbprefix');

		// Get Comments

		return $dcdb->get_results('SELECT * FROM '.$dbprefix.'comment', ARRAY_A);

	}

	function get_dc_links()

	{

		//General Housekeeping

		$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));

		set_magic_quotes_runtime(0);

		$dbprefix = get_option('dcdbprefix');

		return $dcdb->get_results('SELECT * FROM '.$dbprefix.'link ORDER BY position', ARRAY_A);

	}

	function cat2wp($categories='')

	{

		// General Housekeeping

		global $wpdb;

		$count = 0;

		$dccat2wpcat = array();

		// Do the Magic

		if(is_array($categories))

		{

			echo '<p>'.__('Importing Categories...').'<br /><br /></p>';

			foreach ($categories as $category)

			{

				$count++;

				extract($category);

				// Make Nice Variables

				$name = $wpdb->escape($cat_libelle_url);

				$title = $wpdb->escape(csc ($cat_libelle));

				$desc = $wpdb->escape(csc ($cat_desc));

				if($cinfo = category_exists($name))

				{

					$ret_id = wp_insert_category(array('cat_ID' => $cinfo, 'category_nicename' => $name, 'cat_name' => $title, 'category_description' => $desc));

				}

				else

				{

					$ret_id = wp_insert_category(array('category_nicename' => $name, 'cat_name' => $title, 'category_description' => $desc));

				}

				$dccat2wpcat[$id] = $ret_id;

			}

			// Store category translation for future use

			add_option('dccat2wpcat',$dccat2wpcat);

			echo '<p>'.sprintf(_n('Done! <strong>%1$s</strong> category imported.', 'Done! <strong>%1$s</strong> categories imported.', $count), $count).'<br /><br /></p>';

			return true;

		}

		echo __('No Categories to Import!');

		return false;

	}

	function users2wp($users='')

	{

		// General Housekeeping

		global $wpdb;

		$count = 0;

		$dcid2wpid = array();

		// Midnight Mojo

		if(is_array($users))

		{

			echo '<p>'.__('Importing Users...').'<br /><br /></p>';

			foreach($users as $user)

			{

				$count++;

				extract($user);

				// Make Nice Variables

				$name = $wpdb->escape(csc ($name));

				$RealName = $wpdb->escape(csc ($user_pseudo));

				if($uinfo = get_userdatabylogin($name))

				{

					$ret_id = wp_insert_user(array(

								'ID'		=> $uinfo->ID,

								'user_login'	=> $user_id,

								'user_nicename'	=> $Realname,

								'user_email'	=> $user_email,

								'user_url'	=> 'http://',

								'display_name'	=> $Realname)

								);

				}

				else

				{

					$ret_id = wp_insert_user(array(

								'user_login'	=> $user_id,

								'user_nicename'	=> csc ($user_pseudo),

								'user_email'	=> $user_email,

								'user_url'	=> 'http://',

								'display_name'	=> $Realname)

								);

				}

				$dcid2wpid[$user_id] = $ret_id;

				// Set DotClear-to-WordPress permissions translation

				// Update Usermeta Data

				$user = new WP_User($ret_id);

				$wp_perms = $user_level + 1;

				if(10 == $wp_perms) { $user->set_role('administrator'); }

				else if(9  == $wp_perms) { $user->set_role('editor'); }

				else if(5  <= $wp_perms) { $user->set_role('editor'); }

				else if(4  <= $wp_perms) { $user->set_role('author'); }

				else if(3  <= $wp_perms) { $user->set_role('contributor'); }

				else if(2  <= $wp_perms) { $user->set_role('contributor'); }

				else                     { $user->set_role('subscriber'); }

				update_usermeta( $ret_id, 'wp_user_level', $wp_perms);

				update_usermeta( $ret_id, 'rich_editing', 'false');

				update_usermeta( $ret_id, 'first_name', csc ($user_prenom));

				update_usermeta( $ret_id, 'last_name', csc ($user_nom));

			}// End foreach($users as $user)

			// Store id translation array for future use

			add_option('dcid2wpid',$dcid2wpid);

			echo '<p>'.sprintf(__('Done! <strong>%1$s</strong> users imported.'), $count).'<br /><br /></p>';

			return true;

		}// End if(is_array($users)

		echo __('No Users to Import!');

		return false;

	}// End function user2wp()

	function posts2wp($posts='')

	{

		// General Housekeeping

		global $wpdb;

		$count = 0;

		$dcposts2wpposts = array();

		$cats = array();

		// Do the Magic

		if(is_array($posts))

		{

			echo '<p>'.__('Importing Posts...').'<br /><br /></p>';

			foreach($posts as $post)

			{

				$count++;

				extract($post);

				// Set DotClear-to-WordPress status translation

				$stattrans = array(0 => 'draft', 1 => 'publish');

				$comment_status_map = array (0 => 'closed', 1 => 'open');

				//Can we do this more efficiently?

				$uinfo = ( get_userdatabylogin( $user_id ) ) ? get_userdatabylogin( $user_id ) : 1;

				$authorid = ( is_object( $uinfo ) ) ? $uinfo->ID : $uinfo ;

				$Title = $wpdb->escape(csc ($post_titre));

				$post_content = textconv ($post_content);

				$post_excerpt = "";

				if ($post_chapo != "") {

					$post_excerpt = textconv ($post_chapo);

					$post_content = $post_excerpt ."\n<!--more-->\n".$post_content;

				}

				$post_excerpt = $wpdb->escape ($post_excerpt);

				$post_content = $wpdb->escape ($post_content);

				$post_status = $stattrans[$post_pub];

				// Import Post data into WordPress

				if($pinfo = post_exists($Title,$post_content))

				{

					$ret_id = wp_insert_post(array(

							'ID'			=> $pinfo,

							'post_author'		=> $authorid,

							'post_date'		=> $post_dt,

							'post_date_gmt'		=> $post_dt,

							'post_modified'		=> $post_upddt,

							'post_modified_gmt'	=> $post_upddt,

							'post_title'		=> $Title,

							'post_content'		=> $post_content,

							'post_excerpt'		=> $post_excerpt,

							'post_status'		=> $post_status,

							'post_name'		=> $post_titre_url,

							'comment_status'	=> $comment_status_map[$post_open_comment],

							'ping_status'		=> $comment_status_map[$post_open_tb],

							'comment_count'		=> $post_nb_comment + $post_nb_trackback)

							);

					if ( is_wp_error( $ret_id ) )

						return $ret_id;

				}

				else

				{

					$ret_id = wp_insert_post(array(

							'post_author'		=> $authorid,

							'post_date'		=> $post_dt,

							'post_date_gmt'		=> $post_dt,

							'post_modified'		=> $post_modified_gmt,

							'post_modified_gmt'	=> $post_modified_gmt,

							'post_title'		=> $Title,

							'post_content'		=> $post_content,

							'post_excerpt'		=> $post_excerpt,

							'post_status'		=> $post_status,

							'post_name'		=> $post_titre_url,

							'comment_status'	=> $comment_status_map[$post_open_comment],

							'ping_status'		=> $comment_status_map[$post_open_tb],

							'comment_count'		=> $post_nb_comment + $post_nb_trackback)

							);

					if ( is_wp_error( $ret_id ) )

						return $ret_id;

				}

				$dcposts2wpposts[$post_id] = $ret_id;

				// Make Post-to-Category associations

				$cats = array();

				$category1 = get_category_by_slug($post_cat_name);

				$category1 = $category1->term_id;

				if($cat1 = $category1) { $cats[1] = $cat1; }

				if(!empty($cats)) { wp_set_post_categories($ret_id, $cats); }

			}

		}

		// Store ID translation for later use

		add_option('dcposts2wpposts',$dcposts2wpposts);

		echo '<p>'.sprintf(__('Done! <strong>%1$s</strong> posts imported.'), $count).'<br /><br /></p>';

		return true;

	}

	function comments2wp($comments='')

	{

		// General Housekeeping

		global $wpdb;

		$count = 0;

		$dccm2wpcm = array();

		$postarr = get_option('dcposts2wpposts');

		// Magic Mojo

		if(is_array($comments))

		{

			echo '<p>'.__('Importing Comments...').'<br /><br /></p>';

			foreach($comments as $comment)

			{

				$count++;

				extract($comment);

				// WordPressify Data

				$comment_ID = (int) ltrim($comment_id, '0');

				$comment_post_ID = (int) $postarr[$post_id];

				$comment_approved = "$comment_pub";

				$name = $wpdb->escape(csc ($comment_auteur));

				$email = $wpdb->escape($comment_email);

				$web = "http://".$wpdb->escape($comment_site);

				$message = $wpdb->escape(textconv ($comment_content));

				if($cinfo = comment_exists($name, $comment_dt))

				{

					// Update comments

					$ret_id = wp_update_comment(array(