CYBER WEEK

35% OFF ADDONS CODE EVOCYBER2020

X
27149

Ticket #27149 Public

EVENT LISTS & ITEMS with locations

  • 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

       

You must login to reply to this ticket

HelpDesk

Welcome to EventON helpdesk.

EventON is the #1 Best selling event calendar plugin for WordPress websites in envato marketplace.

Checkout EventON