function question_showbank_actions($pageurl, $cm)
{
global $CFG, $COURSE;
/// Now, check for commands on this page and modify variables as necessary
if (optional_param('move', false, PARAM_BOOL) and confirm_sesskey()) {
/// Move selected questions to new category
$category = required_param('category', PARAM_SEQUENCE);
list($tocategoryid, $contextid) = explode(',', $category);
if (!($tocategory = get_record('question_categories', 'id', $tocategoryid, 'contextid', $contextid))) {
error('Could not find category record');
}
$tocontext = get_context_instance_by_id($contextid);
require_capability('moodle/question:add', $tocontext);
$rawdata = (array) data_submitted();
$questionids = array();
foreach ($rawdata as $key => $value) {
// Parse input for question ids
if (preg_match('!^q([0-9]+)$!', $key, $matches)) {
$key = $matches[1];
$questionids[] = $key;
}
}
if ($questionids) {
$questionidlist = join($questionids, ',');
$sql = "SELECT q.*, c.contextid FROM {$CFG->prefix}question q, {$CFG->prefix}question_categories c WHERE q.id IN ({$questionidlist}) AND c.id = q.category";
if (!($questions = get_records_sql($sql))) {
print_error('questiondoesnotexist', 'question', $pageurl->out());
}
$checkforfiles = false;
foreach ($questions as $question) {
//check capabilities
question_require_capability_on($question, 'move');
$fromcontext = get_context_instance_by_id($question->contextid);
if (get_filesdir_from_context($fromcontext) != get_filesdir_from_context($tocontext)) {
$checkforfiles = true;
}
}
$returnurl = $pageurl->out(false, array('category' => "{$tocategoryid},{$contextid}"));
if (!$checkforfiles) {
if (!question_move_questions_to_category(implode(',', $questionids), $tocategory->id)) {
print_error('errormovingquestions', 'question', $returnurl, $questionids);
}
redirect($returnurl);
} else {
$movecontexturl = new moodle_url($CFG->wwwroot . '/question/contextmoveq.php', array('returnurl' => $returnurl, 'ids' => $questionidlist, 'tocatid' => $tocategoryid));
if ($cm) {
$movecontexturl->param('cmid', $cm->id);
} else {
$movecontexturl->param('courseid', $COURSE->id);
}
redirect($movecontexturl->out());
}
}
}
if (optional_param('deleteselected', false, PARAM_BOOL)) {
// delete selected questions from the category
if ($confirm = optional_param('confirm', '', PARAM_ALPHANUM) and confirm_sesskey()) {
// teacher has already confirmed the action
$deleteselected = required_param('deleteselected');
if ($confirm == md5($deleteselected)) {
if ($questionlist = explode(',', $deleteselected)) {
// for each question either hide it if it is in use or delete it
foreach ($questionlist as $questionid) {
question_require_capability_on($questionid, 'edit');
if (record_exists('quiz_question_instances', 'question', $questionid)) {
if (!set_field('question', 'hidden', 1, 'id', $questionid)) {
question_require_capability_on($questionid, 'edit');
error('Was not able to hide question');
}
} else {
delete_question($questionid);
}
}
}
redirect($pageurl->out());
} else {
error("Confirmation string was incorrect");
}
}
}
// Unhide a question
if ($unhide = optional_param('unhide', '', PARAM_INT) and confirm_sesskey()) {
question_require_capability_on($unhide, 'edit');
if (!set_field('question', 'hidden', 0, 'id', $unhide)) {
error("Failed to unhide the question.");
}
redirect($pageurl->out());
}
}
function save_question_options($question)
{
global $QTYPES;
$result = new stdClass();
// This function needs to be able to handle the case where the existing set of wrapped
// questions does not match the new set of wrapped questions so that some need to be
// created, some modified and some deleted
// Unfortunately the code currently simply overwrites existing ones in sequence. This
// will make re-marking after a re-ordering of wrapped questions impossible and
// will also create difficulties if questiontype specific tables reference the id.
// First we get all the existing wrapped questions
if (!($oldwrappedids = get_field('question_multianswer', 'sequence', 'question', $question->id))) {
$oldwrappedquestions = array();
} else {
$oldwrappedquestions = get_records_list('question', 'id', $oldwrappedids, 'id ASC');
}
$sequence = array();
foreach ($question->options->questions as $wrapped) {
if (!empty($wrapped)) {
// if we still have some old wrapped question ids, reuse the next of them
if (is_array($oldwrappedquestions) && ($oldwrappedquestion = array_shift($oldwrappedquestions))) {
$wrapped->id = $oldwrappedquestion->id;
if ($oldwrappedquestion->qtype != $wrapped->qtype) {
switch ($oldwrappedquestion->qtype) {
case 'multichoice':
delete_records('question_multichoice', 'question', $oldwrappedquestion->id);
break;
case 'shortanswer':
delete_records('question_shortanswer', 'question', $oldwrappedquestion->id);
break;
case 'numerical':
delete_records('question_numerical', 'question', $oldwrappedquestion->id);
break;
default:
print_error('qtypenotrecognized', 'qtype_multianswer', '', $oldwrappedquestion->qtype);
$wrapped->id = 0;
}
}
} else {
$wrapped->id = 0;
}
}
$wrapped->name = $question->name;
$wrapped->parent = $question->id;
$previousid = $wrapped->id;
$wrapped->category = $question->category . ',1';
// save_question strips this extra bit off again.
$wrapped = $QTYPES[$wrapped->qtype]->save_question($wrapped, $wrapped, $question->course);
$sequence[] = $wrapped->id;
if ($previousid != 0 && $previousid != $wrapped->id) {
// for some reasons a new question has been created
// so delete the old one
delete_question($previousid);
}
}
// Delete redundant wrapped questions
if (is_array($oldwrappedquestions) && count($oldwrappedquestions)) {
foreach ($oldwrappedquestions as $oldwrappedquestion) {
delete_question($oldwrappedquestion->id);
}
}
if (!empty($sequence)) {
$multianswer = new stdClass();
$multianswer->question = $question->id;
$multianswer->sequence = implode(',', $sequence);
if ($oldid = get_field('question_multianswer', 'id', 'question', $question->id)) {
$multianswer->id = $oldid;
if (!update_record("question_multianswer", $multianswer)) {
$result->error = "Could not update cloze question options! " . "(id={$multianswer->id})";
return $result;
}
} else {
if (!insert_record("question_multianswer", $multianswer)) {
$result->error = "Could not insert cloze question options!";
return $result;
}
}
}
}
}
if (isset($_REQUEST['deleteselected'])) {
// delete selected questions from the category
if (isset($_REQUEST['confirm']) and confirm_sesskey()) {
// teacher has already confirmed the action
$deleteselected = required_param('deleteselected');
if ($_REQUEST['confirm'] == md5($deleteselected)) {
if ($questionlist = explode(',', $deleteselected)) {
// for each question either hide it if it is in use or delete it
foreach ($questionlist as $questionid) {
if (record_exists('quiz_question_instances', 'question', $questionid)) {
if (!set_field('question', 'hidden', 1, 'id', $questionid)) {
error('Was not able to hide question');
}
} else {
delete_question($questionid);
}
}
}
echo '</td></tr>';
echo '</table>';
echo '</div>';
redirect("edit.php?courseid={$course->id}");
} else {
error("Confirmation string was incorrect");
}
} else {
// teacher still has to confirm
// make a list of all the questions that are selected
$rawquestions = $_REQUEST;
$questionlist = '';
/**
* All question categories and their questions are deleted for this activity.
*
* @param object $cm the course module object representing the activity
* @param boolean $feedback to specify if the process must output a summary of its work
* @return boolean
*/
function question_delete_activity($cm, $feedback = true)
{
//To store feedback to be showed at the end of the process
$feedbackdata = array();
//Cache some strings
$strcatdeleted = get_string('unusedcategorydeleted', 'quiz');
$modcontext = get_context_instance(CONTEXT_MODULE, $cm->id);
if ($categoriesmods = get_records('question_categories', 'contextid', $modcontext->id, 'parent', 'id, parent, name')) {
//Sort categories following their tree (parent-child) relationships
//this will make the feedback more readable
$categoriesmods = sort_categories_by_tree($categoriesmods);
foreach ($categoriesmods as $category) {
//Delete it completely (questions and category itself)
//deleting questions
if ($questions = get_records("question", "category", $category->id)) {
foreach ($questions as $question) {
delete_question($question->id);
}
delete_records("question", "category", $category->id);
}
//delete the category
delete_records('question_categories', 'id', $category->id);
//Fill feedback
$feedbackdata[] = array($category->name, $strcatdeleted);
}
//Inform about changes performed if feedback is enabled
if ($feedback) {
$table = new stdClass();
$table->head = array(get_string('category', 'quiz'), get_string('action'));
$table->data = $feedbackdata;
print_table($table);
}
}
return true;
}
}
//dbconnect("localhost", "quizuser", "quiz", "quiz");
$row = get_quiz($_GET['edit']);
// make update
if (isset($_POST['update'])) {
$subject_id = $_POST['subject_id'];
$title = $_POST['title'];
$duration = $_POST['duration'];
$number_of_questions = $_POST['num_of_ques'];
$status = $_POST['status'];
//print_r($_POST);
update_quiz($_GET['edit'], $subject_id, $title, $duration, $number_of_questions, $status);
//redirect_to('allquestions.php?qid='.$_GET['edit']);
}
if (isset($_POST['delete_question'])) {
delete_question($_GET['quid']);
redirect_to('edit.php?edit=' . $_GET['edit']);
}
?>
<div class="container">
<a href="question.php?qid=<?php
echo $_GET['edit'];
?>
"><i class="fa fa-question fa-lg fa-fw"></i>Add new question</a>
<h1>update quiz</h1>
<form class="form-horizontal" method="POST" action="edit.php?edit=<?php
echo $_GET['edit'];
?>
">
function RWSDQCat($r_qci)
{
global $DB;
global $CFG;
$r_chn = $DB->get_records("question_categories", array("parent" => $r_qci));
if (count($r_chn) > 0) {
foreach ($r_chn as $r_chd) {
RWSDQCat($r_chd->id);
}
}
$r_qsts = $DB->get_records("question", array("category" => $r_qci));
if (count($r_qsts) > 0) {
foreach ($r_qsts as $r_q) {
if (respondusws_floatcompare($CFG->version, 2011070100, 2) >= 0) {
question_delete_question($r_q->id);
} else {
delete_question($r_q->id);
}
}
$DB->delete_records("question", array("category" => $r_qci));
}
$DB->delete_records("question_categories", array("id" => $r_qci));
}
$max = $_POST[MIN] == "" ? 0 : $_POST[MAX];
$msg = add_reponse($_POST[ID], $_POST[LIBELE], $min, $max);
}
break;
case DELETE_SONDAGE:
if (!isset($_GET[ID])) {
$msg = ERROR_CORRUPTED_DATA;
} else {
$msg = delete_sondage($_GET[ID]);
}
break;
case DELETE_QUESTION:
if (!isset($_GET[ID])) {
$msg = ERROR_CORRUPTED_DATA;
} else {
$msg = delete_question($_GET[ID]);
}
break;
case DELETE_USER:
if (!isset($_GET[ID])) {
$msg = ERROR_CORRUPTED_DATA;
} else {
$msg = delete_compte_as_admin($_GET[ID]);
}
break;
case DELETE_REPONSE:
if (!isset($_GET[ID])) {
$msg = ERROR_CORRUPTED_DATA;
} else {
$msg = delete_reponse($_GET[ID]);
}
<?php
}
}
}
}
?>
</div>
<?php
} else {
if (isset($_POST['save'])) {
$question = $_POST['question_text'];
$id = $_POST['question_id'];
save_question($id, $question);
} else {
if (isset($_POST['delete'])) {
delete_question($_POST['question_id']);
} else {
if (isset($_POST['add']) && !empty($_POST['question'])) {
add_question($_POST['question'], $_POST['category']);
} else {
?>
<div id="questions">
<?php
$categories = get_categories();
if ($categories) {
foreach ($categories as $category) {
?>
<table>
<thead>
<tr>
<td colspan="3"><h3><?php
/**
* All non-used question categories and their questions are deleted and
* categories still used by other courses are moved to the site course.
*
* @param object $course an object representing the course
* @param boolean $feedback to specify if the process must output a summary of its work
* @return boolean
*/
function question_delete_course($course, $feedback = true)
{
global $CFG, $QTYPES;
//To detect if we have created the "container category"
$concatid = 0;
//The "container" category we'll create if we need if
$contcat = new object();
//To temporary store changes performed with parents
$parentchanged = array();
//To store feedback to be showed at the end of the process
$feedbackdata = array();
//Cache some strings
$strcatcontainer = get_string('containercategorycreated', 'quiz');
$strcatmoved = get_string('usedcategorymoved', 'quiz');
$strcatdeleted = get_string('unusedcategorydeleted', 'quiz');
if ($categories = get_records('question_categories', 'course', $course->id, 'parent', 'id, parent, name, course')) {
//Sort categories following their tree (parent-child) relationships
$categories = sort_categories_by_tree($categories);
foreach ($categories as $cat) {
//Get the full record
$category = get_record('question_categories', 'id', $cat->id);
//Check if the category is being used anywhere
if (question_category_isused($category->id, true)) {
//It's being used. Cannot delete it, so:
//Create a container category in SITEID course if it doesn't exist
if (!$concatid) {
$concat = new stdClass();
$concat->course = SITEID;
if (!isset($course->shortname)) {
$course->shortname = 'id=' . $course->id;
}
$concat->name = get_string('savedfromdeletedcourse', 'quiz', format_string($course->shortname));
$concat->info = $concat->name;
$concat->publish = 1;
$concat->stamp = make_unique_id_code();
$concatid = insert_record('question_categories', $concat);
//Fill feedback
$feedbackdata[] = array($concat->name, $strcatcontainer);
}
//Move the category to the container category in SITEID course
$category->course = SITEID;
//Assign to container if the category hasn't parent or if the parent is wrong (not belongs to the course)
if (!$category->parent || !isset($categories[$category->parent])) {
$category->parent = $concatid;
}
//If it's being used, its publish field should be 1
$category->publish = 1;
//Let's update it
update_record('question_categories', $category);
//Save this parent change for future use
$parentchanged[$category->id] = $category->parent;
//Fill feedback
$feedbackdata[] = array($category->name, $strcatmoved);
} else {
//Category isn't being used so:
//Delete it completely (questions and category itself)
//deleting questions
if ($questions = get_records("question", "category", $category->id)) {
foreach ($questions as $question) {
delete_question($question->id);
}
delete_records("question", "category", $category->id);
}
//delete the category
delete_records('question_categories', 'id', $category->id);
//Save this parent change for future use
if (!empty($category->parent)) {
$parentchanged[$category->id] = $category->parent;
} else {
$parentchanged[$category->id] = $concatid;
}
//Update all its child categories to re-parent them to grandparent.
set_field('question_categories', 'parent', $parentchanged[$category->id], 'parent', $category->id);
//Fill feedback
$feedbackdata[] = array($category->name, $strcatdeleted);
}
}
//Inform about changes performed if feedback is enabled
if ($feedback) {
$table = new stdClass();
$table->head = array(get_string('category', 'quiz'), get_string('action'));
$table->data = $feedbackdata;
print_table($table);
}
}
return true;
}
<?php
include 'header.html';
require_once '../includes/db_conn.php';
require_once 'admin_fun.php';
if (isset($_POST['question_title']) && isset($_POST['key']) && isset($_POST['mark']) && isset($_POST['question_url'])) {
$question_title = $_POST['question_title'];
$key = $_POST['key'];
$mark = $_POST['mark'];
$type = $_POST['type'];
$quesion_url = $_POST['question_url'];
$quesion_id = $_POST['question_id'];
insert_question($question_id, $question_title, $key, $mark, $type, $question_url);
}
if (isset($_GET['delid'])) {
delete_question($_GET['delid']);
}
?>
<script type="text/javascript">
function del(){
var mymessage=confirm("确认删除吗？");
if(confirm(mymessage)==true){
return true;
}else{
return false;
}
}
</script>
<br>
<br>
public function process_actions()
{
global $CFG, $DB;
/// Now, check for commands on this page and modify variables as necessary
if (optional_param('move', false, PARAM_BOOL) and confirm_sesskey()) {
// Move selected questions to new category
$category = required_param('category', PARAM_SEQUENCE);
list($tocategoryid, $contextid) = explode(',', $category);
if (!($tocategory = $DB->get_record('question_categories', array('id' => $tocategoryid, 'contextid' => $contextid)))) {
print_error('cannotfindcate', 'question');
}
$tocontext = get_context_instance_by_id($contextid);
require_capability('moodle/question:add', $tocontext);
$rawdata = (array) data_submitted();
$questionids = array();
foreach ($rawdata as $key => $value) {
// Parse input for question ids
if (preg_match('!^q([0-9]+)$!', $key, $matches)) {
$key = $matches[1];
$questionids[] = $key;
}
}
if ($questionids) {
list($usql, $params) = $DB->get_in_or_equal($questionids);
$sql = "";
$questions = $DB->get_records_sql("\n SELECT q.*, c.contextid\n FROM {question} q\n JOIN {question_categories} c ON c.id = q.category\n WHERE q.id {$usql}", $params);
foreach ($questions as $question) {
question_require_capability_on($question, 'move');
}
question_move_questions_to_category($questionids, $tocategory->id);
redirect($this->baseurl->out(false, array('category' => "{$tocategoryid},{$contextid}")));
}
}
if (optional_param('deleteselected', false, PARAM_BOOL)) {
// delete selected questions from the category
if ($confirm = optional_param('confirm', '', PARAM_ALPHANUM) and confirm_sesskey()) {
// teacher has already confirmed the action
$deleteselected = required_param('deleteselected', PARAM_RAW);
if ($confirm == md5($deleteselected)) {
if ($questionlist = explode(',', $deleteselected)) {
// for each question either hide it if it is in use or delete it
foreach ($questionlist as $questionid) {
$questionid = (int) $questionid;
question_require_capability_on($questionid, 'edit');
if ($DB->record_exists('quiz_question_instances', array('question' => $questionid))) {
$DB->set_field('question', 'hidden', 1, array('id' => $questionid));
} else {
delete_question($questionid);
}
}
}
redirect($this->baseurl);
} else {
print_error('invalidconfirm', 'question');
}
}
}
// Unhide a question
if ($unhide = optional_param('unhide', '', PARAM_INT) and confirm_sesskey()) {
question_require_capability_on($unhide, 'edit');
$DB->set_field('question', 'hidden', 0, array('id' => $unhide));
redirect($this->baseurl);
}
}
<?php
include "designtemplate.php";
include "database.php";
include "validation.php";
verify_authorization("admin");
connect();
?>
<?php
if (isset($_POST['deletequestions'])) {
foreach ($_POST as $key => $value) {
$arr = explode("_", $key);
if ($arr[0] == 'checkbox') {
delete_question($arr[1]);
}
}
}
?>
<html>
<head>
<title>
Question Bank
</title>
</head>
<body>
<?php
connect();
exit(get_particlesystem_by_id($request[1]));
}
if ($requestSize == 3) {
if ($request[2] == "") {
exit(get_particlesystem_by_id($request[1]));
}
}
handle_error();
default:
handle_error();
}
break;
case 'DELETE':
switch ($request[0]) {
case 'questions':
exit(delete_question($request[1]));
case 'particlesystems':
exit(delete_particlesystem($request[1]));
default:
handle_error();
}
break;
case 'POST':
switch ($request[0]) {
case 'particlesystems':
save_particle_system();
exit("");
case 'questions':
save_question();
exit("");
default:
