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
|
<?php
// Just a few phpBB migration queries for now....
/*
-- POSTGRESQL-centric initial SQL
INSERT INTO liberty_content ( content_id, title, data, content_type_guid, format_guid, content_status_id, user_id, modifier_user_id, created, last_modified ) (SELECT nextval('liberty_content_id_seq'), forum_name, forum_desc, 'bitboard', 'bbcode', 50, 1, 1, CURRENT_TIMESTAMP::abstime::int::bigint, CURRENT_TIMESTAMP::abstime::int::bigint FROM phpbb.forums);
INSERT INTO boards (board_id, content_id) (SELECT forum_id, content_id FROM phpbb.forums INNER JOIN liberty_content ON (content_type_guid='bitboard' AND forum_name=title) );
ALTER SEQUENCE boards_board_id_seq RESTART WITH 6;
-- OR: INSERT INTO boards (board_id, content_id) (SELECT nextval('boards_board_id_seq'), content_id FROM liberty_content WHERE content_type_guid='bitboard');
INSERT INTO boards_map (board_content_id, topic_content_id) (SELECT content_id, content_id FROM phpbb.forums INNER JOIN liberty_content ON (content_type_guid='bitboard' AND forum_name=title) );
*/
require_once( '../../kernel/includes/setup_inc.php' );
$gBitSystem->verifyPermission( 'p_admin' );
$_SESSION['captcha_verified'] = true;
global $db;
if( file_exists( PHPBB_PKG_PATH.'config.php' ) ) {
require_once( PHPBB_PKG_PATH.'config.php' );
}
chdir( PHPBB_PKG_PATH );
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/bbcode.'.$phpEx);
migrate_phpbb();
function migrate_phpbb() {
global $gBitDb, $gBitSystem, $gLibertySystem, $db;
if( !$gLibertySystem->isPluginActive( 'bbcode' ) ) {
$gLibertySystem->setActivePlugin( 'bbcode' );
$gLibertySystem->scanAllPlugins();
if( !class_exists( 'HTML_BBCodeParser' ) ) {
print( "bbcode format plugin is not active. make sure you have installed Pear Text_Wiki_BBCode with: <br/><code>pear install Text_Wiki_BBCode-alpha</code>" ); die;
}
}
require_once( LIBERTY_PKG_PATH.'plugins/format.bithtml.php' );
if( ini_get( 'max_execution_time' ) < 300 ) {
print "Your max_execution_time in your php.ini is set to ". ini_get( 'max_execution_time' ) ." seconds. We recommend you increase that.";
}
if( empty( $_POST['Migrate'] ) ) {
print '<form method="POST"><input type="submit" name="Migrate" value="Migrate"/></form>';
die;
}
$gBitDb->StartTrans();
if( $forumList = $gBitDb->getAssoc( "SELECT `forum_id`,`forum_name`, `forum_desc`,`content_id` FROM " . FORUMS_TABLE . " bbf LEFT JOIN `".BIT_DB_PREFIX."liberty_content` lc ON (lc.`content_type_guid`='bitboard' AND bbf.`forum_name`=lc.`title`) ORDER BY bbf.forum_id" ) ) {
vd( $forumList ); flush();
foreach( array_keys( $forumList ) as $forumId ) {
print "Migrating forum $forumId<br/>\n"; flush();
if( empty( $forumList[$forumId]['content_id'] ) ) {
$forumStore = [];
$forumStore['user_id'] = ROOT_USER_ID;
$forumStore['title'] = $forumList[$forumId]['forum_name'];
$forumStore['edit'] = $forumList[$forumId]['forum_desc'];
$forumStore['migrate_board_id'] = $forumId;
$forumStore['format_guid'] = 'bbcode';
$newBoard = new BitBoard();
if( $newBoard->store( $forumStore ) ) {
$contentId = $newBoard->mContentId;
if( $gBitSystem->isPackageActive( 'pigeonholes' ) ) {
// add board to pigeonhole category that should already be created...
}
} else {
vd( $newBoard->mErrors );
}
} else {
$contentId = $forumList[$forumId]['content_id'];
}
if( !empty( $contentId ) ) {
migrate_phpbb_forum( $forumId, $contentId );
} else {
vd( "NO content_id for forum $forumId" );
}
}
}
$gBitDb->CompleteTrans();
}
function migrate_phpbb_forum( $pForumId, $pForumContentId ) {
global $db, $gBitDb;
$sql = "SELECT * FROM " . TOPICS_TABLE . " bbt
INNER JOIN " . POSTS_TABLE . " bbp ON(bbt.topic_first_post_id=bbp.post_id)
INNER JOIN " . POSTS_TEXT_TABLE . " bbpt ON(bbpt.post_id=bbp.post_id)
WHERE bbt.forum_id=$pForumId
ORDER BY bbt.topic_id";
if ( !($result = $db->sql_query($sql)) ) {
message_die(GENERAL_ERROR, "Could not obtain topic/post information.", '', __LINE__, __FILE__, $sql);
}
$gBitDb->StartTrans();
while ( $row = $db->sql_fetchrow($result) ) {
$commentHash = [];
$commentHash['root_id'] = $pForumContentId;
$commentHash['parent_id'] = $pForumContentId;
$commentHash['anon_name'] = $row['post_username'];
$commentHash['title'] = $row['post_subject'];
$commentHash['edit'] = $row['post_text'];
$commentHash['format_guid'] = 'bbcode';
$commentHash['created'] = $row['post_time'];
$commentHash['last_modified'] = !empty( $row['post_edit_time'] ) ? $row['post_edit_time'] : $row['post_time'];
$commentHash['user_id'] = $row['poster_id'];
$commentHash['modifier_user_id'] = $row['poster_id'];
$commentHash['ip'] = decode_ip( $row['poster_ip'] );
$rootComment = new LibertyComment();
print "Migrating Topic $row[topic_id]<br/>\n";
if( $rootComment->storeComment( $commentHash ) ) {
print "Migrating Post $row[post_id]<br/>\n"; flush();
$topicHash['root_id'] = $rootComment->mContentId;
$topicHash['is_moved'] = $row['topic_moved_id'];
$topicHash['is_sticky'] = !empty( $row['topic_type'] ) ? '1' : null;
$topicHash['is_moved'] = ($row['topic_status'] == 2 ? '1' : null);
$topicHash['migrate_topic_id'] = $row['topic_id'];
$rootTopic = new BitBoardTopic( $rootComment->mContentId );
$rootTopic->store( $topicHash );
migrate_phpbb_topic( $row['topic_id'], $rootComment );
} else {
vd( $row );
vd( $commentHash );
vd( $rootComment->mErrors );
die;
}
}
$gBitDb->CompleteTrans();
$db->sql_freeresult($result);
}
function migrate_phpbb_topic( $pTopicId, &$pRootComment ) {
global $db;
$sql = "SELECT bbp.*, bbpt.* FROM " . POSTS_TABLE . " bbp
INNER JOIN " . POSTS_TEXT_TABLE . " bbpt ON(bbpt.post_id=bbp.post_id)
INNER JOIN " . TOPICS_TABLE . " bbt ON(bbt.topic_id=bbp.topic_id)
WHERE bbp.topic_id=$pTopicId AND bbp.post_id != bbt.topic_first_post_id
ORDER BY bbp.post_time ";
if ( !($result = $db->sql_query($sql)) ) {
message_die(GENERAL_ERROR, "Could not obtain topic/post information.", '', __LINE__, __FILE__, $sql);
}
while ( $row = $db->sql_fetchrow($result) ) {
print "Migrating Post $row[post_id]<br/>\n";
$commentHash = [];
$commentHash['root_id'] = $pRootComment->getField( 'root_id' );
$commentHash['parent_id'] = $pRootComment->getField( 'content_id' );
$commentHash['anon_name'] = $row['post_username'];
$commentHash['title'] = $row['post_subject'];
$commentHash['edit'] = $row['post_text'];
$commentHash['format_guid'] = 'bbcode';
$commentHash['created'] = $row['post_time'];
$commentHash['last_modified'] = $row['post_edit_time'];
$commentHash['user_id'] = $row['poster_id'];
$commentHash['modifier_user_id'] = $row['poster_id'];
$commentHash['ip'] = decode_ip( $row['poster_ip'] );
$newComment = new LibertyComment();
if( $newComment->storeComment( $commentHash ) ) {
$postHash['migrate_post_id'] = $row['post_id'];
$newPost = new BitBoardPost( $newComment->mCommentId );
$newPost->store( $postHash );
} else {
vd( $row );
vd( $commentHash );
vd( $newComment->mErrors );
die;
}
}
}
?>
|
