Moodle课程注册用户SQL查询

Question

我在编译SQL查询以查找注册参加特定moodle课程的用户数量时遇到了困难。

我使用并使用了来自以下线程的查询：SQL query for Courses Enrolment on Moodle

下面引用的查询没有返回准确的结果：

​

SELECT DISTINCT u.id AS userid, c.id AS courseid
FROM mdl_user u
JOIN mdl_user_enrolments ue ON ue.userid = u.id
JOIN mdl_enrol e ON e.id = ue.enrolid
JOIN mdl_role_assignments ra ON ra.userid = u.id
JOIN mdl_context ct ON ct.id = ra.contextid AND ct.contextlevel = 50
JOIN mdl_course c ON c.id = ct.instanceid AND e.courseid = c.id
JOIN mdl_role r ON r.id = ra.roleid AND r.shortname = 'student'
WHERE e.status = 0 AND u.suspended = 0 AND u.deleted = 0
  AND (ue.timeend = 0 OR ue.timeend > NOW()) AND ue.status = 0

​

以下内容给出了正确的数字，但从我所读到的内容来看，这似乎是不正确的(我正在处理一个由3个用户组成的数据集)：

​

SELECT COUNT(*)

FROM mdl_course AS course 
JOIN mdl_enrol AS en ON en.courseid = course.id
JOIN mdl_user_enrolments AS ue ON ue.enrolid = en.id
JOIN mdl_user AS user2 ON ue.userid = user2.id

​

任何帮助都很感激。

Answer 1

您可以通过调用在get_enrolled_users文件中定义的accesslib.php来获得注册用户

还有一个可以使用的count_enrolled_users方法