Get User Photo Posts Count. [yz_total_activity_photos]

yzc_get_total_photo_posts_shortcode.php

<?php
/**
 * Get User Photo Posts Count. [yz_total_activity_photos]
 */
function yzc_get_total_photo_posts_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_photo'";
    
    if ( ! empty( $args['user_id'] ) ) {
        $request .= " AND user_id = {$args['user_id']} ";
    }
    return $wpdb->get_var( $request );
}
add_shortcode( 'yz_total_activity_photos', 'yzc_get_total_photo_posts_shortcode' );