35% OFF ADDONS CODE EVOCYBER2020
I want to use List & Items for showing events in locations. Is it possible to hide locations, where no upcoming event exists? Found no switch for this.
If you have a lot of locations in the list it would be very frustrating for the visitors always to click on locations with “no event”-message.
Thanks and Regards
The problem is
$terms = get_categories(array(‘taxonomy’=>$category_type));
in class-frontend.php without any parameter.
Again – it does not make sense to show the visitors categories, locations or organizers without upcoming events.
I tested this sql-query which only supplies results with upcoming events (exampel with organizers):
SELECT t.*, tt.* FROM wp_kiahuffu_terms AS tINNER JOIN wp_kiahuffu_term_taxonomy AS tt ON t.term_id = tt.term_idINNER JOIN wp_kiahuffu_term_relationships AS r ON r.term_taxonomy_id=tt.term_idWHERE ((SELECT count(meta_ID) from wp_kiahuffu_postmeta AS o WHERE (from_unixtime(o.meta_value) >= CURDATE()) and meta_key=’evcal_srow’ AND (o.post_id=r.object_id)) > 0 )and tt.taxonomy IN (‘event_organizer’) AND tt.count > 0GROUP BY t.nameORDER BY t.name ASC
It would be terrific to get this in $terms = ….