| : |
id)){
$query = "
SELECT
id,
CONCAT(shortname, ' ', fullname) as name
FROM
{$CFG->prefix}course as c,
{$CFG->prefix}context as co,
{$CFG->prefix}role_assignement as r
WHERE
r.contextid = co.id AND
co.instance = c.id AND
co.contextlevel = CONTEXT_COURSE AND
r IN ('$managerroleslist') AND
c.id != $COURSE->id
ORDER BY
c.shortname
";
}
else{
// admin can move everything !!
$query = "
SELECT
id,
CONCAT(shortname, ' ', fullname) as name
FROM
{$CFG->prefix}course
WHERE
id != $COURSE->id
ORDER BY
shortname
";
}
$availablecoursesmenu = get_records_sql_menu($query);
$ajaxSectionUpdater = (@$CFG->enableajax) ? 'ajaxSectionUpdater(this);' : '' ;
choose_from_menu($availablecoursesmenu, 'course', '', 'choose', $ajaxSectionUpdater);
$cancontinue = 1;
}
else{
print_string('noothercoursestoedit', 'coursexfers');
}
?>
|