From 6d3f425810f9de4e7247148054701233c3cad3e5 Mon Sep 17 00:00:00 2001 From: Laury GvR Date: Thu, 13 Apr 2017 10:57:11 -0400 Subject: [PATCH] Added parent_id to the memberinfo category data --- classes/data/dataMemberInfo.php | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/classes/data/dataMemberInfo.php b/classes/data/dataMemberInfo.php index 32dfb0b7..a889b3d5 100644 --- a/classes/data/dataMemberInfo.php +++ b/classes/data/dataMemberInfo.php @@ -584,7 +584,15 @@ class GlmDataMemberInfo extends GlmDataAbstract FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "categories WHERE id = C.parent ), '' - ) AS parent_name + ) AS parent_name, + COALESCE ( + ( + SELECT id + FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."categories + WHERE id = C.parent + ), '' + ) AS parent_id + FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "categories AS C, ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "category_member_info AS CMI WHERE C.id = CMI.category -- 2.17.1