Support

December 1, 2017 at 2:47 pm

Hi Lukas,

You can remove sold out events with a filter function like this:

function lukas_sold_out_events_where( $SQL, WP_Query $wp_query ) {
	global $wpdb;
	if ( 
		isset( $wp_query->query_vars['post_type'] ) && 
		( $wp_query->query_vars['post_type'] == 'espresso_events'  || 
		( is_array( $wp_query->query_vars['post_type'] ) && 
		in_array( 'espresso_events', $wp_query->query_vars['post_type'] ) ) ) && 
		! $wp_query->is_singular 
	) 
	{
		$SQL .= " AND {$wpdb->posts}.post_status != 'sold_out'";
	}
	return $SQL;
}
add_filter( 'posts_where', 'lukas_sold_out_events_where', 15, 2 );

You can add the above to a functions plugin or into your WordPress theme’s functions.php file.