units/search/search_suggest_users.php

   1 <?php
   2 global $CFG, $db, $PAGE;
   3
   4 if (isset($parameter)) {
   5
   6     if (!empty($PAGE->search_type_unformatted)) {
   7                 $typeline = " AND user_type = " . $PAGE->search_type;
   8             } else {
   9                 $typeline = "";
  10             }
  11
  12     if ($CFG->dbtype == 'mysql') {
  13         $dbname = $db->qstr($parameter);
  14         $searchline = "SELECT DISTINCT name,username,MATCH(name) AGAINST (" . $dbname . ") AS score
  15                        FROM ".$CFG->prefix."users WHERE (MATCH(name) AGAINST (" . $dbname . ") > 0) $typeline LIMIT 20";
  16     } else {
  17         $dbname = $db->qstr("%" . $parameter . "%");
  18         $searchline = "SELECT DISTINCT name,username
  19                        FROM ".$CFG->prefix."users WHERE (name LIKE " . $dbname . ") $typeline LIMIT 20";
  20     }
  21
  22     if ($results = get_records_sql($searchline)) {
  23         $run_result .= "<h2>" . __gettext("Matching accounts:") . "</h2><p>";
  24         foreach($results as $returned_name) {
  25             $run_result .= "<a href=\"" . url . $returned_name->username . '/">' . htmlspecialchars($returned_name->name) . "</a> <br />";
  26         }
  27         $run_result .= "</p>";
  28
  29     }
  30
  31 }
  32
  33 ?>