vBulletin3::setup_globals()
Sets up the field mappings
Contents
Description Description
Source Source
File: includes/admin/converters/vBulletin3.php
public function setup_globals() { // Setup smiley URL & path $this->bbcode_parser_properties = array( 'smiley_url' => false, 'smiley_dir' => false ); /** Forum Section *****************************************************/ // Old forum id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'forumid', 'to_type' => 'forum', 'to_fieldname' => '_bbp_old_forum_id' ); // Forum parent id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'parentid', 'to_type' => 'forum', 'to_fieldname' => '_bbp_old_forum_parent_id' ); // Forum topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'threadcount', 'to_type' => 'forum', 'to_fieldname' => '_bbp_topic_count' ); // Forum reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'replycount', 'to_type' => 'forum', 'to_fieldname' => '_bbp_reply_count' ); // Forum total topic count (Includes unpublished topics, Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'threadcount', 'to_type' => 'forum', 'to_fieldname' => '_bbp_total_topic_count' ); // Forum total reply count (Includes unpublished replies, Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'replycount', 'to_type' => 'forum', 'to_fieldname' => '_bbp_total_reply_count' ); // Forum title. $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'title', 'to_type' => 'forum', 'to_fieldname' => 'post_title' ); // Forum slug (Clean name to avoid confilcts) $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'title_clean', 'to_type' => 'forum', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Forum description. $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'description', 'to_type' => 'forum', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_null' ); // Forum display order (Starts from 1) $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'displayorder', 'to_type' => 'forum', 'to_fieldname' => 'menu_order' ); // Forum type (Category = -1 or Forum > 0, Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forum', 'from_fieldname' => 'parentid', 'to_type' => 'forum', 'to_fieldname' => '_bbp_forum_type', 'callback_method' => 'callback_forum_type' ); // Forum status (Set a default value 'open', Stored in postmeta) $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => '_bbp_status', 'default' => 'open' ); // Forum dates. $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_date', 'default' => date( 'Y-m-d H:i:s' ) ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_date_gmt', 'default' => date( 'Y-m-d H:i:s' ) ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_modified', 'default' => date( 'Y-m-d H:i:s' ) ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_modified_gmt', 'default' => date( 'Y-m-d H:i:s' ) ); /** Forum Subscriptions Section ***************************************/ // Subscribed forum ID (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'subscribeforum', 'from_fieldname' => 'forumid', 'to_type' => 'forum_subscriptions', 'to_fieldname' => '_bbp_forum_subscriptions' ); // Subscribed user ID (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'subscribeforum', 'from_fieldname' => 'userid', 'to_type' => 'forum_subscriptions', 'to_fieldname' => 'user_id', 'callback_method' => 'callback_userid' ); /** Topic Section *****************************************************/ // Old topic id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'threadid', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_topic_id' ); // Topic parent forum id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'forumid', 'to_type' => 'topic', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_forumid' ); // Topic reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'replycount', 'to_type' => 'topic', 'to_fieldname' => '_bbp_reply_count', 'callback_method' => 'callback_topic_reply_count' ); // Topic total reply count (Includes unpublished replies, Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'replycount', 'to_type' => 'topic', 'to_fieldname' => '_bbp_total_reply_count', 'callback_method' => 'callback_topic_reply_count' ); // Topic author. $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'postuserid', 'to_type' => 'topic', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Topic author name (Stored in postmeta as _bbp_anonymous_name) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'postusername', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_topic_author_name_id' ); // Is the topic anonymous (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'postuserid', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_is_topic_anonymous_id', 'callback_method' => 'callback_check_anonymous' ); // Topic Author ip (Stored in postmeta) // Note: We join the 'post' table because 'thread' table does not include topic content. $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'ipaddress', 'join_tablename' => 'thread', 'join_type' => 'INNER', 'join_expression' => 'USING (threadid) WHERE post.parentid = 0', 'to_type' => 'topic', 'to_fieldname' => '_bbp_author_ip' ); // Topic title. $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'title', 'to_type' => 'topic', 'to_fieldname' => 'post_title' ); // Topic slug (Clean name to avoid conflicts) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'title', 'to_type' => 'topic', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Topic parent forum id (If no parent, then 0) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'forumid', 'to_type' => 'topic', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_forumid' ); // Topic content. // Note: We join the 'post' table because 'thread' table does not include topic content. $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'pagetext', 'join_tablename' => 'thread', 'join_type' => 'INNER', 'join_expression' => 'USING (threadid) WHERE post.parentid = 0', 'to_type' => 'topic', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Topic status (Open or Closed) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'open', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_closed_status_id', 'callback_method' => 'callback_topic_status' ); // Sticky status (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'sticky', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_sticky_status_id', 'callback_method' => 'callback_sticky_status' ); // Topic dates. $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'dateline', 'to_type' => 'topic', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'dateline', 'to_type' => 'topic', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'dateline', 'to_type' => 'topic', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'dateline', 'to_type' => 'topic', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'thread', 'from_fieldname' => 'lastpost', 'to_type' => 'topic', 'to_fieldname' => '_bbp_last_active_time', 'callback_method' => 'callback_datetime' ); /** Tags Section ******************************************************/ // Topic id. $this->field_map[] = array( 'from_tablename' => 'tagthread', 'from_fieldname' => 'threadid', 'to_type' => 'tags', 'to_fieldname' => 'objectid', 'callback_method' => 'callback_topicid' ); // Taxonomy ID. $this->field_map[] = array( 'from_tablename' => 'tagthread', 'from_fieldname' => 'tagid', 'to_type' => 'tags', 'to_fieldname' => 'taxonomy' ); // Term text. $this->field_map[] = array( 'from_tablename' => 'tag', 'from_fieldname' => 'tagtext', 'join_tablename' => 'tagthread', 'join_type' => 'INNER', 'join_expression' => 'USING (tagid)', 'to_type' => 'tags', 'to_fieldname' => 'name' ); // Term slug. $this->field_map[] = array( 'from_tablename' => 'tag', 'from_fieldname' => 'tagtext', 'join_tablename' => 'tagthread', 'join_type' => 'INNER', 'join_expression' => 'USING (tagid)', 'to_type' => 'tags', 'to_fieldname' => 'slug', 'callback_method' => 'callback_slug' ); /** Topic Subscriptions Section ***************************************/ // Subscribed topic ID (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'subscribethread', 'from_fieldname' => 'threadid', 'to_type' => 'topic_subscriptions', 'to_fieldname' => '_bbp_subscriptions' ); // Subscribed user ID (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'subscribethread', 'from_fieldname' => 'userid', 'to_type' => 'topic_subscriptions', 'to_fieldname' => 'user_id', 'callback_method' => 'callback_userid' ); /** Reply Section *****************************************************/ // Old reply id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'postid', 'to_type' => 'reply', 'to_fieldname' => '_bbp_old_reply_id' ); // Reply parent forum id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'threadid', 'from_expression' => 'WHERE parentid != 0', 'to_type' => 'reply', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_topicid_to_forumid' ); // Reply parent topic id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'threadid', 'to_type' => 'reply', 'to_fieldname' => '_bbp_topic_id', 'callback_method' => 'callback_topicid' ); // Reply author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'ipaddress', 'to_type' => 'reply', 'to_fieldname' => '_bbp_author_ip' ); // Reply author. $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'userid', 'to_type' => 'reply', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Reply author name (Stored in postmeta as _bbp_anonymous_name) $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'username', 'to_type' => 'reply', 'to_fieldname' => '_bbp_old_reply_author_name_id' ); // Is the reply anonymous (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'userid', 'to_type' => 'reply', 'to_fieldname' => '_bbp_old_is_reply_anonymous_id', 'callback_method' => 'callback_check_anonymous' ); // Reply content. $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'pagetext', 'to_type' => 'reply', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Reply parent topic id (If no parent, then 0) $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'threadid', 'to_type' => 'reply', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_topicid' ); // Reply dates. $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'dateline', 'to_type' => 'reply', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'dateline', 'to_type' => 'reply', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'dateline', 'to_type' => 'reply', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'post', 'from_fieldname' => 'dateline', 'to_type' => 'reply', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); /** User Section ******************************************************/ // Store old user id (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'userid', 'to_type' => 'user', 'to_fieldname' => '_bbp_old_user_id' ); // Store old user password (Stored in usermeta serialized with salt) $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'password', 'to_type' => 'user', 'to_fieldname' => '_bbp_password', 'callback_method' => 'callback_savepass' ); // Store old user salt (This is only used for the SELECT row info for the above password save) $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'salt', 'to_type' => 'user', 'to_fieldname' => '' ); // User password verify class (Stored in usermeta for verifying password) $this->field_map[] = array( 'to_type' => 'user', 'to_fieldname' => '_bbp_class', 'default' => 'vBulletin3' ); // User name. $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'username', 'to_type' => 'user', 'to_fieldname' => 'user_login' ); // User email. $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'email', 'to_type' => 'user', 'to_fieldname' => 'user_email' ); // User homepage. $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'homepage', 'to_type' => 'user', 'to_fieldname' => 'user_url' ); // User registered. $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'joindate', 'to_type' => 'user', 'to_fieldname' => 'user_registered', 'callback_method' => 'callback_datetime' ); // User AIM (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'aim', 'to_type' => 'user', 'to_fieldname' => '_bbp_vbulletin3_user_aim' ); // User Yahoo (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'yahoo', 'to_type' => 'user', 'to_fieldname' => '_bbp_vbulletin3_user_yim' ); // User ICQ (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'icq', 'to_type' => 'user', 'to_fieldname' => '_bbp_vbulletin3_user_icq' ); // User MSN (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'msn', 'to_type' => 'user', 'to_fieldname' => '_bbp_vbulletin3_user_msn' ); // User Skype (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'user', 'from_fieldname' => 'skype', 'to_type' => 'user', 'to_fieldname' => '_bbp_vbulletin3_user_skype' ); }