From 310471950e90275f7906aa4d416aa0e67456db45 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Sun, 1 Oct 2006 19:35:27 +0000
Subject: [PATCH] Cannot add glossary category MDL-6713

---
 mod/glossary/editcategories.php | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

diff --git a/mod/glossary/editcategories.php b/mod/glossary/editcategories.php
index e78c149cd1..87a562aa03 100644
--- a/mod/glossary/editcategories.php
+++ b/mod/glossary/editcategories.php
@@ -130,7 +130,8 @@
 
     } elseif ( $action == "add" ) {
         if ( $confirm ) {
-            $dupcategory = get_record("glossary_categories",lower(name),strtolower($name),"glossaryid",$glossary->id);
+            $ILIKE = sql_ilike();
+            $dupcategory = get_records_sql("SELECT * FROM {$CFG->prefix}glossary_categories WHERE name $ILIKE '$name'");
             if ( $dupcategory ) {
                 echo "<p align=\"center\">" . get_string("add"). " " . get_string("category","glossary") . "<font size=\"3\">";
 
@@ -139,8 +140,6 @@
                 echo "</center>";
                 print_simple_box_end();
 
-                print_footer($course);
-
                 redirect("editcategories.php?id=$cm->id&amp;action=add&&amp;name=$name");
 
             } else {
-- 
2.39.5