exit;
            } else {
                echo "<div>Delete Successful!</div>";
            }
            break;
    }
}
$a_fields = array('id', 'course', 'module', 'instance', 'section', 'idnumber', 'added', 'score', 'groupmode', 'groupingid');
// Query to show the bugged courses
if (!empty($module)) {
    $sql = 'select ' . implode(',', $a_fields) . ' from {course_modules} gc where gc.course=' . $_REQUEST['courseid'] . ' and gc.module=' . $module . ' and gc.instance NOT IN (select e.id from {' . $modulename . '} e where e.course=' . $_REQUEST['courseid'] . ')';
} else {
    $sql = 'select ' . implode(',', $a_fields) . ' from {course_modules} gc where gc.course=' . $_REQUEST['courseid'];
}
$records = $DB->get_records_sql($sql, null);
echo form_for_records($records, $a_fields, $optional);
echo '</body></html>';
function form_for_records($a_records, $a_headers, $optional)
{
    //    var_dump($a_records);
    $headers_row = '<tr>';
    foreach ($a_headers as $h) {
        $headers_row .= "<th>{$h}</th>";
    }
    $headers_row .= '</tr>';
    $body = '';
    foreach ($a_records as $a_rec) {
        $body .= '<tr>';
        $body .= "<td><a href='course_modules_edit.php?id={$a_rec->id}'>edit</a><br/><input name='id' value='" . $a_rec->id . "' type='radio' />" . $a_rec->id . "</td>";
        foreach ($a_rec as $name => $rec) {
            if ($name == 'id') {
            $record->idnumber = $_POST['idnumber'];
            $record->gradetype = $_POST['gradetype'];
            $record->aggregationcoef = $_POST['aggregationcoef'];
            if (!$DB->update_record("grade_items", $record)) {
                echo "<div>Error - Failed to update records from the database.</div>";
                exit;
            } else {
                echo "<div>Update Successful!</div>";
            }
            break;
    }
}
// Query to show the bugged courses
$sql = 'select ' . implode(',', $a_fields) . ' from {grade_items} gi where id=' . $_REQUEST['id'];
$record = $DB->get_record_sql($sql, null);
echo form_for_records(array($record), $a_fields);
echo '</body></html>';
function form_for_records($a_records, $a_headers)
{
    //    var_dump($a_records);
    $headers_row = '<tr>';
    foreach ($a_headers as $h) {
        $headers_row .= "<th>{$h}</th>";
    }
    $headers_row .= '</tr>';
    $body = '';
    foreach ($a_records as $a_rec) {
        $body .= '<tr>';
        $body .= "<td><input name='id' value='" . $a_rec->id . "' type='hidden' />" . $a_rec->id . "</td>";
        foreach ($a_rec as $name => $rec) {
            if ($name == 'id') {
        case 'delete':
            $where = "id=" . $_POST['id'];
            if (!$DB->delete_records_select("grade_categories", $where)) {
                echo "<div>Error - Failed to delete records from the database.</div>";
                exit;
            } else {
                echo "<div>Delete Successful!</div>";
            }
            break;
    }
}
$a_fields = array('id', 'courseid', 'parent', 'depth', 'path', 'fullname', 'aggregation', 'aggregateonlygraded', 'aggregateoutcomes', 'aggregatesubcats');
// Query to show the bugged courses
$sql = 'select ' . implode(',', $a_fields) . ' from {grade_categories} gc where courseid=' . $_REQUEST['courseid'];
$records = $DB->get_records_sql($sql, null);
echo form_for_records($records, $a_fields);
echo '</body></html>';
function form_for_records($a_records, $a_headers)
{
    //    var_dump($a_records);
    $headers_row = '<tr>';
    foreach ($a_headers as $h) {
        $headers_row .= "<th>{$h}</th>";
    }
    $headers_row .= '</tr>';
    $body = '';
    foreach ($a_records as $a_rec) {
        $body .= '<tr>';
        $body .= "<td><a href='course_grade_categories_edit.php?id={$a_rec->id}'>edit</a><br/><input name='id' value='" . $a_rec->id . "' type='radio' />" . $a_rec->id . "</td>";
        foreach ($a_rec as $name => $rec) {
            if ($name == 'id') {