Total Activity Comments Shortcode [yz_total_activity_comments user_id=""]

yzc_get_total_comments_shortcode.php

<?php
/**
 * Get User Comments Count.
 */
function yzc_get_total_comments_shortcode( $args = null ) {
	global $bp, $wpdb;

	// Get Shortcode Args.
	$args = wp_parse_args( $args, array(
			'user_id' => false,
		)
	);

	// Get Global Request
	$request = "SELECT COUNT(*) FROM {$bp->activity->table_name} WHERE component = 'activity' AND type = 'activity_comment'";

	if ( ! empty( $args['user_id'] ) ) {
		$request .= " AND user_id = {$args['user_id']} ";
	}

	return $wpdb->get_var( $request );

}

add_shortcode( 'yz_total_activity_comments', 'yzc_get_total_comments_shortcode' );