From 67da7e65d27e712a4e7f1c7c96dd538559e68668 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Tue, 9 Dec 2008 22:17:18 +0000
Subject: [PATCH] MDL-13978 fixed code to use new DML syntax

---
 course/search.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/course/search.php b/course/search.php
index e8576481f5..0abf631fd7 100644
--- a/course/search.php
+++ b/course/search.php
@@ -146,7 +146,7 @@
     // get list of courses containing modules if required
     elseif (!empty($modulelist) and confirm_sesskey()) {
         $modulename = $modulelist;
-        $sql =  "SELECT DISTINCT c.id FROM {$CFG->prefix}".$modulelist." module, {$CFG->prefix}course c"
+        $sql =  "SELECT DISTINCT c.id FROM {".$modulelist."} module, {course} c"
             ." WHERE module.course=c.id";
 
         $courseids = $DB->get_records_sql($sql);
-- 
2.39.5