Support

February 21, 2013 at 4:36 pm

This is my sql-query, added as a separate function in event-list.php:

// search for categories, having events
$sql = “SELECT DISTINCT c.id, c.category_name, c.category_identifier FROM “.EVENTS_CATEGORY_TABLE.” c “;
$sql .= “JOIN “.EVENTS_CATEGORY_REL_TABLE.” r ON c.id = r.cat_id “;
$sql .= “JOIN “.EVENTS_DETAIL_TABLE.” e ON r.event_id = e.id “;
$sql .= “WHERE is_active = ‘Y’ “;
$sql .= $show_expired == ‘false’ ? ” AND (e.start_date >= ‘” . date(‘Y-m-d’) . “‘ OR e.event_status = ‘O’ OR e.registration_end >= ‘” . date(‘Y-m-d’) . “‘) ” : ”;
$sql .= $show_secondary == ‘false’ ? ” AND e.event_status != ‘S’ ” : ”;
$sql .= $show_deleted == ‘false’ ? ” AND e.event_status != ‘D’ ” : ” AND e.event_status = ‘D’ “;

$categories = $wpdb->get_results( $sql );

—

Furthermore I use category-identifier field to introduce a certain category-structure using category groups, like ‘groupName-ID’.

Showing multiple category-checkboxes, grouped (by groupName, see above), and carriing out a small JS-function which builds a custom category-identifier-string, I am able to filter events with checked categories out, using shortcode [EVENT-LIST category_idendifier=my-custom-category-identifier-string].

That’s it. Not very tricky, and it works fine.

Frank

February 23, 2013 at 2:17 am

There nothing has been mangled,
instead of ‘>’,
what html-encodes for ‘>’.

Kind regards
Frank