Ticket #27149 Public

• Hi,
  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
  Heinz

  BY: Heinz Peller - Feb 7,2017 AT 11:43AM - 3 years ago
• • By: Heinz Peller Feb 16,2017 AT 7:16AM - Posted 3 years ago - #28305

    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 t

    INNER JOIN wp_kiahuffu_term_taxonomy AS tt ON t.term_id = tt.term_id

    INNER JOIN wp_kiahuffu_term_relationships AS r ON r.term_taxonomy_id=tt.term_id

    WHERE ((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 > 0

    GROUP BY t.name

    ORDER BY t.name ASC

    It would be terrific to get this in $terms = ….

    Regards
    Heinz