NPC and loot editor - update2

[ChaosSlayer]

Geroge, sudden of nothing I am getting "isbot now requred" error when trying to run NPC-loot editor
But my db has been updated a WHILE ago and allready has isbot, botinventory and botleader things.

Whats more important - I have allready this version before (of October 3rd)wihout any errors, so I am not sure where they coming from

I have donwloaded Oct 28 version and still geting same error

[trevius]

Did you run the register_ocx.bat again? You probably installed something else that broke your previous version's registration or something.

[GeorgeS]

Actually someone else had the same error. I think it's the query which checks for isbot field thay breaks the program on some computers. I have to dig further and find another way of running the query. Just give me a day to think it out..


/edit/

NPC and Loot Editor
08.21.13 - Changed the query that game players error that mentioned 'isbot' field is missing, despite having it in the table

Please download this version and see if it still gives that error.

GeorgeS

[moydock]

Hey George,
I downloaded the latest version and I'm still getting that error.
I updated my DB with the 2 tables and isbot column. All of your other editors that come with it work properly. Anyone else getting this?

[GeorgeS]

I'll remove the check - for some reason it does not work on all computers.
I think almost everyone uses bots now, so I'll use that as the default schema.

Look for an updated version later

*edit
Updated the program and it should no longer crash/give error there.

GeorgeS

[moydock]

Thanks, that worked. Great job on the additions btw. Going to try out the npc editor now!

[trevius]

GeorgeS,

One of the latest changes from KLS removed the timeleft field in the spawn2 table. This causes the spawn editor to break when it tries to load because it can't find that field anymore. KLS moved spawn timers to their own table now. Here is the required SQL for what she changed.

Required SQL:

DROP TABLE IF EXISTS `respawn_times`;
CREATE TABLE `respawn_times` (
  `id` int(11) NOT NULL default '0',
  `start` int(11) NOT NULL default '0',
  `duration` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `spawn2` DROP `timeleft`;

So, the tool needs to be updated to work with this new system. For anyone else seeing this problem, you should be able to add the timeleft field back to the spawn2 table for now until the tool is updated. That should at least let the tool work, but that field of the tool will be useless.

[derekj54]

yeah im having trouble with it, i click on a mob and go to create lootdrop and it says please select a mob, i go to create loottable and it crashes, i can edit mobs easily but the loot table part isnt working, i gotta do loot straight in the db for now /cry

[GeorgeS]

Thanks for the tip - I'll have a fix wed. asap

GeorgeS

[GeorgeS]

As promised,
NPC and Loot Editor
08.21.15 - Removed 'timeleft' field from spawn2 as required by the emu source. Errors are likely if you have not updated your database schema


Derekj54 - not sure about the error. No one else has this as a reported issue.
The loot code is same since several years ago.

Hope it fixes things.

GeorgeS

[derekj54]

its still doing it, i get a error: 94, invalid use of null. it happens when i try to create a table or if i use the repair loot tables option.

[GeorgeS]

Your error has to do with a null being in a table where it should not exist. You have to find this problem with a table editor. My program works fine.

GeorgeS

[GeorgeS]

Roambox editing is here!

Modified the spawngroup editor in the npc&loot program so that roambox data are visible and editable. If you have features you want in then let me know.


NPC and Loot Editor

08.21.18 - roamboxes supported


GeorgeS

[Randymarsh9]

I keep getting Run time error 9 subscript out of range. when I try to create an NPC

[GeorgeS]

Can you go thru exactly what type of npc and what class/race etc.. that gave that error?


-edit
I found the problem - some newer schemas use >64 fields in the npc_types table and the array would crash it.
Fixed in the newest version

Thanks
GeorgeS