Need help with books table in DB

[Drawde]

Since I'm working on quests etc. at the minute I thought I'd try adding some book text to the DB, since many quests involve notes, books etc.
However I'm not entirely sure how the book table works.
The txtfile value presumably is the name of the file containing the text, e.g book1.txt. Where is this file located, in a books subdirectory, or in the EQEmu directory?
And the name value, presumably this is for assigning the text to an item, should it be the same as the item's lore text?

Any help from the developers or someone else who's tried adding book data would be appreciated!

[DeletedUser]

each book item has a "filename" value inside the item...

Like, the Tome of Order & Discord is "discord". Currently, there are no editors out that I know of which let you look at or edit these values.


in the table, you have 2 fields, name & txtfile. name would be discord for this book we are talking about, and txtfile would be the text in the book. Each type of book has a different built in format it appears, so you need to play around with it. Some books have ` (by the #1 key) as the newline seperator, others do not. It is an experement thing you have to do....

[Lurker_005]

The key name starts on the AF hex offset and ends at the next NULL (00)

Using mysql-front, you can find your item, and then view the blob in the hex tab to find the key name.

[Drawde]

Thanks for the help!
So the "txtfile" value actually contains the text, it's not a reference to a filename?
I'll try it out and see what happens, anyway.

[Lurker_005]

The txtfile field seems to only hold about 64 characters....

Am I missing something, or is this meant to be a link to actual text files?

Also I wanted to post this link http://www.eqcaster.com/ He has a compendium that list the actual contents of MANY books type objects!

[Drawde]

Tried it out and it works!
Now I just need to work out where to put the ` line breaks..
The txtfile value seems to be capable of holding more than 64 characters, as far as I can see.

[Lurker_005]

Ahh it was mysql-front limiting the field to 64 characters. Using rew sql queries I can get it to use longer text.

[Lurker_005]

It seems that it will wrap a long line of text on it's own. But for paragraphs and such, the ` will break the automatic line wraping. Also putting a charage return in the string causes some problems.

The below works as long as the lines aren't longer than the page width.

'sample text`
more sample text'

'sample text
more sample text'

[Esco]

I am soooooo wanting to do research.