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)
{
$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)
{
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)
{
global $db;
static $field_info;
if (!isset($field_info)) {
// Get columns so we avoid any 'unknown column' errors
$field_info = $db->show_fields_from("forums");
}
$insert_data = array();
foreach ($field_info as $key => $field) {
if ($field['Extra'] == 'auto_increment') {
if ($db->type != "sqlite") {
$insert_data[$field['Field']] = '';
}
continue;
}
if (isset($data[$field['Field']])) {
$insert_data[$field['Field']] = $data[$field['Field']];
}
}
// MyBB 1.6 values
$insert_data['import_fid'] = $data['fid'];
$insert_data['import_pid'] = $data['pid'];
$insert_data['description'] = encode_to_utf8($insert_data['description'], "forums", "forums");
// This value NEEDS to be here for the cleanup() to work
$insert_data['pid'] = 0;
return $insert_data;
}
function convert_data($data)
{
global $db;
static $field_info;
if (!isset($field_info)) {
// Get columns so we avoid any 'unknown column' errors
$field_info = $db->show_fields_from("posts");
}
$insert_data = array();
foreach ($field_info as $key => $field) {
if ($field['Extra'] == 'auto_increment') {
if ($db->type != "sqlite") {
$insert_data[$field['Field']] = '';
}
continue;
}
if (isset($data[$field['Field']])) {
$insert_data[$field['Field']] = $data[$field['Field']];
}
}
// MyBB 1.6 values
$insert_data['import_pid'] = $data['pid'];
$insert_data['tid'] = $this->get_import->tid($data['tid']);
$insert_data['fid'] = $this->get_import->fid($data['fid']);
$insert_data['uid'] = $this->get_import->uid($data['uid']);
$insert_data['username'] = $this->get_import->username($data['uid']);
$insert_data['subject'] = encode_to_utf8($data['subject'], "posts", "posts");
$insert_data['message'] = encode_to_utf8($data['message'], "posts", "posts");
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// phpBB 2 values
$insert_data['import_tid'] = $data['topic_id'];
$insert_data['sticky'] = $data['topic_type'];
$insert_data['fid'] = $this->get_import->fid_f($data['forum_id']);
$insert_data['import_firstpost'] = $data['topic_first_post_id'];
$insert_data['dateline'] = $data['topic_time'];
$insert_data['subject'] = encode_to_utf8(utf8_unhtmlentities($data['topic_title']), "topics", "threads");
$insert_data['uid'] = $this->get_import->uid($data['topic_poster']);
$insert_data['import_uid'] = $data['topic_poster'];
$insert_data['views'] = $data['topic_views'];
$insert_data['closed'] = $data['topic_status'];
if ($insert_data['closed'] == "no") {
$insert_data['closed'] = '';
}
// Shadow topic?
if ($insert_data['closed'] == 2) {
$insert_data['closed'] = 0;
}
if ($data['topic_moved_id']) {
$insert_data['closed'] .= "|" . $this->get_import->tid($data['topic_moved_id']);
}
// phpBB 2 has a sticky value of '2' which stands for announcement threads. Our announcements system is seperate.
if ($insert_data['sticky'] > 1) {
$insert_data['sticky'] = 1;
}
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// Invision Power Board 2 values
$insert_data['import_pmid'] = $data['msg_id'];
$insert_data['uid'] = $this->get_import->uid($data['msg_author_id']);
$insert_data['fromid'] = $this->get_import->uid($data['mt_from_id']);
$insert_data['toid'] = $this->get_import->uid($data['mt_to_id']);
$touserarray = explode('<br />', $data['msg_cc_users']);
// Rebuild the recipients array
$recipients = array();
foreach ($touserarray as $key => $to) {
$username = $this->get_username($to);
$recipients['to'][] = $this->get_import->username($username['id']);
}
$insert_data['recipients'] = serialize($recipients);
if ($data['mt_vid_folder'] == 'sent') {
$insert_data['folder'] = 2;
} elseif ($data['mt_vid_folder'] == 'unsent') {
$insert_data['folder'] = 3;
} else {
$insert_data['folder'] = 1;
}
$insert_data['subject'] = encode_to_utf8($data['mt_title'], "message_text", "privatemessages");
$insert_data['status'] = $data['mt_read'];
$insert_data['dateline'] = $data['mt_date'];
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['msg_post']), "message_text", "privatemessages");
$insert_data['readtime'] = $data['mt_user_read'];
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)
{
global $db;
static $field_info;
if (!isset($field_info)) {
// Get columns so we avoid any 'unknown column' errors
$field_info = $db->show_fields_from("users");
}
$insert_data = array();
foreach ($field_info as $key => $field) {
if ($field['Extra'] == 'auto_increment') {
if ($db->type != "sqlite") {
$insert_data[$field['Field']] = '';
}
continue;
}
if (isset($data[$field['Field']])) {
$insert_data[$field['Field']] = $data[$field['Field']];
}
}
// MyBB 1.6 values
$insert_data['import_uid'] = $data['uid'];
$insert_data['usergroup'] = $this->board->get_group_id($data['usergroup'], array("not_multiple" => true));
$insert_data['additionalgroups'] = str_replace($insert_data['usergroup'], '', $this->board->get_group_id($data['usergroup']));
$insert_data['username'] = encode_to_utf8($insert_data['username'], "users", "users");
$insert_data['signature'] = encode_to_utf8($data['signature'], "users", "users");
$insert_data['displaygroup'] = $this->board->get_group_id($data['displaygroup'], array("not_multiple" => true));
$insert_data['import_usergroup'] = $data['usergroup'];
$insert_data['import_additionalgroups'] = $data['additionalgroups'];
return $insert_data;
}
function convert_data($data)
{
global $db;
$insert_data = array();
$query = $this->old_db->simple_select("pm_recipients", "*", "id_pm = '{$data['id_pm']}'");
$sep = '';
while ($recip = $this->old_db->fetch_field($query, 'id_member')) {
$recip_list .= $sep . $recip;
$sep = ',';
}
$this->old_db->free_result($query);
$recip_list = explode(",", $recip_list);
// SMF values
$insert_data['pmid'] = null;
$insert_data['import_pmid'] = $data['id_pm'];
$insert_data['uid'] = $this->get_import->uid($data['id_member']);
$insert_data['fromid'] = $this->get_import->uid($data['id_member_from']);
$insert_data['toid'] = $this->get_import->uid($recip_list['0']);
$insert_data['recipients'] = serialize($recip_list);
$insert_data['folder'] = '1';
$insert_data['subject'] = encode_to_utf8($data['subject'], "personal_messages", "privatemessages");
$insert_data['status'] = $data['is_read'];
$insert_data['dateline'] = $data['msgtime'];
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert(utf8_unhtmlentities($data['body'])), "personal_messages", "privatemessages");
if ($insert_data['status'] == '1') {
$insert_data['readtime'] = TIME_NOW;
$insert_data['receipt'] = '2';
}
// Hack to work around SMF 2's way of storing multiple recipients in the db...
// NOT a very efficient way to handle this, but it works for now.
$this->insert_extra_pms($recip_list, $insert_data);
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// vBulletin 3 values
$insert_data['import_fid'] = $data['forumid'];
$insert_data['name'] = encode_to_utf8($this->fix_ampersand($data['title']), "forum", "forums");
$insert_data['description'] = encode_to_utf8($this->fix_ampersand($data['description']), "forum", "forums");
$insert_data['disporder'] = $data['displayorder'];
$insert_data['password'] = $data['password'];
if ($data['defaultsortfield'] == 'lastpost') {
$data['defaultsortfield'] = '';
}
$insert_data['defaultsortby'] = $data['defaultsortfield'];
$insert_data['defaultsortorder'] = $data['defaultsortorder'];
// We have a category
if ($data['parentid'] == '-1') {
$insert_data['type'] = 'c';
$insert_data['import_fid'] = $data['forumid'];
} else {
$insert_data['linkto'] = $data['link'];
$insert_data['type'] = 'f';
$insert_data['import_pid'] = $data['parentid'];
}
$bitwise = array('active' => 1, 'open' => 2, 'modposts' => 8, 'modthreads' => 16, 'modattachments' => 32, 'allowmycode' => 64, 'allowimgcode' => 128, 'allowhtml' => 256, 'allowsmilies' => 512, 'allowpicons' => 1024, 'allowtratings' => 2048, 'usepostcounts' => 4096, 'overridestyle' => 32768, 'showinjump' => 65536);
foreach ($bitwise as $column => $bit) {
if ($data['options'] & $bit) {
$insert_data[$column] = 1;
} else {
$insert_data[$column] = 0;
}
}
return $insert_data;
}
public function check_for_duplicates(&$user)
{
global $db, $output, $import_session;
if (!$this->total_users) {
// Count the total number of users so we can generate a unique id if we have a duplicate user
$query = $db->simple_select("users", "COUNT(*) as totalusers");
$this->total_users = $db->fetch_field($query, "totalusers");
$db->free_result($query);
}
$username = $user[$this->settings['username_column']];
$encoded_username = encode_to_utf8($user[$this->settings['username_column']], $this->settings['encode_table'], "users");
// Check for duplicate users
$where = "username='******' OR username='******'";
$query = $db->simple_select("users", "username,email,uid,postnum", $where, array('limit' => 1));
$duplicate_user = $db->fetch_array($query);
$db->free_result($query);
// Using strtolower and my_strtolower to check, instead of in the query, is exponentially faster
// If we used LOWER() function in the query the index wouldn't be used by MySQL
if (strtolower($duplicate_user['username']) == strtolower($username) || my_strtolower($duplicate_user['username']) == strtolower($encoded_username)) {
if ($user[$this->settings['email_column']] == $duplicate_user['email']) {
$output->print_progress("start");
$output->print_progress("merge_user", array('import_uid' => $user[$this->settings['progress_column']], 'duplicate_uid' => $duplicate_user['uid']));
$db->update_query("users", array('import_uid' => $user[$this->settings['progress_column']], 'postnum' => $duplicate_user['postnum'] + $user[$this->settings['postnum_column']]), "uid = '{$duplicate_user['uid']}'");
return false;
} else {
$user[$this->settings['username_column']] = $duplicate_user['username'] . "_" . $import_session['board'] . "_import" . $this->total_users;
}
}
return true;
}
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();
// 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_fid'] = $data['id'];
$insert_data['name'] = $data['name'];
$insert_data['description'] = encode_to_utf8($data['description'], "forums", "forums");
$insert_data['disporder'] = $data['position'];
$insert_data['password'] = $data['password'];
if ($data['sort_key'] == 'last_post') {
$data['sort_key'] = '';
}
$insert_data['defaultsortby'] = $data['sort_key'];
if ($data['sort_order'] == 'A-Z') {
$data['sort_order'] = 'asc';
} else {
$data['sort_order'] = 'desc';
}
$insert_data['defaultsortorder'] = $data['sort_order'];
// We have a category
if ($data['parent_id'] == '-1') {
$insert_data['type'] = 'c';
$insert_data['import_fid'] = $data['id'];
} else {
$insert_data['linkto'] = $data['redirect_url'];
$insert_data['type'] = 'f';
$insert_data['import_pid'] = $data['parent_id'];
}
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)
{
global $import_session;
$insert_data = array();
// Invision Power Board 2 values
$insert_data['import_tid'] = $data['tid'];
$insert_data['sticky'] = $data['pinned'];
$insert_data['fid'] = $this->get_import->fid($data['forum_id']);
$insert_data['import_firstpost'] = $data['topic_firstpost'];
$insert_data['dateline'] = $data['start_date'];
$insert_data['subject'] = encode_to_utf8($data['title'], "topics", "threads");
$insert_data['uid'] = $this->get_import->uid($data['starter_id']);
$insert_data['import_uid'] = $data['starter_id'];
$insert_data['views'] = $data['views'];
if ($data['state'] != 'open') {
$insert_data['closed'] = 1;
} else {
$insert_data['closed'] = '';
}
$insert_data['totalratings'] = $data['topic_rating_total'];
$insert_data['notes'] = $data['notes'];
$insert_data['visible'] = $data['approved'];
$insert_data['numratings'] = $data['topic_rating_hits'];
$pids = '';
$seperator = '';
$query = $this->old_db->simple_select("posts", "pid", "topic_id = '{$data['tid']}'");
while ($post = $this->old_db->fetch_array($query)) {
$pids .= $seperator . $post['pid'];
$seperator = ', ';
}
$this->old_db->free_result($query);
$insert_data['attachmentcount'] = '';
if ($pids != '') {
switch ($import_session['old_board_version']) {
case "2.2":
case "2.3":
if ($import_session['column_attach_rel_id'] == true) {
$query = $this->old_db->simple_select("attachments", "COUNT(*) as attach_count", "attach_rel_id IN ({$pids}) AND attach_rel_module = 'post'");
break;
}
default:
if ($import_session['column_attach_pid'] == true) {
$query = $this->old_db->simple_select("attachments", "COUNT(*) as attach_count", "attach_pid IN ({$pids})");
} else {
if ($import_session['column_attach_id'] == true) {
$query = $this->old_db->simple_select("attachments", "COUNT(*) as attach_count", "attach_id IN ({$pids})");
} else {
$query = null;
}
}
}
$insert_data['attachmentcount'] = $this->old_db->fetch_field($query, "attach_count");
$this->old_db->free_result($query);
}
$insert_data['import_poll'] = $data['poll_state'];
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_cat']);
$insert_data['name'] = encode_to_utf8(str_replace("&", "&", $data['name']), "categories", "forums");
$insert_data['disporder'] = $data['cat_order'];
$insert_data['type'] = "c";
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// punBB values
$insert_data['import_fid'] = intval($data['id']);
$insert_data['name'] = encode_to_utf8($data['cat_name'], "categories", "forums");
$insert_data['disporder'] = $data['disp_position'];
$insert_data['type'] = "c";
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// SMF values
$insert_data['import_fid'] = intval($data['ID_CAT']);
$insert_data['name'] = encode_to_utf8($this->fix_ampersand($data['name']), "categories", "forums");
$insert_data['disporder'] = $data['catOrder'];
$insert_data['type'] = "c";
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// Values from phpBB
$insert_data['import_fid'] = intval($data['cat_id']);
$insert_data['name'] = encode_to_utf8($data['cat_title'], "categories", "forums");
$insert_data['disporder'] = $data['cat_order'];
$insert_data['type'] = "c";
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// Mingle values
$insert_data['import_fid'] = intval($data['id']);
$insert_data['name'] = encode_to_utf8($data['name'], "forum_groups", "forums");
$insert_data['description'] = encode_to_utf8($this->bbcode_parser->convert($data['description']), "forum_groups", "forums");
$insert_data['disporder'] = $data['sort'];
$insert_data['type'] = "c";
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// phpBB 2 values
$insert_data['import_fid'] = intval($data['forum_id']);
$insert_data['name'] = encode_to_utf8($data['forum_name'], "forums", "forums");
$insert_data['description'] = encode_to_utf8($data['forum_desc'], "forums", "forums");
$insert_data['import_pid'] = $data['cat_id'];
$insert_data['disporder'] = $data['forum_order'];
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// vBulletin 3 values
$insert_data['usergroup'] = $this->board->get_group_id($data['usergroupid'], array("not_multiple" => true));
$insert_data['additionalgroups'] = str_replace($insert_data['usergroup'], '', $this->board->get_group_id($data['usergroupid']));
$insert_data['displaygroup'] = $this->board->get_group_id($data['usergroupid'], array("not_multiple" => true));
$insert_data['import_usergroup'] = $this->board->get_group_id($data['usergroupid'], array("original" => true));
$insert_data['import_additionalgroups'] = $this->board->get_group_id($data['usergroupid'], array("original" => true));
$insert_data['import_displaygroup'] = $data['displaygroupid'];
$insert_data['import_uid'] = $data['userid'];
$insert_data['username'] = encode_to_utf8($data['username'], "user", "users");
$insert_data['email'] = $data['email'];
$insert_data['regdate'] = $data['joindate'];
$insert_data['lastactive'] = $data['lastactivity'];
$insert_data['lastvisit'] = $data['lastvisit'];
$insert_data['website'] = $data['homepage'];
$avatar = $this->get_avatar($data['avatarid']);
if (!$avatar) {
$customavatar = $this->get_custom_avatar($data['userid']);
if (!$customavatar) {
$insert_data['avatardimensions'] = '';
$insert_data['avatar'] = '';
$insert_data['avatartype'] = '';
}
} else {
list($width, $height) = @getimagesize($avatar['avatarpath']);
$insert_data['avatardimensions'] = $width . '|' . $height;
$insert_data['avatar'] = $avatar['avatarpath'];
$insert_data['avatartype'] = 'remote';
}
$insert_data['lastpost'] = $data['lastpost'];
$data['birthday'] = trim($data['birthday']);
if (!empty($data['birthday'])) {
$insert_data['birthday'] = $data['birthday'];
}
$insert_data['icq'] = $data['icq'];
$insert_data['aim'] = $data['aim'];
$insert_data['yahoo'] = $data['yahoo'];
$insert_data['msn'] = $data['msn'];
$insert_data['timezone'] = str_replace(array('.0', '.00'), array('', ''), $insert_data['timezone']);
$insert_data['style'] = 0;
$insert_data['referrer'] = $data['referrerid'];
$insert_data['regip'] = $data['ipaddress'];
$insert_data['totalpms'] = $data['pmtotal'];
$insert_data['unreadpms'] = $data['pmunread'];
$insert_data['passwordconvert'] = $data['password'];
$insert_data['passwordconverttype'] = 'vb3';
$insert_data['passwordconvertsalt'] = $data['salt'];
$insert_data['signature'] = encode_to_utf8($this->bbcode_parser->convert($this->get_signature($data['userid'])), "user", "users");
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// Mingle Values
$insert_data['import_fid'] = intval($data['id']);
$insert_data['import_pid'] = intval($data['parent_id']);
$insert_data['name'] = encode_to_utf8($data['name'], "forum_forums", "forums");
$insert_data['description'] = encode_to_utf8($this->bbcode_parser->convert($data['description']), "forum_forums", "forums");
$insert_data['disporder'] = $data['sort'];
$insert_data['type'] = 'f';
// TODO: last post data?
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// vBulletin 3 values
$insert_data['import_eid'] = $data['eventid'];
$insert_data['name'] = encode_to_utf8($data['title'], "event", "events");
$insert_data['description'] = encode_to_utf8($this->bbcode_parser->convert($data['event']), "event", "events");
$insert_data['uid'] = $this->get_import->uid($data['userid']);
$insert_data['dateline'] = $data['dateline'];
$insert_data['starttime'] = $data['dateline_from'];
$insert_data['endtime'] = $data['dateline_to'];
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// punBB values
$insert_data['import_fid'] = intval($data['id']);
$insert_data['name'] = encode_to_utf8($data['forum_name'], "forums", "forums");
$insert_data['description'] = encode_to_utf8($data['forum_desc'], "forums", "forums");
$insert_data['import_pid'] = $data['cat_id'];
$insert_data['disporder'] = $data['disp_position'];
$insert_data['linkto'] = $data['redirect_url'];
$insert_data['lastpost'] = $data['last_post'];
$insert_data['parentlist'] = $data['cat_id'];
$insert_data['defaultsortby'] = $data['sort_by'];
return $insert_data;
}
function convert_data($data)
{
$insert_data = array();
// bbPress values
$insert_data['import_tid'] = $data['id'];
$insert_data['sticky'] = $data['status'] == 'sticky' ? 1 : 0;
$insert_data['closed'] = $data['closed'];
$insert_data['fid'] = $this->get_import->fid($data['parent_id']);
$insert_data['dateline'] = strtotime($data['date']);
$insert_data['subject'] = encode_to_utf8($this->bbcode_parser->convert_title($data['subject']), "forum_threads", "threads");
$insert_data['uid'] = $this->get_import->uid($data['starter']);
$insert_data['import_uid'] = $data['starter'];
$insert_data['views'] = $data['views'];
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;
}
