From d6fdaffa76976f486dc228f89359254fa20f1676 Mon Sep 17 00:00:00 2001
From: Benjamin Franzke <benjaminfranzke@googlemail.com>
Date: Thu, 24 Jan 2013 15:25:53 +0100
Subject: Show already filed queries.

And if it was correct.
---
 sqlbox/view.php | 18 +++++++++++++-----
 1 file changed, 13 insertions(+), 5 deletions(-)

(limited to 'sqlbox/view.php')

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
-- 
cgit