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') {