Get The Total Activities Number Shortcode [yzc_get_total_activities]

yzc_get_site_total_activities_number.php

<?php

/**
 * Get The Total Activities Number.
 */
function yzc_get_site_total_activities_number() {
    
    global $bp,$wpdb;
    
    $total = $wpdb->get_var( "SELECT COUNT(*) FROM {$bp->activity->table_name}  WHERE component = 'activity' AND type != 'activity_comment' ");
    if(  ! empty( $total ) ) {
       echo sprintf( __( '%d activities', 'youzer' ) , $total );
    }

}

add_shortcode( 'yzc_get_total_activities', 'yzc_get_site_total_activities_number' );