1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle 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, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
/**
* Prints a particular instance of sqlbox
*
* You can have a rather longer description of the file as well,
* if you like, and it can span multiple lines.
*
* @package mod
* @subpackage sqlbox
* @copyright 2012 Jan Klemkow, Benjamin Franzke
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
require_once(dirname(dirname(dirname(__FILE__))).'/config.php');
require_once(dirname(__FILE__).'/lib.php');
require_once(dirname(__FILE__).'/locallib.php');
require_once(dirname(__FILE__).'/sqlbox_form.php');
$id = optional_param('id', 0, PARAM_INT); // course_module ID, or
$n = optional_param('n', 0, PARAM_INT); // sqlbox instance ID - it should be named as the first character of the module
if ($id) {
$cm = get_coursemodule_from_id('sqlbox', $id, 0, false, MUST_EXIST);
$course = $DB->get_record('course', array('id' => $cm->course), '*', MUST_EXIST);
$sqlbox = $DB->get_record('sqlbox', array('id' => $cm->instance), '*', MUST_EXIST);
} elseif ($n) {
$sqlbox = $DB->get_record('sqlbox', array('id' => $n), '*', MUST_EXIST);
$course = $DB->get_record('course', array('id' => $sqlbox->course), '*', MUST_EXIST);
$cm = get_coursemodule_from_instance('sqlbox', $sqlbox->id, $course->id, false, MUST_EXIST);
} else {
print_error('invalidcourse');
}
require_login($course, true, $cm);
$context = get_context_instance(CONTEXT_MODULE, $cm->id);
add_to_log($course->id, 'sqlbox', 'view', "view.php?id={$cm->id}", $sqlbox->name, $cm->id);
$PAGE->set_url('/mod/sqlbox/view.php', array('id' => $cm->id));
$PAGE->set_title(format_string($sqlbox->name));
$PAGE->set_heading(format_string($course->fullname));
$PAGE->set_context($context);
// other things you may want to set - remove if not needed
//$PAGE->set_cacheable(false);
$PAGE->set_focuscontrol('id_sqlbox_query');
//$PAGE->add_body_class('sqlbox-'.$somevar);
echo $OUTPUT->header();
if (isguestuser()) {
echo $OUTPUT->confirm("Guest not allowed, Login?",
get_login_url(), new moodle_url('/course/view.php', array('id'=>$course->id)));
echo $OUTPUT->footer();
exit;
}
if ($sqlbox->intro) { // Conditions to show the intro can change to look for own settings or whatever
echo $OUTPUT->box(format_module_intro('sqlbox', $sqlbox, $cm->id), 'generalbox mod_introbox', 'sqlboxintro');
}
$form = new mod_sqlbox_form($PAGE->url->out(false));
$data = $form->get_data();
$current = $DB->get_record('sqlbox_solutions', array('sqlboxid' => $sqlbox->id, 'userid' => $USER->id));
if ($current)
$form->set_query($current->query);
$form->display();
$data = $form->get_data();
$correct = true;
if (isset($data->sqlbox_query)) {
echo $OUTPUT->heading('SQL Query: '.$data->sqlbox_query);
$con = sprintf("host=%s dbname=%s user=%s password=%s",
$CFG->sqlbox_hostname ? $CFG->sqlbox_hostname : "localhost",
$CFG->sqlbox_database ? $CFG->sqlbox_database : "sqlbox",
$CFG->sqlbox_user ? $CFG->sqlbox_user : "sqlbox",
$CFG->sqlbox_password ? $CFG->sqlbox_password : "sqlbox_pw" );
$db = pg_connect($con);
if (!$db)
print_error('dbconnectionfailed', 'sqlbox');
$table = db_table_from_query($db, $data->sqlbox_query);
if (strlen($sqlbox->query) > 0) {
$table_orig = db_table_from_query($db, $sqlbox->query);
if ($table->data != $table_orig->data ||
$table->head != $table_orig->head)
$correct = false;
}
pg_close($db);
echo html_writer::table($table);
sqlbox_submit_response($data->sqlbox_query, $sqlbox, $correct, $USER->id);
} else if ($current) {
$correct = $current->correct;
}
if (isset($data->sqlbox_query) || $current) {
if ($correct)
echo $OUTPUT->heading("Die Anfrage ist korrekt!");
else
echo $OUTPUT->heading("Die Ergebnismenge der Anfrage ist fehlerhaft!");
}
echo $OUTPUT->footer();
|
