NPC and loot editor - update2

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