Vanilla::setup_globals()
Sets up the field mappings
Description
Source
File: bp-forums/admin/converters/Vanilla.php
public function setup_globals() { /** Forum Section *****************************************************/ // Forum id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'CategoryID', 'from_expression' => 'WHERE Category.CategoryID > 0', 'to_type' => 'forum', 'to_fieldname' => '_bbp_forum_id' ); // Forum parent id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'ParentCategoryID', 'to_type' => 'forum', 'to_fieldname' => '_bbp_forum_parent_id', 'callback_method' => 'callback_forum_parent' ); // Forum topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'CountDiscussions', 'to_type' => 'forum', 'to_fieldname' => '_bbp_topic_count' ); // Forum reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'CountComments', 'to_type' => 'forum', 'to_fieldname' => '_bbp_reply_count' ); // Forum total topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'CountDiscussions', 'to_type' => 'forum', 'to_fieldname' => '_bbp_total_topic_count' ); // Forum total reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'CountComments', 'to_type' => 'forum', 'to_fieldname' => '_bbp_total_reply_count' ); // Forum title. $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'Name', 'to_type' => 'forum', 'to_fieldname' => 'post_title' ); // Forum slug (Clean name to avoid confilcts) $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'Name', 'to_type' => 'forum', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Forum description. $this->field_map[] = array( 'from_tablename' => 'Category', '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' => 'Category', 'from_fieldname' => 'Sort', 'to_type' => 'forum', 'to_fieldname' => 'menu_order' ); // Forum dates. $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'DateInserted', 'to_type' => 'forum', 'to_fieldname' => 'post_date', ); $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'DateInserted', 'to_type' => 'forum', 'to_fieldname' => 'post_date_gmt', ); $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'DateUpdated', 'to_type' => 'forum', 'to_fieldname' => 'post_modified', ); $this->field_map[] = array( 'from_tablename' => 'Category', 'from_fieldname' => 'DateUpdated', 'to_type' => 'forum', 'to_fieldname' => 'post_modified_gmt', ); /** Topic Section *****************************************************/ // Topic id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'DiscussionID', 'to_type' => 'topic', 'to_fieldname' => '_bbp_topic_id' ); // Topic reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'CountComments', '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' => 'Discussion', 'from_fieldname' => 'CountComments', 'to_type' => 'topic', 'to_fieldname' => '_bbp_total_reply_count', 'callback_method' => 'callback_topic_reply_count' ); // Topic parent forum id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'CategoryID', 'to_type' => 'topic', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_forumid' ); // Topic author. $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'InsertUserID', 'to_type' => 'topic', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Topic title. $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'Name', 'to_type' => 'topic', 'to_fieldname' => 'post_title' ); // Topic slug (Clean name to avoid conflicts) $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'Name', 'to_type' => 'topic', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Topic content. $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'Body', 'to_type' => 'topic', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Topic status (Open or Closed) $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'closed', 'to_type' => 'topic', 'to_fieldname' => 'post_status', 'callback_method' => 'callback_topic_status' ); // Topic author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'InsertIPAddress', 'to_type' => 'topic', 'to_fieldname' => '_bbp_author_ip' ); // Topic parent forum id (If no parent, then 0) $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'CategoryID', 'to_type' => 'topic', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_forumid' ); // Topic dates. $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'DateInserted', 'to_type' => 'topic', 'to_fieldname' => 'post_date' ); $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'DateInserted', 'to_type' => 'topic', 'to_fieldname' => 'post_date_gmt' ); $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'DateUpdated', 'to_type' => 'topic', 'to_fieldname' => 'post_modified' ); $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'DateUpdated', 'to_type' => 'topic', 'to_fieldname' => 'post_modified_gmt' ); $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'DateLastComment', 'to_type' => 'topic', 'to_fieldname' => '_bbp_last_active_time' ); /** Tags Section ******************************************************/ // Topic id. $this->field_map[] = array( 'from_tablename' => 'TagDiscussion', 'from_fieldname' => 'DiscussionID', 'to_type' => 'tags', 'to_fieldname' => 'objectid', 'callback_method' => 'callback_topicid' ); // Taxonomy ID. $this->field_map[] = array( 'from_tablename' => 'TagDiscussion', 'from_fieldname' => 'TagID', 'to_type' => 'tags', 'to_fieldname' => 'taxonomy' ); // Term text. $this->field_map[] = array( 'from_tablename' => 'Tag', 'from_fieldname' => 'Name', 'join_tablename' => 'TagDiscussion', 'join_type' => 'INNER', 'join_expression' => 'USING (tagid)', 'to_type' => 'tags', 'to_fieldname' => 'name' ); /** Reply Section *****************************************************/ // Reply id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Comment', 'from_fieldname' => 'CommentID', 'to_type' => 'reply', 'to_fieldname' => '_bbp_post_id' ); // Reply parent topic id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Comment', 'from_fieldname' => 'DiscussionID', 'to_type' => 'reply', 'to_fieldname' => '_bbp_topic_id', 'callback_method' => 'callback_topicid' ); // Reply parent forum id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'CategoryID', 'join_tablename' => 'Comment', 'join_type' => 'INNER', 'join_expression' => 'USING (DiscussionID)', 'to_type' => 'reply', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_topicid_to_forumid' ); // Reply title. // Note: We join the Discussion table because Comment table does not include topic title. $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'Name', 'join_tablename' => 'Comment', 'join_type' => 'INNER', 'join_expression' => 'USING (DiscussionID)', 'to_type' => 'reply', 'to_fieldname' => 'post_title', 'callback_method' => 'callback_reply_title' ); // Reply slug (Clean name to avoid conflicts) // Note: We join the Discussion table because Comment table does not include topic title. $this->field_map[] = array( 'from_tablename' => 'Discussion', 'from_fieldname' => 'Name', 'join_tablename' => 'Comment', 'join_type' => 'INNER', 'join_expression' => 'USING (DiscussionID)', 'to_type' => 'reply', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Reply author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'Comment', 'from_fieldname' => 'InsertIPAddress', 'to_type' => 'reply', 'to_fieldname' => '_bbp_author_ip' ); // Reply author. $this->field_map[] = array( 'from_tablename' => 'Comment', 'from_fieldname' => 'InsertUserID', 'to_type' => 'reply', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Reply content. $this->field_map[] = array( 'from_tablename' => 'Comment', 'from_fieldname' => 'Body', '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' => 'Comment', 'from_fieldname' => 'DiscussionID', 'to_type' => 'reply', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_topicid' ); // Reply dates. $this->field_map[] = array( 'from_tablename' => 'Comment', 'from_fieldname' => 'DateInserted', 'to_type' => 'reply', 'to_fieldname' => 'post_date' ); $this->field_map[] = array( 'from_tablename' => 'Comment', 'from_fieldname' => 'DateInserted', 'to_type' => 'reply', 'to_fieldname' => 'post_date_gmt' ); $this->field_map[] = array( 'from_tablename' => 'Comment', 'from_fieldname' => 'DateUpdated', 'to_type' => 'reply', 'to_fieldname' => 'post_modified' ); $this->field_map[] = array( 'from_tablename' => 'Comment', 'from_fieldname' => 'DateUpdated', 'to_type' => 'reply', 'to_fieldname' => 'post_modified_gmt' ); /** 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_user_id' ); // Store old User password (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'User', 'from_fieldname' => 'Password', 'to_type' => 'user', 'to_fieldname' => '_bbp_password' ); // User name. $this->field_map[] = array( 'from_tablename' => 'User', 'from_fieldname' => 'Name', 'to_type' => 'user', 'to_fieldname' => 'user_login' ); // User nice name. $this->field_map[] = array( 'from_tablename' => 'User', 'from_fieldname' => 'Name', 'to_type' => 'user', 'to_fieldname' => 'user_nicename' ); // User email. $this->field_map[] = array( 'from_tablename' => 'User', 'from_fieldname' => 'Email', 'to_type' => 'user', 'to_fieldname' => 'user_email' ); // User registered. $this->field_map[] = array( 'from_tablename' => 'User', 'from_fieldname' => 'DateInserted', 'to_type' => 'user', 'to_fieldname' => 'user_registered' ); // Display Name $this->field_map[] = array( 'from_tablename' => 'User', 'from_fieldname' => 'Name', 'to_type' => 'user', 'to_fieldname' => 'display_name' ); }
Questions?
We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.