MobileRead Forums - View Single Post

j.p.s · 01-19-2019, 12:31 PM

The list view listing for the KUAL booklet drifts down the screen and eventually off the first page as other books are opened even if KUAL has been used in the meantime. That is, the access time for the booklet KUAL does not get updated, unlike the kindlet KUAL.

The good news is that updating p_lastAccess for the KUAL record in cc.db raises KUAL to the second entry of the list view listing with the Recent filter after another book is opened and closed. The bad news is that the sqlite3 on board the kindle can not update cc.db (See post #1862 in https://www.mobileread.com/forums/sh...03326&page=125 )

Proof that there is hope:

Code:

mkdir local
sshfs root@oasis:/var/local local
NOW=`ssh root@oasis date '+%s'`
sqlite3.26 local/cc.db "SELECT icu_load_collation('en_US.utf8', 'icu');  update Entries set p_lastAccess = $NOW where p_titles_0_nominal = 'KUAL';"
fusermount -u local

Open a book on the kindle, then close it. KUAL will be the second entry in list view.

So, with a kindle sqlite3 binary that speaks icu, it would be straightforward to make a KUAL extention that bumps KUAL's listing.

This has been implemented as a KUAL extension. See https://www.mobileread.com/forums/sh...63#post3803463

01-19-2019, 12:31 PM	#1
j.p.s Grand Sorcerer Posts: 5,326 Karma: 98809518 Join Date: Apr 2011 Device: pb360	KUAL "listing bump" proof of concept The list view listing for the KUAL booklet drifts down the screen and eventually off the first page as other books are opened even if KUAL has been used in the meantime. That is, the access time for the booklet KUAL does not get updated, unlike the kindlet KUAL. The good news is that updating p_lastAccess for the KUAL record in cc.db raises KUAL to the second entry of the list view listing with the Recent filter after another book is opened and closed. The bad news is that the sqlite3 on board the kindle can not update cc.db (See post #1862 in https://www.mobileread.com/forums/sh...03326&page=125 ) Proof that there is hope: Code: mkdir local sshfs root@oasis:/var/local local NOW=`ssh root@oasis date '+%s'` sqlite3.26 local/cc.db "SELECT icu_load_collation('en_US.utf8', 'icu'); update Entries set p_lastAccess = $NOW where p_titles_0_nominal = 'KUAL';" fusermount -u local Open a book on the kindle, then close it. KUAL will be the second entry in list view. So, with a kindle sqlite3 binary that speaks icu, it would be straightforward to make a KUAL extention that bumps KUAL's listing. This has been implemented as a KUAL extension. See https://www.mobileread.com/forums/sh...63#post3803463 Last edited by j.p.s; 01-27-2019 at 12:16 PM. Reason: Add URL to point to KUAL extension.