From 02c86c9f6f9cb34190ed673b72a6601a8ad9a420 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Tue, 12 Sep 2017 16:30:16 -0400
Subject: [PATCH] Fix for member id

Need to look at the member_pointer id instead of the member info id.
---
 models/admin/ajax/membersListExport.php | 16 ++++++++--------
 1 file changed, 8 insertions(+), 8 deletions(-)

diff --git a/models/admin/ajax/membersListExport.php b/models/admin/ajax/membersListExport.php
index 84ee0334..8470e6a1 100644
--- a/models/admin/ajax/membersListExport.php
+++ b/models/admin/ajax/membersListExport.php
@@ -223,7 +223,7 @@ class GlmMembersAdmin_ajax_membersListExport extends GlmDataMemberInfo
         //echo '<pre>$where: ' . print_r( $where, true ) . '</pre>';
         // Get a current list of members without paging
         $list = $this->getList($where, "member_name");
-        
+
         //echo '<pre>$list: ' . print_r( $list, true ) . '</pre>';
         //exit;
 
@@ -242,36 +242,36 @@ class GlmMembersAdmin_ajax_membersListExport extends GlmDataMemberInfo
 
                 // If URL Clicks and/or Views are selected
                 if ($select['exportClicks'] || $select['exportViews']) {
-                    
+
                     foreach($list as $k=>$v) {
 
+
                         $thisMonth = date('Y-m-d', strtotime($_REQUEST['monthYear']));
-                        
+
                         if ($select['exportClicks']) {
                             $clicks = $this->wpdb->get_row("
                                 SELECT COALESCE ((
                                     SELECT clicks
                                       FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."clickthrough_stats
-                                     WHERE member = ".$v['id']."
+                                     WHERE member = ".$v['member_pointer']."
                                        AND stat_type = 3
                                        AND stat_date = '$thisMonth'
                                ), 0) AS month
                             ", ARRAY_A);
                             $list[$k]['clicks'] = $clicks['month'];
-                            
                         }
-                            
+
                         if ($select['exportViews']) {
                             $views = $this->wpdb->get_row("
                                 SELECT COALESCE ((
                                     SELECT clicks
                                       FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."member_detail_stats
-                                     WHERE member = ".$v['id']."
+                                     WHERE member = ".$v['member_pointer']."
                                        AND stat_type = 3
                                        AND stat_date = '$thisMonth'
                                ), 0) AS month
                             ", ARRAY_A);
-                        
+
                             $list[$k]['views'] = $views['month'];
 
                         }
-- 
2.17.1