MobileRead Forums - View Single Post

davidfor · 01-14-2014, 11:26 PM

And just to document this while it is fresh in my mind and get it all in one post.

The BtB information is in two tables:

"Stacks" holds the information displayed. There is one row for each piece of data. The information is a title and the descriptive text. There is also an id for an image. The image id is a GUID. If it is zero, there is no image. The images are stored on the device unde ".kobo/stacks".

"Keywords" is the link between the books and the Stacks. It has the BookId (contentId in table content) and and the Stack id. Plus an option chapter id. The other columns used are "Type" and "Keywords".

"Type" is how the Stack and the Keywords column is used and if the ChapterId is needed. I can see three types:

Authors - The Stack for this is a description of the author. The ChapterId is not used and as far as I can tell the Keywords column is not used. If there is an "Authors" row, when the BtB button is pressed, there is an "Author" button displayed.
BookKeywords - These appear to be for the whole book. The ChapterId is not used and but tell Keywords column has a value. But, as far as I can tell, this is not used. I think that the links displayed when the BtB popup is displayed come from these.
ChapterKeywords - These appear to be for a single chapter. The ChapterId has the internal path for the file that contains the chapter. The Keywords column contains a search string. The first match for the search string in the chapter is marked as a link to display the Stack information. The value looks like
Code:
```
[ "the White Rabbit" ]
```
. Changing that value changes what is selected in the chapter. The same Stack can be used for different words by adding rows with different values in the Keywords column. But, it appears the search term is a list. I changed one to
Code:
```
[ "Mr. Bingley", "the" ]
```
and the first occurrence of both terms was underlined.

The BtB info appears to be downloaded when a book is downloaded. If you mess around with it like I have, and want to revert to the good info, remove the book from the reader and then download it again.

There is also a stack tile. Pressing this will show the last BtB info that was viewed. If there is an image associated with the stack, that will be shown in the tile.

That's what I have learnt with a few hours of playing. Hopefully I haven't gotten anything to wrong. If anyone does find errors, please correct them. And if anyone does try to add BtB info, I'll be happy to help, but I can't say I am interested enough to start doing it myself.

01-14-2014, 11:26 PM	#14
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	And just to document this while it is fresh in my mind and get it all in one post. The BtB information is in two tables: "Stacks" holds the information displayed. There is one row for each piece of data. The information is a title and the descriptive text. There is also an id for an image. The image id is a GUID. If it is zero, there is no image. The images are stored on the device unde ".kobo/stacks". "Keywords" is the link between the books and the Stacks. It has the BookId (contentId in table content) and and the Stack id. Plus an option chapter id. The other columns used are "Type" and "Keywords". "Type" is how the Stack and the Keywords column is used and if the ChapterId is needed. I can see three types: Authors - The Stack for this is a description of the author. The ChapterId is not used and as far as I can tell the Keywords column is not used. If there is an "Authors" row, when the BtB button is pressed, there is an "Author" button displayed. BookKeywords - These appear to be for the whole book. The ChapterId is not used and but tell Keywords column has a value. But, as far as I can tell, this is not used. I think that the links displayed when the BtB popup is displayed come from these. ChapterKeywords - These appear to be for a single chapter. The ChapterId has the internal path for the file that contains the chapter. The Keywords column contains a search string. The first match for the search string in the chapter is marked as a link to display the Stack information. The value looks like Code: [ "the White Rabbit" ] . Changing that value changes what is selected in the chapter. The same Stack can be used for different words by adding rows with different values in the Keywords column. But, it appears the search term is a list. I changed one to Code: [ "Mr. Bingley", "the" ] and the first occurrence of both terms was underlined. The BtB info appears to be downloaded when a book is downloaded. If you mess around with it like I have, and want to revert to the good info, remove the book from the reader and then download it again. There is also a stack tile. Pressing this will show the last BtB info that was viewed. If there is an image associated with the stack, that will be shown in the tile. That's what I have learnt with a few hours of playing. Hopefully I haven't gotten anything to wrong. If anyone does find errors, please correct them. And if anyone does try to add BtB info, I'll be happy to help, but I can't say I am interested enough to start doing it myself.