EoC: NPC Editor (BETA)

[Akkadius]

This is something that I had wanted to get to because editing NPC's in a zone on mass scale is probably one of the most time consuming tasks there could be.

I spent a few hours putting this tool together and it is Georges-style inspired.

All I use for editing is Mysql CLI and the EoC, I encourage anyone to use it because it is super fast and convenient. Let me know if anyone has feedback or questions.

Features:

Extremely Responsive and fast for updates
Search by Zone and Version
Search additionally by NPC name
Mass edit a column based on NPC selection
Mass edit a column with a random value specified from minimum and maximum values
Instant saving
It's super


http://i.imgur.com/McwiF5y.png

[GeorgeS]

looking good!

GeorgeS

[Cassieze]

This is looking pretty good however I was wondering if at all these are possible:

Sort ascending/descending by column
Search based on other quantifiers than name (mainly race and level)


I feel like these would give the mass edit a lot more power

Less important:
resizing width capability
setting fields to hidden

Just some heuristics :)

Thanks

[Akkadius]

OK, it's been quite a while since I've updated this thread apparently.

I've made it one of my forefront tasks to get a fully-fledged NPC Editor suite in EoC. Pushed an update this morning, here's some screens. The only thing not working atm is the loot stuff at the top, plan to finish fleshing out those tonight if I don't fall asleep from staying up too late.

You can expect to see this get mature real fast though.

Implemented:

Table sorting
Mass field edit and propogation
NPC Deleting
NPC Full Page Editing


Changes live here: http://eoc.akkadius.com/EOC2/index.php?M=NPC2

You can expect to see:


Quick View Information and Loot at top
Copy NPC
Spell List Editor
Merchant Editor
Special Attacks Editor
Grid Editor
Field Based Filtering (Search)
When double clicking a cell in the grid view, it will create a temporary input for intelligent inputs such as if you were to click a race field, it would create a race dropdown of choices, or special attacks field would pop up an intelligent selector
More to come


http://i.imgur.com/GEZktho.png

http://i.imgur.com/8liurPs.png

[ghanja]

Simply Rocking. (now that I've found the scheme)

[Akkadius]

Akka, are there themes/styles to EoC, or can they be implemented if not? Perhaps I'm the minority, though, there's just too much white-space for my eyes. Those screenshots from 2013 with the grey background is easier to look at. Functionality wise, you've got this downright rocking, thank you.

Top right has a Dark Theme option. I use it when I'm developing and I have red eyes.

[utbbop]

Thanks so much for your work on this, Akka!

[epilz]

hell yes, this kicks ass

[ratmanAK]

Thank You for this awesome set of tools. I'd like to make a recommendation. If at all possible can we get the d_melee_textures 1 and 2 field added to the npc full page edit? A visual weapon selection like on your item editor would be great, but even just a basic input box would help. It's kind of a pain to have to close out the window to edit an npc's weapons.

[Akkadius]

Thank You for this awesome set of tools. I'd like to make a recommendation. If at all possible can we get the d_melee_textures 1 and 2 field added to the npc full page edit? A visual weapon selection like on your item editor would be great, but even just a basic input box would help. It's kind of a pain to have to close out the window to edit an npc's weapons.


Yes, I have some updates to push here soon that are quite nice to this editor. Stay tuned.

I had visual in the full page editor until someone decided to change the field names

[Akkadius]

These are not released, but should be able to push them today.

Special Attacks/Abilities Editor:

http://i.imgur.com/mdXrTT5.png

Smart grid editor:

When you hover over a cell normally, it will create a simple input field. But when you double click a field, if there is an intelligent editor or select dropdown available, it will create it in the cell for easier understanding what what values mean for ease of editing


http://i.imgur.com/VGMeK23.png

[Akkadius]

The above changes are now live on EOC.

Enjoy :)

[Akkadius]

The NPC table data now automatically sizes itself to the browser resolution that you have. This is also updated.

[Akkadius]

Table grid visuals updated

http://i.imgur.com/28706Y3.png

[Akkadius]

Quick update, more to come.

Copy NPC functionality is in place.

http://i.imgur.com/f2CTWm0.png

Ability to do a non-zone-specific search:

http://i.imgur.com/86fQbLW.png

Single NPC Edit interface cleanup:

http://i.imgur.com/ZKnJ4Q9.png

[Akkadius]

http://i.imgur.com/V3GFW8a.png

[Akkadius]

http://i.imgur.com/ENYnPGO.png

[Akkadius]

If anyone has had a chance to use this recently, I welcome any feedback. I should be continuing work here on it this weekend...

[epilz]

Have used it multiple times over the past week. The mass field editor is very nice, and it cuts down a lot of time. Changed 4 custom zones in about 10 minutes, compared to spending time crawling the DB.

[Akkadius]

Have used it multiple times over the past week. The mass field editor is very nice, and it cuts down a lot of time. Changed 4 custom zones in about 10 minutes, compared to spending time crawling the DB.

That's awesome to hear

[atrayas]

Very nice, you're just making life easier and easier, keep it up.

[utbbop]

I use your tools daily.
This NPC Editor is awesome and does save much time!

[iluvseq]

I've started using this recently as well, it is quite nice.

One bit of feedback: I think it would make sense to move the 'maxlevel' column to be adjacent to the 'level' column in the grid view, so that it is easier to see the level range for an NPC. As it is now, the 'maxlevel' column is buried deep to the right...

[Akkadius]

I've started using this recently as well, it is quite nice.

