stefyonweb (@stefyonweb)

Forum Replies Created

Viewing 8 replies - 1 through 8 (of 8 total)

  • stefyonweb
    Participant

    @stefyonweb

    Sure: I had an mdb backup. For some reason I inverted two columns in my table structure, so when I imported from csv file I had 0000-00-00 00:00:00 in column LAST_POST. Just a stupid mistake ^__^
    Unfortunately I still have some troubles. Lots of replies are in the database but not connected with their parent topics. I still have to figure out why, the database is huge, it’s very difficult to do some debug.
    Anyway, I’ll tell you when everything is ok.
    Thanks!


    stefyonweb
    Participant

    @stefyonweb

    Hi, I think I did it: the problem with the dates dipended on topics table structure.
    Everything seems to work fine now.
    Thank you for your precious support!


    stefyonweb
    Participant

    @stefyonweb

    Yes, dates are in the correct format yyyy-mm-dd


    stefyonweb
    Participant

    @stefyonweb

    Hi again, it seems I managed to import the database, but I get a weird error message in front end: [Incorrect DATETIME value: ‘0’]
    SELECT p.ID FROM wp_posts AS p WHERE p.post_date > ‘0’ AND p.post_type = ‘forum’ AND ( p.post_status = ‘publish’ OR p.post_status = ‘private’ OR p.post_status = ‘hidden’ ) ORDER BY p.post_date ASC LIMIT 1

    Apparently import was ok. Here’s the code.

    <?php
    
    /**
     * bbPress Example Converter
     *
     * @package bbPress
     * @subpackage Converters
     */
    
    /**
     * Example converter base impoprter template for bbPress
     *
     * @since 2.3.0 bbPress (r4689)
     *
     * @link Codex Docs https://codex.bbpress.org/import-forums/custom-import
     */
    class snitz extends BBP_Converter_Base {
    
    	/**
    	 * Main Constructor
    	 */
    	public function __construct() {
    		parent::__construct();
    	}
    
    	/**
    	 * Sets up the field mappings
    	 */
    	public function setup_globals() {
    
    		/** Forum Section *****************************************************/
    
    		// Setup table joins for the forum section at the base of this section
    
    		// Old forum id (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'FORUM_ID',
    			'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_FORUM',
    			'from_fieldname'  => 'CAT_ID',
    			'to_type'         => 'forum',
    			'to_fieldname'    => '_bbp_old_forum_parent_id'
    		);
    
    		// Forum topic count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_FORUM',
    			'from_fieldname' => 'F_TOPICS',
    			'to_type'        => 'forum',
    			'to_fieldname'   => '_bbp_topic_count'
    		);
    
    		// Forum reply count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_FORUM',
    			'from_fieldname' => 'F_COUNT',
    			'to_type'        => 'forum',
    			'to_fieldname'   => '_bbp_reply_count'
    		);
    
    		// Forum total topic count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_FORUM',
    			'from_fieldname' => 'F_TOPICS',
    			'to_type'        => 'forum',
    			'to_fieldname'   => '_bbp_total_topic_count'
    		);
    
    		// Forum total reply count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_FORUM',
    			'from_fieldname' => 'F_COUNT',
    			'to_type'        => 'forum',
    			'to_fieldname'   => '_bbp_total_reply_count'
    		);
    
    		// Forum title.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'F_SUBJECT',
    			'to_type'         => 'forum',
    			'to_fieldname'    => 'post_title'
    		);
    
    		// Forum slug (Clean name to avoid confilcts)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'F_SUBJECT',
    			'to_type'         => 'forum',
    			'to_fieldname'    => 'post_name',
    			'callback_method' => 'callback_slug'
    		);
    
    		// Forum description.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'F_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_FORUM',
    			'from_fieldname'  => 'FORUM_ORDER',
    			'to_type'         => 'forum',
    			'to_fieldname'    => 'menu_order'
    		);
    
    		// Forum type (Category = 0 or Forum = 1, Stored in postmeta)
    		$this->field_map[] = array(
    	//		'from_tablename'  => 'FORUM_FORUM',
    	//		'from_fieldname'  => 'the_forum_type',
    			'to_type'         => 'forum',
    			'to_fieldname'    => '_bbp_forum_type',
    		//	'callback_method' => 'callback_forum_type'
           'default'      => 'forum'
    		);
    
    		// Forum status (Unlocked = 0 or Locked = 1, Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'F_STATUS',
    			'to_type'         => 'forum',
    			'to_fieldname'    => '_bbp_status',
    			'callback_method' => 'callback_forum_status'
    		);
    
    		// 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'
    		);*/
    
    		/** Forum Subscriptions Section ***************************************/
    
    		// Subscribed forum ID (Stored in usermeta)
    	/*	$this->field_map[] = array(
    			'from_tablename'  => 'forum_subscriptions_table',
    			'from_fieldname'  => 'the_forum_id',
    			'to_type'         => 'forum_subscriptions',
    			'to_fieldname'    => '_bbp_forum_subscriptions'
    		);*/
    
    		// Subscribed user ID (Stored in usermeta)
    	/*	$this->field_map[] = array(
    			'from_tablename'  => 'forum_subscriptions_table',
    			'from_fieldname'  => 'the_user_id',
    			'to_type'         => 'forum_subscriptions',
    			'to_fieldname'    => 'user_id',
    			'callback_method' => 'callback_userid'
    		);*/
    
    		/** Topic Section *****************************************************/
    
    		// Setup table joins for the topic section at the base of this section
    
    		// Old topic id (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'TOPIC_ID',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_old_topic_id'
    		);
    
    		// Topic reply count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_REPLIES',
    			'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'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_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'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'FORUM_ID',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_forum_id',
    			'callback_method' => 'callback_forumid'
    		);
    
    		// Topic author.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_AUTHOR',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_author',
    			'callback_method' => 'callback_userid'
    		);
    
    		// Topic author ip (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_IP',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_author_ip'
    		);
    
    		// Topic content.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_MESSAGE',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_content',
    			'callback_method' => 'callback_html'
    		);
    
    		// Topic title.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_SUBJECT',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_title'
    		);
    
    		// Topic slug (Clean name to avoid conflicts)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_SUBJECT',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_name',
    			'callback_method' => 'callback_slug'
    		);
    
    		// Topic status (Open or Closed)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_STATUS',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_old_closed_status_id',
    			'callback_method' => 'callback_topic_status'
    		);
    
    		// Topic parent forum id (If no parent, then 0)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'FORUM_ID',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_parent',
    			'callback_method' => 'callback_forumid'
    		);
    
    		// Sticky status (Stored in postmeta)
    	/*	$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_STICKY',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_old_sticky_status_id',
    			'callback_method' => 'callback_sticky_status'
    		);*/
        $this->field_map[] = array(
    	//		'from_tablename'  => 'FORUM_FORUM',
    	//		'from_fieldname'  => 'the_forum_type',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_old_sticky_status_id',
    		//	'callback_method' => 'callback_forum_type'
           'default'      => 'normal'
    		);
    
    		// Topic dates.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_DATE',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_date',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_DATE',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_date_gmt',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_LAST_POST',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_modified',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_LAST_POST',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_modified_gmt',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_LAST_POST',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_last_active_time',
    			'callback_method' => 'callback_datetime'
    		);
    
        $this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_MESSAGE',
    			'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'
       );
        
    		// Setup any table joins needed for the topic section
    	/*	$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'TOPIC_ID',
    			'join_tablename'  => 'FORUM_TOPICS',
    			'join_type'       => 'INNER',
    			'join_expression' => 'USING FORUM_REPLY.TOPIC_ID = FORUM_TOPICS.TOPIC_ID',
    			'from_expression' => 'WHERE FORUM_FORUM.TOPIC_ID = 0',
    			'to_type'         => 'topic'
    		);*/
        
        
    
    		/** Tags Section ******************************************************/
    
    		
    
    		/** Topic Subscriptions Section ***************************************/
    
    		/** Favorites Section *************************************************/
    
    		// Favorited topic ID (Stored in usermeta)
    
    		/** Reply Section *****************************************************/
    
    		// Setup table joins for the reply section at the base of this section
    
    		// Old reply id (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'REPLY_ID',
    			'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'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'FORUM_ID',
    			'to_type'         => 'reply',
    			'to_fieldname'    => '_bbp_forum_id',
    			'callback_method' => 'callback_forumid'
    		);
    
    		// Reply parent topic id (If no parent, then 0. Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'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'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_IP',
    			'to_type'         => 'reply',
    			'to_fieldname'    => '_bbp_author_ip'
    		);
    
    		// Reply author.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_AUTHOR',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_author',
    			'callback_method' => 'callback_userid'
    		);
    
    		// Reply title and reply slugs
    		// Note: We don't actually want either a reply title or a reply slug as
    		//       we want single replies to use their ID as the permalink.
    
    		// Reply content.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_MESSAGE',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_content',
    			'callback_method' => 'callback_html'
    		);
    
    	/* Snizt doesnt use reply order
    		// Reply order.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'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'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'TOPIC_ID',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_parent',
    			'callback_method' => 'callback_topicid'
    		);
    
    		// Reply dates.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_DATE',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_date',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_DATE',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_date_gmt',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_DATE',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_modified',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_DATE',
    			'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'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'TOPIC_ID',
    			'join_tablename'  => 'FORUM_REPLY',
    			'join_type'       => 'INNER',
    			'join_expression' => 'USING FORUM_TOPICS.TOPIC_ID = FORUM_REPLY.TOPIC_ID',
    			'from_expression' => 'WHERE FORUM_TOPICS.first_post != 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'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'MEMBER_ID',
    			'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'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_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'  => 'FORUM_MEMBERS',
    			'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'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_NAME',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'user_login'
    		);
    
    		// User nice name.
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_MEMBERS',
    			'from_fieldname' => 'M_NAME',
    			'to_type'        => 'user',
    			'to_fieldname'   => 'user_nicename'
    		);
    
    		// User email.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_EMAIL',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'user_email'
    		);
    
    		// User homepage.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_HOMEPAGE',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'user_url'
    		);
    
    		/* Snitz doesn't use user registered
    		// User registered.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'the_users_registration_date',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'user_registered',
    			'callback_method' => 'callback_datetime'
    		);
    */
    /* Snitz doesn't use user status
    		// User status.
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_MEMBERS',
    			'from_fieldname' => 'the_users_status',
    			'to_type'        => 'user',
    			'to_fieldname'   => 'user_status'
    		);
    */
    
    		// User display name.
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_MEMBERS',
    			'from_fieldname' => 'M_NAME',
    			'to_type'        => 'user',
    			'to_fieldname'   => 'display_name'
    		);
    
    		// User Profile Field 1 (Stored in usermeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_AIM',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'aim'
    		);
    
    		// User Profile Field 2 (Stored in usermeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_YAHOO',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'yim'
    		);
    
    		// User Profile Field 3 (Stored in usermeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_MEMBERS',
    			'from_fieldname' => 'M_SIG',
    			'to_type'        => 'user',
    			'to_fieldname'   => '_bbp_snitz_user_sig'
    		);
    
    		// 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'  => 'FORUM_MEMBERS',
    			'join_type'       => 'INNER',
    			'join_expression' => 'USING users_profile_table.MEMBER_ID = FORUM_MEMBERS.MEMBER_ID',
    			'from_expression' => 'WHERE FORUM_MEMBERS.MEMBER_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'] ) );
    	}
      
      
    	/**
    	 * Translate the forum status from Snitz v3.x numeric's to WordPress's strings.
    	 *
    	 * @param int $status Snitz v3.x numeric forum status
    	 * @return string WordPress safe
    	 */
    	public function callback_forum_status( $status = 1 ) {
    		switch ( $status ) {
    			case 0 :
    				$status = 'closed';     // Snitz forum status closed 'F_STATUS = 0'
    				break;
    
    			case 1 :
    			default :
    				$status = 'open';       // Snitz forum status open 'F_STATUS = 1'
    				break;
    		}
    		return $status;
    	}
    
    	/**
    	 * Translate the topic status from Snitz v3.x numeric's to WordPress's strings.
    	 *
    	 * @param int $status Snitz v3.x numeric topic status
    	 * @return string WordPress safe
    	 */
    	public function callback_topic_status( $status = 1 ) {
    		switch ( $status ) {
    			case 0 :
    				$status = 'closed';     // Snitz topic status closed 'T_STATUS = 0'
    				break;
    
    			case 1 :
    			default :
    				$status = 'publish';    // Snitz topic status open 'T_STATUS = 1'
    				break;
    		}
    		return $status;
    	}
    
    	/**
    	 * Translate the topic sticky status type from Snitz 3.x numeric's to WordPress's strings.
    	 *
    	 * @param int $status Snitz 3.x numeric forum type
    	 * @return string WordPress safe
    	 */
    	public function callback_sticky_status( $status = 0 ) {
    		switch ( $status ) {
    			case 1 :
    				$status = 'sticky';       // Snitz Sticky 'T_STICKY = 1'
    				break;
    
    			case 0  :
    			default :
    				$status = 'normal';       // Snitz normal topic 'T_STICKY = 0'
    				break;
    		}
    		return $status;
    	}
    }
    
    

    stefyonweb
    Participant

    @stefyonweb

    Hi Robin, thanks for your efforts.
    It seems the problem with forum table was a field: “FORUM_ORDER” instead of “F_ORDER”.
    Now forum table is ok, I’m going to check out every single field.
    I’ll keep you updated 🙂


    stefyonweb
    Participant

    @stefyonweb

    Thank you Robin, here’s the code:

    <?php
    
    /**
     * bbPress Example Converter
     *
     * @package bbPress
     * @subpackage Converters
     */
    
    /**
     * Example converter base impoprter template for bbPress
     *
     * @since 2.3.0 bbPress (r4689)
     *
     * @link Codex Docs https://codex.bbpress.org/import-forums/custom-import
     */
    class snitz extends BBP_Converter_Base {
    
    	/**
    	 * Main Constructor
    	 */
    	public function __construct() {
    		parent::__construct();
    	}
    
    	/**
    	 * Sets up the field mappings
    	 */
    	public function setup_globals() {
    
    		/** Forum Section *****************************************************/
    
    		// Setup table joins for the forum section at the base of this section
    
    		// Old forum id (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'FORUM_ID',
    			'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_FORUM',
    			'from_fieldname'  => 'CAT_ID',
    			'to_type'         => 'forum',
    			'to_fieldname'    => '_bbp_old_forum_parent_id'
    		);
    
    		// Forum topic count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_FORUM',
    			'from_fieldname' => 'F_TOPICS',
    			'to_type'        => 'forum',
    			'to_fieldname'   => '_bbp_topic_count'
    		);
    
    		// Forum reply count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_FORUM',
    			'from_fieldname' => 'F_COUNT',
    			'to_type'        => 'forum',
    			'to_fieldname'   => '_bbp_reply_count'
    		);
    
    		// Forum total topic count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_FORUM',
    			'from_fieldname' => 'F_TOPICS',
    			'to_type'        => 'forum',
    			'to_fieldname'   => '_bbp_total_topic_count'
    		);
    
    		// Forum total reply count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_FORUM',
    			'from_fieldname' => 'F_COUNT',
    			'to_type'        => 'forum',
    			'to_fieldname'   => '_bbp_total_reply_count'
    		);
    
    		// Forum title.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'F_SUBJECT',
    			'to_type'         => 'forum',
    			'to_fieldname'    => 'post_title'
    		);
    
    		// Forum slug (Clean name to avoid confilcts)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'F_SUBJECT',
    			'to_type'         => 'forum',
    			'to_fieldname'    => 'post_name',
    			'callback_method' => 'callback_slug'
    		);
    
    		// Forum description.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'F_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_FORUM',
    			'from_fieldname'  => 'F_ORDER',
    			'to_type'         => 'forum',
    			'to_fieldname'    => 'menu_order'
    		);
    
    		// Forum type (Category = 0 or Forum = 1, Stored in postmeta)
    		$this->field_map[] = array(
    	//		'from_tablename'  => 'FORUM_FORUM',
    	//		'from_fieldname'  => 'the_forum_type',
    			'to_type'         => 'forum',
    			'to_fieldname'    => '_bbp_forum_type',
    		//	'callback_method' => 'callback_forum_type'
           'default'      => 'forum'
    		);
    
    		// Forum status (Unlocked = 0 or Locked = 1, Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_FORUM',
    			'from_fieldname'  => 'F_STATUS',
    			'to_type'         => 'forum',
    			'to_fieldname'    => '_bbp_status',
    			'callback_method' => 'callback_forum_status'
    		);
    
    		// 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'
    		);*/
    
    		/** Forum Subscriptions Section ***************************************/
    
    		// Subscribed forum ID (Stored in usermeta)
    	/*	$this->field_map[] = array(
    			'from_tablename'  => 'forum_subscriptions_table',
    			'from_fieldname'  => 'the_forum_id',
    			'to_type'         => 'forum_subscriptions',
    			'to_fieldname'    => '_bbp_forum_subscriptions'
    		);*/
    
    		// Subscribed user ID (Stored in usermeta)
    	/*	$this->field_map[] = array(
    			'from_tablename'  => 'forum_subscriptions_table',
    			'from_fieldname'  => 'the_user_id',
    			'to_type'         => 'forum_subscriptions',
    			'to_fieldname'    => 'user_id',
    			'callback_method' => 'callback_userid'
    		);*/
    
    		/** Topic Section *****************************************************/
    
    		// Setup table joins for the topic section at the base of this section
    
    		// Old topic id (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'TOPIC_ID',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_old_topic_id'
    		);
    
    		// Topic reply count (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_REPLIES',
    			'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'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_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'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'FORUM_ID',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_forum_id',
    			'callback_method' => 'callback_forumid'
    		);
    
    		// Topic author.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_AUTHOR',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_author',
    			'callback_method' => 'callback_userid'
    		);
    
    		// Topic author ip (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_IP',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_author_ip'
    		);
    
    		// Topic content.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_MESSAGE',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_content',
    			'callback_method' => 'callback_html'
    		);
    
    		// Topic title.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_SUBJECT',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_title'
    		);
    
    		// Topic slug (Clean name to avoid conflicts)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_SUBJECT',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_name',
    			'callback_method' => 'callback_slug'
    		);
    
    		// Topic status (Open or Closed)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_STATUS',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_old_closed_status_id',
    			'callback_method' => 'callback_topic_status'
    		);
    
    		// Topic parent forum id (If no parent, then 0)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'FORUM_ID',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_parent',
    			'callback_method' => 'callback_forumid'
    		);
    
    		// Sticky status (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_STICKY',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_old_sticky_status_id',
    			'callback_method' => 'callback_sticky_status'
    		);
    
    		// Topic dates.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_DATE',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_date',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_DATE',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_date_gmt',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_LAST_POST_DATE',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_modified',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_LAST_POST_DATE',
    			'to_type'         => 'topic',
    			'to_fieldname'    => 'post_modified_gmt',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_LAST_POST',
    			'to_type'         => 'topic',
    			'to_fieldname'    => '_bbp_last_active_time',
    			'callback_method' => 'callback_datetime'
    		);
    
        $this->field_map[] = array(
    			'from_tablename'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'T_MESSAGE',
    			'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'
       );
        
    		// Setup any table joins needed for the topic section
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'TOPIC_ID',
    			'join_tablename'  => 'FORUM_TOPICS',
    			'join_type'       => 'INNER',
    			'join_expression' => 'USING FORUM_REPLY.TOPIC_ID = FORUM_TOPICS.TOPIC_ID',
    			'from_expression' => 'WHERE FORUM_FORUM.TOPIC_ID = 0',
    			'to_type'         => 'topic'
    		);
    
    		/** Tags Section ******************************************************/
    
    		
    
    		/** Topic Subscriptions Section ***************************************/
    
    		/** Favorites Section *************************************************/
    
    		// Favorited topic ID (Stored in usermeta)
    
    		/** Reply Section *****************************************************/
    
    		// Setup table joins for the reply section at the base of this section
    
    		// Old reply id (Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'REPLY_ID',
    			'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'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'FORUM_ID',
    			'to_type'         => 'reply',
    			'to_fieldname'    => '_bbp_forum_id',
    			'callback_method' => 'callback_forumid'
    		);
    
    		// Reply parent topic id (If no parent, then 0. Stored in postmeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'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'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_IP',
    			'to_type'         => 'reply',
    			'to_fieldname'    => '_bbp_author_ip'
    		);
    
    		// Reply author.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_AUTHOR',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_author',
    			'callback_method' => 'callback_userid'
    		);
    
    		// Reply title and reply slugs
    		// Note: We don't actually want either a reply title or a reply slug as
    		//       we want single replies to use their ID as the permalink.
    
    		// Reply content.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_MESSAGE',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_content',
    			'callback_method' => 'callback_html'
    		);
    
    	/* Snizt doesnt use reply order
    		// Reply order.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'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'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'TOPIC_ID',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_parent',
    			'callback_method' => 'callback_topicid'
    		);
    
    		// Reply dates.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_DATE',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_date',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_DATE',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_date_gmt',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_DATE',
    			'to_type'         => 'reply',
    			'to_fieldname'    => 'post_modified',
    			'callback_method' => 'callback_datetime'
    		);
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_REPLY',
    			'from_fieldname'  => 'R_DATE',
    			'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'  => 'FORUM_TOPICS',
    			'from_fieldname'  => 'TOPIC_ID',
    			'join_tablename'  => 'FORUM_REPLY',
    			'join_type'       => 'INNER',
    			'join_expression' => 'USING FORUM_TOPICS.TOPIC_ID = FORUM_REPLY.TOPIC_ID',
    			'from_expression' => 'WHERE FORUM_TOPICS.first_post != 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'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'MEMBER_ID',
    			'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'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_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'  => 'FORUM_MEMBERS',
    			'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'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_NAME',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'user_login'
    		);
    
    		// User nice name.
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_MEMBERS',
    			'from_fieldname' => 'M_NAME',
    			'to_type'        => 'user',
    			'to_fieldname'   => 'user_nicename'
    		);
    
    		// User email.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_EMAIL',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'user_email'
    		);
    
    		// User homepage.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_HOMEPAGE',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'user_url'
    		);
    
    		/* Snitz doesn't use user registered
    		// User registered.
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'the_users_registration_date',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'user_registered',
    			'callback_method' => 'callback_datetime'
    		);
    */
    /* Snitz doesn't use user status
    		// User status.
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_MEMBERS',
    			'from_fieldname' => 'the_users_status',
    			'to_type'        => 'user',
    			'to_fieldname'   => 'user_status'
    		);
    */
    
    		// User display name.
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_MEMBERS',
    			'from_fieldname' => 'M_NAME',
    			'to_type'        => 'user',
    			'to_fieldname'   => 'display_name'
    		);
    
    		// User Profile Field 1 (Stored in usermeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_AIM',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'aim'
    		);
    
    		// User Profile Field 2 (Stored in usermeta)
    		$this->field_map[] = array(
    			'from_tablename'  => 'FORUM_MEMBERS',
    			'from_fieldname'  => 'M_YAHOO',
    			'to_type'         => 'user',
    			'to_fieldname'    => 'yim'
    		);
    
    		// User Profile Field 3 (Stored in usermeta)
    		$this->field_map[] = array(
    			'from_tablename' => 'FORUM_MEMBERS',
    			'from_fieldname' => 'M_SIG',
    			'to_type'        => 'user',
    			'to_fieldname'   => '_bbp_snitz_user_sig'
    		);
    
    		// 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'  => 'FORUM_MEMBERS',
    			'join_type'       => 'INNER',
    			'join_expression' => 'USING users_profile_table.MEMBER_ID = FORUM_MEMBERS.MEMBER_ID',
    			'from_expression' => 'WHERE FORUM_MEMBERS.MEMBER_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'] ) );
    	}
      
      
    	/**
    	 * Translate the forum status from Snitz v3.x numeric's to WordPress's strings.
    	 *
    	 * @param int $status Snitz v3.x numeric forum status
    	 * @return string WordPress safe
    	 */
    	public function callback_forum_status( $status = 1 ) {
    		switch ( $status ) {
    			case 0 :
    				$status = 'closed';     // Snitz forum status closed 'F_STATUS = 0'
    				break;
    
    			case 1 :
    			default :
    				$status = 'open';       // Snitz forum status open 'F_STATUS = 1'
    				break;
    		}
    		return $status;
    	}
    
    	/**
    	 * Translate the topic status from Snitz v3.x numeric's to WordPress's strings.
    	 *
    	 * @param int $status Snitz v3.x numeric topic status
    	 * @return string WordPress safe
    	 */
    	public function callback_topic_status( $status = 1 ) {
    		switch ( $status ) {
    			case 0 :
    				$status = 'closed';     // Snitz topic status closed 'T_STATUS = 0'
    				break;
    
    			case 1 :
    			default :
    				$status = 'publish';    // Snitz topic status open 'T_STATUS = 1'
    				break;
    		}
    		return $status;
    	}
    
    	/**
    	 * Translate the topic sticky status type from Snitz 3.x numeric's to WordPress's strings.
    	 *
    	 * @param int $status Snitz 3.x numeric forum type
    	 * @return string WordPress safe
    	 */
    	public function callback_sticky_status( $status = 0 ) {
    		switch ( $status ) {
    			case 1 :
    				$status = 'sticky';       // Snitz Sticky 'T_STICKY = 1'
    				break;
    
    			case 0  :
    			default :
    				$status = 'normal';       // Snitz normal topic 'T_STICKY = 0'
    				break;
    		}
    		return $status;
    	}
    }
    
    

    stefyonweb
    Participant

    @stefyonweb

    Thank you for your time, Robin 🙂
    I tried making a new snitz.php file following the given example. I also added the lines you suggested. Again the importer only imports users and reply table. I really can’t figure out the problem.
    I’m going to give up and ask for some company to do the job for me 🙁


    stefyonweb
    Participant

    @stefyonweb

    Hi everyone, although 4 years have passed, I hope someone can help me 🙂
    I’m trying to import a snitz database following these instructions, but I can only import users and “reply” table.
    Analyzing forum table configuration I noticed, comparing the snitz.php file with the other files, that

    ‘to_fieldname’ => ‘_bbp_forum_id’

    whereas in all the other files it’s

    ‘to_fieldname’ => ‘_bbp_old_forum_id’

    I tried changing the value but had no success, though.

    Maybe it depends on the fact that new bbPress version uses “post” and “postmeta” tables instead of custom bbPress tables?

    I searched for ad updated snitz.php file but didn’t find any.

    Thanks in advance 🙂

Viewing 8 replies - 1 through 8 (of 8 total)