public function getPermissionsForAnyVerifiedUserInSite(SiteModel $siteModel, $removeEditorPermissions = false, $includeChildrenPermissions = false) { global $DB, $CONFIG; $stat = $DB->prepare("SELECT permission_in_user_group.* FROM permission_in_user_group " . " JOIN user_group_information ON user_group_information.id = permission_in_user_group.user_group_id AND user_group_information.is_deleted = '0' AND user_group_information.is_in_index = '0' " . " JOIN user_group_in_site ON user_group_in_site.user_group_id = user_group_information.id AND user_group_in_site.site_id = :site_id AND user_group_in_site.removed_at IS NULL " . " WHERE permission_in_user_group.removed_at IS NULL AND (user_group_information.is_includes_verified_users = '1' OR user_group_information.is_includes_users = '1' OR user_group_information.is_includes_anonymous = '1' )"); $stat->execute(array('site_id' => $siteModel->getId())); $permissions = array(); while ($data = $stat->fetch()) { $ext = $this->extensionsManager->getExtensionById($data['extension_id']); if ($ext) { $per = $ext->getUserPermission($data['permission_key']); if ($per) { $permissions[] = $per; } } } $user = new UserAccountModel(); $user->setIsEditor(true); return new \UserPermissionsList($this->extensionsManager, $permissions, $user, $CONFIG->siteReadOnly || $removeEditorPermissions, $includeChildrenPermissions); }