bbp_admin_repair_user_topic_count()
Recount topics by the users
Description Description
Return Return
(array) An array of the status code and the message
Source Source
File: includes/admin/tools/repair.php
function bbp_admin_repair_user_topic_count() {
// Define variables
$bbp_db = bbp_db();
$statement = esc_html__( 'Counting the number of topics each user has created… %s', 'bbpress' );
$result = esc_html__( 'Failed!', 'bbpress' );
$sql_select = "SELECT `post_author`, COUNT(DISTINCT `ID`) as `_count` FROM `{$bbp_db->posts}` WHERE `post_type` = '" . bbp_get_topic_post_type() . "' AND `post_status` = '" . bbp_get_public_status_id() . "' GROUP BY `post_author`";
$insert_rows = $bbp_db->get_results( $sql_select );
if ( is_wp_error( $insert_rows ) ) {
return array( 1, sprintf( $statement, $result ) );
}
$key = $bbp_db->prefix . '_bbp_topic_count';
$insert_values = array();
foreach ( $insert_rows as $insert_row ) {
$insert_values[] = "('{$insert_row->post_author}', '{$key}', '{$insert_row->_count}')";
}
if ( !count( $insert_values ) ) {
return array( 2, sprintf( $statement, $result ) );
}
$sql_delete = "DELETE FROM `{$bbp_db->usermeta}` WHERE `meta_key` = '{$key}'";
if ( is_wp_error( $bbp_db->query( $sql_delete ) ) ) {
return array( 3, sprintf( $statement, $result ) );
}
foreach ( array_chunk( $insert_values, 10000 ) as $chunk ) {
$chunk = "\n" . implode( ",\n", $chunk );
$sql_insert = "INSERT INTO `{$bbp_db->usermeta}` (`user_id`, `meta_key`, `meta_value`) VALUES {$chunk}";
if ( is_wp_error( $bbp_db->query( $sql_insert ) ) ) {
return array( 4, sprintf( $statement, $result ) );
}
}
return array( 0, sprintf( $statement, esc_html__( 'Complete!', 'bbpress' ) ) );
}
Changelog Changelog
| Version | Description |
|---|---|
| 2.1.0 | Introduced. |