Forum Replies Created
Viewing 4 replies - 1 through 4 (of 4 total)
-
I’m a firm believer of sharing your work, even if you get it working yourself. You never know who it could help! 🙂
Thank you Robin! Appreciate you guys being here for us php noobs 😀
I think I may have fixed it. Time to run another import. I’ve made the following changes to the import script.
<?php /** * Implementation of ECO Forums converter. * * @since bbPress (r4689) * @link Codex Docs https://codex.bbpress.org/import-forums/custom-import */ class VSI extends BBP_Converter_Base { /** * Main Constructor * * @uses Example_Converter::setup_globals() */ function __construct() { parent::__construct(); $this->setup_globals(); } /** * Sets up the field mappings */ public function setup_globals() { /** Forum Section *****************************************************/ // Setup table joins for the forum section at the base of this section // Forum id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_FORUMS', 'from_fieldname' => 'forumid', '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' => 'forums_table', // 'from_fieldname' => 'the_parent_id', // 'to_type' => 'forum', // 'to_fieldname' => '_bbp_forum_parent_id' //); // Forum topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_FORUMS', 'from_fieldname' => 'numberoftopics', 'to_type' => 'forum', 'to_fieldname' => '_bbp_topic_count' ); // Forum reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_FORUMS', 'from_fieldname' => 'numberofreplies', 'to_type' => 'forum', 'to_fieldname' => '_bbp_reply_count' ); // Forum total topic count (Stored in postmeta) //$this->field_map[] = array( // 'from_tablename' => 'forums_table', // 'from_fieldname' => 'the_total_topic_count', // 'to_type' => 'forum', // 'to_fieldname' => '_bbp_total_topic_count' //); // Forum total reply count (Stored in postmeta) //$this->field_map[] = array( // 'from_tablename' => 'forums_table', // 'from_fieldname' => 'the_total_reply_count', // 'to_type' => 'forum', // 'to_fieldname' => '_bbp_total_reply_count' //); // Forum title. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_FORUMS', 'from_fieldname' => 'forumtitle', 'to_type' => 'forum', 'to_fieldname' => 'post_title' ); // Forum slug (Clean name to avoid confilcts) //$this->field_map[] = array( // 'from_tablename' => 'forums_table', // 'from_fieldname' => 'the_forum_slug', // 'to_type' => 'forum', // 'to_fieldname' => 'post_name', // 'callback_method' => 'callback_slug' //); // Forum description. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_FORUMS', 'from_fieldname' => 'forumdescription', 'to_type' => 'forum', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_null' ); // Forum display order (Starts from 1) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_FORUMS', 'from_fieldname' => 'forumorder', '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') ); // Setup the table joins for the forum section //$this->field_map[] = array( // 'from_tablename' => 'groups_table', // 'from_fieldname' => 'forum_id', // 'join_tablename' => 'forums_table', // 'join_type' => 'INNER', // 'join_expression' => 'USING groups_table.forum_id = forums_table.forum_id', // 'from_expression' => 'WHERE forums_table.forum_id != 1', // 'to_type' => 'forum' //); /** Topic Section *****************************************************/ // Setup table joins for the topic section at the base of this section // Topic id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'messageid', 'to_type' => 'topic', 'to_fieldname' => '_bbp_topic_id' ); // Topic reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'replycount', 'to_type' => 'topic', 'to_fieldname' => '_bbp_reply_count', 'callback_method' => 'callback_topic_reply_count' ); // Topic total reply count (Stored in postmeta) //$this->field_map[] = array( // 'from_tablename' => 'topics_table', // 'from_fieldname' => 'the_total_topic_reply_count', // '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' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'forumid', 'to_type' => 'topic', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_forumid' ); // Topic author. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'memberid', 'to_type' => 'topic', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Topic author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'ipaddress', 'to_type' => 'topic', 'to_fieldname' => '_bbp_author_ip' ); // Topic content. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'forummessage', 'to_type' => 'topic', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Topic title. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'forumsubject', 'to_type' => 'topic', 'to_fieldname' => 'post_title' ); // Topic slug (Clean name to avoid conflicts) //$this->field_map[] = array( // 'from_tablename' => 'topics_table', // 'from_fieldname' => 'the_topic_slug', // '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' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'forumid', 'to_type' => 'topic', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_forumid' ); // Sticky status (Stored in postmeta)) //$this->field_map[] = array( // 'from_tablename' => 'topics_table', // 'from_fieldname' => 'the_topic_sticky_status', // 'to_type' => 'topic', // 'to_fieldname' => '_bbp_old_sticky_status', // 'callback_method' => 'callback_sticky_status' //); // Topic dates. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'datecreated', 'to_type' => 'topic', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'datecreated', 'to_type' => 'topic', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'dateupdate', 'to_type' => 'topic', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'dateupdate', 'to_type' => 'topic', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); //$this->field_map[] = array( // 'from_tablename' => 'topics_table', // 'from_fieldname' => 'the_topic_modified_date', // 'to_type' => 'topic', // 'to_fieldname' => '_bbp_last_active_time', // 'callback_method' => 'callback_datetime' //); // Setup any table joins needed for the topic section $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'threadid', 'join_tablename' => 'topics_table', 'join_type' => 'INNER', 'join_expression' => 'USING replies_table.the_topic_id = topics_table.the_topic_id', 'from_expression' => 'WHERE ECOFORUMS_MESSAGES.threadid = 0', 'to_type' => 'topic' ); /** Reply Section *****************************************************/ // Setup table joins for the reply section at the base of this section // Reply id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'threadid', 'to_type' => 'reply', 'to_fieldname' => '_bbp_post_id' ); // Reply parent forum id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'forumid', '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' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'replyto', 'to_type' => 'reply', 'to_fieldname' => '_bbp_topic_id', 'callback_method' => 'callback_topicid' ); // Reply author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'ipaddress', 'to_type' => 'reply', 'to_fieldname' => '_bbp_author_ip' ); // Reply author. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'memberid', 'to_type' => 'reply', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Reply title. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'forumsubject', 'to_type' => 'reply', 'to_fieldname' => 'post_title' ); // Reply slug (Clean name to avoid conflicts) //$this->field_map[] = array( // 'from_tablename' => 'replies_table', // 'from_fieldname' => 'the_reply_slug', // 'to_type' => 'reply', // 'to_fieldname' => 'post_name', // 'callback_method' => 'callback_slug' //); // Reply content. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'forummessage', 'to_type' => 'reply', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Reply order. //$this->field_map[] = array( // 'from_tablename' => 'replies_table', // 'from_fieldname' => 'the_reply_order', // 'to_type' => 'reply', // 'to_fieldname' => 'menu_order' //); // Reply parent topic id (If no parent, then 0) $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'threadid', 'to_type' => 'reply', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_topicid' ); // Reply dates. $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'datecreated', 'to_type' => 'reply', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'datecreated', 'to_type' => 'reply', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'dateupdate', 'to_type' => 'reply', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); //$this->field_map[] = array( // 'from_tablename' => 'replies_table', // 'from_fieldname' => 'dateupdate', // 'to_type' => 'reply', // 'to_fieldname' => 'post_modified_gmt', // 'callback_method' => 'callback_datetime' //); // Setup any table joins needed for the reply section $this->field_map[] = array( 'from_tablename' => 'ECOFORUMS_MESSAGES', 'from_fieldname' => 'threadid', 'join_tablename' => 'replies_table', 'join_type' => 'INNER', 'join_expression' => 'USING topics_table.the_topic_id = replies_table.the_topic_id', 'from_expression' => 'WHERE ECOFORUMS_MESSAGES.replyto != 0', 'to_type' => 'reply' ); /** User Section ******************************************************/ // Setup table joins for the user section at the base of this section // Store old User id (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'ECO_MEMBERS', 'from_fieldname' => 'member_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' => 'ECO_MEMBERS', 'from_fieldname' => 'userpassword', '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_table', // 'from_fieldname' => 'the_users_password_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' => 'Example' //); // User name. $this->field_map[] = array( 'from_tablename' => 'ECO_MEMBERS', 'from_fieldname' => 'login_id', 'to_type' => 'user', 'to_fieldname' => 'user_login' ); // User nice name. $this->field_map[] = array( 'from_tablename' => 'ECO_MEMBERS', 'from_fieldname' => 'login_id', 'to_type' => 'user', 'to_fieldname' => 'user_nicename' ); // User email. $this->field_map[] = array( 'from_tablename' => 'ECO_MEMBERS', 'from_fieldname' => 'emailaddress', 'to_type' => 'user', 'to_fieldname' => 'user_email' ); // User homepage. //$this->field_map[] = array( // 'from_tablename' => 'users_table', // 'from_fieldname' => 'the_users_homepage_url', // 'to_type' => 'user', // 'to_fieldname' => 'user_url' //); // User registered. $this->field_map[] = array( 'from_tablename' => 'ECO_MEMBERS', 'from_fieldname' => 'accountcreated', 'to_type' => 'user', 'to_fieldname' => 'user_registered', 'callback_method' => 'callback_datetime' ); // User status. //$this->field_map[] = array( // 'from_tablename' => 'users_table', // 'from_fieldname' => 'the_users_status', // 'to_type' => 'user', // 'to_fieldname' => 'user_status' //); // User display name. $this->field_map[] = array( 'from_tablename' => 'ECO_MEMBERS', 'from_fieldname' => 'login_id', 'to_type' => 'user', 'to_fieldname' => 'display_name' ); // User AIM (Stored in usermeta) //$this->field_map[] = array( // 'from_tablename' => 'users_table', // 'from_fieldname' => 'the_users_aim', // 'to_type' => 'user', // 'to_fieldname' => 'aim' //); // User Yahoo (Stored in usermeta) //$this->field_map[] = array( // 'from_tablename' => 'users_table', // 'from_fieldname' => 'the_users_yahoo', // 'to_type' => 'user', // 'to_fieldname' => 'yim' //); // User Jabber (Stored in usermeta) //$this->field_map[] = array( // 'from_tablename' => 'users_table', // 'from_fieldname' => 'the_users_jabber', // 'to_type' => 'user', // 'to_fieldname' => 'jabber' //); // Setup any table joins needed for the user section //$this->field_map[] = array( // 'from_tablename' => 'users_profile_table', // 'from_fieldname' => 'the_users_id', // 'join_tablename' => 'users_table', // 'join_type' => 'INNER', // 'join_expression' => 'USING users_profile_table.the_user_id = users_table.the_user_id', // 'from_expression' => 'WHERE users_table.the_user_id != -1', // 'to_type' => 'user' //); } /** * This method allows us to indicates what is or is not converted for each * converter. */ public function info() { return ''; } /** * This method is to save the salt and password together. That * way when we authenticate it we can get it out of the database * as one value. Array values are auto sanitized by WordPress. */ public function callback_savepass( $field, $row ) { $pass_array = array( 'hash' => $field, 'salt' => $row['salt'] ); return $pass_array; } /** * This method is to take the pass out of the database and compare * to a pass the user has typed in. */ public function authenticate_pass( $password, $serialized_pass ) { $pass_array = unserialize( $serialized_pass ); return ( $pass_array['hash'] == md5( md5( $password ). $pass_array['salt'] ) ); } }From what I can figure, the messages with ‘NONE’ as the subject are replies, but they’re added as topics and not joined.
Viewing 4 replies - 1 through 4 (of 4 total)
