about summary refs log tree commit diff stats
path: root/backend.php
diff options
context:
space:
mode:
authorAndrew Dolgov <noreply@fakecake.org>2017-02-26 13:42:00 +0300
committerAndrew Dolgov <noreply@fakecake.org>2017-02-26 13:42:00 +0300
commit8aaf1fad0c1cfa65132f052f0f98b3452ddc4eeb (patch)
tree2b44d22cb37d126caca770eb63d6608b6efb8000 /backend.php
parent84230a6809d7ce8bd5d0161d1f91df4a4b7b32a0 (diff)
downloadthe-epube-8aaf1fad0c1cfa65132f052f0f98b3452ddc4eeb.tar.gz
the-epube-8aaf1fad0c1cfa65132f052f0f98b3452ddc4eeb.tar.xz
various offline-related fixes
Diffstat (limited to 'backend.php')
-rw-r--r--backend.php8
1 files changed, 5 insertions, 3 deletions
diff --git a/backend.php b/backend.php
index 308d2df..f603fbf 100644
--- a/backend.php
+++ b/backend.php
@@ -130,19 +130,21 @@
 		$bookid = (int) $_REQUEST["id"];
 		$lastread = 0;
 		$lastcfi = "";
+		$totalpages = 0;
 
 		if ($bookid) {
 
-			$result = $ldb->query("SELECT id, lastread, lastcfi FROM epube_books
-				WHERE bookid = '$bookid' AND owner = '$owner' LIMIT 1");
+			$result = $ldb->query("SELECT b.lastread, b.lastcfi, p.total_pages FROM epube_books AS b, epube_pagination AS p
+				WHERE b.bookid = p.bookid AND b.bookid = '$bookid' AND b.owner = '$owner' LIMIT 1");
 
 			if ($line = $result->fetchArray()) {
 				$lastread = (int) $line["lastread"];
 				$lastcfi = $line["lastcfi"];
+				$totalpages = (int) $line["total_pages"];
 			}
 		}
 
-		print json_encode(["page" => $lastread, "cfi" => $lastcfi]);
+		print json_encode(["page" => $lastread, "cfi" => $lastcfi, "total" => $totalpages]);
 
 		break;