diff options
-rw-r--r-- | backend.php | 8 | ||||
-rw-r--r-- | js/read.js | 4 | ||||
-rw-r--r-- | read.html | 18 | ||||
-rw-r--r-- | schema.sql | 16 |
4 files changed, 19 insertions, 27 deletions
diff --git a/backend.php b/backend.php index b6e840c..c353e5c 100644 --- a/backend.php +++ b/backend.php @@ -68,7 +68,7 @@ break; case "getpagination": - $bookid = db_escape_string($_REQUEST["id"]); + $bookid = (int) $_REQUEST["id"]; if ($bookid) { $result = db_query($link, "SELECT pagination FROM epube_pagination WHERE bookid = '$bookid' LIMIT 1"); @@ -83,7 +83,7 @@ break; case "storepagination": $payload = db_escape_string($_REQUEST["payload"]); - $bookid = db_escape_string($_REQUEST["id"]); + $bookid = (int) $_REQUEST["id"]; if ($bookid && $payload) { @@ -107,7 +107,7 @@ break; case "getlastread": - $bookid = db_escape_string($_REQUEST["id"]); + $bookid = (int) $_REQUEST["id"]; $lastread = -1; if ($bookid) { @@ -126,7 +126,7 @@ case "storelastread": $page = (int) $_REQUEST["page"]; - $bookid = db_escape_string($_REQUEST["id"]); + $bookid = (int) $_REQUEST["id"]; if ($page && $bookid) { @@ -92,9 +92,7 @@ function zoom(incr) { function clear_lastread() { if (confirm("Clear stored last read page?")) { - var bookId = book.generateBookKey(book.metadata.identifier); - - $.post("backend.php", { op: "storelastread", page: -1, id: bookId }, function(data) { + $.post("backend.php", { op: "storelastread", page: -1, id: $.urlParam("id") }, function(data) { $(".lastread_input").val(data); }); } @@ -185,9 +185,7 @@ $("select.font_family").val(font); - var bookId = book.generateBookKey(book.metadata.identifier); - - $.get("backend.php", { op: "getlastread", id: bookId }, function(data) { + $.get("backend.php", { op: "getlastread", id: $.urlParam("id") }, function(data) { $(".lastread_input").val(data.lastread); @@ -228,8 +226,7 @@ rendered.then(function() { console.log("book ready"); - var bookId = book.generateBookKey(book.metadata.identifier); - var url = "backend.php?op=getpagination&id=" + encodeURIComponent(bookId); + var url = "backend.php?op=getpagination&id=" + encodeURIComponent($.urlParam("id")); EPUBJS.core.request(url).then(function(storedPageList){ @@ -247,15 +244,14 @@ book.pageListReady.then(function(pageList) { console.log("page list ready"); - var bookId = book.generateBookKey(book.metadata.identifier); - if (!_pagination_cached) { console.log("storing pagination on server"); - $.post("backend.php", { op: "storepagination", id: bookId, payload: JSON.stringify(pageList) }); + $.post("backend.php", { op: "storepagination", id: $.urlParam("id"), + payload: JSON.stringify(pageList) }); } - $.get("backend.php", { op: "getlastread", id: bookId }, function(data) { + $.get("backend.php", { op: "getlastread", id: $.urlParam("id") }, function(data) { if (data.lastread) book.gotoPage(data.lastread); }); @@ -285,12 +281,10 @@ $(".loading").hide(); $("#cur_page").html(location.anchorPage); - var bookId = book.generateBookKey(book.metadata.identifier); - if (_store_position && new Date().getTime()/1000 - _last_position_sync > 60) { console.log("storing lastread"); - $.post("backend.php", { op: "storelastread", id: bookId, page: location.anchorPage }); + $.post("backend.php", { op: "storelastread", id: $.urlParam("id"), page: location.anchorPage }); _store_position = 0; _last_position_sync = new Date().getTime()/1000; } @@ -2,20 +2,20 @@ drop table if exists epube_settings; drop table if exists epube_pagination; drop table if exists epube_books; -create table epube_settings( - id serial not null primary key, - owner varchar(200) not null unique, - font_size integer not null, - font_family varchar(200) not null, - line_height integer not null); +--create table epube_settings( +-- id serial not null primary key, +-- owner varchar(200) not null unique, +-- font_size integer not null, +-- font_family varchar(200) not null, +-- line_height integer not null); create table epube_pagination( id serial not null primary key, - bookid varchar(200) not null, + bookid integer not null, pagination text not null); create table epube_books( id serial not null primary key, - bookid varchar(200) not null, + bookid integer not null, owner varchar(200) not null, lastread integer not null); |