New Adventure Tool Request

[Zeice]

The NPC_Loot_editor. It crashes whenever I try to load a zone, or I try to copy a zone via the new adventure part.

[GeorgeS]

Ok, which DB version are you using?



You're also crashing when loading zone - you mean on main page, loading all npc's in a particular zone (using search button on main page)?


GeorgeS

[Zeice]

I'm using PEQ.....let's see version number is 384. Last time I updated it, but just been adding sql files from then on out.

yeah crashing zone on main page.

[GeorgeS]

ok, then it means you may be missing the 'version' field in npc_types
Add it in then it should work fine

Let me know if you cannot find the sql

GeorgeS

[Zeice]

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.

[Zeice]

BTW would it be possible to get version number added to the spawn editor at some point?

[GeorgeS]

NPC and Loot Editor
08.22.10 - Tool automatically checks for and add 'version' field to npc_types table if it's missing.


GeorgeS