summaryrefslogtreecommitdiff
path: root/sqlbox/reportall.php
diff options
context:
space:
mode:
Diffstat (limited to 'sqlbox/reportall.php')
-rw-r--r--sqlbox/reportall.php8
1 files changed, 7 insertions, 1 deletions
diff --git a/sqlbox/reportall.php b/sqlbox/reportall.php
index 7ba70ce..abb799c 100644
--- a/sqlbox/reportall.php
+++ b/sqlbox/reportall.php
@@ -47,7 +47,13 @@ $table = new html_table;
$table->head = array_merge(array("Nutzer", "Fortschritt"), $b);
$table->align = array_merge(array("left", "left"), array_fill(0, count($b), 'center'));
-$users = $DB->get_records("user", array('deleted'=>'0'));
+$users = $DB->get_records_sql("select u.* from {enrol} e, {user_enrolments} ue, {user} u
+ where e.courseid=:courseid and
+ ue.enrolid = e.id and
+ ue.userid = u.id and
+ u.deleted = 0",
+ array('courseid'=>$course->id));
+
foreach ($users as $user) {
if (isguestuser($user))
continue;