Question for other item db builders.
 

What tool do you guys use to create items or to edit them to fix bugs with them? Be it a new custom item or something collected, just wondering what everyone uses.

I really don't edit items. Mostly I just convert the item data from another format using VBScript. The item editor that comes with EQEmu works pretty well though.

Yeah any time I try to edit items to make changes like updating the correct item number or what have you, I use Kaiyodo's tool, but I noticed yesterday that the recommended number field isn't working, and it's missing a few fields as well like bardtype, bardvalue, focusid, and reqlevel...but hopefully those will be in for the next release of it. ;)

I've fixed the recommended level and focus spell fields thanks to Lurker, I'll update the CVS and put a new version on my site as soon as I get the code compiling again :)

Bardtype and Bardvalue I've never heard of, if you can give me the names of some items that have these set and what the values should be then I can put them in. Even better if you had the offsets for them in the Item struct :)

K.

I'll see if I can get ahold of some of the items. A lot of new pop items have song modifiers, like rings that work as wind instrument etc.

Edit: Found one! Troubadour's Mace...item #22891. Attaching an sql file that has its data. From what I can tell, this was a packet collected item.

I have looked in to the bardtype, bardvalue, focusID, and required level

Kaiyodo, focus ID is the last 2 bytes of the structure, it is labeled in the file I sent you. One note, a few things have different names than the official EQEmu item structure. I was working on cleaning it up some if you want a cleaner version.


As for the other 3:

Bardtype is the same as item skill
Bardvalue is the same as delay delay 21 = 2.1 modifier
Required Level is the same as the casting level Although I am not sure why it acts differently than when level applies to spells

Thanks Lurker, I was a bit puzzled by the bardy things :) I think my item editor is using a customized Hackersquest version of the struct at the moment (I forget, it was a long time ago), I wouldn't mind a look at your cleaned up version, mine is a bit messy.

I've uploaded a beta of the item editor with the focus effect and recommended level fixes to http://www.geocities.com/kaiyodouk/Beta/ . It's also got a few extra things like visual icon editing and support for batch deleting of items.

K.

Just downloaded it. It works great, thanks for the update! :)

I'm not too sure reqlevel is the same as casting level. I think it's a completely different field that displays the required level in the item window. While casting level is a hidden number that requires the person be that level for the effect to be used/proc to go off.

The field at 0x00ff labeled level is where I saw the only proper value on items with a required level. I didn't check into it more than that.


Kaiyodo, would it be possible to get an export all items to sql or DB option? And perhaps use the sql replace command instead of insert. :D