<?php

/**

 * bbPress Admin Tools Page

 *

 * @package bbPress

 * @subpackage Administration

 */

// Exit if accessed directly

if ( !defined( 'ABSPATH' ) ) exit;

/** Repair ********************************************************************/

/**

 * Admin repair page

 *

 * @since bbPress (r2613)

 *

 * @uses bbp_admin_repair_list() To get the recount list

 * @uses check_admin_referer() To verify the nonce and the referer

 * @uses wp_cache_flush() To flush the cache

 * @uses do_action() Calls 'admin_notices' to display the notices

 * @uses screen_icon() To display the screen icon

 * @uses wp_nonce_field() To add a hidden nonce field

 */

function bbp_admin_repair() {

?>

	<div class="wrap">

		<?php screen_icon( 'tools' ); ?>

		<h2 class="nav-tab-wrapper"><?php bbp_tools_admin_tabs( __( 'Repair Forums', 'bbpress' ) ); ?></h2>

		<p><?php _e( 'bbPress keeps track of relationships between forums, topics, replies, and topic tags, and users. Occasionally these relationships become out of sync, most often after an import or migration. Use the tools below to manually recalculate these relationships.', 'bbpress' ); ?></p>

		<p class="description"><?php _e( 'Some of these tools create substantial database overhead. Avoid running more than 1 repair job at a time.', 'bbpress' ); ?></p>

		<form class="settings" method="post" action="">

			<table class="form-table">

				<tbody>

					<tr valign="top">

						<th scope="row"><?php _e( 'Relationships to Repair:', 'bbpress' ) ?></th>

						<td>

							<fieldset>

								<legend class="screen-reader-text"><span><?php _e( 'Repair', 'bbpress' ) ?></span></legend>

								<?php foreach ( bbp_admin_repair_list() as $item ) : ?>

									<label><input type="checkbox" class="checkbox" name="<?php echo esc_attr( $item[0] ) . '" id="' . esc_attr( str_replace( '_', '-', $item[0] ) ); ?>" value="1" /> <?php echo esc_html( $item[1] ); ?></label><br />

								<?php endforeach; ?>

							</fieldset>

						</td>

					</tr>

				</tbody>

			</table>

			<fieldset class="submit">

				<input class="button-primary" type="submit" name="submit" value="<?php esc_attr_e( 'Repair Items', 'bbpress' ); ?>" />

				<?php wp_nonce_field( 'bbpress-do-counts' ); ?>

			</fieldset>

		</form>

	</div>

<?php

}

/**

 * Handle the processing and feedback of the admin tools page

 *

 * @since bbPress (r2613)

 *

 * @uses bbp_admin_repair_list() To get the recount list

 * @uses check_admin_referer() To verify the nonce and the referer

 * @uses wp_cache_flush() To flush the cache

 * @uses do_action() Calls 'admin_notices' to display the notices

 */

function bbp_admin_repair_handler() {

	if ( 'post' == strtolower( $_SERVER['REQUEST_METHOD'] ) ) {

		check_admin_referer( 'bbpress-do-counts' );

		// Stores messages

		$messages = array();

		wp_cache_flush();

		foreach ( (array) bbp_admin_repair_list() as $item ) {

			if ( isset( $item[2] ) && isset( $_POST[$item[0]] ) && 1 == $_POST[$item[0]] && is_callable( $item[2] ) ) {

				$messages[] = call_user_func( $item[2] );

			}

		}

		if ( count( $messages ) ) {

			foreach ( $messages as $message ) {

				bbp_admin_tools_feedback( $message[1] );

			}

		}

	}

}

/**

 * Assemble the admin notices

 *

 * @since bbPress (r2613)

 *

 * @param string|WP_Error $message A message to be displayed or {@link WP_Error}

 * @param string $class Optional. A class to be added to the message div

 * @uses WP_Error::get_error_messages() To get the error messages of $message

 * @uses add_action() Adds the admin notice action with the message HTML

 * @return string The message HTML

 */

function bbp_admin_tools_feedback( $message, $class = false ) {

	if ( is_string( $message ) ) {

		$message = '<p>' . $message . '</p>';

		$class = $class ? $class : 'updated';

	} elseif ( is_wp_error( $message ) ) {

		$errors = $message->get_error_messages();

		switch ( count( $errors ) ) {

			case 0:

				return false;

				break;

			case 1:

				$message = '<p>' . $errors[0] . '</p>';

				break;

			default:

				$message = '<ul>' . "\n\t" . '<li>' . join( '</li>' . "\n\t" . '<li>', $errors ) . '</li>' . "\n" . '</ul>';

				break;

		}

		$class = $class ? $class : 'error';

	} else {

		return false;

	}

	$message = '<div id="message" class="' . esc_attr( $class ) . '">' . $message . '</div>';

	$message = str_replace( "'", "\'", $message );

	$lambda  = create_function( '', "echo '$message';" );

	add_action( 'admin_notices', $lambda );

	return $lambda;

}

