From 5cf2bc15d380fed8835e6e59ad18455f927ab800 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Thu, 2 Mar 2017 15:30:31 -0500 Subject: [PATCH] Another correction on the mysql date query Need to remember to use the Y-m-d instead of m/d/Y format when using dates in mysql where. --- index.php | 6 +++--- models/front/events/rssFeed.php | 2 +- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/index.php b/index.php index 5b306e5..455bb51 100644 --- a/index.php +++ b/index.php @@ -3,7 +3,7 @@ * Plugin Name: GLM Members Database Events * Plugin URI: http://www.gaslightmedia.com/ * Description: Gaslight Media Members Database. - * Version: 1.6.14 + * Version: 1.6.15 * Author: Chuck Scott * Author URI: http://www.gaslightmedia.com/ * License: GPL2 @@ -20,7 +20,7 @@ * @package glmMembersDatabaseEventsAddOn * @author Chuck Scott * @license http://www.gaslightmedia.com Gaslightmedia - * @version 1.6.14 + * @version 1.6.15 */ /* @@ -38,7 +38,7 @@ * so that we're sure the other add-ons see an up to date * version from this plugin. */ -define('GLM_MEMBERS_EVENTS_PLUGIN_VERSION', '1.6.14'); +define('GLM_MEMBERS_EVENTS_PLUGIN_VERSION', '1.6.15'); define('GLM_MEMBERS_EVENTS_PLUGIN_DB_VERSION', '0.1.1'); // This is the minimum version of the GLM Members DB plugin require for this plugin. diff --git a/models/front/events/rssFeed.php b/models/front/events/rssFeed.php index 7870a98..fa367ef 100644 --- a/models/front/events/rssFeed.php +++ b/models/front/events/rssFeed.php @@ -32,7 +32,7 @@ class GlmMembersFront_events_rssFeed extends GlmMembersFront_events_baseAction public function modelAction($actionData = false) { $action = ''; - $fromDate = date('m/d/Y'); + $fromDate = date('Y-m-d'); $this->dateRange = "start_time >= '{$fromDate}'"; if ( isset($_REQUEST['eventId']) && $eventId = filter_var($_REQUEST['eventId'], FILTER_VALIDATE_INT)) { -- 2.17.1