|
Moodle
2.2.1
http://www.collinsharper.com
|
Go to the source code of this file.
Namespaces | |
| namespace | tool |
Variables | |
| $action = optional_param('action', '', PARAM_ACTION) | |
| $syscontext = get_context_instance(CONTEXT_SYSTEM) | |
| if ($action=== 'delete') | |
| $sql | |
| $problems = array() | |
| $rs = $DB->get_recordset_sql($sql) | |
| $action = optional_param('action', '', PARAM_ACTION) |
| $rs = $DB->get_recordset_sql($sql) |
| $sql |
"SELECT r.id AS roleid, c.contextlevel, r.sortorder, COUNT(ra.id) AS racount FROM {role} r JOIN {role_assignments} ra ON ra.roleid = r.id JOIN {context} c ON c.id = ra.contextid LEFT JOIN {role_context_levels} rcl ON (rcl.roleid = r.id AND rcl.contextlevel = c.contextlevel) WHERE rcl.id IS NULL GROUP BY r.id, c.contextlevel, r.sortorder ORDER BY c.contextlevel ASC, r.sortorder ASC"
| $syscontext = get_context_instance(CONTEXT_SYSTEM) |