Thread: Aura H2O Backup of reading stats
View Single Post
Old 02-16-2015, 05:58 PM   #6
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
EventType=5 rows are added when you finish a book. As there is one for each book you finish, if you haven't finished one since you lost the stats, there won't be one

But, its a good point about the reading time. It has to be in one of the other events. It might be 3 as that is start a book and from memory the ExtraData looks like a series of timestamps. But there is another pair of events that are open and close a book, they might have the times. Or it might be in a singleton event that has the cumulative details. I have a list of events that I know about at home, and I've posted it in the past, but can't find it. I don't remember one I would have thought held the total time.

As to the checksum, I don't know how to calculate it. I've never really looked into it as I don't even know which columns in the table the checksum is over.
davidfor is offline   Reply With Quote