/**

 * Get the array of the repair list

 *

 * @since bbPress (r2613)

 *

 * @uses apply_filters() Calls 'bbp_repair_list' with the list array

 * @return array Repair list of options

 */

function bbp_admin_repair_list() {

	$repair_list = array(

		0  => array( 'bbp-sync-topic-meta',        __( 'Recalculate the parent topic for each post',          'bbpress' ), 'bbp_admin_repair_topic_meta'               ),

		5  => array( 'bbp-sync-forum-meta',        __( 'Recalculate the parent forum for each post',          'bbpress' ), 'bbp_admin_repair_forum_meta'               ),

		10 => array( 'bbp-sync-forum-visibility',  __( 'Recalculate private and hidden forums',               'bbpress' ), 'bbp_admin_repair_forum_visibility'         ),

		15 => array( 'bbp-sync-all-topics-forums', __( 'Recalculate last activity in each topic and forum',   'bbpress' ), 'bbp_admin_repair_freshness'                ),

		20 => array( 'bbp-group-forums',           __( 'Repair BuddyPress Group Forum relationships',         'bbpress' ), 'bbp_admin_repair_group_forum_relationship' ),

		25 => array( 'bbp-forum-topics',           __( 'Count topics in each forum',                          'bbpress' ), 'bbp_admin_repair_forum_topic_count'        ),

		30 => array( 'bbp-forum-replies',          __( 'Count replies in each forum',                         'bbpress' ), 'bbp_admin_repair_forum_reply_count'        ),

		35 => array( 'bbp-topic-replies',          __( 'Count replies in each topic',                         'bbpress' ), 'bbp_admin_repair_topic_reply_count'        ),

		40 => array( 'bbp-topic-voices',           __( 'Count voices in each topic',                          'bbpress' ), 'bbp_admin_repair_topic_voice_count'        ),

		45 => array( 'bbp-topic-hidden-replies',   __( 'Count spammed & trashed replies in each topic',       'bbpress' ), 'bbp_admin_repair_topic_hidden_reply_count' ),

		50 => array( 'bbp-user-replies',           __( 'Count topics for each user',                          'bbpress' ), 'bbp_admin_repair_user_topic_count'         ),

		55 => array( 'bbp-user-topics',            __( 'Count replies for each user',                         'bbpress' ), 'bbp_admin_repair_user_reply_count'         ),

		60 => array( 'bbp-user-favorites',         __( 'Remove trashed topics from user favorites',           'bbpress' ), 'bbp_admin_repair_user_favorites'           ),

		65 => array( 'bbp-user-subscriptions',     __( 'Remove trashed topics from user subscriptions',       'bbpress' ), 'bbp_admin_repair_user_subscriptions'       ),

		70 => array( 'bbp-user-role-map',          __( 'Remap existing users to default forum roles',         'bbpress' ), 'bbp_admin_repair_user_roles'               )

	);

	ksort( $repair_list );

	return (array) apply_filters( 'bbp_repair_list', $repair_list );

}

/**

 * Recount topic replies

 *

 * @since bbPress (r2613)

 *

 * @uses bbp_get_reply_post_type() To get the reply post type

 * @uses wpdb::query() To run our recount sql queries

 * @uses is_wp_error() To check if the executed query returned {@link WP_Error}

 * @return array An array of the status code and the message

 */

