View Single Post
Old 01-02-2019, 12:06 PM   #1
Karmylla
Member
Karmylla began at the beginning.
 
Karmylla's Avatar
 
Posts: 16
Karma: 10
Join Date: Jan 2019
Device: KOBO Aura H2O (v1)
Unhappy KoboReader.sqlite - Event - Reading Stats



Hey everyone,

Long time lurker, I've finally decided to make an account and join your ranks, and I'm glad I did!

I come to you with an issue I've seen others fall victim to: I logged off my device and all my reading stats and awards went back to zero.
I went and checked back all the books I had read, but the total amount of hours remained zero; since I'm someone who loves statistics and checking the numbers, this reset broke my heart.

And so started my journey in search for an answer!
I found, thanks to this forum, that I must edit the EVENT page in the KoboReader.sqlite file. So far, so good! The issue is that I don't know how or where to add those numbers that translate to hours!
No, that's a lie, I know I have to edit the ExtraData but I'm a little lost regarding the binary code; blobs kinda suck.
Also, to add the total amount of hours - or the hours of each book, rather - I should edit the ones who have the EventType 5, correct? Or maybe 46? (Or maybe both, idk guys, I'm lost, can you tell?)

If someone could give me some guidance, I would very much appreciate it!

Cheers, and Happy New Year!
Karmylla is offline   Reply With Quote