exit;
}
//Get the XML file out and start importing them into our database.
//TODO: See question_import.php 287-289.
$qti_import = new QTIImport($import_path);
$qids = $qti_import->importQuestions($attributes);
//import test
$tid = $qti_import->importTest();
//associate question and tests
foreach ($qids as $order => $qid) {
if (isset($qti_import->weights[$order])) {
$weight = round($qti_import->weights[$order]);
} else {
$weight = 0;
}
$new_order = $order + 1;
// $sql = "INSERT INTO " . TABLE_PREFIX . "tests_questions_assoc" .
// "(test_id, question_id, weight, ordering, required) " .
// "VALUES ($tid, $qid, $weight, $new_order, 0)";
// $result = mysql_query($sql, $db);
$testsQuestionsAssocDAO = new TestsQuestionsAssocDAO();
$testsQuestionsAssocDAO->Create($tid, $qid, $weight, $new_order);
}
//debug('imported test');
if (!$msg->containsErrors()) {
$msg->addFeedback('IMPORT_SUCCEEDED');
}
//clear directory
FileUtility::clr_dir(TR_CONTENT_DIR . 'import/' . $_course_id);
header('Location: index.php?_course_id=' . $_course_id);
exit;
/* Inclusive Design Institute */
/* */
/* This program is free software. You can redistribute it and/or */
/* modify it under the terms of the GNU General Public License */
/* as published by the Free Software Foundation. */
/************************************************************************/
$page = 'tests';
define('TR_INCLUDE_PATH', '../include/');
require_once TR_INCLUDE_PATH . 'vitals.inc.php';
require_once TR_INCLUDE_PATH . 'classes/Utility.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsDAO.class.php';
global $_course_id;
Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE);
$testsQuestionsDAO = new TestsQuestionsDAO();
$testsQuestionsAssocDAO = new TestsQuestionsAssocDAO();
$tid = intval($_POST['tid']);
$_pages['tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id]['title_var'] = 'questions';
$_pages['tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id]['parent'] = 'tests/index.php';
$_pages['tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id]['children'] = array('tests/add_test_questions.php');
$_pages['tests/add_test_questions.php']['title_var'] = 'add_questions';
$_pages['tests/add_test_questions.php']['parent'] = 'tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id;
$_pages['tests/add_test_questions_confirm.php']['title_var'] = 'add_questions';
$_pages['tests/add_test_questions_confirm.php']['parent'] = 'tests/questions.php?tid=' . $tid . '&_course_id=' . $_course_id;
if (isset($_POST['cancel'])) {
$msg->addFeedback('CANCELLED');
header('Location: questions.php?tid=' . $tid . '&_course_id=' . $_course_id);
exit;
} else {
if (isset($_POST['submit_yes'])) {
//get order
require_once TR_INCLUDE_PATH . 'classes/Utility.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/ContentTestsAssocDAO.class.php';
global $_course_id;
Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE);
$testsDAO = new TestsDAO();
if (isset($_POST['submit_no'])) {
$msg->addFeedback('CANCELLED');
header('Location: index.php?_course_id=' . $_course_id);
exit;
} else {
if (isset($_POST['submit_yes'])) {
$tid = intval($_POST['tid']);
if ($testsDAO->Delete($tid)) {
$testsQuestionsAssocDAO = new TestsQuestionsAssocDAO();
$testsQuestionsAssocDAO->DeleteByTestID($tid);
//delete test content association as well
$contentTestsAssocDAO = new ContentTestsAssocDAO();
$contentTestsAssocDAO->DeleteByTestID($tid);
}
$msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
header('Location: ' . TR_BASE_HREF . 'tests/index.php?_course_id=' . $_course_id);
exit;
}
}
/* else: */
require_once TR_INCLUDE_PATH . 'header.inc.php';
$_GET['tid'] = intval($_GET['tid']);
$row = $testsDAO->get($_GET['tid']);
unset($hidden_vars);
/* Copyright (c) 2010 */
/* Inclusive Design Institute */
/* */
/* This program is free software. You can redistribute it and/or */
/* modify it under the terms of the GNU General Public License */
/* as published by the Free Software Foundation. */
/************************************************************************/
define('TR_INCLUDE_PATH', '../include/');
require_once TR_INCLUDE_PATH . 'vitals.inc.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/Utility.class.php';
global $_course_id;
Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE);
$testsQuestionsDAO = new TestsQuestionsDAO();
$testsQuestionsAssocDAO = new TestsQuestionsAssocDAO();
$tid = intval($_REQUEST['tid']);
if (isset($_POST['submit_no'])) {
$msg->addFeedback('CANCELLED');
header('Location: question_db.php?_course_id=' . $_course_id);
exit;
} else {
if (isset($_POST['submit_yes'])) {
$_POST['qid'] = explode(',', $_POST['qid']);
foreach ($_POST['qid'] as $id) {
$id = intval($id);
if ($testsQuestionsDAO->Delete($id)) {
$testsQuestionsAssocDAO->DeleteByQuestionID($id);
}
}
$msg->addFeedback('QUESTION_DELETED');
$page = 'tests';
define('TR_INCLUDE_PATH', '../include/');
require_once TR_INCLUDE_PATH . 'vitals.inc.php';
require_once TR_INCLUDE_PATH . 'classes/Utility.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php';
global $_course_id;
Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE);
$tid = intval($_REQUEST['tid']);
$qid = intval($_REQUEST['qid']);
if (isset($_POST['submit_no'])) {
$msg->addFeedback('CANCELLED');
header('Location: questions.php?tid=' . $tid . SEP . '_course_id=' . $_course_id);
exit;
} else {
if (isset($_POST['submit_yes'])) {
$testsQuestionsAssocDAO = new TestsQuestionsAssocDAO();
$testsQuestionsAssocDAO->Delete($tid, $qid);
$msg->addFeedback('QUESTION_REMOVED');
header('Location: questions.php?tid=' . $tid . SEP . '_course_id=' . $_course_id);
exit;
}
}
/* else: */
$_pages['tests/questions.php?tid=' . $_GET['tid']]['title_var'] = 'questions';
$_pages['tests/questions.php?tid=' . $_GET['tid']]['parent'] = 'tests/index.php';
$_pages['tests/questions.php?tid=' . $_GET['tid']]['children'] = array('tests/add_test_questions.php?tid=' . $_GET['tid']);
$_pages['tests/add_test_questions.php?tid=' . $_GET['tid']]['title_var'] = 'add_questions';
$_pages['tests/add_test_questions.php?tid=' . $_GET['tid']]['parent'] = 'tests/questions.php?tid=' . $_GET['tid'];
$_pages['tests/question_remove.php']['title_var'] = 'remove_question';
$_pages['tests/question_remove.php']['parent'] = 'tests/questions.php?tid=' . $_GET['tid'];
require_once TR_INCLUDE_PATH . 'header.inc.php';
/**
* Export test
* @param int test id
* @param string the test title
* @param ref [OPTIONAL] zip object reference
* @param array [OPTIONAL] list of already added files.
*/
function test_qti_export($tid, $test_title = '', $zipfile = null)
{
global $_course_id;
require_once TR_INCLUDE_PATH . 'classes/DAO/CoursesDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/zipfile.class.php';
// for zipfile
require_once TR_INCLUDE_PATH . 'classes/XML/XML_HTMLSax/XML_HTMLSax.php';
// for XML_HTMLSax
require_once TR_INCLUDE_PATH . 'lib/html_resource_parser.inc.php';
// for get_html_resources()
global $savant, $db, $languageManager, $test_zipped_files, $test_files, $use_cc;
global $course_id;
$coursesDAO = new CoursesDAO();
$course_row = $coursesDAO->get($_course_id);
$course_language = $course_row['primary_language'];
$courseLanguage =& $languageManager->getLanguage($course_language);
$course_language_charset = $courseLanguage->getCharacterSet();
$imported_files;
$zipflag = false;
if ($zipfile == null) {
$zipflag = true;
}
if ($test_zipped_files == null) {
$test_zipped_files = array();
}
if ($zipflag) {
$zipfile = new zipfile();
$zipfile->create_dir('resources/');
// for all the dependency files
}
$resources = array();
$dependencies = array();
// don't want to sort it, i want the same order out.
// asort($question_ids);
//TODO: Merge the following 2 sqls together.
//Randomized or not, export all the questions that are associated with it.
// $sql = "SELECT TQ.question_id, TQA.weight FROM ".TABLE_PREFIX."tests_questions TQ INNER JOIN ".TABLE_PREFIX."tests_questions_assoc TQA USING (question_id) WHERE TQ.course_id=$_SESSION[course_id] AND TQA.test_id=$tid ORDER BY TQA.ordering, TQA.question_id";
// $result = mysql_query($sql, $db);
// $question_ids = array();
//
// if (is_array($question_rows)){
// foreach ($question_rows as $question_row) $question_ids[] = $question_row['question_id'];
// }
//
// //No questions in the test
// if (sizeof($question_ids)==0){
// return;
// }
//
// $question_ids_delim = implode(',',$question_ids);
//
// //$sql = "SELECT * FROM ".TABLE_PREFIX."tests_questions WHERE course_id=$_SESSION[course_id] AND question_id IN($question_ids_delim)";
// $sql = "SELECT TQ.*, TQA.weight, TQA.test_id FROM ".TABLE_PREFIX."tests_questions TQ INNER JOIN ".TABLE_PREFIX."tests_questions_assoc TQA USING (question_id) WHERE TQA.test_id=$tid AND TQ.question_id IN($question_ids_delim) ORDER BY TQA.ordering, TQA.question_id";
//
// $result = mysql_query($sql, $db);
// while ($row = mysql_fetch_assoc($result)) {
$testsQuestionsAssocDAO = new TestsQuestionsAssocDAO();
$question_rows = $testsQuestionsAssocDAO->getByTestID($tid);
if (!is_array($question_rows)) {
return false;
} else {
foreach ($question_rows as $row) {
$obj = TestQuestions::getQuestion($row['type']);
$local_xml = '';
$local_xml = $obj->exportQTI($row, $course_language_charset, '1.2.1');
$local_dependencies = array();
$text_blob = implode(' ', $row);
$local_dependencies = get_html_resources($text_blob);
$dependencies = array_merge($dependencies, $local_dependencies);
$xml = $xml . "\n\n" . $local_xml;
}
}
//files that are found inside the test; used by print_organization(), to add all test files into QTI/ folder.
$test_files = $dependencies;
$resources[] = array('href' => 'tests_' . $tid . '.xml', 'dependencies' => array_keys($dependencies));
$xml = trim($xml);
//get test title
// $sql = "SELECT title FROM ".TABLE_PREFIX."tests WHERE test_id = $tid";
// $result = mysql_query($sql, $db);
// $row = mysql_fetch_array($result);
$testsDAO = new TestsDAO();
$row = $testsDAO->get($tid);
//TODO: wrap around xml now
$savant->assign('xml_content', $xml);
$savant->assign('title', htmlspecialchars($row['title'], ENT_QUOTES, 'UTF-8'));
$savant->assign('num_takes', $row['num_takes']);
$savant->assign('use_cc', $use_cc);
$xml = $savant->fetch('tests/test_questions/wrapper.tmpl.php');
$xml_filename = 'tests_' . $tid . '.xml';
if (!$use_cc) {
$zipfile->add_file($xml, $xml_filename);
} else {
$zipfile->add_file($xml, 'QTI/' . $xml_filename);
}
// add any dependency files:
if (!$use_cc) {
foreach ($dependencies as $resource => $resource_server_path) {
//add this file in if it's not already in the zip package
if (!in_array($resource_server_path, $test_zipped_files)) {
$zipfile->add_file(@file_get_contents($resource_server_path), 'resources/' . $resource, filemtime($resource_server_path));
$test_zipped_files[] = $resource_server_path;
}
}
}
if ($zipflag) {
// construct the manifest xml
$savant->assign('resources', $resources);
$savant->assign('dependencies', array_keys($dependencies));
$savant->assign('encoding', $course_language_charset);
$savant->assign('title', $test_title);
$savant->assign('xml_filename', $xml_filename);
$manifest_xml = $savant->fetch('tests/test_questions/manifest_qti_1p2.tmpl.php');
$zipfile->add_file($manifest_xml, 'imsmanifest.xml');
$zipfile->close();
$filename = str_replace(array(' ', ':'), '_', $course_row['title'] . '-' . $test_title . '-' . date('Ymd'));
$zipfile->send_file($filename);
exit;
}
$return_array[$xml_filename] = array_keys($dependencies);
return $return_array;
//done
}
/* Inclusive Design Institute */
/* */
/* This program is free software. You can redistribute it and/or */
/* modify it under the terms of the GNU General Public License */
/* as published by the Free Software Foundation. */
/************************************************************************/
define('TR_INCLUDE_PATH', '../include/');
require_once TR_INCLUDE_PATH . 'vitals.inc.php';
require_once TR_INCLUDE_PATH . 'classes/testQuestions.class.php';
require_once TR_INCLUDE_PATH . 'classes/Utility.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php';
global $_course_id;
//Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE);
$testsDAO = new TestsDAO();
$testsQuestionsAssocDAO = new TestsQuestionsAssocDAO();
$_letters = array(_AT('a'), _AT('b'), _AT('c'), _AT('d'), _AT('e'), _AT('f'), _AT('g'), _AT('h'), _AT('i'), _AT('j'));
if ($_POST['back']) {
header('Location: index.php?_course_id=' . $_course_id);
exit;
}
if (defined('TR_FORCE_GET_FILE') && TR_FORCE_GET_FILE) {
$content_base_href = 'get.php/';
} else {
$content_base_href = 'content/' . $_SESSION['course_id'] . '/';
}
require_once TR_INCLUDE_PATH . 'header.inc.php';
$tid = intval($_GET['tid']);
// check that the test_id is correct
if (!($test_row = $testsDAO->get($tid))) {
$msg->printErrors('ITEM_NOT_FOUND');
/* modify it under the terms of the GNU General Public License */
/* as published by the Free Software Foundation. */
/************************************************************************/
$page = 'tests';
define('TR_INCLUDE_PATH', '../include/');
require_once TR_INCLUDE_PATH . 'vitals.inc.php';
require_once TR_INCLUDE_PATH . 'classes/testQuestions.class.php';
require_once TR_INCLUDE_PATH . 'classes/Utility.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsCategoriesDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/TestsQuestionsAssocDAO.class.php';
global $_course_id;
Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE);
$testsDAO = new TestsDAO();
$testsQuestionsCategoriesDAO = new TestsQuestionsCategoriesDAO();
$testsQuestionsAssocDAO = new TestsQuestionsAssocDAO();
$_pages['tests/questions.php']['title_var'] = 'questions';
$_pages['tests/questions.php']['parent'] = 'tests/index.php';
$_pages['tests/questions.php']['children'] = array('tests/add_test_questions.php?tid=' . $_GET['tid'] . '&_course_id=' . $_course_id);
$_pages['tests/add_test_questions.php?tid=' . $_GET['tid'] . '&_course_id=' . $_course_id]['title_var'] = 'add_questions';
$_pages['tests/add_test_questions.php?tid=' . $_GET['tid'] . '&_course_id=' . $_course_id]['parent'] = 'tests/questions.php?tid=' . $_GET['tid'] . '&_course_id=' . $_course_id;
$_pages['tests/questions.php']['guide'] = 'instructor/?p=add_questions.php';
$tid = intval($_REQUEST['tid']);
if (isset($_POST['submit'])) {
$count = 1;
foreach ($_POST['weight'] as $qid => $weight) {
$qid = intval($qid);
$weight = intval($weight);
$orders = $_POST['ordering'];
asort($orders);
$orders = array_keys($orders);
