From 03796afc42c0fbfa2a670bf37c8bd550e8f457d0 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Fri, 7 Apr 2017 16:54:44 -0400
Subject: [PATCH] Update query to get member type

using join for members and member_type
---
 models/front/fields/detail.php | 18 +++++++++---------
 1 file changed, 9 insertions(+), 9 deletions(-)

diff --git a/models/front/fields/detail.php b/models/front/fields/detail.php
index 050b711..2b3eab0 100644
--- a/models/front/fields/detail.php
+++ b/models/front/fields/detail.php
@@ -44,36 +44,36 @@ class GlmMembersFront_fields_detail extends GlmDataFieldsCustomFields
      * @access public
      */
     public $config;
-    
+
     public function modelAction( $actionData = false )
     {
         $member_id      = null;
         $where          = '';
         $order          = '';
         $field_vals     = '';
-        $slash_price    = false;  
+        $slash_price    = false;
 
         global $wpdb;
-        
+
         // get the member id to pass to getList, set the where clause
         if ( isset( $actionData['request']['member'] ) ) {
             $member_id = $actionData['request']['member'] - 0;
             $member_info    = new GlmDataMemberInfo($this->wpdb, $this->config);
             $member_info_id = $member_info->getActiveInfoIdForMember($member_id);
- 
+
             $where = "ref_dest = $member_info_id";
-        
+
             $fields_data    = new GlmDataFieldsCustomFieldsData($this->wpdb, $this->config);
             $field_values   = $fields_data->getList($where);
-            
-            $sql            = "SELECT name FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "member_type WHERE id = $member_id;"; 
+
+            $sql            = "SELECT mt.name FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "member_type mt, " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "members m WHERE m.id = $member_id;";
             $member_type    = $wpdb->get_results($sql);
             $member_type    = $member_type[0]->name;
 
             foreach($field_values as $key=>$value){
                 $field_id       = $value['field_id'];
-                $field_value    = $value['field_data']; 
-                
+                $field_value    = $value['field_data'];
+
                 $sql            = "SELECT field_name FROM " . GLM_MEMBERS_FIELDS_PLUGIN_DB_PREFIX . "custom_fields WHERE id = $field_id;";
                 $field_name     = $wpdb->get_results($sql);
                 $field_name     = $field_name[0]->field_name;
-- 
2.17.1