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)); }