post_exists

Source code

function post_exists($title, $content = '', $date = '') {

	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' ) );



	$query = "SELECT ID FROM $wpdb->posts WHERE 1=1";

	$args = array();



	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;

}