From 2d439c9d593068dfa09900b884452d1d9f4664d1 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Tue, 30 Dec 2003 18:19:15 +0000
Subject: [PATCH] Slight fix for MySQL 4
---
lib/datalib.php | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)
diff --git a/lib/datalib.php b/lib/datalib.php
index fefcdc2c62..76d984c4e3 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -1436,12 +1436,15 @@ function get_groups($courseid, $userid=0) {
global $CFG;
if ($userid) {
+ $dbselect = ", {$CFG->prefix}groups_members m";
$userselect = "AND m.groupid = g.id AND m.userid = '$userid'";
+ } else {
+ $dbselect = '';
+ $userselect = '';
}
return get_records_sql("SELECT DISTINCT g.*
- FROM {$CFG->prefix}groups g,
- {$CFG->prefix}groups_members m
+ FROM {$CFG->prefix}groups g $dbselect
WHERE g.courseid = '$courseid' $userselect ");
}
--
2.39.5