bbp_admin_repair_topic_hidden_reply_count()

Recount topic hidden replies (spammed/trashed)

Description

Return

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

Source

function bbp_admin_repair_topic_hidden_reply_count() {
    global $wpdb;
 
    $statement = __( 'Counting the number of spammed and trashed replies in each discussion&hellip; %s', 'buddyboss' );
    $result    = __( 'Failed!', 'buddyboss' );
 
    $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 ( '" . implode( "','", 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!', 'buddyboss' ) ) );
}

Expand full source code Collapse full source code

Changelog

Changelog
Version	Description
bbPress (r2747)	Introduced.

Uses

Uses
Uses	Description
bp-forums/core/functions.php: bbp_get_trash_status_id()	Return the trash post status ID
bp-forums/core/functions.php: bbp_get_spam_status_id()	Return the spam post status ID
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