Support

August 17, 2014 at 2:35 pm

I am looking to put the same query in place for the calendar, obviously this need adjusting to suit the calendar, the page is linked at.

http://stagingarea.staffordshirechambers.co.uk/events-listing/

I can use it as one of the two following queries

$event_query = “SELECT SQL_CALC_FOUND_ROWS *
FROM wp_posts
INNER JOIN wp_esp_datetime
ON wp_posts.ID = wp_esp_datetime.EVT_id
INNER JOIN wp_esp_event_meta
ON wp_posts.ID = wp_esp_event_meta.EVT_id
LEFT JOIN wp_postmeta pm_value1
ON pm_value1.post_id = wp_posts.ID
LEFT JOIN wp_postmeta pm_value2
ON pm_value2.post_id = wp_posts.ID
LEFT JOIN wp_term_relationships
ON wp_term_relationships.object_id = wp_posts.ID
LEFT JOIN wp_term_taxonomy
ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_ID
LEFT JOIN wp_terms
ON wp_term_taxonomy.term_ID = wp_terms.term_id

WHERE (DTT_EVT_end >= NOW() AND post_status = ‘Publish’)

“;

Or

$atts = array(
‘title’ => NULL,
‘limit’ => $no,
‘css_class’ => NULL,
‘show_expired’ => FALSE,
‘month’ => NULL,
‘category_slug’ => $event_cat_slug,
‘order_by’ => ‘start_date’,
‘sort’ => ‘ASC’,

/* Matching postmeta values in query
‘meta_query’ => array (
‘relation’ => ‘AND’,
array (
‘key’ => $site_tag_enabled,
‘value’ => $event_filter_site,
‘compare’ => ‘Like’,
),
array (
‘key’ => $sector_tag_enabled,
‘value’ => $event_filter_sector,
‘compare’ => ‘Like’,
),
),
);

I had a look into the shortcode for the calendar and not really not sure where i need to go to. The postmeta table is mainly the main table i need to query as i need to use meta_queries.

This is something we are looking to get finished next week. Do we get customisation support from you guys as this is one area i could do with the help with.