Change Posts & Comments Statistics to Activities Number & Activities Comments Number

yz-change-posts-and-comments-statistics.php

<?php

/**
 * Get The User Activities Number.
 */
function yzc_get_user_activities_number( $number, $user_id, $type ) {
 if ( $type == 'posts' ) {
 global $bp,$wpdb;
 $activity_count = $wpdb->get_var( "SELECT COUNT(*) FROM {$bp->activity->table_name}
WHERE component IN ( 'activity', 'groups' ) AND type != 'activity_comment' AND user_id = '$user_id'
");
 $total = $number + $activity_count;
 }
 return $total;
}
add_filter('youzify_get_user_statistic_number', 'yzc_get_user_activities_number', 10, 3 );


/**
 * Get The User Activity Comments Number.
 */
function yzc_get_user_activities_comments_number( $number, $user_id, $type ) {

    if ( $type != 'comments' ) {
        return $number;
    }

    global $bp,$wpdb;
    
    $total = $wpdb->get_var( "SELECT COUNT(*) FROM {$bp->activity->table_name}  WHERE component IN ( 'activity', 'groups' ) AND type = 'activity_comment' AND user_id = '$user_id' ");
    
    return $total;                             

}

add_filter( 'youzify_get_user_statistic_number', 'yzc_get_user_activities_comments_number', 10, 3 );