View Single Post
Old 07-03-2013, 10:43 PM   #17
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
Posts: 13,583
Karma: 79436940
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
Quote:
Originally Posted by davidfor View Post
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.
Geez; it's at least 12 minutes since you posted... Where's the final version! You're slowing down....
PeterT is offline   Reply With Quote