From cef6a947b787e59c49e71ff14bae5392ff750f00 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Thu, 8 Nov 2018 11:30:56 -0500 Subject: [PATCH] Update for filter to grab member data Grab lat lon for the member data for trip planner. --- setup/frontHooks.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/setup/frontHooks.php b/setup/frontHooks.php index e1a84c57..4ce5233b 100644 --- a/setup/frontHooks.php +++ b/setup/frontHooks.php @@ -655,7 +655,8 @@ add_filter( // echo '
$member_info_id: ' . print_r( $member_info_id, true ) . '
'; 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 + 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 FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "member_info MI LEFT OUTER JOIN " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "cities C ON (C.id = MI.city) WHERE MI.id = $member_info_id"; -- 2.17.1