bbp_admin_repair_topic_voice_count()

Recount topic members

Description

Return

(array) An array of the status code and the message

Source

function bbp_admin_repair_topic_voice_count() {
    global $wpdb;
 
    $statement = __( 'Counting the number of members in each discussion&hellip; %s', 'buddyboss' );
    $result    = __( 'Failed!', 'buddyboss' );
 
    $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!', 'buddyboss' ) ) );
}

Expand full source code Collapse full source code

Changelog

Changelog
Version	Description
bbPress (r2613)	Introduced.

Uses

Uses
Uses	Description
bp-forums/core/functions.php: bbp_get_closed_status_id()	Return the closed post status ID
bp-forums/core/functions.php: bbp_get_public_status_id()	Return the public post status ID
bp-forums/topics/template.php: bbp_get_topic_post_type()	Return the unique id of the custom post type for topics
bp-forums/replies/template.php: bbp_get_reply_post_type()	Return the unique id of the custom post type for replies

Used By
Used By	Description
bp-forums/admin/tools.php: bp_admin_forum_repair_tools_wrapper_function()	Wrapper function to handle Repair Forums all the actions.

Questions?

We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.

Contents