NPC and loot editor - update2

[ChaosSlayerZ]

Trev, these are the details from my troubles from back then. See if it matches yours. But after George fixed it back then, It all worked fine again.

George- BIG troubles

the spawn editor is screwed up

I have just made a tiny adjustment in npc respawn time and clicked SAVE
instead of saving adjustment for the spawn group i was editing is picked what seem to be a RANDOM spawn group from the same zone table and saved changes in there overwriting ALL entries in that group.

At first I could nto figure out what has happened when all spawns fro the group I was editing got DOUBLED spawns in game.
I went in, found duplicate group, deleted it.. and saved again

BOOM - another random spawn group has been overwriten with the values from spawn group I was editing - now half of my city guards are gone, and that group i was editing now has TRIPLE spawns in game.

[trevius]

Yeah, I thought I had seen this issue reported before and thought it was resolved. I recently updated my NPC Editor version not long ago, but for some reason it seems like I am running one from a few revisions ago, so I am sure the problem is on my end. It may be that I updated it for my test server and not for the production one. I will get it updated and tested. If I don't reply saying there is still a problem, it is safe to assume that there isn't a problem with the latest version. Sorry about the bad report.

[trevius]

Odd, before I was running 08.22.01 and it was working fine. I installed the latest version (08.22.09) and registered the ocx, and when I try to search the zone for NPCs (any zone), it crashes with the following error:

Run-time error '3265':
Item cannot be found in the collection corresponding to the requested name or ordinal.

I still have the 08.22.01 version installed and it still works fine, but the new one does not. I have the db.ini file setup the same as before as well.

[GeorgeS]

Hi trevius


..your're missing the 'version' field there

..from Zeice's post
http://www.eqemulator.net/forums/showthread.php?t=28536


Hmm, yep I'm missing version number in npc_types. Strange because I went back to sql 612_instance_changes and the only npc_types change is

ALTER TABLE `npc_types` ADD `adventure_template_id` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `npc_faction_id`;

So I guess I need to do something like

ALTER TABLE `npc_types` ADD `version` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `slow_mitigation`;

I couldn't find any other recent sql changes that added version. I may just be missing it though. I'll give the above a try and see if it works.


*edit* Yep that did the trick.

[trevius]

Ahh, I knew I had seen that discussed somewhere, but couldn't figure out which thread it was from. From everything I can find, the version field related to NPCs only goes into the Spawn2 table, not npc_types. Unless I am missing some SQL from somewhere. The one in npc_types is adventure_template_id. Did I miss an SQL update, cause I don't see one for it?

[Shendare]

Yeah, I see places in the Emu code looking for the version field in spawn2, but not in npc_types.

[Zeice]

Trevius, I couldn't find the update either. The sql that I put up above fixed my problem with the latest version though.