function bbp_admin_repair_topic_reply_count() {

	global $wpdb;

	$statement = __( 'Counting the number of replies in each topic… %s', 'bbpress' );

	$result    = __( 'Failed!', 'bbpress' );

	$sql_delete = "DELETE FROM `{$wpdb->postmeta}` WHERE `meta_key` = '_bbp_reply_count';";

	if ( is_wp_error( $wpdb->query( $sql_delete ) ) )

		return array( 1, sprintf( $statement, $result ) );

	// Post types and status

	$tpt = bbp_get_topic_post_type();

	$rpt = bbp_get_reply_post_type();

	$pps = bbp_get_public_status_id();

	$cps = bbp_get_closed_status_id();

	$sql = "INSERT INTO `{$wpdb->postmeta}` (`post_id`, `meta_key`, `meta_value`) (

			SELECT `topics`.`ID` AS `post_id`, '_bbp_reply_count' AS `meta_key`, COUNT(`replies`.`ID`) As `meta_value`

				FROM `{$wpdb->posts}` AS `topics`

					LEFT JOIN `{$wpdb->posts}` as `replies`

						ON  `replies`.`post_parent` = `topics`.`ID`

						AND `replies`.`post_status` = '{$pps}'

						AND `replies`.`post_type`   = '{$rpt}'

				WHERE `topics`.`post_type` = '{$tpt}'

					AND `topics`.`post_status` IN ( '{$pps}', '{$cps}' )

				GROUP BY `topics`.`ID`);";

	if ( is_wp_error( $wpdb->query( $sql ) ) )

		return array( 2, sprintf( $statement, $result ) );

	return array( 0, sprintf( $statement, __( 'Complete!', 'bbpress' ) ) );

}

/**

 * Recount topic voices

 *

 * @since bbPress (r2613)

 *

 * @uses bbp_get_reply_post_type() To get the reply post type

 * @uses wpdb::query() To run our recount sql queries

 * @uses is_wp_error() To check if the executed query returned {@link WP_Error}

 * @return array An array of the status code and the message

 */

function bbp_admin_repair_topic_voice_count() {

	global $wpdb;

	$statement = __( 'Counting the number of voices in each topic… %s', 'bbpress' );

	$result    = __( 'Failed!', 'bbpress' );

	$sql_delete = "DELETE FROM `{$wpdb->postmeta}` WHERE `meta_key` = '_bbp_voice_count';";

	if ( is_wp_error( $wpdb->query( $sql_delete ) ) )

		return array( 1, sprintf( $statement, $result ) );

	// Post types and status

	$tpt = bbp_get_topic_post_type();

	$rpt = bbp_get_reply_post_type();

	$pps = bbp_get_public_status_id();

	$cps = bbp_get_closed_status_id();

	$sql = "INSERT INTO `{$wpdb->postmeta}` (`post_id`, `meta_key`, `meta_value`) (

			SELECT `postmeta`.`meta_value`, '_bbp_voice_count', COUNT(DISTINCT `post_author`) as `meta_value`

				FROM `{$wpdb->posts}` AS `posts`

				LEFT JOIN `{$wpdb->postmeta}` AS `postmeta`

					ON `posts`.`ID` = `postmeta`.`post_id`

					AND `postmeta`.`meta_key` = '_bbp_topic_id'

				WHERE `posts`.`post_type` IN ( '{$tpt}', '{$rpt}' )

					AND `posts`.`post_status` IN ( '{$pps}', '{$cps}' )

					AND `posts`.`post_author` != '0'

				GROUP BY `postmeta`.`meta_value`);";

	if ( is_wp_error( $wpdb->query( $sql ) ) )

		return array( 2, sprintf( $statement, $result ) );

	return array( 0, sprintf( $statement, __( 'Complete!', 'bbpress' ) ) );

}

/**

 * Recount topic hidden replies (spammed/trashed)

 *

 * @since bbPress (r2747)

 *

 * @uses wpdb::query() To run our recount sql queries

 * @uses is_wp_error() To check if the executed query returned {@link WP_Error}

 * @return array An array of the status code and the message

 */

function bbp_admin_repair_topic_hidden_reply_count() {

	global $wpdb;

	$statement = __( 'Counting the number of spammed and trashed replies in each topic… %s', 'bbpress' );

	$result    = __( 'Failed!', 'bbpress' );

	$sql_delete = "DELETE FROM `{$wpdb->postmeta}` WHERE `meta_key` = '_bbp_reply_count_hidden';";

	if ( is_wp_error( $wpdb->query( $sql_delete ) ) )

		return array( 1, sprintf( $statement, $result ) );

	$sql = "INSERT INTO `{$wpdb->postmeta}` (`post_id`, `meta_key`, `meta_value`) (SELECT `post_parent`, '_bbp_reply_count_hidden', COUNT(`post_status`) as `meta_value` FROM `{$wpdb->posts}` WHERE `post_type` = '" . bbp_get_reply_post_type() . "' AND `post_status` IN ( '" . join( "','", array( bbp_get_trash_status_id(), bbp_get_spam_status_id() ) ) . "') GROUP BY `post_parent`);";

	if ( is_wp_error( $wpdb->query( $sql ) ) )

		return array( 2, sprintf( $statement, $result ) );

	return array( 0, sprintf( $statement, __( 'Complete!', 'bbpress' ) ) );

}

