From 9ec6ecb933485474fe82447166fa98b2927ea57b Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Thu, 20 Sep 2007 05:54:32 +0000
Subject: [PATCH] changed join onto context table to an outer join because some
 contexts could be missing during listing of participants

---
 user/index.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/user/index.php b/user/index.php
index 81ef0d9b6a..be147f3d77 100644
--- a/user/index.php
+++ b/user/index.php
@@ -332,7 +332,7 @@
     $select .= $course->enrolperiod?', r.timeend ':'';
 
     $from   = "FROM {$CFG->prefix}user u
-               JOIN {$CFG->prefix}context ctx
+               LEFT OUTER JOIN {$CFG->prefix}context ctx
                  ON (u.id=ctx.instanceid AND ctx.contextlevel = ".CONTEXT_USER.")
                JOIN {$CFG->prefix}role_assignments r
                  ON u.id=r.userid
-- 
2.39.5