summaryrefslogtreecommitdiff
path: root/sqlbox
diff options
context:
space:
mode:
Diffstat (limited to 'sqlbox')
-rw-r--r--sqlbox/report.php9
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);