Delete all monsters

[laikeriz]

L2J Revision 3410:
L2JDP Revision 6509:

Hello. How do i delete all monsters from spawnlist?I tried

Code: Select all

DLETE FROM spawnlist WHERE npc_templateid = (SELECT id FROM npc WHERE type='L2Monster')

but it gives me error. Is there another way?

[devo]

mb just use

General.properties

Code: Select all

# Don't load spawntable.# Default: FalseAltDevNoSpawns = [color=#BF0000]true[/color]

if you rly want to delete it from spawnlist table, just right click on it in navicat and "Empty Table"

or:

Code: Select all

DROP TABLE IF EXISTS `spawnlist`;CREATE TABLE `spawnlist` (  `id` int(11) NOT NULL auto_increment,  `location` varchar(40) NOT NULL default '',  `count` int(9) NOT NULL default '0',  `npc_templateid` int(9) NOT NULL default '0',  `locx` int(9) NOT NULL default '0',  `locy` int(9) NOT NULL default '0',  `locz` int(9) NOT NULL default '0',  `randomx` int(9) NOT NULL default '0',  `randomy` int(9) NOT NULL default '0',  `heading` int(9) NOT NULL default '0',  `respawn_delay` int(9) NOT NULL default '0',  `loc_id` int(9) NOT NULL default '0',  `periodOfDay` decimal(2,0) default '0',  PRIMARY KEY (`id`),  KEY `key_npc_templateid` (`npc_templateid`));

[janiii]

L2J Revision 3410:
L2JDP Revision 6509:

Hello. How do i delete all monsters from spawnlist?I tried

Code: Select all

DLETE FROM spawnlist WHERE npc_templateid = (SELECT id FROM npc WHERE type='L2Monster')

but it gives me error. Is there another way?

Code: Select all

DELETE FROM spawnlist WHERE npc_templateid IN (SELECT id FROM npc WHERE type = 'L2Monster');

[devo]

Ohhh silly me you wanted to delete monsters DD

[laikeriz]

Thank you janiii

[crnicholls]

LOL I saw this thread while looking for some other info on why raidbosses are so messed up im running server ver 3410 with Dp 6509 and yea you may want to delete all mobs and start over, something has messed with the raidbosses p atk m atk speeds and run speeds. Feel free to point me in to the right forum to post this because this is craaazzyy LOL. Someone was drunk me thinks j/k good thing im only running that pack as test server LOL