about summary refs log tree commit diff stats
path: root/classes/Handler/GetinfoHandler.php
diff options
context:
space:
mode:
Diffstat (limited to 'classes/Handler/GetinfoHandler.php')
-rw-r--r--classes/Handler/GetinfoHandler.php36
1 files changed, 18 insertions, 18 deletions
diff --git a/classes/Handler/GetinfoHandler.php b/classes/Handler/GetinfoHandler.php
index 2235ef5..0c51cf5 100644
--- a/classes/Handler/GetinfoHandler.php
+++ b/classes/Handler/GetinfoHandler.php
@@ -12,27 +12,27 @@ use Sanitizer;
 
 class GetinfoHandler implements RequestHandlerInterface, AuthRequired
 {
-    public function handle(Request $request): Response
-    {
-        $id = (int) $request->getAttribute('id');
-        $caldb = new PDO('sqlite:' . Config::get(Config::CALIBRE_DB));
+	public function handle(Request $request): Response
+	{
+		$id = (int) $request->getAttribute('id');
+		$caldb = new PDO('sqlite:' . Config::get(Config::CALIBRE_DB));
 
-        $sth = $caldb->prepare("SELECT books.*, s.name AS series_name,
-            (SELECT text FROM comments WHERE book = books.id) AS comment,
-            (SELECT id FROM data WHERE book = books.id AND format = 'EPUB' LIMIT 1) AS epub_id FROM books
-            LEFT JOIN books_series_link AS bsl ON (bsl.book = books.id)
-            LEFT JOIN series AS s ON (bsl.series = s.id)
-            WHERE books.id = ?");
-        $sth->execute([$id]);
+		$sth = $caldb->prepare("SELECT books.*, s.name AS series_name,
+			(SELECT text FROM comments WHERE book = books.id) AS comment,
+			(SELECT id FROM data WHERE book = books.id AND format = 'EPUB' LIMIT 1) AS epub_id FROM books
+			LEFT JOIN books_series_link AS bsl ON (bsl.book = books.id)
+			LEFT JOIN series AS s ON (bsl.series = s.id)
+			WHERE books.id = ?");
+		$sth->execute([$id]);
 
-        if ($row = $sth->fetch()) {
+		if ($row = $sth->fetch()) {
 			$row['comment'] = Sanitizer::sanitize($row['comment'] ?? "");
 
-            return (new Response())->withBody(json_encode($row));
-        }
+			return (new Response())->withBody(json_encode($row));
+		}
 
-        return (new Response())
-            ->withStatus(404)
-            ->withBody("Not found.");
-    }
+		return (new Response())
+			->withStatus(404)
+			->withBody("Not found.");
+	}
 }