From 9d6f5d42eb47faaa48ef820e99613d5d1cb31806 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Tue, 29 Apr 2003 03:16:32 +0000
Subject: [PATCH] Only retrieve records that are needed  (eg description never
 is used)

---
 lib/datalib.php | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index d935bfd15a..8b0ba3baf5 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -874,7 +874,10 @@ function get_course_students($courseid, $sort="u.lastaccess DESC") {
 
     global $CFG;
 
-    return get_records_sql("SELECT u.* FROM {$CFG->prefix}user u, {$CFG->prefix}user_students s
+    return get_records_sql("SELECT u.id, u.username, u.firstname, u.lastname, u.maildisplay,
+                            u.email, u.city, u.country, u.lastaccess, u.lastlogin, u.picture
+                            FROM {$CFG->prefix}user u, 
+                                 {$CFG->prefix}user_students s
                             WHERE s.course = '$courseid' AND s.userid = u.id AND u.deleted = '0'
                             ORDER BY $sort");
 }
-- 
2.39.5