View Single Post
Old 07-20-2012, 04:25 PM   #1
pssquirrel
ebooknut
pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.
 
pssquirrel's Avatar
 
Posts: 205
Karma: 573170
Join Date: Oct 2011
Device: Sony T2 & T1 (previously PRS-350)
Removing "New" Badge from Unread Books

UPDATE: To go straight to the solution, see Post #10 below.

=================================================

I've been trying to figure out a way to batch-remove all the "new" badges that appear on newly-loaded books so that when I re-format my T1 and re-load my library (which I seem to end up doing regularly) I don't have to manually open/close a bazillion books. (PRS+ does this very nicely on my 350, and it's a feature I miss.)

Thanks to some very kind people here on MobileRead, I've just started delving into the books.db, and I'm taking a guess that the "new" badge appears when reading_time is null???

I was thinking of overwriting the null fields with a number, but since I don't really know what I'm doing, I thought I'd run it by those of you who understand these things to make sure I'm not attempting anything stupid. So here's what I'm wondering:

1. Do you think it reasonable that inputting a number in the null fields in the reading_time column will make the "new" badge disappear?

2. What number do you think I should try since the numbers don't seem to correspond to any obvious timestamp that I'm familiar with? Perhaps one digit higher than the number in modified_date?

Screenshots of the pertinent database columns attached.

What think?
Attached Thumbnails
Click image for larger version

Name:	screenshot.png
Views:	128
Size:	35.5 KB
ID:	89479  

Last edited by pssquirrel; 07-21-2012 at 05:09 PM. Reason: solution found
pssquirrel is offline   Reply With Quote