Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
What modules are copied from what course? (PETEL)
cm.course,, cm.module,
WHEN 'quiz' THEN (SELECT FROM mdl_quiz m WHERE = cm.instance)
END AS 'Module name'
,t.courseid, c.fullname, u.firstname, u.lastname
FROM mdl_local_courseduplicate t
JOIN mdl_course_modules cm ON = t.sourceactivityid
JOIN mdl_modules m ON = cm.module
JOIN mdl_course c ON = t.courseid
JOIN mdl_user u ON = t.userid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment