}
$course_id = $course_info['real_id'];
// Redefining table calls
$TBL_EXERCICE_QUESTION = Database::get_course_table(TABLE_QUIZ_TEST_QUESTION);
$TBL_EXERCICES = Database::get_course_table(TABLE_QUIZ_TEST);
$TBL_QUESTIONS = Database::get_course_table(TABLE_QUIZ_QUESTION);
$TBL_REPONSES = Database::get_course_table(TABLE_QUIZ_ANSWER);
$TBL_CATEGORY = Database::get_course_table(TABLE_QUIZ_QUESTION_CATEGORY);
$TBL_COURSE_REL_CATEGORY = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY);
// Get course categories for the selected course
// get category list for the course $selected_course
$categoryList = Testcategory::getCategoriesIdAndName($selected_course);
$selectCourseCategory = Display::select('courseCategoryId', $categoryList, $courseCategoryId, array('class' => 'chzn-select', 'onchange' => 'submit_form(this);'), false);
echo Display::form_row(get_lang("QuestionCategory"), $selectCourseCategory);
// Get exercise list for this course
$exercise_list = get_all_exercises_for_course_id($course_info, $session_id, $selected_course, false);
//Exercise List
$my_exercise_list = array();
$my_exercise_list['0'] = get_lang('AllExercises');
$my_exercise_list['-1'] = get_lang('OrphanQuestions');
if (is_array($exercise_list)) {
foreach ($exercise_list as $row) {
$my_exercise_list[$row['id']] = "";
if ($row['id'] == $fromExercise && $selected_course == api_get_course_int_id()) {
$my_exercise_list[$row['id']] = "> ";
}
$my_exercise_list[$row['id']] .= $row['title'];
}
}
if ($exercice_id_changed == 1) {
reset_menu_lvl_type();
// Tool introduction
Display::display_introduction_section(TOOL_QUIZ);
if (!empty($errorXmlExport)) {
echo $errorXmlExport;
}
HotPotGCt($documentPath, 1, $userId);
// Only for administrator
if ($is_allowedToEdit) {
if (!empty($choice)) {
// All test choice, clean all test's results
if ($choice == 'clean_all_test') {
$check = Security::check_token('get');
if ($check) {
// list des exercices dans un test
// we got variable $courseId $courseInfo session api_get_session_id()
$exerciseList = get_all_exercises_for_course_id($courseInfo, api_get_session_id(), $courseId, false);
$quantity_results_deleted = 0;
foreach ($exerciseList as $exeItem) {
// delete result for test, if not in a gradebook
$exercise_action_locked = api_resource_is_locked_by_gradebook($exeItem['id'], LINK_EXERCISE);
if ($exercise_action_locked == false) {
$objExerciseTmp = new Exercise();
if ($objExerciseTmp->read($exeItem['id'])) {
$quantity_results_deleted += $objExerciseTmp->clean_results(true);
}
}
}
Display::display_confirmation_message(sprintf(get_lang('XResultsCleaned'), $quantity_results_deleted));
}
}
// single exercise choice
