Support

May 20, 2020 at 9:07 am

Hi there,

The thread you linked to changes the price list function, but you linked directly to an event, that output doesn’t use a price list it uses a dropdown and therefor uses a different function.

So, may I ask is it the price dropdown function you are looking to change?

If so, are you using the ‘Event Espresso – Members Addon’ on the site? (Meaning you can set prices for logged out users and prices for logged in members)

i’m also trying to get this to work.
https://eventespresso.com/topic/hide-sold-out-events-in-ee3/

Ok, but we’ll need more details on what you are stuck on with the above.

The code is still available on that site and Josh’s fix still applies.

May 20, 2020 at 11:51 am

Ok, so for that you need to copy the event_espresso_price_dropdown function in:

\event-espresso\includes\functions\pricing.php

Line 396 – 453 (everything within the if (!function_exists('event_espresso_price_dropdown')) { ... } condition).

Add that to your custom functions plugin mentioned in the previous thread and then change:

$results = $wpdb->get_results( $wpdb->prepare("SELECT id, event_cost, surcharge, surcharge_type, price_type FROM " . EVENTS_PRICES_TABLE . " WHERE event_id='%d' ORDER BY id ASC", $event_id) );

to be:

$results = $wpdb->get_results( $wpdb->prepare("SELECT id, event_cost, surcharge, surcharge_type, price_type FROM " . EVENTS_PRICES_TABLE . " WHERE event_id='%d' ORDER BY event_cost DESC", $event_id) );

Inside your custom function.

That will sort the event prices in the dropdown by event cost highest -> lowest.

May 21, 2020 at 8:24 am

You haven’t given any more details, so my answer is currently the same as above:

Ok, but we’ll need more details on what you are stuck on with the above.

The code is still available on that site and Josh’s fix still applies.

Have you added the code to your site and added Josh’s fix?

Note that thread hides sold-out events from the Table View Template add-on so I assume you are viewing that output?

May 21, 2020 at 8:40 am

Sometimes load order matters with WordPress.

Deactivate Event Espresso and the custom functions plugin. Then reactivate (in this order) the custom functions plugin then Event Espresso.

Or, if you prefer not to do that, create a custom_functions.php file within:

/wp-content/uploads/espresso/

Then place the function within that file (remember to add an opening <?php tag to the file.

(You’ll need to remove the function from the custom functions plugin to use the above)

One issue with the above method is some ‘security’ plugins simply remove .php files found in /uploads/, or worse still, some leave the file there and just empty it.

May 21, 2020 at 9:16 am

Ok, so that’s completely different to the thread you linked to above.

That’s using [EVENT_LIST] to output various lists, correct?

Copy event_list.php and event_list_display.php to:

/wp-content/uploads/espresso/templates/

Edit event_list.php and around line 288 you’ll have:

$event_id = $event->id;

Just after that add:

$open_spots = apply_filters('filter_hook_espresso_get_num_available_spaces', $event_id);
if($open_spots < 1) {
	continue;
}

That should remove sold-out events from the lists.

Note that the above increases the number of queries per event.