Олег Давидович: 1 версия импортирована

2024-10-18T06:53:26Z

1 версия импортирована

← Предыдущая версия	Версия от 06:53, 18 октября 2024
(нет различий)

1>Nadavkav: New page: an old way to get roles of users in a course. (as far as i can understand the code, it is deprecated) and as suggested by Tim Hunt: mdl_course_display is wrong. You need role_assignmen...

2010-09-22T11:54:14Z

New page: an old way to get roles of users in a course. (as far as i can understand the code, it is deprecated) and as suggested by Tim Hunt: mdl_course_display is wrong. You need role_assignmen...

Новая страница

an old way to get roles of users in a course.

(as far as i can understand the code, it is deprecated)

and as suggested by Tim Hunt:

mdl_course_display is wrong. You need role_assignments, which means you also need contexts. Something like

SELECT * FROM mdl_user u
JOIN mdl_role_assignments ra ON ra.userid = u.id
JOIN mdl_role r ON ra.roleid = r.id
JOIN mdl_context con ON ra.contextid = con.id
JOIN mdl_course c ON c.id = con.instanceid AND con.contextlevel = 50
WHERE r.shortname = 'student' AND c.id = XXX

will get you all the students in a course. mdl_context.instanceid points to different things depending on mdl_context.contextlevel. 50 means course, the other levels can be looked up in the accesslib.php code [http://cvs.moodle.org/moodle/lib/accesslib.php?annotate=1.514#l136 here], For example, mdl_context.contextlevel 70 is modules, then instanceid points to the mdl_course_modules table.

If you really want to understand this, you need to read the [[Development:Roles]] documentation.

Course display - История изменений

Олег Давидович: 1 версия импортирована

1>Nadavkav: New page: an old way to get roles of users in a course. (as far as i can understand the code, it is deprecated) and as suggested by Tim Hunt: mdl_course_display is wrong. You need role_assignmen...