From c92bce46148c25577226251002b040db44930284 Mon Sep 17 00:00:00 2001
From: martinlanghoff <martinlanghoff>
Date: Sun, 6 Jan 2008 23:24:37 +0000
Subject: [PATCH] accesslib: get_user_by_capability() - Fix last_access
 handling

We were missing $courseid, which is actually $context->instanceid.

MDL-12452
---
 lib/accesslib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/accesslib.php b/lib/accesslib.php
index 7d2c804dd7..4ccf992e15 100755
--- a/lib/accesslib.php
+++ b/lib/accesslib.php
@@ -4314,7 +4314,7 @@ function get_users_by_capability($context, $capability, $fields='', $sort='',
     // User lastaccess JOIN
     if ($iscoursepage) {
         $uljoin = "LEFT OUTER JOIN {$CFG->prefix}user_lastaccess ul 
-                         ON (ul.userid = u.id AND ul.courseid = $courseid)";
+                         ON (ul.userid = u.id AND ul.courseid = {$context->instanceid})";
     } else {
         $uljoin = '';
     }
-- 
2.39.5