When we added the feature to use multiple categories in the EVENT_LIST short code, we lost/broke existing categories because they are stored in a different table. With the added support for multiple categories, we started storing a comma separated list of category ids in the events_detail table. So I am adding support for the legacy and new cate…

event_list.php

<?php

//This is a template file for displaying a list of events on a page. These functions are used with the [ESPRESSO_EVENTS] shortcode.
//This is an group of functions for querying all of the events in your databse.
//This file should be stored in your "/wp-content/uploads/espresso/templates/" directory.
//Note: All of these functions can be overridden using the "Custom Files" addon. The custom files addon also contains sample code to display ongoing events

if (!function_exists('display_all_events')) {
  function display_all_events() {
		event_espresso_get_event_details(array());
	}

}

if (!function_exists('display_event_espresso_categories')) {
	function display_event_espresso_categories($event_category_id=NULL, $css_class=NULL) {
		event_espresso_get_event_details(array('category_identifier' => $event_category_id, 'css_class' => $css_class));
	}
}

if (!function_exists('event_espresso_get_event_details_ajx')) {
	function event_espresso_get_event_details_ajx($attributes) {
	}
}

//Events Listing - Shows the events on your page.
if (!function_exists('event_espresso_get_event_details')) {

	function event_espresso_get_event_details( $attributes ) {

		global $wpdb, $org_options, $events_in_session;
		
		$template_name = ( 'event_list_display.php' );
		$path = locate_template( $template_name );
		
		$event_page_id = $org_options['event_page_id'];
		$currency_symbol = isset($org_options['currency_symbol']) ? $org_options['currency_symbol'] : '';
		$ee_search = isset($_REQUEST['ee_search']) && $_REQUEST['ee_search'] == 'true' && isset($_REQUEST['ee_name']) && !empty($_REQUEST['ee_name']) ? true : false;
		$ee_search_string = isset($_REQUEST['ee_name']) && !empty($_REQUEST['ee_name']) ? sanitize_text_field( $_REQUEST['ee_name'] ) : '';
		
		
		//Check for Multi Event Registration
		$multi_reg = false;
			$category_name = '';
		if (function_exists('event_espresso_multi_reg_init')) {
			$multi_reg = true;
		}
		
		$default_attributes = array(
			'category_identifier'		=> NULL,
			'event_category_id'			=> NULL,
			'staff_id'					=> NULL,
			'allow_override'			=> 0,
			'show_expired'				=> 'false',
			'show_secondary'			=> 'false',
			'show_deleted'				=> 'false',
			'show_recurrence'			=> 'true',
			'limit'						=> '0',
			'order_by'					=> 'NULL',
			'sort'						=> 'ASC',
			'css_class'					=> 'NULL',
			'current_page'				=> 1,
			'events_per_page'			=> 50,
			'num_page_links_to_display'	=>10,
			'use_wrapper'				=> true
		);
		// loop thru default atts
		foreach ($default_attributes as $key => $default_attribute) {
			// check if att exists
			if (!isset($attributes[$key])) {
				$attributes[$key] = $default_attribute;
			}
		}
		
		// now extract shortcode attributes
		extract($attributes);
		
		if (!empty($event_category_id)){
			$category_identifier = $event_category_id;
		}

		//BEGIN CATEGORY MODIFICATION : using events_detail_table.category_id instead of events_category_table.category_identifier in order to filter events with one OR MORE categories
		//Let's check if there's one or more categories specified for the events of the event list (based on the use of "," as a separator) and store them in the $cat array.
		$single_cat = FALSE;
		
		if(strstr($category_identifier,',')){
			$array_cat=explode(",",$category_identifier);
			$cat=array_map('trim', $array_cat);
			
			$category_detail_id = '';
			
			//For every category specified in the shortcode, let's get the corresponding category_id et create a well-formatted string (id,n id)
			foreach($cat as $k=>$v){
	
				$sql_get_category_detail_id="SELECT id FROM ". EVENTS_CATEGORY_TABLE . " WHERE category_identifier = '".$v."'";
				$category_detail_id .= $wpdb->get_var( $sql_get_category_detail_id ).",";
			}
	
			$cleaned_string_cat = substr($category_detail_id, 0, -1);
			$tmp=explode(",",$cleaned_string_cat);
			sort($tmp);
			$cleaned_string_cat=implode(",", $tmp);
			trim($cleaned_string_cat);
			$category_id=$cleaned_string_cat;
			
			//We filter the events based on the events_detail_table.category_id instead of the category_identifier
			$category_sql = ($category_id !== NULL  && !empty($category_id))? " AND e.category_id IN (" . $category_id . ") ": '';
		
		} else {
			$category_sql = ($category_identifier !== NULL  && !empty($category_identifier))? " AND c.category_identifier = '" . $category_identifier . "' ": '';
		}
		
		//END CATEGORY MODIFICATION

		//Create the query
		$DISTINCT = $ee_search == true ? "DISTINCT" : '';
		$sql = "SELECT $DISTINCT e.*, ese.start_time, ese.end_time, p.event_cost ";
		
		//Category field names
		$sql .= ($category_identifier != NULL && !empty($category_identifier))? ", c.category_name, c.category_desc, c.display_desc, c.category_identifier": '';
		
		//Venue sql
		isset($org_options['use_venue_manager']) && $org_options['use_venue_manager'] == 'Y' ? $sql .= ", v.name venue_name, v.address venue_address, v.city venue_city, v.state venue_state, v.zip venue_zip, v.country venue_country, v.meta venue_meta " : '';
		
		//Staff sql
		isset($org_options['use_personnel_manager']) && $org_options['use_personnel_manager'] == 'Y' ? $sql .= ", st.name staff_name " : '';
		
		
		$sql .= " FROM " . EVENTS_DETAIL_TABLE . " e ";
		$sql .= ($category_identifier != NULL && !empty($category_identifier))? " JOIN " . EVENTS_CATEGORY_REL_TABLE . " r ON r.event_id = e.id  JOIN " . EVENTS_CATEGORY_TABLE . " c ON  c.id = r.cat_id ":'';
		
		//Venue sql
		isset($org_options['use_venue_manager']) && $org_options['use_venue_manager'] == 'Y' ? $sql .= " LEFT JOIN " . EVENTS_VENUE_REL_TABLE . " vr ON vr.event_id = e.id LEFT JOIN " . EVENTS_VENUE_TABLE . " v ON v.id = vr.venue_id " : '';
		
		//Venue sql
		isset($org_options['use_personnel_manager']) && $org_options['use_personnel_manager'] == 'Y' ? $sql .= " LEFT JOIN " . EVENTS_PERSONNEL_REL_TABLE . " str ON str.event_id = e.id LEFT JOIN " . EVENTS_PERSONNEL_TABLE . " st ON st.id = str.person_id " : '';
		
		$sql .= " LEFT JOIN " . EVENTS_START_END_TABLE . " ese ON ese.event_id= e.id ";
		$sql .= " LEFT JOIN " . EVENTS_PRICES_TABLE . " p ON p.event_id=e.id ";
		$sql .= " WHERE is_active = 'Y' ";
		
		//Category sql
		$sql .= $category_sql;
		
		//Staff sql
		$sql .= ($staff_id !== NULL  && !empty($staff_id))? " AND st.id = '" . $staff_id . "' ": '';
		
		//User sql
		$sql .= (isset($user_id)  && !empty($user_id))? " AND wp_user = '" . $user_id . "' ": '';
		
		$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') . "') " : '';
		if  ($show_expired == 'true'){
			$allow_override = 1;
		}
		
		//If using the [ESPRESSO_VENUE_EVENTS] shortcode
		$sql .= isset($use_venue_id) && $use_venue_id == true ? " AND v.id = '".$venue_id."' " : '';
		
		$sql .= $show_secondary == 'false' ? " AND e.event_status != 'S' " : '';
		$sql .= $show_deleted == 'false' ? " AND e.event_status != 'D' " : " AND e.event_status = 'D' ";
		if  ($show_deleted == 'true'){
			$allow_override = 1;
		}
		//echo '<p>'.$order_by.'</p>';
		$sql .= $show_recurrence == 'false' ? " AND e.recurrence_id = '0' " : '';
		
		//Search query
		if ( $ee_search ){
			// search for full original string within bracketed search options
			$sql .= " AND ( e.event_name LIKE '%$ee_search_string%' ";
			// array of common words that we don't want to waste time looking for
			$words_to_strip = array( ' the ', ' a ', ' or ', ' and ' );
			$words = str_replace( $words_to_strip, ' ', $ee_search_string );
			// break words array into individual strings
			$words = explode( ' ', $words );
			// search for each word  as an OR statement
			foreach ( $words as $word ) {
				$sql .= " OR e.event_name LIKE '%$word%' ";			
			}
			// close the search options
			$sql .= " ) ";
		}
		
		$sql .= " GROUP BY e.id ";
		$sql .= $order_by != 'NULL' ? " ORDER BY " . $order_by . " ".$sort." " : " ORDER BY date(start_date), id ASC ";
		$sql .= $limit > 0 ? ' LIMIT 0, '.$limit : '';  
		
		//echo $sql;
		//echo 'This page is located in ' . get_option( 'upload_path' );
		
		$events = $wpdb->get_results( $sql );

		$category_id = isset($wpdb->last_result[0]->id) ? $wpdb->last_result[0]->id : '';
		$category_name = isset($wpdb->last_result[0]->category_name) ? $wpdb->last_result[0]->category_name : '';
		$category_identifier = isset($wpdb->last_result[0]->category_identifier) ? $wpdb->last_result[0]->category_identifier : '';
		$category_desc = isset($wpdb->last_result[0]->category_desc) ? html_entity_decode(wpautop($wpdb->last_result[0]->category_desc)) : '';
		$display_desc = isset($wpdb->last_result[0]->display_desc) ? $wpdb->last_result[0]->display_desc : '';
        
		
		$total_events = count($events);
		$total_pages = ceil($total_events/$events_per_page);
		
		$offset = ($current_page-1)*$events_per_page;
		$events = array_slice($events,$offset,$events_per_page);
		
		//Debug
		//var_dump($events);
		
		if ( $use_wrapper ) {
			echo "<div id='event_wrapper'>";
		}
		$page_link_ar = array();
		foreach($attributes as $key=>$attribute) {
			if ( !in_array($key,array('current_page','use_wrapper'))) {
				$page_link_ar[] = "$key=".urlencode($attribute);
			}
		}
		$page_link = implode('&',$page_link_ar);
		echo "<div id='event_search_code' style='display:none;' data='$page_link'></div>";
		//css_class='$css_class' allow_override='$allow_override' events_per_page='$events_per_page' num_page_links_to_display='$num_page_links_to_display'></div>";
		echo "<div id='event_container_pagination' >";
		if ( $total_pages > 1 ) {
			
			$mid = ceil($num_page_links_to_display/2);
			
			if ( $num_page_links_to_display%2 == 0) {
				$back = $mid;
			} else {
				$back = $mid -1;
			}			
			$start = $current_page - $back;
			if ( $start < 1 ) {
				$start = 1;
			}
			$end = $start+$num_page_links_to_display;
			if ( $end > $total_pages) {
				$end = $total_pages;
			}
			
			$prev = $current_page - 1;
			$prev_no_more = '';
			if ( $prev < 1 ) {
				$prev = 1;
				$prev_no_more = 'no_more';
			}
			
			$next = $current_page + 1;
			$next_no_more = '';
			if ( $next > $total_pages) {
				$next = $total_pages;
				$next_no_more = 'no_more';
			}
			
			$espresso_paginate = "<div class='page_navigation'>";
			$espresso_paginate .= "<a href='#' current_page=1 class='event_paginate $prev_no_more ui-icon ui-icon-seek-first'>&lt;&lt;</a>";
			$espresso_paginate .= "<a href='#' current_page=$prev class='event_paginate $prev_no_more ui-icon ui-icon-seek-prev'>&lt;</a>";
			if ( $start > 1) {
				$espresso_paginate .= "<span class='ellipse less'>...</span>";
			}
			for($i = $start; $i <= $end; $i++) {
				$active_page = '';
				if ( $i == $current_page) {
					$active_page = 'active_page';
				}
				$espresso_paginate .= "<a class='page_link event_paginate $active_page ' current_page=$i href='#' style='display: block; '>$i</a>";
			}
			if ( $end < $total_pages) {
				$espresso_paginate .= "<span class='ellipse more'>...</span>";
			}
			$espresso_paginate .= "<a href='#' current_page=$next class='event_paginate $next_no_more ui-icon ui-icon-seek-next'>&gt;</a>";
			$espresso_paginate .= "<a href='#' current_page=$total_pages class='event_paginate $next_no_more ui-icon ui-icon-seek-end'>&gt;&gt;</a>";
			$espresso_paginate .= "</div>";	
		}
		echo "<div id='event_content' class='event_content'>";
		if ( count($events) < 1) {
			//echo $sql;
			echo __('No events available...', 'event_espresso');
		}
		 if ($display_desc == 'Y') {
			echo '<p id="events_category_name-' . $category_id . '" class="events_category_name">' . stripslashes_deep($category_name) . '</p>';
			echo espresso_format_content($category_desc);
		}
		foreach ($events as $event) {
			
			$event_id = $event->id;
			$event_name = $event->event_name;
			$event_desc = stripslashes_deep($event->event_desc);
			$event_identifier = $event->event_identifier;
			$active = $event->is_active;
			$registration_start = $event->registration_start;
			$registration_end = $event->registration_end;
			$start_date = $event->start_date;
			$end_date = $event->end_date;
			$reg_limit = $event->reg_limit;
			$event_address = $event->address;
			$event_address2 = $event->address2;
			$event_city = $event->city;
			$event_state = $event->state;
			$event_zip = $event->zip;
			$event_country = $event->country;
			$member_only = $event->member_only;
			$externalURL = $event->externalURL;
			$recurrence_id = $event->recurrence_id;
			$display_reg_form = $event->display_reg_form;
			$allow_overflow = $event->allow_overflow;
			$overflow_event_id = $event->overflow_event_id;
			$event_desc = array_shift(explode('<!--more-->', $event_desc));
			global $event_meta;
			$event_meta = unserialize($event->event_meta);
			$event_meta['is_active'] = $event->is_active;
			$event_meta['event_status'] = $event->event_status;
			$event_meta['start_time'] = empty($event->start_time) ? '' : $event->start_time;
			$event_meta['start_date'] = $event->start_date;
			$event_meta['registration_start'] = $event->registration_start;
			$event_meta['registration_startT'] = $event->registration_startT;
			$event_meta['registration_end'] = $event->registration_end;
			$event_meta['registration_endT'] = $event->registration_endT;

			//Venue information
			if ($org_options['use_venue_manager'] == 'Y') {
				$event_address = empty($event->venue_address) ? '' : $event->venue_address;
				$event_address2 = empty($event->venue_address2) ? '' : $event->venue_address2;
				$event_city = empty($event->venue_city) ? '' : $event->venue_city;
				$event_state = empty($event->venue_state) ? '' : $event->venue_state;
				$event_zip = empty($event->venue_zip) ? '' : $event->venue_zip;
				$event_country = empty($event->venue_country) ? '' : $event->venue_country;

				//Leaving these variables intact, just in case people want to use them
				$venue_title = empty($event->venue_name) ? '' : $event->venue_name;
				$venue_address = $event_address;
				$venue_address2 = $event_address2;
				$venue_city = $event_city;
				$venue_state = $event_state;
				$venue_zip = $event_zip;
				$venue_country = $event_country;
				global $venue_meta;
				$add_venue_meta = array(
					'venue_title' => $venue_title,
					'venue_address' => $event_address,
					'venue_address2' => $event_address2,
					'venue_city' => $event_city,
					'venue_state' => $event_state,
					'venue_country' => $event_country,
				);
				$venue_meta = (!empty($event->venue_meta) && !empty($add_venue_meta)) ? array_merge(unserialize($event->venue_meta), $add_venue_meta) : '';
				//print_r($venue_meta);
			}

			//Address formatting
			$location = (!empty($event_address) ? $event_address : '') . (!empty($event_address2) ? '<br />' . $event_address2 : '') . (!empty($event_city) ? '<br />' . $event_city : '') . (!empty($event_state)  ? ', ' . $event_state : '') . (!empty($event_zip) ? '<br />' . $event_zip : '') . (!empty($event_country) ? '<br />' . $event_country : '');

			//Google map link creation
			$google_map_link = espresso_google_map_link(array('address' => $event_address, 'city' => $event_city, 'state' => $event_state, 'zip' => $event_zip, 'country' => $event_country, 'text' => 'Map and Directions', 'type' => 'text'));
			global $all_meta;
			$all_meta = array(
				'event_id' => $event_id,
				'event_name' => stripslashes_deep($event_name),
				'event_desc' => stripslashes_deep($event_desc),
				'event_address' => $event_address,
				'event_address2' => $event_address2,
				'event_city' => $event_city,
				'event_state' => $event_state,
				'event_zip' => $event_zip,
				'event_country' => $venue_country,
				'venue_title' => $venue_title,
                'venue_address' => $venue_address,
                'venue_address2' => $venue_address2,
                'venue_city' => $venue_city,
                'venue_state' => $venue_state,
                'venue_country' => $venue_country,
				'location' => $location,
				'is_active' => $event->is_active,
				'event_status' => $event->event_status,
				'contact_email' => empty($event->alt_email) ? $org_options['contact_email'] : $event->alt_email,
				'start_time' => empty($event->start_time) ? '' : $event->start_time,
				'registration_startT' => $event->registration_startT,
				'registration_start' => $registration_start,
				'registration_endT' => $event->registration_endT,
				'registration_end' => $registration_end,
				'is_active' => empty($is_active) ? '' : $is_active,
				'event_country' => $event_country,
				'start_date' => event_date_display($start_date, get_option('date_format')),
				'end_date' => event_date_display($end_date, get_option('date_format')),
				'time' => empty($event->start_time) ? '' : $event->start_time,
				'start_time' => empty($event->start_time) ? '' : $event->start_time,
				'end_time' => empty($event->end_time) ? '' : $event->end_time,
				'google_map_link' => $google_map_link,
				'price' => empty($event->event_cost) ? '' : $event->event_cost,
				'event_cost' => empty($event->event_cost) ? '' : $event->event_cost,
			);
			//Debug
			//echo '<p>'.print_r($all_meta).'</p>';
			//These variables can be used with other the espresso_countdown, espresso_countup, and espresso_duration functions and/or any javascript based functions.
			//Warning: May cause additional database queries an should only be used for sites with a small amount of events.
			// $start_timestamp = espresso_event_time($event_id, 'start_timestamp');
			//$end_timestamp = espresso_event_time($event_id, 'end_timestamp');

			//This can be used in place of the registration link if you are usign the external URL feature
			$registration_url = $externalURL != '' ? $externalURL : espresso_reg_url($event_id);
				//Serve up the event list
				//As of version 3.0.17 the event list details have been moved to event_list_display.php

				if ($allow_override == 1) {
					//Uncomment to show active status array
					//print_r( event_espresso_get_is_active($event_id));
					if ( empty( $path ) ) {
						include( $template_name );
					} else {
						include( $path );
					}
				} else {
					switch (event_espresso_get_status($event_id)) {
						case 'NOT_ACTIVE':
							//Don't show the event
							//Uncomment the following two lines to show events that are not active and the active status array
							//print_r( event_espresso_get_is_active($event_id));
							//include('event_list_display.php');
							break;

						case 'PENDING':
							if (current_user_can('administrator') || function_exists('espresso_member_data') && espresso_can_view_event($event_id) == true) {
								//Uncomment to show active status array
								//print_r( event_espresso_get_is_active($event_id));

								echo '<div class="pending_event">';
								if ( empty( $path ) ) {
								  include( $template_name );
								} else {
								  include( $path );
								}
								echo '</div>';
							}
							break;

						default:

							//Uncomment to show active status array
							//print_r( event_espresso_get_is_active($event_id));
							if ( empty( $path ) ) {
								include( $template_name );
							} else {
								include( $path );
							}
							break;
					}
				}
			
		}
		echo "</div>";
		echo "</div>";
		if ( isset( $espresso_paginate ) ) {
			echo $espresso_paginate; // spit out the pagination links
		}
		if ( $use_wrapper ) {
			echo "</div>";
		}
		//Check to see how many database queries were performed
		//echo '<p>Database Queries: ' . get_num_queries() .'</p>';
		espresso_registration_footer();
	}

}