Quote:
Originally Posted by davidfor
But, the real question is how the status is stored on the device. Is it in an accessible database?
|
Yes. It is an accessible SQLite DB.
Query is
Code:
select
title,
strftime('%Y-%m-%d', datetime(opentime, 'unixepoch')) AS FINISHED
from
books_impl
join
books_settings
on
id=bookid
where
completed = 1
order by 2 desc
Filename is <mountpoint>/system/explorer-3/explorer-3.db