Skip to content
This repository has been archived by the owner on Jul 31, 2023. It is now read-only.

Change series details, sort order #4

Closed
rvolz opened this issue Aug 8, 2012 · 1 comment
Closed

Change series details, sort order #4

rvolz opened this issue Aug 8, 2012 · 1 comment
Assignees
Labels
Milestone

Comments

@rvolz
Copy link
Owner

rvolz commented Aug 8, 2012

Die Funktion "seriesDetails" gibt momentan (0.9.1) die Bücher einer Reihe in der Reihenfolge wieder, wie sie als ID in der Datenbank gespeichert sind. (bicbucstriim.php - Zeilen 521 bis 531).

In meiner Variante werden die Bücher anhand des Indexes der Serie sortiert, was ich bei Buchreihen durchaus für sinnvoll halte.

Returns a series and the related books function
seriesDetails($id) {
$series = $this->findOne('Series', 'select * from series where id='.$id);
if (is_null($series)) return NULL;
$books = $this->find('Book', 'select BSL.book, Books.* from books_series_link BSL, books Books where Books.id=BSL.book and series='.$id.' order by series_index'); return array('series' => $series, 'books' => $books); }

@ghost ghost assigned rvolz Aug 8, 2012
@rvolz
Copy link
Owner Author

rvolz commented Aug 8, 2012

Fixed in 0.9.2

@rvolz rvolz closed this as completed Aug 8, 2012
rvolz added a commit that referenced this issue Aug 8, 2012
jampot5000 pushed a commit to jampot5000/BicBucStriim that referenced this issue Jul 17, 2014
"error loading page" if searching for strings with ' in it:
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 near "brian": syntax error' in C:\Apache24\htdocs\bbs122\lib\BicBucStriim\calibre.php:292
Stack trace:
#0 ..\lib\BicBucStriim\calibre.php(292): PDO->query('select count(*)...')
#1 ..\lib\BicBucStriim\calibre.php(275): Calibre->count('select count(*)...')
#2 ..\lib\BicBucStriim\calibre.php(556): Calibre->findSliceFiltered('Book', 0, 30, Object(CalibreFilter), 'o'brian')
rvolz#3 ..\index.php(911): Calibre->titlesSlice('de', 0, 30, Object(CalibreFilter), 'o'brian')
rvolz#4 [internal function]: globalSearch()
rvolz#5 ..\vendor\slim\slim\Slim\Route.php(436): call_user_func_array('globalSearch', Array)
rvolz#6 ..\vendor\slim\slim\Slim\Slim.php(1307): Slim\Route->dispatch()
rvolz#7 ..\vendor\slim\slim\Slim\Middleware\Flash.php(85): Slim\Slim->call()
rvolz#8 ..\vendor\slim\slim\Slim\Middleware\MethodOverride.php(92): Slim\Middleware\Flash->call()
rvolz#9 ..\lib\BicBucStriim\calibre_config_middleware.php(50): Slim\Middleware\MethodOverride->call()
rvolz#10 ..\lib\BicBucStriim\login_middleware.php(33): CalibreConfigMiddleware->call()
rvolz#11 ..\lib\BicBucStriim\own_config_middleware.php(33): LoginMiddleware->call()
rvolz#12 ..\lib\BicBucStriim\caching_middleware.php(41): OwnConfigMiddleware->call()
rvolz#13 ..\vendor\slim\slim\Slim\Middleware\PrettyExceptions.php(67): CachingMiddleware->call()
rvolz#14 ..\vendor\slim\slim\Slim\Slim.php(1254): Slim\Middleware\PrettyExceptions->call()
rvolz#15 ..\index.php(196): Slim\Slim->run()
rvolz#16 {main}
JuergenBY referenced this issue Jan 29, 2015
MoonReader et al try to download resources first without proper
AUTH-Headers, only after a 401 response they try again with AUTH-info.

Added separate routes for OPDS that answer with 401.
@Binog Binog mentioned this issue Oct 18, 2016
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

1 participant