From: benny <benny@roojs.com>
Date: Thu, 26 Jul 2018 08:05:59 +0000 (+0800)
Subject: DataObjects/Core_group.php
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=875a80d08067796b5faf5331daeaa1ee411b0347

DataObjects/Core_group.php
---

diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php
index 6658918f..f4dead47 100644
--- a/DataObjects/Core_group.php
+++ b/DataObjects/Core_group.php
@@ -66,8 +66,9 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject
             FROM 
                 {$cgm}
             WHERE 
-                {$this->tableName()}.id = {$cgm}.group_id
-            
+                {$this->tableName()}.id = {$cgm->tableName()}.group_id
+            AND
+                {$cgm->tableName()}.user_id = {$cp->tableName()}.id
             AND
                 {$cp}.active = 1
             )