The tools are all great and the new changes to this one are exceptional!

One minor thing though; it appears we are no longer able to move columns around to arrange them as needed. You can still size the columns, but it is hard when you have a few certain things to adjust for an entire zone and have to scroll from left to right to see the name and then make the change. I liked the old way where I could just put AC, STR, HPs, Special Attacks, etc all right next to each other and just adjust the ones needing adjustment at that time. But, now it seems like the columns are all locked in place in the order they are already in.

Another simple idea might be an option to lock the ID and Name columns in place so they stay on screen when you scroll left to right. This would work similar to an excel spreadsheet and would make it easier to edit the fields in any part of the list without having to double and triple check to make sure you are editing the correct NPC.

I just added the newest version with moveable columns. Somehow they were locked before.

GeorgeS

Hello George!
The latest version looks very nice.
One little thing i noticed that could be usefull - in the ShowNpc Spell list - could you add sort by ID? could come handy

not teribly important, but whenever you will have next big update perhaps you would consider adding this.

thanks
=)

PS. one more thing - in TradeSkill editor- could get the same black back ground and golden letters as in NPC editor? white background realy hurts the eyes =)

Added ChaosSlayer's ShowNpc Spell list sort request and a few minor bug fixes.

GeorgeS

NPC and Loot Editor
08.20.07 - Added function to WIPE spawns from a zone. This deletes all spawns from SPAWN2,SPAWNENTRY,SPAWNGROUP, GRID, GRID_ENTRIES
It does NOT delete the actual NPCs from npc_types.

GeorgeS

George, I just noticed- there is a BIG problem with recent versions of npc editor - when you click COPY the window now asks you how many copies you want instead of- which ID you want to assign.

while new feature is usefull, the old one is EXTRIMLY valuable. could you please add it back?

thanks =)

No problem - select Field Utilities/Specify Starting NPCid range

select say 6000 to 6000 -- click on evaluate then click on Use this range

then copy 1 npc and it will use that #. Specify a range and then multiple copies start at 6000 +


GeorgeS

ah i see.. well this is great for copying multyple items into specific range but to copy a single item kind of too long (too many things to click) - how about adding a quick single copy button which will ask for specific # like you had before? prety please =) and put it next to the "copy" on the front panel =)

GeorgeS,

Since you made the grid editor part of the NPC Loot Editor now, I figured this is the best place to post about this issue. The problem I am seeing is that when you edit the WPs in a grid (the pause length for example in the WPs), and then save it, it doesn't actually save over the grid number you edited. Instead, it seems to overwrite the last added grid number with all of WPs from the one you were editing as well as the edited changes.

I have noticed problems with this in the past, but didn't figure out what was happening until tonight. I was always wondering why my grids were getting messed up when I was using the editor. The way it currently is, you can only edit the highest grid number for the zone. Everything else has to be redone manually from in-game.

I don't think that is intended, and I imagine it was probably just a mistake somewhere. I think getting that fixed would make the tool much more useful.

Other than that, I am still amazed at how nice your tools are now. They were great when I first started using them and they have only gotten better from that point. I can't believe how nice you have gotten them to this point. I think they are pretty complete as is. I can't thank you enough hehe. Without them, I would be lost!

If you need more information on the grid problem I am seeing, just let me know.

ah i suspected something like that. I could not figure out why the heck one of my patruling guards suddenly switched his walking path to be identical to one of the named mobs =)

This bug was verified on my system as well, and found the source of the probem in my code. Sorry for the bug!- I know it can cause big DB problems! It's at least fixed now and thanks for the bug report

08.20.08 - Fixed saving Grid bug. Now the correct grid will be updated and not the last one as before.

GeorgeS

thank you George =)

so what about one little quick copy button? :grin:

I just downloaded the latest npc_loot_editor and when I type in a zone, and tell it to search, I get the following error, running Vista 64-bit: "Run-time error '3265': Item cannot be found in the collection corresponding to the requested name or ordinal."

