protected function loadModerators()
{
$list = $this->joomlaAccess->loadModerators();
// TODO: add support into CB
$params = array('list' => &$list);
$this->integration->trigger('loadModerators', $params);
return parent::loadModerators($list);
}
protected function loadModerators()
{
$db = JFactory::getDBO();
$query = "SELECT u.id AS userid, m.catid\n\t\t\t\tFROM #__users AS u\n\t\t\t\tINNER JOIN #__kunena_users AS ku ON u.id=ku.userid\n\t\t\t\tLEFT JOIN #__kunena_moderation AS m ON u.id=m.userid\n\t\t\t\tLEFT JOIN #__kunena_categories AS c ON m.catid=c.id\n\t\t\t\tWHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1')";
$db->setQuery($query);
$list = (array) $db->loadObjectList();
KunenaError::checkDatabaseError();
return parent::loadModerators($list);
}
protected function loadModerators()
{
$list = $this->joomlaAccess->loadModerators();
$db = JFactory::getDBO();
$query = "SELECT g.memberid AS userid, c.id AS catid\n\t\t\tFROM #__kunena_categories AS c\n\t\t\tINNER JOIN #__community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid\n\t\t\tWHERE c.published=1 AND g.approved=1 AND g.permissions={$db->Quote(COMMUNITY_GROUP_ADMIN)}";
$db->setQuery($query);
$jslist = (array) $db->loadObjectList();
KunenaError::checkDatabaseError();
return parent::loadModerators(array_merge($list, $jslist));
}
