Hey jrw174,
thanks for your effort!
I've found out that page_stat_data doesn't necessarly get updated once book.last_open get's updated. So there's a change that the total pages get mixed up.
I hope you don't mind that I've created a github repository with your app. This makes changes easier to track:
https://github.com/ckilb/koreader-po...sync/tree/main
I've fixed the issue I've mentioned by adding the book ID to the query that reads out the total number of pages. Also, I've simplified the queries a bit:
https://github.com/ckilb/koreader-po...1a437059515821
One question: As the log file path got changed to /tmp, how to read the log file now? If the device is attached to my computer I can't access /tmp.