} else { $sql = "SELECT * FROM " . TABLE_PREFIX . "tests t" . " WHERE test_id=" . $matches[1]; $result = mysql_query($sql, $db) or die(mysql_error()); $row = mysql_fetch_assoc($result); add_test($matches[1], $row["title"]); } } else { if (preg_match('/^aa_(.*)$/', $_POST["id"], $matches) > 0) { if ($matches[1] == 0) { $sql = "SELECT * FROM " . TABLE_PREFIX . "assignments a" . " WHERE course_id=" . $_SESSION["course_id"] . " AND NOT EXISTS (SELECT 1" . " FROM " . TABLE_PREFIX . "gradebook_tests g" . " WHERE g.id = a.assignment_id" . " AND g.type='ATutor Assignment')"; $result = mysql_query($sql, $db) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) { add_assignment($row["assignment_id"]); } } else { add_assignment($matches[1]); } } } $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY'); header('Location: gradebook_tests.php'); exit; } else { if (isset($_POST['addExternalTest'])) { $missing_fields = array(); if ($_POST['title'] == '') { $missing_fields[] = _AT('title'); } if ($missing_fields) { $missing_fields = implode(', ', $missing_fields); $msg->addError(array('EMPTY_FIELDS', $missing_fields));
$navigation[] = $works_url; submit_grade_comments($_POST['assignment'], $_POST['submission'], $_POST['grade'], $_POST['comments'], $email_notify, null); } elseif (isset($_GET['add'])) { $pageName = $langNewAssign; $navigation[] = $works_url; new_assignment(); } elseif (isset($_POST['assign_type'])) { if ($_POST['assign_type']) { $data = Database::get()->queryArray("SELECT name,id FROM `group` WHERE course_id = ?d", $course_id); } else { $data = Database::get()->queryArray("SELECT user.id AS id, surname, givenname\n FROM user, course_user\n WHERE user.id = course_user.user_id\n AND course_user.course_id = ?d AND course_user.status = 5\n AND user.id", $course_id); } echo json_encode($data); exit; } elseif (isset($_POST['new_assign'])) { add_assignment(); } elseif (isset($_GET['as_id'])) { $as_id = intval($_GET['as_id']); $id = intval($_GET['id']); if (delete_user_assignment($as_id)) { Session::Messages($langDeleted, 'alert-success'); } else { Session::Messages($langDelError, 'alert-danger'); } redirect_to_home_page('modules/work/index.php?course=' . $course_code . '&id=' . $id); } elseif (isset($_POST['grades'])) { $navigation[] = $works_url; submit_grades(intval($_POST['grades_id']), $_POST['grades'], $email_notify); } elseif (isset($_REQUEST['id'])) { $id = intval($_REQUEST['id']); $work_title = q(Database::get()->querySingle("SELECT title FROM assignment WHERE id = ?d", $id)->title);