The older version worked great with vista, i'm not sure when this was broken, but the version that worked for me, was last modified 3/28/08 on my computer.

It's np if you don't want to fix this, I'll just use the old version. Just wanted to let you know.
Thanks.

'fraid I do not get this error on vista32. I did not change any zone code in recent history...

Can anyone verify this error?

GeorgeS

Oh, I'm dumb, the version that still works for me is: 07.33.00.

More on this,
If I try to search an empty zone, I don't get the error. But if I add 1 npc to that zone, that doesn't even have a faction or loot table assigned to him, I get the error if I try to search that zone again. I did this because the error said something about items, looking at it again I don't think it meant EQ items :). It doesn't even seem to try to load any of the npc's, it just instantly pops up that error.

I've been working on a custom server, just to mess around with and I'm having troubles changing the races on mobs. I tried to change to race of a mob in the nexus from human to gnome, saved the chages and #repop the zone but she stayed the human. I tried restarting the server but she still looks human. I did a #npcstats (or whatever it is) and the race number was the same as the gnome.

I was able to change the orcs in Crushbone to the new model, so I know it works sometimes. I know it's possible to change the race, since that is how it's set up on Storm Haven. What am I missing?

Wrong thread for this but sure...
Try using #npcedit race # with the npc targetted
Where # is the race #
Then repop and it will show.
#npcedit <type> <value> is used to directly modify the database.

K I'll try that... forgot to say I was using the NPC and Loot editor to change the races...

You may have to also zone out/in as well.

GeorgeS

OK, I was able to change the NPC's in the Nexus for some of the races like gnome, dwarf and troll, but I can't change to say the new orc model (458) . Is there still a global race file like in the Original EQ?

Getting the same error, on XP.

Post exactly the search criteria so I can reproduce this error

GeorgeS

Well I figured out my problem, sometimes it won't change the appearance of a mob unless you set the gender to "2" for monster!

It doesn't seem to matter what I search, I always get the error. For example, the default "NPC: orc" "Zone: Crushbone" gives me the error.

Yeah that is my problem too.

Regarding the error, I added error checking. Now you get the npc id of the problem NPC. A problem would be a null field, or a problem with a field on the npc id.

If an error still exists (i.e program crashes) then the error is occuring somewhere else in the code.

Dl the newest ODBC drivers from my site and give those a go.

GeorgeS

Okay I get the error on every single npc, after I finish clicking okay through all of them they seem to be loaded in.
I see a column called, Is_Bot, but I don't have this column in my database. Could this be what's causing it?

Ya, if you don't have all of the columns it is looking for, it will fail.

A small update to the npc&loot editor

NPC and Loot Editor
08.20.12 - Added 'Find all loot in ZONE' (with editable fields) under tools and many little enhancements everywhere.

GeorgeS

A pretty massive update is looming around the corner - just am spending a few days testing it before release..

Inlcuded are:

Slightly changed interface for quicker editing!
Merchant editor - now fully integrated with the NPC & Loot editor - finally!!!
Ability to view and edit loot on an zone wide basis!
Ability to change a NPC into a Merchant with real merchant ids on the fly!
Ability to Wipe a zone of all npcs!
Much enhanced Item search with a buffer and a special advanced search!
Ability to search for all npc's by Level!!
New control buttons made by Trevius!

New Loot assignment feature -
-- This allows one to import a list of items and assign them as loot to the npc's in the search criteria, It's NOT random loot, but assigned by an item list that you control. So, let's say you load in all 60-75lvl npc's which have not loot. You can now assign specified loot to them. Great for zones with npc's with no loottables! You control # item/npc and % drop.