/**

 * Repair group forum ID mappings after a bbPress 1.1 to bbPress 2.2 conversion

 *

 * @since bbPress (r4395)

 *

 * @global WPDB $wpdb

 * @return If a wp_error() occurs and no converted forums are found

 */

function bbp_admin_repair_group_forum_relationship() {

	global $wpdb;

	$statement = __( 'Repairing BuddyPress group-forum relationships… %s', 'bbpress' );

	$g_count     = 0;

	$f_count     = 0;

	// Copy the BuddyPress filter here, incase BuddyPress is not active

	$prefix    = apply_filters( 'bp_core_get_table_prefix', $wpdb->base_prefix );

	$tablename = $prefix . 'bp_groups_groupmeta';

	// Get the converted forum IDs

	$forum_ids = $wpdb->query( "SELECT `forum`.`ID`, `forummeta`.`meta_value`

								FROM `{$wpdb->posts}` AS `forum`

									LEFT JOIN `{$wpdb->postmeta}` AS `forummeta`

										ON `forum`.`ID` = `forummeta`.`post_id`

										AND `forummeta`.`meta_key` = '_bbp_old_forum_id'

								WHERE `forum`.`post_type` = 'forum'

								GROUP BY `forum`.`ID`;" );

	// Bail if forum IDs returned an error

	if ( is_wp_error( $forum_ids ) || empty( $wpdb->last_result ) )

		return array( 2, sprintf( $statement, __( 'Failed!', 'bbpress' ) ) );

	// Stash the last results

	$results = $wpdb->last_result;

	// Update each group forum

	foreach ( $results as $group_forums ) {

		// Only update if is a converted forum

		if ( ! isset( $group_forums->meta_value ) )

			continue;

		// Attempt to update group meta

		$updated = $wpdb->query( "UPDATE `{$tablename}` SET `meta_value` = '{$group_forums->ID}' WHERE `meta_key` = 'forum_id' AND `meta_value` = '{$group_forums->meta_value}';" );

		// Bump the count

		if ( !empty( $updated ) && ! is_wp_error( $updated ) ) {

			++$g_count;

		}

		// Update group's forum metadata

		$group_id = (int) $wpdb->get_var( "SELECT `group_id` FROM `{$tablename}` WHERE `meta_key` = 'forum_id' AND `meta_value` = '{$group_forums->ID}';" );

		if ( !empty( $group_id ) ) {

			update_post_meta( $group_forums->ID, '_bbp_group_ids', array( $group_id ) );

			++$f_count;

		}

	}

	// Make some logical guesses at the old group root forum

	if ( function_exists( 'bp_forums_parent_forum_id' ) ) {

		$old_default_forum_id = bp_forums_parent_forum_id();

	} elseif ( defined( 'BP_FORUMS_PARENT_FORUM_ID' ) ) {

		$old_default_forum_id = (int) BP_FORUMS_PARENT_FORUM_ID;

	} else {

		$old_default_forum_id = 1;

	}

	// Try to get the group root forum

	$posts = get_posts( array(

		'post_type'   => bbp_get_forum_post_type(),

		'meta_key'    => '_bbp_old_forum_id',

		'meta_value'  => $old_default_forum_id,

		'numberposts' => 1

	) );

	// Found the group root forum

	if ( ! empty( $posts ) ) {

		// Rename 'Default Forum'  since it's now visible in sitewide forums

		if ( 'Default Forum' == $posts[0]->post_title ) {

			wp_update_post( array(

				'ID'         => $posts[0]->ID,

				'post_title' => __( 'Group Forums', 'bbpress' ),

			) );

		}

		// Update the group forums root metadata

		update_option( '_bbp_group_forums_root_id', $posts[0]->ID );

	}

	// Complete results

	$result = sprintf( __( 'Complete! %s groups updated; %s forums updated.', 'bbpress' ), bbp_number_format( $g_count ), bbp_number_format( $f_count ) );

	return array( 0, sprintf( $statement, $result ) );

}

/**

 * Recount forum topics

 *

 * @since bbPress (r2613)

 *

 * @uses wpdb::query() To run our recount sql queries

 * @uses is_wp_error() To check if the executed query returned {@link WP_Error}

 * @uses bbp_get_forum_post_type() To get the forum post type

 * @uses get_posts() To get the forums

 * @uses bbp_update_forum_topic_count() To update the forum topic count

 * @return array An array of the status code and the message

 */

function bbp_admin_repair_forum_topic_count() {

	global $wpdb;

	$statement = __( 'Counting the number of topics in each forum… %s', 'bbpress' );

	$result    = __( 'Failed!', 'bbpress' );