Quote:
Originally Posted by j.p.s
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. |
Try the one NiLuJe packages with SS(??) - one of his catch-all packages.
If not, then I have a build linked to the entire Uncode data library - as in: everything.
If NiLuJe's does not do the trick, post in this thread and I will attach my build.
PS: There is another db there, with one entry, which holds the collation value setting to execute in sqlite3 to modify and delete of cc.db. (maybe: locale.db ??)