summaryrefslogtreecommitdiff
path: root/lib/study/brresults.php
blob: 93ebfdf2475ff53df8bba3fc52a527ca0ad01c60 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<?php

assert_redir(count($args) == 3, 'study');
$batchid = intval($args[2]);

$info = mysql_fetch_assoc(sql(
	"SELECT list_study.id AS studyid, ".
	"batch_study.id AS bsid, batches.id AS batchid, batches.json_data AS json_data ".
	"FROM batches LEFT JOIN list_study ON list_study.list = batches.list AND list_study.user = " . $user['id'] . " " .
	"LEFT JOIN batch_study ON batch_study.batch = $batchid AND batch_study.user = " . $user['id'] . " " .
	"WHERE batches.id = $batchid"));
if (!($info)) {
	echo "This batch does not exist";
	die();
}
if (!($info['studyid'] != 0)) {
	echo "You are not studying this list.";
	die();
}

if ($info["bsid"] == 0) {
	sql("INSERT INTO batch_study(user, batch, last_review, notes_json) ".
		"VALUES(" . $user['id'] . ", $batchid, 0, '{}')");
	$info['bsid'] = mysql_insert_id();
	$info['notes'] = '{}';
}

if (isset($_POST['results']) && isset($_POST['score'])) {
	sql("UPDATE batch_study SET before_last_review = last_review WHERE id = " . $info['bsid']);
	sql("INSERT INTO batch_review(user, batch, results, score, date) ".
		"VALUES(" . $user['id'] . ", $batchid, '" . escs(esca($_POST['results'])) . "', " . intval($_POST['score']) . ", NOW())");
	sql("UPDATE batch_study SET last_review = " . mysql_insert_id() . " WHERE id = " . $info['bsid']);
	echo 'Saved';
} else if (isset($_POST['notes'])) {
	sql("UPDATE batch_study SET notes_json = '" . escs(esca($_POST['notes'])) . "' WHERE id = " . $info['bsid']);
	echo 'Saved';
} else {
	echo 'Error';
}

die();