MDL-20601 fixed fatal SQL upgrade error, missing {} around table names
[moodle.git] / question / export.php
CommitLineData
aca318e1 1<?php // $Id$
2/**
4323d029 3 * Export quiz questions into the given category
4 *
5 * @author Martin Dougiamas, Howard Miller, and many others.
6 * {@link http://moodle.org}
7 * @license http://www.gnu.org/copyleft/gpl.html GNU Public License
8 * @package questionbank
9 * @subpackage importexport
10 */
aca318e1 11
12 require_once("../config.php");
271e6dec 13 require_once("editlib.php");
14 require_once("export_form.php");
aca318e1 15
271e6dec 16 list($thispageurl, $contexts, $cmid, $cm, $module, $pagevars) = question_edit_setup('export');
b72ff476 17
d187f660 18
f1abd39f 19 // get display strings
1b8b535d 20 $strexportquestions = get_string('exportquestions', 'quiz');
0c1e3a14 21
46d79818 22 // make sure we are using the user's most recent category choice
23 if (empty($categoryid)) {
24 $categoryid = $pagevars['cat'];
25 }
aca318e1 26
aca318e1 27 // ensure the files area exists for this course
271e6dec 28 make_upload_directory("$COURSE->id");
29 list($catid, $catcontext) = explode(',', $pagevars['cat']);
f34488b2 30 if (!$category = $DB->get_record("question_categories", array("id" => $catid, 'contextid' => $catcontext))) {
271e6dec 31 print_error('nocategory','quiz');
22afe6d6 32 }
33
f1abd39f 34 /// Header
5c0daafc 35 $PAGE->set_url($thispageurl->out());
d412354c 36 $PAGE->set_title($strexportquestions);
b72ff476 37 if ($cm!==null) {
271e6dec 38 $strupdatemodule = has_capability('moodle/course:manageactivities', $contexts->lowest())
1d58b567 39 ? $OUTPUT->update_module_button($cm->id, $cm->modname)
aca318e1 40 : "";
d412354c 41 $PAGE->navbar->add(get_string('modulenameplural', $cm->modname), new moodle_url($CFG->wwwroot.'/mod/'.$cm->modname.'/index.php', array('id'=>$COURSE->id)));
42 $PAGE->navbar->add(format_string($module->name), new moodle_url($CFG->wwwroot.'/mod/'.$cm->modname.'/view.php', array('id'=>$cm->id)));
43 $PAGE->navbar->add($strexportquestions);
44 $PAGE->set_button($strupdatemodule);
45 echo $OUTPUT->header();
aca318e1 46 $currenttab = 'edit';
47 $mode = 'export';
b72ff476 48 ${$cm->modname} = $module;
49 include($CFG->dirroot."/mod/$cm->modname/tabs.php");
aca318e1 50 } else {
b72ff476 51 // Print basic page layout.
d412354c 52 $PAGE->navbar->add($strexportquestions);
53 echo $OUTPUT->header();
567709c4 54 // print tabs
55 $currenttab = 'export';
56 include('tabs.php');
aca318e1 57 }
58
271e6dec 59 $exportfilename = default_export_filename($COURSE, $category);
60 $export_form = new question_export_form($thispageurl, array('contexts'=>$contexts->having_one_edit_tab_cap('export'), 'defaultcategory'=>$pagevars['cat'],
61 'defaultfilename'=>$exportfilename));
aca318e1 62
aca318e1 63
271e6dec 64 if ($from_form = $export_form->get_data()) { /// Filename
65
66
67 if (! is_readable("format/$from_form->format/format.php")) {
0be2c858 68 print_error('unknowformat', '', '', $from_form->format);
271e6dec 69 }
aca318e1 70
f1abd39f 71 // load parent class for import/export
271e6dec 72 require_once("format.php");
d187f660 73
f1abd39f 74 // and then the class for the selected format
271e6dec 75 require_once("format/$from_form->format/format.php");
aca318e1 76
271e6dec 77 $classname = "qformat_$from_form->format";
f5565b69 78 $qformat = new $classname();
271e6dec 79 $qformat->setContexts($contexts->having_one_edit_tab_cap('export'));
80 $qformat->setCategory($category);
81 $qformat->setCourse($COURSE);
aca318e1 82
271e6dec 83 if (empty($from_form->exportfilename)) {
84 $from_form->exportfilename = default_export_filename($COURSE, $category);
85 }
86 $qformat->setFilename($from_form->exportfilename);
1b8b535d 87 $canaccessbackupdata = has_capability('moodle/site:backup', $contexts->lowest());
88 $qformat->set_can_access_backupdata($canaccessbackupdata);
271e6dec 89 $qformat->setCattofile(!empty($from_form->cattofile));
90 $qformat->setContexttofile(!empty($from_form->contexttofile));
08892d5b 91
92 if (! $qformat->exportpreprocess()) { // Do anything before that we need to
bd8ee7c1 93 print_error('exporterror', 'question', $thispageurl->out());
aca318e1 94 }
95
08892d5b 96 if (! $qformat->exportprocess()) { // Process the export data
bd8ee7c1 97 print_error('exporterror', 'question', $thispageurl->out());
aca318e1 98 }
99
f5565b69 100 if (! $qformat->exportpostprocess()) { // In case anything needs to be done after
bd8ee7c1 101 print_error('exporterror', 'question', $thispageurl->out());
aca318e1 102 }
103 echo "<hr />";
104
105 // link to download the finished file
f5565b69 106 $file_ext = $qformat->export_file_extension();
1b8b535d 107 $filename = $from_form->exportfilename . $file_ext;
108 if ($canaccessbackupdata) {
109 $efile = get_file_url($qformat->question_get_export_dir() . '/' . $filename,
110 array('forcedownload' => 1));
111 echo '<p><div class="boxaligncenter"><a href="' . $efile . '">' .
112 get_string('download', 'quiz') . '</a></div></p>';
113 echo '<p><div class="boxaligncenter"><font size="-1">' .
114 get_string('downloadextra', 'quiz') . '</font></div></p>';
115 } else {
5a254a29 116 $efile = get_file_url($filename, null, 'questionfile');
1b8b535d 117 echo '<p><div class="boxaligncenter">' .
29305001 118 get_string('yourfileshoulddownload', 'question', $efile) . '</div></p>';
cf615522 119 $PAGE->requires->js_function_call('document.location.replace', array($efile))->after_delay(1);
aca318e1 120 }
aca318e1 121
fef8f84e 122 echo $OUTPUT->continue_button('edit.php?' . $thispageurl->get_query_string());
9b59580b 123 echo $OUTPUT->footer();
aca318e1 124 exit;
125 }
126
271e6dec 127 /// Display export form
1d58b567 128 $helpicon = new moodle_help_icon();
129 $helpicon->text = $strexportquestions;
130 $helpicon->page = 'export';
131 $helpicon->module = 'quiz';
132 echo $OUTPUT->heading_with_help($helpicon);
aca318e1 133
271e6dec 134 $export_form->display();
135
9b59580b 136 echo $OUTPUT->footer();
f1abd39f 137?>