View Single Post
Old 07-03-2013, 10:30 PM   #16
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
Quote:
Originally Posted by PeterT View Post
@GeoffR: I think my approach would be to move the images directory, make a new one, and then for each image found in the SQL database move the corresponding image back to the new images directory.
Not a bad way of doing it. The following query will get the image ids:

Code:
SELECT DISTINCT ImageId
FROM content
WHERE ContentType = 6
Then doing a "move ImageId*" to images directory would restore all the cover images for the books the device knows about. There are other images should also to be recovered. The images for the badges are in the directory as well.

I started on adding this to the utilities plugin yesterday. I thought of absurdly simple way of working out the extras files. I just need to finish writing the code to do prompting and the actual deletes.
davidfor is offline   Reply With Quote