From fb4e23d2b41c7616687ac43f26f08fd57ca26daf Mon Sep 17 00:00:00 2001
From: Chuck Scott <cscott@gaslightmedia.com>
Date: Fri, 22 Jun 2018 12:59:48 -0400
Subject: [PATCH] Member List search problems fixed

Fixed member list "Text Search" when using enter in that field. SQL referencing wrong data in list.php
Fixed loss of Text Search when clicking Alpha Tags in members list, not passing "searh_text" in list.html
---
 models/admin/members/list.php | 7 ++++---
 views/admin/members/list.html | 4 ++--
 2 files changed, 6 insertions(+), 5 deletions(-)

diff --git a/models/admin/members/list.php b/models/admin/members/list.php
index 0fefd08f..c1a20736 100644
--- a/models/admin/members/list.php
+++ b/models/admin/members/list.php
@@ -158,10 +158,11 @@ class GlmMembersAdmin_members_list extends GlmDataMembers
             // $textSearch = addslashes(filter_input(INPUT_POST, 'text_search', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES));
             $textSearch = addslashes(filter_var($_REQUEST['text_search'], FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES));
             $where .= " AND T.id in (
-                SELECT DISTINCT(member)
-                  FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."member_info
-                 WHERE member_name like '%$textSearch%'
+                SELECT DISTINCT(id)
+                  FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."members
+                 WHERE name like '%$textSearch%'
             )";
+
         }
 
         // Get a list of categories for filtering
diff --git a/views/admin/members/list.html b/views/admin/members/list.html
index 4d1de441..7bd477a4 100644
--- a/views/admin/members/list.html
+++ b/views/admin/members/list.html
@@ -54,9 +54,9 @@
         {/if}
 
         <div class="glm-alpha-links">
-            <a href="{$thisUrl}?page=glm-members-admin-menu-members-list&glm_action=list&textSearch={$textSearch}&categorySearch={$catSearchSelected}" class="glm-alpha-link{if !$alphaSelected} glm-alpha-link-selected{/if}">All</a>
+            <a href="{$thisUrl}?page=glm-members-admin-menu-members-list&glm_action=list&text_search={$textSearch}&categorySearch={$catSearchSelected}" class="glm-alpha-link{if !$alphaSelected} glm-alpha-link-selected{/if}">All</a>
       {foreach $alphaList as $a}
-            <a href="{$thisUrl}?page=glm-members-admin-menu-members-list&glm_action=list&alpha={$a.alpha}&textSearch={$textSearch}&categorySearch={$catSearchSelected}" class="glm-alpha-link{if $a.default} glm-alpha-link-selected{/if}">{$a.alpha}</a>
+            <a href="{$thisUrl}?page=glm-members-admin-menu-members-list&glm_action=list&alpha={$a.alpha}&text_search={$textSearch}&categorySearch={$catSearchSelected}" class="glm-alpha-link{if $a.default} glm-alpha-link-selected{/if}">{$a.alpha}</a>
       {/foreach}
        </div>
 
-- 
2.17.1