diff options
| -rw-r--r-- | sqlbox/report.php | 9 |
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); |