Function Reference: geodir_payment_delete_post_type

Summary

This function has not been documented yet.

Source Code

function geodir_payment_delete_post_type($post_type = ''){

	global $wpdb, $plugin_prefix;
	
	if($post_type != ''){
		
		$all_postypes = geodir_get_posttypes();
		
		$wpdb->query($wpdb->prepare("DELETE FROM ".GEODIR_PRICE_TABLE." WHERE post_type=%s", array($post_type)));
		
		$coupon_data = $wpdb->get_results($wpdb->prepare("SELECT cid, post_types FROM ".COUPON_TABLE." WHERE FIND_IN_SET(%s, post_types)", array($post_type)));
		
		if(!empty($coupon_data)){
			
			foreach($coupon_data as $key => $coupon){
			
				$coupons = explode(",",$coupon->post_types);
				
				if(($del_key = array_search($post_type, $coupons)) !== false)
					unset($coupons[$del_key]);
				
				if(!empty($coupons)){
					
					$coupons = implode(',',$coupons);
					
					$wpdb->query($wpdb->prepare("UPDATE ".COUPON_TABLE." SET post_types=%s WHERE cid=%d",array($coupons,$coupon->cid)));
					
				}else{
					
					$wpdb->query($wpdb->prepare("DELETE FROM ".COUPON_TABLE." WHERE cid=%d", array($coupon->cid)));
					
				}
					
			}
			
		}
	
	}
}