From d45c7f14891d951f8a6987cc6492073b97e05b5b Mon Sep 17 00:00:00 2001
From: Nicolas BERNSTEIN <alexis211@gmail.com>
Date: Sun, 20 Nov 2011 13:39:47 +0100
Subject: Added the bit list study system

---
 lib/study/brresults.php | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 lib/study/brresults.php

(limited to 'lib/study/brresults.php')

diff --git a/lib/study/brresults.php b/lib/study/brresults.php
new file mode 100644
index 0000000..b3e1068
--- /dev/null
+++ b/lib/study/brresults.php
@@ -0,0 +1,35 @@
+<?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) VALUES(" . $user['id'] . ", $batchid, 0)");
+	$info['bsid'] = mysql_insert_id();
+}
+
+if (isset($_POST['results']) && isset($_POST['score'])) {
+	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 {
+	echo 'Error';
+}
+
+die();
-- 
cgit v1.2.3