Updated Tool - EqItems Item Editor

[ChaosSlayer]

Originally Posted by mplayer254

GeorgeS, your tools are amazing, and this one in particular has been such a huge help. I have always wanted to be able to customize some things about EQ and your editors have been a godsend. The one thing I have not been able to do after watching these forums and using all the tools the community has come out with (Thank you Cavedude, your server pack is awesome) is being able to easily edit a book's text. I have looked all over the forums and wiki, and unless I am missing a thread somewhere this is all I have found:

http://www.eqemulator.net/forums/sho...highlight=book
Somewhat helpful, except that I am not familiar with SQL (which I am guessing is what he "went into" to make the book), so I have no idea how to do what the poster is describing.

http://www.eqemulator.net/forums/sho...highlight=book
Bit more helpful, was able to do what Dudeman did and edit an existing book but still not foolproof for someone like myself that doesn't know what he's doing.

Anyway, I also scanned the Wiki and found nothing more on how to actually create a custom book. My question for GeorgeS is, is there any possibility of adding the ability to modify book text to your item editor, or is there anyone out there that could write a short tutorial on how to do it? I am rebuilding my database to include some custom content and clean up a ton of quests, and plan on posting it once it is done and I learn hot to extract it. Anyway, sorry for the long winded post, and thank you all so much for the work you've done, it is incredible!

the book is an item. whats writen inside a book is stored in books.tbl table which corespand to the property of the field "book" in items table

so take any book in item editor and look at "book" field and you will see the short id name of the book text

then open mySQL browser. and simply open books table, find row with the same name and edit away like in notepad

[trevius]

This is getting off-topic for GeorgeS' Tools. But, here is the wiki page for the books table:

http://www.eqemulator.net/wiki/wikka...uDBSchemabooks

Try installing Navicat and looking at the table with it. It shouldn't be hard to figure out what to do by looking at the other examples. You will probably want to copy a book or 2 into Notepad so you can view them and/or edit them to create a new book's text.

[mplayer254]

Thanks all, I was able to get Navicat, find the Books Table and modify a few existing notes/books, but I was wondering if anyone has had this issue: when I create a new book in GeorgeS's item editor, I am unable to then find the shortname entered in the copy/edit screen for the new item in the Books table. If this is off topic, please feel free to move my post, I thought perhaps GeorgeS might have some insight on this so I posted it here. Chaosslayer and Trevius, thanks for the help!

[mplayer254]

Tried to just edit post but couldn't, I realized as soon as I went back into to Navicat that there was a big "+" button staring me in the face in the table view window Added the shortname field I wanted and am testing now on the server. Thanks for going easy on me after my first post!

[spider661]

i noticed in 292 they changed the aug slots in the item field name is this going to affect the editor im guessing it will are you planing on doing an update.. or is the source code up to date so i can make the change? also my npc editor has not worked for changing spawn timers seance they changed how spawns work is there going to be a fix soon? i have had to do all the changes in navicat and my other gms don't know how to do that lol

[GeorgeS]

I'm working on the changes.
Should'nt be more than a day or so to get it done


I'm trying to find the latest items.sql, can someone point me to the link please.


GeorgeS

[spider661]

sure
http://code.google.com/p/projecteqem...c=svn292&r=292