function convert_data($data)
{
$insert_data = array();
// phpBB 3 Values
$insert_data['import_fid'] = intval($data['forum_id']);
$insert_data['name'] = encode_to_utf8($this->fix_ampersand($data['forum_name']), "forums", "forums");
$insert_data['description'] = encode_to_utf8($this->bbcode_parser->convert($data['forum_desc']), "forums", "forums");
$insert_data['disporder'] = $data['left_id'];
$insert_data['open'] = int_to_01($data['forum_status']);
// Are there rules for this forum?
if ($data['forum_rules_link']) {
$insert_data['rules'] = $data['forum_rules_link'];
} else {
$insert_data['rules'] = $data['forum_rules'];
}
$insert_data['rulestype'] = 1;
// We have a category
if ($data['forum_type'] == '0') {
$insert_data['linkto'] = '';
$insert_data['type'] = 'c';
$insert_data['import_pid'] = $data['parent_id'];
} else {
// Is this a redirect forum?
$insert_data['linkto'] = '';
if ($data['forum_type'] == '2') {
$insert_data['linkto'] = $data['forum_link'];
}
$insert_data['type'] = 'f';
$insert_data['import_pid'] = $data['parent_id'];
}
// TODO: last post data?
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// vBulletin 3 values
$insert_data['import_tid'] = $data['threadid'];
$insert_data['sticky'] = $data['sticky'];
$insert_data['fid'] = $this->get_import->fid($data['forumid']);
$insert_data['import_firstpost'] = $data['firstpostid'];
$insert_data['dateline'] = $data['dateline'];
$insert_data['subject'] = encode_to_utf8(str_replace('"', '"', $data['title']), "thread", "threads");
$insert_data['import_poll'] = $data['pollid'];
$insert_data['uid'] = $this->get_import->uid($data['postuserid']);
$insert_data['import_uid'] = $data['postuserid'];
$insert_data['views'] = $data['views'];
$insert_data['closed'] = int_to_01($data['open']);
if ($insert_data['closed'] == 'no') {
$insert_data['closed'] = '';
}
if ($data['open'] == '10') {
$insert_data['closed'] = 'moved|' . $this->get_import->tid($data['pollid']);
}
$insert_data['totalratings'] = $data['votetotal'];
$insert_data['notes'] = $data['notes'];
$insert_data['visible'] = $data['visible'];
$insert_data['numratings'] = $data['votenum'];
$insert_data['attachmentcount'] = $data['attach'];
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// phpBB 2 values
$insert_data['pmid'] = null;
$insert_data['import_pmid'] = $data['privmsgs_id'];
$insert_data['uid'] = $this->get_import->uid($data['privmsgs_to_userid']);
$insert_data['fromid'] = $this->get_import->uid($data['privmsgs_from_userid']);
$insert_data['toid'] = $this->get_import->uid($data['privmsgs_to_userid']);
$insert_data['recipients'] = 'a:1:{s:2:"to";a:1:{i:0;s:' . strlen($insert_data['toid']) . ':"' . $insert_data['toid'] . '";}}';
$insert_data['subject'] = encode_to_utf8($data['privmsgs_subject'], "privmsgs", "privatemessages");
$insert_data['status'] = $this->get_pm_status($data['privmsgs_type']);
$insert_data['dateline'] = $data['privmsgs_date'];
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['privmsgs_text'], $data['privmsgs_bbcode_uid']), "privmsgs_text", "privatemessages");
$insert_data['includesig'] = $data['privmsgs_attach_sig'];
$insert_data['smilieoff'] = int_to_01($data['privmsgs_enable_smilies']);
if ($data['privmsgs_type'] != 1) {
$insert_data['readtime'] = $insert_data['dateline'];
} else {
$insert_data['readtime'] = 0;
}
if ($data['privmsgs_type'] != 2) {
$insert_data['folder'] = 1;
} else {
$insert_data['folder'] = 2;
}
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// phpBB 2 values
$insert_data['import_pid'] = $data['post_id'];
$insert_data['tid'] = $this->get_import->tid($data['topic_id']);
// Check the last post for any NULL's, converted by phpBB's parser to a default topic
if ($data['post_subject'] === 'NULL') {
$data['post_subject'] = 'Welcome to phpBB 2';
}
// Get Username
$topic_poster = $this->get_user($data['poster_id']);
// Check to see if we need to inherit any post subjects from the thread
if (empty($data['post_subject'])) {
$query = $this->old_db->simple_select("topics", "topic_first_post_id, topic_title", "topic_first_post_id='{$data['post_id']}'", array('limit' => 1));
$topic = $this->old_db->fetch_array($query);
$this->old_db->free_result($query);
if ($topic['topic_first_post_id'] == $data['post_id']) {
$data['post_subject'] = 'RE: ' . $topic['topic_title'];
}
}
$insert_data['fid'] = $this->get_import->fid_f($data['forum_id']);
$insert_data['subject'] = encode_to_utf8(utf8_unhtmlentities($data['post_subject']), "posts", "posts");
$insert_data['uid'] = $this->get_import->uid($data['poster_id']);
$insert_data['import_uid'] = $data['poster_id'];
$insert_data['username'] = $this->get_import->username($data['poster_id'], $topic_poster['username']);
$insert_data['dateline'] = $data['post_time'];
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['post_text'], $data['bbcode_uid']), "posts", "posts");
$insert_data['ipaddress'] = $this->decode_ip($data['poster_ip']);
$insert_data['includesig'] = $data['enable_sig'];
$insert_data['smilieoff'] = int_to_01($data['enable_smilies']);
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// Invision Power Board 2 values
$insert_data['import_pid'] = $data['pid'];
$insert_data['tid'] = $this->get_import->tid($data['topic_id']);
$thread = $this->get_thread($data['topic_id']);
$insert_data['fid'] = $this->get_import->fid($thread['forum_id']);
$insert_data['subject'] = encode_to_utf8($thread['title'], "topics", "posts");
if ($data['queued'] == 0) {
$insert_data['visible'] = 1;
} else {
$insert_data['visible'] = 0;
}
$insert_data['uid'] = $this->get_import->uid($data['author_id']);
$insert_data['import_uid'] = $data['author_id'];
$insert_data['username'] = $this->get_import->username($insert_data['import_uid']);
$insert_data['dateline'] = $data['post_date'];
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['post']), "posts", "posts");
$insert_data['ipaddress'] = $data['ip_address'];
$insert_data['includesig'] = $data['use_sig'];
$insert_data['smilieoff'] = int_to_01($data['allowsmilie']);
$insert_data['edituid'] = $this->get_import->uid($this->get_uid_from_username($data['edit_name']));
$insert_data['edittime'] = $data['edit_time'];
$insert_data['posthash'] = $data['post_key'];
return $insert_data;
}
function convert_data($data)
{
global $db;
// vBulletin 3 values
$insert_data['import_pmid'] = $data['pmid'];
$insert_data['uid'] = $this->get_import->uid($data['userid']);
$insert_data['fromid'] = $this->get_import->uid($data['fromuserid']);
$insert_data['toid'] = $this->get_import->uid($data['touserid']);
$touserarray = unserialize($data['touserarray']);
// Rebuild the recipients array
$recipients = array();
if (is_array($touserarray['cc']) && !empty($touserarray['cc'])) {
foreach ($touserarray['cc'] as $key => $to) {
$username = $this->get_username($to);
$recipients['to'][] = $this->get_import->uid($username['userid']);
}
}
$insert_data['recipients'] = serialize($recipients);
if ($data['folderid'] == -1) {
$insert_data['folder'] = 2;
} else {
$insert_data['folder'] = 0;
}
$insert_data['subject'] = encode_to_utf8($data['subject'], "pm", "privatemessages");
$insert_data['status'] = $data['messageread'];
$insert_data['dateline'] = $data['dateline'];
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['message']), "pmtext", "privatemessages");
$insert_data['includesig'] = $data['showsignature'];
$insert_data['smilieoff'] = int_to_01($data['allowsmilie']);
if ($data['messageread'] == 1) {
$insert_data['readtime'] = time();
}
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// SMF values
$insert_data['usergroup'] = $this->board->get_group_id($data['id_group'], true, $data['is_activated']);
$insert_data['additionalgroups'] = $this->board->get_group_id($data['additional_groups']);
$insert_data['displaygroup'] = $insert_data['usergroup'];
$insert_data['import_usergroup'] = $data['id_group'];
$insert_data['import_additionalgroups'] = $data['additional_groups'];
$insert_data['import_displaygroup'] = $data['id_group'];
$insert_data['import_uid'] = $data['id_member'];
$insert_data['username'] = encode_to_utf8($data['member_name'], "members", "users");
$insert_data['email'] = $data['email_address'];
$insert_data['regdate'] = $data['date_registered'];
$insert_data['lastactive'] = $data['last_login'];
$insert_data['lastvisit'] = $data['last_login'];
$insert_data['website'] = $data['website_url'];
$insert_data['avatar'] = $data['avatar'];
list($width, $height) = @getimagesize($data['avatar']);
$insert_data['avatardimensions'] = $width . '|' . $height;
if ($insert_data['avatar'] == '') {
$insert_data['avatartype'] = "";
} else {
$insert_data['avatartype'] = 'remote';
}
$last_post = $this->get_last_post($data['id_member']);
$insert_data['lastpost'] = isset($last_post['poster_time']) ? $last_post['poster_time'] : 0;
$data['birthdate'] = trim($data['birthdate']);
if (!empty($data['birthdate'])) {
$insert_data['birthday'] = date("n-j-Y", strtotime($data['birthdate']));
}
$insert_data['icq'] = $data['icq'];
$insert_data['aim'] = $data['aim'];
$insert_data['yahoo'] = $data['yim'];
$insert_data['msn'] = $data['msn'];
$insert_data['hideemail'] = $data['hide_email'];
$insert_data['invisible'] = int_to_01($data['show_online']);
$insert_data['pmnotify'] = $data['pm_email_notify'];
$insert_data['timeformat'] = $data['time_format'];
$insert_data['timezone'] = $data['time_offset'];
$insert_data['timezone'] = str_replace(array('.0', '.00'), array('', ''), $insert_data['timezone']);
$insert_data['buddylist'] = $data['buddy_list'];
$insert_data['ignorelist'] = $data['pm_ignore_list'];
$insert_data['regip'] = $data['member_ip'];
$insert_data['timeonline'] = $data['total_time_logged_in'];
$insert_data['totalpms'] = $data['instant_messages'];
$insert_data['unreadpms'] = $data['unread_messages'];
$insert_data['signature'] = str_replace(array("[bgcolor=", "[/bgcolor]"), array("[color=", "[/color]"), preg_replace('#\\[quote author\\=(.*?) link\\=topic\\=([0-9]*).msg([0-9]*)\\#msg([0-9]*) date\\=(.*?)\\]#i', "[quote='\$1' pid='{$pid}' dateline='\$5']", encode_to_utf8($data['signature'], "members", "users")));
if ($data['passwd']) {
$insert_data['passwordconvert'] = $data['passwd'];
} else {
if ($data['password']) {
$insert_data['passwordconvert'] = $data['password'];
}
}
$insert_data['passwordconverttype'] = 'smf2';
$insert_data['salt'] = $data['password_salt'];
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// phpBB 2 values
$insert_data['usergroup'] = $this->board->get_group_id($data, array("not_multiple" => true));
$insert_data['additionalgroups'] = str_replace($insert_data['usergroup'], '', $this->board->get_group_id($data));
$insert_data['displaygroup'] = $this->board->get_group_id($data, array("not_multiple" => true));
$insert_data['import_usergroup'] = $this->board->get_group_id($data, array("not_multiple" => true, "original" => true));
$insert_data['import_additionalgroups'] = $this->board->get_group_id($data, array("original" => true));
$insert_data['import_displaygroup'] = $data['group_id'];
$insert_data['import_uid'] = $data['user_id'];
$insert_data['username'] = encode_to_utf8($data['username'], "users", "users");
$insert_data['email'] = $data['user_email'];
$insert_data['regdate'] = $data['user_regdate'];
$insert_data['lastactive'] = $data['user_lastvisit'];
$insert_data['lastvisit'] = $data['user_lastvisit'];
$insert_data['website'] = $data['user_website'];
$insert_data['avatar'] = $data['user_avatar'];
list($width, $height) = @getimagesize($data['user_avatar']);
$insert_data['avatardimensions'] = $width . '|' . $height;
if ($insert_data['avatar'] == '') {
$insert_data['avatartype'] = "";
} else {
$insert_data['avatartype'] = 'remote';
}
$last_post = $this->get_last_post($data['user_id']);
$insert_data['lastpost'] = intval($last_post['post_time']);
$insert_data['icq'] = $data['user_icq'];
$insert_data['aim'] = $data['user_aim'];
$insert_data['yahoo'] = $data['user_yim'];
$insert_data['msn'] = $data['user_msnm'];
$insert_data['hideemail'] = $data['hideEmail'];
$insert_data['invisible'] = int_to_01($data['user_allow_viewonline']);
$insert_datar['allownotices'] = $data['user_notify'];
if ($data['user_notify'] == 1) {
$subscription_method == 2;
} else {
$subscription_method = 0;
}
$insert_data['subscriptionmethod'] = $subscription_method;
$insert_data['receivepms'] = $data['user_allow_pm'];
$insert_data['pmnotice'] = $data['user_popup_pm'];
$insert_data['pmnotify'] = $data['pm_email_notify'];
$insert_data['showsigs'] = $data['user_attachsig'];
$insert_data['showavatars'] = $data['user_allowavatar'];
$insert_data['timeformat'] = $data['user_dateformat'];
$insert_data['timezone'] = $data['user_timezone'];
$insert_data['regip'] = $last_post['poster_ip'];
$insert_data['totalpms'] = $this->get_private_messages($data['user_id']);
$insert_data['unreadpms'] = $data['user_unread_privmsg'];
$insert_data['salt'] = generate_salt();
$insert_data['signature'] = encode_to_utf8(str_replace(':' . $data['user_sig_bbcode_uid'], '', utf8_unhtmlentities($data['user_sig'])), "users", "users");
$insert_data['password'] = salt_password($data['user_password'], $insert_data['salt']);
$insert_data['loginkey'] = generate_loginkey();
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// SMF values
$insert_data['import_fid'] = intval($data['ID_BOARD']);
$insert_data['name'] = encode_to_utf8($this->fix_ampersand($data['name']), "boards", "forums");
$insert_data['description'] = encode_to_utf8($this->fix_ampersand($data['description']), "boards", "forums");
if ($data['ID_PARENT']) {
$insert_data['pid'] = $this->get_import->fid_f($data['ID_PARENT']);
} else {
$insert_data['pid'] = $this->get_import->fid_c($data['ID_CAT']);
}
$insert_data['disporder'] = $data['boardOrder'];
$insert_data['usepostcounts'] = int_to_01($data['countPosts']);
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// SMF values
$insert_data['import_fid'] = intval($data['id_board']);
$insert_data['name'] = encode_to_utf8(str_replace("&", "&", $data['name']), "boards", "forums");
$insert_data['description'] = encode_to_utf8(str_replace("&", "&", $data['description']), "boards", "forums");
if ($data['id_parent']) {
$insert_data['pid'] = $this->get_import->fid_f($data['id_parent']);
} else {
$insert_data['pid'] = $this->get_import->fid_c($data['id_cat']);
}
$insert_data['disporder'] = $data['board_order'];
$insert_data['usepostcounts'] = int_to_01($data['count_posts']);
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// phpBB 3 values
$insert_data['import_pid'] = $data['post_id'];
$insert_data['tid'] = $this->get_import->tid($data['topic_id']);
$insert_data['fid'] = $this->get_import->fid($data['forum_id']);
$insert_data['subject'] = encode_to_utf8($this->bbcode_parser->convert_title($data['post_subject']), "posts", "posts");
$insert_data['uid'] = $this->get_import->uid($data['poster_id']);
$insert_data['import_uid'] = $data['poster_id'];
$insert_data['username'] = $this->get_import->username($data['poster_id']);
$insert_data['dateline'] = $data['post_time'];
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['post_text'], $data['bbcode_uid']), "posts", "posts");
$insert_data['ipaddress'] = $data['poster_ip'];
$insert_data['includesig'] = $data['enable_sig'];
$insert_data['smilieoff'] = int_to_01($data['enable_smilies']);
return $insert_data;
}
function convert_data($data)
{
global $db;
$insert_data = array();
// vBulletin 3 values
$thread = $this->get_import_tid_poll($data['pollid']);
$votes = @explode('|||', $data['votes']);
$insert_data['import_pid'] = $data['pollid'];
$insert_data['import_tid'] = $thread['import_tid'];
$insert_data['tid'] = $thread['tid'];
$insert_data['question'] = $data['question'];
$insert_data['dateline'] = $data['dateline'];
$insert_data['options'] = str_replace('|||', '||~|~||', $data['options']);
$insert_data['votes'] = str_replace('|||', '||~|~||', $data['votes']);
$insert_data['numoptions'] = $data['numberoptions'];
$insert_data['numvotes'] = count($votes);
$insert_data['timeout'] = $data['timeout'];
$insert_data['multiple'] = $data['multiple'];
$insert_data['closed'] = int_to_01($data['active']);
return $insert_data;
}
function convert_data($data)
{
global $db;
// vBulletin 3 values
$insert_data['import_pid'] = $data['postid'];
$insert_data['tid'] = $this->get_import->tid($data['threadid']);
$thread = $this->get_thread($data['threadid']);
$insert_data['fid'] = $this->get_import->fid($thread['forumid']);
$insert_data['subject'] = encode_to_utf8(str_replace('"', '"', $thread['title']), "thread", "posts");
$insert_data['visible'] = $data['visible'];
$insert_data['uid'] = $this->get_import->uid($data['userid']);
$insert_data['import_uid'] = $data['userid'];
$insert_data['username'] = $this->get_import->username($insert_data['import_uid'], $data['username']);
$insert_data['dateline'] = $data['dateline'];
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['pagetext']), "post", "posts");
$insert_data['ipaddress'] = $data['ipaddress'];
$edit = $this->get_editlog($data['postid']);
$insert_data['edituid'] = $this->get_import->uid($edit['userid']);
$insert_data['edittime'] = $edit['dateline'];
$insert_data['includesig'] = $data['showsignature'];
$insert_data['smilieoff'] = int_to_01($data['allowsmilie']);
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// phpBB 3 values
$to = explode(':', $data['to_address']);
foreach ($to as $key => $uid) {
$to[$key] = $this->get_import->uid(str_replace('u_', '', $uid));
}
$toid = $to[0];
$insert_data['import_pmid'] = $data['msg_id'];
$insert_data['uid'] = $toid;
$insert_data['fromid'] = $this->get_import->uid($data['author_id']);
$insert_data['toid'] = $toid;
$insert_data['recipients'] = serialize(array('to' => $to));
$insert_data['subject'] = encode_to_utf8($data['message_subject'], "privmsgs", "privatemessages");
$insert_data['status'] = $this->get_pm_status($data['msg_id']);
$insert_data['readtime'] = TIME_NOW;
$insert_data['dateline'] = $data['message_time'];
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['message_text'], $data['bbcode_uid']), "privmsgs", "privatemessages");
$insert_data['includesig'] = $data['enable_sig'];
$insert_data['smilieoff'] = int_to_01($data['enable_smilies']);
return $insert_data;
}
