Added possibility to add notes to studied batch items.

1 files changed, 5 insertions, 2 deletions

diff --git a/lib/study/batch.php b/lib/study/batch.php
index d8df526..60152f1 100644
--- a/lib/study/batch.php
+++ b/lib/study/batch.php
@@ -6,7 +6,8 @@ $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 ".
+	"batch_study.id AS bsid, batch_study.notes_json AS notes, ".
+	"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 ".
@@ -16,8 +17,10 @@ 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)");
+	sql("INSERT INTO batch_study(user, batch, last_review, notes_json) ".
+		"VALUES(" . $user['id'] . ", $batchid, 0, '{}')");
 	$info['bsid'] = mysql_insert_id();
+	$info['notes'] = '{}';
 }
 
 $reviews = array();