I have attached in a txt file what I have so far. In the C# code I am querying for users, courses and enrollments. Then I map courses to users to get users of each course. However, what I have yet to figure out, is how do I get what role each user has in a course?
- mdl_enrol - Does not tell me what role a particular user has in a particular course.
- mdl_user_enrolments - Same as above.
- mdl_role_assignments - It would seem as if roles are in this table. However, I haven't been able to figure out how do I map a role in this table to a particular user and course.
Can you please help me to figure this out? Thank you in advance.