|
Daniele Pavinato
|
January 16, 2014 at 8:19 am
Hi,
I found the Josh script for display past events:
<code><ul>
<?php
global $wpdb;
$tablename = $wpdb->prefix . events_detail;
$pastevents = $wpdb->get_results("SELECT * FROM $tablename WHERE start_date < curdate() AND event_status <> 'D' ");
foreach ( $pastevents as $pastevent ){
echo '<li><a href="' . espresso_reg_url($pastevent->id) . '">' . stripslashes($pastevent->event_name) . '</a></li>';
}
?>
</ul></code>
If I am right, this snippet should display a list of past event, right?
Should it be configured?
I need to display the past events grouped by category (2010, 2011, 2012, ect.). Is possible?
For the single past event, how should be the template? How can I set the page for display the past events?
|
|
Josh
|
January 17, 2014 at 9:48 am
Hi there,
The snippet will display a list of past events, but it does not group events by category. If you are categorizing the events by year, then you don’t need to use this snippet. The [EVENT_LIST] shortcode will work out of the box for this.
|
|
Daniele Pavinato
|
January 17, 2014 at 11:05 am
I’m not sure if I have understood correctly… Is possible with [EVENT_LIST] to display the past event categorized?
|
|
Josh
|
January 17, 2014 at 11:19 am
If the events are assigned to categories, yes.
The event list shortcode documentation shows the parameters that you can use to display past events that are in specific categories:
http://staging.eventespresso.com/wiki/shortcodes-template-variables/#event-list
|
|
Daniele Pavinato
|
January 18, 2014 at 1:41 am
I need an extra explanation about that.
In the documentation I don’t see anything about past events. I see that is possible to show events by category, but how do I display only past events?
|
|
Daniele Pavinato
|
January 18, 2014 at 7:48 am
I solved this getting the data directly from the DB tables:
<code>function espresso_custom_template_past_events(){
global $this_event_id, $events, $wpdb;
//Get all pasts event data
//Get all categories data
$sql_cat_name = " SELECT * FROM " . EVENTS_CATEGORY_TABLE;
$temp_cats = $wpdb->get_results($sql_cat_name); ?>
<ul class="small-block-grid-1 medium-block-grid-3 large-block-grid-4">
<?php
foreach ($temp_cats as $category) { ?>
<li>
<ul>
<?php echo '<h3>'.$category->category_name.'</h3>';
$sql_start_end = "SELECT * FROM " . EVENTS_DETAIL_TABLE . " WHERE end_date < DATE(NOW()) AND category_id =" . $category->id;
$temp_start_end = $wpdb->get_results($sql_start_end);
//var_dump($temp_start_end);
foreach ($temp_start_end as $past_event){ ?>
<li>
<div class="event">
<div class="title">
<a href="<?php echo espresso_reg_url($past_event->id); ?>">
<?php echo stripslashes_deep($past_event->event_name) ?>
</a>
</div>
</div>
</li>
<?php } ?>
</ul>
</li>
<?php } ?>
</ul>
<?php }</code>
I need to know one more thing: I want to open the past event in a different template page (not the same for the ACTIVES/OPENS event).
I have an archive of pasts event and i want to use the same page to display the past event.
In my code I added the espresso_reg_url($past_event->event_name) to open the past event and bypass the NOT_ACTIVE check, but this function redirect me in the registration event template.
How can I open pasts event in a different single event (eventually registration) template?
Am I enough clear?
Thanks.
|
