From 6655dcb70df741ceb007ba06b25f81daa428994b Mon Sep 17 00:00:00 2001 From: Chuck Scott Date: Tue, 21 Jun 2016 15:06:57 -0400 Subject: [PATCH] Fixed some listing and stats issues. Made change to getStats() in the data abstract --- lib/GlmDataAbstract/DataAbstract.php | 4 ++-- models/admin/members/list.php | 4 +--- 2 files changed, 3 insertions(+), 5 deletions(-) diff --git a/lib/GlmDataAbstract/DataAbstract.php b/lib/GlmDataAbstract/DataAbstract.php index 866b3c1c..3cbb754b 100755 --- a/lib/GlmDataAbstract/DataAbstract.php +++ b/lib/GlmDataAbstract/DataAbstract.php @@ -3219,9 +3219,8 @@ abstract class GlmDataAbstract { $sql = "SELECT count(DISTINCT id) as count - FROM $this->table + FROM $this->table T WHERE $where;"; - $stats = $this->wpdb->get_row($sql, ARRAY_A); if (is_admin() && GLM_MEMBERS_PLUGIN_ADMIN_DEBUG_VERBOSE && class_exists('glmMembersAdmin')) { @@ -3281,6 +3280,7 @@ abstract class GlmDataAbstract if (is_admin() && GLM_MEMBERS_PLUGIN_ADMIN_DEBUG_VERBOSE && class_exists('glmMembersAdmin')) { $this->addDataAbstractNotice($sql, 'DataBlock', "DataAbstract - getList() query"); } + $list = $this->wpdb->get_results($sql, ARRAY_A); if (count($list) == 0) { diff --git a/models/admin/members/list.php b/models/admin/members/list.php index 4f3e3fdb..3a7f961a 100644 --- a/models/admin/members/list.php +++ b/models/admin/members/list.php @@ -120,7 +120,7 @@ class GlmMembersAdmin_members_list extends GlmDataMembers // Check if this is a request to show archived members if (isset($_REQUEST['filterArchived'])) { - $where .= " AND T.access = ".$this->config['access_numb']['Archived']; + $where .= " AND access = ".$this->config['access_numb']['Archived']; $filterArchived = true; $haveFilter = true; @@ -247,8 +247,6 @@ class GlmMembersAdmin_members_list extends GlmDataMembers // If we have any entries if (count($list) > 0) { $haveMembers = true; - - $memberCount = count($list); } } -- 2.17.1