PunBB::setup_globals()
Sets up the field mappings
Description
Source
File: bp-forums/admin/converters/PunBB.php
public function setup_globals() { /** Forum Section *****************************************************/ // Forum id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'id', 'to_type' => 'forum', 'to_fieldname' => '_bbp_forum_id' ); // Forum topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'num_topics', 'to_type' => 'forum', 'to_fieldname' => '_bbp_topic_count' ); // Forum reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'num_posts', 'to_type' => 'forum', 'to_fieldname' => '_bbp_reply_count' ); // Forum total topic count (Includes unpublished topics, Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'num_topics', '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' => 'forums', 'from_fieldname' => 'num_posts', 'to_type' => 'forum', 'to_fieldname' => '_bbp_total_reply_count' ); // Forum title. $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'forum_name', 'to_type' => 'forum', 'to_fieldname' => 'post_title' ); // Forum slug (Clean name to avoid conflicts) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'forum_name', 'to_type' => 'forum', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Forum description. $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'forum_desc', 'to_type' => 'forum', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_null' ); // Forum display order (Starts from 1) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'disp_position', 'to_type' => 'forum', 'to_fieldname' => 'menu_order' ); // 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') ); /** Topic Section *****************************************************/ // Topic id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'id', 'to_type' => 'topic', 'to_fieldname' => '_bbp_topic_id' ); // Topic reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'num_replies', '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' => 'topics', 'from_fieldname' => 'num_replies', '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' => 'topics', 'from_fieldname' => 'forum_id', 'to_type' => 'topic', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_forumid' ); // Topic author. // Note: We join the 'posts' table because 'topics' table does not have user id's. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'poster_id', 'join_tablename' => 'topics', 'join_type' => 'LEFT', 'join_expression' => 'ON topics.first_post_id = posts.id', 'to_type' => 'topic', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Topic Author ip (Stored in postmeta) // Note: We join the 'posts' table because 'topics' table does not have author ip. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'poster_ip', 'join_tablename' => 'topics', 'join_type' => 'LEFT', 'join_expression' => 'ON topics.first_post_id = posts.id', 'to_type' => 'topic', 'to_fieldname' => '_bbp_author_ip' ); // Topic content. // Note: We join the 'posts' table because 'topics' table does not have content. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'message', 'join_tablename' => 'topics', 'join_type' => 'LEFT', 'join_expression' => 'ON topics.first_post_id = posts.id', 'to_type' => 'topic', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Topic title. $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'subject', 'to_type' => 'topic', 'to_fieldname' => 'post_title' ); // Topic slug (Clean name to avoid conflicts) $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'subject', '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' => 'topics', 'from_fieldname' => 'forum_id', 'to_type' => 'topic', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_forumid' ); // Topic status (Open or Closed, PunBB v1.4.2 0=open & 1=closed) $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'closed', 'to_type' => 'topic', 'to_fieldname' => 'post_status', 'callback_method' => 'callback_topic_status' ); // Sticky status (Stored in postmeta)) $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'sticky', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_sticky_status', 'callback_method' => 'callback_sticky_status' ); // Topic dates. $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'posted', 'to_type' => 'topic', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'posted', 'to_type' => 'topic', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'last_post', 'to_type' => 'topic', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'last_post', 'to_type' => 'topic', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'last_post', 'to_type' => 'topic', 'to_fieldname' => '_bbp_last_active_time', 'callback_method' => 'callback_datetime' ); /** Tags Section ******************************************************/ /** * PunBB v1.4.2 Forums do not support topic tags out of the box */ /** Reply Section *****************************************************/ // Reply id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'id', 'to_type' => 'reply', 'to_fieldname' => '_bbp_post_id' ); // Reply parent forum id (If no parent, then 0. Stored in postmeta) // Note: We join the 'topics' table because 'posts' table does not have parent forum id's. $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'forum_id', 'join_tablename' => 'posts', 'join_type' => 'LEFT', 'join_expression' => 'ON topics.id = posts.topic_id WHERE topics.first_post_id != posts.id', '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' => 'posts', 'from_fieldname' => 'topic_id', 'to_type' => 'reply', 'to_fieldname' => '_bbp_topic_id', 'callback_method' => 'callback_topicid' ); // Reply author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'poster_ip', 'to_type' => 'reply', 'to_fieldname' => '_bbp_author_ip' ); // Reply author. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'poster_id', 'to_type' => 'reply', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Reply title. // Note: We join the 'topics' table because 'posts' table does not have topic subject. $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'subject', 'join_tablename' => 'posts', 'join_type' => 'LEFT', 'join_expression' => 'ON topics.id = posts.topic_id WHERE topics.first_post_id != posts.id', 'to_type' => 'reply', 'to_fieldname' => 'post_title', 'callback_method' => 'callback_reply_title' ); // Reply slug (Clean name to avoid conflicts) // Note: We join the 'topics' table because 'posts' table does not have topic subject. $this->field_map[] = array( 'from_tablename' => 'topics', 'from_fieldname' => 'subject', 'join_tablename' => 'posts', 'join_type' => 'LEFT', 'join_expression' => 'ON topics.id = posts.topic_id WHERE topics.first_post_id != posts.id', 'to_type' => 'reply', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Reply content. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'message', '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' => 'posts', 'from_fieldname' => 'topic_id', 'to_type' => 'reply', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_topicid' ); // Reply dates. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'posted', 'to_type' => 'reply', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'posted', 'to_type' => 'reply', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'edited', 'to_type' => 'reply', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'edited', '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' => 'users', 'from_fieldname' => 'id', 'to_type' => 'user', 'to_fieldname' => '_bbp_user_id' ); // Store old User password (Stored in usermeta serialized with salt) $this->field_map[] = array( 'from_tablename' => 'users', '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' => 'users', 'from_fieldname' => 'salt', 'to_type' => 'user', 'to_fieldname' => '' ); // User password verify class (Stored in usermeta for verifying password) $this->field_map[] = array( 'to_type' => 'users', 'to_fieldname' => '_bbp_class', 'default' => 'PunBB' ); // User name. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'username', 'to_type' => 'user', 'to_fieldname' => 'user_login' ); // User nice name. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'username', 'to_type' => 'user', 'to_fieldname' => 'user_nicename' ); // User email. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'email', 'to_type' => 'user', 'to_fieldname' => 'user_email' ); // User homepage. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'url', 'to_type' => 'user', 'to_fieldname' => 'user_url' ); // User registered. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'registered', 'to_type' => 'user', 'to_fieldname' => 'user_registered', 'callback_method' => 'callback_datetime' ); // User display name. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'realname', 'to_type' => 'user', 'to_fieldname' => 'display_name' ); // User AIM (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'aim', 'to_type' => 'user', 'to_fieldname' => 'aim' ); // User Yahoo (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'yahoo', 'to_type' => 'user', 'to_fieldname' => 'yim' ); // Store Jabber $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'jabber', 'to_type' => 'user', 'to_fieldname' => 'jabber' ); // Store ICQ (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'icq', 'to_type' => 'user', 'to_fieldname' => '_bbp_punbb_user_icq' ); // Store MSN (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'msn', 'to_type' => 'user', 'to_fieldname' => '_bbp_punbb_user_msn' ); // Store Facebook (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'facebook', 'to_type' => 'user', 'to_fieldname' => '_bbp_punbb_user_facebook' ); // Store Twitter (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'twitter', 'to_type' => 'user', 'to_fieldname' => '_bbp_punbb_user_twitter' ); // Store LinkedIn (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'linkedin', 'to_type' => 'user', 'to_fieldname' => '_bbp_punbb_user_linkedin' ); // Store Skype (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'skype', 'to_type' => 'user', 'to_fieldname' => '_bbp_punbb_user_skype' ); // Store Signature (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'signature', 'to_type' => 'user', 'to_fieldname' => '_bbp_punbb_user_sig', 'callback_method' => 'callback_html' ); // Store Location (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'location', 'to_type' => 'user', 'to_fieldname' => '_bbp_punbb_user_from' ); // Store Admin Note (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'admin_note', 'to_type' => 'user', 'to_fieldname' => '_bbp_punbb_user_admin_note' ); }
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.