$post_count = $wpdb->get_var(
    "SELECT COUNT(ID) FROM $wpdb->posts
    WHERE post_author = '$curauth->ID'
    AND post_type = 'user_video'
    AND post_status = 'publish'"
);