One bit of feedback: I think it would make sense to move the 'maxlevel' column to be adjacent to the 'level' column in the grid view, so that it is easier to see the level range for an NPC. As it is now, the 'maxlevel' column is buried deep to the right...

That is the native order of the database table, so the tool will match that.

However, I do plan to add the ability to order fields and select which fields you want to see.

Thanks for posting

[Akkadius]

Didn't have too much time this weekend, was grinding House of Cards.

- Added lootdrop item adding.
- Added intuitive item search along with lootdrop item adding
- Added the ability to edit loot table details straight in the grid

Still needed (Loot):
- Add a lootdrop directly
- Delete lootdrop entry
- Delete lootdrop table

http://i.imgur.com/SuIalDF.png

http://i.imgur.com/3ygYx8X.png

[Akkadius]

Quick update, loot is 90% done. Keep in mind when I get done doing these I push them to EoC immediately. No reason to wait.

[NPC] Lootdrop item table, add ability to remove items:
[NPC] More adjustments to make the loot pane far less jumpy when
[NPC] Added ability to edit lootdrop table values
[NPC] Loot Table entry removals implemented a58eb53
[NPC] Display 'Real Chance' of an item dropping that takes in the
[NPC] Beginning of allowing Loot tables search/add
[NPC] Added ability to be able to see the actual drop rate for an item in consideration to its parent lootdrop record of probability

http://i.imgur.com/pMn78pP.png
http://i.imgur.com/TCA7Dx2.png

[utbbop]

So awesome.

Thanks Akka!!!!!!!!!!!!!!!!

[Akkadius]

Ok, finally done with loot, very thoroughly. Can get going with other features in the NPC Editor.

https://github.com/Akkadius/EQEmuEOC/compare/b3d8a0048063e980dec19c1fe84578af009351d1...master

[NPC] Loottable pane no highlights row entry when selected
[NPC] Initial point in which items can be added to lootdrops from a v…
[NPC] Adding items to lootdrop entries work from a popup item search …
[NPC] Fix lootdrop display pane by drawing it a half a second after i…
[NPC] Lootdrop item table, add ability to remove items: http://i.imgu…
[NPC] More adjustments to make the loot pane far less jumpy when diff…
[NPC] Added ability to edit lootdrop table values
[NPC] Loot Table entry removals implemented
[NPC] Display 'Real Chance' of an item dropping that takes in the fac…
[NPC] Beginning of allowing Loot tables search/add
[NPC] Made highlight row functionality much less costly. It would ite…
[NPC] Add 'X Item(s) in lootdrop total' message underneath lootdrop t…
[NPC] Add 'loot_table_search_lootdrop.js/php pair' for AJAX requests …
[NPC] Adding lootdrop entries into the loot table are now functional
[NPC] Can now add custom lootdrops and add existing

http://i.imgur.com/ZVbjgrH.png

[Kingly_Krab]

I really like these new changes, can't wait to see where it is in the next year. Good work, Akkadius!

[Akkadius]

I really like these new changes, can't wait to see where it is in the next year. Good work, Akkadius!

What are you implying? :-D

[Kingly_Krab]

Well, with the amount of work being done currently, I'm sure in a year's time it will be more of a diamond and less of the carbon that forms the diamond, haha.

[Akkadius]

Well, with the amount of work being done currently, I'm sure in a year's time it will be more of a diamond and less of the carbon that forms the diamond, haha.

Ahh I see.

Well its up and open for others to try and contribute. My goal is to make a decent chunk of mature tools.

Some more changes:

[NPC] Updated mass field editor so it at least lets you know it is trying to work your NPC list and will let you know when its finished instead of spamming hundreds of notifications.
[NPC] Update search box visuals
[NPC] Divide loot table and loot drop .js assets
- Fix issue where table headers in the loot table would try to highlight or load data for loot drop
- Created 'Make KOS' button on the right side of the NPC summary pane
- Adjusted visuals of NPC pane

http://i.imgur.com/In20Nqf.png

http://i.imgur.com/34oku1w.png

http://i.imgur.com/LnQUh8i.png

[rhyotte]

This is just absolutely Kick Ass!

Big thanks Akk...

[Akkadius]

This is just absolutely Kick Ass!

Big thanks Akk...

Thanks!

Don't need kiss ass but it is nice to get feedback and appreciation for effort that is put into this.

If anyone has any quality of life suggestions that I haven't answered already feel free to pose them.

[Akkadius]

[NPC] Implemented Min Coin/Max Coin updating and display in the npc pane
[NPC] Fix 'Real Chance' calculations
[NPC] Adjust some translators
[NPC] Add race select translator to grid

http://i.imgur.com/W4dhEyc.png

http://i.imgur.com/tE6qWUx.png

[Akkadius]

Spawn editing is a beast, but the basics are now in place.

Adding/Deleting and zone based spawn selection on the way.

http://i.imgur.com/krXLphW.png

[dagulus2]

Any chance you could add a feature to easily merge spawn groups?

So if a zone has 135 separate spawn groups that each have a 100% chance to same the same polar bear, it can easily cut it down to just the 1.

[Akkadius]

Any chance you could add a feature to easily merge spawn groups?

So if a zone has 135 separate spawn groups that each have a 100% chance to same the same polar bear, it can easily cut it down to just the 1.

Where's an example of this in PEQ's DB?

[dagulus2]

Most of the newer zones.

Check out the spawn groups containing a_black_wolf [408108] in the new commonlands as an example.