X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_group.php;h=c9f12bc1f4e92c96abca0b57e0ce77b21219c066;hb=7e47084723e8e83d89498da0e605d325e5add1a4;hp=cd9f90437440df399d3546a85f730491cc4a7962;hpb=11b992de3c7a3103f6bb71b29bf11bf5eefd9588;p=Pman.Core diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index cd9f9043..c9f12bc1 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -54,27 +54,22 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject } } - DB_DataObject::debugLevel(1); + $cp = DB_DataObject::Factory('core_person')->tableName(); $cgm = DB_DataObject::Factory('core_group_member')->tableName(); - + $this->selectAdd(" ( SELECT count(user_id) FROM - {$cgm} - WHERE - {$this->tableName()}.id = {$cgm}.group_id - AND - {$cgm}.user_id = {$cp}.id - AND - {$cp}.active = 1 + core_group_member + ) AS group_member_count "); - DB_DataObject::debugLevel(); +