Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.11.x will end 14 Nov 2022 (12 months plus 6 months extension).
  • Bug fixes for security issues in 3.11.x will end 13 Nov 2023 (18 months plus 12 months extension).
  • PHP version: minimum PHP 7.3.0 Note: minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is supported too.

Differences Between: [Versions 311 and 401] [Versions 311 and 402] [Versions 311 and 403]

   1  <?php
   2  
   3  // This file is part of Moodle - http://moodle.org/
   4  //
   5  // Moodle is free software: you can redistribute it and/or modify
   6  // it under the terms of the GNU General Public License as published by
   7  // the Free Software Foundation, either version 3 of the License, or
   8  // (at your option) any later version.
   9  //
  10  // Moodle is distributed in the hope that it will be useful,
  11  // but WITHOUT ANY WARRANTY; without even the implied warranty of
  12  // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  13  // GNU General Public License for more details.
  14  //
  15  // You should have received a copy of the GNU General Public License
  16  // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
  17  
  18  /**
  19   * Provides various useful functionality to plugins that offer or use this MNet service
  20   *
  21   * Remote enrolment service is used by enrol_mnet plugin which publishes the server side
  22   * methods. The client side is accessible from the admin tree.
  23   *
  24   * @package    mnetservice
  25   * @subpackage enrol
  26   * @copyright  2010 David Mudrak <david@moodle.com>
  27   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  28   */
  29  
  30  defined('MOODLE_INTERNAL') || die();
  31  
  32  require_once($CFG->dirroot . '/user/selector/lib.php');
  33  
  34  /**
  35   * Singleton providing various functionality usable by plugin(s) implementing this MNet service
  36   */
  37  class mnetservice_enrol {
  38  
  39      /** @var mnetservice_enrol holds the singleton instance. */
  40      protected static $singleton;
  41  
  42      /** @var caches the result of {@link self::get_remote_subscribers()} */
  43      protected $cachesubscribers = null;
  44  
  45      /** @var caches the result of {@link self::get_remote_publishers()} */
  46      protected $cachepublishers = null;
  47  
  48      /**
  49       * This is singleton, use {@link mnetservice_enrol::get_instance()}
  50       */
  51      protected function __construct() {
  52      }
  53  
  54      /**
  55       * @return mnetservice_enrol singleton instance
  56       */
  57      public static function get_instance() {
  58          if (is_null(self::$singleton)) {
  59              self::$singleton = new self();
  60          }
  61          return self::$singleton;
  62      }
  63  
  64      /**
  65       * Is this service enabled?
  66       *
  67       * Currently, this checks if whole MNet is available. In the future, additional
  68       * checks can be done. Probably the field 'offer' should be checked but it does
  69       * not seem to be used so far.
  70       *
  71       * @todo move this to some parent class once we have such
  72       * @return bool
  73       */
  74      public function is_available() {
  75          global $CFG;
  76  
  77          if (empty($CFG->mnet_dispatcher_mode) || $CFG->mnet_dispatcher_mode !== 'strict') {
  78              return false;
  79          }
  80          return true;
  81      }
  82  
  83      /**
  84       * Returns a list of remote servers that can enrol their users into our courses
  85       *
  86       * We must publish MNet service 'mnet_enrol' for the peers to allow them to enrol
  87       * their users into our courses.
  88       *
  89       * @todo once the MNet core is refactored this may be part of a parent class
  90       * @todo the name of the service should be changed to the name of this plugin
  91       * @return array
  92       */
  93      public function get_remote_subscribers() {
  94          global $DB;
  95  
  96          if (is_null($this->cachesubscribers)) {
  97              $sql = "SELECT DISTINCT h.id, h.name AS hostname, h.wwwroot AS hosturl,
  98                             a.display_name AS appname
  99                        FROM {mnet_host} h
 100                        JOIN {mnet_host2service} hs ON h.id = hs.hostid
 101                        JOIN {mnet_service} s ON hs.serviceid = s.id
 102                        JOIN {mnet_application} a ON h.applicationid = a.id
 103                       WHERE s.name = 'mnet_enrol'
 104                             AND h.deleted = 0
 105                             AND hs.publish = 1";
 106              $this->cachesubscribers = $DB->get_records_sql($sql);
 107          }
 108  
 109          return $this->cachesubscribers;
 110      }
 111  
 112      /**
 113       * Returns a list of remote servers that offer their courses for our users
 114       *
 115       * We must subscribe MNet service 'mnet_enrol' for the peers to allow our users to enrol
 116       * into their courses.
 117       *
 118       * @todo once the MNet core is refactored this may be part of a parent class
 119       * @todo the name of the service should be changed to the name of this plugin
 120       * @return array
 121       */
 122      public function get_remote_publishers() {
 123          global $DB;
 124  
 125          if (is_null($this->cachepublishers)) {
 126              $sql = "SELECT DISTINCT h.id, h.name AS hostname, h.wwwroot AS hosturl,
 127                             a.display_name AS appname
 128                        FROM {mnet_host} h
 129                        JOIN {mnet_host2service} hs ON h.id = hs.hostid
 130                        JOIN {mnet_service} s ON hs.serviceid = s.id
 131                        JOIN {mnet_application} a ON h.applicationid = a.id
 132                       WHERE s.name = 'mnet_enrol'
 133                             AND h.deleted = 0
 134                             AND hs.subscribe = 1";
 135              $this->cachepublishers = $DB->get_records_sql($sql);
 136          }
 137  
 138          return $this->cachepublishers;
 139      }
 140  
 141      /**
 142       * Fetches the information about the courses available on remote host for our students
 143       *
 144       * The information about remote courses available for us is cached in {mnetservice_enrol_courses}.
 145       * This method either returns the cached information (typically when displaying the list to
 146       * students) or fetch fresh data via new XML-RPC request (which updates the local cache, too).
 147       * The lifetime of the cache is 1 day, so even if $usecache is set to true, the cache will be
 148       * re-populated if we did not fetch from any server (not only the currently requested one)
 149       * for some time.
 150       *
 151       * @param id $mnethostid MNet remote host id
 152       * @param bool $usecache use cached data or invoke new XML-RPC?
 153       * @uses mnet_xmlrpc_client Invokes XML-RPC request if the cache is not used
 154       * @return array|string returned list or serialized array of mnet error messages
 155       */
 156      public function get_remote_courses($mnethostid, $usecache=true) {
 157          global $CFG, $DB; // $CFG needed!
 158  
 159          $lastfetchcourses = get_config('mnetservice_enrol', 'lastfetchcourses');
 160          if (empty($lastfetchcourses) or (time()-$lastfetchcourses > DAYSECS)) {
 161              $usecache = false;
 162          }
 163  
 164          if ($usecache) {
 165              return $DB->get_records('mnetservice_enrol_courses', array('hostid' => $mnethostid), 'sortorder, shortname');
 166          }
 167  
 168          // do not use cache - fetch fresh list from remote MNet host
 169          require_once $CFG->dirroot.'/mnet/xmlrpc/client.php';
 170          $peer = new mnet_peer();
 171          if (!$peer->set_id($mnethostid)) {
 172              return serialize(array('unknown mnet peer'));
 173          }
 174  
 175          $request = new mnet_xmlrpc_client();
 176          $request->set_method('enrol/mnet/enrol.php/available_courses');
 177  
 178          if ($request->send($peer)) {
 179              $list = array();
 180              $response = $request->response;
 181  
 182              // get the currently cached courses key'd on remote id - only need remoteid and id fields
 183              $cachedcourses = $DB->get_records('mnetservice_enrol_courses', array('hostid' => $mnethostid), 'remoteid', 'remoteid, id');
 184  
 185              foreach ($response as &$remote) {
 186                  $course                 = new stdclass(); // record in our local cache
 187                  $course->hostid         = $mnethostid;
 188                  $course->remoteid       = (int)$remote['remoteid'];
 189                  $course->categoryid     = (int)$remote['cat_id'];
 190                  $course->categoryname   = substr($remote['cat_name'], 0, 255);
 191                  $course->sortorder      = (int)$remote['sortorder'];
 192                  $course->fullname       = substr($remote['fullname'], 0, 254);
 193                  $course->shortname      = substr($remote['shortname'], 0, 100);
 194                  $course->idnumber       = substr($remote['idnumber'], 0, 100);
 195                  $course->summary        = $remote['summary'];
 196                  $course->summaryformat  = empty($remote['summaryformat']) ? FORMAT_MOODLE : (int)$remote['summaryformat'];
 197                  $course->startdate      = (int)$remote['startdate'];
 198                  $course->roleid         = (int)$remote['defaultroleid'];
 199                  $course->rolename       = substr($remote['defaultrolename'], 0, 255);
 200                  // We do not cache the following fields returned from peer in 2.0 any more
 201                  // not cached: cat_description
 202                  // not cached: cat_descriptionformat
 203                  // not cached: cost
 204                  // not cached: currency
 205  
 206                  if (empty($cachedcourses[$course->remoteid])) {
 207                      $course->id = $DB->insert_record('mnetservice_enrol_courses', $course);
 208                  } else {
 209                      $course->id = $cachedcourses[$course->remoteid]->id;
 210                      $DB->update_record('mnetservice_enrol_courses', $course);
 211                  }
 212  
 213                  $list[$course->remoteid] = $course;
 214              }
 215  
 216              // prune stale data from cache
 217              if (!empty($cachedcourses)) {
 218                  foreach ($cachedcourses as $cachedcourse) {
 219                      if (!empty($list[$cachedcourse->remoteid])) {
 220                          unset($cachedcourses[$cachedcourse->remoteid]);
 221                      }
 222                  }
 223                  $staleremoteids = array_keys($cachedcourses);
 224                  if (!empty($staleremoteids)) {
 225                      list($sql, $params) = $DB->get_in_or_equal($staleremoteids, SQL_PARAMS_NAMED);
 226                      $select = "hostid=:hostid AND remoteid $sql";
 227                      $params['hostid'] = $mnethostid;
 228                      $DB->delete_records_select('mnetservice_enrol_courses', $select, $params);
 229                  }
 230              }
 231  
 232              // and return the fresh data
 233              set_config('lastfetchcourses', time(), 'mnetservice_enrol');
 234              return $list;
 235  
 236          } else {
 237              return serialize($request->error);
 238          }
 239      }
 240  
 241      /**
 242       * Updates local cache about enrolments of our users in remote courses
 243       *
 244       * The remote course must allow enrolments via our Remote enrolment service client.
 245       * Because of legacy design of data structure returned by XML-RPC code, only one
 246       * user enrolment per course is returned by 1.9 MNet servers. This may be an issue
 247       * if the user is enrolled multiple times by various enrolment plugins. MNet 2.0
 248       * servers do not use user name as array keys - they do not need to due to side
 249       * effect of MDL-19219.
 250       *
 251       * @param id $mnethostid MNet remote host id
 252       * @param int $remotecourseid ID of the course at the remote host
 253       * @param bool $usecache use cached data or invoke new XML-RPC?
 254       * @uses mnet_xmlrpc_client Invokes XML-RPC request
 255       * @return bool|string true if success or serialized array of mnet error messages
 256       */
 257      public function req_course_enrolments($mnethostid, $remotecourseid) {
 258          global $CFG, $DB; // $CFG needed!
 259          require_once $CFG->dirroot.'/mnet/xmlrpc/client.php';
 260  
 261          if (!$DB->record_exists('mnetservice_enrol_courses', array('hostid'=>$mnethostid, 'remoteid'=>$remotecourseid))) {
 262              return serialize(array('course not available for remote enrolments'));
 263          }
 264  
 265          $peer = new mnet_peer();
 266          if (!$peer->set_id($mnethostid)) {
 267              return serialize(array('unknown mnet peer'));
 268          }
 269  
 270          $request = new mnet_xmlrpc_client();
 271          $request->set_method('enrol/mnet/enrol.php/course_enrolments');
 272          $request->add_param($remotecourseid, 'int');
 273  
 274          if ($request->send($peer)) {
 275              $list = array();
 276              $response = $request->response;
 277  
 278              // prepare a table mapping usernames of our users to their ids
 279              $usernames = array();
 280              foreach ($response as $unused => $remote) {
 281                  if (!isset($remote['username'])) {
 282                      // see MDL-19219
 283                      return serialize(array('remote host running old version of mnet server - does not return username attribute'));
 284                  }
 285                  if ($remote['username'] == 'guest') { // we can not use $CFG->siteguest here
 286                      // do not try nasty things you bastard!
 287                      continue;
 288                  }
 289                  $usernames[$remote['username']] = $remote['username'];
 290              }
 291  
 292              if (!empty($usernames)) {
 293                  list($usql, $params) = $DB->get_in_or_equal($usernames, SQL_PARAMS_NAMED);
 294                  list($sort, $sortparams) = users_order_by_sql();
 295                  $params['mnetlocalhostid'] = $CFG->mnet_localhost_id;
 296                  $sql = "SELECT username,id
 297                            FROM {user}
 298                           WHERE mnethostid = :mnetlocalhostid
 299                                 AND username $usql
 300                                 AND deleted = 0
 301                                 AND confirmed = 1
 302                        ORDER BY $sort";
 303                  $usersbyusername = $DB->get_records_sql($sql, array_merge($params, $sortparams));
 304              } else {
 305                  $usersbyusername = array();
 306              }
 307  
 308              // populate the returned list and update local cache of enrolment records
 309              foreach ($response as $remote) {
 310                  if (empty($usersbyusername[$remote['username']])) {
 311                      // we do not know this user or she is deleted or not confirmed or is 'guest'
 312                      continue;
 313                  }
 314                  $enrolment                  = new stdclass();
 315                  $enrolment->hostid          = $mnethostid;
 316                  $enrolment->userid          = $usersbyusername[$remote['username']]->id;
 317                  $enrolment->remotecourseid  = $remotecourseid;
 318                  $enrolment->rolename        = $remote['name']; // $remote['shortname'] not used
 319                  $enrolment->enroltime       = $remote['timemodified'];
 320                  $enrolment->enroltype       = $remote['enrol'];
 321  
 322                  $current = $DB->get_record('mnetservice_enrol_enrolments', array('hostid'=>$enrolment->hostid, 'userid'=>$enrolment->userid,
 323                                         'remotecourseid'=>$enrolment->remotecourseid, 'enroltype'=>$enrolment->enroltype), 'id, enroltime');
 324                  if (empty($current)) {
 325                      $enrolment->id = $DB->insert_record('mnetservice_enrol_enrolments', $enrolment);
 326                  } else {
 327                      $enrolment->id = $current->id;
 328                      if ($current->enroltime != $enrolment->enroltime) {
 329                          $DB->update_record('mnetservice_enrol_enrolments', $enrolment);
 330                      }
 331                  }
 332  
 333                  $list[$enrolment->id] = $enrolment;
 334              }
 335  
 336              // prune stale enrolment records
 337              if (empty($list)) {
 338                  $DB->delete_records('mnetservice_enrol_enrolments', array('hostid'=>$mnethostid, 'remotecourseid'=>$remotecourseid));
 339              } else {
 340                  list($isql, $params) = $DB->get_in_or_equal(array_keys($list), SQL_PARAMS_NAMED, 'param', false);
 341                  $params['hostid'] = $mnethostid;
 342                  $params['remotecourseid'] = $remotecourseid;
 343                  $select = "hostid = :hostid AND remotecourseid = :remotecourseid AND id $isql";
 344                  $DB->delete_records_select('mnetservice_enrol_enrolments', $select, $params);
 345              }
 346  
 347              // store the timestamp of the recent fetch, can be used for cache invalidate purposes
 348              set_config('lastfetchenrolments', time(), 'mnetservice_enrol');
 349              // local cache successfully updated
 350              return true;
 351  
 352          } else {
 353              return serialize($request->error);
 354          }
 355      }
 356  
 357      /**
 358       * Send request to enrol our user to the remote course
 359       *
 360       * Updates our remote enrolments cache if the enrolment was successful.
 361       *
 362       * @uses mnet_xmlrpc_client Invokes XML-RPC request
 363       * @param object $user our user
 364       * @param object $remotecourse record from mnetservice_enrol_courses table
 365       * @return true|string true if success, error message from the remote host otherwise
 366       */
 367      public function req_enrol_user(stdclass $user, stdclass $remotecourse) {
 368          global $CFG, $DB;
 369          require_once($CFG->dirroot.'/mnet/xmlrpc/client.php');
 370  
 371          $peer = new mnet_peer();
 372          $peer->set_id($remotecourse->hostid);
 373  
 374          $request = new mnet_xmlrpc_client();
 375          $request->set_method('enrol/mnet/enrol.php/enrol_user');
 376          $request->add_param(mnet_strip_user((array)$user, mnet_fields_to_send($peer)));
 377          $request->add_param($remotecourse->remoteid);
 378  
 379          if ($request->send($peer) === true) {
 380              if ($request->response === true) {
 381                  // cache the enrolment information in our table
 382                  $enrolment                  = new stdclass();
 383                  $enrolment->hostid          = $peer->id;
 384                  $enrolment->userid          = $user->id;
 385                  $enrolment->remotecourseid  = $remotecourse->remoteid;
 386                  $enrolment->enroltype       = 'mnet';
 387                  // $enrolment->rolename not known now, must be re-fetched
 388                  // $enrolment->enroltime not known now, must be re-fetched
 389                  $DB->insert_record('mnetservice_enrol_enrolments', $enrolment);
 390                  return true;
 391  
 392              } else {
 393                  return serialize(array('invalid response: '.print_r($request->response, true)));
 394              }
 395  
 396          } else {
 397              return serialize($request->error);
 398          }
 399      }
 400  
 401      /**
 402       * Send request to unenrol our user from the remote course
 403       *
 404       * Updates our remote enrolments cache if the unenrolment was successful.
 405       *
 406       * @uses mnet_xmlrpc_client Invokes XML-RPC request
 407       * @param object $user our user
 408       * @param object $remotecourse record from mnetservice_enrol_courses table
 409       * @return true|string true if success, error message from the remote host otherwise
 410       */
 411      public function req_unenrol_user(stdclass $user, stdclass $remotecourse) {
 412          global $CFG, $DB;
 413          require_once($CFG->dirroot.'/mnet/xmlrpc/client.php');
 414  
 415          $peer = new mnet_peer();
 416          $peer->set_id($remotecourse->hostid);
 417  
 418          $request = new mnet_xmlrpc_client();
 419          $request->set_method('enrol/mnet/enrol.php/unenrol_user');
 420          $request->add_param($user->username);
 421          $request->add_param($remotecourse->remoteid);
 422  
 423          if ($request->send($peer) === true) {
 424              if ($request->response === true) {
 425                  // clear the cached information
 426                  $DB->delete_records('mnetservice_enrol_enrolments',
 427                      array('hostid'=>$peer->id, 'userid'=>$user->id, 'remotecourseid'=>$remotecourse->remoteid, 'enroltype'=>'mnet'));
 428                  return true;
 429  
 430              } else {
 431                  return serialize(array('invalid response: '.print_r($request->response, true)));
 432              }
 433  
 434          } else {
 435              return serialize($request->error);
 436          }
 437      }
 438  
 439      /**
 440       * Prepares error messages returned by our XML-RPC requests to be send as debug info to {@link print_error()}
 441       *
 442       * MNet client-side methods in this class return request error as serialized array.
 443       *
 444       * @param string $error serialized array
 445       * @return string
 446       */
 447      public function format_error_message($errormsg) {
 448          $errors = unserialize($errormsg);
 449          $output = 'mnet_xmlrpc_client request returned errors:'."\n";
 450          foreach ($errors as $error) {
 451              $output .= "$error\n";
 452          }
 453          return $output;
 454      }
 455  }
 456  
 457  /**
 458   * Selector of our users enrolled into remote course via enrol_mnet plugin
 459   */
 460  class mnetservice_enrol_existing_users_selector extends user_selector_base {
 461      /** @var id of the MNet peer */
 462      protected $hostid;
 463      /** @var id of the course at the remote server */
 464      protected $remotecourseid;
 465  
 466      public function __construct($name, $options) {
 467          $this->hostid = $options['hostid'];
 468          $this->remotecourseid = $options['remotecourseid'];
 469          parent::__construct($name, $options);
 470      }
 471  
 472      /**
 473       * Find our users currently enrolled into the remote course
 474       *
 475       * @param string $search
 476       * @return array
 477       */
 478      public function find_users($search) {
 479          global $DB;
 480  
 481          list($wherecondition, $params)  = $this->search_sql($search, 'u');
 482          $params['hostid']               = $this->hostid;
 483          $params['remotecourseid']       = $this->remotecourseid;
 484  
 485          $fields      = "SELECT ".$this->required_fields_sql("u");
 486          $countfields = "SELECT COUNT(1)";
 487  
 488          $sql = "          FROM {user} u
 489                            JOIN {mnetservice_enrol_enrolments} e ON e.userid = u.id
 490                           WHERE e.hostid = :hostid AND e.remotecourseid = :remotecourseid
 491                                 AND e.enroltype = 'mnet'
 492                                 AND $wherecondition";
 493  
 494          list($sort, $sortparams) = users_order_by_sql('u');
 495          $order = "    ORDER BY $sort";
 496  
 497          if (!$this->is_validating()) {
 498              $potentialmemberscount = $DB->count_records_sql($countfields . $sql, $params);
 499              if ($potentialmemberscount > 100) {
 500                  return $this->too_many_results($search, $potentialmemberscount);
 501              }
 502          }
 503  
 504          $availableusers = $DB->get_records_sql($fields . $sql . $order, array_merge($params, $sortparams));
 505  
 506          if (empty($availableusers)) {
 507              return array();
 508          }
 509  
 510          if ($search) {
 511              $groupname = get_string('enrolledusersmatching', 'enrol', $search);
 512          } else {
 513              $groupname = get_string('enrolledusers', 'enrol');
 514          }
 515  
 516          return array($groupname => $availableusers);
 517      }
 518  
 519      protected function get_options() {
 520          $options = parent::get_options();
 521          $options['hostid'] = $this->hostid;
 522          $options['remotecourseid'] = $this->remotecourseid;
 523          $options['file'] = 'mnet/service/enrol/locallib.php';
 524          return $options;
 525      }
 526  }
 527  
 528  /**
 529   * Selector of our users who could be enrolled into a remote course via their enrol_mnet
 530   */
 531  class mnetservice_enrol_potential_users_selector extends user_selector_base {
 532      /** @var id of the MNet peer */
 533      protected $hostid;
 534      /** @var id of the course at the remote server */
 535      protected $remotecourseid;
 536  
 537      public function __construct($name, $options) {
 538          $this->hostid = $options['hostid'];
 539          $this->remotecourseid = $options['remotecourseid'];
 540          parent::__construct($name, $options);
 541      }
 542  
 543      /**
 544       * Find our users who could be enrolled into the remote course
 545       *
 546       * Our users must have 'moodle/site:mnetlogintoremote' capability assigned.
 547       * Remote users, guests, deleted and not confirmed users are not returned.
 548       *
 549       * @param string $search
 550       * @return array
 551       */
 552      public function find_users($search) {
 553          global $CFG, $DB;
 554  
 555          $systemcontext = context_system::instance();
 556          $userids = get_users_by_capability($systemcontext, 'moodle/site:mnetlogintoremote', 'u.id');
 557  
 558          if (empty($userids)) {
 559              return array();
 560          }
 561  
 562          list($usql, $uparams) = $DB->get_in_or_equal(array_keys($userids), SQL_PARAMS_NAMED, 'uid');
 563  
 564          list($wherecondition, $params) = $this->search_sql($search, 'u');
 565  
 566          $params = array_merge($params, $uparams);
 567          $params['hostid'] = $this->hostid;
 568          $params['remotecourseid'] = $this->remotecourseid;
 569          $params['mnetlocalhostid'] = $CFG->mnet_localhost_id;
 570  
 571          $fields      = "SELECT ".$this->required_fields_sql("u");
 572          $countfields = "SELECT COUNT(1)";
 573  
 574          $sql = "          FROM {user} u
 575                           WHERE $wherecondition
 576                                 AND u.mnethostid = :mnetlocalhostid
 577                                 AND u.id $usql
 578                                 AND u.id NOT IN (SELECT e.userid
 579                                                    FROM {mnetservice_enrol_enrolments} e
 580                                                   WHERE (e.hostid = :hostid AND e.remotecourseid = :remotecourseid))";
 581  
 582          list($sort, $sortparams) = users_order_by_sql('u');
 583          $order = "    ORDER BY $sort";
 584  
 585          if (!$this->is_validating()) {
 586              $potentialmemberscount = $DB->count_records_sql($countfields . $sql, $params);
 587              if ($potentialmemberscount > 100) {
 588                  return $this->too_many_results($search, $potentialmemberscount);
 589              }
 590          }
 591  
 592          $availableusers = $DB->get_records_sql($fields . $sql . $order, array_merge($params, $sortparams));
 593  
 594          if (empty($availableusers)) {
 595              return array();
 596          }
 597  
 598          if ($search) {
 599              $groupname = get_string('enrolcandidatesmatching', 'enrol', $search);
 600          } else {
 601              $groupname = get_string('enrolcandidates', 'enrol');
 602          }
 603  
 604          return array($groupname => $availableusers);
 605      }
 606  
 607      protected function get_options() {
 608          $options = parent::get_options();
 609          $options['hostid'] = $this->hostid;
 610          $options['remotecourseid'] = $this->remotecourseid;
 611          $options['file'] = 'mnet/service/enrol/locallib.php';
 612          return $options;
 613      }
 614  }