From 7592c26bdcc34d0d292374dcaab9cc3d60b1240d Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Fri, 16 Nov 2018 16:07:07 -0500 Subject: [PATCH] Update what data is being retrieved for the itinerary. Need more data for the member list. --- setup/frontHooks.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/setup/frontHooks.php b/setup/frontHooks.php index 4ce5233b..0fd861b9 100644 --- a/setup/frontHooks.php +++ b/setup/frontHooks.php @@ -656,9 +656,10 @@ add_filter( if ( $member_info_id ) { $sql = " SELECT MI.id,MI.member,MI.member_name,MI.addr1,C.name as city,MI.state,MI.zip,MI.phone,MI.url,MI.email, - MI.lat,MI.lon + MI.lat,MI.lon,MI.has_no_profile,M.member_slug FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "member_info MI LEFT OUTER JOIN " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "cities C ON (C.id = MI.city) + LEFT OUTER JOIN " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "members M ON (M.id = MI.member) WHERE MI.id = $member_info_id"; return $this->wpdb->get_row( $sql, ARRAY_A ); } else { -- 2.17.1