File "upgrade.php"
Full Path: /home/jlklyejr/public_html/wp-content/test/test/test/wp-content/plugins/bbpress/includes/admin/tools/upgrade.php
File size: 23.27 KB
MIME-type: text/x-php
Charset: utf-8
<?php
/**
* bbPress Admin Upgrade Functions
*
* @package bbPress
* @subpackage Administration
*/
// Exit if accessed directly
defined( 'ABSPATH' ) || exit;
/**
* Admin repair page
*
* @since 2.6.0 bbPress (r6278)
*
*/
function bbp_admin_upgrade_page() {
// Get the registered upgrade tools
$tools = bbp_admin_repair_list( 'upgrade' );
// Orderby
$orderby = ! empty( $_GET['orderby'] )
? sanitize_key( $_GET['orderby'] )
: 'priority';
// Order
$order = ! empty( $_GET['order'] ) && in_array( strtolower( $_GET['order'] ), array( 'asc', 'desc' ), true )
? strtolower( $_GET['order'] )
: 'asc';
// New order
$new_order = ( 'desc' === $order )
? 'asc'
: 'desc'; ?>
<div class="wrap">
<h1 class="wp-heading-inline"><?php esc_html_e( 'Forum Tools', 'bbpress' ); ?></h1>
<hr class="wp-header-end">
<h2 class="nav-tab-wrapper"><?php bbp_tools_admin_tabs( 'bbp-upgrade' ); ?></h2>
<p><?php esc_html_e( 'As bbPress improves, occasionally database upgrades are required but some forums are too large to upgrade automatically. Use the tools below to manually run upgrade routines.', 'bbpress' ); ?></p>
<p class="description"><?php esc_html_e( 'Some of these tools create substantial database overhead. Use caution when running more than 1 upgrade at a time.', 'bbpress' ); ?></p>
<?php bbp_admin_repair_tool_status_filters(); ?>
<form class="settings" method="get" action="">
<?php bbp_admin_repair_list_search_form(); ?>
<input type="hidden" name="page" value="bbp-upgrade" />
<?php wp_nonce_field( 'bbpress-do-counts' ); ?>
<div class="tablenav top">
<div class="alignleft actions bulkactions">
<label for="bulk-action-selector-top" class="screen-reader-text"><?php esc_html_e( 'Select bulk action', 'bbpress' ); ?></label>
<select name="action" id="bulk-action-selector-top">
<option value="" selected="selected"><?php esc_html_e( 'Bulk Actions', 'bbpress' ); ?></option>
<option value="run" class="hide-if-no-js"><?php esc_html_e( 'Run', 'bbpress' ); ?></option>
</select>
<input type="submit" id="doaction" class="button action" value="<?php esc_attr_e( 'Apply', 'bbpress' ); ?>">
</div>
<div class="alignleft actions">
<?php bbp_admin_repair_list_components_filter(); ?>
<?php bbp_admin_repair_list_versions_filter(); ?>
<input type="submit" name="filter_action" id="components-submit" class="button" value="<?php esc_html_e( 'Filter', 'bbpress' ); ?>">
</div>
<br class="clear">
</div>
<table class="wp-list-table widefat striped posts">
<thead>
<tr>
<td id="cb" class="manage-column column-cb check-column">
<label class="screen-reader-text" for="cb-select-all-1">
<?php esc_html_e( 'Select All', 'bbpress' ); ?>
</label>
<input id="cb-select-all-1" type="checkbox">
</td>
<th scope="col" id="description" class="manage-column column-primary column-description sortable <?php echo ( 'priority' === $orderby ) ? esc_attr( $order ) : 'asc'; ?>">
<a href="<?php echo esc_url( bbp_get_admin_repair_tool_page_url( array(
'orderby' => 'priority',
'order' => $new_order
) ) ); ?>"><span><?php esc_html_e( 'Description', 'bbpress' ); ?></span><span class="sorting-indicator"></span>
</a>
</th>
<th scope="col" id="version" class="manage-column column-version sortable <?php echo ( 'version' === $orderby ) ? esc_attr( $order ) : 'asc'; ?>">
<a href="<?php echo esc_url( bbp_get_admin_repair_tool_page_url( array(
'orderby' => 'version',
'order' => $new_order
) ) ); ?>"><span><?php esc_html_e( 'Version', 'bbpress' ); ?></span><span class="sorting-indicator"></span>
</a>
</th>
<th scope="col" id="components" class="manage-column column-components"><?php esc_html_e( 'Components', 'bbpress' ); ?></th>
<th scope="col" id="overhead" class="manage-column column-overhead sortable <?php echo ( 'overhead' === $orderby ) ? esc_attr( $order ) : 'asc'; ?>">
<a href="<?php echo esc_url( bbp_get_admin_repair_tool_page_url( array(
'orderby' => 'overhead',
'order' => $new_order
) ) ); ?>"><span><?php esc_html_e( 'Overhead', 'bbpress' ); ?></span><span class="sorting-indicator"></span>
</a>
</th>
</tr>
</thead>
<tbody id="the-list">
<?php if ( ! empty( $tools ) ) : ?>
<?php foreach ( $tools as $item ) : ?>
<tr id="bbp-repair-tools" class="inactive">
<th scope="row" class="check-column">
<label class="screen-reader-text" for="<?php echo esc_attr( str_replace( '_', '-', $item['id'] ) ); ?>"></label>
<input type="checkbox" name="checked[]" value="<?php echo esc_attr( $item['id'] ); ?>" id="<?php echo esc_attr( str_replace( '_', '-', $item['id'] ) ); ?>">
</th>
<td class="bbp-tool-title column-primary column-description" data-colname="<?php esc_html_e( 'Description', 'bbpress' ); ?>">
<strong><?php echo esc_html( $item['title'] ); ?></strong><?php
// Optional description
if ( ! empty( $item['description'] ) ) :
echo '<p class="description">' . esc_html( $item['description'] ) . '</p>';
endif;
?><div class="row-actions hide-if-no-js">
<span class="run">
<a href="<?php bbp_admin_repair_tool_run_url( $item ); ?>" aria-label="<?php printf( esc_html__( 'Run %s', 'bbpress' ), $item['title'] ); ?>" id="<?php echo esc_attr( $item['id'] ); ?>" ><?php esc_html_e( 'Run', 'bbpress' ); ?></a>
</span>
</div>
<button type="button" class="toggle-row">
<span class="screen-reader-text"><?php esc_html_e( 'Show more details', 'bbpress' ); ?></span>
</button>
</td>
<td class="column-version desc" data-colname="<?php esc_html_e( 'Version', 'bbpress' ); ?>">
<div class="bbp-tool-version">
<?php echo implode( ', ', bbp_get_admin_repair_tool_version( $item ) ); ?>
</div>
</td>
<td class="column-components desc" data-colname="<?php esc_html_e( 'Components', 'bbpress' ); ?>">
<div class="bbp-tool-components">
<?php echo implode( ', ', bbp_get_admin_repair_tool_components( $item ) ); ?>
</div>
</td>
<td class="column-overhead desc" data-colname="<?php esc_html_e( 'Overhead', 'bbpress' ); ?>">
<div class="bbp-tool-overhead">
<?php echo implode( ', ', bbp_get_admin_repair_tool_overhead( $item ) ); ?>
</div>
</td>
</tr>
<?php endforeach; ?>
<?php else : ?>
<tr>
<td colspan="4">
<?php esc_html_e( 'No repair tools match this criteria.', 'bbpress' ); ?>
</td>
</tr>
<?php endif; ?>
</tbody>
<tfoot>
<tr>
<td class="manage-column column-cb check-column">
<label class="screen-reader-text" for="cb-select-all-2">
<?php esc_html_e( 'Select All', 'bbpress' ); ?>
</label>
<input id="cb-select-all-2" type="checkbox">
</td>
<th scope="col" class="manage-column column-primary column-description"><?php esc_html_e( 'Description', 'bbpress' ); ?></th>
<th scope="col" class="manage-column column-version"><?php esc_html_e( 'Version', 'bbpress' ); ?></th>
<th scope="col" class="manage-column column-components"><?php esc_html_e( 'Components', 'bbpress' ); ?></th>
<th scope="col" class="manage-column column-overhead"><?php esc_html_e( 'Overhead', 'bbpress' ); ?></th>
</tr>
</tfoot>
</table>
<div class="tablenav bottom">
<div class="alignleft actions bulkactions">
<label for="bulk-action-selector-bottom" class="screen-reader-text"><?php esc_html_e( 'Select bulk action', 'bbpress' ); ?></label>
<select name="action2" id="bulk-action-selector-bottom">
<option value="" selected="selected"><?php esc_html_e( 'Bulk Actions', 'bbpress' ); ?></option>
<option value="run" class="hide-if-no-js"><?php esc_html_e( 'Run', 'bbpress' ); ?></option>
</select>
<input type="submit" id="doaction2" class="button action" value="<?php esc_attr_e( 'Apply', 'bbpress' ); ?>">
</div>
</div>
</form>
</div>
<?php
}
/**
* Upgrade user engagements for bbPress 2.6 and higher
*
* @since 2.6.0 bbPress (r6320)
*
* @return array An array of the status code and the message
*/
function bbp_admin_upgrade_user_engagements() {
// Define variables
$bbp_db = bbp_db();
$statement = esc_html__( 'Upgrading user engagements… %s', 'bbpress' );
$result = esc_html__( 'No engagements to upgrade.', 'bbpress' );
// Delete previous engagements
$sql_delete = "DELETE FROM {$bbp_db->postmeta} WHERE meta_key = '_bbp_engagement'";
if ( is_wp_error( $bbp_db->query( $sql_delete ) ) ) {
return array( 1, sprintf( $statement, $result ) );
}
// Post types and statuses
$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 {$bbp_db->postmeta} (post_id, meta_key, meta_value) (
SELECT postmeta.meta_value, '_bbp_engagement', posts.post_author
FROM {$bbp_db->posts} AS posts
LEFT JOIN {$bbp_db->postmeta} AS postmeta
ON posts.ID = postmeta.post_id
AND postmeta.meta_key = '_bbp_topic_id'
WHERE posts.post_type IN (%s, %s)
AND posts.post_status IN (%s, %s)
GROUP BY postmeta.meta_value, posts.post_author)";
// Run the big query
$prepare = $bbp_db->prepare( $sql, $tpt, $rpt, $pps, $cps );
$engagements = $bbp_db->query( $prepare );
// Bail if no closed topics found
if ( empty( $engagements ) || is_wp_error( $engagements ) ) {
return array( 1, sprintf( $statement, $result ) );
}
// Complete results
$result = sprintf( _n( 'Complete! %d engagement upgraded.', 'Complete! %d engagements upgraded.', $engagements, 'bbpress' ), bbp_number_format( $engagements ) );
return array( 0, sprintf( $statement, $result ) );
}
/**
* Upgrade group forum ID mappings after a bbPress 1.x to bbPress 2.x conversion
*
* Previously named: bbp_admin_repair_group_forum_relationships()
*
* @since 2.6.0 bbPress (r4395)
*
* @return If a wp_error() occurs and no converted forums are found
*/
function bbp_admin_upgrade_group_forum_relationships() {
// Define variables
$bbp_db = bbp_db();
$statement = esc_html__( 'Upgrading BuddyPress group-forum relationships… %s', 'bbpress' );
$g_count = 0;
$f_count = 0;
$s_count = 0;
// Copy the BuddyPress filter here, incase BuddyPress is not active
$prefix = apply_filters( 'bp_core_get_table_prefix', $bbp_db->base_prefix );
$groups_table = $prefix . 'bp_groups';
$groups_meta_table = $prefix . 'bp_groups_groupmeta';
// Get the converted forum IDs
$forum_ids = $bbp_db->query( "SELECT `forum`.`ID`, `forummeta`.`meta_value`
FROM `{$bbp_db->posts}` AS `forum`
LEFT JOIN `{$bbp_db->postmeta}` AS `forummeta`
ON `forum`.`ID` = `forummeta`.`post_id`
AND `forummeta`.`meta_key` = '_bbp_old_forum_id'
WHERE `forum`.`post_type` = '" . bbp_get_forum_post_type() . "'
GROUP BY `forum`.`ID`" );
// Bail if forum IDs returned an error
if ( is_wp_error( $forum_ids ) || empty( $bbp_db->last_result ) ) {
return array( 2, sprintf( $statement, esc_html__( 'Failed!', 'bbpress' ) ) );
}
// Stash the last results
$results = $bbp_db->last_result;
// Update each group forum
foreach ( $results as $group_forums ) {
// Only update if is a converted forum
if ( empty( $group_forums->meta_value ) ) {
continue;
}
// Attempt to update group meta
$updated = $bbp_db->query( "UPDATE `{$groups_meta_table}` 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 to forum relationship data
$group_id = (int) $bbp_db->get_var( "SELECT `group_id` FROM `{$groups_meta_table}` WHERE `meta_key` = 'forum_id' AND `meta_value` = '{$group_forums->ID}'" );
if ( ! empty( $group_id ) ) {
// Update the group to forum meta connection in forums
update_post_meta( $group_forums->ID, '_bbp_group_ids', array( $group_id ) );
// Get the group status
$group_status = $bbp_db->get_var( "SELECT `status` FROM `{$groups_table}` WHERE `id` = '{$group_id}'" );
// Sync up forum visibility based on group status
switch ( $group_status ) {
// Public groups have public forums
case 'public' :
bbp_publicize_forum( $group_forums->ID );
// Bump the count for output later
++$s_count;
break;
// Private/hidden groups have hidden forums
case 'private' :
case 'hidden' :
bbp_hide_forum( $group_forums->ID );
// Bump the count for output later
++$s_count;
break;
}
// Bump the count for output later
++$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_type' => 'NUMERIC',
'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' => esc_html__( 'Group Forums', 'bbpress' ),
'post_name' => esc_html__( 'group-forums', 'bbpress' ),
) );
}
// Update the group forums root metadata
update_option( '_bbp_group_forums_root_id', $posts[0]->ID );
}
// Remove old bbPress 1.1 roles (BuddyPress)
remove_role( 'member' );
remove_role( 'inactive' );
remove_role( 'blocked' );
remove_role( 'moderator' );
remove_role( 'keymaster' );
// Complete results
$result = sprintf( esc_html__( 'Complete! %s groups updated; %s forums updated; %s forum statuses synced.', 'bbpress' ), bbp_number_format( $g_count ), bbp_number_format( $f_count ), bbp_number_format( $s_count ) );
return array( 0, sprintf( $statement, $result ) );
}
/**
* Upgrade user favorites for bbPress 2.6 and higher
*
* @since 2.6.0 bbPress (r6174)
*
* @return array An array of the status code and the message
*/
function bbp_admin_upgrade_user_favorites() {
// Define variables
$bbp_db = bbp_db();
$statement = esc_html__( 'Upgrading user favorites… %s', 'bbpress' );
$result = esc_html__( 'No favorites to upgrade.', 'bbpress' );
$total = 0;
$old_key = $bbp_db->prefix . '_bbp_favorites';
$new_key = '_bbp_favorite';
// Results
$query = "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s";
$prepare = $bbp_db->prepare( $query, $old_key );
$favs = $bbp_db->get_results( $prepare );
// Bail if no closed topics found
if ( empty( $favs ) || is_wp_error( $favs ) ) {
return array( 1, sprintf( $statement, $result ) );
}
// Loop through each user's favorites
foreach ( $favs as $meta ) {
// Get post IDs
$post_ids = explode( ',', $meta->meta_value );
// Add user ID to all favorited posts
foreach ( $post_ids as $post_id ) {
// Skip if already exists
if ( $bbp_db->get_var( $bbp_db->prepare( "SELECT COUNT(*) FROM {$bbp_db->postmeta} WHERE post_id = %d AND meta_key = %s AND meta_value = %s", $post_id, $new_key, $meta->user_id ) ) ) {
continue;
}
// Add the post meta
$added = add_post_meta( $post_id, $new_key, $meta->user_id, false );
// Bump counts if successfully added
if ( ! empty( $added ) ) {
++$total;
}
}
}
// Cleanup
unset( $favs, $added, $post_ids );
// Complete results
$result = sprintf( _n( 'Complete! %d favorite upgraded.', 'Complete! %d favorites upgraded.', $total, 'bbpress' ), bbp_number_format( $total ) );
return array( 0, sprintf( $statement, $result ) );
}
/**
* Upgrade user topic subscriptions for bbPress 2.6 and higher
*
* @since 2.6.0 bbPress (r6174)
*
* @return array An array of the status code and the message
*/
function bbp_admin_upgrade_user_topic_subscriptions() {
// Define variables
$bbp_db = bbp_db();
$statement = esc_html__( 'Upgrading user topic subscriptions… %s', 'bbpress' );
$result = esc_html__( 'No topic subscriptions to upgrade.', 'bbpress' );
$total = 0;
$old_key = $bbp_db->prefix . '_bbp_subscriptions';
$new_key = '_bbp_subscription';
// Results
$query = "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s ORDER BY user_id";
$prepare = $bbp_db->prepare( $query, $old_key );
$subs = $bbp_db->get_results( $prepare );
// Bail if no topic subscriptions found
if ( empty( $subs ) || is_wp_error( $subs ) ) {
return array( 1, sprintf( $statement, $result ) );
}
// Loop through each user's topic subscriptions
foreach ( $subs as $meta ) {
// Get post IDs
$post_ids = explode( ',', $meta->meta_value );
// Add user ID to all subscribed topics
foreach ( $post_ids as $post_id ) {
// Skip if already exists
if ( $bbp_db->get_var( $bbp_db->prepare( "SELECT COUNT(*) FROM {$bbp_db->postmeta} WHERE post_id = %d AND meta_key = %s AND meta_value = %s", $post_id, $new_key, $meta->user_id ) ) ) {
continue;
}
// Add the post meta
$added = add_post_meta( $post_id, $new_key, $meta->user_id, false );
// Bump counts if successfully added
if ( ! empty( $added ) ) {
++$total;
}
}
}
// Cleanup
unset( $subs, $added, $post_ids );
// Complete results
$result = sprintf( _n( 'Complete! %d topic subscription upgraded.', 'Complete! %d topic subscriptions upgraded.', $total, 'bbpress' ), bbp_number_format( $total ) );
return array( 0, sprintf( $statement, $result ) );
}
/**
* Upgrade user forum subscriptions for bbPress 2.6 and higher
*
* @since 2.6.0 bbPress (r6193)
*
* @return array An array of the status code and the message
*/
function bbp_admin_upgrade_user_forum_subscriptions() {
// Define variables
$bbp_db = bbp_db();
$statement = esc_html__( 'Upgrading user forum subscriptions… %s', 'bbpress' );
$result = esc_html__( 'No forum subscriptions to upgrade.', 'bbpress' );
$total = 0;
$old_key = $bbp_db->prefix . '_bbp_forum_subscriptions';
$new_key = '_bbp_subscription';
// Results
$query = "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s ORDER BY user_id";
$prepare = $bbp_db->prepare( $query, $old_key );
$subs = $bbp_db->get_results( $prepare );
// Bail if no forum subscriptions found
if ( empty( $subs ) || is_wp_error( $subs ) ) {
return array( 1, sprintf( $statement, $result ) );
}
// Loop through each user's forum subscriptions
foreach ( $subs as $meta ) {
// Get post IDs
$post_ids = explode( ',', $meta->meta_value );
// Add user ID to all subscribed forums
foreach ( $post_ids as $post_id ) {
// Skip if already exists
if ( $bbp_db->get_var( $bbp_db->prepare( "SELECT COUNT(*) FROM {$bbp_db->postmeta} WHERE post_id = %d AND meta_key = %s AND meta_value = %s", $post_id, $new_key, $meta->user_id ) ) ) {
continue;
}
// Add the post meta
$added = add_post_meta( $post_id, $new_key, $meta->user_id, false );
// Bump counts if successfully added
if ( ! empty( $added ) ) {
++$total;
}
}
}
// Cleanup
unset( $subs, $added, $post_ids );
// Complete results
$result = sprintf( _n( 'Complete! %d forum subscription upgraded.', 'Complete! %d forum subscriptions upgraded.', $total, 'bbpress' ), bbp_number_format( $total ) );
return array( 0, sprintf( $statement, $result ) );
}
/**
* Remove favorites data from user meta for bbPress 2.6 and higher
*
* @since 2.6.0 bbPress (r6281)
*
* @return array An array of the status code and the message
*/
function bbp_admin_upgrade_remove_favorites_from_usermeta() {
// Define variables
$bbp_db = bbp_db();
$statement = esc_html__( 'Remove favorites from usermeta… %s', 'bbpress' );
$result = esc_html__( 'No favorites to remove.', 'bbpress' );
$total = 0;
$key = $bbp_db->prefix . '_bbp_favorites';
// Results
$query = "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s ORDER BY user_id";
$prepare = $bbp_db->prepare( $query, $key );
$favs = $bbp_db->get_results( $prepare );
// Bail if no favorites found
if ( empty( $favs ) || is_wp_error( $favs ) ) {
return array( 1, sprintf( $statement, $result ) );
}
// Delete all user-meta with this key
delete_metadata( 'user', false, $key, false, true );
$total = count( $favs );
// Complete results
$result = sprintf( _n( 'Complete! %d favorite deleted.', 'Complete! %d favorites deleted.', $total, 'bbpress' ), bbp_number_format( $total ) );
return array( 0, sprintf( $statement, $result ) );
}
/**
* Remove topic subscriptions data from user meta for bbPress 2.6 and higher
*
* @since 2.6.0 bbPress (r6281)
*
* @return array An array of the status code and the message
*/
function bbp_admin_upgrade_remove_topic_subscriptions_from_usermeta() {
// Define variables
$bbp_db = bbp_db();
$statement = esc_html__( 'Remove topic subscriptions from usermeta… %s', 'bbpress' );
$result = esc_html__( 'No topic subscriptions to remove.', 'bbpress' );
$total = 0;
$key = $bbp_db->prefix . '_bbp_subscriptions';
// Results
$query = "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s ORDER BY user_id";
$prepare = $bbp_db->prepare( $query, $key );
$subs = $bbp_db->get_results( $prepare );
// Bail if no forum favorites found
if ( empty( $subs ) || is_wp_error( $subs ) ) {
return array( 1, sprintf( $statement, $result ) );
}
// Delete all user-meta with this key
delete_metadata( 'user', false, $key, false, true );
$total = count( $subs );
// Complete results
$result = sprintf( _n( 'Complete! %d topic subscription deleted.', 'Complete! %d topic subscriptions deleted.', $total, 'bbpress' ), bbp_number_format( $total ) );
return array( 0, sprintf( $statement, $result ) );
}
/**
* Remove topic subscriptions data from user meta for bbPress 2.6 and higher
*
* @since 2.6.0 bbPress (r6281)
*
* @return array An array of the status code and the message
*/
function bbp_admin_upgrade_remove_forum_subscriptions_from_usermeta() {
// Define variables
$bbp_db = bbp_db();
$statement = esc_html__( 'Remove forum subscriptions from usermeta… %s', 'bbpress' );
$result = esc_html__( 'No forum subscriptions to remove.', 'bbpress' );
$total = 0;
$key = $bbp_db->prefix . '_bbp_forum_subscriptions';
// Query
$query = "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s ORDER BY user_id";
$prepare = $bbp_db->prepare( $query, $key );
$subs = $bbp_db->get_results( $prepare );
// Bail if no forum favorites found
if ( empty( $subs ) || is_wp_error( $subs ) ) {
return array( 1, sprintf( $statement, $result ) );
}
// Delete all user-meta with this key
delete_metadata( 'user', false, $key, false, true );
$total = count( $subs );
// Complete results
$result = sprintf( _n( 'Complete! %d forum subscription deleted.', 'Complete! %d forum subscriptions deleted.', $total, 'bbpress' ), bbp_number_format( $total ) );
return array( 0, sprintf( $statement, $result ) );
}