General help

When removing the unwanted spaces in the above quey I get (exemple to list french-R entries):

SELECT ge.*, ge.concept pivot FROM mdl_glossary_entries ge WHERE (ge.glossaryid = '1' or ge.sourceglossaryid = '1') AND (ge.approved != 0 ) AND left(ucase(trim(LEADING '<lang lang="fr_ca">' FROM ge.concept)),1) = 'R' ORDER BY ge.concept LIMIT 0, 10


This query works fine when used in phpMySQL but doesn't do the job when used in moodle... What did I missed?

seb

I found my way around and thought I should share this... The two following steps did the job:

Anywhere at the beginning of the glossary/sql.php file, add:

if (current_language() == 'fr_ca') { $delimiter = 'SUBSTRING_INDEX(ge.concept, '>', -4)'; }
elseif (current_language() == 'en') { $delimiter = 'SUBSTRING_INDEX(ge.concept, '>', -2)'; }

Later in the file (around line 215), replace the $WHERE as follow:

        case 'letter':
            if ($hook != 'ALL' and $hook != 'SPECIAL') {
                switch ($CFG->dbtype) {
                case 'postgres7':
                    $where = 'AND substr(upper(concept),1,' .  strlen($hook) . ') = '' . strtoupper($hook) . ''';
                break;
                case 'mysql':
//$where = 'AND left(ucase(concept),' .  strlen($hook) . ") = '" . strtoupper($hook) . "'"; //ORIGINAL CODE
                $where = 'AND left(ucase('.$delimiter.'),' .  strlen($hook) . ") = '" . strtoupper($hook) . "' "; // MERIDIUM -> for multilang glossary !!!
                break;
                }

LATER IN THIS FILE replace the $sqlorderby BY:

        case GLOSSARY_STANDARD_VIEW:
            //$sqlorderby = "ORDER BY ge.concept";// ORIGINAL
      $sqlorderby = "ORDER BY ".$delimiter;//Meridium


As the glossary->concepts will always begin with a '<', you will have to play around this in the view.php  in order to get a representative Pivot.

In glossary/view.php(around line 320):

After:  foreach ($allentries as $entry)

            REPLACE $pivot = $entry->pivot; //ORIGINAL
            BY: $pivot = multilang_filter($courseid, $entry->pivot); //Meridium -> Multilang filter

I did not use the format_text() function as this was adding autolinks in the pivots... (the glossary filter is active) Filters are tricky.

Additionnally, you may need to edit the table structure to allow for longer concepts...

Remember that the above changes are quite intuitive as I'm not an advanced programmer.

Cheers.  SEB