Ticket #16283: idea.txt

function post_exists($title, $content = '', $date = '', $status = 'publish') {
        global $wpdb;

        $post_title = stripslashes( sanitize_post_field( 'post_title', $title, 0, 'db' ) );
        $post_content = stripslashes( sanitize_post_field( 'post_content', $content, 0, 'db' ) );
        $post_date = stripslashes( sanitize_post_field( 'post_date', $date, 0, 'db' ) );
        $post_status = stripslashes( sanitize_post_field( 'post_status', $status, 0, 'db' ) );

        $query = "SELECT ID FROM $wpdb->posts WHERE post_status=%s";
        $args = array();
        $args[] = $post_status;
        if ( !empty ( $date ) ) {
                $query .= ' AND post_date = %s';
                $args[] = $post_date;
        }

        if ( !empty ( $title ) ) {
                $query .= ' AND post_title = %s';
                $args[] = $post_title;
        }

        if ( !empty ( $content ) ) {
                $query .= 'AND post_content = %s';
                $args[] = $post_content;
        }

        if ( !empty ( $args ) )
                return $wpdb->get_var( $wpdb->prepare($query, $args) );

        return 0;

}