NPC and loot editor - update2

[trevius]

GeorgeS,

I think I found a minor bug with the Spawn Group editor part of this tool. When I load of an NPC ID and find all of the spawn groups associated with it, everything looks fine. When I try to edit the NPC ID for any NPCs in those spawn groups and save it, it will save the NPC ID to the last spawn group in the list that it found for that NPC ID. So, if I find 5 spawn groups, and need to update the 3rd one in the list, it won't work. It just keeps updating and saving it to the last one in that list. It actually seems to be saving all of the information for that spawn group to the last one in the list, so I get multiple spawns at the same point each time I try to do it.

Lemme know if you need more information on this.

[chrsschb]

Originally Posted by trevius

GeorgeS,

I think I found a minor bug with the Spawn Group editor part of this tool. When I load of an NPC ID and find all of the spawn groups associated with it, everything looks fine. When I try to edit the NPC ID for any NPCs in those spawn groups and save it, it will save the NPC ID to the last spawn group in the list that it found for that NPC ID. So, if I find 5 spawn groups, and need to update the 3rd one in the list, it won't work. It just keeps updating and saving it to the last one in that list. It actually seems to be saving all of the information for that spawn group to the last one in the list, so I get multiple spawns at the same point each time I try to do it.

Lemme know if you need more information on this.

I've encountered this too. I was walking through Emerald Jungle after I had edited the spawn groups for Forager and Hunter and noticed they were spawning 6-7 times each. I was like wtf?

[ChaosSlayerZ]

Originally Posted by trevius

GeorgeS,

I think I found a minor bug with the Spawn Group editor part of this tool. When I load of an NPC ID and find all of the spawn groups associated with it, everything looks fine. When I try to edit the NPC ID for any NPCs in those spawn groups and save it, it will save the NPC ID to the last spawn group in the list that it found for that NPC ID. So, if I find 5 spawn groups, and need to update the 3rd one in the list, it won't work. It just keeps updating and saving it to the last one in that list. It actually seems to be saving all of the information for that spawn group to the last one in the list, so I get multiple spawns at the same point each time I try to do it.

Lemme know if you need more information on this.

this sounds VERY similar to the error I had few revisions ago, but it seemed like George fixed it last time (if you scroll few post back you should see my report about this error)

[GeorgeS]

I think that problem was discovered and fixed some time ago. Let me know if it still persists. I did some checking in the latest release and it should be resolved.

GeorgeS

[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.