Forum Replies Created
Viewing 18 replies - 1 through 18 (of 18 total)
-
In reply to: style pack not working with generatepress
certainly, it is:
add_filter( 'generate_get_the_title_parameters', function( $params ){ if ( bbp_is_forum_archive() ) { $params = array( 'before' => sprintf( '<h2 class="entry-title"%s">', 'microdata' === generate_get_schema_type() ? ' itemprop="headline"' : '' ), 'after' => '</h2>', ); } return $params; },10,1 );In reply to: style pack not working with generatepressGot it with a few tweaks, thanks so much for your help Robin, I greatly appreciate it.
In reply to: style pack not working with generatepressMethod 2
WP Page: NamedCommunity
Slug Name:Community
Code within the page:[bbp-forum-index]also, I forgot to include the function, here’s the full code that calls the issue:
function generate_get_the_title_parameters() { if ( ! is_singular() ) { $params = array( 'before' => sprintf( '<h2 class="entry-title"%2$s><a href="%1$s" rel="bookmark">', esc_url( get_permalink() ), 'microdata' === generate_get_schema_type() ? ' itemprop="headline"' : '' ), 'after' => '</a></h2>', ); } return apply_filters( 'generate_get_the_title_parameters', $params ); }In reply to: style pack not working with generatepressThank you for that Robin, I was able to find it in the theme coding based on your assistance.
if ( ! is_singular() ) { $params = array( 'before' => sprintf( '<h2 class="entry-title"%2$s><a href="%1$s" rel="bookmark">', esc_url( get_permalink() ), 'microdata' === generate_get_schema_type() ? ' itemprop="headline"' : '' ), 'after' => '</a></h2>', ); }Do you know how I could exclude the forum link from this?
In reply to: style pack not working with generatepressI just created a new forum as a test, (called “test”) and when I did, the “Community” header just changed links, now it links to the Test forum. I’d like to remove the link entirely.
In reply to: style pack not working with generatepressSorry, so on that main forum index page, the Header, “Community” becomes a clickable link to the last created forum in the site.
My question, is, where/what template would insert this as a link? and why did it pick the latest forum created…
In reply to: style pack not working with generatepressThank you for your reply, I just got it a few minutes ago by copying files into the loop-forums.php
I do have one other weird issue- The header “Community” is linked to a particular forum and I can’t seem to figure out how or why.
Any ideas why it’s randomly pulling the last forum created as a link?
In reply to: style pack not working with generatepress@robin I am experiencing the exact same issue, even when using
?ao_noptimize=1to shut off Autoptimize for testing.I also use GeneratePress (pro), and bbpress with bbpstylepack .
The individual forums show perfectly, but the index is very broken and missing proper styling.
The issue can be seen here
https://www.budget101.com/community/In reply to: Tabindex Attributes Cause Accessibility ProblemsThis is a fix that should really be implemented. I would have noted it sooner if I’d realized that the work I did that many years ago was unused.
They half-ass applied it, several of the templates were edited, and some areas still need to be commented out or removed entirely.
src/includes/forums/template.php
line #2491 (used to be)
<select name="<?php echo esc_attr( $r['select_id'] ) ?>" id="<?php echo esc_attr( $r['select_id'] ) ?>_select"<?php echo $tab; ?>>except now the line is #2393 and has become:
<select name="<?php echo esc_attr( $r['select_id'] ) ?>" id="<?php echo esc_attr( $r['select_id'] ) ?>_select" class="<?php echo esc_attr( $r['select_class'] ); ?>"<?php bbp_tab_index_attribute( $r['tab'] ); ?>>so – which part do we remove? see also line #2479 (same code)
In reply to: Noindex Search PagesEdit your Robots.txt file and add the following:
User-agent: * Disallow: /search?* Disallow: /search/*@lucio – I had the same issue, I wanted my topic list to appear above my subforums, here is the easy fix.
go to>
wp-content>plugins>bbpress>templates>default>bbpressFind content-single-forum.php
select lines 28-32:
<?php if ( bbp_has_forums() ) : ?> <?php bbp_get_template_part( 'loop', 'forums' ); ?> <?php endif; ?>Find these lines:
<?php if ( bbp_has_forums() ) : ?> <?php bbp_get_template_part( 'loop', 'forums' ); ?> <?php endif; ?>Paste the 3 lines selected above UNDERNEATH those lines (Line #50)
I’d like to move this as well, some of the subforum listings are so long that people don’t scroll to the bottom to see the topics.
I’d like it to show:
Forum Name:
Topics:
Then Subforum listIn reply to: vbulletin 3.x importActually, this one works much better & doesn’t interfere if you have multiple tabs running at once:
In reply to: vbulletin 3.x importThe import is still occuring, and I know with 1.8 million posts it will take while. It already converted users and topics. Now it is creating a series of dashed lines. ———————-
I too experienced this issue, basically your wp-admin becomes stale and logs you out or kills your connection. Install a refresher in your browser, such as this one:
then open a DIFFERENT page for your wp-admin (NOT the one doing the importing!) and set it to fresh every 3 minutes (alter the length depending on your own needs). This keeps WP from logging you out or killing the DB connection and lets it continue running throughout the day/night without needing to babysit it.
In reply to: Import Hung?The order should be (I think):
Users
Forums
Topics
Tags
RepliesAgreed, this is necessary for large imports, I initially had a database of 110K+ users and 2.2 million posts/topics, which after 13 days of importing I decided to prune before attempting again.
In theory, you could rearrange these yourself by altering the wp-content>plugins>bbpress>includes>admin>converter.php file and changing the order of the steps. I actually thing the tags are the least important step for my site & the one that caused the most headache/issues while importing, so I made that step the LAST step.
<?php /** * bbPress Converter * * Based on the hard work of Adam Ellis at http://bbconverter.com * * @package bbPress * @subpackage Administration */ // Exit if accessed directly if ( !defined( 'ABSPATH' ) ) exit; /** * Main BBP_Converter Class */ class BBP_Converter { /** * The main bbPress Converter loader * * @since bbPress (r3813) * @uses BBP_Converter::includes() Include the required files * @uses BBP_Converter::setup_actions() Setup the actions */ public function __construct() { // "I wonder where I'll float next." if ( empty( $_SERVER['REQUEST_METHOD'] ) ) return; // Bail if request is not correct switch ( strtoupper( $_SERVER['REQUEST_METHOD'] ) ) { // Converter is converting case 'POST' : if ( ( empty( $_POST['action'] ) || ( 'bbconverter_process' != $_POST['action'] ) ) ) return; break; // Some other admin page case 'GET' : if ( ( empty( $_GET['page'] ) || ( 'bbp-converter' != $_GET['page'] ) ) ) return; break; } // Proceed with the actions $this->setup_actions(); } /** * Setup the default actions * * @since bbPress (r3813) * @uses add_action() To add various actions */ private function setup_actions() { // Attach to the admin head with our ajax requests cycle and css add_action( 'bbp_admin_head', array( $this, 'admin_head' ) ); // Attach the bbConverter admin settings action to the WordPress admin init action. add_action( 'bbp_register_admin_settings', array( $this, 'register_admin_settings' ) ); // Attach to the admin ajax request to process cycles add_action( 'wp_ajax_bbconverter_process', array( $this, 'process_callback' ) ); } /** * Register the settings * * @since bbPress (r3813) * @uses add_settings_section() To add our own settings section * @uses add_settings_field() To add various settings fields * @uses register_setting() To register various settings */ public function register_admin_settings() { // Add the main section add_settings_section( 'bbpress_converter_main', __( 'Database Settings', 'bbpress' ), 'bbp_converter_setting_callback_main_section', 'bbpress_converter' ); // System Select add_settings_field( '_bbp_converter_platform', __( 'Select Platform', 'bbpress' ), 'bbp_converter_setting_callback_platform', 'bbpress_converter', 'bbpress_converter_main' ); register_setting ( 'bbpress_converter_main', '_bbp_converter_platform', 'sanitize_title' ); // Database Server add_settings_field( '_bbp_converter_db_server', __( 'Database Server', 'bbpress' ), 'bbp_converter_setting_callback_dbserver', 'bbpress_converter', 'bbpress_converter_main' ); register_setting ( 'bbpress_converter_main', '_bbp_converter_db_server', 'sanitize_title' ); // Database Server Port add_settings_field( '_bbp_converter_db_port', __( 'Database Port', 'bbpress' ), 'bbp_converter_setting_callback_dbport', 'bbpress_converter', 'bbpress_converter_main' ); register_setting ( 'bbpress_converter_main', '_bbp_converter_db_port', 'sanitize_title' ); // Database Name add_settings_field( '_bbp_converter_db_name', __( 'Database Name', 'bbpress' ), 'bbp_converter_setting_callback_dbname', 'bbpress_converter', 'bbpress_converter_main' ); register_setting ( 'bbpress_converter_main', '_bbp_converter_db_name', 'sanitize_title' ); // Database User add_settings_field( '_bbp_converter_db_user', __( 'Database User', 'bbpress' ), 'bbp_converter_setting_callback_dbuser', 'bbpress_converter', 'bbpress_converter_main' ); register_setting ( 'bbpress_converter_main', '_bbp_converter_db_user', 'sanitize_title' ); // Database Pass add_settings_field( '_bbp_converter_db_pass', __( 'Database Password', 'bbpress' ), 'bbp_converter_setting_callback_dbpass', 'bbpress_converter', 'bbpress_converter_main' ); register_setting ( 'bbpress_converter_main', '_bbp_converter_db_pass', 'sanitize_title' ); // Database Prefix add_settings_field( '_bbp_converter_db_prefix', __( 'Table Prefix', 'bbpress' ), 'bbp_converter_setting_callback_dbprefix', 'bbpress_converter', 'bbpress_converter_main' ); register_setting ( 'bbpress_converter_main', '_bbp_converter_db_prefix', 'sanitize_title' ); // Add the options section add_settings_section( 'bbpress_converter_opt', __( 'Options', 'bbpress' ), 'bbp_converter_setting_callback_options_section', 'bbpress_converter' ); // Rows Limit add_settings_field( '_bbp_converter_rows', __( 'Rows Limit', 'bbpress' ), 'bbp_converter_setting_callback_rows', 'bbpress_converter', 'bbpress_converter_opt' ); register_setting ( 'bbpress_converter_opt', '_bbp_converter_rows', 'intval' ); // Delay Time add_settings_field( '_bbp_converter_delay_time', __( 'Delay Time', 'bbpress' ), 'bbp_converter_setting_callback_delay_time', 'bbpress_converter', 'bbpress_converter_opt' ); register_setting ( 'bbpress_converter_opt', '_bbp_converter_delay_time', 'intval' ); // Convert Users ? add_settings_field( '_bbp_converter_convert_users', __( 'Convert Users', 'bbpress' ), 'bbp_converter_setting_callback_convert_users', 'bbpress_converter', 'bbpress_converter_opt' ); register_setting ( 'bbpress_converter_opt', '_bbp_converter_convert_users', 'intval' ); // Restart add_settings_field( '_bbp_converter_restart', __( 'Start Over', 'bbpress' ), 'bbp_converter_setting_callback_restart', 'bbpress_converter', 'bbpress_converter_opt' ); register_setting ( 'bbpress_converter_opt', '_bbp_converter_restart', 'intval' ); // Clean add_settings_field( '_bbp_converter_clean', __( 'Purge Previous Import', 'bbpress' ), 'bbp_converter_setting_callback_clean', 'bbpress_converter', 'bbpress_converter_opt' ); register_setting ( 'bbpress_converter_opt', '_bbp_converter_clean', 'intval' ); } /** * Admin scripts * * @since bbPress (r3813) */ public function admin_head() { ?> <style type="text/css" media="screen"> /*<![CDATA[*/ div.bbp-converter-updated, div.bbp-converter-warning { border-radius: 3px 3px 3px 3px; border-style: solid; border-width: 1px; padding: 5px 5px 5px 5px; } div.bbp-converter-updated { height: 300px; overflow: auto; display: none; background-color: #FFFFE0; border-color: #E6DB55; font-family: monospace; font-weight: bold; } div.bbp-converter-updated p { margin: 0.5em 0; padding: 2px; float: left; clear: left; } div.bbp-converter-updated p.loading { background-image: url('%3C?php echo admin_url('); background-repeat: no-repeat; background-position: right center;; padding-left:2px; padding-right:20px; padding-top:2px; padding-bottom:2px } #bbp-converter-stop { display:none; } #bbp-converter-progress { display:none; } /*]]>*/ </style> <script language="javascript"> var bbconverter_is_running = false; var bbconverter_run_timer; var bbconverter_delay_time = 0; function bbconverter_grab_data() { var values = {}; jQuery.each(jQuery('#bbp-converter-settings').serializeArray(), function(i, field) { values[field.name] = field.value; }); if( values['_bbp_converter_restart'] ) { jQuery('#_bbp_converter_restart').removeAttr("checked"); } if( values['_bbp_converter_delay_time'] ) { bbconverter_delay_time = values['_bbp_converter_delay_time'] * 1000; } values['action'] = 'bbconverter_process'; values['_ajax_nonce'] = '<?php echo wp_create_nonce( 'bbp_converter_process' ); ?>'; return values; } function bbconverter_start() { if( false == bbconverter_is_running ) { bbconverter_is_running = true; jQuery('#bbp-converter-start').hide(); jQuery('#bbp-converter-stop').show(); jQuery('#bbp-converter-progress').show(); bbconverter_log( '<p class="loading"><?php esc_html_e( 'Starting Conversion', 'bbpress' ); ?></p>' ); bbconverter_run(); } } function bbconverter_run() { jQuery.post(ajaxurl, bbconverter_grab_data(), function(response) { var response_length = response.length - 1; response = response.substring(0,response_length); bbconverter_success(response); }); } function bbconverter_stop() { jQuery('#bbp-converter-start').show(); jQuery('#bbp-converter-stop').hide(); jQuery('#bbp-converter-progress').hide(); jQuery('#bbp-converter-message p').removeClass( 'loading' ); bbconverter_is_running = false; clearTimeout( bbconverter_run_timer ); } function bbconverter_success(response) { bbconverter_log(response); if ( response == '<p class="loading"><?php esc_html_e( 'Conversion Complete', 'bbpress' ); ?></p>' || response.indexOf('error') > -1 ) { bbconverter_log('<p>Repair any missing information: <a href="<?php echo admin_url(); ?>tools.php?page=bbp-repair">Continue</a></p>'); bbconverter_stop(); } else if( bbconverter_is_running ) { // keep going jQuery('#bbp-converter-progress').show(); clearTimeout( bbconverter_run_timer ); bbconverter_run_timer = setTimeout( 'bbconverter_run()', bbconverter_delay_time ); } else { bbconverter_stop(); } } function bbconverter_log(text) { if ( jQuery('#bbp-converter-message').css('display') == 'none' ) { jQuery('#bbp-converter-message').show(); } if ( text ) { jQuery('#bbp-converter-message p').removeClass( 'loading' ); jQuery('#bbp-converter-message').prepend( text ); } } </script> <?php } /** * Wrap the converter output in paragraph tags, so styling can be applied * * @since bbPress (r4052) * * @param string $output */ private static function converter_output( $output = '' ) { // Get the last query $before = '<p class="loading">'; $after = '</p>'; $query = get_option( '_bbp_converter_query' ); if ( ! empty( $query ) ) $before = '<p class="loading" title="' . esc_attr( $query ) . '">'; echo $before . $output . $after; } /** * Callback processor * * @since bbPress (r3813) */ public function process_callback() { // Verify intent check_ajax_referer( 'bbp_converter_process' ); // Bail if user cannot view import page if ( ! current_user_can( 'bbp_tools_import_page' ) ) { wp_die( '0' ); } if ( ! ini_get( 'safe_mode' ) ) { set_time_limit( 0 ); ini_set( 'memory_limit', '256M' ); ini_set( 'implicit_flush', '1' ); ignore_user_abort( true ); } // Save step and count so that it can be restarted. if ( ! get_option( '_bbp_converter_step' ) || ( !empty( $_POST['_bbp_converter_restart'] ) ) ) { update_option( '_bbp_converter_step', 1 ); update_option( '_bbp_converter_start', 0 ); } $step = (int) get_option( '_bbp_converter_step', 1 ); $min = (int) get_option( '_bbp_converter_start', 0 ); $count = (int) ! empty( $_POST['_bbp_converter_rows'] ) ? $_POST['_bbp_converter_rows'] : 100; $max = ( $min + $count ) - 1; $start = $min; // Bail if platform did not get saved $platform = !empty( $_POST['_bbp_converter_platform' ] ) ? $_POST['_bbp_converter_platform' ] : get_option( '_bbp_converter_platform' ); if ( empty( $platform ) ) return; // Include the appropriate converter. $converter = bbp_new_converter( $platform ); switch ( $step ) { // STEP 1. Clean all tables. case 1 : if ( !empty( $_POST[_bbp_converter_clean] ) ) { if ( $converter->clean( $start ) ) { update_option( _bbp_converter_step'', $step + 1 ); update_option( '_bbp_converter_start', 0 ) } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Deleting previously converted data (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } } else { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); } break; // STEP 2. Convert users. case 2 : if ( !empty( $_POST['_bbp_converter_convert_users'] ) ) { if ( $converter->convert_users( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No users to convert', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Converting users (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } } else { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); } break; // STEP 3. Clean passwords. case 3 : if ( !empty( $_POST['_bbp_converter_convert_users'] ) ) { if ( $converter->clean_passwords( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No passwords to clear', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Delete users WordPress default passwords (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } } else { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); } break; // STEP 4. Convert forums. case 4 : if ( $converter->convert_forums( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No forums to convert', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Converting forums (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } break; // STEP 5. Convert forum parents. case 5 : if ( $converter->convert_forum_parents( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No forum parents to convert', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Calculating forum hierarchy (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } break; // STEP 6. Convert topics. case 6 : if ( $converter->convert_topics( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No topics to convert', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Converting topics (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } break; // STEP 7. Stick topics. case 7 : if ( $converter->convert_topic_stickies( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No stickies to stick', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Calculating topic stickies (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } break; // STEP 8. Stick to front topics (Super Sicky). case 8 : if ( $converter->convert_topic_super_stickies( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No super stickies to stick', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Calculating topic super stickies (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } break; // STEP 9. Convert replies. case 9 : if ( $converter->convert_replies( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No replies to convert', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Converting replies (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } break; // STEP 10. Convert reply_to parents. case 10 : if ( $converter->convert_reply_to_parents( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No reply_to parents to convert', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Calculating reply_to parents (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } break; // STEP 11. Convert tags. case 11 : if ( $converter->convert_tags( $start ) ) { update_option( '_bbp_converter_step', $step + 1 ); update_option( '_bbp_converter_start', 0 ); if ( empty( $start ) ) { $this->converter_output( __( 'No tags to convert', 'bbpress' ) ); } } else { update_option( '_bbp_converter_start', $max + 1 ); $this->converter_output( sprintf( __( 'Converting topic tags (%1$s - %2$s)', 'bbpress' ), $min, $max ) ); } break; default : delete_option( '_bbp_converter_step' ); delete_option( '_bbp_converter_start' ); delete_option( '_bbp_converter_query' ); $this->converter_output( __( 'Conversion Complete', 'bbpress' ) ); break; } } /** * Create Tables for fast syncing * * @since bbPress (r3813) */ public function sync_table( $drop = false ) { global $wpdb; $table_name = $wpdb->prefix . 'bbp_converter_translator'; if ( ! empty( $drop ) && $wpdb->get_var( "SHOW TABLES LIKE '{$table_name}'" ) == $table_name ) $wpdb->query( "DROP TABLE {$table_name}" ); require_once( ABSPATH . '/wp-admin/includes/upgrade.php' ); if ( !empty( $wpdb->charset ) ) { $charset_collate = "DEFAULT CHARACTER SET $wpdb->charset"; } if ( !empty( $wpdb->collate ) ) { $charset_collate .= "COLLATE $wpdb->collate"; } /** Translator ****************************************************/ $sql = "CREATE TABLE {$table_name} ( meta_id mediumint(8) unsigned not null auto_increment, value_type varchar(25) null, value_id bigint(20) unsigned not null default '0', meta_key varchar(25) null, meta_value varchar(25) null, PRIMARY KEY (meta_id), KEY value_id (value_id), KEY meta_join (meta_key, meta_value) ) {$charset_collate};"; dbDelta( $sql ); } } /** * Base class to be extended by specific individual importers * * @since bbPress (r3813) */ abstract class BBP_Converter_Base { /** * @var array() This is the field mapping array to process. */ protected $field_map = array(); /** * @var object This is the connection to the WordPress datbase. */ protected $wpdb; /** * @var object This is the connection to the other platforms database. */ protected $opdb; /** * @var int This is the max rows to process at a time. */ public $max_rows; /** * @var array() Map of topic to forum. It is for optimization. */ private $map_topicid_to_forumid = array(); /** * @var array() Map of from old forum ids to new forum ids. It is for optimization. */ private $map_forumid = array(); /** * @var array() Map of from old topic ids to new topic ids. It is for optimization. */ private $map_topicid = array(); /** * @var array() Map of from old reply_to ids to new reply_to ids. It is for optimization. */ private $map_reply_to = array(); /** * @var array() Map of from old user ids to new user ids. It is for optimization. */ private $map_userid = array(); /** * @var str This is the charset for your wp database. */ public $charset; /** * @var boolean Sync table available. */ public $sync_table = false; /** * @var str Sync table name. */ public $sync_table_name; /** Methods ***************************************************************/ /** * This is the constructor and it connects to the platform databases. */ public function __construct() { $this->setup_globals(); } private function setup_globals() { global $wpdb; /** Get database connections ******************************************/ $this->wpdb = $wpdb; $this->max_rows = (int) $_POST['_bbp_converter_rows']; $this->opdb = new wpdb( $_POST['_bbp_converter_db_user'], $_POST['_bbp_converter_db_pass'], $_POST['_bbp_converter_db_name'], $_POST['_bbp_converter_db_server'] ); $this->opdb->prefix = $_POST['_bbp_converter_db_prefix']; /** * Error Reporting */ $this->wpdb->show_errors(); $this->opdb->show_errors(); /** * Syncing */ $this->sync_table_name = $this->wpdb->prefix . 'bbp_converter_translator'; if ( $this->wpdb->get_var( "SHOW TABLES LIKE '" . $this->sync_table_name . "'" ) == $this->sync_table_name ) { $this->sync_table = true; } else { $this->sync_table = false; } /** * Charset */ if ( empty( $this->wpdb->charset ) ) { $this->charset = 'UTF8mb4'; } else { $this->charset = $this->wpdb->charset; } /** * Default mapping. */ /** Forum Section *****************************************************/ $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_status', 'default' => 'publish' ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'comment_status', 'default' => 'closed' ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'ping_status', 'default' => 'closed' ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_type', 'default' => 'forum' ); /** Topic Section *****************************************************/ $this->field_map[] = array( 'to_type' => 'topic', 'to_fieldname' => 'post_status', 'default' => 'publish' ); $this->field_map[] = array( 'to_type' => 'topic', 'to_fieldname' => 'comment_status', 'default' => 'closed' ); $this->field_map[] = array( 'to_type' => 'topic', 'to_fieldname' => 'ping_status', 'default' => 'closed' ); $this->field_map[] = array( 'to_type' => 'topic', 'to_fieldname' => 'post_type', 'default' => 'topic' ); /** Post Section ******************************************************/ $this->field_map[] = array( 'to_type' => 'reply', 'to_fieldname' => 'post_status', 'default' => 'publish' ); $this->field_map[] = array( 'to_type' => 'reply', 'to_fieldname' => 'comment_status', 'default' => 'closed' ); $this->field_map[] = array( 'to_type' => 'reply', 'to_fieldname' => 'ping_status', 'default' => 'closed' ); $this->field_map[] = array( 'to_type' => 'reply', 'to_fieldname' => 'post_type', 'default' => 'reply' ); /** User Section ******************************************************/ $this->field_map[] = array( 'to_type' => 'user', 'to_fieldname' => 'role', 'default' => get_option( 'default_role' ) ); } /** * Convert Forums */ public function convert_forums( $start = 1 ) { return $this->convert_table( 'forum', $start ); } /** * Convert Topics / Threads */ public function convert_topics( $start = 1 ) { return $this->convert_table( 'topic', $start ); } /** * Convert Posts */ public function convert_replies( $start = 1 ) { return $this->convert_table( 'reply', $start ); } /** * Convert Users */ public function convert_users( $start = 1 ) { return $this->convert_table( 'user', $start ); } /** * Convert Tags */ public function convert_tags( $start = 1 ) { return $this->convert_table( 'tags', $start ); } /** * Convert Table * * @param string to type * @param int Start row */ public function convert_table( $to_type, $start ) { // Are we usig a sync table, or postmeta? if ( $this->wpdb->get_var( "SHOW TABLES LIKE '" . $this->sync_table_name . "'" ) == $this->sync_table_name ) { $this->sync_table = true; } else { $this->sync_table = false; } // Set some defaults $has_insert = false; $from_tablename = ''; $field_list = $from_tables = $tablefield_array = array(); // Toggle Table Name based on $to_type (destination) switch ( $to_type ) { case 'user' : $tablename = $this->wpdb->users; break; case 'tags' : $tablename = ''; break; default : $tablename = $this->wpdb->posts; } // Get the fields from the destination table if ( !empty( $tablename ) ) { $tablefield_array = $this->get_fields( $tablename ); } /** Step 1 ************************************************************/ // Loop through the field maps, and look for to_type matches foreach ( $this->field_map as $item ) { // Yay a match, and we have a from table, too if ( ( $item['to_type'] == $to_type ) && !empty( $item['from_tablename'] ) ) { // $from_tablename was set from a previous loop iteration if ( ! empty( $from_tablename ) ) { // Doing some joining if ( !in_array( $item['from_tablename'], $from_tables ) && in_array( $item['join_tablename'], $from_tables ) ) { $from_tablename .= ' ' . $item['join_type'] . ' JOIN ' . $this->opdb->prefix . $item['from_tablename'] . ' AS ' . $item['from_tablename'] . ' ' . $item['join_expression']; } // $from_tablename needs to be set } else { $from_tablename = $item['from_tablename'] . ' AS ' . $item['from_tablename']; } // Specific FROM expression data used if ( !empty( $item['from_expression'] ) ) { // No 'WHERE' in expression if ( stripos( $from_tablename, "WHERE" ) === false ) { $from_tablename .= ' ' . $item['from_expression']; // 'WHERE' in expression, so replace with 'AND' } else { $from_tablename .= '. str_replace( WHERE, AND, $item[from_expression'] )''; } } // Add tablename and fieldname to arrays, formatted for querying $from_tables[] = $item['from_tablename']; $field_list[] = 'convert(' . $item['from_tablename'] . '.' . $item['from_fieldname'] . ' USING "' . $this->charset . '") AS ' . $item['from_fieldname']; } } /** Step 2 ************************************************************/ // We have a $from_tablename, so we want to get some data to convert if ( !empty( $from_tablename ) ) { // Get some data from the old forums $field_list = array_unique( $field_list ); $forum_query = 'SELECT ' . implode( ',', $field_list ) . ' FROM ' . $this->opdb->prefix . $from_tablename . ' LIMIT ' . $start . ', ' . $this->max_rows; $forum_array = $this->opdb->get_results( $forum_query, ARRAY_A ); // Set this query as the last one ran update_option( '_bbp_converter_query', $forum_query ); // Query returned some results if ( !empty( $forum_array ) ) { // Loop through results foreach ( (array) $forum_array as $forum ) { // Reset some defaults $insert_post = $insert_postmeta = $insert_data = array(); // Loop through field map, again... foreach ( $this->field_map as $row ) { // Types matchand to_fieldname is present. This means // we have some work to do here. if ( ( $row['to_type'] == $to_type ) && ! is_null( $row['to_fieldname'] ) ) { // This row has a destination that matches one of the // columns in this table. if ( in_array( $row['to_fieldname'], $tablefield_array ) ) { // Allows us to set default fields. if ( isset( $row['default'] ) ) { $insert_post[$row['to_fieldname']] = $row['default']; // Translates a field from the old forum. } elseif ( isset( $row['callback_method'] ) ) { if ( ( 'callback_userid' == $row['callback_method'] ) && empty( $_POST['_bbp_converter_convert_users'] ) ) { $insert_post[$row['to_fieldname']] = $forum[$row['from_fieldname']]; } else { $insert_post[$row['to_fieldname']] = call_user_func_array( array( $this, $row[callback_method] ), array( $forum[$row['from_fieldname']]'', $forum ) ); } // Maps the field from the old forum. } else { $insert_post[$row['to_fieldname']] = $forum[$row['from_fieldname']]; } // Destination field is not empty, so we might need // to do some extra work or set a default. } elseif ( !empty( $row['to_fieldname'] ) ) { // Allows us to set default fields. if ( isset( $row['default'] ) ) { $insert_postmeta[$row['to_fieldname']] = $row['default']; // Translates a field from the old forum. } elseif ( isset( $row['callback_method'] ) ) { if ( ( $row['callback_method'] == 'callback_userid' ) && ( 0 == $_POST['_bbp_converter_convert_users'] ) ) { $insert_postmeta[$row['to_fieldname']] = $forum[$row['from_fieldname']]; } else { $insert_postmeta[$row['to_fieldname']] = call_user_func_array( array( $this, $row[callback_method] ), array( $forum[$row['from_fieldname']]'', $forum ) ); } // Maps the field from the old forum. } else { $insert_postmeta[$row['to_fieldname']] = $forum[$row['from_fieldname']]; } } } } /** Step 3 ************************************************/ // Something to insert into the destination field if ( count( $insert_post ) > 0 || ( $to_type == 'tags' && count( $insert_postmeta ) > 0 ) ) { switch ( $to_type ) { /** New user **************************************/ case 'user': if ( username_exists( $insert_post['user_login'] ) ) { $insert_post['user_login'] = 'imported_' . $insert_post['user_login']; } if ( email_exists( $insert_post['user_email'] ) ) { $insert_post['user_email'] = 'imported_' . $insert_post['user_email']; } $post_id = wp_insert_user( $insert_post ); if ( is_numeric( $post_id ) ) { foreach ( $insert_postmeta as $key => $value ) { add_user_meta( $post_id, $key, $value, true ); if ( '_id' == substr( $key, -3 ) && ( true === $this->sync_table ) ) { $this->wpdb->insert( $this->sync_table_name, array( 'value_type' => 'user', 'value_id' => $post_id, 'meta_key' => $key, 'meta_value' => $value ) ); } } } break; /** New Topic-Tag *********************************/ case 'tags': $post_id = wp_set_object_terms( $insert_postmeta['objectid'], $insert_postmeta['name'], 'topic-tag', true ); $term = get_term_by( 'name', $insert_postmeta['name'], 'topic-tag'); if ( false !== $term ) { wp_update_term( $term->term_id, 'topic-tag', array( 'description' => $insert_postmeta[description']', slug => $insert_postmeta[slug'] ) )'; } break; /** Forum, Topic, Reply ***************************/ default: $post_id = wp_insert_post( $insert_post ); if ( is_numeric( $post_id ) ) { foreach ( $insert_postmeta as $key => $value ) { add_post_meta( $post_id, $key, $value, true ); // Forums need to save their old ID for group forum association if ( ( 'forum' == $to_type ) && ( '_bbp_forum_id' == $key ) ) add_post_meta( $post_id, '_bbp_old_forum_id', $value ); // Topics need an extra bit of metadata // to be keyed to the new post_id if ( ( 'topic' == $to_type ) && ( '_bbp_topic_id' == $key ) ) { // Update the live topic ID update_post_meta( $post_id, $key, $post_id ); // Save the old topic ID add_post_meta( $post_id, '_bbp_old_topic_id', $value ); if ( '_id' == substr( $key, -3 ) && ( true === $this->sync_table ) ) { $this->wpdb->insert( $this->sync_table_name, array( 'value_type' => 'post', 'value_id' => $post_id, 'meta_key' => '_bbp_topic_id', 'meta_value' => $post_id ) ); $this->wpdb->insert( $this->sync_table_name, array( 'value_type' => 'post', 'value_id' => $post_id, 'meta_key' => '_bbp_old_topic_id', 'meta_value' => $value ) ); } } elseif ( '_id' == substr( $key, -3 ) && ( true === $this->sync_table ) ) { $this->wpdb->insert( $this->sync_table_name, array( 'value_type' => 'post', 'value_id' => $post_id, 'meta_key' => $key, 'meta_value' => $value ) ); } // Replies need to save their old reply_to ID for hierarchical replies association if ( ( 'reply' == $to_type ) && ( '_bbp_reply_to' == $key ) ) { add_post_meta( $post_id, '_bbp_old_reply_to', $value ); } } } break; } $has_insert = true; } } } } return ! $has_insert; } /** * This method converts old forum heirarchy to new bbPress heirarchy. */ public function convert_forum_parents( $start ) { $has_update = false; if ( !empty( $this->sync_table ) ) { $query = 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_forum_parent_id" AND meta_value > 0 LIMIT ' . $start . ', ' . $this->max_rows; } else { $query = 'SELECT post_id AS value_id, meta_value FROM ' . $this->wpdb->postmeta . ' WHERE meta_key = "_bbp_forum_parent_id" AND meta_value > 0 LIMIT ' . $start . ', ' . $this->max_rows; } update_option( '_bbp_converter_query', $query ); $forum_array = $this->wpdb->get_results( $query ); foreach ( (array) $forum_array as $row ) { $parent_id = $this->callback_forumid( $row->meta_value ); $this->wpdb->query( 'UPDATE ' . $this->wpdb->posts . ' SET post_parent = "' . $parent_id . '" WHERE ID = "' . $row->value_id . '" LIMIT 1' ); $has_update = true; } return ! $has_update; } /** * This method converts old topic stickies to new bbPress stickies. * * @since bbPress (r) * * @uses WPDB $wpdb * @uses bbp_stick_topic() to set the imported topic as sticky * */ public function convert_topic_stickies( $start ) { $has_update = false; if ( !empty( $this->sync_table ) ) { $query = 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_old_sticky_status" AND meta_value = "sticky" LIMIT ' . $start . ', ' . $this->max_rows; } else { $query = 'SELECT post_id AS value_id, meta_value FROM ' . $this->wpdb->postmeta . ' WHERE meta_key = "_bbp_old_sticky_status" AND meta_value = "sticky" LIMIT ' . $start . ', ' . $this->max_rows; } update_option( '_bbp_converter_query', $query ); $sticky_array = $this->wpdb->get_results( $query ); foreach ( (array) $sticky_array as $row ) { bbp_stick_topic( $row->value_id ); $has_update = true; } return ! $has_update; } /** * This method converts old topic super stickies to new bbPress super stickies. * * @since bbPress (r) * * @uses WPDB $wpdb * @uses bbp_stick_topic() to set the imported topic as super sticky * */ public function convert_topic_super_stickies( $start ) { $has_update = false; if ( !empty( $this->sync_table ) ) { $query = 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_old_sticky_status" AND meta_value = "super-sticky" LIMIT ' . $start . ', ' . $this->max_rows; } else { $query = 'SELECT post_id AS value_id, meta_value FROM ' . $this->wpdb->postmeta . ' WHERE meta_key = "_bbp_old_sticky_status" AND meta_value = "super-sticky" LIMIT ' . $start . ', ' . $this->max_rows; } update_option( '_bbp_converter_query', $query ); $sticky_array = $this->wpdb->get_results( $query ); foreach ( (array) $sticky_array as $row ) { $super = true; bbp_stick_topic( $row->value_id, $super ); $has_update = true; } return ! $has_update; } /** * This method converts old reply_to post id to new bbPress reply_to post id. */ public function convert_reply_to_parents( $start ) { $has_update = false; if ( !empty( $this->sync_table ) ) { $query = 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_old_reply_to" AND meta_value > 0 LIMIT ' . $start . ', ' . $this->max_rows; } else { $query = 'SELECT post_id AS value_id, meta_value FROM ' . $this->wpdb->postmeta . ' WHERE meta_key = "_bbp_old_reply_to" AND meta_value > 0 LIMIT ' . $start . ', ' . $this->max_rows; } update_option( '_bbp_converter_query', $query ); $reply_to_array = $this->wpdb->get_results( $query ); foreach ( (array) $reply_to_array as $row ) { $reply_to = $this->callback_reply_to( $row->meta_value ); $this->wpdb->query( 'UPDATE ' . $this->wpdb->postmeta . ' SET meta_value = "' . $reply_to . '" WHERE meta_key = "_bbp_reply_to" AND post_id = "' . $row->value_id . '" LIMIT 1' ); $has_update = true; } return ! $has_update; } /** * This method deletes data from the wp database. */ public function clean( $start ) { $start = 0; $has_delete = false; /** Delete bbconverter topics/forums/posts ****************************/ if ( true === $this->sync_table ) { $query = 'SELECT value_id FROM ' . $this->sync_table_name . ' INNER JOIN ' . $this->wpdb->posts . ' ON(value_id = ID) WHERE meta_key LIKE "_bbp_%" AND value_type = "post" GROUP BY value_id ORDER BY value_id DESC LIMIT ' . $this->max_rows; } else { $query = 'SELECT post_id AS value_id FROM ' . $this->wpdb->postmeta . ' WHERE meta_key LIKE "_bbp_%" GROUP BY post_id ORDER BY post_id DESC LIMIT ' . $this->max_rows; } update_option( '_bbp_converter_query', $query ); $posts = $this->wpdb->get_results( $query, ARRAY_A ); if ( isset( $posts[0] ) && ! empty( $posts[0]['value_id'] ) ) { foreach ( (array) $posts as $value ) { wp_delete_post( $value['value_id'], true ); } $has_delete = true; } /** Delete bbconverter users ******************************************/ if ( true === $this->sync_table ) { $query = 'SELECT value_id FROM ' . $this->sync_table_name . ' INNER JOIN ' . $this->wpdb->users . ' ON(value_id = ID) WHERE meta_key = "_bbp_user_id" AND value_type = "user" LIMIT ' . $this->max_rows; } else { $query = 'SELECT user_id AS value_id FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_user_id" LIMIT ' . $this->max_rows; } update_option( '_bbp_converter_query', $query ); $users = $this->wpdb->get_results( $query, ARRAY_A ); if ( !empty( $users ) ) { foreach ( $users as $value ) { wp_delete_user( $value['value_id'] ); } $has_delete = true; } unset( $posts ); unset( $users ); return ! $has_delete; } /** * This method deletes passwords from the wp database. * * @param int Start row */ public function clean_passwords( $start ) { $has_delete = false; /** Delete bbconverter passwords **************************************/ $query = 'SELECT user_id, meta_value FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_password" LIMIT ' . $start . ', ' . $this->max_rows; update_option( '_bbp_converter_query', $query ); $bbconverter = $this->wpdb->get_results( $query, ARRAY_A ); if ( !empty( $bbconverter ) ) { foreach ( $bbconverter as $value ) { if ( is_serialized( $value['meta_value'] ) ) { $this->wpdb->query( 'UPDATE ' . $this->wpdb->users . ' ' . 'SET user_pass = "" ' . 'WHERE ID = "' . $value['user_id'] . '"' ); } else { $this->wpdb->query( 'UPDATE ' . $this->wpdb->users . ' ' . 'SET user_pass = "' . $value['meta_value'] . '" ' . 'WHERE ID = "' . $value['user_id'] . '"' ); $this->wpdb->query( 'DELETE FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_password" AND user_id = "' . $value['user_id'] . '"' ); } } $has_delete = true; } return ! $has_delete; } /** * This method implements the authentication for the different forums. * * @param string Unencoded password. */ abstract protected function authenticate_pass( $password, $hash ); /** * Info */ abstract protected function info(); /** * This method grabs appropriate fields from the table specified * * @param string The table name to grab fields from */ private function get_fields( $tablename ) { $rval = array(); $field_array = $this->wpdb->get_results( 'DESCRIBE ' . $tablename, ARRAY_A ); foreach ( $field_array as $field ) { $rval[] = $field['Field']; } if ( $tablename == $this->wpdb->users ) { $rval[] = 'role'; $rval[] = 'yim'; $rval[] = 'aim'; $rval[] = 'jabber'; } return $rval; } /** Callbacks *************************************************************/ /** * Run password through wp_hash_password() * * @param string $username * @param string $password */ public function callback_pass( $username, $password ) { $user = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT * FROM ' . $this->wpdb->users . ' WHERE user_login = "%s" AND user_pass = "" LIMIT 1', $username ) ); if ( !empty( $user ) ) { $usermeta = $this->wpdb->get_row( 'SELECT * FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_password" AND user_id = "' . $user->ID . '" LIMIT 1' ); if ( !empty( $usermeta ) ) { if ( $this->authenticate_pass( $password, $usermeta->meta_value ) ) { $this->wpdb->query( 'UPDATE ' . $this->wpdb->users . ' ' . 'SET user_pass = "' . wp_hash_password( $password ) . '" ' . 'WHERE ID = "' . $user->ID . '"' ); $this->wpdb->query( 'DELETE FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_password" AND user_id = "' . $user->ID . '"' ); } } } } /** * A mini cache system to reduce database calls to forum ID's * * @param string $field * @return string */ private function callback_forumid( $field ) { if ( !isset( $this->map_forumid[$field] ) ) { if ( !empty( $this->sync_table ) ) { $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_forum_id" AND meta_value = "%s" LIMIT 1', $field ) ); } else { $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT post_id AS value_id FROM ' . $this->wpdb->postmeta . ' WHERE meta_key = "_bbp_forum_id" AND meta_value = "%s" LIMIT 1', $field ) ); } if ( !is_null( $row ) ) { $this->map_forumid[$field] = $row->value_id; } else { $this->map_forumid[$field] = 0; } } return $this->map_forumid[$field]; } /** * A mini cache system to reduce database calls to topic ID's * * @param string $field * @return string */ private function callback_topicid( $field ) { if ( !isset( $this->map_topicid[$field] ) ) { if ( !empty( $this->sync_table ) ) { $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_old_topic_id" AND meta_value = "%s" LIMIT 1', $field ) ); } else { $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT post_id AS value_id FROM ' . $this->wpdb->postmeta . ' WHERE meta_key = "_bbp_old_topic_id" AND meta_value = "%s" LIMIT 1', $field ) ); } if ( !is_null( $row ) ) { $this->map_topicid[$field] = $row->value_id; } else { $this->map_topicid[$field] = 0; } } return $this->map_topicid[$field]; } /** * A mini cache system to reduce database calls to reply_to post id. * * @param string $field * @return string */ private function callback_reply_to( $field ) { if ( !isset( $this->map_reply_to[$field] ) ) { if ( !empty( $this->sync_table ) ) { $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_post_id" AND meta_value = "%s" LIMIT 1', $field ) ); } else { $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT post_id AS value_id FROM ' . $this->wpdb->postmeta . ' WHERE meta_key = "_bbp_post_id" AND meta_value = "%s" LIMIT 1', $field ) ); } if ( !is_null( $row ) ) { $this->map_reply_to[$field] = $row->value_id; } else { $this->map_reply_to[$field] = 0; } } return $this->map_reply_to[$field]; } /** * A mini cache system to reduce database calls to user ID's * * @param string $field * @return string */ private function callback_userid( $field ) { if ( !isset( $this->map_userid[$field] ) ) { if ( !empty( $this->sync_table ) ) { $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT value_id, meta_value FROM ' . $this->sync_table_name . ' WHERE meta_key = "_bbp_user_id" AND meta_value = "%s" LIMIT 1', $field ) ); } else { $row = $this->wpdb->get_row( $this->wpdb->prepare( 'SELECT user_id AS value_id FROM ' . $this->wpdb->usermeta . ' WHERE meta_key = "_bbp_user_id" AND meta_value = "%s" LIMIT 1', $field ) ); } if ( !is_null( $row ) ) { $this->map_userid[$field] = $row->value_id; } else { if ( !empty( $_POST['_bbp_converter_convert_users'] ) && ( $_POST['_bbp_converter_convert_users'] == 1 ) ) { $this->map_userid[$field] = 0; } else { $this->map_userid[$field] = $field; } } } return $this->map_userid[$field]; } /** * A mini cache system to reduce database calls map topics ID's to forum ID's * * @param string $field * @return string */ private function callback_topicid_to_forumid( $field ) { $topicid = $this->callback_topicid( $field ); if ( empty( $topicid ) ) { $this->map_topicid_to_forumid[$topicid] = 0; } elseif ( ! isset( $this->map_topicid_to_forumid[$topicid] ) ) { $row = $this->wpdb->get_row( 'SELECT post_parent FROM ' . $this->wpdb->posts . ' WHERE ID = "' . $topicid . '" LIMIT 1' ); if ( !is_null( $row ) ) { $this->map_topicid_to_forumid[$topicid] = $row->post_parent; } else { $this->map_topicid_to_forumid[$topicid] = 0; } } return $this->map_topicid_to_forumid[$topicid]; } protected function callback_slug( $field ) { return sanitize_title( $field ); } protected function callback_negative( $field ) { if ( $field < 0 ) { return 0; } else { return $field; } } protected function callback_html( $field ) { require_once( bbpress()->admin->admin_dir . 'parser.php' ); $bbcode = BBCode::getInstance(); return html_entity_decode( $bbcode->Parse( $field ) ); } protected function callback_null( $field ) { if ( is_null( $field ) ) { return ''; } else { return $field; } } protected function callback_datetime( $field ) { if ( is_numeric( $field ) ) { return date( 'Y-m-d H:i:s', $field ); } else { return date( 'Y-m-d H:i:s', strtotime( $field ) ); } } } /** * This is a function that is purposely written to look like a "new" statement. * It is basically a dynamic loader that will load in the platform conversion * of your choice. * * @param string $platform Name of valid platform class. */ function bbp_new_converter( $platform ) { $found = false; if ( $curdir = opendir( bbpress()->admin->admin_dir . 'converters/' ) ) { while ( $file = readdir( $curdir ) ) { if ( stristr( $file, '.php' ) && stristr( $file, 'index' ) === FALSE ) { $file = preg_replace( '/.php/', '', $file ); if ( $platform == $file ) { $found = true; continue; } } } closedir( $curdir ); } if ( true === $found ) { require_once( bbpress()->admin->admin_dir . 'converters/' . $platform . '.php' ); return new $platform; } else { return null; } }In reply to: Import Hung?I was importing from my Vbulletin 4 and it went through converting topics, then it started converting tags and hung about 12,900. Is this a known bug? What’s the best way to do this over without losing the imported content and without taking risks of missing content not being imported initially on the hang up?
I’m a day late and a dollar short, but I thought I’d answer this for anyone else experiencing a similar issue.
vB4 tables originally used latin1_swedish_ci Collation, so when they’re imported certain characters don’t import properly causing the import to hang.
If the bbpress converter hangs up you can see what the last query was running. go to your WordPress MySQL Database:
Find the wp_options table (note that your table prefix may be different)
1. Shut off the importer (hit the STOP Button)
2. Go to the wp_options table & do a search for %converter% – it will return 3 tablesa. _bbp_converter_query b. _bbp_converter_start c. _bbp_converter_stepSelect both _bbp_converter_start AND _bbp_converter_query and click edit. Look to see where the tags got hung up in the option value field-
(here’s an example from my own database):
SELECT convert(tagcontent.contentid USING "utf8mb4") AS contentid,convert(tagcontent.tagid USING "utf8mb4") AS tagid,convert(tag.tagtext USING "utf8mb4") AS tagtext FROM tagcontent AS tagcontent INNER JOIN tag AS tag USING (tagid) LIMIT 2750, 50In this case, it’s getting hung while imported tags 2750, 50 rows at a time.
change the values to the next bracket (but don’t alter any other data in the fields,:
_bbp_converter_start 2800 _bbp_converter_query 2800and hit save
so now the option_value of the _bbp_converter_query looks like this:
SELECT convert(tagcontent.contentid USING "utf8mb4") AS contentid,convert(tagcontent.tagid USING "utf8mb4") AS tagid,convert(tag.tagtext USING "utf8mb4") AS tagtext FROM tagcontent AS tagcontent INNER JOIN tag AS tag USING (tagid) LIMIT 2800, 100(note the new LIMIT number)
Then hit the START button on your Converter. IF, for some odd reason it doesn’t automatically restart, don’t freak out. Just hit the STOP button again, open a new page for the import
http://YOURDOMAINHERE.com/wp-admin/tools.php?page=bbp-converterRe-enter your data, with the rows limit at 100, delay time the same as before & convert users STILL
Checked (if it was to begin with) DO NOT CHECK START OVER or PREVIOUS IMPORT.
Hit START and it will pick up where it left off.
Alternatively, you can
2. remove the offending tags from vbulletin –> /admincp/tag.php there are 45 per pg
3. update thread counters
4. Start the importer, see if it updates
5. If so- you’re all set *until next time* (and there WILL be a Next time!)In reply to: vbulletin import…failsWhen it hangs it says something like: Importing Discussions (x-y) then all of a sudden it just prints “-” every 5 seconds or so and nothing is being imported,
Unfortunately this reply comes far too late to help the OP, but hopefully, this will help someone else down the road.
First, before you begin your transfer of vBulletin, add the following lines to the top of your wp-config.php just below <?php
define( 'WP_DEBUG', true ); define( 'WP_DEBUG_LOG', true ); define( 'WP_DEBUG_DISPLAY', false );This will create a debug log of any errors you encounter, you can access the log by visiting
https://YOURDOMAINHERE.com/wp-content/debug.logkeep in mind that if your wp install is within another folder, you’ll have to alter the path in the url to access the log.
Next, once you’ve encountered an error, check your debug log, if the error isn’t listed, you can go to your MySQL tables.
Hit STOP on the Importer. (Don’t navigate from the page, just hit the stop button).
Go to the wp_options table (might be slightly different prefix depending on your own database settings) and do a search for %converter%You will find 3 rows within the wp_options table
a. _bbp_converter_query
b. _bbp_converter_start
c. _bbp_converter_stepThe Step will show you which step # your install is hung up on. The Converter query will tell you precisely which line and the start is what tells the bbp_converter where you last left off.
View the steps in your wp-content>plugins>bbpress>includes>admin>converter.php file
Step 1 (about line 339)
Step 2 about line 360, etcMost often the issue is due to character collation.
In reply to: I’m trying to fix some coding in importThank you for the fix, It’s appreciated.
Oops! I think that’s the original WP code itself. Anyway, I found another code to fix in bbPress. Pls let me know if I should post it.
This goes without saying, you should ALWAYS share a fix, you never know who’s going to be searching for it, sometimes YEARS after you find it.
Viewing 18 replies - 1 through 18 (of 18 total)
