$roo->jok($core_group->memberCount());
}
}
+
+
- DB_DataObject::debugLevel(5);
+ $cp = DB_DataObject::Factory('core_person');
+ $cgm = DB_DataObject::Factory('core_group_member');
- $cgmDBObj = DB_DataObject::Factory('core_group_member');
- $cpObj = DB_DataObject::Factory('core_person');
- $cgm = DB_DataObject::Factory('core_group_member')->tableName();
- $cpObj->active = 1; // set the where condition with active = 1
- /*$this->selectAdd("
+ $this->selectAdd("
(
SELECT
count(user_id)
{$cgm}
WHERE
{$this->tableName()}.id = {$cgm}.group_id
+
+ AND
+ {$cp}.active = 1
)
AS group_member_count
- ");*/
- $cgmDBObj->joinAdd($cpObj);
+ ");
+
+
+
+
+ /*$cgmDBObj->joinAdd($cpObj);
$this->joinAdd($cgmDBObj);
-
+ DB_DataObject::debugLevel();*/
}
function toEventString() {