diff options
| -rw-r--r-- | sqlbox/sqlbox_form.php | 5 | ||||
| -rw-r--r-- | sqlbox/view.php | 18 |
2 files changed, 18 insertions, 5 deletions
diff --git a/sqlbox/sqlbox_form.php b/sqlbox/sqlbox_form.php index 946fad4..5360b59 100644 --- a/sqlbox/sqlbox_form.php +++ b/sqlbox/sqlbox_form.php @@ -12,6 +12,11 @@ class mod_sqlbox_form extends moodleform { $mform->addElement('text', 'sqlbox_query', 'SQL Query', 'size="50"'); $mform->addElement('submit', 'sqlbox_button', 'Submit'); } + + public function set_query($query) { + $mform = &$this->_form; + $mform->setDefault("sqlbox_query", $query); + } } ?> diff --git a/sqlbox/view.php b/sqlbox/view.php index 7a151ce..f9b4ba1 100644 --- a/sqlbox/view.php +++ b/sqlbox/view.php @@ -76,6 +76,10 @@ if ($sqlbox->intro) { // Conditions to show the intro can change to look for own // Replace the following lines with you own code $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(); @@ -98,12 +102,16 @@ if (isset($data->sqlbox_query)) { echo html_writer::table($table); - if ($correct) - echo $OUTPUT->heading("Correct!"); - else - echo $OUTPUT->heading("Incorrect!"); - 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("Correct!"); + else + echo $OUTPUT->heading("Incorrect!"); } // Finish the page |