original_string: protected static function fetch_concepts(array $glossaries) {
          global $DB;
  
          $glossarylist = implode(',', $glossaries);
  
          $sql = "SELECT id, glossaryid, concept, casesensitive, 0 AS category, fullmatch
                    FROM {glossary_entries}
                   WHERE glossaryid IN ($glossarylist) AND usedynalink = 1 AND approved = 1
  
                   UNION
  
                  SELECT id, glossaryid, name AS concept, 1 AS casesensitive, 1 AS category, 1 AS fullmatch
                    FROM {glossary_categories}
                   WHERE glossaryid IN ($glossarylist) AND usedynalink = 1
  
                  UNION
  
                  SELECT ge.id, ge.glossaryid, ga.alias AS concept, ge.casesensitive, 0 AS category, ge.fullmatch
                    FROM {glossary_alias} ga
                    JOIN {glossary_entries} ge ON (ga.entryid = ge.id)
                   WHERE ge.glossaryid IN ($glossarylist) AND ge.usedynalink = 1 AND ge.approved = 1";
  
          $concepts = array();
          $rs = $DB->get_recordset_sql($sql);
          foreach ($rs as $concept) {
              $currentconcept = trim(strip_tags($concept->concept));
  
              // Concept must be HTML-escaped, so do the same as format_string to turn ampersands into &amp;.
              $currentconcept = replace_ampersands_not_followed_by_entity($currentconcept);
  
              if (empty($currentconcept)) {
                  continue;
              }
  
              // Rule out any small integers, see MDL-1446.
              if (is_number($currentconcept) and $currentconcept < 1000) {
                  continue;
              }
  
              $concept->concept = $currentconcept;
  
              $concepts[$concept->glossaryid][] = $concept;
          }
          $rs->close();
  
          return $concepts;
      }
code: protected static function fetch_concepts(array $glossaries) {
          global $DB;
  
          $glossarylist = implode(',', $glossaries);
  
          $sql = "SELECT id, glossaryid, concept, casesensitive, 0 AS category, fullmatch
                    FROM {glossary_entries}
                   WHERE glossaryid IN ($glossarylist) AND usedynalink = 1 AND approved = 1
  
                   UNION
  
                  SELECT id, glossaryid, name AS concept, 1 AS casesensitive, 1 AS category, 1 AS fullmatch
                    FROM {glossary_categories}
                   WHERE glossaryid IN ($glossarylist) AND usedynalink = 1
  
                  UNION
  
                  SELECT ge.id, ge.glossaryid, ga.alias AS concept, ge.casesensitive, 0 AS category, ge.fullmatch
                    FROM {glossary_alias} ga
                    JOIN {glossary_entries} ge ON (ga.entryid = ge.id)
                   WHERE ge.glossaryid IN ($glossarylist) AND ge.usedynalink = 1 AND ge.approved = 1";
  
          $concepts = array();
          $rs = $DB->get_recordset_sql($sql);
          foreach ($rs as $concept) {
              $currentconcept = trim(strip_tags($concept->concept));
  
              // Concept must be HTML-escaped, so do the same as format_string to turn ampersands into &amp;.
              $currentconcept = replace_ampersands_not_followed_by_entity($currentconcept);
  
              if (empty($currentconcept)) {
                  continue;
              }
  
              // Rule out any small integers, see MDL-1446.
              if (is_number($currentconcept) and $currentconcept < 1000) {
                  continue;
              }
  
              $concept->concept = $currentconcept;
  
              $concepts[$concept->glossaryid][] = $concept;
          }
          $rs->close();
  
          return $concepts;
      }
code_tokens: protected static function fetch_concepts ( array $ glossaries ) { global $ DB ; $ glossarylist = implode ( ',' , $ glossaries ) ; $ sql = "SELECT id, glossaryid, concept, casesensitive, 0 AS category, fullmatch
                    FROM {glossary_entries}
                   WHERE glossaryid IN ($glossarylist) AND usedynalink = 1 AND approved = 1
  
                   UNION
  
                  SELECT id, glossaryid, name AS concept, 1 AS casesensitive, 1 AS category, 1 AS fullmatch
                    FROM {glossary_categories}
                   WHERE glossaryid IN ($glossarylist) AND usedynalink = 1
  
                  UNION
  
                  SELECT ge.id, ge.glossaryid, ga.alias AS concept, ge.casesensitive, 0 AS category, ge.fullmatch
                    FROM {glossary_alias} ga
                    JOIN {glossary_entries} ge ON (ga.entryid = ge.id)
                   WHERE ge.glossaryid IN ($glossarylist) AND ge.usedynalink = 1 AND ge.approved = 1" ; $ concepts = array ( ) ; $ rs = $ DB -> get_recordset_sql ( $ sql ) ; foreach ( $ rs as $ concept ) { $ currentconcept = trim ( strip_tags ( $ concept -> concept ) ) ; // Concept must be HTML-escaped, so do the same as format_string to turn ampersands into &amp;. $ currentconcept = replace_ampersands_not_followed_by_entity ( $ currentconcept ) ; if ( empty ( $ currentconcept ) ) { continue ; } // Rule out any small integers, see MDL-1446. if ( is_number ( $ currentconcept ) and $ currentconcept < 1000 ) { continue ; } $ concept -> concept = $ currentconcept ; $ concepts [ $ concept -> glossaryid ] [ ] = $ concept ; } $ rs -> close ( ) ; return $ concepts ; }
docstring: Fetch concepts for given glossaries.
  @param int[] $glossaries
  @return array
docstring_tokens: Fetch concepts for given glossaries .