This repository has been archived by the owner on Oct 24, 2018. It is now read-only.
forked from robinflyhigh/Drupal2Wordpress
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Drupal2Wordpress.php
190 lines (156 loc) · 11.3 KB
/
Drupal2Wordpress.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
<?php
require_once("php-mysql.php");
//Database Host Name
$DB_HOSTNAME = 'localhost';
//Wordpress Database Name, Username and Password
$DB_WP_USERNAME = 'user';
$DB_WP_PASSWORD = 'pass';
$DB_WORDPRESS = 'database';
//Drupal Database Name, Username and Password
$DB_DP_USERNAME = 'user';
$DB_DP_PASSWORD = 'pass';
$DB_DRUPAL = 'database';
//Table Prefix
$DB_WORDPRESS_PREFIX = 'wp_';
$DB_DRUPAL_PREFIX = '';
//Create Connection Array for Drupal and Wordpress
$drupal_connection = array("host" => "localhost","username" => $DB_DP_USERNAME,"password" => $DB_DP_PASSWORD,"database" => $DB_DRUPAL);
$wordpress_connection = array("host" => "localhost","username" => $DB_WP_USERNAME,"password" => $DB_WP_PASSWORD,"database" => $DB_WORDPRESS);
//Create Connection for Drupal and Wordpress
$dc = new DB($drupal_connection);
$wc = new DB($wordpress_connection);
//Check if database connection is fine
$dcheck = $dc->check();
if (!$dcheck){
echo "This $DB_DRUPAL service is AVAILABLE"; die();
}
$wcheck = $wc->check();
if (!$wcheck){
echo "This $DB_WORDPRESS service is AVAILABLE"; die();
}
message('Database Connection successful');
//Empty the current worpdress Tables
$wc->query("TRUNCATE TABLE ".$DB_WORDPRESS_PREFIX."comments");
$wc->query("TRUNCATE TABLE ".$DB_WORDPRESS_PREFIX."links");
$wc->query("TRUNCATE TABLE ".$DB_WORDPRESS_PREFIX."postmeta");
$wc->query("TRUNCATE TABLE ".$DB_WORDPRESS_PREFIX."posts");
$wc->query("TRUNCATE TABLE ".$DB_WORDPRESS_PREFIX."term_relationships");
$wc->query("TRUNCATE TABLE ".$DB_WORDPRESS_PREFIX."term_taxonomy");
$wc->query("TRUNCATE TABLE ".$DB_WORDPRESS_PREFIX."terms");
message('Wordpress Table Truncated');
//Get all drupal Tags and add it into worpdress terms table
$drupal_tags = $dc->results("SELECT DISTINCT d.tid, d.name, REPLACE(LOWER(d.name), ' ', '-') AS slug FROM ".$DB_DRUPAL_PREFIX."term_data d INNER JOIN ".$DB_DRUPAL_PREFIX."term_hierarchy h ON (d.tid = h.tid) ORDER BY d.tid ASC");
foreach($drupal_tags as $dt)
{
$wc->query("REPLACE INTO ".$DB_WORDPRESS_PREFIX."terms (term_id, name, slug) VALUES ('%s','%s','%s')", $dt['tid'], $dt['name'], $dt['slug']);
}
//Update worpdress term_taxonomy table
$drupal_taxonomy = $dc->results("SELECT DISTINCT d.tid AS term_id, 'post_tag' AS post_tag, d.description AS description, h.parent AS parent FROM ".$DB_DRUPAL_PREFIX."term_data d INNER JOIN ".$DB_DRUPAL_PREFIX."term_hierarchy h ON (d.tid = h.tid) ORDER BY 'term_id' ASC");
foreach($drupal_taxonomy as $dt)
{
$wc->query("INSERT INTO ".$DB_WORDPRESS_PREFIX."term_taxonomy (term_id, taxonomy, description, parent) VALUES ('%s','%s','%s','%s')", $dt['term_id'], $dt['post_tag'], $dt['description'], $dt['parent']);
}
message('Tags Updated');
//Get all post from Drupal and add it into wordpress posts table
$drupal_posts = $dc->results("SELECT DISTINCT n.nid AS id, n.uid AS post_author, FROM_UNIXTIME(n.created) AS post_date, r.body AS post_content, n.title AS post_title, r.teaser AS post_excerpt, n.type AS post_type, IF(n.status = 1, 'publish', 'private') AS post_status FROM ".$DB_DRUPAL_PREFIX."node n, ".$DB_DRUPAL_PREFIX."node_revisions r WHERE (n.vid = r.vid)");
foreach($drupal_posts as $dp)
{
$wc->query("INSERT INTO ".$DB_WORDPRESS_PREFIX."posts (id, post_author, post_date, post_content, post_title, post_excerpt, post_type, post_status) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s')", $dp['id'], $dp['post_author'], $dp['post_date'], $dp['post_content'], $dp['post_title'], $dp['post_excerpt'], $dp['post_type'], $dp['post_status']);
}
message('Posts Updated');
//Add relationship for post and tags
$drupal_post_tags = $dc->results("SELECT DISTINCT node.nid, term_data.tid FROM (".$DB_DRUPAL_PREFIX."term_node term_node INNER JOIN ".$DB_DRUPAL_PREFIX."term_data term_data ON (term_node.tid = term_data.tid)) INNER JOIN ".$DB_DRUPAL_PREFIX."node node ON (node.nid = term_node.nid)");
foreach($drupal_post_tags as $dpt)
{
$wordpress_term_tax = $wc->row("SELECT DISTINCT term_taxonomy.term_taxonomy_id FROM ".$DB_WORDPRESS_PREFIX."term_taxonomy term_taxonomy WHERE (term_taxonomy.term_id = ".$dpt['tid'].")");
$wc->query("INSERT INTO ".$DB_WORDPRESS_PREFIX."term_relationships (object_id, term_taxonomy_id) VALUES ('%s','%s')", $dpt['nid'], $wordpress_term_tax['term_taxonomy_id']);
}
message('Tags & Posts Relationships Updated');
//Update the post type for worpdress
$wc->query("UPDATE ".$DB_WORDPRESS_PREFIX."posts SET post_type = 'post' WHERE post_type IN ('blog')");
message('Posted Type Updated');
//Count the total tags
$wc->query("UPDATE ".$DB_WORDPRESS_PREFIX."term_taxonomy tt SET count = ( SELECT COUNT(tr.object_id) FROM ".$DB_WORDPRESS_PREFIX."term_relationships tr WHERE tr.term_taxonomy_id = tt.term_taxonomy_id )");
message('Tags Count Updated');
//Get the url alias from drupal and use it for the Post Slug
$drupal_url = $dc->results("SELECT url_alias.src, url_alias.dst FROM ".$DB_DRUPAL_PREFIX."url_alias url_alias WHERE (url_alias.src LIKE 'node%')");
foreach($drupal_url as $du)
{
$update = $wc->query("UPDATE ".$DB_WORDPRESS_PREFIX."posts SET post_name = '%s' WHERE ID = '%s'",$du['dst'],str_replace('node/','',$du['src']));
}
message('URL Alias to Slug Updated');
//Move the comments and their replies - 1 Level
$drupal_comments = $dc->results("SELECT DISTINCT c.cid AS comment_ID, c.nid AS comment_post_ID, c.name AS comment_author, c.mail AS comment_author_email, c.homepage AS comment_author_url, c.hostname AS comment_author_IP, FROM_UNIXTIME(c.created) AS comment_date, field_data_comment_body.comment_body_value AS comment_content FROM ".$DB_DRUPAL_PREFIX."comment c INNER JOIN ".$DB_DRUPAL_PREFIX."field_data_comment_body field_data_comment_body ON (c.cid = field_data_comment_body.entity_id) WHERE (c.pid = 0)");
foreach($drupal_comments as $duc)
{
$insert = $wc->query("INSERT INTO ".$DB_WORDPRESS_PREFIX."comments (comment_ID,comment_post_ID ,comment_author ,comment_author_email ,comment_author_url ,comment_author_IP ,comment_date ,comment_date_gmt, comment_content ,comment_approved,comment_parent)VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",$duc['comment_ID'],$duc['comment_post_ID'],$duc['comment_author'],$duc['comment_author_email'],$duc['comment_author_url'],$duc['comment_author_IP'],$duc['comment_date'],$duc['comment_date'],$duc['comment_content'],'1','0');
$drupal_comments_level1 = $dc->results("SELECT DISTINCT c.cid AS comment_ID, c.nid AS comment_post_ID, c.name AS comment_author, c.mail AS comment_author_email, c.homepage AS comment_author_url, c.hostname AS comment_author_IP, FROM_UNIXTIME(c.created) AS comment_date, field_data_comment_body.comment_body_value AS comment_content FROM ".$DB_DRUPAL_PREFIX."comment c INNER JOIN ".$DB_DRUPAL_PREFIX."field_data_comment_body field_data_comment_body ON (c.cid = field_data_comment_body.entity_id) WHERE (c.pid = ".$duc['comment_ID'].")");
foreach($drupal_comments_level1 as $dcl1)
{
$wc->query("INSERT INTO ".$DB_WORDPRESS_PREFIX."comments (comment_ID,comment_post_ID ,comment_author ,comment_author_email ,comment_author_url ,comment_author_IP ,comment_date ,comment_date_gmt, comment_content ,comment_approved,comment_parent)VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",$dcl1['comment_ID'],$dcl1['comment_post_ID'],$dcl1['comment_author'],$dcl1['comment_author_email'],$dcl1['comment_author_url'],$dcl1['comment_author_IP'],$dcl1['comment_date'],$dcl1['comment_date'],$dcl1['comment_content'],'1',$duc['comment_ID']);
}
}
message('Comments Updated - 1 Level');
//Update Comment Counts in Wordpress
$wc->query("UPDATE ".$DB_WORDPRESS_PREFIX."posts SET comment_count = ( SELECT COUNT(comment_post_id) FROM ".$DB_WORDPRESS_PREFIX."comments WHERE ".$DB_WORDPRESS_PREFIX."posts.id = ".$DB_WORDPRESS_PREFIX."comments.comment_post_id )");
//Get all files in content_field_images from Drupal and add it into wordpress posts table, then add the featured image to postmeta
$drupal_files = $dc->results("SELECT DISTINCT f.fid, f.uid AS post_author, FROM_UNIXTIME(f.timestamp) AS post_date, f.filename, f.filepath, f.filemime AS post_mime_type, cfp.nid, cfp.vid, n.vid FROM ".$DB_DRUPAL_PREFIX."files f, ".$DB_DRUPAL_PREFIX."content_field_photo cfp, ".$DB_DRUPAL_PREFIX."node n WHERE (f.fid = cfp.field_photo_fid AND cfp.vid = n.vid)");
foreach($drupal_files as $dp)
{
$wc->query("INSERT INTO ".$DB_WORDPRESS_PREFIX."posts (post_author, post_date, post_title, post_name, post_parent, post_type, post_mime_type, post_status) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s')", 1, $dp['post_date'], $dp['filename'], $dp['filepath'], $dp['nid'], 'attachment', $dp['post_mime_type'], 'inherit');
$post_id = $wc->row("SELECT ID FROM ".$DB_WORDPRESS_PREFIX."posts WHERE post_name = '%s'", $dp['filepath']);
$wc->query("INSERT INTO ".$DB_WORDPRESS_PREFIX."postmeta (post_id, meta_key, meta_value) VALUES ('%s','%s','%s')", $dp['nid'], '_thumbnail_id', $post_id['ID']);
$wc->query("INSERT INTO ".$DB_WORDPRESS_PREFIX."postmeta (post_id, meta_key, meta_value) VALUES ('%s','%s','%s')", $post_id['ID'], '_wp_attached_file', $dp['filepath']);
}
// Try and correct the above because wordpress lies about images in the latest revision for a node
$drupal_files = $dc->results("SELECT DISTINCT f.fid, f.uid AS post_author, FROM_UNIXTIME(f.timestamp) AS post_date, f.filename, f.filepath, f.filemime AS post_mime_type, ctb.field_photo_square_fid, n.nid, n.vid FROM ".$DB_DRUPAL_PREFIX."files f, ".$DB_DRUPAL_PREFIX."content_type_blog ctb, ".$DB_DRUPAL_PREFIX."node n WHERE (f.fid = ctb.field_photo_square_fid AND ctb.vid = n.vid)");
foreach($drupal_files as $dp)
{
$post_id = $wc->row("SELECT ID FROM ".$DB_WORDPRESS_PREFIX."posts WHERE post_name = '%s'", $dp['filepath']);
$wc->query("UPDATE ".$DB_WORDPRESS_PREFIX."posts SET post_name = '%s' WHERE ID = '%s'", $dp['filepath'], $post_id['ID']);
$wc->query("UPDATE ".$DB_WORDPRESS_PREFIX."postmeta SET meta_value = '%s' WHERE post_id = '%s'", $dp['filepath'], $post_id['ID']);
}
// Make the links to files URL encoded so they are actually accessible when full of nasty unsanitized characters we don't want to rename
$wordpress_files = $wc->results("SELECT post_id, meta_value FROM ".$DB_WORDPRESS_PREFIX."postmeta WHERE meta_key = '_wp_attached_file'");
foreach($wordpress_files as $wf)
{
$path = preg_replace('/%2F/', '/', rawurlencode($wf['meta_value']));
$wc->query("UPDATE ".$DB_WORDPRESS_PREFIX."postmeta SET meta_value = '%s' WHERE post_id = '%s' AND meta_key = '_wp_attached_file'", $path, $wf['post_id']);
}
message('Cheers !!');
/*
TO DO - Skipped coz didnt have much comment and Users, if you need then share you database and shall work upon and fix it for you.
1.) Update Users/Authors
*/
//Preformat the Object for Debuggin Purpose
function po($obj){
echo "<pre>";
print_r($obj);
echo "</pre>";
}
function message($msg){
echo "<hr>$msg</hr>";
func_flush();
}
function func_flush($s = NULL)
{
if (!is_null($s))
echo $s;
if (preg_match("/Apache(.*)Win/S", getenv('SERVER_SOFTWARE')))
echo str_repeat(" ", 2500);
elseif (preg_match("/(.*)MSIE(.*)\)$/S", getenv('HTTP_USER_AGENT')))
echo str_repeat(" ", 256);
if (function_exists('ob_flush'))
{
// for PHP >= 4.2.0
@ob_flush();
}
else
{
// for PHP < 4.2.0
if (ob_get_length() !== FALSE)
ob_end_flush();
}
flush();
}
?>