From 6ed362b66a9bd2b5fedb83f06cbebeaa555a6ab7 Mon Sep 17 00:00:00 2001 From: Anthony Talarico Date: Mon, 30 Jan 2017 15:53:10 -0500 Subject: [PATCH] fixing the sql query for getting front page dates by search to only show events that are active, status = 10 --- models/admin/ajax/eventsCalMonthAJAX.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/models/admin/ajax/eventsCalMonthAJAX.php b/models/admin/ajax/eventsCalMonthAJAX.php index e24d367..664d60c 100644 --- a/models/admin/ajax/eventsCalMonthAJAX.php +++ b/models/admin/ajax/eventsCalMonthAJAX.php @@ -137,7 +137,7 @@ class GlmMembersAdmin_ajax_eventsCalMonthAJAX extends GlmDataEventsTimes $year = $date['year']; $image_url = GLM_MEMBERS_PLUGIN_MEDIA_URL . '/images/small/'; - $sql = "SELECT * FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX ."events WHERE id IN (SELECT event FROM "; + $sql = "SELECT * FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX ."events WHERE status = 10 AND id IN (SELECT event FROM "; $sql .= GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "times WHERE YEAR(start_time) = $year AND MONTH(start_time) = $month AND active = 1 ORDER BY start_time ) LIMIT 3; "; $events = $wpdb->get_results($sql); -- 2.17.1