/dhforum Secret
Created
February 18, 2018 15:51
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/* | |
CREATE TABLE IF NOT EXISTS `dh_authors` ( | |
`id` int(6) unsigned NOT NULL AUTO_INCREMENT, | |
`name` varchar(255) CHARACTER SET latin1 DEFAULT NULL, | |
`password` varchar(255) NOT NULL DEFAULT '478c6b086fec279cfe4aea3dbbf9640a', | |
`email` varchar(255) NOT NULL DEFAULT 'keine@example.org', | |
PRIMARY KEY (`id`), | |
UNIQUE KEY `id` (`id`) | |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1038 ; | |
-- password is only a dummy md5 encrypted value which is for all the default value | |
-- email is also only a dummy value which is for all users the same | |
CREATE TABLE IF NOT EXISTS `dh_forums` ( | |
`id` int(11) NOT NULL AUTO_INCREMENT, | |
`title` varchar(50) CHARACTER SET latin1 NOT NULL, | |
`topic_count` int(11) NOT NULL, | |
`reply_count` int(11) NOT NULL, | |
`locked` int(11) NOT NULL DEFAULT '0', | |
PRIMARY KEY (`id`) | |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; | |
-- there's only one forum entry to group all the newly imported topics in | |
CREATE TABLE IF NOT EXISTS `dh_posts` ( | |
`id` int(6) unsigned NOT NULL AUTO_INCREMENT, | |
`forum_id` int(11) NOT NULL, | |
`topic_id` int(11) NOT NULL, | |
`parent_id` int(6) NOT NULL, | |
`title` varchar(255) CHARACTER SET latin1 DEFAULT NULL, | |
`post` text CHARACTER SET latin1, | |
`author_id` int(6) NOT NULL, | |
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | |
PRIMARY KEY (`id`), | |
KEY `topic_id` (`parent_id`), | |
KEY `author_id` (`author_id`) | |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16395 ; | |
-- parent_id is 0 for topics | |
-- the topics are also in the dh_topics table | |
CREATE TABLE IF NOT EXISTS `dh_topics` ( | |
`id` int(11) NOT NULL, | |
`forum_id` int(11) NOT NULL, | |
`author_id` int(11) NOT NULL, | |
`title` varchar(255) CHARACTER SET latin1 NOT NULL, | |
`post` text CHARACTER SET latin1 NOT NULL, | |
`posts_count` int(11) DEFAULT NULL, | |
`total_posts_count` int(11) NOT NULL, | |
`date` datetime NOT NULL, | |
`locked` int(11) NOT NULL DEFAULT '0' | |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
*/ | |
/** | |
* 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 dhforum 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' => 'dh_forums', | |
'from_fieldname' => 'id', | |
'to_type' => 'forum', | |
'to_fieldname' => '_bbp_old_forum_id' | |
); | |
// Forum parent id (If no parent, then 0. Stored in postmeta) | |
// Not available | |
/*$this->field_map[] = array( | |
'from_tablename' => 'forums_table', | |
'from_fieldname' => 'the_parent_id', | |
'to_type' => 'forum', | |
'to_fieldname' => '_bbp_old_forum_parent_id' | |
);*/ | |
// Forum topic count (Stored in postmeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'topic_count', | |
'to_type' => 'forum', | |
'to_fieldname' => '_bbp_topic_count' | |
); | |
// Forum reply count (Stored in postmeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'reply_count', | |
'to_type' => 'forum', | |
'to_fieldname' => '_bbp_reply_count' | |
); | |
// Forum total topic count (Stored in postmeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'topic_count', | |
'to_type' => 'forum', | |
'to_fieldname' => '_bbp_total_topic_count' | |
); | |
// Forum total reply count (Stored in postmeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'reply_count', | |
'to_type' => 'forum', | |
'to_fieldname' => '_bbp_total_reply_count' | |
); | |
// Forum title. | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'title', | |
'to_type' => 'forum', | |
'to_fieldname' => 'post_title' | |
); | |
// Forum slug (Clean name to avoid confilcts) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'title', | |
'to_type' => 'forum', | |
'to_fieldname' => 'post_name', | |
'callback_method' => 'callback_slug' | |
); | |
// Forum description. | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'title', | |
'to_type' => 'forum', | |
'to_fieldname' => 'post_content', | |
'callback_method' => 'callback_null' | |
); | |
// Forum display order (Starts from 1) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'id', // only one value with id = 1 | |
'to_type' => 'forum', | |
'to_fieldname' => 'menu_order' | |
); | |
// Forum type (Category = 0 or Forum = 1, Stored in postmeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'id', // only one value with id = 1 -> forum | |
'to_type' => 'forum', | |
'to_fieldname' => '_bbp_forum_type', | |
'callback_method' => 'callback_forum_type' | |
); | |
// Forum status (Unlocked = 0 or Locked = 1, Stored in postmeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_forums', | |
'from_fieldname' => 'locked', | |
'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 is not available | |
/* | |
$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 is not available | |
/* | |
$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' => 'dh_topics', | |
'from_fieldname' => 'id', | |
'to_type' => 'topic', | |
'to_fieldname' => '_bbp_old_topic_id' | |
); | |
// Topic reply count (Stored in postmeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'posts_count', | |
'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' => 'dh_topics', | |
'from_fieldname' => 'total_posts_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' => 'dh_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' => 'dh_topics', | |
'from_fieldname' => 'author_id', | |
'to_type' => 'topic', | |
'to_fieldname' => 'post_author', | |
'callback_method' => 'callback_userid' | |
); | |
// Topic author ip (Stored in postmeta) | |
// -> not available | |
/* | |
$this->field_map[] = array( | |
'from_tablename' => 'topics_table', | |
'from_fieldname' => 'the_topic_author_ip_address', | |
'to_type' => 'topic', | |
'to_fieldname' => '_bbp_author_ip' | |
);*/ | |
// Topic content. | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'title', | |
'to_type' => 'topic', | |
'to_fieldname' => 'post_content', | |
'callback_method' => 'callback_html' | |
); | |
// Topic title. | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'title', | |
'to_type' => 'topic', | |
'to_fieldname' => 'post_title' | |
); | |
// Topic slug (Clean name to avoid conflicts) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'title', | |
'to_type' => 'topic', | |
'to_fieldname' => 'post_name', | |
'callback_method' => 'callback_slug' | |
); | |
// Topic status (Open or Closed) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'locked', | |
'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 is double?! | |
/* | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'forum_id', | |
'to_type' => 'topic', | |
'to_fieldname' => 'post_parent', | |
'callback_method' => 'callback_forumid' | |
);*/ | |
// Sticky status (Stored in postmeta) | |
// -> not available | |
/* | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'locked', | |
'to_type' => 'topic', | |
'to_fieldname' => '_bbp_old_sticky_status_id', | |
'callback_method' => 'callback_sticky_status' | |
); | |
*/ | |
// Topic dates. | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'date', | |
'to_type' => 'topic', | |
'to_fieldname' => 'post_date', | |
'callback_method' => 'callback_datetime' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'date', | |
'to_type' => 'topic', | |
'to_fieldname' => 'post_date_gmt', | |
'callback_method' => 'callback_datetime' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'date', | |
'to_type' => 'topic', | |
'to_fieldname' => 'post_modified', | |
'callback_method' => 'callback_datetime' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'date', | |
'to_type' => 'topic', | |
'to_fieldname' => 'post_modified_gmt', | |
'callback_method' => 'callback_datetime' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => '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' => 'dh_topics', | |
'from_fieldname' => 'forum_id', | |
'join_tablename' => 'dh_forums', | |
'join_type' => 'INNER', | |
'join_expression' => 'USING dh_topics.forum_id = dh_forums.id', | |
'from_expression' => 'WHERE 1=1', | |
'to_type' => 'topic' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_topics', | |
'from_fieldname' => 'author_id', | |
'join_tablename' => 'dh_forums', | |
'join_type' => 'INNER', | |
'join_expression' => 'USING dh_topics.author_id = dh_authors.id', | |
'from_expression' => 'WHERE 1=1', | |
'to_type' => 'topic' | |
); | |
/** Tags Section ******************************************************/ | |
// Setup table joins for the tag section at the base of this section | |
// Setup any table joins needed for the tags section | |
/* | |
$this->field_map[] = array( | |
'from_tablename' => 'tag_table', | |
'from_fieldname' => 'the_topic_id', | |
'join_tablename' => 'tagcontent_table', | |
'join_type' => 'INNER', | |
'join_expression' => 'USING tagcontent_table.tag_id = tags_table.tag_id', | |
'from_expression' => 'WHERE tagcontent_table.tag_id = tag_table.tag_id', | |
'to_type' => 'tags' | |
); | |
// Topic id. | |
$this->field_map[] = array( | |
'from_tablename' => 'tagcontent_table', | |
'from_fieldname' => 'contentid', | |
'to_type' => 'tags', | |
'to_fieldname' => 'objectid', | |
'callback_method' => 'callback_topicid' | |
); | |
// Taxonomy ID. | |
$this->field_map[] = array( | |
'from_tablename' => 'tagcontent_table', | |
'from_fieldname' => 'tagid', | |
'to_type' => 'tags', | |
'to_fieldname' => 'taxonomy' | |
); | |
// Term text. | |
$this->field_map[] = array( | |
'from_tablename' => 'tag_table', | |
'from_fieldname' => 'tagtext', | |
'to_type' => 'tags', | |
'to_fieldname' => 'name' | |
); | |
// Term slug. | |
$this->field_map[] = array( | |
'from_tablename' => 'tag_table', | |
'from_fieldname' => 'tagslug', | |
'to_type' => 'tags', | |
'to_fieldname' => 'slug', | |
'callback_method' => 'callback_slug' | |
); | |
// Term description. | |
$this->field_map[] = array( | |
'from_tablename' => 'tag_table', | |
'from_fieldname' => 'tagdescription', | |
'to_type' => 'tags', | |
'to_fieldname' => 'description' | |
); | |
*/ | |
/** Topic Subscriptions Section ***************************************/ | |
// Subscribed topic ID (Stored in usermeta) | |
/* | |
$this->field_map[] = array( | |
'from_tablename' => 'topic_subscriptions_table', | |
'from_fieldname' => 'the_topic_id', | |
'to_type' => 'topic_subscriptions', | |
'to_fieldname' => '_bbp_subscriptions' | |
); | |
// Subscribed user ID (Stored in usermeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'topic_subscriptions_table', | |
'from_fieldname' => 'the_user_id', | |
'to_type' => 'topic_subscriptions', | |
'to_fieldname' => 'user_id', | |
'callback_method' => 'callback_userid' | |
); | |
*/ | |
/** Favorites Section *************************************************/ | |
// Favorited topic ID (Stored in usermeta) | |
/* | |
$this->field_map[] = array( | |
'from_tablename' => 'favorites_table', | |
'from_fieldname' => 'the_favorite_topic_id', | |
'to_type' => 'favorites', | |
'to_fieldname' => '_bbp_favorites' | |
); | |
// Favorited user ID (Stored in usermeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'favorites_table', | |
'from_fieldname' => 'the_user_id', | |
'to_type' => 'favorites', | |
'to_fieldname' => 'user_id', | |
'callback_method' => 'callback_userid' | |
); | |
*/ | |
/** 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' => 'dh_posts', | |
'from_fieldname' => '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' => 'dh_posts', | |
'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' => 'dh_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' => 'dh_posts', | |
'from_fieldname' => 'the_reply_author_ip_address', | |
'to_type' => 'reply', | |
'to_fieldname' => '_bbp_author_ip' | |
);*/ | |
// Reply author. | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_posts', | |
'from_fieldname' => 'author_id', | |
'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' => 'dh_posts', | |
'from_fieldname' => 'post', | |
'to_type' => 'reply', | |
'to_fieldname' => 'post_content', | |
'callback_method' => 'callback_html' | |
); | |
// Reply order. | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_posts', | |
'from_fieldname' => 'id', | |
'to_type' => 'reply', | |
'to_fieldname' => 'menu_order' | |
); | |
// Reply parent topic id (If no parent, then 0) | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_posts', | |
'from_fieldname' => 'topic_id', | |
'to_type' => 'reply', | |
'to_fieldname' => 'post_parent', | |
'callback_method' => 'callback_topicid' | |
); | |
// Reply dates. | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_posts', | |
'from_fieldname' => 'date', | |
'to_type' => 'reply', | |
'to_fieldname' => 'post_date', | |
'callback_method' => 'callback_datetime' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_posts', | |
'from_fieldname' => 'date', | |
'to_type' => 'reply', | |
'to_fieldname' => 'post_date_gmt', | |
'callback_method' => 'callback_datetime' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_posts', | |
'from_fieldname' => 'date', | |
'to_type' => 'reply', | |
'to_fieldname' => 'post_modified', | |
'callback_method' => 'callback_datetime' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_posts', | |
'from_fieldname' => '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' => 'dh_posts', | |
'from_fieldname' => 'topic_id', | |
'join_tablename' => 'dh_topics', | |
'join_type' => 'INNER', | |
'join_expression' => 'USING dh_posts.topic_id = dh_topics.id', | |
'from_expression' => 'WHERE 1=1', | |
'to_type' => 'reply' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_posts', | |
'from_fieldname' => 'forum_id', | |
'join_tablename' => 'dh_forums', | |
'join_type' => 'INNER', | |
'join_expression' => 'USING dh_posts.forum_id = dh_forums.id', | |
'from_expression' => 'WHERE 1=1', | |
'to_type' => 'reply' | |
); | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_posts', | |
'from_fieldname' => 'author_id', | |
'join_tablename' => 'dh_authors', | |
'join_type' => 'INNER', | |
'join_expression' => 'USING dh_posts.author_id = dh_authors.id', | |
'from_expression' => 'WHERE 1=1', | |
'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' => 'dh_authors', | |
'from_fieldname' => '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' => 'dh_authors', | |
'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' => 'dh_authors', | |
'from_fieldname' => 'password', | |
'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' => 'dh_authors', | |
'from_fieldname' => 'name', | |
'to_type' => 'user', | |
'to_fieldname' => 'user_login' | |
); | |
// User nice name. | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_authors', | |
'from_fieldname' => 'name', | |
'to_type' => 'user', | |
'to_fieldname' => 'user_nicename' | |
); | |
// User email. | |
// | |
$this->field_map[] = array( | |
'from_tablename' => 'dh_authors', | |
'from_fieldname' => 'email', | |
'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' => 'users_table', | |
'from_fieldname' => 'the_users_registration_date', | |
'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' => 'dh_authors', | |
'from_fieldname' => 'name', | |
'to_type' => 'user', | |
'to_fieldname' => 'display_name' | |
); | |
// User Profile Field 1 (Stored in usermeta) | |
/* | |
$this->field_map[] = array( | |
'from_tablename' => 'users_table', | |
'from_fieldname' => 'the_users_custom_profile_field_1', | |
'to_type' => 'user', | |
'to_fieldname' => '_bbp_example_profile_field_1' | |
); | |
// User Profile Field 2 (Stored in usermeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'users_table', | |
'from_fieldname' => 'the_users_custom_profile_field_2', | |
'to_type' => 'user', | |
'to_fieldname' => '_bbp_example_profile_field_2' | |
); | |
// User Profile Field 3 (Stored in usermeta) | |
$this->field_map[] = array( | |
'from_tablename' => 'users_table', | |
'from_fieldname' => 'the_users_custom_profile_field_3', | |
'to_type' => 'user', | |
'to_fieldname' => '_bbp_example_profile_field_3' | |
); | |
// 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'] ) ); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment