From 20f01db71a03668b0c5f5c3851f014b98528e444 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Wed, 9 Nov 2016 15:40:29 -0500
Subject: [PATCH] List for categories should have only active events.

Restrict the category list for event search to categories that are in
active events.
---
 classes/data/dataCategories.php | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/classes/data/dataCategories.php b/classes/data/dataCategories.php
index bd74e77..eabf097 100644
--- a/classes/data/dataCategories.php
+++ b/classes/data/dataCategories.php
@@ -351,6 +351,11 @@ class GlmDataEventsCategories extends GlmDataAbstract
                  WHERE active
                    AND start_time >= NOW()
             )
+            AND event IN (
+               SELECT id
+                 FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "events
+                WHERE status = 10
+            )
         ) ";
         $order = "T.name";
         return $this->getList($where, $order);
-- 
2.17.1