From c4c575979ee6e7162aa5f2787f1028c1a5aa04f3 Mon Sep 17 00:00:00 2001
From: paca70 <paca70>
Date: Fri, 25 Apr 2003 19:32:38 +0000
Subject: [PATCH] Allow caseinsensitive search for postgesql

---
 mod/forum/lib.php | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/mod/forum/lib.php b/mod/forum/lib.php
index a43288d31b..ce72620ee5 100644
--- a/mod/forum/lib.php
+++ b/mod/forum/lib.php
@@ -431,12 +431,19 @@ function forum_search_posts($search, $courseid, $page=0, $recordsperpage=50) {
              $limit = "LIMIT $recordsperpage,$page";
     }
 
+    //to allow caseinsensitive search for postgesql
+    if($CFG->dbtype == "postgres7") {
+       $LIKE = "ILIKE";
+       }else {
+       $LIKE = "LIKE";
+    }
+
     return get_records_sql("SELECT p.*,u.firstname,u.lastname,u.email,u.picture
                             FROM {$CFG->prefix}forum_posts p,  
                                  {$CFG->prefix}forum_discussions d, 
                                  {$CFG->prefix}user u, 
                                  {$CFG->prefix}forum f
-                            WHERE (p.message LIKE '%$search%' OR p.subject LIKE '%$search%')
+                            WHERE (p.message $LIKE '%$search%' OR p.subject $LIKE '%$search%')
                               AND p.userid = u.id 
                               AND p.discussion = d.id 
                               AND d.course = '$courseid' 
-- 
2.39.5