function display_scores($dbh)
{
# Get event ID number, which must look like an integer
$event_id = script_param("event_id");
if (!ctype_digit($event_id)) {
die("Bad event ID\n");
}
# Select scores for the given event
$stmt = "\n SELECT\n student.student_id, student.name, grade_event.date,\n score.score AS score, grade_event.category\n FROM student\n INNER JOIN grade_event\n LEFT JOIN score ON student.student_id = score.student_id\n AND grade_event.event_id = score.event_id\n WHERE grade_event.event_id = ?\n ORDER BY student.name";
$sth = $dbh->prepare($stmt);
$sth->execute(array($event_id));
# fetch the rows into an array so we know how many there are
$rows = $sth->fetchAll();
if (count($rows) == 0) {
die("No information was found for the selected event\n");
}
printf("<form method=\"post\" action=\"%s?action=%d&event_id=%d\">\n", script_name(), ENTER_SCORES, $event_id);
# print scores as an HTML table
for ($row_num = 0; $row_num < count($rows); $row_num++) {
$row = $rows[$row_num];
# Print event info and table heading preceding the first row
if ($row_num == 0) {
printf("Event ID: %d, Event date: %s, Event category: %s\n", $event_id, $row["date"], $row["category"]);
print "<br /><br />\n";
print "<table border=\"1\">\n";
print "<tr>\n";
display_cell("th", "Name");
display_cell("th", "Score");
print "</tr>\n";
}
print "<tr>\n";
display_cell("td", $row["name"]);
$col_val = sprintf("<input type=\"text\" name=\"score[%d]\"", $row["student_id"]);
$col_val .= sprintf(" value=\"%d\" size=\"5\" /><br />\n", $row["score"]);
display_cell("td", $col_val, FALSE);
print "</tr>\n";
}
print "</table>\n";
print "<br />\n";
print "<input type=\"submit\" name=\"submit\" value=\"Submit\" />\n";
print "</form>\n";
}
if (0 && empty($gHistory['DB'])) {
print start_page($gamenames[$_GET['game']] . ' Game Data Offline');
print 'The ' . $_GET['game'] . ' database is currently unavailable. Please check back shortly.';
print end_page();
return;
}
$gOutput = OutputFormat::getInstance($_GET['format']);
$gOutput->set_start_functions('start_page', 'end_page');
if (!empty($_GET['history'])) {
display_history();
} elseif (!empty($_GET['more'])) {
display_more_search($_GET['search']);
} elseif (!empty($_GET['search'])) {
display_search($_GET['search']);
} elseif (isset($_GET['formid']) || isset($_GET['ordid']) || isset($_GET['edid'])) {
display_cell($_GET['formid'], $_GET['edid'], $_GET['ordid']);
} elseif (isset($_GET['script']) || isset($_GET['sid'])) {
display_script($_GET['script'], $_GET['sid']);
} elseif (isset($_GET['stats'])) {
display_rectype_stats($_GET['rec']);
} elseif (isset($_GET['rec'])) {
display_rectype($_GET['rec']);
} else {
display_main();
}
function process_get()
{
global $gamenames;
$format = NULL;
if (isset($_GET['format'])) {
$format = strtolower($_GET['format']);
