report: Rewrite to be able to query reports from a mysql moodle backend

1 files changed, 6 insertions, 3 deletions

diff --git a/sqlbox/report.php b/sqlbox/report.php
index 02dabef..7d9904c 100644
--- a/sqlbox/report.php
+++ b/sqlbox/report.php
@@ -34,8 +34,9 @@ echo '</div>';
 
 $sql = "SELECT
             u.id,
-            translate(to_char(s.correct, 'FM9'), '01', '☒☑'),
-            (u.firstname || ' ' || u.lastname),
+            s.correct,
+            u.firstname,
+            u.lastname,
             s.query
           FROM {user} u, {sqlbox_solutions} s
         WHERE
@@ -47,7 +48,9 @@ $table->head = array("Lösung", "Nutzer", "Anfrage");
 $table->align = array("center", "left", "left");
 if ($records) {
     foreach ($records as $record)
-        $table->data[] = array_slice((array)$record, 1);
+      $table->data[] = array($record->correct == 1 ? '☑' : '☒',
+                             $record->firstname." ".$record->lastname,
+                             $record->query);
 }
 echo html_writer::table($table);