} 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);
