Support

July 8, 2014 at 5:00 am

Hi,

I need help. I created a page that display the past events archive, but i need to retrieve the city of the past event.

See the code belaow used for this purpose:

<code>add_action(&#039;action_hook_espresso_custom_template_past-events&#039;,&#039;espresso_custom_template_past_events&#039;);

function espresso_custom_template_past_events(){

	global $this_event_id, $events, $wpdb;
	foreach ($events as $event){
		$button_text 		= __(&#039;&#039;, &#039;event_espresso&#039;);
		$alt_button_text	= __(&#039;View Details&#039;, &#039;event_espresso&#039;);//For alternate registration pages
		$externalURL 		= $event-&gt;externalURL;
		$button_text		= !empty($externalURL) ? $alt_button_text : $button_text;
		$registration_url 	= !empty($externalURL) ? $externalURL : espresso_reg_url($event-&gt;id);
	}

	//Get all categories data
	$sql_cat_name = &quot; SELECT * FROM &quot; . EVENTS_CATEGORY_TABLE;
	$temp_cats = $wpdb-&gt;get_results($sql_cat_name);

	foreach ($temp_cats as $category) { 

		$sql_start_end = &quot;SELECT * FROM &quot; . EVENTS_DETAIL_TABLE . &quot; WHERE end_date &lt; DATE(NOW()) AND category_id =&quot; . $category-&gt;id;

		$temp_start_end = $wpdb-&gt;get_results($sql_start_end);

		if( !empty($temp_start_end) ) : ?&gt;
		
		&lt;li&gt;
			&lt;ul&gt;

			&lt;?php			
			
			echo &#039;&lt;h3&gt;&#039;.$category-&gt;category_name.&#039;&lt;/h3&gt;&#039;;

			//Get all pasts event
		    foreach ($temp_start_end as $past_event){

		    	var_dump($past_event);

		    	$string = $past_event-&gt;event_desc;
				$match = wp_extract_urls( $string );?&gt;

				 &lt;li class=&quot;event&quot;&gt;
					&lt;div class=&quot;title&quot;&gt;&lt;?php echo $past_event-&gt;event_name; ?&gt;&lt;/div&gt;
					&lt;div class=&quot;date&quot;&gt;&lt;?php past_date_check($past_event); ?&gt;&lt;/div&gt;
					&lt;div class=&quot;place&quot;&gt;
						&lt;?php
							echo do_shortcode(&#039;[ESPRESSO_VENUE event_id=&quot;&#039; . $event-&gt;id . &#039;&quot; show_image=&quot;false&quot; show_title=&quot;false&quot; show_description=&quot;false&quot; show_address=&quot;false&quot; show_additional_details=&quot;false&quot; show_google_map_link=&quot;false&quot; show_map_image=&quot;false&quot; outside_wrapper=&quot;span&quot; title_wrapper=&quot;span&quot; ]&#039;);
							// if($past_event-&gt;city !== &quot;&quot;){
							// 	if($past_event-&gt;venue_title !== &quot;&quot;){								
							// 		echo $past_event-&gt;venue_title . &#039; - &#039; . $past_event-&gt;city;
							// 	}else{
							// 		echo $past_event-&gt;city;	
							// 	} 
							// } 
						?&gt;
					&lt;/div&gt;
					&lt;a href=&quot;&lt;?php echo stripslashes($match[0]); ?&gt;&quot;&gt;Programma&lt;/a&gt;
					&lt;br&gt;

					&lt;?php if($match[1]) : ?&gt;
					&lt;a href=&quot;&lt;?php echo stripslashes($match[1]); ?&gt;&quot;&gt;Relazioni&lt;/a&gt;
					&lt;?php endif; ?&gt;
					
				&lt;/li&gt;

		&lt;?php  }  ?&gt;

		&lt;/ul&gt;
	&lt;/li&gt;

&lt;?php 
	
	endif;

	} 

?&gt;</code>