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:
pear install Text_Wiki_BBCode-alpha" ); 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 '';
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
\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]
\n";
if( $rootComment->storeComment( $commentHash ) ) {
print "Migrating Post $row[post_id]
\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]
\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;
}
}
}
?>