From 92a2d92a82e47638a604656c332d2c957560e891 Mon Sep 17 00:00:00 2001
From: martinlanghoff <martinlanghoff>
Date: Tue, 26 Sep 2006 05:05:32 +0000
Subject: [PATCH] message_history_link() - replace use sql_concat() and
 sql_like()

---
 message/lib.php | 15 ++-------------
 1 file changed, 2 insertions(+), 13 deletions(-)

diff --git a/message/lib.php b/message/lib.php
index acdec0c456..f09612fa85 100644
--- a/message/lib.php
+++ b/message/lib.php
@@ -664,19 +664,8 @@ function message_history_link($userid1, $userid2=0, $returnstr=false, $keywords=
 function message_search_users($courseid, $searchtext, $sort='', $exceptions='') {
     global $CFG;
 
-    switch ($CFG->dbtype) {
-        case 'mysql':
-             $fullname = ' CONCAT(u.firstname," ",u.lastname) ';
-             $LIKE = 'LIKE';
-             break;
-        case 'postgres7':
-             $fullname = " u.firstname||' '||u.lastname ";
-             $LIKE = 'ILIKE';
-             break;
-        default:
-             $fullname = ' u.firstname||" "||u.lastname ';
-             $LIKE = 'ILIKE';
-    }
+    $fullname = sql_fullname();
+    $LIKE     = sql_like();
 
     if (!empty($exceptions)) {
         $except = ' AND u.id NOT IN ('. $exceptions .') ';
-- 
2.39.5