Код
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'111',1,1,600000 FROM `npc` WHERE `type` LIKE 'L2FestivalMonster';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'111',1,1,600000 FROM `npc` WHERE `type` LIKE 'L2Monster';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'111',1,1,600000 FROM `npc` WHERE `type` LIKE 'L2Chest';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'111',1,1,600000 FROM `npc` WHERE `type` LIKE 'L2FeedableBeast';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'111',1,1,600000 FROM `npc` WHERE `type` LIKE 'L2RiftInvader';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'111',1,1,600000 FROM `npc` WHERE `type` LIKE 'L2Boss';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'111',1,1,600000 FROM `npc` WHERE `type` LIKE 'L2RaidBoss';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'111',1,1,600000 FROM `npc` WHERE `type` LIKE 'L2MInion';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'222',1,1,700000 FROM `npc` WHERE `type` LIKE 'L2FestivalMonster';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'222',1,1,700000 FROM `npc` WHERE `type` LIKE 'L2Monster';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'222',1,1,700000 FROM `npc` WHERE `type` LIKE 'L2Chest';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'222',1,1,700000 FROM `npc` WHERE `type` LIKE 'L2FeedableBeast';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'222',1,1,700000 FROM `npc` WHERE `type` LIKE 'L2RiftInvader';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'222',1,1,700000 FROM `npc` WHERE `type` LIKE 'L2Boss';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'222',1,1,700000 FROM `npc` WHERE `type` LIKE 'L2RaidBoss';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'222',1,1,700000 FROM `npc` WHERE `type` LIKE 'L2MInion';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'333',1,1,990000 FROM `npc` WHERE `type` LIKE 'L2FestivalMonster';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'333',1,1,990000 FROM `npc` WHERE `type` LIKE 'L2Monster';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'333',1,1,990000 FROM `npc` WHERE `type` LIKE 'L2Chest';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'333',1,1,990000 FROM `npc` WHERE `type` LIKE 'L2FeedableBeast';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'333',1,1,990000 FROM `npc` WHERE `type` LIKE 'L2RiftInvader';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'333',1,1,990000 FROM `npc` WHERE `type` LIKE 'L2Boss';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'333',1,1,990000 FROM `npc` WHERE `type` LIKE 'L2RaidBoss';
INSERT INTO `droplist` (mobId,itemId,min,max,chance) SELECT `id`,'333',1,1,990000 FROM `npc` WHERE `type` LIKE 'L2MInion';
