From: benny <benny@roojs.com>
Date: Wed, 1 Aug 2018 04:58:58 +0000 (+0800)
Subject: DataObjects/Core_group.php
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=7c054a4d976a431b6b47333f74a07e15936db5d9

DataObjects/Core_group.php
---

diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php
index 3beff8bc..c2a559a9 100644
--- a/DataObjects/Core_group.php
+++ b/DataObjects/Core_group.php
@@ -55,14 +55,16 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject
             }
         }
         
-        if(!empty($q['_with_member_id'])){
+        if(!empty($q['mem_id'])){
             $this->selectAdd("
                 COALESCE(
                     (SELECT id from core_group_member
-                        WHERE ...
-                        
+                        WHERE 
+                            user_id = {$q['mem_id']}
+                        AND
+                            group_id = {$this->tableName()}.id
                         LIMIT 1
-                    ),0) as ....
+                    ),0) as cgm_id
                     ");
         }