NPC and loot editor - update2

[GeorgeS]

I'm almost ready to release the next big update for this tool. Now you have the ability to create and edit npc spell lists. Say for example, you make a new Orc and want a custom spell(s) for him. Then with this update, a new spell list is created and assigned to the orc. In game, he will deploy that spell(s).
Also, the spell id is translated to the text version in an adjacent column. If you type in 200, the program will translate it to minor heal.

I've created some pretty creative spell lists, such as orcs which lifetap and feign death etc.. pretty neat and will suprise those low lvl newbs!

Update will be done by wed nite.

functionality:
1. Copy and Paste any spells from any source spell list to any dest. spell list
2. Delete a spell list
3. Save current spell list
4. Maintains a spell reference list (for common spell lookups)

GeorgeS

[moydock]

You read my mind sometimes George . Really looking forward to this, thanks again.

[Aramid]

Originally Posted by GeorgeS

I'm almost ready to release the next big update for this tool. Now you have the ability to create and edit npc spell lists.

Fantastic!!!

This will be great for making Spell Lists for those who run the Bots...

Thanks George

[GeorgeS]

Ok, compiled and uploaded it. It's in the GeorgeS_EqEmu_Files.zip under My Database Editing Tool Suite.

I played with it tonight making all sort of crazy spell sets. Works like a charm. Changed th e orcs into necro's with pets!


GeorgeS

[GeorgeS]

Should have added this -

Create a new list with the new list button first.
remember if you want spells from any list (for your new list), select the source list and copy the spells (just select any cells) then in your custom list, click on a cell and hit paste. Pasting more spells than existing rows in your current list is ok. Save to DB is final when you are ready. No save until you click that. You can also modify any list just type in a spell id and the spell text will appear next to it. There's also a spell search tool.

Have fun

GeorgeS

[trevius]

Holy crap! Downloading it now! Thanks GeorgeS!

[moydock]

This tool is very useful! Thanks George. Been wanting something to edit npc spells for awhile. And looking forward to not having to deal with the 4 loot tables anymore

[moydock]

Found a bug when creating a new lootdrop table. No row is added in "lootdrop", it just adds the row in "lootdrop_entries". This makes the entry not work, until you go in manually and create the row in lootdrop.

[moydock]

Also, if you go to Tools>Create new loottable, on an npc that has no loottable, you get the
Run-time error '3021': Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

[GeorgeS]

You mean it crashes when there's a lootable=0?
I tried it and get no crash when I go tools/create new loottable_id
A new loottable gets added to where the 0 was.
I will check on the code ...

When I tried tools/create new lootdrop_id, a new id gets added with a rusty dagger as a loot item.

What works for you - is clicking on lootdrop_id - then seeing it added as a lootdrop (left panel) and an associated item in the right side panel?
But nothing happens with tools/create new loottable_id? - except a lootdrop_entries is created? weird.

I'm guessing it may be a integer vs. long variable declaration. I'm looking at it now..

GeorgeS



Can one else check this on their db?

[ChaosSlayer]

i think what he is referign to is following event:

do add loot table
the program ALWAYS add loottable #3 and item 7001
BUT if you type in NEW loot tabel id which does nto yet have any items in it - the editor will nto auto aa a generic item (7001) , and if you try to save that( wihotu addign SOEMTHING to the item table first) the editor will crash.

this is mroe of a fool prove feature, since you normaly do want to save a loottable which has nothgin in it =)

i ocasinaly click SAVE before I add an item casing a crash but over hours and hours I spent in the editor I learned to add item first and then save =)

[moydock]

Originally Posted by GeorgeS

You mean it crashes when there's a lootable=0?
I tried it and get no crash when I go tools/create new loottable_id
A new loottable gets added to where the 0 was.
I will check on the code ...

When I tried tools/create new lootdrop_id, a new id gets added with a rusty dagger as a loot item.

What works for you - is clicking on lootdrop_id - then seeing it added as a lootdrop (left panel) and an associated item in the right side panel?
But nothing happens with tools/create new loottable_id? - except a lootdrop_entries is created? weird.

I'm guessing it may be a integer vs. long variable declaration. I'm looking at it now..

GeorgeS



Can one else check this on their db?

For the first problem, everything functions properly, except afterwards you have to go into your database and manually create a new entry in lootdrop, that corresponds to the new ID your tool created in lootdrop_entries.

For the 2nd problem, I select an npc that has a completely blank loot entry, as in not even coin, and I go to Tools-> Create New Loottable_id and I get that error and crash.
I'm running windows vista.

[ChaosSlayer]

Originally Posted by moydock

For the first problem, everything functions properly, except afterwards you have to go into your database and manually create a new entry in lootdrop, that corresponds to the new ID your tool created in lootdrop_entries.

ah rigth- you referign to a NAME of the loot table- yeah if that don't exist the tabel will nto work in game unless ist named/created.

For the 2nd problem, I select an npc that has a completely blank loot entry, as in not even coin, and I go to Tools-> Create New Loottable_id and I get that error and crash.
I'm running windows vista.

i don't get such eror - could be Vista thing =)

[GeorgeS]

Yes, the item #3 is just a place holder to type a known lootdrop_id in.

So I went and re-wrote much of the code to be more robust in loottable id generation and lootdrops. I hope it responds better than before.

Crash with empty loottable=0 - cannot reproduce, and do not have vista...
See if this version makes a difference..

GeorgeS

Originally Posted by ChaosSlayer

i think what he is referign to is following event:

do add loot table
the program ALWAYS add loottable #3 and item 7001
BUT if you type in NEW loot tabel id which does nto yet have any items in it - the editor will nto auto aa a generic item (7001) , and if you try to save that( wihotu addign SOEMTHING to the item table first) the editor will crash.

this is mroe of a fool prove feature, since you normaly do want to save a loottable which has nothgin in it =)

i ocasinaly click SAVE before I add an item casing a crash but over hours and hours I spent in the editor I learned to add item first and then save =)

[moydock]

Thanks George. Will do.