Ability to FIX ALL bad merchants (i.e no merchant id's or merchants with class=41 and missing merchant links!!!)
Change NPC to FULL aggro to all
and more features I forgot..

Coming soon..
GeorgeS

Hopy cow man! That sounds awesome!

I was thinking of a minor addition the other day that might be good for the NPC loot editor. Basically, I think it would be nice to have a field to adjust how much faction each NPC gives. You can already set an NPC to a faction, but it would be good if you could set it to give -30 or +10 or something directly from the tool. It might even be nice to have a simple feature to create new factions. Though, creating factions in the database is already pretty easy. But, I think the most important thing is a setting in the tool to adjust how much faction you get from killing each NPC. It is just 1 less thing to have to use anything outside of the tool to adjust.

OK, it's done and released.
There's the possibility of frequent bug fixes and misc issues expected since there's so many changes.

Most of all you all can see Trevius' icon buttons added to the tool.

The other tools and windows will eventually have the buttons remade - if Trev gets the time.

Also, I will need to redo the help since the one with the tool is old.

GeorgeS

Got the latest version of the Tool Set downloaded, and I might be a little biased but I think the new look is great :D

Though, the button set I made was mainly for the Item Editor. I made a few of the buttons for the NPC Loot editor, but the majority were direct replacements for the Item Editor.

I can go ahead and make another set for all of the other tools as well. I see you made new backgrounds for most of them as well. They look really good. I would have done it for ya to save you the time. I just figured that since the Item Editor already had a theme, that the buttons would pretty much finish it off. So, I started with them first and the set I gave you was mainly to complete that. Then, I was planning to start on the set for the other tools if you liked how the first ones turned out. You should have every button needed to completely finish off the look of the item editor and it's different windows. Though, I was thinking that I could still make another variation of radio on/off buttons. And I could also make some graphics to replace the down arrows for the drop down boxes if those can be replaced. The only thing left would be the little square button you have for opening the windows for setting the spells for casting, procing, worn, focus effects. I can make one of those as well if you want so that everything is replaced.

I can make more variations in button sizes and shapes too if you would like that. Just let me know if you have any certain ideas for them and I can make them happen pretty easily. If you want them in the same theme, I can do that easily as well. I think the new look makes the tools look a little more consistent, which is good.

Your work never ceases to amaze me. I know the community is thankful for them as well :D

Thanks, your'e welcome to make more. I think even try to make a background as well with a logo would be great.

I applied the button skins to other tools since they could use a standardised theme eventually.

GeorgeS

They look great so far :D I will try to get some more graphic stuff out for them soon too and you can decide if you like any of it or not. I am thinking of maybe doing some of the backgrounds in the same theme you have used. I don't want to cause you too much extra work to get this stuff implemented though. I can definitely get a logo started.

no not know if its been mentioned i have not looked but thought it would let you know incase you did not notice.

the new editor.

slots. does not set multy slots if you load and save an item it sets the slot to whatever is set (first slot from before you saved) and if you try and set multy slots it only sets one.. this is not just visual on screen it does the same in game..

i have to use old edit to set more then one slot.. but other then that great tool.

also a side note.. downloaded the tools suit.. the tradeskill editor crashes when you load all tradeskills.

Ahh the multiple slots issue...thanks for reminding me!

I'll put this on today's list.

The tradeskill's editor..not sure - I'll look at it.

GeorgeS

Any chance of adding in the columns for weapon animations on the npcs? Would be great to edit that from the editor instead of searching through the mysql database

Hey GeorgeS,

If you get time, I was messing around and found that there are 2 more fields that would be very nice to have in the NPC Loot Editor. I can't believe that I didn't know about these fields before now lol! It would have saved me some time. Basically, the 2 fields below work on the Titanium client to change the weapon model of the NPC for Primary and Secondary slots.

d_melee_texture1 = Primary Weapon Model
d_melee_texture2 = Secondary Weapon Model

I remember seeing these a while back and reading the wiki page for the database on them, but it said not to use them (at least not for 6.2 client). But, I just tested them and they seem to work perfectly.

To use the field, you just set it to the model number of the weapon you want them to be wielding. You don't need to add "IT" or anything with it, just the number itself. An example is 10404 to set it to Mithaniel Marr's Sword.

Got it. I'll start adding those in

GeorgeS