diff options
| author | Andrew Dolgov <[email protected]> | 2017-02-28 19:13:00 +0300 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2017-02-28 19:13:00 +0300 |
| commit | 4eb861026b8aed148f411a307cf7c0a48d0d15f0 (patch) | |
| tree | 30f417d394de785ed5d40bb7cfdee679cfc68d89 /backend.php | |
| parent | c348dcdc5faca033272fb39d3cc36086a85a0704 (diff) | |
add book description tooltips using qtip2
Diffstat (limited to 'backend.php')
| -rw-r--r-- | backend.php | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend.php b/backend.php index fb0c9ec..7a4b63e 100644 --- a/backend.php +++ b/backend.php @@ -50,6 +50,7 @@ $db = new SQLite3(CALIBRE_DB, SQLITE3_OPEN_READONLY); $result = $db->query("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) |