Get User Video Posts Count Shortcode [yz_total_activity_videos]

yzc_get_total_videos_shortcode.php

<?php
/**
 * Get User Video Posts Count. [yz_total_activity_videos]
 */
function yzc_get_total_videos_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_video'";
    
    if ( ! empty( $args['user_id'] ) ) {
        $request .= " AND user_id = {$args['user_id']} ";
    }

    return $wpdb->get_var( $request );

}

add_shortcode( 'yz_total_activity_videos', 'yzc_get_total_videos_shortcode' );