NPC and loot editor - update2

**trevius** · #25 12-23-2008, 01:48 PM

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:

Code:

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.