Thread: Choosing a screensaver cover
View Single Post
Old 06-03-2015, 09:11 AM   #3
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
If you have any relational database knowledge this isn't hard. And if you take a copy of the database before starting, you can put it back if you mess up.

The database is the file KoboReader.sqlite in the .kobo directory.

The table "content" contains the details of the books. The rows with "contentType=6" are the books. These are your books and the recommendations from Kobo. The "ContentID" is the key. For sideloaded books, this is the URI used to locate the file when the device is running. The MimeType is the type of book. As your are interested in using an images as a cover, then looking for "MimeType='application/x-cbz'" will find the images.

The values you want to change are in "ReadingStatus". Set this to 1. (0=Unread, 2=Finished). And the timestamp is in "DateLastRead". If you looked at the image using the device, this will be set and the change needed will be obvious.
davidfor is offline   Reply With Quote