Added the bit list study system

1 files changed, 23 insertions, 0 deletions

diff --git a/lib/study/batchreview.php b/lib/study/batchreview.php
new file mode 100644
index 0000000..8639193
--- /dev/null
+++ b/lib/study/batchreview.php
@@ -0,0 +1,23 @@
+<?php
+
+assert_redir(count($args) == 3, 'study');
+$batchid = intval($args[2]);
+
+$info = mysql_fetch_assoc(sql(
+	"SELECT list_study.id AS studyid, batches.name AS bname, ".
+	"lists.name AS lname, account.login AS uname, ".
+	"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'] . " " .
+	"LEFT JOIN lists ON batches.list = lists.id ".
+	"LEFT JOIN account ON account.id = lists.owner ".
+	"WHERE batches.id = $batchid"));
+assert_error($info, "This batch does not exist.");
+assert_error($info['studyid'] != 0, "You are not studying this list.");
+
+if ($info["bsid"] == 0) {
+	sql("INSERT INTO batch_study(user, batch, last_review) VALUES(" . $user['id'] . ", $batchid, 0)");
+	$info['bsid'] = mysql_insert_id();
+}
+
+require("tpl/study/batch_review.php");