Navigation

← Previous Changeset
Next Changeset →

Changeset 3228

Timestamp:

11/29/05 00:40:09 (3 years ago)

Author:

ryan

Message:

Textpattern importer from Aaron Brazell.

Files:

trunk/wp-admin/import/textpattern.php (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

trunk/wp-admin/import/textpattern.php

r3096	r3228
	1	<?php
	2
	3	/*
	4	This Import Script is written by Aaron Brazell of Technosailor.com
	5
	6	It was developed using a large blog running Textpattern 4.0.2 and
	7	successfully imported nearly 3000 records at a time. Higher
	8	scalability is uncertain.
	9
	10	BACKUP YOUR DATABASE PRIOR TO RUNNING THIS IMPORT SCRIPT
	11	*/
	12
	13	// BEGIN EDITING
	14
	15	// $txpconfig options can be found in the Textpattern %textpattern%/config.php file
	16	$txpcfg['db'] = 'textpattern';
	17	$txpcfg['user'] = 'root';
	18	$txpcfg['pass'] = '';
	19	$txpcfg['host'] = 'localhost';
	20	$txpcfg['table_prefix'] = '';
	21
	22	// STOP EDITING
	23
	24	add_option('tpre',$txpcfg['table_prefix']);
	25
	26
	27	/**
	28	Add These Functions to make our lives easier
	29	**/
	30	if(!function_exists('get_cat_nicename'))
	31	{
	32	function get_catbynicename($category_nicename)
	33	{
	34	global $wpdb;
	35
	36	$cat_id -= 0; // force numeric
	37	$name = $wpdb->get_var('SELECT cat_ID FROM '.$wpdb->categories.' WHERE category_nicename="'.$category_nicename.'"');
	38
	39	return $name;
	40	}
	41	}
	42
	43	if(!function_exists('get_comment_count'))
	44	{
	45	function get_comment_count($post_ID)
	46	{
	47	global $wpdb;
	48	return $wpdb->get_var('SELECT count(*) FROM '.$wpdb->comments.' WHERE comment_post_ID = '.$post_ID);
	49	}
	50	}
	51
	52	if(!function_exists('link_exists'))
	53	{
	54	function link_exists($linkname)
	55	{
	56	global $wpdb;
	57	return $wpdb->get_var('SELECT link_id FROM '.$wpdb->links.' WHERE link_name = "'.$wpdb->escape($linkname).'"');
	58	}
	59	}
	60
	61	/**
	62	The Main Importer Class
	63	**/
	64	class Textpattern_Import {
	65
	66	var $posts = array ();
	67	var $file;
	68
	69	function header()
	70	{
	71	echo '<div class="wrap">';
	72	echo '<h2>'.__('Import Textpattern').'</h2>';
	73	}
	74
	75	function footer()
	76	{
	77	echo '</div>';
	78	}
	79
	80	function greet()
	81	{
	82	global $txpcfg;
	83
	84	_e('<p>Howdy! This importer allows you to extract posts from any Textpattern 4.0.2+ into your blog. This has not been tested on previous versions of Textpattern. Mileage may vary.</p>');
	85	_e('<p>Your Textpattern Configuration settings are as follows:</p>');
	86	_e('<ul><li><strong>Textpattern Database Name:</strong> '.$txpcfg['db'].'</li>');
	87	_e('<li><strong>Textpattern Database User:</strong> '.$txpcfg['user'].'</li>');
	88	_e('<li><strong>Textpattern Database Password:</strong> '.$txpcfg['pass'].'</li>');
	89	_e('<li><strong>Textpattern Database Host:</strong> '.$txpcfg['host'].'</li>');
	90	_e('</ul>');
	91	_e('<p>If this is incorrect, please modify settings in wp-admin/import/textpattern.php</p>');
	92	_e('<form action="admin.php?import=textpattern&step=1" method="post">');
	93	_e('<input type="submit" name="submit" value="Import Categories" />');
	94	_e('</form>');
	95	}
	96
	97	function get_txp_links()
	98	{
	99	//General Housekeeping
	100	global $txpdb;
	101	set_magic_quotes_runtime(0);
	102	$prefix = get_option('tpre');
	103
	104	return $txpdb->get_results('SELECT
	105	id,
	106	date,
	107	category,
	108	url,
	109	linkname,
	110	description
	111	FROM '.$prefix.'txp_link',
	112	ARRAY_A);
	113	echo'SELECT
	114	id,
	115	date,
	116	category,
	117	url,
	118	linkname,
	119	description
	120	FROM '.$prefix.'txp_link';
	121	}
	122
	123	function get_txp_cats()
	124	{
	125
	126	// General Housekeeping
	127	global $txpdb;
	128	set_magic_quotes_runtime(0);
	129	$prefix = get_option('tpre');
	130
	131	// Get Categories
	132	return $txpdb->get_results('SELECT
	133	id,
	134	name,
	135	title
	136	FROM '.$prefix.'txp_category
	137	WHERE type = "article"',
	138	ARRAY_A);
	139	}
	140
	141	function get_txp_posts()
	142	{
	143	// General Housekeeping
	144	global $txpdb;
	145	set_magic_quotes_runtime(0);
	146	$prefix = get_option('tpre');
	147
	148	// Get Posts
	149	return $txpdb->get_results('SELECT
	150	ID,
	151	Posted,
	152	AuthorID,
	153	LastMod,
	154	Title,
	155	Body,
	156	Excerpt,
	157	Category1,
	158	Category2,
	159	Status,
	160	Keywords,
	161	url_title,
	162	comments_count,
	163	ADDDATE(Posted, "INTERVAL '.get_settings('gmt_offset').' HOURS") AS post_date_gmt,
	164	ADDDATE(LastMod, "INTERVAL '.get_settings('gmt_offset').' HOURS") AS post_modified_gmt
	165	FROM '.$prefix.'textpattern
	166	', ARRAY_A);
	167	}
	168
	169	function get_txp_comments()
	170	{
	171	// General Housekeeping
	172	global $txpdb;
	173	set_magic_quotes_runtime(0);
	174	$prefix = get_option('tpre');
	175
	176	// Get Comments
	177	return $txpdb->get_results('SELECT * FROM '.$prefix.'txp_discuss', ARRAY_A);
	178	}
	179
	180	function get_txp_users()
	181	{
	182	// General Housekeeping
	183	global $txpdb;
	184	set_magic_quotes_runtime(0);
	185	$prefix = get_option('tpre');
	186
	187	// Get Users
	188	$users = $txpdb->get_results('SELECT
	189	user_id,
	190	name,
	191	RealName,
	192	email,
	193	privs
	194	FROM '.$prefix.'txp_users', ARRAY_A);
	195	return $users;
	196	}
	197
	198	function links2wp($links='')
	199	{
	200	// General Housekeeping
	201	global $wpdb;
	202	$count = 0;
	203
	204	// Deal with the links
	205	if(is_array($links))
	206	{
	207	echo __('<p>Importing Links...<br /><br /></p>');
	208	foreach($links as $link)
	209	{
	210	$count++;
	211	extract($link);
	212
	213	// Make nice vars
	214	$category = $wpdb->escape($category);
	215	$linkname = $wpdb->escape($linkname);
	216	$description = $wpdb->escape($description);
	217
	218	if($linfo = link_exists($linkname))
	219	{
	220	$ret_id = wp_insert_link(array(
	221	'link_id' => $linfo,
	222	'link_url' => $url,
	223	'link_name' => $linkname,
	224	'link_category' => $category,
	225	'link_description' => $description,
	226	'link_updated' => $date)
	227	);
	228	}
	229	else
	230	{
	231	$ret_id = wp_insert_link(array(
	232	'link_url' => $url,
	233	'link_name' => $linkname,
	234	'link_category' => $category,
	235	'link_description' => $description,
	236	'link_updated' => $date)
	237	);
	238	}
	239	$txplinks2wplinks[$link_id] = $ret_id;
	240	}
	241	add_option('txplinks2wplinks',$txplinks2wplinks);
	242	echo __('<p>Done! <strong>'.$count.'</strong> Links imported.<br /><br /></p>');
	243	return true;
	244	}
	245	echo 'No Links to Import!';
	246	return false;
	247	}
	248
	249	function users2wp($users='')
	250	{
	251	// General Housekeeping
	252	global $wpdb;
	253	$count = 0;
	254	$txpid2wpid = array();
	255
	256	// Midnight Mojo
	257	if(is_array($users))
	258	{
	259	echo __('<p>Importing Users...<br /><br /></p>');
	260	foreach($users as $user)
	261	{
	262	$count++;
	263	extract($user);
	264
	265	// Make Nice Variables
	266	$name = $wpdb->escape($name);
	267	$RealName = $wpdb->escape($RealName);
	268
	269	if($uinfo = get_userdatabylogin($name))
	270	{
	271
	272	$ret_id = wp_insert_user(array(
	273	'ID' => $uinfo->ID,
	274	'user_login' => $name,
	275	'user_nicename' => $RealName,
	276	'user_email' => $email,
	277	'user_url' => 'http://',
	278	'display_name' => $name)
	279	);
	280	}
	281	else
	282	{
	283	$ret_id = wp_insert_user(array(
	284	'user_login' => $name,
	285	'user_nicename' => $RealName,
	286	'user_email' => $email,
	287	'user_url' => 'http://',
	288	'display_name' => $name)
	289	);
	290	}
	291	$txpid2wpid[$user_id] = $ret_id;
	292
	293	// Set Textpattern-to-WordPress permissions translation
	294	$transperms = array(1 => '10', 2 => '9', 3 => '5', 4 => '4', 5 => '3', 6 => '2', 7 => '0');
	295
	296	// Update Usermeta Data
	297	$user = new WP_User($ret_id);
	298	if('10' == $transperms[$privs]) { $user->set_role('administrator'); }
	299	if('9' == $transperms[$privs]) { $user->set_role('editor'); }
	300	if('5' == $transperms[$privs]) { $user->set_role('editor'); }
	301	if('4' == $transperms[$privs]) { $user->set_role('author'); }
	302	if('3' == $transperms[$privs]) { $user->set_role('contributor'); }
	303	if('2' == $transperms[$privs]) { $user->set_role('contributor'); }
	304	if('0' == $transperms[$privs]) { $user->set_role('subscriber'); }
	305
	306	update_usermeta( $ret_id, 'wp_user_level', $transperms[$privs] );
	307	update_usermeta( $ret_id, 'rich_editing', 'false');
	308	}// End foreach($users as $user)
	309
	310	// Store id translation array for future use
	311	add_option('txpid2wpid',$txpid2wpid);
	312
	313
	314	echo __('<p>Done! <strong>'.$count.'</strong> users imported.<br /><br /></p>');
	315	return true;
	316	}// End if(is_array($users)
	317
	318	echo 'No Users to Import!';
	319	return false;
	320
	321	}// End function user2wp()
	322
	323	function cat2wp($categories='')
	324	{
	325	// General Housekeeping
	326	global $wpdb;
	327	$count = 0;
	328	$txpcat2wpcat = array();
	329
	330	// Do the Magic
	331	if(is_array($categories))
	332	{
	333	echo __('<p>Importing Categories...<br /><br /></p>');
	334	foreach ($categories as $category)
	335	{
	336	$count++;
	337	extract($category);
	338
	339
	340	// Make Nice Variables
	341	$name = $wpdb->escape($name);
	342	$title = $wpdb->escape($title);
	343
	344	if($cinfo = category_exists($name))
	345	{
	346	$ret_id = wp_insert_category(array('cat_ID' => $cinfo, 'category_nicename' => $name, 'cat_name' => $title));
	347	}
	348	else
	349	{
	350	$ret_id = wp_insert_category(array('category_nicename' => $name, 'cat_name' => $title));
	351	}
	352	$txpcat2wpcat[$id] = $ret_id;
	353	}
	354
	355	// Store category translation for future use
	356	add_option('txpcat2wpcat',$txpcat2wpcat);
	357	echo __('<p>Done! <strong>'.$count.'</strong> categories imported.<br /><br /></p>');
	358	return true;
	359	}
	360	echo 'No Categories to Import!';
	361	return false;
	362
	363	}
	364
	365	function posts2wp($posts='')
	366	{
	367	// General Housekeeping
	368	global $wpdb;
	369	$count = 0;
	370	$txpposts2wpposts = array();
	371	$cats = array();
	372
	373	// Do the Magic
	374	if(is_array($posts))
	375	{
	376	echo __('<p>Importing Posts...<br /><br /></p>');
	377	foreach($posts as $post)
	378	{
	379	$count++;
	380	extract($post);
	381
	382	// Set Textpattern-to-WordPress status translation
	383	$stattrans = array(1 => 'draft', 2 => 'private', 3 => 'draft', 4 => 'publish', 5 => 'publish');
	384
	385	//Can we do this more efficiently?
	386	$uinfo = ( get_userdatabylogin( $AuthorID ) ) ? get_userdatabylogin( $AuthorID ) : 1;
	387	$authorid = ( is_object( $uinfo ) ) ? $uinfo->ID : $uinfo ;
	388
	389	$Title = $wpdb->escape($Title);
	390	$Body = $wpdb->escape($Body);
	391	$Excerpt = $wpdb->escape($Excerpt);
	392	$post_status = $stattrans[$Status];
	393
	394	// Import Post data into WordPress
	395
	396	if($pinfo = post_exists($Title,$Body))
	397	{
	398	$ret_id = wp_insert_post(array(
	399	'ID' => $pinfo,
	400	'post_date' => $Posted,
	401	'post_date_gmt' => $post_date_gmt,
	402	'post_author' => $authorid,
	403	'post_modified' => $LastMod,
	404	'post_modified_gmt' => $post_modified_gmt,
	405	'post_title' => $Title,
	406	'post_content' => $Body,
	407	'post_excerpt' => $Excerpt,
	408	'post_status' => $post_status,
	409	'post_name' => $url_title,
	410	'comment_count' => $comments_count)
	411	);
	412	}
	413	else
	414	{
	415	$ret_id = wp_insert_post(array(
	416	'post_date' => $Posted,
	417	'post_date_gmt' => $post_date_gmt,
	418	'post_author' => $authorid,
	419	'post_modified' => $LastMod,
	420	'post_modified_gmt' => $post_modified_gmt,
	421	'post_title' => $Title,
	422	'post_content' => $Body,
	423	'post_excerpt' => $Excerpt,
	424	'post_status' => $post_status,
	425	'post_name' => $url_title,
	426	'comment_count' => $comments_count)
	427	);
	428	}
	429	$txpposts2wpposts[$ID] = $ret_id;
	430
	431	// Make Post-to-Category associations
	432	$cats = array();
	433	if($cat1 = get_catbynicename($Category1)) { $cats[1] = $cat1; }
	434	if($cat2 = get_catbynicename($Category2)) { $cats[2] = $cat2; }
	435
	436	if(!empty($cats)) { wp_set_post_cats('', $ret_id, $cats); }
	437	}
	438	}
	439	// Store ID translation for later use
	440	add_option('txpposts2wpposts',$txpposts2wpposts);
	441
	442	echo __('<p>Done! <strong>'.$count.'</strong> posts imported.<br /><br /></p>');
	443	return true;
	444	}
	445
	446	function comments2wp($comments='')
	447	{
	448	// General Housekeeping
	449	global $wpdb;
	450	$count = 0;
	451	$txpcm2wpcm = array();
	452	$postarr = get_option('txpposts2wpposts');
	453
	454	// Magic Mojo
	455	if(is_array($comments))
	456	{
	457	echo __('<p>Importing Comments...<br /><br /></p>');
	458	foreach($comments as $comment)
	459	{
	460	$count++;
	461	extract($comment);
	462
	463	// WordPressify Data
	464	$comment_ID = ltrim($discussid, '0');
	465	$comment_approved = (1 == $visible) ? 1 : 0;
	466	$name = $wpdb->escape($name);
	467	$email = $wpdb->escape($email);
	468	$web = $wpdb->escape($web);
	469	$message = $wpdb->escape($message);
	470
	471	if($cinfo = comment_exists($name, $posted))
	472	{
	473	// Update comments
	474	$ret_id = wp_update_comment(array(
	475	'comment_ID' => $cinfo,
	476	'comment_author' => $name,
	477	'comment_author_email' => $email,
	478	'comment_author_url' => $web,
	479	'comment_date' => $posted,
	480	'comment_content' => $message,
	481	'comment_approved' => $comment_approved)
	482	);
	483	}
	484	else
	485	{
	486	// Insert comments
	487	$ret_id = wp_insert_comment(array(
	488	'comment_post_ID' => $postarr[$parentid],
	489	'comment_author' => $name,
	490	'comment_author_email' => $email,
	491	'comment_author_url' => $web,
	492	'comment_author_IP' => $ip,
	493	'comment_date' => $posted,
	494	'comment_content' => $message,
	495	'comment_approved' => $comment_approved)
	496	);
	497	}
	498	$txpcm2wpcm[$comment_ID] = $ret_id;
	499	}
	500	// Store Comment ID translation for future use
	501	add_option('txpcm2wpcm', $txpcm2wpcm);
	502
	503	// Associate newly formed categories with posts
	504	get_comment_count($ret_id);
	505
	506
	507	echo __('<p>Done! <strong>'.$count.'</strong> comments imported.<br /><br /></p>');
	508	return true;
	509	}
	510	echo 'No Comments to Import!';
	511	return false;
	512	}
	513
	514	function import_categories()
	515	{
	516	// Category Import
	517	$cats = $this->get_txp_cats();
	518	$this->cat2wp($cats);
	519	add_option('txp_cats', $cats);
	520
	521
	522
	523	_e('<form action="admin.php?import=textpattern&step=2" method="post">');
	524	_e('<input type="submit" name="submit" value="Import Users" />');
	525	_e('</form>');
	526
	527	}
	528
	529	function import_users()
	530	{
	531	// User Import
	532	$users = $this->get_txp_users();
	533	$this->users2wp($users);
	534
	535	_e('<form action="admin.php?import=textpattern&step=3" method="post">');
	536	_e('<input type="submit" name="submit" value="Import Posts" />');
	537	_e('</form>');
	538	}
	539
	540	function import_posts()
	541	{
	542	// Post Import
	543	$posts = $this->get_txp_posts();
	544	$this->posts2wp($posts);
	545
	546	_e('<form action="admin.php?import=textpattern&step=4" method="post">');
	547	_e('<input type="submit" name="submit" value="Import Comments" />');
	548	_e('</form>');
	549	}
	550
	551	function import_comments()
	552	{
	553	// Comment Import
	554	$comments = $this->get_txp_comments();
	555	$this->comments2wp($comments);
	556
	557	_e('<form action="admin.php?import=textpattern&step=5" method="post">');
	558	_e('<input type="submit" name="submit" value="Import Links" />');
	559	_e('</form>');
	560	}
	561
	562	function import_links()
	563	{
	564	//Link Import
	565	$links = $this->get_txp_links();
	566	$this->links2wp($links);
	567	add_option('txp_links', $links);
	568
	569	_e('<form action="admin.php?import=textpattern&step=6" method="post">');
	570	_e('<input type="submit" name="submit" value="Finish" />');
	571	_e('</form>');
	572	}
	573
	574	function cleanup_txpimport()
	575	{
	576	delete_option('tpre');
	577	delete_option('txp_cats');
	578	delete_option('txpid2wpid');
	579	delete_option('txpcat2wpcat');
	580	delete_option('txpposts2wpposts');
	581	delete_option('txpcm2wpcm');
	582	delete_option('txplinks2wplinks');
	583	$this->tips();
	584	}
	585
	586	function tips()
	587	{
	588	echo'<p>Welcome to WordPress. We hope (and expect!) that you will find this platform incredibly rewarding! As a new WordPress user coming from Textpattern, there are some things that we would like to point out. Hopefully, they will help your transition go as smoothly as possible.</p>';
	589	echo'<h3>Users</h3>';
	590	echo'<p>You have already setup WordPress and have been assigned an administrative login and password. Forget it. You didn\'t have that login in Textpattern, why should you have it here? Instead we have taken care to import all of your users into our system. Unfortunately there is one downside. Because both WordPress and Textpattern uses a strong encryption hash with passwords, it is impossible to decrypt it and we are forced to assign temporary passwords to all your users. <strong>Every user has the same username, but their passwords are reset to password123.</strong> This includes you. So <a href="/wp-login.php">Login</a> and change it.</p>';
	591	echo'<h3>Preserving Authors</h3>';
	592	echo'<p>Secondly, we have attempted to preserve post authors. If you are the only author or contributor to your blog, then you are safe. In most cases, we are successful in this preservation endeavor. However, if we cannot ascertain the name of the writer due to discrepancies between database tables, we assign it to you, the administrative user.</p>';
	593	echo'<h3>Textile</h3>';
	594	echo'<p>Also, since you\'re coming from Textpattern, you probably have been using Textile to format your comments and posts. If this is the case, we recommend downloading and installing <a href="http://www.huddledmasses.org/2004/04/19/wordpress-plugin-textile-20/">Textile for WordPress</a>. Trust me... You\'ll want it.</p>';
	595	echo'<h3>WordPress Resources</h3>';
	596	echo'<p>Finally, there are numerous WordPress resources around the internet. Some of them are:</p>';
	597	echo'<ul>';
	598	echo'<li><a href="http://www.wordpress.org">The official WordPress site</a></li>';
	599	echo'<li><a href="http://wordpress.org/support/">The WordPress support forums</li>';
	600	echo'<li><a href="http://codex.wordpress.org">The Codex (In other words, the WordPress Bible)</a></li>';
	601	echo'</ul>';
	602	echo'<p>That\'s it! What are you waiting for? Go <a href="/wp-login.php">login</a>!</p>';
	603	}
	604
	605	function dispatch()
	606	{
	607	if (empty ($_GET['step']))
	608	$step = 0;
	609	else
	610	$step = (int) $_GET['step'];
	611
	612	$this->header();
	613
	614	switch ($step)
	615	{
	616	default:
	617	case 0 :
	618	$this->greet();
	619	break;
	620	case 1 :
	621	$this->import_categories();
	622	break;
	623	case 2 :
	624	$this->import_users();
	625	break;
	626	case 3 :
	627	$this->import_posts();
	628	break;
	629	case 4 :
	630	$this->import_comments();
	631	break;
	632	case 5 :
	633	$this->import_links();
	634	break;
	635	case 6 :
	636	$this->cleanup_txpimport();
	637	break;
	638	}
	639
	640	$this->footer();
	641	}
	642
	643	function Textpattern_Import()
	644	{
	645	// Nothing.
	646	}
	647	}
	648
	649	$txpdb = new wpdb($txpcfg['user'], $txpcfg['pass'], $txpcfg['db'], $txpcfg['host']);
	650
	651	$txp_import = new Textpattern_Import();
	652	register_importer('textpattern', 'Textpattern', __('Import posts from a Textpattern Blog'), array ($txp_import, 'dispatch'));
	653	?>

Navigation

Changeset 3228

Legend:

trunk/wp-admin/import/textpattern.php

Download in other formats: