L2J Server

Code: Select all

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

Code: Select all

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

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`));

Code: Select all

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