Function Reference: geodir_search_duplicate_field

Summary

This function has not been documented yet.

Source File

geodir_search_duplicate_field() is located in geodir_ajax_duplicate_alert/geodir_ajax_duplicate_alert.php [Line: 136]

Source Code

function geodir_search_duplicate_field(){
	
	global $wpdb, $plugin_prefix;
	
	$field = $_REQUEST['field'];
	$post_type = $_REQUEST['post_type'];
	
	if (isset($_REQUEST['search_val'])) {
					$search = htmlentities($_REQUEST['search_val']);
	} else  $search ='';

	if($search){
	
		$table = $plugin_prefix.$post_type.'_detail';
		
		if($wpdb->get_var($wpdb->prepare("SHOW COLUMNS FROM ".$table." WHERE field = %s", array($field)))){
				
			$query = $wpdb->prepare("SELECT d.".$field." FROM $wpdb->posts p, ".$table." d	WHERE p.ID=d.post_id AND d.".$field."=%s AND p.post_type=%s AND p.post_status='publish'", array($search, $post_type));
			
			$results = $wpdb->get_results( $query );
			
			if(count($results) > 0){
				
				$post_types = geodir_get_posttypes('object');
			
				$name = $post_types->$post_type->labels->singular_name;
				
				echo __('A', GEODIRDUPLICATEALERT_TEXTDOMAIN ).' '.ucfirst($name).__(' with this field is already listed!<br/> Please make sure you are not adding a duplicate entry', GEODIRDUPLICATEALERT_TEXTDOMAIN);
				
			}
		
		}
		
	}
	
}