/**
* Get course/profile right
*
* @param integer $profileId profile identifier
* @param integer $courseId course identifier
* @return array ['tool_id']['action_name'] value
*/
function claro_get_course_profile_right($profileId = null, $courseId = null)
{
$courseProfileRightList = null;
static $cachedProfileId = null;
static $cachedCourseId = null;
static $cachedCourseProfileRightList = null;
// load courseId
if (is_null($courseId)) {
if (claro_is_in_a_course()) {
$courseId = claro_get_current_course_id();
} else {
return false;
}
}
// load profile id
if (is_null($profileId)) {
if (!empty($GLOBALS['_profileId'])) {
$profileId = $GLOBALS['_profileId'];
} else {
return false;
}
}
if (!empty($cachedCourseProfileRightList) && $cachedProfileId == $profileId && $cachedCourseId == $courseId) {
$courseProfileRightList = $cachedCourseProfileRightList;
}
if (empty($courseProfileRightList)) {
$profile = new RightProfile();
if ($profile->load($profileId)) {
$courseProfileToolRight = new RightCourseProfileToolRight();
$courseProfileToolRight->setCourseId($courseId);
$courseProfileToolRight->load($profile);
$courseProfileRightList = $courseProfileToolRight->getToolActionList();
// cache for the next time ...
$cachedProfileId = $profileId;
$cachedCourseId = $courseId;
$cachedCourseProfileRightList = $courseProfileRightList;
} else {
return false;
}
}
return $courseProfileRightList;
}
/**
* delete a course of the plateform
*
* TODO detect failure with claro_failure
*
* @param string $cid
*
* @return boolean TRUE if suceed
* boolean FALSE otherwise.
*/
function delete_course($code, $sourceCourseId)
{
global $eventNotifier;
// Declare needed tables
$tbl_mdb_names = claro_sql_get_main_tbl();
$tbl_course = $tbl_mdb_names['course'];
$tbl_rel_course_user = $tbl_mdb_names['rel_course_user'];
$tbl_course_class = $tbl_mdb_names['rel_course_class'];
$tbl_rel_course_category = $tbl_mdb_names['rel_course_category'];
$tbl_rel_course_portlet = $tbl_mdb_names['rel_course_portlet'];
$this_course = claro_get_course_data($code);
if (!$this_course) {
// This is bad !
throw new Exception("Course not found");
}
$currentCourseId = trim($this_course['sysCode']);
if (empty($currentCourseId)) {
// This is bad !
throw new Exception("Missing course id");
}
// Delete user registrations into this course
$sql = 'DELETE FROM `' . $tbl_rel_course_user . '`
WHERE code_cours="' . $currentCourseId . '"';
claro_sql_query($sql);
// Remove any recording in rel_cours_class
$sql = "DELETE FROM `" . $tbl_course_class . "`\n WHERE courseId ='" . claro_sql_escape($currentCourseId) . "'";
claro_sql_query($sql);
// Remove links between this course and categories
$sql = "DELETE FROM `" . $tbl_rel_course_category . "`\n WHERE courseId ='" . $this_course['id'] . "'";
claro_sql_query($sql);
// Remove links between this course and portlets
$sql = "DELETE FROM `" . $tbl_rel_course_portlet . "`\n WHERE courseId ='" . $this_course['id'] . "'";
claro_sql_query($sql);
// Delete the course inside the platform course registery
$sql = 'DELETE FROM `' . $tbl_course . '`
WHERE code= "' . claro_sql_escape($currentCourseId) . '"';
claro_sql_query($sql);
// Is it a session course ?
if (!is_null($sourceCourseId)) {
// Does the source course still have session courses ?
$sql = "SELECT COUNT(cours_id) AS nbSessionCourses\n FROM `" . $tbl_course . "`\n WHERE sourceCourseId = " . (int) $sourceCourseId;
$result = claro_sql_query_get_single_row($sql);
if ($result['nbSessionCourses'] == 0) {
$sql = "UPDATE `" . $tbl_course . "`\n SET isSourceCourse = 0\n WHERE cours_id = " . (int) $sourceCourseId;
claro_sql_query($sql);
}
}
// Delete course right
RightCourseProfileToolRight::resetAllRightProfile($currentCourseId);
// Delete course module tables
// FIXME handle errors
list($success, $log) = delete_all_modules_from_course($currentCourseId);
// Notify the course deletion event
$args['cid'] = $this_course['sysCode'];
$args['tid'] = null;
$args['rid'] = null;
$args['gid'] = null;
$args['uid'] = $GLOBALS['_uid'];
$eventNotifier->notifyEvent("course_deleted", $args);
if ($currentCourseId == $code) {
$currentCourseDbName = trim($this_course['dbName']);
$currentCourseDbNameGlu = trim($this_course['dbNameGlu']);
$currentCoursePath = trim($this_course['path']);
if (empty($currentCourseDbName)) {
// This is bad !
throw new Exception("Missing db name");
}
if (empty($currentCourseDbNameGlu)) {
// This is bad !
throw new Exception("Missing db name glu");
}
if (get_conf('singleDbEnabled')) {
// SEARCH ALL TABLES RELATED TO THE CURRENT COURSE
claro_sql_query("use " . get_conf('mainDbName'));
$tbl_to_delete = claro_sql_get_course_tbl(claro_get_course_db_name_glued($currentCourseId));
foreach ($tbl_to_delete as $tbl_name) {
$sql = 'DROP TABLE IF EXISTS `' . $tbl_name . '`';
claro_sql_query($sql);
}
// Underscores must be replaced because they are used as wildcards in LIKE sql statement
$cleanCourseDbNameGlu = str_replace("_", "\\_", $currentCourseDbNameGlu);
$sql = 'SHOW TABLES LIKE "' . $cleanCourseDbNameGlu . '%"';
$result = claro_sql_query($sql);
// DELETE ALL TABLES OF THE CURRENT COURSE
$tblSurvivor = array();
while (false !== ($courseTable = mysql_fetch_array($result, MYSQL_NUM))) {
$tblSurvivor[] = $courseTable[0];
//$tblSurvivor[$courseTable]='not deleted';
}
if (sizeof($tblSurvivor) > 0) {
Claroline::getInstance()->log('DELETE_COURSE', array_merge(array('DELETED_COURSE_CODE' => $code, 'UNDELETED_TABLE_COUNTER' => sizeof($tblSurvivor)), $tblSurvivor));
}
} else {
$sql = "DROP DATABASE `" . $currentCourseDbName . "`";
claro_sql_query($sql);
}
// MOVE THE COURSE DIRECTORY INTO THE COURSE GARBAGE COLLECTOR
if (!empty($currentCoursePath)) {
if (file_exists(get_conf('coursesRepositorySys') . $currentCoursePath . '/')) {
claro_mkdir(get_conf('garbageRepositorySys'), CLARO_FILE_PERMISSIONS, true);
rename(get_conf('coursesRepositorySys') . $currentCoursePath . '/', get_conf('garbageRepositorySys', 'garbage') . '/' . $currentCoursePath . '_' . date('YmdHis'));
} else {
Console::warning("DELETE_COURSE : Course directory not found {$currentCoursePath} for course {$currentCourseId}");
}
Claroline::log('COURSE_DELETED', array('courseCode' => $currentCourseId, 'courseDbName' => $currentCourseDbName, 'courseDbNameGlu' => $currentCourseDbNameGlu, 'coursePath' => $currentCoursePath));
return true;
} else {
Console::error("DELETE_COURSE : Try to delete a course repository with no folder name {$currentCourseId} !");
return true;
}
} else {
return false;
}
}
require_once get_path('incRepositorySys') . '/lib/right/courseProfileToolAction.class.php';
require_once get_path('incRepositorySys') . '/lib/right/profileToolRightHtml.class.php';
//=================================
// Main section
//=================================
$cmd = isset($_REQUEST['cmd']) ? $_REQUEST['cmd'] : null;
$display_profile = isset($_REQUEST['display_profile']) ? $_REQUEST['display_profile'] : null;
$profile_id = isset($_REQUEST['profile_id']) ? $_REQUEST['profile_id'] : null;
$tool_id = isset($_REQUEST['tool_id']) ? $_REQUEST['tool_id'] : null;
$right_value = isset($_REQUEST['right_value']) ? $_REQUEST['right_value'] : null;
if (!empty($profile_id)) {
// load profile
$profile = new RightProfile();
if ($profile->load($profile_id)) {
// load profile tool right
$courseProfileRight = new RightCourseProfileToolRight();
$courseProfileRight->setCourseId(claro_get_current_course_id());
$courseProfileRight->load($profile);
if (!$profile->isLocked()) {
if ($cmd == 'set_right' && !empty($tool_id)) {
$courseProfileRight->setToolRight($tool_id, $right_value);
$courseProfileRight->save();
}
}
} else {
$profile_id = null;
}
}
//---------------------------------
// Build list of profile to display
//---------------------------------