get_record('course', array('id' => $cm->course), '*', MUST_EXIST); $sqlbox = $DB->get_record('sqlbox', array('id' => $cm->instance), '*', MUST_EXIST); } else { print_error('invalidcourse'); } require_login($course, true, $cm); $context = get_context_instance(CONTEXT_MODULE, $cm->id); require_capability('mod/sqlbox:readqueries', $context); add_to_log($course->id, 'sqlbox', 'report', "report.php?id={$cm->id}", $sqlbox->name, $cm->id); $PAGE->set_url('/mod/sqlbox/report.php', array('id' => $cm->id)); $PAGE->set_title(format_string($sqlbox->name)); $PAGE->set_heading(format_string($course->fullname)); $PAGE->set_context($context); echo $OUTPUT->header(); $sql = "SELECT u.id, translate(to_char(s.correct, 'FM9'), '01', '☒☑'), (u.firstname || ' ' || u.lastname), s.query FROM {user} u, {sqlbox_solutions} s WHERE u.id = s.userid and s.sqlboxid = :id"; $records = $DB->get_records_sql($sql, array('id' => $sqlbox->id)); $table = new html_table; $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); } echo html_writer::table($table); echo $OUTPUT->footer(); ?>