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.