新diff。做了一点儿小优化
Index: mod/glossary/sql.php
===================================================================
RCS file: /cvsroot/moodle/moodle/mod/glossary/sql.php,v
retrieving revision 1.23
diff -r1.23 sql.php
276c276,277
< $where = 'AND left(ucase(concept),' . strlen($hook) . ") = '" . strtoupper($hook) . "'";
---
> //$where = 'AND left(ucase(concept),' . strlen($hook) . ") = '" . strtoupper($hook) . "'";
> $where = 'AND EXISTS (SELECT * FROM `mdl_glossary_letter_map` WHERE letter = \'' .strtoupper($hook) . "' AND strcmp(ucase(left(concept, length(`character`))), `character`) = 0)";
295c296,298
< $where = 'AND left(ucase(concept),1) NOT IN (' . strtoupper($sqlalphabet) . ')';
---
> //$where = 'AND left(ucase(concept),1) NOT IN (' . strtoupper($sqlalphabet) . ')';
> $where = 'AND NOT EXISTS (SELECT * FROM `mdl_glossary_letter_map` WHERE strcmp(ucase(left(concept, length(`character`))), `character`)=0 )';
>
需要用第二个rar附件建一个数据库