DataObjects/Core_group.php
authorbenny <benny@roojs.com>
Thu, 26 Jul 2018 08:05:59 +0000 (16:05 +0800)
committerbenny <benny@roojs.com>
Thu, 26 Jul 2018 08:05:59 +0000 (16:05 +0800)
DataObjects/Core_group.php

index 6658918..f4dead4 100644 (file)
@@ -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
             )