public static function get_user_comments_approved( $user_id, $comment_author_email, $comment_author, $comment_author_url ) {
    global $wpdb;

    if ( !empty( $user_id ) )
      return (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$wpdb->comments} WHERE user_id = %d AND comment_approved = 1", $user_id ) );

    if ( !empty( $comment_author_email ) )
      return (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$wpdb->comments} WHERE comment_author_email = %s AND comment_author = %s AND comment_author_url = %s AND comment_approved = 1", $comment_author_email, $comment_author, $comment_author_url ) );

    return 0;
  }