From cfe60cc20dd92728f1cf52e3f646ec33484132a5 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Fri, 9 Sep 2016 13:49:10 -0400 Subject: [PATCH] Update getting events with limit set. If limit was set the sql query was using NOW() function to get events. If the start time of the event already past then it would not show up. Changed the mysql function to CURDATE() This will get the date. --- models/front/events/baseAction.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/models/front/events/baseAction.php b/models/front/events/baseAction.php index 3723bd7..67b8ce8 100644 --- a/models/front/events/baseAction.php +++ b/models/front/events/baseAction.php @@ -111,7 +111,7 @@ abstract class GlmMembersFront_events_baseAction extends GlmDataEvents SELECT distinct event FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "times AS ET WHERE active - AND start_time >= NOW() + AND start_time >= CURDATE() ) "; $order = "T.id"; -- 2.17.1